/Ad-hoc-Insights-in-Consumer-Goods-Domain

Ad-hoc-Insights-in-Consumer-Goods-Domain 🚀

Introduction 📊

This exciting project, part of the Codebasics Data Analyst Bootcamp, aimed to empower Atliq Hardwares with quick, data-driven decisions. Our focus was on addressing ad-hoc queries through advanced SQL, targeting top-level management.

SQL Challenge - Insightful Queries 📈

We harnessed the power of advanced SQL concepts—Joins, Subqueries, CTEs, and Window functions. Automation, using Stored Procedures and Views, was a key component. Domain knowledge on fiscal year, quarters, and profit & loss statements enriched our analysis.

Major Insights 🌟

  1. Market Presence 🌐

    • Croma exclusively operated in the Indian market.

  2. Sales Growth 📈

    • Croma India experienced a whopping 180% sales increase in FY 2021.

  3. Product Portfolio Expansion 🛍️

    • The percentage of unique products increased by 36.33% in 2021 compared to 2020.

  4. Segment-wise Product Increase 🚀

    • Accessories and Networking segments saw the highest (34) and lowest (3) increase in unique products, respectively, in 2021 vs. 2020.

  5. Manufacturing Cost Variations 💰

    • AQ HOME Allin1 Gen 2 and AQ Master wired x1 Ms had the highest and lowest manufacturing costs, respectively.

  6. Top Customers and Discounts 🏷️

    • The top 5 customers with the highest average pre-invoice discount percentage in FY 2021 (India) were Flipkart, Viveks, Ezone, Croma, and Amazon.

  7. Product Quantity Sold 📦

    • In FY 2020, Q1 (Sep-Nov 2019) and Q3 had the maximum and minimum sold quantity of products, respectively.

  8. Top Products in Divisions 🏆

    • For FY 2021, the top 3 products in the N&S, P&A, and PC divisions were pen drives, mouse, and personal laptops, respectively.

Presentation 🎉

Our findings were creatively presented in a visually engaging PowerPoint. Each insight was spotlighted with clear visuals, adding charts and graphs for that extra punch.

Conclusion 🌐

This project not only cracked the ad-hoc requests but showcased our prowess in advanced SQL and domain knowledge. Automation ensures that our analysis is not just insightful but also scalable and sustainable.

In conclusion, we've armed Atliq Hardwares with a robust tool for strategic decision-making. Let the growth journey begin! 🚀