Data Analyst with AI (Batch-11)

Introductory Class

Data Analyst (Batch-11) – Introductory Class

02:14:08

Class 01 – Power BI Intro | Ribbons | Data Sources | Power Query Overview

Class 02 – ETL | Advanced Data Cleaning with Power Query

Class 03 – Power Query | Conditional Columns | Column from Examples | Data Tools | Date Calculations | Group By | Advanced Filtering & Sorting

Class 04 – Power Query: Parameters | Append Queries | Folder Selection | Data Normalization | Data Modeling

Class 05 – Data Modelling Intro | Data Concepts | Fact vs Dimension | Star, Snowflake & Galaxy Schema | Data Formatting

Class 06 – Calculated Columns | Text Functions (LEFT, RIGHT, UPPER, LOWER, CONCAT) | Date Functions (DAY, MONTH, YEAR, DATEDIFF, TODAY, WEEKDAY, WEEKNUM) | SUBSTITUE, FIND, SEARCH, Dynamic LEFT & RIGHT

Class 07 – Calculated Columns | Logical Operators | IF, Nested IF | SWITCH (with TRUE) | AND, OR | Dynamic Formulas

Class 08 – Calculated Measures | Implicit vs Explicit | Filter Context | Aggregation Functions (SUM, COUNT, COUNTROWS, AVERAGE, DISTINCTCOUNT, DIVIDE, MAX, MIN)

Class 09 – Calculated Measures | Filter Flow Concepts | Examples of Calculated Functions | Multi-Dimensional Analysis

Class 10 – Calculated Measures | Advanced Functions (ALL Conditions, Variables) | Practical Examples

Class 11 – Calculated Measures | Filter Functions with Explicit Measures | Merging Measures into a Single Calculated Measure | Introduction to Iterator Functions

Class 12 – Calculated Measures | Iterator Functions (SUMX, AVERAGEX, MINX, MAXX) | Time Intelligence Functions (DATEADD, Previous Month, Previous Year, DATESYTD, DATESMTD, DATESQTD & DATESINPERIOD)

Class 13 – Calaculated Measures | Handling Errors | Data Visualizations (Navigation Bar, Images, Cards and Visual Formatting)

Class 14 – Data Visualizations | (Line Chart, Forecasting, Reference line, Bar Chart, KPI Chart, Table and Metrix Visual & Formatting | Customer Tooltips Conational Formatting

Class 15 – Data Visualizations | Filters Types (Slicers , Visual Level Filters, Page Level Filters, Dashboard Level Filters) | TopN Filters | KPI Chart | Guage Charts | Area Chart

Class 16 – Advanced Filtering Techniques | Drill-Through Techniques | Line Charts & Variations | Other Visualization Options

Class 17 – Dashboard Finalization | Dashboard Publishing Concepts | Power BI Service Introduction (Data Refresh, Row-Level Security, Credentials, Workspaces)

Class 18 – SQL Query Concepts | Connecting Power BI with SQL Databases | Power Query & ETL for Performance Dashboards | Data Modeling & Dashboard Design Techniques

Class 19 – Advanced Dashboard Design Strategies | Advanced Power Query (M Code Techniques) | Building Performance Analysis Dashboards from Scratch

Power BI Project: 365 Media Feathers

Class 01

43:13
Class 02

17:07
Class 03

36:37
Class 04

27:49
Class 05

39:20
Class 06

19:42
Class 07

41:00
Class 08

21:56
Class 09

38:46
Class 10

12:05

Power BI Project: 365 Granny’s Café

Class 20 – Dashboard Finalization | Advanced Techniques | Column & Bar Charts | Line + KPI Card

Class 21 – Excel Basics | Interface & Navigation | Text Functions | Core Formulas | VLOOKUP, XLOOKUP, INDEX-MATCH

Class 22 – Data Types & Formats | Freeze Panel | Grouping | Data Cleaning (Duplicates, Trim, Substitute, Flash Fill, Text to Columns, Concatenate) | Sorting & Filtering | Text Functions (LEFT, RIGHT, LEN)

Class 23 – IF & Logical Functions (IF, AND, OR, NOT, Nested IF) | Conditional Summing & Counting (SUMIF, COUNTIF, SUMIFS, AVERAGEIFS, COUNTIFS) | Lookup & Ranking (VLOOKUP, RANK, ROUND, SUMPRODUCT, TEXTJOIN) | Hands-on Activity

Class 24 – Excel Best Practices | Advanced Functions | Data Validation | Conditional Formatting | Pivot Tables & Charts | Advanced Calculations

Class 25 – Advanced Pivot Tables & Calculations | Deep Data Analysis | Case Study Application

Class 26 – Interactive Charts | Advanced Visualizations | Dashboard Design Concepts

Class 27 – Dashboard Development | Dynamic Formulas & Advanced Calculations

Class 28 – Dashboard Finalization | Insight Review | Power Pivot | Power Query Fundamentals

Class 29 – Dashboard Finalization | Advanced Excel Features | VBA Automation | Power Automate | Power Query Applications | SQL Connections with Excel

Class 30 – Excel Final Project Overview | Introduction to SQL & Databases | SQL Types & Basic Queries | Hands-on Database Examples

Class 31 – SQL Core Clauses (SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY) | Real-Time Examples & Practice

Class 32 – SQL Order of Operations | Understanding Aggregation Functions (SUM, COUNT, AVG, MIN, MAX) | Applying Numerical Functions for Data Analysis | Working with Date & Time Functions | Using String Functions for Data Cleaning and Formatting

Class 33 – SQL Comparison Operators (>, <, =, !=, BETWEEN, LIKE, IN) | IS and IS NOT Functions | Logical & Conditional Functions (AND, OR, IIF, CASE WHEN THEN, ISNULL) | Building Conditional Queries | Introduction to SQL Joins and Their Use Cases

Class 34 – In-Depth Study of SQL JOINS (INNER, LEFT, RIGHT, FULL/OUTER) | Real-Time Query Building Using Joins | Combining Multiple Tables for Insights | Case Studies and Industry Best Practices in Relational Data Management

Class 35 – Understanding ER Diagrams (Entity-Relationship Modeling) | Facts vs Dimension Tables in Database Design | Establishing Table Relationships (One-to-Many, Many-to-Many) | Creating a Logical Data Model | Case Studies and Real-World Database Project Examples

Class 36 – SQL UNION & UNION ALL Concepts | Working with Large and Complex Queries | Query Optimization Techniques | Data Integration Scenarios | Real-Time Examples of Combining Data Across Systems and Optimizing Performance

Class 37 – SQL Subqueries (Scalar & Multi-Row) | Derived Columns in SELECT | Derived Tables in FROM | Understanding MySQL | Window Functions (ROW_NUMBER, RANK, Others)

Class 38 – Python: Detailed Introduction | Types of Variables | Numerical Functions | String Functions

Class 39 – Python: List Functions | Conditional Statements & Functions

Class 40 – Python: Loop Concepts | Loop Functions with Practical List Examples

Class 41 – Python: Libraries Overview | Data Import Techniques | Data Exploration | Data Cleaning | Slicing & Filtering | Group By & Column Operations

Class 42 – Python Live Project: Complete Analysis on Hotel Management Data Using Key Techniques & All Covered Functions

Class 43 – Python Live Project: Advanced Methods Using Real Data with Problem Statement and Solution

Class 44 – API Concepts (Application Programming Interface) | API Integrations & Solutions | Tableau Introduction | Relationships | Calculated Fields | Calculated Measures | Dashboard Creation

Class 45 –

Class 46 –

Class 47 –

Class 48 –

Course Content

Introductory Class

Data Analyst (Batch-11) – Introductory Class

Class 01 – Power BI Intro | Ribbons | Data Sources | Power Query Overview

Data Analyst (Batch-11) – Session 01

Class 02 – ETL | Advanced Data Cleaning with Power Query

Data Analyst (Batch-11) – Session 02

Class 03 – Power Query | Conditional Columns | Column from Examples | Data Tools | Date Calculations | Group By | Advanced Filtering & Sorting

Data Analyst (Batch-11) – Session 03

Class 04 – Power Query: Parameters | Append Queries | Folder Selection | Data Normalization | Data Modeling

Data Analyst (Batch-11) – Session 04

Class 05 – Data Modelling Intro | Data Concepts | Fact vs Dimension | Star, Snowflake & Galaxy Schema | Data Formatting

Data Analyst (Batch-11) – Session 05

Class 06 – Calculated Columns | Text Functions (LEFT, RIGHT, UPPER, LOWER, CONCAT) | Date Functions (DAY, MONTH, YEAR, DATEDIFF, TODAY, WEEKDAY, WEEKNUM) | SUBSTITUE, FIND, SEARCH, Dynamic LEFT & RIGHT

Data Analyst (Batch-11) – Session 06

Class 07 – Calculated Columns | Logical Operators | IF, Nested IF | SWITCH (with TRUE) | AND, OR | Dynamic Formulas

Data Analyst (Batch-11) – Session 07

Class 08 – Calculated Measures | Implicit vs Explicit | Filter Context | Aggregation Functions (SUM, COUNT, COUNTROWS, AVERAGE, DISTINCTCOUNT, DIVIDE, MAX, MIN)

Data Analyst (Batch-11) – Session 08

Class 09 – Calculated Measures | Filter Flow Concepts | Examples of Calculated Functions | Multi-Dimensional Analysis

Data Analyst (Batch-11) – Session 09

Class 10 – Calculated Measures | Advanced Functions (ALL Conditions, Variables) | Practical Examples

Data Analyst (Batch-11) – Session 10

Class 11 – Calculated Measures | Filter Functions with Explicit Measures | Merging Measures into a Single Calculated Measure | Introduction to Iterator Functions

Data Analyst (Batch-11) – Session 11

Class 12 – Calculated Measures | Iterator Functions (SUMX, AVERAGEX, MINX, MAXX) | Time Intelligence Functions (DATEADD, Previous Month, Previous Year, DATESYTD, DATESMTD, DATESQTD & DATESINPERIOD)

Data Analyst (Batch-11) – Session 12

Class 13 – Calaculated Measures | Handling Errors | Data Visualizations (Navigation Bar, Images, Cards and Visual Formatting)

Data Analyst (Batch-11) – Session 13

Class 14 – Data Visualizations | (Line Chart, Forecasting, Reference line, Bar Chart, KPI Chart, Table and Metrix Visual & Formatting | Customer Tooltips Conational Formatting

Data Analyst (Batch-11) – Session 14

Class 15 – Data Visualizations | Filters Types (Slicers , Visual Level Filters, Page Level Filters, Dashboard Level Filters) | TopN Filters | KPI Chart | Guage Charts | Area Chart

Data Analyst (Batch-11) – Session 15

Class 16 – Advanced Filtering Techniques | Drill-Through Techniques | Line Charts & Variations | Other Visualization Options

Data Analyst (Batch-11) – Session 16

Class 17 – Dashboard Finalization | Dashboard Publishing Concepts | Power BI Service Introduction (Data Refresh, Row-Level Security, Credentials, Workspaces)

Data Analyst (Batch-11) – Session 17

Class 18 – SQL Query Concepts | Connecting Power BI with SQL Databases | Power Query & ETL for Performance Dashboards | Data Modeling & Dashboard Design Techniques

Data Analyst (Batch-11) – Session 18

Class 19 – Advanced Dashboard Design Strategies | Advanced Power Query (M Code Techniques) | Building Performance Analysis Dashboards from Scratch

Data Analyst (Batch-11) – Session 19

Power BI Project: 365 Media Feathers

Class 01

Class 02

Class 03

Class 04

Class 05

Class 06

Class 07

Class 08

Class 09

Class 10

Power BI Project: 365 Granny’s Café

Class 01

Class 02

Class 03

Class 04

Class 05

Class 20 – Dashboard Finalization | Advanced Techniques | Column & Bar Charts | Line + KPI Card

Data Analyst (Batch-11) – Session 20

Class 21 – Excel Basics | Interface & Navigation | Text Functions | Core Formulas | VLOOKUP, XLOOKUP, INDEX-MATCH

Data Analyst (Batch-11) – Session 21

Class 22 – Data Types & Formats | Freeze Panel | Grouping | Data Cleaning (Duplicates, Trim, Substitute, Flash Fill, Text to Columns, Concatenate) | Sorting & Filtering | Text Functions (LEFT, RIGHT, LEN)

Data Analyst (Batch-11) – Session 22

Class 23 – IF & Logical Functions (IF, AND, OR, NOT, Nested IF) | Conditional Summing & Counting (SUMIF, COUNTIF, SUMIFS, AVERAGEIFS, COUNTIFS) | Lookup & Ranking (VLOOKUP, RANK, ROUND, SUMPRODUCT, TEXTJOIN) | Hands-on Activity

Data Analyst (Batch-11) – Session 23

Class 24 – Excel Best Practices | Advanced Functions | Data Validation | Conditional Formatting | Pivot Tables & Charts | Advanced Calculations

Data Analyst (Batch-11) – Session 24

Class 25 – Advanced Pivot Tables & Calculations | Deep Data Analysis | Case Study Application

Data Analyst (Batch-11) – Session 25

Class 26 – Interactive Charts | Advanced Visualizations | Dashboard Design Concepts

Data Analyst (Batch-11) – Session 26

Class 27 – Dashboard Development | Dynamic Formulas & Advanced Calculations

Data Analyst (Batch-11) – Session 27

Class 28 – Dashboard Finalization | Insight Review | Power Pivot | Power Query Fundamentals

Data Analyst (Batch-11) – Session 28

Class 29 – Dashboard Finalization | Advanced Excel Features | VBA Automation | Power Automate | Power Query Applications | SQL Connections with Excel

Data Analyst (Batch-11) – Session 29

Class 30 – Excel Final Project Overview | Introduction to SQL & Databases | SQL Types & Basic Queries | Hands-on Database Examples

Data Analyst (Batch-11) – Session 30