This project leverages SQL for data analysis and Tableau for data visualization to gain insights into Atliq's sales data. The objective is to answer several questions regarding revenue and sales trends. The SQL queries and visualizations provide comprehensive insights into the company's sales performance and trends.
To replicate this project on your machine, follow these steps:
- Install SQL-supported DBMS: Ensure you have a SQL-supported Database Management System installed.
- Create Database: Create a new database for the project.
- Create Tables: Use the provided schema diagram to create necessary tables.
- Import Data: Import the CSV files from the dataset folder into your database.
- Connect Tableau: Link Tableau to your database to create visualizations.
Note: For MySQL users, restoring the backup files can save you time.
Refer to the provided schema diagram for table structures and relationships.
- Database Management System: MySQL
- Visualization Tool: Tableau
- SQL Queries and Analysis: Analysis.sql file
This dataset was obtained from Code Basics. You can download the dataset [https://codebasics.io/resources/end-to-end-sales-insights-project-using-tableau](source link).
You are free to use this dataset to build your own project and practice your data querying and visualization skills.
- 🐬 mysql
- 📊 Tableau
- 📚 Code Basics
The project answers several key questions about Atliq's sales performance. Here are a few of them (for more, refer to the analysis.sql file):
- Revenue by Market: Breakdown of revenue generated from each market.
- Total Revenue: Calculation of the total revenue generated.
- Sales Quantity: Analysis of the total quantity of sales.
- Revenue by Year Trend: Trend analysis of revenue over the years.
The results of the analysis are as follows:
- Revenue by Market: The detailed revenue for each market can be found in the Tableau dashboard.
- Total Revenue: The total revenue generated is "$ 118,405.20K".
- Sales Quantity: The total sales quantity is "141.31K units".
- Revenue by Year Trend: The revenue trend over the years is visualized, showing growth patterns and seasonal variations. [https://public.tableau.com/app/profile/varun.t.r./viz/Dashboard1_17187019071190/Dashboard1?publish=yes] (Dashboard link)
The project successfully answered the set of questions regarding Atliq's sales data. The insights gained from this project can help Atliq make informed decisions regarding market strategies, sales improvements, and revenue forecasting.
Feel free to explore the analysis.sql file and the Tableau dashboard for a deeper dive into the data!