Дипломная работа на тему "ТЮМГУ | Разработка цифрового решения для создания, назначения и аналитики заявок на закупку"

Работа на тему: Разработка цифрового решения для создания, назначения и аналитики заявок на закупку
Оценка: хорошо.
Оригинальность работы на момент публикации 50+% на антиплагиат.ру.
Ниже прилагаю все данные для покупки.
https://studentu24.ru/list/suppliers/Anastasiya1---1326

Описание работы

MINISTRY OF SCIENCE AND HIGHER EDUCATION OF RUSSIAN FEDERATION
Federal Autonomous Educational Institution of Higher Professional Education
«UNIVERSITY OF TYUMEN» SCHOOL OF ADVANCED STUDIES

RECOMMENDED DEFENSE 1N SEC FOR А

UNDERGRADUATE THESIS
DEVELOPMENT OF А DIGITAL SOLUTION FOR PURCHASE REQUESTS CREATION, ASSIGNMENT, AND ANALYTICS / РАЗРАБОТКА ЦИФРОВОГО РЕШЕНИЯ ДЛЯ СОЗДАНИЯ, НАЗНАЧЕНИЯ И АНАЛИТИКИ ЗАЯВОК НА ЗАКУПКУ

09.03.03 Applied Computer Science
Major « Information Technology and Systems Analysis»

Completed Ьу the student of year 4
Of the full-time type of enrollm nt
Supervisor
Candidate of Technical Sciences, Associate Professor of the School of Advanced Studie

Tyumen 2023

МИНИСТЕРСТВО НАУКИ И ВЫСШЕГО ОБРАЗОВАНИЯ РОССИЙСКОЙ ФЕДЕРАЦИИ
Федеральное государственное автономное образовательное учреждение высшего образования
«ТЮМЕНСКИЙ ГОСУДАРСТВЕННЫЙ УНИВЕРСИТЕТ» ШКОЛА ПЕРСПЕКТИВНЫХ ИССЛЕДОВАНИЙ (SAS)

РЕКОМЕНДОВАНО К ЗАЩИТЕ В ГЭК

ВЫПУСКНАЯ КВАЛИФИКАЦИОННАЯ РАБОТА
бакалаврская работа
DEVELOPMENT OF А DIGITAL SOLUTION FOR PURCHASE REQUESTS CREATION, ASSIGNMENT, AND ANALYTICS / РАЗРАБОТКА ЦИФРОВОГО РЕШЕНИЯ ДЛЯ СОЗДАНИЯ, НАЗНАЧЕНИЯ И АНАЛИТИКИ ЗАЯВОК НА ЗАКУПКУ

09.03.03 Прикладная информатика
Профиль «Информационные технологии и системный анализ»

Тюмень 2023

TABLE OF CONTENTS INTRODUCTION 4
CHAPTER 1. BUSINESS CASE 6
1.1 DESCRIPTION OF THE BUSINESS NEED 6
1.2 ANALYSIS OF THE CURRENT PROCESS AND ITS LIMITATIONS 9
1.3 BENEFITS OF THE PROPOSED SOLUTION OVER AS-IS PROCESS 11
CHAPTER 2. PROJECT ARCHITECTURE 13
2.1 TECHNICAL STACK 13
2.2 POWER PLATFORM OVERVIEW 16
CHAPTER 3. SOLUTION DESIGN 21
3.1 DESIGN OF THE SOLUTION’S USER INTERFACE AND USER EXPERIENCE 21
3.2 IMPLEMENTATION OF THE SOLUTION’S WORKFLOWS AND BUSINESS LOGIC 23
CHAPTER 4. SOLUTION DEVELOPMENT 24
4.1 DEVELOPMENT APPROACH, METHODOLOGY, AND TOOLS USED 24
4.2 SHAREPOINT ONLINE DEVELOPMENT 26
4.3 POWERAPPS WEB-APPLICATION 28
4.4 POWER BI DEVELOPMENT 30
CONCLUSION 32
LESSONS LEARNED 32
POSITIVE EXPERIENCES 32
NEGATIVE EXPERIENCES 33
POTENTIAL ROOM FOR FURTHER DEVELOPMENT OF THIS PROJECT 33
REFERNCES 36
APPENDICES 37
TECHNICAL SPECIFICATIONS AND ARCHITECTURE DIAGRAMS 37
IMAGES 37

INTRODUCTION
Purchase request management is a critical process that enables organizations to streamline purchasing activities and control procurement costs. With the increasing complexity of supply chains and global business operations, organizations are adopting digital technologies to automate and optimize their purchase request management processes. The Power Platform is a powerful suite of business applications and services from Microsoft that enables organizations to build and deploy custom solutions for various business processes, including purchase request management. In this article, we will provide an overview of the Power Platform solution for purchase request management, its key components, and benefits it provides.
The proposed solution for purchase request management is a customizable and scalable solution that enables the organization to automate and optimize its purchase request management processes. The solution is built on the Power Platform, which is a low-code/no-code platform for building custom business applications. The solution consists of the following key components.
In oilfield service companies like the client company Schlumberger, purchasing requests are a critical aspect of managing operations. However, traditional processes for managing purchase requests are often fragmented, leading to inefficiencies and delays. In this diploma project, we propose a Power Platform solution for creating, assigning, and analyzing purchase requests. The solution is designed to optimize the process of handling purchase requests by centralizing the workflow and automating key steps, resulting in faster and more accurate request handling.
The solution harnesses the power of Microsoft Power Apps, Power Automate, and Power BI to create a highly configurable and scalable platform that can adapt to the unique needs of client. It begins with the creation of a simple and user-friendly interface for submitting and managing purchase requests. Users can submit requests
by filling out a form that captures all relevant data, including the product or service required, the quantity, the preferred supplier, and delivery date.
The platform then automates the routing of the request to the appropriate approver, based on pre-defined workflows and business rules. Approvers receive notifications via email or in-app, with direct links to the request details. They can then review the request and approve or reject it, with the option to add comments or request additional information. The platform also includes a detailed audit trail of all activities related to the request, providing full transparency and accountability throughout the entire process.
Finally, the Power BI component of the solution provides powerful analytical tools for monitoring and optimizing the purchase request process. Users can access real-time dashboards and reports that track key metrics such as the average processing time per request, the number of requests pending approval, and the supplier performance. Insights from these reports can be used to identify bottlenecks in the workflow, improve communication with suppliers, and optimize purchasing decisions.
Overall, the Power Platform solution proposed in this project offers significant benefits to the client company in terms of process reflection, accuracy, and data visibility. By streamlining the creation, assignment, and analysis of purchase requests, the client company can ensure timely and effective procurement of essential goods and services, ultimately leading to improved productivity and profitability.

CHAPTER 1. BUSINESS CASE
1.1 DESCRIPTION OF THE BUSINESS NEED
The year 2022 will go down in history as a year of significant change in the oil and gas industry. In response to the events that took place, which led to international tensions, the United States and the European Union imposed sanctions on Russia. This decision affected several companies, including Schlumberger, an oilfield service company with heavy reliance on Russian suppliers for their equipment parts.1
The sanction-induced disruption posed a significant challenge to Schlumberger. The company needed to find alternative suppliers quickly to keep its business running. The Russian department of Schlumberger understood that this meant developing a digital solution that would allow them to identify new equipment supplier parts and manage purchase requests in a streamlined and efficient manner.
The problem was that Schlumberger urgently needed to find alternative suppliers to continue its operations effectively. Finding new suppliers was a difficult and time-consuming task that required extensive research, communication, and evaluation amongst alternative suppliers. Furthermore, Schlumberger was required to make its transition to alternative suppliers without disruptions to its operations or supply chain.
Without a streamlined procurement process to manage these tasks, Schlumberger was faced with significant disruptions and mounting operational costs. Additionally, the company was at risk of losing out in a highly competitive oil and gas industry to other organizations that could effectively manage their procurement processes.
The procurement team took on the task of identifying alternative suppliers that would provide the same quality of equipment parts at competitive prices. This
required extensive research and communication with several suppliers, which was a time-consuming process. Additionally, without a streamlined procurement process, the procurement team was at risk of being overwhelmed with manual tracking and data management requirements brought about by the new suppliers.

REFERNCES
1. Guilmette, A. Workflow Automation with Microsoft Power, 2nd edition. Birmingham: Packt Publishing, 2022. 302 p.
2. Hundhausen, R., Schwaber, K.,Professional Scrum Development with Azure DevOps. Microsoft Press. Hoboken: Pearson Education, 2021. 432 p.
3. Pearson, M., Knight, B., Knight, D., Quintana, M. Pro Microsoft power platform: solution building for the citizen developer. New York: Apress Media Llc, 2020. 420 p.
4. Russo, M., & Ferrari, A. The definitive guide to DAX: business intelligence with Microsoft Power BI, SQL server analysis services, and Excel. Hoboken: Pearson Education, 2020. 586 p.
5. Fortune. New York, 2014.