Class 01 – Introduction of Data Analytics

Class 03 – Text Tools (Extract, Merge Columns, Split Columns, Format) | Number Tools (Statistics) | Duplicate vs Reference Queries | Column Profiling, Quality and Distribution

Class 04 – Number Tools (Standard) | Date Tools (Age, Earliest, Latest, Dates Concept) | Conditional Columns | Duplicate Columns

Class 05 – Column from Example | Group By | Parameters | Merge Queries | Date Tools (Subtract Days} | Filtering

Class 06 – Appending Data | Data Modelling Concept

Class 07 – Data Modelling | Column Formatting

Class 08 – DAX Calculated Columns | Text Functions (UPPER, LOWER, CONCETENATE, LEFT, RIGHT, FIND)

Class 09 – Text Functions (MID) | Date Functions (DAY, MONTH, YEAR, HOUR, MINUTE, SECOND, DATEDIFF)

Class 10 – Date Functions (WEEKNUM, WEEKDAY) | Logical Functions (IF, Nested IFs, SWITCH)

Class 11 – Logical Functions (AND, OR Logics with IF, SWITCH Function, RELATED)

Class 12 – Filter Context | Filter Flow | Implicit & Explicit Measures | Numerical Functions (SUM, AVERAGE, MIN, MAX, COUNT)

Class 13 – Numerical Functions (AVERAGE, DIVIDE, DISTINCTCOUNT)

Class 14 – CALCULATE Function | ALL Function

Class 15 – FILTER Function | Iterator Functions (SUMX, AVERAGEX)

Class 16 – Time Intelligence Functions (DATEADD, DATESYTD, DATESMTD, DATESQTD, DAYSINPERIOD)

Class 17 – Error Handling in Time Intelligence Functions (IFERROR, ISBLANK)

Class 18 – Visualization – Insert Options | Card Visual | Line Chart | Visual Formatting

Class 19 – Visualization – Line Chart (Trend, Forecast) | Bar Chart | KPI Visuals

Class 20 – Filters (Basic, Advance, TOPN) | Donut & Pie Charts | Matrix Visual

Class 21 – Matrix Visual | TOP N Card Visual | Cross Filtering | Slicers

Class 22 – Guage Chart | Drill Down/ Up | Drill Through | Area Chart

Class 23 – Bookmarks | Filter Buttons | Field Parameters | Advance Tooltips | Navigation Menu

Class 24 – AI Visuals (Smart Narrative, Decomposition Tree, Key Influencers)

Class 25 – Market Minds (Replace Value, Unpivot Columns, Handling Errors)

Class 26 – Market Mindz (Column, Bar, 100 Stacked Column, Donut Charts | Error Bars | Custom Groups | Both Direction Filter | Unpivot Columns

Class 27 – Market Mindz (AI Visuals , Key Influencers, Background Design, Color Pallete)

Class 28 – Designing the Power BI Dashboard

Class 29 – Completing the Market Mindz Project Design

Class 30 – Oodles of Noodles Project (Solution 01)

Class 31 – Oodles of Noodles Project (Solution 02)

Class 32 – Oodles of Noodles Project (Solution 03)

Class 33 – Variables in DAX | Iterator Function (RANKX for Dynamic TOPN Rankings)

Class 34 – Advanced RANKX Function | Create Table

Class 35 – Maven Roasters – Rounding Functions (INT, ROUND, ROUNDDOWN, ROUNDUP, MROUND, TRUNC, FIXED, FLOOR, CEILING) | Information Functions (ISBLANK, ISNUMBER, ISTEXT, ISLOGICAL) | Conversion Functions (CURRENCY, FORMAT, DATEVALUE, VALUE, DATE, TIME)

Class 36 – Maven Roasters – Advanced CALCULATE Modifiers (REMOVEFILTERS, KEEPFILTERS) | Calculated Tables | Table Functions (ALL, FILTER, DISTINCT)

Class 37 – Maven Roasters – Advanced CALCULATE Modifiers (ALLEXCEPT – % of Parent, ALLSELECTED – % of Modified Context)

Class 38 – Maven Roasters (SELECTCOLUMNS, ADDCOLUMNS, SUMMARIZE, Case Study (SUMMARIZE))

Class 39 – Maven Roasters – Relationship Functions (RELATED, RELATEDTABLES, USERELATIONSHIP, CROSSFILTER)

Class 40 – Maven Roasters – CROSSFILTER Case Study | Automatic Calendar Table | COALESE Function