Gravity Books Data Warehouse

Gravity Books Data Warehouse, an end-to-end solution showcasing my skills in data modeling, ETL, analytics, and visualization.

First:

Data Modeling:

We designed the data warehouse using a Snowflake Schema to optimize analytics. The business required many-to-many relationships, which we resolved by creating bridge tables:

Customer and Address: Solved using a Customer Address table to meet business needs.

Book and Author: Addressed with a Book Author table to ensure accurate relationships.

ETL Process:

We built and automated data pipelines using SSIS, ensuring efficient data integration and transformation.

Business Intelligence (BI):

We created an insightful Power BI dashboard with multiple pages, including:

Summary Page: Showcasing KPIs like total books, orders, customers, revenue, and net profit.

Publisher Insights: Metrics such as revenue and book counts by publisher.

Sales Analysis: Trends and performance across sales.

...and more pages offering detailed insights into the data!