Sales Dashboard using Power BI & SQL

In this project I have analysed Pizza Sales data to get insights on business performance analysing on various KPI using Power BI and SQL.
1. Extracted data from SQL server to Power BI.
2. Performed Data cleaning with Power Query.
3. Using DAX created measures for all KPIs.
4. Built Report and Dashboard for below KPIs with PowerBI new card visual and compared with the results from SQL
5. Data Visualization - Including Dashboard prepartion using PowerBI.

Data Modelling in PowerBI

In this project I have created data model for real time tables with Fact and Dimension table.
1. Created relationship in Power BI. .
2. Identified Foreign and Primary keys, cardinalities.
3. Identified Foreign and Primary keys, cardinalities.
4. Developed star, snowflake and Galaxy schema.

Location

Chennai
Tamil Nadu, India - 600054

Phone

(+91) 9884824245

Email

manochitra.analyst@gmail.com

Social