Power BI Advanced (2 days)

Using The Formula Bar; Using The Advanced Editor; Overview Of The M Language; Exploring M using #shared

Excel.Workbook; File.Contents; Table.TransformColumns; Table.TransformColumnTypes; Table.UnpivotColumns; Table.UnpivotOtherColumns

Defining a function; Defining input parameters; The goes-to operator; Defining the function body; Using optional parameters; Calling functions

Benefit of generating lists; Generating lists of numbers; Generating lists of dates; Generating alphanumeric lists; Using the each function; Applying a function to a list of files

Using DAX Studio, Writing complex formulas, Using variables, Calculating moving averages, Calculating running totals, Percentile calculations, Creating advanced time intelligence formulas, Using multiple date tables, Working with non-standard calendars

Creating calculated tables, DAX functions that return tables, The CALCULATETABLE function, The ADDCOLUMNS function, The SUMMARIZE function, SUMMARIZE with ROLLUP, VALUES and DISTINCT functions, The CROSSJOIN function, The TOPN function, The ROW function, Using calculated tables within the data model

What is a parameter table, When to use parameter tables, Using the HASONEVALUE function, Using the VALUES function, Creating custom slicers, Creating multiple parameter table solutions

Overview of ArgGIS maps integration, Selecting a base map, Creating heat maps, Adding demographic layers, Searching for layers on ArgGIS online

Overview of R integration, Configuring R Script Options, Using the R Script editor, Creating correlation plots, Creating predictive plots, Interacting with Power BI visuals

Adding custom links to a dashboard, Using th web content widget, Using the video widget, Real-time streaming dashboard tiles