Project 1 – Superstore Data Analysis

📌 Topics Covered

• Cleaning and preprocessing raw datasets
• Exploratory Data Analysis (EDA) using Excel
• Creating Pivot Tables and Pivot Charts
• Designing interactive dashboards
• Conditional formatting and key performance indicators (KPIs)

📝 Project Summary
This project focuses on transforming unstructured datasets into actionable insights using Excel. You will clean, analyze, and visualize data by building interactive dashboards. The goal is to identify trends, patterns, and KPIs, making it easier to make informed business decisions from raw data.

✅ What You Will Learn

• Clean and preprocess raw data for analysis
• Perform exploratory data analysis in Excel
• Summarize data with Pivot Tables and Pivot Charts
• Build interactive dashboards with visualizations
• Highlight key metrics using conditional formatting

Note to Students –

Live Classes will held on Google Meet.
Mentor will provide files, dataset in the Google Clasroom.
Class video will be provided on Google Classroom.

Click “Mark as Complete” button.

Good Luck.