This project aims to analyze the sales data of AtliQ Hardware, a company that sells hardware products to different sectors in various regions. The company experienced a decrease in sales last year, and the managers want to identify the reasons behind this decline using the available sales data.
The project involved several steps to analyze and visualize the sales data. The following is an overview of the process:
- Data Import: The sales data was imported from a GitHub repository into MySQL Workbench for further analysis.
- Data Analysis: Various data analysis techniques were applied, such as examining sales for each year, comparing sales across different cities, and joining tables to gather relevant insights.
- Data Modeling: A star schema was created in Tableau to facilitate data visualization and exploration.
- Data Cleaning and ETL: Data cleaning tasks were performed within Tableau, including handling negative and zero sales values, filtering out irrelevant countries, and converting sales amounts to a consistent currency (INR).
- Dashboard Creation: Multiple visualizations were built in Tableau to showcase the sales data effectively.
- Interactive Filters: Year and month filters were added to the dashboard as slicers, enabling users to select specific time periods for analysis.
- Project Documentation: A README file was prepared to document the entire project, including the steps taken and key findings.
The dashboard consists of several visualizations to provide insights into the sales data. The key visualizations include:
- Revenue by Markets: A bar graph illustrating the revenue generated by different markets.
- Sales Quantity by Markets: A bar graph displaying the quantity of products sold in different markets.
- Revenue Trend by Year: A trend graph showcasing the revenue trend over the years.
- Top 5 Customers by Revenue: A bar graph highlighting the top five customers based on their revenue contribution.
- Top 5 Products by Revenue: A bar graph showing the top five products based on their revenue generation.
To effectively utilize the provided Tableau dashboard, follow these instructions:
- Ensure that Tableau Desktop is installed on your system.
- Open the Tableau project file (.twb) containing the created data model and visualizations.
- Use the interactive filters (year and month) to select specific time periods for analysis.
- Explore the different visualizations to gain insights into the sales data.
- Adjust filters and interact with the visualizations to further analyze the data as required.
- Extract relevant findings and observations from the dashboard to understand the reasons behind the decline in sales.
The AtliQ Hardware Sales Analysis project aimed to identify the reasons behind the decline in sales for the company. By importing the sales data, performing data analysis, creating a star schema, and building visualizations in Tableau, valuable insights were obtained. The dashboard allows users to explore the data interactively and draw conclusions based on the provided visualizations. By utilizing the provided instructions, stakeholders can gain a better understanding of the sales data and identify potential areas for improvement.
