.webp&w=3840&q=100)
Industry
e-commerce
Skills
data-wrangling
Tools
sql
Learning Objectives
Debug and fix JOIN, GROUP BY, and WHERE clause issues to ensure accurate filtering and calculations.
Demonstrate knowledge of common table expressions (CTEs) to structure and simplify complex queries.
Overview
As a Senior Data Analyst at GlobalMart, you’re tasked with uncovering critical insights into the company's product catalog. Reports on product order summaries and performance are riddled with bugs, causing inaccurate outputs. It’s your responsibility to debug these queries, resolve the issues, and deliver accurate data that empowers GlobalMart to enhance customer satisfaction and operational efficiency.
Prerequisites
- Knowledge of basic SQL concepts like SELECT, WHERE, GROUP BY, HAVING, ORDER BY, and JOIN.
- Knowledge of aggregations using functions like SUM, COUNT, and AVG.
- Knowledge of CTEs and subqueries for structuring and simplifying queries.