PREMIUM

Master Data Analytics in SQL & Excel

10 hrs 39 coding exercises 4 projects

Master Data Analytics with SQL and Excel. Learn data preparation, advanced querying, PivotTables, and Explanatory Data Analysis that equips you to solve real-world business challenges.

$60 $120 50% off

Start Learning

Preview Course

Resolve doubts with AI Mentor

Guided Projects for hands-on learning

Coding Exercises with AI hints

Personalised Mock Interviews

Skills you will gain

Data Analytics

SQL Querying

Data Cleaning

Joins

Subqueries

Window Functions

Excel Functions

Pivot Tables

Dashboards

EDA

Business Case Studies

AI-powered support to help you learn

AI Mentor
Resolve doubts using AI Mentor
AI Mentor answers questions, explains topics, and provides examples to help you understand concepts better.

Coding Exercises
Practice coding exercises effortlessly with AI-powered hints
Get real-time AI guidance while coding. Debug, enhance solutions & learn with personalised feedback on popular languages.

Mock Interviews
Get personalised feedback and prepare for roles in tech
Enhance your professional skills with AI-powered feedback and build confidence for job interviews.

Get exclusive access to premium features and personalised learning

Start Learning

Guided Projects

Solve real-world projects with a step-by-step guide, starter code templates, and access to model solutions to boost your skills and build a standout resume.

GUIDED PROJECT 1
AeroMax Airways: Data-Driven Insights for Optimizing Airline Operations and Passenger Experience
This project involves analyzing a large dataset from the aviation sector, including flight delays, passenger demographics, ticket pricing, and operational costs. Participants will uncover insights into flight delays, identify congested airports, analyze passenger satisfaction trends, and evaluate financial performance. The project emphasizes data cleaning, processing, and visualization to derive actionable recommendations for improving punctuality, enhancing customer experience, and optimizing profitability in the airline industry.

Data Analysis

Data Cleaning

Data Processing

PivotTables

Data Visualization

Statistical Analysis

Customer Insights

GUIDED PROJECT 2
StellarMart Analytics: Optimizing Retail Performance Through Data Insights
This project focuses on analyzing a retail dataset from StellarMart to identify sales trends, seasonal patterns, regional performance, and underperforming product categories. We will clean and process data, create dynamic visualizations, and generate actionable insights to support strategic decisions and drive profitability. Deliverables include an organized Excel workbook with cleaned data, aggregated metrics, and visualizations tailored for retail analytics

Data Analysis

Excel

Data Cleaning

Data Processing

PivotTables

Data Visualization

Sales Trend Analysis

Seasonal Trends

Regional Performance

Statistical Functions

Retail Analytics

Customer Insights

Business Intelligence

GUIDED PROJECT 3
DVD Rental Store: SQL-Driven Exploratory Data Analysis
Leverage MySQL to perform Exploratory Data Analysis (EDA) on a dataset representing a DVD rental store. Execute SQL queries to uncover insights related to film popularity, customer behavior, rental trends, and revenue generation. Identify the most rented films, top-paying customers, busiest rental periods, and the most profitable categories, while also assessing staff performance and store efficiency. This project focuses on SQL-based data analysis without using external visualization tools, ensuring actionable insights directly from database queries.

SQL

Data Analysis using SQL

Joins & Aggregations

Window Functions

Subqueries

MySQL

Query Optimization

Analytical Queries

Data-driven Decision Making

GUIDED PROJECT 4
World Demographics and Economics: SQL-Based Data Analysis
Utilize MySQL to perform Data Analysis on a database which contains structured information about countries, cities, and languages. Execute SQL queries to analyze global population distribution, economic indicators, linguistic diversity, and geographic classifications. Gain insights into top populated countries, economic rankings, most spoken languages, and GDP variations. Investigate population distribution across continents, the largest and smallest cities, and the correlation between population size and life expectancy. This project focuses solely on SQL-based data analysis to derive meaningful global insights.

SQL

Data Modeling

Normalization & Indexing

Geographic Data Analysis

Statistical Queries

Data Aggregation & Filtering

Industry-focused curriculum

Introduction to Data Analytics

2 Videos

Basics of data analytics and it's phases

2 videos

20 mins

Introduction to Data Analytics
Phases of Data Analytics Project

Preview module

SQL Basics

12 Videos

13 Coding Exercises

1 Quiz

Cleaning and validating data with Excel and SQL

12 videos

1 hour 34 mins

Introduction to Databases and DBMS
Types of DBMS
More on DBMS
Keys in RDBMS
Types of Commands in SQL - DDL and DML
Types of Commands - Demonstration
More SQL Commands
Filtering and Operators - Demonstration
Operators and Pattern Matching - Demonstration
Group By, Having and Order By Clause
Aggregate Functions - Demonstration
Normalization in RDBMS

13 Coding Exercises

Coding Exercise on Filtering and Operators - Beginner
Coding Exercise on Operators and Pattern Matching - Beginner
Coding Exercise on Aggregate Functions - Beginner

1 Quiz

Quiz to test your understanding of SQL Basics

Advanced SQL Techniques

6 videos

22 Coding Exercises

1 Quiz

Querying, filtering, aggregations, and joins in SQL.

6 videos

50 mins

Alias and Joins in SQL
Joins Demonstration
Subquery in SQL
Subqueries - Demonstration
Window Functions Concepts
Window Functions Hands-on

22 Coding Exercises

Coding Exercise on SQL Joins - Beginner
Coding Exercise on SQL - Beginner
Coding Exercise on SQL - Advanced

1 Quiz

Quiz to test your understanding of SQL Advance concepts

Case Study : Playstore Ad Revenue

5 videos

End-to-end Business Analytics Case Study on Playstore Ad Revenue

5 videos

40 mins

Case Study Introduction
Business Context and Problem Definition
How to approach the solution?
SQL Workbench Data Understanding
SQL Workbench Data Preprocessing

Guided SQL Project 1: DVD Rental Store

Guided Project 1

DVD Rental Store Project : Functional requirements and step-by-step guide

Guided SQL Project 2 : World Demographics and Economics

Guided Project 2

World Demographics and Economics Project : Functional requirements and step-by-step guide

Fundamentals of Excel in Data Analytics

11 Videos

1 Quiz

Subqueries, window functions, and advanced aggregations

11 videos

1 hour 20 mins

Introduction to Excel
Excel Navigation
Rows, Columns & Cells
Basic Math with Excel
Boolean Operations
Cell Referencing
Information Functions
Counting
Filtering & Sorting
Finding & Searching Text
Joining Text

1 Quiz

Quiz to test your understanding of excel fundamentals

Data Handling and Analysis in Excel

7 videos

1 Quiz

Excel functions, conditional operations, and data manipulation

7 videos

1 hour and 14 mins

Basics of Date and Time
Finding Difference Between Dates
Advanced Text Operations
Conditional Operations
Aggregation
Conditional Aggregation
Indexing & Matching

1 Quiz

Data handling quiz to test your understanding

Data Cleaning, Analysis, and Visualization in Excel

6 videos

1 Quiz

Data Cleaning, Analysis, and Visualization in Excel

6 videos

1 hour and 15 mins

Data Cleaning using Functions
Conditional Formatting
Data Validation
Lookup Functions in Excel
Pivot Tables
Data Visualization using Excel

1 Quiz

Quiz to test your understanding of Data Cleaning and Analysis

Exploratory Data Analysis (EDA)

10 videos

1 Quiz

Conducting univariate, bivariate, and multivariate analysis using Excel.

10 videos

2 hours

Introduction to Exploratory Data Analysis with Excel
Problem Statement
Data Understanding
Questions & Hypothesis
Data Cleaning & Manipulation
Univariate Analysis
Exploratory Data Analysis- Hands-on- Part 1
Exploratory Data Analysis- Hands-on- Part 2
Exploratory Data Analysis- Hands-on- Part 3
Quick peek into the final insights

1 Quiz

Quiz to test your understanding

Guided Excel Project 1 : E-Commerce

Guided Project 1

E-Commerce Project : Functional requirements and step-by-step guide

Guided Excel Project 2 : Aviation Sector Analysis using Excel

Guided Project 2

Aviation Sector Analysis Project : Functional requirements and step-by-step guide

SQL Developer and Excel Specialist - Mock Interview

2 Mock Interviews

2 Personalised Mock Interviews to help you land a SQL Developer or an Excel Specialist role

Course instructors

Dr. Bradford Tuckfield

Founder - Kmbara & Data Science Consultant

Dr. Bradford Tuckfield is a Data Science Consultant at his company, Kmbara, where he provides automated, data-centric solutions in domains like Manufacturing, Pharmaceuticals, Marketing, and Technology. He is also an author, has written books on Data Science, Computer Science, and Algorithms, and works as an instructor at ViaX and Great Learning. Dr. Bradford completed his Doctor of Philosophy (Ph.D.) from the Wharton School in Operations and Information Management. He comes from a background in Mathematics and Economics and has wide expertise in Data Science, including Statistics, Programming, and Machine Learning.

Dr. Bradford Tuckfield

Founder - Kmbara & Data Science Consultant

Denver Dias

Senior Data Science Consultant

Data Science Leader with over 8 years of experience in building advanced Machine Learning models and leveraging Data Engineering skills to facilitate data-driven decision-making. Proven track record of delivering high-impact solutions for Fortune 500 clients, leading cross-functional teams, and generating substantial cost savings. Currently working with Getty Images to revamp their A/B Testing platform to better measure the effectiveness of newly developed algorithms and experiments in production.

Denver Dias

Senior Data Science Consultant

Gaelim Holland

Senior Data Analyst | Power BI Expert | Data Visualization | Data Scientist

Gaelim is an innovative Data Analyst and Data Scientist with extensive expertise in omnichannel analytics, integrating both online and offline data in funnel analysis. Highly skilled in optimizing online sales, revenue, and call-to-actions through conversion rate optimization, statistical science, and A/B testing, Gaelim has a deep command of statistical testing tools, data extraction, and data science. With aspirations to take on managerial or consulting roles, Gaelim seeks to apply their expertise in data-driven marketing, targeted acquisition, and data science to drive impactful results.

Gaelim Holland

Senior Data Analyst | Power BI Expert | Data Visualization | Data Scientist