Codebasics Resume Project Challenge
Your search for resume data projects ends here!
Challenge:
Provide Insights to Management in Consumer Goods Domain
Your search for resume data projects ends here!
Provide Insights to Management in Consumer Goods Domain
Provide Insights to Management in Consumer Goods Domain
Total Enroll User: 450 | Difficulty: 2.5/5
Domain: Consumer Goods | Function: Executive Management
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. 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:
Imagine yourself as the applicant for this role and perform the following task
1. Check ‘ad-hoc-requests.pdf’ - there are 10 ad hoc requests for which the business needs insights.
2. You need to run a SQL query to answer these requests.
3. The target audience of this dashboard is top-level management - hence you need to create a presentation to show the insights.
4. Be creative with your presentation, audio/video presentation will have more weightage.
Other resources Provided:
a. Dataset required to provide
b. Metadata
c. Hints (try not to use the hints to develop your skills quicker)
d. Sample questions and Presentation
Download Problem Files
Download Files HereDifficulty : 2.5/5
Domain: Consumer Goods | Function: Executive Management
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. 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:
Imagine yourself as the applicant for this role and perform the following task
1. Check ‘ad-hoc-requests.pdf’ - there are 10 ad hoc requests for which the business needs insights.
2. You need to run a SQL query to answer these requests.
3. The target audience of this dashboard is top-level management - hence you need to create a presentation to show the insights.
4. Be creative with your presentation, audio/video presentation will have more weightage.
Other resources Provided:
a. Dataset required to provide
b. Metadata
c. Hints (try not to use the hints to develop your skills quicker)
d. Sample questions and Presentation
Download Problem Files
Download Files HereBeginners to Advanced SQL course for those preparing for a data career (data analyst, data scientist, or data engineer). This course is carefully curated to simulate real-time organizational experience to prepare you for the current job market and at the same time provides you with an ultimate learning experience through a storytelling mode that you would see in movies.
Learning knows no limits. Here’s to your journey of seamless learning. Pick your preferred course from the list of paid & free resources.
Quick Link
Help & Support
/images/1.1.419/courses/thumbnails/sql-beginner-to-advanced-for-data-professionals.webp)
Log in with Google
Log in with Linkedin