About this project
A coffee company selling products in three different countries.
The company has three different coffee roast types for four different coffee types.
They sell their coffee in four different package dimensions.
Finally, the company has a loyalty program and some of the customers are members of the loyalty program.
Using the sales, product and customer data from three different excel tables, I created an interactive dashboard displaying visual information about the sales over time, sales by country and top 5 customers. I added filters for coffee roast type, package dimensions as well as customers' loyalty membership.
In order to join data from different tables, I used xlookup and index functions with matching.
Visuals are created using pivot tables and charts.
** Project idea and excel tips are from Mo Chen's youtube channel.
