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.
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.
Chennai
Tamil Nadu, India - 600054