Skip to content

Latest commit

 

History

History
28 lines (20 loc) · 930 Bytes

README.md

File metadata and controls

28 lines (20 loc) · 930 Bytes

Sales and Forecast Dashboard

Project Overview

An extract-transform-load (ETL) pipeline is built to collect the business data. These data are processed to generate insights and forecasts using exploratory data analysis (EDA) and predictive models. The results of the analyses are stored in a PostgreSQL database which connects to a Power BI dashboard.

Alt text

Using Airflow, the entire flow of data from the source up to the Postgres database is automated. The scripts are set to run monthly (every first day of the month at 6 AM).

Alt text

To Run

  1. Build the docker image:
docker-compose build
  1. Initialize Airflow:
docker-compose up airflow-init
  1. Run docker-compose:
docker-compose up
  1. Go to localhost:8080 in your browser, enter the credentials, and look for the sales_forecast_pipeline DAG.