Skip to content

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

10 Commits
 
 
 
 

Repository files navigation

Sales Performance Dashboard

Power BI DAX Power Query Data Analysis


Overview

This project presents a sales performance dashboard developed in Power BI to monitor revenue, units sold, and budget achievement across multiple countries and customers.

🎥 Interactive Dashboard Demo

See how slicers dynamically update every visual, allowing users to analyze sales performance from different years, months, and customers.

Powerbi-sales-slicers

📸 Dashboard Preview

Main Dashboard

image

🎯 Business Objective

Develop an interactive business intelligence dashboard that enables users to monitor sales performance, identify high-performing markets and customers, evaluate budget achievement, and analyze sales trends over time to support data-driven decision-making.


❓ Business Questions Answered

This dashboard helps answer questions such as:

  • Which countries generate the highest revenue?
  • Which customers contribute the most sales?
  • How do sales change over time?
  • Are sales meeting the planned budget?
  • How many transactions and units have been sold?
  • Which markets present the greatest growth opportunities?

🚀 Dashboard Features

  • Interactive filters by Year, Month, Country, and Customer
  • Revenue and Units Sold KPI cards
  • Budget vs Actual Sales gauge
  • Sales by Country visualization
  • Customer performance analysis
  • Monthly sales trend analysis
  • Year-over-year sales comparison
  • Geographic sales map
  • Sales summary table with key performance metrics

📈 Key Performance Indicators

KPI Description
Total Sales Total revenue generated
Units Sold Total quantity of products sold
Transactions Number of completed sales
Average Ticket Average revenue per transaction
Budget Achievement Actual sales compared to planned budget

💡 Key Insights

  • Identified the highest-performing countries by total revenue.
  • Compared customer contributions to overall sales.
  • Evaluated monthly and yearly sales trends.
  • Monitored sales performance against budget targets.
  • Enabled quick identification of business opportunities through interactive filtering.

🛠️ Tools & Technologies

  • Power BI
  • Power Query
  • DAX
  • Microsoft Excel

📚 Skills Demonstrated

  • Dashboard Design
  • Business Intelligence
  • Data Visualization
  • Data Modeling
  • Power Query (ETL)
  • DAX Measures
  • KPI Development
  • Interactive Reporting
  • Geospatial Analysis
  • Data Analysis

Files

  • Power BI dashboard (.pbix)
  • Dashboard screenshots

📸 Additional Dashboard Views

Sales Performance Visualizations

Compare sales performance by vendor and country using interactive visualizations.

Powerbi-sales-graphic

Sales Summary Table

Analyze sales metrics including revenue, transactions, channel contribution, and average ticket by country.

Powerbi-sales-table

📈 Business Value

This dashboard consolidates multiple sales metrics into a single interactive report, enabling users to quickly evaluate business performance, compare markets, monitor sales targets, and identify opportunities without manually analyzing raw data.


🔮 Future Improvements

  • Add profitability and margin analysis
  • Include product-level performance metrics
  • Create customer segmentation analysis
  • Add drill-through pages for detailed exploration
  • Develop a mobile-friendly dashboard layout

Author

Daniel Betancourt

Electronic Engineer | Data Analyst

If you found this project interesting, feel free to connect with me on LinkedIn or explore my other data analytics projects on GitHub.

About

Power BI sales dashboard tracking revenue, units sold, and budget performance across customers, countries, and time periods.

Topics

Resources

Stars

Watchers

Forks

Releases

Packages

Contributors