£375.00 – £895.00
This intermediate level course is designed for users who are already familiar with Power BI and are looking to broaden their horizons when it comes to designing reports and dashboards. This course explains how to use over 30 of the custom visuals developed by Microsoft and the Power BI developer community; and how to use them to construct interactive data narratives for their audience. This is a practical, hands-on course which demonstrates how, why and when to use each of the visuals.
This one day intermediate level course is designed for users who are already familiar with Power BI and are looking to broaden their horizons when it comes to designing reports and dashboards. The course delves deeper into the Query Editor and the DAX language; it discusses Excel and PowerPoint integration; and whows delegates how to use custom visuals to construct interactive data narratives for their audience.
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
Our scheduled training courses take place at the following address:
Tower Bridge Business Centre
46-48 East Smithfield
London E1W 1AW
Tel: 0800 998 9248
When booking on-site training, use the pricing zone map below to determine the daily rate based on the location of your organization: zone A, £695, per day; zone B, £795, per day; zone C, £895, per day.
|Choose a date||
24 Jul 2019 – London, 21 Aug 2019 – London, 25 Sep 2019 – London, 13 Nov 2019 – London, 11 Dec 2019 – London, 15 Jan 2020 – London, 12 Feb 2020 – London, 18 Mar 2020 – London, 13 May 2020 – London, On-site training – Zone A, On-site training – Zone B, On-site training – Zone C