Provide Insights to Management in Consumer Goods Domain

About

This project involves data analysis and visualization in the Consumer Goods domain. It includes SQL queries, data insights, and visualizations to support decision-making for a hypothetical company, Atliq Hardwares, in the computer hardware industry.

Features

• SQL queries and data analysis to address specific business questions.
• Creation of visualizations to present data insights effectively.

Project Structure

The project structure is organized as follows:

• Inputs/:
  • ad-hoc-requests/: A PDF document which contains the Ad-Hoc Requests
  • atliq_hardware_db/: A SQL file which contains the Queries for the creation of the database
  • demo_sql_queries/: A demo file for help
  • Hints/: Hints on how to approach the Ad-Hoc Requests
  • Metadata/: This file provides a comprehensive overview of the tables found in the 'gdb023' (atliq_hardware_db) database.
  • sample_challenge_presentation/:
  • support document for beginners:
• Ad_hoc Queries/: The Solution to the Ad-Hoc Requests
• README.md: The project's documentation (this file).

Ad-Hoc Requests

Below are the ad-hoc requests that this project addresses along with their outputs as images:

1. List of Markets in APAC for Customer "Atliq Exclusive"

   

2. Percentage Increase in Unique Products (2021 vs. 2020)

   

3. Unique Product Counts by Segment (Descending Order)

   

4. Segment with the Most Increase in Unique Products (2021 vs. 2020)

   

5. Highest and Lowest Manufacturing Costs

   

6. Top 5 Customers with High Pre-Invoice Discount (FY 2021, Indian Market)

   

7. Gross Sales Amount for Customer "Atliq Exclusive" by Month

   

8. Quarter with Maximum Total Sold Quantity (2020)

   

9. Channel Contribution to Gross Sales (FY 2021)

   

10. Top 3 Products by Division with High Total Sold Quantity (FY 2021)

    

Technologies Used

•