This is a small project developed for the purpose of learning and training Pandas package applications for Data Analysis.
For this project there are three database sources originated from a service provider company:
- CadastroFuncionarios.csv
- CadastroClientes.csv
- BaseServiçosPrestados.xlsx
The first .csv file is a database containing the company's employees information such as name, salary and work area. The second .csv file contains information regarding each client's name and their monthly contract price. The .xlsx file includes the information related to the company's orders such as, which employee was responsible for each order, which client signed each contract, how many months the client has signed for.
This analysis has the objective of identifying six indicators:
- Total Payroll Value
- Company's Total Revenue
- The percentage of employees that have successfully signed a contract
- Total sales each area of the company has made
- Number of employees per company area
- Average Monthly Revenue
Note: this is a project developed for academic purposes, therefore the data contained in "CadastroFuncionarios.csv", "CadastroClientes.csv" and "BaseServiçosPrestados.xlsx" files are fictitious and used only to learn Pandas packages applications.