4.2 Read 93 reviews
Overview
In this Data Wrangling, Analysis and AB Testing with SQL course offered by Coursera in partnership with UC Davis we'll learn how to convert timestamps of all types to common formats and perform date/time calculations. We'll select and perform the optimal JOIN for a data science inquiry and clean data within an analysis dataset by deduping, running quality checks, backfilling, and handling nulls. We'll learn how to segment and analyze data per segment using windowing functions and use case statements to execute conditional logic to address a data science inquiry. We'll also describe how to convert a query into a scheduled job and how to insert data into a date partition. Finally, given a predictive analysis need, we'll engineer a feature from raw data using the tools and skills we've built over the course. The real-world application of these skills will give you the framework for performing the analysis of an AB test.
What you'll learn
Validate and clean a dataset
Assess and create datasets to answer your questions
Solve problems using SQL
Build a simple testing framework to touch on AB Testing
Programme Structure
Course structure:
- Map Out Your Joins
- Test Queries vs Final Queries
- Example: Create an Aggregate Table with a Rolling Date Period
- Rolling Orders (Solution)
- Find Each User's Most Recently Viewed Page for an Email Campaign
- Review Windowing Functions
Key information
Duration
- Part-time
- 1 days
Start dates & application deadlines
You can apply for and start this programme anytime.
Language
English
Delivered
Online
- Self-paced
Campus Location
- Mountain View, United States
Disciplines
Computer Sciences Software Engineering Data Analytics View 179 other Short Courses in Data Analytics in United StatesWhat students do after studying
Join for free or log in to access our complete career info list.
Academic requirements
We are not aware of any specific GRE, GMAT or GPA grading score requirements for this programme.
English requirements
We are not aware of any English requirements for this programme.
Other requirements
General requirements
- Intermediate level
- Some statistics is recommended and at least 2-years business experience.
Tuition Fees
Tuition fees are shown in and the most likely applicable fee is shown based on your nationality.
-
International Applies to you
Applies to youNon-residentsFree - Out-of-StateFree
Additional Details
- Audit: free access to course materials except graded items
- Certificate: a trusted way to showcase your skills
- A year of unlimited access with Coursera Plus $199
Funding
Coursera provides financial aid to learners who cannot afford the fee. Apply for it by clicking on the Financial Aid link beneath the "Enroll" button on the left. You'll be prompted to complete an application and will be notified if you are approved. You'll need to complete this step for each course in the Specialization, including the Capstone Project.
Improve page content