car sales dashboard

Automobile Sales Data Analysis Using Power BI and MySQL

Client: Jayden Pitre Buick-Pontiac-GMC of Scottsdale

Dataset: Honda Pale White Odyssey

Date: Wednesday, January 12, 2022

Total Amount: $114.17

Role: Freelancer

Tools Used: Power BI, MySQL

Objective:

The primary objective of this project is to analyze and visualize automobile sales data, specifically focusing on a transaction for a Honda Pale White Odyssey, using Power BI for visualization and MySQL for database management.

Project Overview:

Data Extraction and Preparation:

Extract sales data from various sources.

Clean and preprocess the data to ensure accuracy and consistency.

Import the cleaned data into a MySQL database.

Database Management:

Design and create a relational database in MySQL to store the sales data.

Write SQL queries to retrieve specific data points, such as transaction dates, vehicle details, and sales amounts.

Data Analysis:

Use SQL queries to perform preliminary analysis on the sales data.

Identify key metrics such as total sales, average transaction value, and frequency of specific vehicle sales.

Data Visualization:

Connect Power BI to the MySQL database to retrieve real-time data.

Create interactive dashboards and reports in Power BI to visualize key insights.

Visualizations include bar charts, pie charts, and line graphs to represent sales trends over time.

Use filters and slicers to allow users to drill down into specific details, such as sales by date, vehicle model, or sales representative.

Reporting:

Generate comprehensive reports that summarize the findings.

Provide insights and recommendations based on the data analysis.

Outcome:

The final deliverable will be an interactive Power BI dashboard connected to a MySQL database, providing real-time insights into the sales performance of Jayden Pitre Buick-Pontiac-GMC of Scottsdale. This tool will help the client make data-driven decisions to improve their sales strategy and operational efficiency.

Skills Utilized:

Data extraction and cleaning

MySQL database design and management

SQL query writing

Data analysis and interpretation

Power BI dashboard creating Reporting and visualization