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 –

Class 17 –

Class 18 –

Class 19 –

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 –

Data Analyst (Batch-11) – Session 16

Class 17 –

Data Analyst (Batch-11) – Session 17

Class 18 –

Data Analyst (Batch-11) – Session 18

Class 19 –

Data Analyst (Batch-11) – Session 19