Coca-Cola Sales Report Dashboard in Power BI

Hamidou Cherif
2 min readNov 3, 2023

Over View.

We make a Power BI dashboard from scratch on a made-up dataset for Coca-Cola. We analyze sales, profit margins, prices, regions and more. First, we start uploading the dataset from excel using power query. Then, we make the dashboard structure by adding headers and shapes. Third, we work on the following visuals:

1. The AI powered Q&A visual.

2. Key influencers visual in Power BI to analyze profit margins per brand.

3. Map chart to show sales by region.

4. Matrix to analyze financials such as price per unit and operating profit.

5. Dynamic time Slicer for users to change dates (Months)

Set up 1: Questions & Answers.

Set up 2: Key influencers.

Set Up 3: Map chart to show sales by region.

Set Up 4: Matrix to analyze financials such as price per unit and operating profit.

Set up 5: Dynamic time Slicer for users to change dates (Months)

Final Dashboard.

Thank You and feel free to comment below.

--

--

Hamidou Cherif

Financial Analyst/Data analyst/Business intelligent analyst