Extract, Transform and Load a sales dataset for business intelligence visualization

The following python libraries are needed to run the project

• pandas
• scipy
• sqlalchemy
• python-dotenv

Install them by using pip install pandas scipy sqlalchemy.

1. Clone the repo

git clone https://github.com/ashenafiDL/sales-ETL.git

2. Add git large files system support to your account (in order to support version control of files that are more than 100MB)

   • install git-lfs (sudo apt install git-lfs on ubuntu)
   • enable git lfs by running git lfs install

3. Create .env file and set it up as in .env.example file

4. Open Load and Transform jupyter notebook and run each cell one by one.

5. Visualizations are available at visualization-pdf and visualization.pbit files