Automotive BI & Management Platform

This is a comprehensive, enterprise-grade Business Intelligence (BI) and management platform built for a large automotive corporation to monitor and analyze its global operations. The application was developed using Django and MySQL to handle complex data and provide real-time insights.

The primary goal was to centralize sales, inventory, and performance data from 40+ dealerships worldwide into a single, powerful, and interactive dashboard for executives and managers.

Key Features

Multi-faceted BI Dashboard: Provides a high-level overview of key performance indicators (KPIs) including total sales value, vehicles in stock, and total number of dealerships.

Advanced Sales Analytics: Users can drill down into sales data with interactive charts showing monthly trends, year-to-date performance, and sales breakdowns by dealership area.

In-Depth Inventory Management: Tracks vehicle inventory by status (e.g., In Production, In-Transit, Dealer Stock), model name, and category. It also highlights critical metrics like aged inventory (>90 days) to help reduce costs.

Interactive Dealership Map: A geospatial map view that visualizes the location of all dealerships across the globe, providing a clear picture of the corporation's footprint.

Performance vs. Target Tracking: A dedicated module for comparing actual sales units against pre-defined company targets, allowing for quick performance assessment.

Secure Admin Panel: A secure back-end for administrators to manage users, data sources, and application settings.

Technologies Used

Backend: Python, Django Framework

Database: MySQL

Frontend: HTML, CSS, JavaScript (with a charting library like Chart.js or D3.js for data visualization)