Skip to content

Ketan-33/DWBI-Project

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

7 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

End-to-End DWBI Project

A comprehensive Data Warehousing & Business Intelligence (DWBI) project covering:

  • ER Diagram Design: Structuring data relationships
  • Star & Snowflake Schema: Optimized data warehouse design
  • Test Data Generation: Automating datasets using Python
  • Snowflake Setup & Data Loading: Configuring Snowflake and managing data ingestion
  • Scenario-Based SQL Queries: Executing complex queries for real-world cases
  • Report Blueprint & PowerBI Dashboards: Designing and visualizing data insights

Hands-on experience with Snowflake, SQL, Python, and PowerBI to build a complete DWBI solution.

Project Screenshots

ER Diagram

ER Diagram Design

PowerBI Dashboard

Sales Dashboard

About

A complete DWBI solution for a shipping agency covering ER diagram design, schema modeling, test data generation (Python), Snowflake setup, data loading, SQL queries, and interactive PowerBI dashboards.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors

Languages