This project was created as part of the Codebasis Resume Challenge.
AtliQ Hardwares is a product-based company that sells computers, accessories, and peripherals to customers across the globe. Recently, the management team realized they lack the data-driven insights needed to make fast and effective decisions. In order to strengthen their analytics capability, they plan to expand the team by hiring junior data analysts.
Tony Sharma, the Director of Data Analytics, designed a SQL challenge to assess both the technical proficiency and soft skills of potential candidates.
| File Name | Description |
|---|---|
Ad-hoc-requests.pdf |
Contains the list of business questions and requests which require insights |
Adhoc Requests.sql |
SQL file containing the queries and analysis used to answer the questions |
Insights.pdf |
Final presentation summarizing the insights obtained through the analysis |
Identified a 36% year-over-year increase in product portfolio, with accessories showing the highest growth, supporting product diversification insights. Uncovered that retailers contributed ~75% of total gross sales and highlighted COVID-related sales dips followed by early recovery, aiding channel and demand analysis.