scorecardresearch
Naukri Learning > Data Science & Analytics > Data Analysis >

Data Wrangling, Analysis and AB Testing with SQL

Data Wrangling, Analysis and AB Testing with SQL

70 Views

Course Highlights

  • 15 Hours of E-learning content, tests etc

  • Enroll for free | Pay for Certification Examination

  • Offered By University of California, Davis

  • SKILLS YOU WILL GAIN: A/B Testing, Query String, Data Analysis, Predictive Analytics, SQL

Mode of learning: Online self study

Course Overview

What are the course deliverables ?
  • WHAT YOU WILL 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

More about this course
  • This course allows you to apply the SQL skills taught in “SQL for Data Science” to four increasingly complex and authentic data science inquiry case studies. 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.

I am Interested

Curriculum

    Enquire Now

    Reviews

    Average Rating

    4.1
    Write a Review
    CompareRemove All
    Browse Category
    0

    Buy Safely with Naukri.com
    We support secure payment methods

    Disclaimer

    While Naukri Learning services have helped many customers over the years, we do not guarantee any interview calls or assure any job offers with any of our services.
    The services associated with Naukri Learning are only provided through the website Naukri.com. You are advised to be cautious of calls/emails asking for payment from other web sites that claim to offer similar services under the name of Naukri.com. We have no associates/agents other than the partner sites that have been specifically named on the homepage of the website Naukri.com. We also recommend that you Security Guidelines and Terms and Conditions