Enqurious LogoTM

Use coupon code 'ENQSPARKS25' to get 100 credits for FREE

0
0
Days
0
0
Hours
0
0
Minutes
0
0
Seconds
Go back

Fundamentals of Data Wrangling using SQL

3 Scenarios
3 Hours
masterclass poster
Industry
e-commerce
Skills
data-wrangling
Tools
sql

Learning Objectives

Get familiar with SQL Data Definition language
Be able to SELECT data in multiple ways
Be able to filter data with WHERE clause
Be able to write conditional logic in SQL
Be able to perform simple aggregations, text processing, and date processing on data

Overview

Amazon, a major e-commerce player, has been using Excel to manage their growing data from over 2000 customers and 5000 orders. However, they're hitting Excel's limits in data analysis and scalability, making it tough to deeply understand trends and make quick, informed decisions.

To overcome these limitations, Amazon is transitioning to SQL and databases, which offer more robust and scalable data management. This change will empower them to:

  • Organize data more effectively across a scalable platform.
  • Conduct in-depth analyses with advanced SQL queries.
  • Generate dynamic reports and visualize data trends to better understand market behaviors and customer needs.

In this self-paced module, we'll explore how this transition can transform Amazon's operations. We'll cover:

  • Essential data operations in SQL for managing large datasets.
  • Techniques for processing text and dates in SQL to gain finer insights and improve operational efficiency

Prerequisites

  • Data Analysis using Excel