Yearly Sales Report using MS Excel.

Objective - To obtain City Sales report using multiple Excel Files 1 sheet Each,Which gets Everything Updated after we add files to Folder.

In order to achieve the result, we have performed

1. Data importing ( Multiple Excel files from folder).
2. Data Cleaning.
3. Dax measure to calculate Total Sales.
4. Data analysis using Pivot Table.
5. Mini Dashboard Report.