Objective

Provide insights on Finance, Sales, Marketing, and Supply Chain to the management of a manufacturing company.

Domain: Manufacturing

This project analyzes business data to generate actionable insights using SQL for querying and Power BI for visualization.

Key Tasks

• Write SQL queries to extract essential insights and reports.

• Develop stored procedures for filtered data extraction.

• Create an interactive Power BI dashboard for data-driven decisions.

Tech Stack

• MySQL

• MS Excel

• Power BI (including Power BI Service for live dashboard sharing)

Workflow

• SQL Workbench

• Load raw data into MySQL.

• Design database schemas and relationships.

• Create stored procedures for managers to extract filtered reports.

• Generate key metrics using advanced SQL queries.

Power BI Dashboard

• Connect Power BI to MySQL and Excel.

• Transform and clean data using Power Query.

• Establish data relationships and build calculated measures.

• Design a dynamic dashboard with KPIs for each department.

Key Features

Departmental Insights

• Finance View: Profit and loss metrics, revenue trends, and KPI tracking.

• Sales View: Unit economics, customer segmentation, and sales performance analysis.

• Marketing View: Campaign ROI, operational expenses, and customer acquisition cost.

• Supply Chain View: Inventory turnover, demand forecast accuracy, and risk analysis.

• Executive View: Comprehensive high-level insights for strategic decision-making.

Live Dashboard

• Interactive Visuals: Drill-through and filter options for better analysis.

• Dynamic Updates: Real-time data updates powered by Power BI Service.

Key Learnings

• In-depth understanding of departmental metrics and their significance.

• Enhanced stakeholder communication skills through effective report delivery.

• Mastered integrating SQL and Power BI for seamless data visualization.