As a part of the challenge I have conducted Exploratory Data Analysis (EDA) to address Ad_Hoc requests and created a presentation summarizing the insights obtained. code_basics projects
- Enhance Decision-Making: Improve the quality of decision-making by providing the management with quick and data-informed insights.
- Expand Data Analytics Team: Strengthen the data analytics team by hiring multiple junior data analysts proficient in both technical and soft skills.
- Evaluate Candidate Skills: Conduct a SQL challenge to assess candidates' proficiency in technical abilities and communication, ensuring the selection of suitable candidates with a balanced skill set.
Atliq Hardwares (imaginary company) is one of the leading computer hardware producers in India and well expanded in other countries too. However, the management noticed that they do not get enough insights to make quick and smart data-informed decisions.
Meta data .provides a comprehensive overview of the tables found in the 'gdb023' (atliq_hardware_db) database. It includes information for six main tables:
- dim_customer: contains customer-related data
- dim_product: contains product-related data
- fact_gross_price: contains gross price information for each product
- fact_manufacturing_cost: contains the cost incurred in the production of each product
- fact_pre_invoice_deductions: contains pre-invoice deductions information for each product
- fact_sales_monthly: contains monthly sales data for each product.
- Provide the list of markets in which customer "Atliq Exclusive" operates its business in the APAC region.
- What is the percentage of unique product increase in 2021 vs. 2020?
- Provide a report with all the unique product counts for each segment and sort them in descending order of product counts.
- Follow-up: Which segment had the most increase in unique products in 2021 vs 2020?
- Get the products that have the highest and lowest manufacturing costs.
- Generate a report which contains the top 5 customers who received an average high pre_invoice_discount_pct for the fiscal year 2021 and in the Indian market.
- Get the complete report of the Gross sales amount for the customer “Atliq Exclusive” for each month. This analysis helps to get an idea of low and high-performing months and take strategic decisions.
- In which quarter of 2020, got the maximum total_sold_quantity?
- Which channel helped to bring more gross sales in the fiscal year 2021 and the percentage of contribution?
- Get the Top 3 products in each division that have a high total_sold_quantity in the fiscal_year 2021?