Improving sales analysis using Excel: A business solution
Li, Ziqin (2018)
Li, Ziqin
Laurea-ammattikorkeakoulu
2018
All rights reserved
Julkaisun pysyvä osoite on
https://urn.fi/URN:NBN:fi:amk-201802262802
https://urn.fi/URN:NBN:fi:amk-201802262802
Tiivistelmä
The thesis project was commissioned by a company that owns several shops selling different products, such as food, tool, and cloth. The purpose of this thesis is to get insights into the process in the information flow in the shops, for the target company to record and analyse complicated sales data using Excel in a more effective manner.
As the case company is tightly connected with different tour guides and travel agencies, sales data becomes rather complicated due to the varying data inserted into the commission system. Knowledge base required in the project includes business process, business process modelling, Excel spreadsheet. To better understand the background of the data flow, the project is planned and structured based on system analysis and design principles, involving planning, analysing, designing, implementing and maintenance phase. Interviews and questionnaires were used to assess the user experience and determine the points of improvements in the current tool.
The result of the project is an improved tool for the employees to use. The aim was to improve their work efficiency with an easier to use and learn solution. At the end of the project the company successfully implemented the provided solution.
As the case company is tightly connected with different tour guides and travel agencies, sales data becomes rather complicated due to the varying data inserted into the commission system. Knowledge base required in the project includes business process, business process modelling, Excel spreadsheet. To better understand the background of the data flow, the project is planned and structured based on system analysis and design principles, involving planning, analysing, designing, implementing and maintenance phase. Interviews and questionnaires were used to assess the user experience and determine the points of improvements in the current tool.
The result of the project is an improved tool for the employees to use. The aim was to improve their work efficiency with an easier to use and learn solution. At the end of the project the company successfully implemented the provided solution.