Atliq-Hardware-Consumer-Goods-Insights

image

Domain: Consumer Goods | Function: Executive Management

Atliq Hardwares (imaginary company) is one of the leading computer hardware producers in India and well expanded in other countries too.

However, the management noticed that they do not get enough insights to make quick and smart data-informed decisions. They want to expand their data analytics team by adding several junior data analysts. Tony Sharma, their data analytics director wanted to hire someone who is good at both tech and soft skills. Hence, he decided to conduct a SQL challenge which will help him understand both the skills.

Video Presentation

Product Growth Comparison: 2020 vs 2021

Visual Insights
First Image Second Image

Product Count by Segment in a Technology Store

Insights
First Image

Comparison of Product Counts by Segment in a Technology Store: 2020 vs 2021

Insights
First Image

Product Information and Manufacturing Cost for Two Items in a Technology Store

Highest manufacturing cost Lowest manufacturing cost
First Image Second Image

List of Customers and Their Average Discount Percentage in a Technology Store

Top 5 Customers
First Image

Monthly Gross Sales Amount in a Technology Store from September 2019 to August 2021

Monthly Gross Sales Amount
First Image

Total Sold Quantity by Quarter in a Technology Store

Total sold quantity
First Image

Gross Sales and Percentage by Sales Channel in a Technology Company

Sales Channel
First Image

Top-Selling Products by Division and Rank Order

Top-Selling Products
First Image