Complete Supermarket Sales Dashboard

Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape

Learn how to build a professional and interactive Supermarket Sales Dashboard using Microsoft Excel. This course takes you step-by-step through data cleaning, analysis, and visualization to help you uncover key business insights. Whether you’re a beginner or looking to sharpen your data analytics skills, this course will equip you with practical knowledge to turn raw sales data into clear, actionable dashboards.

What Will You Learn?
  • Organizing and cleaning sales data
  • Using Excel formulas and functions for analysis
  • Creating PivotTables and PivotCharts
  • Building a dynamic and visually appealing dashboard
  • Interpreting sales trends and performance

Material Includes

  • Excel Workbook containing the dataset.
  • A letter from Management (dashboard requirements)

Requirements

  • No prior knowledge in Excel is required
  • A laptop or Phone and an internet connectivity

Audience

  • This course is designed for students, business owners, and aspiring data analysts.

Course Content

Introduction to the Course
In this introduction video, you'll see the final dashboard we'll be building for F&FMART.

Answering Business Questions as Analysts.
In this section, you'll learn how to think like a data analyst by turning business questions into data-driven answers. We’ll explore common sales-related questions—like identifying the Key Performance Indicators (KPIs) of the business, Month-over-month profit trends, Peak sales periods, and customer preferences—and show you how to answer them using your dashboard. Through hands-on lessons, you'll build dashboards that provide clear insights and support decision-making.

Earn a certificate

Add this certificate to your resume to demonstrate your skills & increase your chances of getting noticed.

selected template

A course by

Augustine Otabil
Augustine Otabil
Data Analyst

Student Ratings & Reviews

No Review Yet
No Review Yet

Course Includes:

  • Price:
    Original price was: ₵70.00.Current price is: ₵50.00.
  • Instructor:Augustine Otabil
  • Duration: 5 hours 36 minutes
  • Lessons:8
  • Students:0
  • Level:All Levels
  • Certifications:No
₵50.00 ₵70.00

Courses You May Like

Excel functions
40 minutes
Beginner
Introduction to Excel Functions
(4.7/ 3 Ratings)
Free
  • 5 Lessons
  • 21 Students
Beginner
Introduction to Excel Functions
(4.7/ 3 Ratings)
Free

Microsoft Excel is one of the most powerful tools for data management, analysis, and reporting. At the core of Excel’s...

  • 5 Lessons
  • 21 Students
Enroll Now
Analytics Plan Strategy Insight Concept
1 hour 5 minutes
Beginner
Excel Pivot Tables for Data Analysis
(3.0/ 1 Rating)
Original price was: ₵30.00.Current price is: ₵15.00.
  • 12 Lessons
  • 8 Students
Beginner
Excel Pivot Tables for Data Analysis
(3.0/ 1 Rating)
Original price was: ₵30.00.Current price is: ₵15.00.

Pivot Tables in Microsoft Excel are one of the most powerful and versatile tools for data analysis. They allow users...

  • 12 Lessons
  • 8 Students
Enroll Now
Data Analysis Results Summary Graph Chart Graphic
5 hours 35 minutes
Beginner
PART 1: Introduction to Data Analytics and AI
(4.3/ 3 Ratings)
Original price was: ₵50.00.Current price is: ₵25.00.
  • 25 Lessons
  • 11 Students
Beginner
PART 1: Introduction to Data Analytics and AI
(4.3/ 3 Ratings)
Original price was: ₵50.00.Current price is: ₵25.00.

The problem: Most data analyst, data science, and coding courses miss a critical practical step. They don’t teach you how...

  • 25 Lessons
  • 11 Students
Enroll Now

Want to receive push notifications for all major on-site activities?

✕