Verify data for any missing or wrong values
Made sure data is clean with respect to data type, data format and values used
Used KPIs for making a conditional formating to make sure to see how the business go
Created pivot tables according to the questions I asked based on what I see that need to improve in the data in order to frow the business
Use all the pivot tables into one dashboard and apply slicers to make it dynamic