Excel-Project-CoffeeOrderData

An interactive excel dashboard created. I have created an excel dashboard using data about "Coffee Orders". Got the data from GitHub. The dataset was clean, only required minor updates. I have used formulas like NESTEDIF, XLOOKUP, INDEX, MATCH and Pivot tables for analysis purpose. The dashboard has timelines and slicers which are interconnected together via "Report connection" feature. This helps to reflect the information throughout the dashboard based on the selection in timelines/slicers. The dashboard contains 1 Timeline, 3 Slicers (Coffee Roast Type, Size, Loyalty Card). Based on these, Charts shows "Total Sales Over time", "Sales by Country" and "Top 5 Customers".