🚴 Maven Cycles Sales & Profit Dashboard (Power BI Project)

📊 Overview

This Power BI dashboard presents an interactive and insightful analysis of sales and profit data for Maven Cycles, a fictional cycling products company. The dashboard enables users to monitor key business metrics like revenue, profit, and profit margin, and to explore sales performance across products, categories, regions, and time periods.

---

✅ Key Features

• KPI Cards showing:

  • Total Revenue
  • Total Profit
  • Profit Margin (with progress toward goals)

• Interactive Filters:

  • Date range selector
  • Product category dropdown

• Visual Components:

  • 📦 Product Detail Table with conditional formatting on profit margin
  • 🌍 Revenue by Country using map visuals
  • 🧁 Profit by Category (Donut Chart)
  • 📈 Profit Trend by Period (Line Chart)

• DAX Measures for:

  • Total Revenue
  • Total Profit
  • Profit Margin
  • Total Orders

---

🧩 Tools Used

• Power BI Desktop
• Power Query Editor
• DAX (Data Analysis Expressions)

---

📁 Project Structure

• ├── Maven Cycles Sales Dashboard.pbix # Power BI file
• ├── README.md # Documentation
• └── Maven Cycles Sales Dashboard snapshot.png #

---

📌 How to Use

• Open the .pbix file in Power BI Desktop.
• Use the filters at the top to adjust the date range or select product categories.
• Hover or click on visuals for detailed insights.
• Analyze performance by region, product line, and timeline.

🔍 Insights Uncovered

• Best-selling products and top-performing categories
• Countries generating the highest revenue
• Trends in profitability over time
• Areas falling short of profit margin goals

📅 Timeline

• Week 1: Data modeling, transformation, and DAX measure creation
• Week 2: Report visuals, slicers, formatting, and final insights

🙋‍♂️ Author Built by Kentigern Nnaji, a Business & Data Analyst passionate about leveraging data to uncover insights and drive decision-making.

🔗 Connect on LinkedIn View LinkedIn](https://www.linkedin.com/in/kent-c-nnaji)