The Complete Roadmap to Data Analyst

About Course

While data is the backbone of every successful business today, finding the right guidance to become a skilled data analyst can be a challenge. If you’re passionate about building a career in data analytics, this course is your roadmap to success.

Through this course, Kanav Taneja shares his expertise from over 15 years in data analytics and his role as an Analytics Manager with a top telecom company.

Drawing from his vast experience in analyzing complex data and mentoring professionals, Kanav provides not just the tools but also the practical insights needed to secure your first job in data analytics and thrive in your career.

This course is designed to help aspiring data analysts transition from learning to earning, with step-by-step guidance on mastering essential skills, working on real-world projects, and building confidence to succeed in high-demand roles.

This course is designed to transform you from a beginner to a job-ready Data Analyst, equipped with the practical skills, business understanding, and analytical mindset that today’s companies demand.
✅ Key Takeaways from the Course:
Master Core Data Tools: Gain hands-on experience in Microsoft Excel, Power BI, SQL, and Python—tools used every day by top analysts across the world.
Solve Real Business Problems: Learn how to analyze, interpret, and visualize real-world datasets across domains like Marketing, Sales, and Operations.
Learn Industry-Relevant Metrics: Understand KPIs like CAC, CLTV, ARPU, Retention Rate, and more—critical for making informed business decisions.
Build Dashboards from Scratch: Design and present interactive dashboards using Power BI and Excel to tell compelling stories with data.
Automate Your Workflows: Learn how to clean and transform raw data using Power Query and Python, improving efficiency and accuracy.
Write SQL Queries Like a Pro: Master querying techniques to extract insights from complex datasets and relational databases.
Apply Your Learning Through Projects: Work on capstone projects and mini-case studies that simulate real business scenarios.
💼 Job-Ready Support Beyond Learning
Learning is only part of the journey—we go one step further to help you land the job.
🔗 Job Portal Access – jobs.theknowledgecastle.com
Apply to curated job listings tailored for data analysts and fresh graduates
AI-powered Mock Interviews: Practice interviews based on your profile and the job description, with real-time feedback on your answers
Profile Showcase: Build a standout profile and get discovered by recruiters directly on the platform
Quiz & Certification: Test your skills through in-course quizzes, and earn a certificate upon passing
🚀 Our Mission
At The Knowledge Castle, we don’t just train you—we guide you from learning to earning. This course is your first step towards a successful career in data analytics.

Course Content

Welcome To Data Analyst Roadmap!
This is the beginning of new journey

Day Zero: Your Data Analyst Journey Begins

12:58
How to Get Started – Navigating The Knowledge Castle

04:08
Setting Up for Success: Installing Your Data Analytics Toolkit

08:48

SQL Theory

DDL Theory

TCL Theory

DML

DCL

Database Terminologies

Creating Database

Data Type

Constraints

Constraints Intro

01:19
Auto Increment

00:53
Primary Key

05:02
Foreign Key

08:20
Foreign Key on Delete Cascade

05:23
Unique Key

03:33
Index in Unique Key

01:07
Default Constraint

02:44
Not Null Constraint

02:21
Drop Primary & Foreign Key

02:58
Drop Unique Key

00:50
Using Database

03:31

SQL Best Practice

Sales DDL Exercise

Employees Database

DDL

Select Intro

02:00
Where conditions

01:37
Where Exercise

00:17
Where Solution

00:29
Multiple Filter Operator

00:39
And Clause

01:25
Or Clause

02:47
Operator Precedence

09:47
Operator Precedence Exercise

00:13
Operator Precedence Solution

01:07
In Filter

02:23
Not in

00:49
In Solution

00:42
Like Not Like

03:33
Between Not Between

02:32
Is Null Not Null

01:22
Other Comparison Operators

02:43
Select Exercise

00:23
Select Solution

01:13
Select Distinct

01:27

Aggregate Functions

Intro to Aggregate Functions

00:54
Count()

03:10
Count Distinct

03:20
Count Exercise

00:30
Count Exercise Solution

02:13
Group by

04:48
Alias

00:42
Order by

02:36
Having

01:13
Where vs Having

07:01
Where vs Having Exercise

00:29
Where vs Having Exercise Sol

03:13
Limit

01:38

The Insert Statement

TCL Statements

Aggregate Functions in Detail

Count Function in detail

04:02
Sum Function in detail

01:14
Sum Solution

00:44
Min & Max

01:13
Min & Max Solution

00:58
Avg Function

01:26
Round Function

01:10
Coalesce & If Null Task

00:58
Coalesce & If Null Solution

03:21
Coalesce

05:46
If Null

01:44

SQL Joins

Joins Intro

01:31
Joins Preamble

01:06
Joins Preamble Solution

05:48
Inner Join

07:05
Inner Join Solution

03:06
Handle Duplicate Records in Joins

06:37
Left Join

04:39
Right Join

02:26
Join Exercise

00:32
Join Exercise Solution

02:09
Join & Where Together

02:55
Join & Aggregate functions

02:06
Joins with Multiple Tables

04:35
Joins Exercise

00:38
Joins Multiple Table Exercise Solution

05:01

Union vs Union all

Sub Query

Sub Query Introduction

02:58
Sub Query Nested in

04:31
Sub Query Self Join

09:40
Sub Query Nested Task

00:19
Sub Query Nested Solution

01:08
Sub Query & Union Task

01:13
Sub Query & Union Solution

06:46
Sub Query Latest Salary Task

00:29
Sub Query Latest Salary Solution

02:17
Sub Query Create Table Task

01:22
Sub Query Create Table Solution

07:36

SQL Views

Stored Routines

Triggers

Windows Functions

Final Exercise

Excel Introduction

Excel Course Structure

Navigate Excel Ribbons

Open New and Save a File

Enter Text in Workbook

Formatting the Text

Autofill Rewrite & Edit

Copying & Pasting

Change Borders & Background Colors

Merge Cells & Find, Replace

Data Type

Sheets

Rows and Columns

Inserting & Deleting Rows

Freeze Panes

Formulas & Reference Cells

Formulas Rule

Name Manager

Lock Cells

Refer other Worksheets & Books

Circular Reference

VLOOKUP

Index & Match

Power Functions

Errors

If & Logical

Offset

Indirect

Data Validation

Text Functions

Indirect & Offset Together

Sorting

Filters

Pivot Tables

Conditional Formatting

Charts

Power BI Data Literacy

Chart Types

Rotten Tomatoes Data Understanding

04:13
What is Bar Chart

01:45
Power BI Interface

00:56
Loading Your first Data

03:12
Creating Bar Chart

05:05
What is Line Chart

02:39
Line Chart in Power BI

01:04
Categories in Line Chart

01:08
Line Chart Activity

01:48
What is Stacked Bar Chart

02:07
Stacked bar Chart in Power BI

01:31
Stacked Bar Chart Activity & Solution

02:52
What are Tree Maps

02:00
Tree Maps in Power BI

02:50
Tree Maps Activity & Sol

01:26
Combined Axis or Clustered Column Chart

00:47
Combined Axis or Clustered Column Chart in Power BI

00:53
Clustered Column Chart activity & Sol

01:41
Scatter Plots

05:52
Scatter Plots in Power BI

01:48
Scatter Plots Activity & Sol

01:08

Project 1 Starting with Power BI

Building Visuals Reports

First Report in Power BI

Report Designing & Layout

07:03
Sales Page

09:28
Drill Down with Date Fields

07:46
Hierarchy

03:47
Hierarchy challenge & Solution

01:03
Adding Custom Visuals

06:31
Sync Slicers

02:47
Sorting in Visualizations

01:56
AI Visuals Narrative

02:34
AI Visuals QnA Visual

07:13
Finalizing Product Page

03:02
Tooltips

05:51
Tooltips Solution

02:31
Table Formatting & Map Visuals

06:49
Line Chart solutions for Ship Modes

01:52
Dynamic Titles

03:22
Dynamic Title Solution

00:47
Page Navigator

06:29

Publishing First Report

Expert Lane

Expert Project Scoping

02:56
Uploading Master File

06:45
Budget Table Transformations

01:31
Pivot vs Unpivoted Data

07:59
USA Sales – Folder Upload

07:16
Australia Sales – Folder Upload

07:23
Argentina Sales – Folder Upload

06:34
Challenge for other Sales Regions

00:21
Solution for other Sales Regions

01:12
Append Queries

06:59
Splitting & Merging Tranformations

02:34
Conditional Columns

02:53
Add Columns from Example

02:13
Choose columns – Loading the Data in Model

03:20

Data Modeling Concepts

Data Categories

04:58
Relationships Filters Data

07:15
Not all Tables are Related

01:28
Relationships between all Tables

02:04
Budget with Stores

00:41
Budget & Sales Together – Many to Many Confusion

10:27
Dynamic Calendar Table Requirement

02:46
Create Dynamic Calendar Table

14:58
Sorting from another Fields

04:24

Data Model Deep Dive

DAX

DAX Intro

03:32
DAX Implicit vs Explicit

06:14
DAX Count Rows

02:23
DAX Filter Context

07:58
DAX Iterator Functions SUMX

12:59
Introduction to DAX VAR

14:05
Discount % Using VAR in DAX

06:18
Divide Function (Gross Margin)

04:13
Dedicated Table for Measures

05:54
DAX Calculate Intro

06:44
Calculate Filter Modifiers

10:11
Using Relationship Calculate Modifier

05:34
DAX Time Intelligence Functions

14:46
Sales Current Year

15:29

Building The Reports

Store Overview

Budget

Overview

Finalizing Reports

Power BI Service

VBA Introduction

VBA Environment

File Types & Object Model

Object Model

Record a Macro

Object Library & VBA

Special Cells

Absolute vs Relative Reference

Trigger Macro

Delete Comments

Reference Cells

Most used Properties

use of Range Properties

Copy & Resize Properties

Reference Worksheets

Reference Workbook

Range Test

What is Variables

Object Variables

Saving Workbook with Variables

With Block

For Each Loop Collections

Simple IF

IF and OR Clause

Nested If Clause

VBA Functions & Exit Sub

MsgBox

VBA Input Box

Excel Input Box

Debugging the Code

Error Handling

Calling Procedures

For Loop

For Nested Loop

Do While Loop

Working with DIR & Folders

GetOpenFileName

FileDialog Loop

Workbook Events

Worksheet Event

User Forms

Project Expense Sharing

Getting Started With Python
This is Your Python Class. Please Note These videos will be changed soon, based on recent feedbacks received. Thank you for your patience.

Quiz

Student Ratings & Reviews

No Review Yet

About Course

What Will You Learn?

Course Content

Welcome To Data Analyst Roadmap! This is the beginning of new journey

Day Zero: Your Data Analyst Journey Begins

How to Get Started – Navigating The Knowledge Castle

Setting Up for Success: Installing Your Data Analytics Toolkit

SQL Theory

SQL Intro

Database Introduction

SQL Syntax

SQL Object

DDL Introduction

DDL Theory

The Create Statement

The Alter Statement

The Drop Statement

The Rename Statement

The Truncate Statement

DDL Recap

TCL Theory

TCL Theory

TCL Commit

TCL Rollback

TCL Recap

SQL Syntax Recap

DML

DML Intro

Select Statement

Insert Statement

Update Statement

Delete Statement

DML Recap

DCL

DCL Grant

DCL Revoke

SQL Keyword

Database Terminologies

Database Terminologies

Database Design

Relationships

Primary Key

Foreign Key

Unique Key

Primary Key vs Unique Key

Creating Database

SQL Interface

Create Database

Create Table

Data Type

Data Type Intro

Text Data Type

Numbers Int

Float Numeric

Floating Double Data Type

Date Time

Date Type Recap

Other Useful Data Type

Constraints

Constraints Intro

Auto Increment

Primary Key

Foreign Key

Foreign Key on Delete Cascade

Unique Key

Index in Unique Key

Default Constraint

Not Null Constraint

Drop Primary & Foreign Key

Drop Unique Key

Using Database

SQL Best Practice

SQL Best Practice

Sales DDL Exercise

DDL Sales Exercise

DDL Sales Exercise Solution

Employees Database

Employees Script

Employee Schema

DDL

Welcome To Data Analyst Roadmap!
This is the beginning of new journey