Skip to content

This project is based on a workshop attended through Jobaaj where we were tasked with analyzing Walmart’s sales data and building a dynamic dashboard using Power BI.

License

Notifications You must be signed in to change notification settings

FarhaKousar1601/Walmart-Sales-Data-Analysis

Repository files navigation

🛒 Walmart Sales Data Analysis

Excel Power BI Workshop Project

📊 Project Overview

This project is based on a workshop attended through Jobaaj, where we were tasked with analyzing Walmart’s sales data and building a dynamic dashboard using Microsoft Excel and Power BI.

🧾 Objective

Analyze the sales dataset provided by Walmart to derive key business insights, identify trends, and visually represent performance metrics through an interactive dashboard.

🗃️ Dataset Description

The dataset includes the following fields:

  • Order ID
  • Order Date
  • Ship Date
  • Customer Name
  • Country, State, City
  • Category
  • Product Name
  • Sales
  • Quantity
  • Profit

🛠️ Tools & Skills Used

  • Microsoft Excel: For initial data cleaning, pivot tables, and preprocessing
  • Power BI: For creating interactive dashboards and data visualizations
  • Data Analysis: Filtering, sorting, identifying top products and customers, profit tracking, etc.
  • Data Visualization: Bar charts, maps, KPIs, slicers, and trendlines

📌 Key Insights Derived

  • Top-selling products by category and profit
  • Most profitable states and cities
  • Order trends by month and year
  • High-volume and low-profit zones
  • Order-to-ship duration insights

📷 Dashboard Preview

🔗 Click here to view the live Power BI Dashboard

Dashboard Preview

🏆 Certificate of Completion

I received this certificate for successfully completing the Walmart Sales Data Analysis workshop using Power BI and Excel, organized by Jobaaj.

Certificate Preview

🎓 Workshop

  • Hosted By: Jobaaj
  • Topic: Walmart Sales Data Analytics & Visualization
  • Outcome: Practical hands-on experience in data storytelling and building dashboards from raw business data

🔗 Connect With Me

📍 Farha Kousar
🔗 LinkedIn
🌐 Portfolio/Bio Link


💡 “Turning data into decisions — one dashboard at a time.”

About

This project is based on a workshop attended through Jobaaj where we were tasked with analyzing Walmart’s sales data and building a dynamic dashboard using Power BI.

Topics

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages