🧾 Consumer Goods – AtliQ Hardwares (Case Study)

📌 About AtliQ Hardwares

AtliQ Hardwares is a top (hypothetical) computer hardware company based in India with a growing global presence. The company offers a wide range of hardware products and focuses on using data-driven decision-making to stay competitive.

---

🚩 The Problem

AtliQ was facing challenges in making quick, data-backed decisions due to their heavy reliance on Excel-based reporting. To overcome this, they aimed to strengthen their analytics team by hiring junior data analysts with strong technical and communication skills.

---

👨‍💻 My Role & Responsibilities

As part of this case study project, my responsibilities included:

• 📄 Understanding Business Needs: Analyzed ad-hoc-requests.pdf containing 10 business problems.
• 🔍 Data Querying with SQL: Wrote SQL queries to extract relevant data.
• 📊 Presenting Insights: Created a PowerPoint deck with insights tailored for senior management.

---

⚙️ My Approach

• Used MySQL to query databases and gather accurate data.
• Ensured data integrity using validation methods.
• Delivered actionable insights aligned with each business need.

---

🌟 Key Insights & Learnings

• Improved SQL proficiency for real-world data processing.
• Gained business analysis experience through scenario-based questions.
• Learned to communicate insights through clear and concise presentations.
• Developed a structured approach to transforming raw data into decision-ready insights.

---

📁 Repository Structure

File Name	Description
Consumer Goods of AtliQ Hardwares.sql	SQL script for data extraction and processing
Consumer Goods of AtliQ Hardwares.txt	Business insights and dataset overview
Hints.pdf	Hints and tips to guide SQL logic
Metadata.txt	Table structures and relationships
ad-hoc-requests.pdf	10 business scenarios requiring analysis
demo_sql_queries.txt	Sample SQL queries used for exploration

---

🛠️ How to Use

1. Open your MySQL environment.
2. Run Consumer Goods of AtliQ Hardwares.sql to extract the required data.
3. Use supporting files like Hints.pdf, Metadata.txt, and demo_sql_queries.txt for guidance.

---

🎯 Why This Project Matters

This case study demonstrates my ability to:

• Tackle real business challenges using SQL and analytical thinking.
• Present insights that directly support business decisions.
• Bridge the gap between raw data and meaningful outcomes.

---

Feel free to explore this repository. For any questions or discussions, don't hesitate to reach out!