Microsoft Power BI Data Analyst Professional Certification (Batch-10)

Categories: Power BI
Wishlist Share
Share Course
Page Link
Share On Social Media

Course Content

Class 01 – Introduction of Data Analytics

Class 02 – Introduction of Power BI | Basics of Power Query | ETL | Basic Transformations in Power Query – Replace Value, Deleting Columns, Extract with Delimiter

Class 03-04 – Text Functions (Format Columns, Merge Columns, Split Columns) | Number Functions (Standard, Statistics, Rounding) | Basic Group By | Column Profiling, Quality and Distribution

Class 04-05 – Date Tools (Year, Month, Day, Start of Month) | Categorical vs Time Series Analysis | Conditional Column | Column from Example | Orders of Operations

Class 05-06 – Merge Queries | Appending Queries | Appending by Folders | Advanced Group By | Parameters

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