📊 Excel Interactive Dashboard 📊

👩‍💻 Dashboard Link

Created dynamic and interactive Excel dashboard. The dashboard showcase the most important information and various KPI that can be formed using the cookie company data. The major excel tool used is pivot table and pivot charts.

Download the excel file

1. Data Sheet

   Data sheet include the data of the cookie company with the column heading as country, revenue, profit and many other parameter. For data i had applied filter only for the year 2020 year.

   1. Convert the data into table
   2. Insert pivot table

   

2. Profit By Country And Cookie Type

   Insert the pivot table where country as the row labels, cookie name as the column labels and profit as the values in the pivot field list. Then apply bar pivot chart.

   

3. Units Sold Each Month

   Insert the pivot table where month as the row labels and units sold as the values. Then apply line chart.

   

4. Product Wise Units Sold

   Insert the pivot table where Product as the row labels and units sold as the values. Then the donut chart.

   

5. Monthly Profit

   Insert the pivot table where Month as row labels and Profit as values. Then insert the line chart.

   

6. Slicer

   Select the chart and insert slicer from going to the pivot analyze. Connect slicer to all the pivot table.