Case Study Background
As part of our role as data analysts at AtliQ Hardware, a prominent computer hardware and peripheral manufacturer serving surgery stores, nomad stores, excel stores, and other market segments, our primary objective is to provide actionable insights to the Sales Director to address the observed decline in sales. Our efforts aim to identify key trends and patterns, enabling data-driven decision-making to revitalize sales performance.
Company Overview: AtliQ Hardware is headquartered in India and boasts an extensive network of regional offices. We specialize in producing and supplying computer hardware and peripherals to diverse market segments, including surgery stores, nomad stores, and Excel stores. Our products cater to various customer needs, positioning us as a significant player in the industry.
Project Goals: Our mission involves delivering clear, concise, and easily understandable insights to the Sales Director. Through careful analysis of sales data, market trends, and customer behaviors, we aim to uncover the underlying causes of the decline in sales. By identifying critical factors impacting our sales performance, we can help the organization devise strategies to counteract these challenges effectively.
End Result: An automated dashboard providing quick and latest sales insights to support data-driven decision making
Phase 1: Data Analysis Process
Asking Questions
1. What is my revenue breakdown by city?
2. What is my revenue breakdown by years and months?
3. What are the top 5 customers by revenue and sales quantity?
4. What are the top 5 products by revenue number?
Determining Stakeholders
-
Sales Director Team
-
Marketing Team
-
Customer Service Team
-
Data & Analytics Team
-
IT Team
Primary MySQL Analysis
MySQL Query Insights
Strategic Insights into Product Performance across Diverse Markets
-
Conducted an in-depth assessment of top-selling products across various market names and zones within India.
-
Delved into each city's sales data, including revenue figures in their respective currencies.
-
Provided a nuanced understanding of product preferences and market dynamics, enabling precisely targeting market-specific strategies.
Temporal Trends and Revenue Evolution
-
Examined the sales transaction timeline meticulously, uncovering a discernible and consistent decline in sales revenue over the recent years.
-
Explored a comprehensive dataset comprising an impressive 150,283 sales transactions, reflecting the thoroughness of the analysis.
Quantitative Snapshot of Analyzed Data
-
Focused on 38 distinct regions within India, excluding two US states, to encapsulate a representative cross-section of the market.
Top Customer and Product Insights
-
Identifying top revenue-generating customers and their purchasing patterns facilitates tailored engagement strategies.
-
Evaluating product performance assists in reallocating resources to optimize sales and marketing campaigns and encourages proactive product portfolio management.
Phase 2: Data Visualizations
Creating a data model
Implementing a One-to-Many Relationship:
Transactions are intricately interwoven with Products, Sales, and Markets.
Tableau Dashboard
