Skip to content

m-j-yates/AdventureWorks

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

5 Commits
 
 
 
 
 
 

Repository files navigation

📊 Sales Performance Report | Power BI

Welcome to my interactive Power BI dashboard analyzing regional sales, product performance, and profitability across fiscal year 2020. This project transforms raw transactional data into a dynamic decision-support tool—designed to uncover trends, optimize strategy, and empower business intelligence.


🚀 Project Overview

This report is the result of a full-stack analytics workflow: from Excel-based data preparation to polished Power BI visualizations. I cleaned, structured, and enriched the dataset using advanced Excel techniques before designing a dashboard that delivers clarity, insight, and impact.

image https://app.powerbi.com/links/pnW03DGqCJ?ctid=3ea7c128-c601-4479-a003-e14d00c0b5cb&pbi_source=linkShare

🛠️ Skills Demonstrated

  • 📦 Data Preparation & Modeling

    • Cleaned and structured sales data by region, category, and time
    • Created calculated columns and measures for profitability and performance
  • 📈 Analytical Thinking

    • Identified top-performing product groups and seasonal trends
    • Compared regional contributions to total revenue and margin
  • 📊 Power BI Visualization

    • Designed interactive charts and KPIs for intuitive exploration
    • Used slicers, filters, and tooltips to enhance user experience
    • Built a cohesive layout that guides users through the story

📸 Report Highlights

These visuals bring the data story to life:

  • 📅 Monthly Sales & Profit Margin Trends
    Tracks performance across FY2020 with dual-axis visuals.

  • 🌍 Regional Sales Breakdown
    Compares contributions from Australia, Canada, France, Germany, UK, and US.

  • 🛍️ Sales by Product Group & Category
    Highlights top-selling items across Bikes, Clothing, Accessories, and Components.

  • 📦 Quantity Sold by Category
    Visualizes volume trends and inventory movement.


📌 Key Insights

  • Identified seasonal spikes in sales and margin dips
  • Flagged underperforming product categories for strategic review
  • Built a reusable framework for future sales data imports and dashboard iterations

💡 Why This Matters

This isn’t just a report—it’s a strategic engine for sales intelligence. With Power BI storytelling, I’ve built a tool that empowers smarter decisions across marketing, operations, and finance.


Want to collaborate on future BI dashboards or expand this into a multi-report suite? Let’s connect and build something impactful.

About

Exploration of the adventure works database in PowerBI

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors