Power BI Intermediate (1 day)

Benefits of parameters and templates; Creating parameters; Parameter value types; Parameterizing data sources; parameterizing filters; Creating a template; Using a template

Converting a query to a function; Understanding function syntax; Invoking a function

Calendar tables; Power BI Auto Date/Time feature; The TOTALYTD function; Specifying end of fiscal year;
Calculating running totals; the SAMEPERIODLASTYEAR function; the PARALLELPERIOD function; Using the DATEADD function for maximum flexibility

Creating a what-if parameter; Specifying limits; Referencing the parameter measure; Incorporating parameter values in your model

Analyze in Excel; Installing Power BI Publisher for Excel; Creating pivot table reports from Power BI data sources; The importance of data types; Error – The field that you are moving cannot be placed in that PivotTable area; Pinning Excel content to a Power BI dashboard

Overview of custom visuals; Chiclet Slicer; Timeline; Advanced Time Slicer; Hierarchy Slicer; Synoptic Panel; Waffle Chart; Percentile Chart; Box and Whisker; Histogram; Bullet Chart; KPI Indicator; GlobeMap; Table Heatmap; WordCloud

Planning narratives; Self-running narratives; Interactive narratives; Using the Pulse chart visual; Using the Scroller visual; Using Narratives for Power BI; Using video clips in your visuals

Constructing a narrative in PowerPoint, Using export to PowerPoint, Embedding live reports into a PowerPoint presentation