Manufacturing Analytics – Excel, SQL, Tableau & Power BI

This project is a complete Manufacturing Analytics solution, developed using Excel, SQL, Tableau, and Power BI, designed to analyze production performance, quality issues, manpower utilization, and operational efficiency.

🚀 Project Overview

This end-to-end analytics project transforms raw manufacturing data into actionable insights. Using SQL for data extraction, Excel for data cleaning, Tableau for visualization exploration, and Power BI for the final interactive dashboard, the project provides a comprehensive view of:

Manufactured Quantity

Rejected Quantity

Wastage Percentage

Manpower involvement

Production trends by date, shift, and item

It helps manufacturing teams track performance, identify quality issues, and optimize operations.

🎯 Key Features

✅ Interactive KPI Cards — Manufactured Qty, Rejected Qty, Wastage %, Employees, Operators.

✅ Wastage & Quality Insights — Identify rejection patterns and key quality problem areas.

✅ Production Trend Analysis — Daily/Monthly trend lines comparing production vs rejection.

✅ Shift & Item-Based Analysis — Understand performance by operational segments.

✅ Manpower Summary — Quick view of employee and operator distribution.

✅ Clean Industrial UI — Professionally aligned, easy-to-read manufacturing visuals.

📊 Visualizations Included

📈 Manufacturing Trend (Manufactured vs Rejected Qty)

🧪 Wastage % Over Time

🏭 Shift-wise & Item-wise Production Analysis

📦 Rejection Insights

👷 Operator & Employee Summary Cards

🕒 Time-based Filtering and Slicers

🧮 Metrics Calculated

Manufactured Quantity – Total units produced

Rejected Quantity – Defects or non-usable units

Wastage Percentage – (Rejected / Manufactured) * 100

Total Employees – Workforce involvement

Daily & Monthly Trends – Production behavior over time

🔗 Dataset

Structure typically includes: Date • Shift • Item • Manufactured Qty • Rejected Qty • Employees • Operators

🛠️ Tools Used

Tool Purpose

• SQL - Data extraction & basic transformation
• Excel - Cleaning, formatting & preprocessing
• Tableau - Exploratory visualizations
• Power BI - Final dashboard & insights

📥 Installation / Usage

Clone or download this repository.

Open the .pbix Power BI file in Power BI Desktop.

Optional: Open the Excel file used for cleaning.

Optional: View Tableau exploratory workbook.

Explore the dashboard and interact with slicers.

📸 Dashboard

📜 License

This project is for portfolio and educational use.

✨ Created By

Asharani M G 🔗 GitHub: https://github.com/ASHARANI-MG

📧 Email: ashaa12gowda@gmail.com

💼 LinkedIn: https://www.linkedin.com/in/asharani-m-g-a64569229/