
This Power BI project allowed me to work with a structured relational database consisting of Orders, Customers, Products, and Regions tables. Using SQL Server for data extraction and Power BI for modeling and visualization, I developed a clear understanding of business insights from raw data.
👨💻 What I Did:
- Cleaned and structured datasets using SQL queries.
- Built meaningful data relationships between tables in Power BI.
- Created calculated columns and DAX measures such as:
- Total Revenue
- Total Quantity
- Average Order Value
- Visualized key insights using:
- Bar Chart: Revenue by Product Category
- Line Chart: Revenue Trend by Month
- Pie Chart: Revenue Contribution by Region
- Table: Monthly Revenue Breakdown
🎯 What I Learned:
- How to use Power BI's data model and relationships effectively.
- Writing efficient DAX formulas for dynamic calculations.
- Designing clear and insightful data visualizations.
- Connecting SQL to Power BI for live, refreshable dashboards.
VIEW PROJECT IN DETAIL ⬇️
End-to-End Sales Analytics Dashboard - SQL + Power BI