Scribd
Upload
20 views2 pages

Superstore SQL Project Guide

The Superstore SQL Project Guide outlines steps for data analysts to utilize SQL, Excel, and Power BI with the Superstore dataset from Kaggle. It includes instructions for downloading the dataset, setting up MySQL, importing data, performing SQL analysis, exporting results to Excel, visualizing in Power BI, and preparing final deliverables. The guide also provides tips for presenting the project in interviews, emphasizing the use of real-world data and the analytical process.

Uploaded by

santlat72
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
20 views2 pages

Superstore SQL Project Guide

The Superstore SQL Project Guide outlines steps for data analysts to utilize SQL, Excel, and Power BI with the Superstore dataset from Kaggle. It includes instructions for downloading the dataset, setting up MySQL, importing data, performing SQL analysis, exporting results to Excel, visualizing in Power BI, and preparing final deliverables. The guide also provides tips for presenting the project in interviews, emphasizing the use of real-world data and the analytical process.

Uploaded by

santlat72
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 2

Superstore SQL Project Guide – For Data Analyst

Role

This project helps you demonstrate your SQL, Excel, and Power BI skills using the Superstore
dataset from Kaggle. It mirrors real-world data analysis tasks you’d perform as a Data Analyst in
companies like Accenture, PwC, or Deloitte.

■ Step 1: Download the Dataset

1 Go to Kaggle → Search 'Superstore Dataset' → Download CSV file.


2 File will be named something like 'SampleSuperstore.csv'.
3 Keep it in a known folder, e.g., C:\DataProjects\Superstore.

■ Step 2: Set Up MySQL Workbench

1 1. Open MySQL Workbench.

2 2. Connect to your local server (username: root, password: your password).

3 3. Create a new database using this command:

4 CREATE DATABASE superstore;

5 4. Then select it: USE superstore;

■ Step 3: Import the Dataset

1 Option 1: Use MySQL Workbench Table Import Wizard.


2 Option 2: Create table manually:
3 CREATE TABLE superstore_sales ( Row_ID INT, Order_ID VARCHAR(50), Order_Date
DATE, Ship_Date DATE, Ship_Mode VARCHAR(50), Customer_ID VARCHAR(50),
Customer_Name VARCHAR(100), Segment VARCHAR(50), Country VARCHAR(50), City
VARCHAR(50), State VARCHAR(50), Postal_Code VARCHAR(20), Region VARCHAR(50),
Product_ID VARCHAR(50), Category VARCHAR(50), Sub_Category VARCHAR(50),
Product_Name VARCHAR(255), Sales DECIMAL(10,2), Quantity INT, Discount
DECIMAL(5,2), Profit DECIMAL(10,2) );

4 Then use MySQL Workbench → Table Data Import Wizard → Choose 'SampleSuperstore.csv'.
5 Finish import and verify data: SELECT * FROM superstore_sales LIMIT 10;

■ Step 4: Perform SQL Analysis

1 1. Total Sales and Profit:


2 SELECT SUM(Sales) AS Total_Sales, SUM(Profit) AS Total_Profit FROM superstore_sales;
3 2. Top 10 Products by Sales:
4 SELECT Product_Name, SUM(Sales) AS Total_Sales FROM superstore_sales GROUP BY
Product_Name ORDER BY Total_Sales DESC LIMIT 10;

5 3. State with Highest Profit:


6 SELECT State, SUM(Profit) AS Total_Profit FROM superstore_sales GROUP BY State
ORDER BY Total_Profit DESC LIMIT 5;

7 4. Monthly Sales Trend:


8 SELECT DATE_FORMAT(Order_Date, '%Y-%m') AS Month, SUM(Sales) AS Total_Sales
FROM superstore_sales GROUP BY Month ORDER BY Month;

■ Step 5: Export Results to Excel

1 Use 'Export Results' in MySQL Workbench to save each query result as an Excel file.
2 Create separate sheets for 'Sales Summary', 'Top Products', 'Profit by State', etc.

■ Step 6: Visualize in Power BI

1 Open Power BI → Get Data → Import Excel.

2 Load the exported Excel files.

3 Create visuals like:

4 • Sales by Region (Map chart)

5 • Profit by Category (Bar chart)

6 • Monthly Sales Trend (Line chart)

7 • Top Products by Sales (Table/Bar chart)

■ Step 7: Final Deliverables

1 • Power BI Dashboard (.pbix file)

2 • Excel Analysis File (.xlsx)

3 • SQL Script (.sql file)

4 • PDF Report (this guide or your summary)

■ Tips to Present This Project in Interviews

1 Mention that you used real-world data from Kaggle.


2 Explain your process clearly: Data Cleaning → SQL Analysis → Visualization.
3 Highlight business insights you derived (e.g., which region or product performed best).

You might also like