Provide Insights to Management in Consumer Goods Domain

This is the submission for one of the resume project challenges conducted by Codebasics.

Challenge : Provide Insights to Management in Consumer Goods Domain

Domain:Consumer Goods

Function: Executive Management

Problem Statement

Atliq Hardware is one of the leading computer hardware producers in India and well expanded in other countries too. The management noticed that they do not get enough insights to make quick and smart data-informed decisions. They want to expand their data analytics team by adding several junior data analysts. Tony Sharma, their data analytics director wanted to hire someone who is good at both tech and soft skills. Hence, he decided to conduct a SQL challenge which will help him understand both the skills.

Task

As an applicant for this role the following task need to be performed.

1.  The ‘ad-hoc-requests.pdf’ has to be checked. There are 10 ad hoc requests for which the business needs insights.

2.  SQL queries need to be run to answer these requests. 

Link to the challenge

https://codebasics.io/challenge/codebasics-resume-project-challenge

Tools Used

1.SQL Workbench : For SQL Queries

2.Power BI: For creating visuals

3.MS Powerpoint: To present the insights along with the visuals

Learnings from the Project

Learned implementing advanced sql concepts like

1. Union

2. CTEs

3. Joins

4. Pivoting tables using case and when

5. User defined variables

6. Window Functions