This Business Intelligence Project is about medical products sales intelligence. We will be working on two fact tables and four dimensions using Python for data exploration, Microsoft Azure as a cloud provider to host our solution, and Microsoft Power BI as a reporting tool.

To exploit this project follow these steps:

1. Run pip install -r requirements.txt
2. Create a ressource group in Azure
3. Create the different cloud resources as shown in the report
   • Azure Blob Storage
   • Azure Data Factory
   • Azure SQL Database
4. Run create_data_warehouse.sql on Azure SQL Database you have created
   • Connect SSMS to the Azure SQL Database
   • Run the script
5. Import the ETL pipeline file to Azure Data Factory
6. Trigger the pipeline
7. Connect the Sales.pbix file to the data warehouse
   • Open the Sales.pbix file
   • Change source settings to your Azure SQL Database
8. Create a Microsoft Power BI Server workspace
9. Create the application from the workspace

This project is organized as follows:

Medical-Sales-Intelligence
│   .gitignore
│   LICENSE
│   README.md
│   requirements.txt
│
├───Data
│       Customers.xlsx
│       Products.xlsx
│       Sales Managers.xlsx
│       Sales Reps and Geographies.xlsx
│       Sales.xlsx
│       Targets.xlsx
│
├───Development
│   ├───Data Orchestration
│   │       ETL.zip
│   │       ETL_support_live.zip
│   │
│   ├───Data Warehousing
│   │       create_data_warehouse.sql
│   │
│   ├───Exploratory Data Analysis
│   │       Data understanding.ipynb
│   │       EDA Customers.ipynb
│   │       EDA Products.ipynb
│   │       EDA Sales.ipynb
│   │       EDA SalesManagers.ipynb
│   │       EDA SalesRepsandGeographies.ipynb
│   │       EDA Targets.ipynb
│   │       utils.py
│   │
│   └───Reporting
│           Sales.pbix
│           Sales.pdf
│
└───Report
        Presentation.pptx
        Project Report.pdf