Data Analytics Core Course - Cracking Product

About Course

Welcome to our comprehensive course, featuring over 50+ videos, 100+ problem statements, and 3 capstone projects. This meticulously crafted program is designed to cater to both beginners venturing into the field of Data Analytics and individuals seeking to delve into advanced concepts such as SQL, Product Thinking, and Case-based problem-solving.

Our curriculum encompasses a fundamental introduction to analytics, with dedicated modules for SQL, Excel, Product Sense, Tableau, and Capstone Projects. Drawing from our live classroom lecture series conducted in 2023, the course offers high-quality video lectures, practice problem sets, lecture PDFs, and engaging capstone projects which will help you build a solid profile for your analytics journey.

Enrollment in this course allows for a self-paced learning experience. We encourage you to register promptly and embark on your journey of transitioning into the field of data analytics.

Best Regards

Course Content

Module 1 : Introduction to Data analytics
This lecture deals with understanding the fundamentals of data analytics. How is data used in industry and what are the key skills required to become a good data analyst.

Course Intro Page

Module 2 : SQL Basics

Module 3 : SQL Advanced

Views/Temporary Tables/CTE/Subquery

01:05:32
Introduction to Joins

01:26:06
Joins Continued

01:34:02
Problem Solving Session : Joins-1

01:06:39
Problem Solving Session : Joins-2

01:39:49
Window Functions Part-1 (Ranking/Aggregation)

01:23:00
Window Functions Part-2 : Value Functions

01:38:58
[Solution Discussion] SQL Window Functions Practice Problems

01:20:23
SQL Module Wrap, Module Assignment Solution Approach Discussion.

50:01
SQL Functions (Resources)

00:00

Module 4 : MS Excel for analytics

Module 5 : Introduction to Product Analytics

Product Metrics Fundamentals

01:13:49
Customer Acquisition Metrics

01:17:43
Monetization & Engagement Metrics

01:13:56
Customer Support Metrics

01:25:21
Product Metric Assignment Solution Discussion

51:52
User Journey & Funnel Analysis

01:04:44
Product Case Studies Fundamental

01:09:19
Product Case Study Assignment Solution Discussion

01:20:32
Case Study Materials

00:00

Module 6 : Tableau for Dashboarding

Module 7 : Capstone Project-1 (EV Sales Analytics)

Module 8 : Capstone Project-2 (EV Sales Dashboarding)

Module 9 : Resume Grooming/Mocks

Module 10 : Interview Preparation

Module 11 : Applying for Jobs

Student Ratings & Reviews

No Review Yet

About Course

What Will You Learn?

Course Content

Module 1 : Introduction to Data analytics This lecture deals with understanding the fundamentals of data analytics. How is data used in industry and what are the key skills required to become a good data analyst.

Course Intro Page

Module 2 : SQL Basics

Getting Started with Databases and SQL

Basics of Table Relationships and Structures

MySQL Workbench Setup and Simple Queries

ER Diagrams & Introduction to NoSQL Databases

Database Normalization, Table Creation and Insertion, Intro. to “Group by”

Group by Clause, Aggregation Functions, Having Clause.

Topic Recap (Group by & CASE statement)

Module 3 : SQL Advanced

Views/Temporary Tables/CTE/Subquery

Introduction to Joins

Joins Continued

Problem Solving Session : Joins-1

Problem Solving Session : Joins-2

Window Functions Part-1 (Ranking/Aggregation)

Window Functions Part-2 : Value Functions

[Solution Discussion] SQL Window Functions Practice Problems

SQL Module Wrap, Module Assignment Solution Approach Discussion.

SQL Functions (Resources)

Module 4 : MS Excel for analytics

Basic Functions : Absolute Reference, Sum If, Count IF

VLOOKUP, Left, Right Functions

Assignment 2 & 3 Solution Discussion

Pivot Table Complete Understanding

Unique Function, Index Match Function, Assignment 3 Solution

Assignment Resources

Module 5 : Introduction to Product Analytics

Product Metrics Fundamentals

Customer Acquisition Metrics

Monetization & Engagement Metrics

Customer Support Metrics

Product Metric Assignment Solution Discussion

User Journey & Funnel Analysis

Product Case Studies Fundamental

Product Case Study Assignment Solution Discussion

Case Study Materials

Module 6 : Tableau for Dashboarding

Introduction to dashboarding

Downloading and Installing Tableau Desktop

Fruit sales analysis : Pie charts and calculated fields

Fruit sales analysis : Bar and line charts | Tables

Fruit sales analysis : Time series trend and assembly of a dashboard

Module 7 : Capstone Project-1 (EV Sales Analytics)

EV sales analysis : Understanding the problem statement & Basic EDA

EV sales analysis : Sales drop analysis solutions

Module 8 : Capstone Project-2 (EV Sales Dashboarding)

Module 9 : Resume Grooming/Mocks

Module 10 : Interview Preparation

General HR Interview Questions

Advance SQL Interview Questions

Business Case Study Round Interview Questions

Case Study Preparation (Complementary )

Module 11 : Applying for Jobs

Student Ratings & Reviews

Module 1 : Introduction to Data analytics
This lecture deals with understanding the fundamentals of data analytics. How is data used in industry and what are the key skills required to become a good data analyst.