Project-on-power-bi-andExcel

Implement a Performance Dashboard for a Sales report

Objective

Based on certain questions analysis sales data in Excel and Summerize in Power BI

Task

1.Find out the answers of every question in excel

2.Use pivot table

3.Use Power BI to create Dashborad

4.Use Dax to create Date table,Running Total,Month over Month Change(MOM%)

Skills Learned

1.Analyze Sales data by Excel

2.Learn how to use pivot table

3.Learn how to design Dashborad in Power BI

4.Learn how to Utilize Dax in Sales Report to find valuable insights

Tools Used

1.Excel

2.Power Bi

Output

1.Some images from excel

image

image

  1. Some Images from Power BI

I.Dash borad

image

II.Running Total

image

III.MOM%

image