• +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
Ayuba
Portfolios (4)

DANGATA STORES

October 05, 2026 (0) comments
Product
Project related images. Click to view
Product

Developed an interactive Sales & Performance Dashboard in Microsoft Power BI to analyze retail sales performance and provide actionable business insights for Dangata Stores. The dashboard consolidates sales data across multiple years, enabling management to monitor revenue trends, profitability, product performance, and overall business health.

Objectives

* Analyze historical sales performance from 2016 to 2019.?

* Track key business metrics such as Gross Sales, Net Sales, Cost of Sales, Gross Margin, Discounts, and Returned Sales.?

* Identify performance trends and profitability drivers.?

* Create an intuitive and interactive dashboard for executive decision-making.?

Tools & Technologies

* Microsoft Power BI?

* Power Query (Data Cleaning & Transformation)?

* DAX (Data Analysis Expressions)?

* Data Modeling & Visualization?

Key Features

* Interactive year-based filtering (2016-2019)?

* KPI cards highlighting critical business metrics?

* Sales performance overview dashboard?

* Profitability analysis through Gross Margin calculations?

* Return and discount tracking for operational efficiency?

* Dynamic navigation and report interaction?

Data Analysis Performed

* Sales trend analysis across multiple years?

* Revenue and profitability assessment?

* Cost-to-sales performance evaluation?

* Gross Margin performance measurement?

* Returned sales impact analysis?

* Comparative yearly performance analysis?

Key Insights

* Achieved Gross Sales of ?29.36M for the selected period.?

* Recorded Net Sales of ?12.08M after accounting for relevant deductions.?

* Cost of Sales stood at ?17.28M, providing visibility into operational spending.?

* Maintained a 41.15% Gross Margin, indicating a healthy profitability level.?

* Return rates were minimal with only ?2,018 in returned sales.?

* No discounts were recorded during the selected reporting period.?

Outcome: The dashboard transformed raw sales data into a clear, visual decision-support tool, enabling stakeholders to quickly assess business performance, identify growth opportunities, and make data-driven decisions.


Comment (0)

Leave your thought here

Other projects by Ayuba

Blog

Healthcare Visits Analytics

Blog

Sales Summary Dashboard

Blog

ABC Stores Dashboard

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