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
Assignment 04 Solution

16:06

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

Class 20 – Calculate Function | Batching Similar Measures | Decision Making | Industrial Standards/Practices while Presenting Report | Contribution Analysis

Class 21 – REMOVEFILTER | % of Grand Total Analysis | % of Parent Analysis

Class 22 – Iterator Functions (SUMX, AVERAGEX, MINX, MAXX) | RELATED | Time Intelligence Analysis (YoY & MoM %age Change Analysis, DATEADD ) | Error Handling (ISBLANK, IFERROR)

Class 23 – Discussion (Dashboard | Images | Elements | Shapes | Color Palette | Formatting | UI UX | Card Visual | Corporate Standards | Line Chart (Trend Line, Reference Line: Comparison Analysis) | Bar Chart | Column Chart | Difference between Clustered and Stacked Charts)

Class 24 – KPI Card | Donut Chart | Pie Chart | Filters (Visual, Page & Report Level) | Basic Filter | Advanced Filters | TOPN Filter

Class 25 – Table and Matrix | Conditional Formatting | Area Chart

Class 26 – Guage Chart (Filtering, Monthly Filter, Industry Standards)

Class 27 – Drilling (Up, Down, Through) | Bookmarks | Page Navigation | Custom Tooltips

Class 28 – Power BI Service

Project: 365 Media Feathers

Session 01

43:13
Session 02

17:08
Session 03

36:37
Session 04

27:50
Session 05

39:21
Session 06

19:46
Session 07

41:01
Session 08

21:57
Session 09

38:47
Session 10

12:06

Project: 365 Granny’s Cafe

Course Content

Power BI – Assignment Solutions

Assignment 01 Solution

Assignment 02 Solution

Assignment 03 Solution

Assignment 04 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

Class 20 – Calculate Function | Batching Similar Measures | Decision Making | Industrial Standards/Practices while Presenting Report | Contribution Analysis

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

Class 21 – REMOVEFILTER | % of Grand Total Analysis | % of Parent Analysis

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

Class 22 – Iterator Functions (SUMX, AVERAGEX, MINX, MAXX) | RELATED | Time Intelligence Analysis (YoY & MoM %age Change Analysis, DATEADD ) | Error Handling (ISBLANK, IFERROR)

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

Class 23 – Discussion (Dashboard | Images | Elements | Shapes | Color Palette | Formatting | UI UX | Card Visual | Corporate Standards | Line Chart (Trend Line, Reference Line: Comparison Analysis) | Bar Chart | Column Chart | Difference between Clustered and Stacked Charts)

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

Class 24 – KPI Card | Donut Chart | Pie Chart | Filters (Visual, Page & Report Level) | Basic Filter | Advanced Filters | TOPN Filter

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

Class 25 – Table and Matrix | Conditional Formatting | Area Chart

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

Class 26 – Guage Chart (Filtering, Monthly Filter, Industry Standards)

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

Class 27 – Drilling (Up, Down, Through) | Bookmarks | Page Navigation | Custom Tooltips

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

Class 28 – Power BI Service

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

Project: 365 Media Feathers

Session 01

Session 02

Session 03

Session 04

Session 05