How I Built a Sales Dashboard for "Savr" Finance App Using Power BI

-

🔍 Project Background

Savr is a fictional retail brand created for a mock business dashboard challenge. The goal was to visualize sales, customer trends, and performance metrics using Power BI — just like you'd do in a real business setting.

🎯 Business Objective

To help the marketing and operations team at Savr:

  • Track sales performance by region and product

  • Identify best- and worst-performing categories

  • Understand customer behavior and returns

🛠 Tools Used

  • Power BI – for building dynamic dashboards

  • Excel – for handling raw data

  • DAX – to create calculated metrics

  • Power Query – for data transformation

📈 Dashboard Features

Here’s what the final dashboard includes:

  1. Sales Overview:
    Shows total sales, quantity sold, returns, and profit across all regions.

  2. Top Products & Categories:
    Highlights high-revenue items and low performers.

  3. Customer Segment Analysis:
    Breaks down metrics by customer types (e.g., Loyal, New).

  4. Dynamic Filters:
    Allows users to filter data by:

    • Year

    • Region

    • Product category

  5. Interactive Visuals:
    Bar charts, donut charts, maps, and card visuals to tell the story at a glance.

📷 Dashboard Screenshot


{Click on image for broad clear view}

Click for Video/Audio Live Demonstration

💡 What I Learned

  • How to use Power BI’s drag-and-drop interface to build impactful visuals

  • How to use Power Query Editor to clean and reshape messy data

  • Writing DAX expressions to calculate KPIs like Profit %, Return Ratio

  • Most importantly: how to tell a business story using data

🔗 GitHub Link

You can view the full dashboard files and Excel source here:
👉 GitHub: Savr Power BI Dashboard

🙋‍♀️ Final Thoughts

This was one of my favorite projects because it helped me think like a business analyst. I learned how to turn raw data into something that leadership teams could actually use to make decisions. I look forward to building even more advanced dashboards soon!

Hi, I’m Heena Shaikh — a Data enthusiast with a passion for analytics, storytelling, and machine learning. I enjoy exploring data to uncover patterns, solve problems, and make meaningful decisions. With skills in Python, MySQL, R, Data Visualization , Machine Learning and automation tools, I'm constantly learning and building towards a career in data science.

Comments

Post a Comment

How i built ShopeE-Mate

How I Built ShopeE-Mate (An E-commerce Product Recommendation /Comparison Using Python and Machine Learning)

-
Image
🛍️ Project Overview During my final year, I created a multi-platform e-commerce product recommendation system called ShopeE-Mate . This tool helps users find the best deals across Amazon, Flipkart, and JioMart — all in one place. 💡 The Problem Users waste a lot of time switching between apps and websites just to find the best price for the same product. I wanted to solve that using automation and ML/AI. 🛠️ Tools and Technologies Used 🔎 Web Scraping: RPA UiPath, Selenium 📊 Data Processing: Pandas, NumPy , Google colab 📦 Machine Learning: Scikit-learn, Tokenization(NLP) 🧠 Recommendation Models: Content-based, Collaborative, Hybrid  🌐 Web Framework: Flask  🛢 Database system : MySql XAMPP server ⚙️ How It Works Step 1: Product data is scraped in real-time using automation tools Step 2: Data is cleaned and structured using Pandas Step 3: ML models rank the products based on user preference, rating, and discount Step 4: Flask displays...
Read more

Sales Forecasting for Big Mart Using XGBoost Regression — A Machine Learning Approach

-
Image
  {Click on image for broad clear view} 🔍 Project Overview This project focuses on predicting sales for Big Mart stores across India using historical data. I built a machine learning model that analyzes factors like product price, store type, location, and promotions to forecast future sales with greater accuracy. 🎯 Business Problem Big Mart needed a reliable way to forecast sales to: Avoid overstocking and stockouts Optimize inventory and staffing Plan promotions more effectively Using machine learning helps make smarter, data-driven decisions. 🛠 Tools & Techniques Used Python + Google Colab Libraries: Pandas, Seaborn, Matplotlib, XGBoost, Scikit-learn Model Used: XGBoost Regressor Data Source: Kaggle – Big Mart Sales Dataset ⚙️ Key Steps I Followed Data cleaning and handling missing values Feature encoding (Label Encoding for categories) Exploratory Data Analysis using Seaborn Model training with XGBoost Evaluation usi...
Read more

Welcome to Decode With Heena

-
Image
I'm Heena Shaikh , a Data Science graduate with a passion for turning raw data into meaningful insights. Through this blog, I share my real-world projects, virtual internship experiences, and tutorials in data analytics, machine learning, and business reporting. Whether you're a recruiter, a fellow learner, or someone just curious about data — I'm glad you're here! 👉 Feel free to explore my About Me and Get my Resume , check out my Projects , check out my Blog Posts , or Contact Me anytime.
Read more