GitHub - ShadowRanger100/Order_Summary

📊 Order Summary Analysis Dashboard

A comprehensive data analysis project using SQL, Excel, and Power BI to derive actionable insights from e-commerce order data.

🗂️ Project Structure

Order_Summary/
│
├── Excel Data/                # Raw and cleaned Excel files used for analysis
├── SQL Queries - Orders/     # SQL scripts for data extraction and transformation
├── Insights/                 # Screenshots and documented key findings from dashboard
├── Order_Summary_Dashboard.pbx      # Power BI dashboard file

🔧 Tools Used

• MySQL Workbench – for running SQL queries to explore and clean the dataset
• Microsoft Excel – for preliminary data cleaning, KPI computation, and summary tables
• Power BI – for dashboard design, visual storytelling, and dynamic report generation

📈 Key Features

• Dynamic dashboard built in Power BI for tracking order trends, revenue, customer segments, and more
• Clean SQL queries used for joining and aggregating order data
• Excel KPI sheet and raw data transformation included
• Organized folders for modular access to each step of the process

🧠 Insights Generated

• Top-performing products and categories