• +234 (0) 7062274671
  • training@talentdigit.com
  • Log in
  • Register
Logo
  • About
  • Reviews
  • Portfolios
  • Programmes
    • Self-Paced Courses
    • Free Courses
    • Instructor-led Programmes
    • Training Centre (Hybrid)
    • Corporate Training
  • Free Resources
Avatar
Wilfred
Portfolios (7)

ABC Sales Analysis

September 29, 2026 (0) comments
Product
Project related images. Click to view
Product

ABC Sales Dashboard (Excel)

An interactive sales performance dashboard built for a bicycle and accessories retailer ("ABC"), covering 2016–2019 across five branches (Gbagada, Ibadan, Ikoyi, Lekki, Surulere). The dashboard consolidates revenue, cost, profitability, order and customer data into a single, slicer-driven view for management reporting.

Key features

  • Interactive filtering: Year, month, and branch slicers let users drill into performance for any period or location without touching the underlying data.
  • KPI summary bar: Nine headline metrics at a glance — Revenue, Expenses, Profit, Profit %, Orders, Returns, Return Rate, Product count, and Customer count.
  • Trend analysis: Month-over-month and year-over-year profit growth charts (combo column-and-line charts) to track momentum and seasonality.
  • Product and branch performance: Ranked bar charts showing the top 5 products, branches, and product categories by profit, highlighting where the business makes the most money.
  • Returns analysis: A breakdown of return reasons (defective product, delay, wrong product, unmet expectations) to flag quality and fulfilment issues.
  • Customer insight: A profit-by-gender donut chart giving a quick read on the customer base.

Tools and skills demonstrated

  • Excel (Power Query/pivot-based data modelling, DAX-style measures or formulas for KPIs, dynamic charts, slicers, and dashboard layout/design)
  • Data visualization and storytelling — translating raw sales, return, and customer data into a decision-ready, single-page report
  • Dashboard UX — consistent colour system, iconography, and layout so stakeholders can scan KPIs and trends quickly

Purpose
Built to practice end-to-end dashboard design: from structuring raw transactional data, to calculating KPIs, to presenting insights visually for a non-technical audience — a workflow directly transferable to reporting on energy-sector data (e.g., production, pricing, or flaring metrics).


Comment (0)

Leave your thought here

Other projects by Wilfred

Blog

Electronics Retailer Analysis

Blog

Global Flaring Dashboard, 2012–2025

Blog

2022 Methane Emission

Blog

Gas distribution sales report

Blog

Sales Summary Dashboard

Blog

Bike Purchase Analysis

Logo
  • Home
  • About
  • Reviews
  • Portfolios
  • Blog
  • Programmes
    • Self-Paced Courses
    • Free Courses
    • Instructor-led Programmes
    • Training Centre (Hybrid)
    • Corporate Training
  • Free Resources
    Log In
    Sign Up
Logo

Talentdigit Resources Limited is a digital training and consulting firm that equips individuals and organizations with digital skills training.

Quick Links

  • About
  • Reviews
  • Portfolios
  • Corporate Training
  • Blog
  • Refer a student and Earn
  • Verify Certificate
  • Login
  • Register

Programmes

  • Self-Paced Courses
  • Free Courses
  • Instructor-led Programmes
  • Hybrid Learning
  • Corporate Training
  • Free Resources

Sign Up for Our Newsletter

Receive weekly newsletter with educational materials, popular books and much more!

  • Terms of Use
  • Privacy Policy

© 2023 (c) All right reserve

Login

Don't have an account yet?

Forgot your password?

or Log-in with

  • Gacebook
  • Google
Sign Up

Already have an account?

Home
Home
Home
Home
Home
Home
Home
Home
Home