Data Analyst with AI + AWS + Snowflake (Batch-12)

Power BI – Assignment Solutions

Assignment 01 Solution

32:27
Assignment 02 Solution

20:43
Assignment 03 Solution

09:46

Pre-Requisite Videos

Class 01 – Importance of Excel | Keyboard Shortcuts | Functions (PROPER, UPPER, LOWER, SUM, MIN, MAX, AVG, VLOOKUP)

Class 02 – Data Types & Formats | Freeze Panel | Data Cleaning (Duplicates, TRIM, SUBSTITUTE, Flash Fill, Text to Columns, CONCATENATE) | Text Functions (LEFT, RIGHT, LEN)

Class 03 – Filtering | Sorting | Custom Sorting | Functions (VLOOKUP, XLOOKUP, INDEX, MATCH) | Data Validation | Conditional Formatting

Class 04 – Conditional Formatting | Logical Functions (IF, AND, OR, Nested IF) | Conditional Summing & Counting (SUMIF, COUNTIF, SUMIFS, COUNTIFS) | RANK

Class 05 – Basics of Pivot Tables | Data Analysis using Pivot Tables

Class 06 – Customizing Charts (Bar & Column Charts, Line Chart, Pie & Donut Charts, Treemap & Sunburst Charts, Waterfall & Funnel Charts)

Class 07 – 365 Cafe Coffee Project

Class 08 – 365 Cafe Coffee Project

Class 09 – Power BI: Power Query (Basic, Text Tools)

Class 10 – Power Query (Data Profiling, Column Quality, Context)

Class 10 (Sir Abbas Lectures)

Class 11 – Categorical vs Time Series Analysis | Append Queries | Merge Queries | Folder Query

Class 12 – Power Query Revision

Class 13 – Power Query Revision | Advanced Editor

Class 14 – Data Modelling & Data Normalization

Class 15 – Advanced Data Modelling

Class 16 – Data Analysis Expressions (DAX) | Left | Right | LEN | Find | Substitute| Variables (VAR)

Class 17 – DATE Functions (TODAY, YEAR, MONTH, DAY, HOUR, MINUTE, SECOND, DATEDIFF, DATEADD, NETWORKDAYS, YEARFRAC)

Class 18 – Logical Operators | Functions | Order of Operation (Lower & Upper Bound) | IF Function | Nested IF | Multiple Conditions | Multiple Conditions & Multiple Logics | Uses of AND | SWITCH Function | MID Function | Data Categorization | Hiding Foreign Keys

Class 19 – Introduction to Measures and its Best Practices | Filter Context | Implicit VS Explicit Measures | Measures Table | Measures Tree | Handling Blanks

Course Content

Power BI – Assignment Solutions

Assignment 01 Solution

Assignment 02 Solution

Assignment 03 Solution

Pre-Requisite Videos

Introduction to Excel | Shortcuts | Fill Handle | Flash Fill – Session 01

Sorting | Filtering | Grouping | Custom Sort | Hide and Deleting – Session 02

Mathematical Calculation | Referencing (Relative, Absolute, Mixed) – Session 03

Numerical Functions in Excel | 3D Referencing – Session 04

Class 01 – Importance of Excel | Keyboard Shortcuts | Functions (PROPER, UPPER, LOWER, SUM, MIN, MAX, AVG, VLOOKUP)

Data Analyst with AI (Batch-12) – Session 01

Class 02 – Data Types & Formats | Freeze Panel | Data Cleaning (Duplicates, TRIM, SUBSTITUTE, Flash Fill, Text to Columns, CONCATENATE) | Text Functions (LEFT, RIGHT, LEN)

Data Analyst with AI (Batch-12) – Session 02

Class 03 – Filtering | Sorting | Custom Sorting | Functions (VLOOKUP, XLOOKUP, INDEX, MATCH) | Data Validation | Conditional Formatting

Data Analyst with AI (Batch-12) – Session 03

Class 04 – Conditional Formatting | Logical Functions (IF, AND, OR, Nested IF) | Conditional Summing & Counting (SUMIF, COUNTIF, SUMIFS, COUNTIFS) | RANK

Data Analyst with AI (Batch-12) – Session 04

Class 05 – Basics of Pivot Tables | Data Analysis using Pivot Tables

Data Analyst with AI (Batch-12) – Session 05

Class 06 – Customizing Charts (Bar & Column Charts, Line Chart, Pie & Donut Charts, Treemap & Sunburst Charts, Waterfall & Funnel Charts)

Data Analyst with AI (Batch-12) – Session 06

Class 07 – 365 Cafe Coffee Project

Data Analyst with AI (Batch-12) – Session 07

Class 08 – 365 Cafe Coffee Project

Data Analyst with AI (Batch-12) – Session 08

Class 09 – Power BI: Power Query (Basic, Text Tools)

Data Analyst with AI (Batch-12) – Session 09

Class 10 – Power Query (Data Profiling, Column Quality, Context)

Data Analyst with AI (Batch-12) – Session 10

Class 10 (Sir Abbas Lectures)

Session 01

Session 02

Session 03 – Power Query (Basic, Text & Number Tools)

Session 04 – Power Query (Data Profiling, Column Quality, Date Tools, Conditional Columns)

Session 05 – Power Query (Introduction to M-Code, Column From Examples, Group By, Merge and Append Queries, Parameters)

Class 11 – Categorical vs Time Series Analysis | Append Queries | Merge Queries | Folder Query

Data Analyst with AI (Batch-12) – Session 11

Class 12 – Power Query Revision

Data Analyst with AI (Batch-12) – Session 12

Class 13 – Power Query Revision | Advanced Editor

Data Analyst with AI (Batch-12) – Session 13

Class 14 – Data Modelling & Data Normalization

Data Analyst with AI (Batch-12) – Session 14

Class 15 – Advanced Data Modelling

Data Analyst with AI (Batch-12) – Session 15

Class 16 – Data Analysis Expressions (DAX) | Left | Right | LEN | Find | Substitute| Variables (VAR)

Data Analyst with AI (Batch-12) – Session 16

Class 17 – DATE Functions (TODAY, YEAR, MONTH, DAY, HOUR, MINUTE, SECOND, DATEDIFF, DATEADD, NETWORKDAYS, YEARFRAC)

Data Analyst with AI (Batch-12) – Session 17

Class 18 – Logical Operators | Functions | Order of Operation (Lower & Upper Bound) | IF Function | Nested IF | Multiple Conditions | Multiple Conditions & Multiple Logics | Uses of AND | SWITCH Function | MID Function | Data Categorization | Hiding Foreign Keys

Session 01

Session 02

Class 19 – Introduction to Measures and its Best Practices | Filter Context | Implicit VS Explicit Measures | Measures Table | Measures Tree | Handling Blanks

Data Analyst with AI (Batch-12) – Session 19