Project 4: Atliq Hardware Consumer Goods Insights
By Komal Diwe
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.
Product Growth Comparison: 2020 vs 2021
| Visual | Insights |
|---|---|
 |
 |
Product Count by Segment in a Technology Store
| Insights |
|---|
 |
Comparison of Product Counts by Segment in a Technology Store: 2020 vs 2021
| Insights |
|---|
 |
Product Information and Manufacturing Cost for Two Items in a Technology Store
| Highest manufacturing cost | Lowest manufacturing cost |
|---|---|
 |
 |
List of Customers and Their Average Discount Percentage in a Technology Store
| Top 5 Customers |
|---|
 |
Monthly Gross Sales Amount in a Technology Store from September 2019 to August 2021
| Monthly Gross Sales Amount |
|---|
 |
Total Sold Quantity by Quarter in a Technology Store
| Total sold quantity |
|---|
 |
Gross Sales and Percentage by Sales Channel in a Technology Company
| Sales Channel |
|---|
 |
Top-Selling Products by Division and Rank Order
| Top-Selling Products |
|---|
 |