Skip to content

In this Power BI project, we analyzed the Superstore dataset to uncover meaningful business insights through interactive data visualizations. The data was first cleaned and prepared by removing unnecessary columns, fixing the date format, and correcting data types to ensure accuracy.

Notifications You must be signed in to change notification settings

DevLM7/2_Data_analysis

Folders and files

NameName
Last commit message
Last commit date

Latest commit

Β 

History

4 Commits
Β 
Β 
Β 
Β 
Β 
Β 

Repository files navigation

πŸ“Š Superstore Sales Dashboard – Power BI Project

Welcome to the Superstore Sales Analysis project β€” a sleek and insightful Power BI dashboard designed to transform raw retail data into clear business intelligence.

This project was created as part of a hands-on learning experience in Power BI, where I explored everything from data cleaning to advanced visualization.


πŸ” What This Dashboard Covers

This dashboard provides a comprehensive breakdown of sales performance using the Superstore dataset, focusing on:

  • πŸ“ Region-wise Sales & Profit
  • πŸ“ˆ Monthly Sales Trends
  • πŸ’° Profit Margins
  • πŸ“¦ Top-level KPIs (Sales, Profit, Orders)
  • 🧭 Interactive Filters (Slicers)
  • 🎯 Key Insights and Business Recommendations

🧹 Data Preparation Highlights

  • Removed unnecessary columns (e.g., Row ID)
  • Fixed Order Date format (MM-DD-YYYY β†’ proper Date format)
  • Set correct data types for sales figures, dates, and categorical fields
  • Cleaned and standardized fields to ensure accuracy in reporting

πŸ’‘ Key Takeaways

  • West region has the highest overall sales
  • South region shows strong profitability despite lower sales
  • Month-on-month sales trend reveals seasonal patterns
  • Filtering by Region enables targeted performance analysis

πŸ› οΈ Tools Used

  • Power BI Desktop
  • Superstore Dataset (from Kaggle)
  • DAX for calculated metrics like Profit Margin

πŸ‘¨β€πŸ’Ό Purpose

This dashboard was created as a Power BI learning task using a real-world dataset, as part of my internship with Elevate Labs.
It showcases how data visualization can reveal business insights that spreadsheets often hide.


About

In this Power BI project, we analyzed the Superstore dataset to uncover meaningful business insights through interactive data visualizations. The data was first cleaned and prepared by removing unnecessary columns, fixing the date format, and correcting data types to ensure accuracy.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published