Data Mining and Analysis
Marko, Erlis (2018)
Marko, Erlis
Metropolia Ammattikorkeakoulu
2018
All rights reserved
Julkaisun pysyvä osoite on
https://urn.fi/URN:NBN:fi:amk-201805239745
https://urn.fi/URN:NBN:fi:amk-201805239745
Tiivistelmä
This work was made for Roche Oy. Roche Oy is one of the leading pharmaceutical and diagnostic companies in the world.
The purpose of this project was to create a database for sales department of the company, which will be used by the employees in the field enabling them to report in real time their expenses. The database should be easy and friendly for the users, to minimize the errors in the calculation of the monthly and annually budget for each employee. The project supervisors of each team will have the right to follow their employees´ expenses and approve these expenses every month. Every four months, the project leaders should be able to subtract from the database the necessary information needed to complete the report.
During the project different tools were used to adapt to the company’s environment. In the end the tools used for this project were Google Spreadsheet-Data Studio and Excel with Power BI.
The project is presented in a different way from what is used in the company. Some of the codes and the names of the products, employees are changed or not present. The end result was satisfactory, and the company started to use the platform built.
The purpose of this project was to create a database for sales department of the company, which will be used by the employees in the field enabling them to report in real time their expenses. The database should be easy and friendly for the users, to minimize the errors in the calculation of the monthly and annually budget for each employee. The project supervisors of each team will have the right to follow their employees´ expenses and approve these expenses every month. Every four months, the project leaders should be able to subtract from the database the necessary information needed to complete the report.
During the project different tools were used to adapt to the company’s environment. In the end the tools used for this project were Google Spreadsheet-Data Studio and Excel with Power BI.
The project is presented in a different way from what is used in the company. Some of the codes and the names of the products, employees are changed or not present. The end result was satisfactory, and the company started to use the platform built.