This project involved conducting a detailed analysis for Atliq Hardwares (imaginary company) , a leading producer of computer hardware in India, which has also expanded its operations to various countries globally.
The management realized they were lacking the necessary insights to make quick, data-driven decisions. To address this, they decided to expand their data analytics team by hiring several junior analysts. Tony Sharma, the Data Analytics Director, aimed to find candidates proficient in both technical and soft skills, leading him to design a SQL challenge to evaluate these capabilities.
In this project, I used MySQL for data querying and manipulation, and Power BI to create clear and effective visualizations.
- AtliQ Exclusive has expanded into 8 major markets in the APAC region, showcasing its growing international presence.
- Continuous innovation led to a 36% increase in the number of products offered, from 245 in 2020 to 334 in 2021.
- The segments of Notebooks, Accessories, and Peripherals are experiencing rapid growth, meanwhile, Desktop Storage and Networking products are seeing slower growth.
- AQ HOME Allin 1 Gen 2 Personal Desktop has the highest production cost, while AQ Master wired x1 Ms Mouse has the lowest.
- Flipkart, Viveks, Ezone, Croma and Amazon are the top 5 customers who received the highest average pre-invoice discount percentages during FY 2021.
- Sales hit a low in March 2020 but recovered by August, surpassing pre-pandemic levels by year-end.
- Q1 FY 2020 had the highest sales, while Q3 had the lowest.
- Retailers contributed to 75% of total sales, with distributors and direct sales accounting for a smaller portion.
- Pen drives (700,000 units), mouse devices (400,000 units), and personal laptops (17,000 units) were the best selling products.
- Leverage data analytics to better understand consumer preferences and purchasing patterns to tailor products and marketing strategies accordingly.
- Explore new product opportunities that align with emerging consumer demands.
- Implement dynamic pricing models based on demand and competition and improve inventory management.
- Diversify sales channels.
- Improve product recommendations and promotions based on customer behavior and market trends.