The course delves deeper into the Query Editor and the DAX language; it discusses Excel and PowerPoint integration; and shows delegates how to use bookmarks and 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
The fee for running in-house Power BI courses in Colchester is £795, per day.
The cost for running customized Power BI courses in Luton is £795, per day.
Our fee for delivering customized Power BI training in Tyneside is £895, per day.
The charge for running customized Power BI training in Liverpool is £895, per day.
Our price for delivering on-site Power BI courses in Medway Towns is £895, per day.
The fee for running customized Power BI training in Doncaster is £895, per day.
The fee for running customized Power BI training in Exeter is £895, per day.
Our charge for delivering on-site Power BI courses in Farnborough/Aldershot is £895, per day.
The charge for running customized Power BI training in Greater Manchester is £895, per day.
Our charge for delivering Microsoft Power BI courses in Chesterfield is £895, per day.
Our price for supplying on-site Power BI courses in Reading is £795, per day.
Our price for delivering on-site Power BI courses in Blackpool is £895, per day.
Our fee for delivering in-house Power BI courses in High Wycombe is £895, per day.
The charge for running Microsoft Power BI courses in Chelmsford is £895, per day.
The fee for running on-site Power BI training in Edinburgh is £995, per day.
Our price for delivering in-house Power BI courses in Oxford is £895, per day.
Our price for running on-site Power BI training in The West Midlands is £795, per day.
The fee for running on-site Power BI training in Telford is £795, per day.
The cost of supplying on-site Power BI courses in Accrington/Rossendale is £895, per day.
Our charge for supplying Microsoft Power BI courses in Sunderland is £895, per day.
Our price for supplying in-house Power BI courses in Derby is £795, per day.
Our price for delivering customized Power BI courses in Basingstoke is £895, per day.
Our price for delivering customized Power BI courses in Eastbourne is £895, per day.
Our fee for delivering on-site Power BI training in Northampton is £895, per day.
The fee for running customized Power BI training in Ireland is £995, per day.
The charge for running in-house Power BI courses in Preston is £895, per day.
Our price for running Microsoft Power BI courses in Sheffield is £895, per day.
Our price for running customized Power BI training in Plymouth is £895, per day.
Our price for supplying in-house Power BI courses in Slough is £895, per day.
Our charge for supplying on-site Power BI training in Newport is £895, per day.
The fee for running customized Power BI courses in Torquay is £895, per day.
Our price for delivering customized Power BI courses in Burnley is £895, per day.
Our fee for delivering customized Power BI courses in Ipswich is £895, per day.
The fee for running on-site Power BI training in West Yorkshire is £795, per day.
Our price for supplying Microsoft Power BI courses in Dundee is £995, per day.
Our fee for delivering customized Power BI courses in Cardiff is £895, per day.
Our fee for delivering Microsoft Power BI courses in Bristol is £895, per day.
The fee for running customized Power BI training in Norwich is £795, per day.
Our charge for supplying on-site Power BI courses in Birkenhead is £895, per day.
Our charge for delivering customized Power BI courses in Coventry is £795, per day.
Our fee for delivering on-site Power BI courses in Warrington is £895, per day.
Our price for delivering in-house Power BI courses in Mansfield is £895, per day.
The fee for running on-site Power BI courses in Greater Glasgow is £995, per day.
The charge for running customized Power BI courses in Lincoln is £795, per day.
Our charge for delivering customized Power BI training in Wigan is £895, per day.
The cost for running in-house Power BI courses in Poole is £895, per day.
The fee for running on-site Power BI courses in Worcester is £895, per day.
The charge for running customized Power BI courses in Stoke-on-Trent is £795, per day.
Our charge for supplying on-site Power BI courses in Maidstone is £895, per day.
Our price for running customized Power BI training in Nottingham is £795, per day.
Our price for supplying Microsoft Power BI courses in Basildon is £895, per day.
The cost for running customized Power BI courses in Hastings is £895, per day.
Our charge for delivering customized Power BI courses in Swindon is £895, per day.
Our price for delivering customized Power BI training in Brighton and Hove is £895, per day.
The cost of supplying Microsoft Power BI courses in Cheltenham is £895, per day.
Our price for running on-site Power BI courses in Teesside is £895, per day.
Our price for supplying customized Power BI training in Cambridge is £795, per day.
The charge for running customized Power BI courses in Thanet is £895, per day.
The charge for running customized Power BI courses in Birmingham is £795, per day.
The cost of supplying on-site Power BI courses in Grimsby is £895, per day.
The cost of supplying on-site Power BI courses in Burton-upon-Trent is £895, per day.
Our price for supplying on-site Power BI courses in Greater London is £895, per day.
The cost of supplying customized Power BI courses in Crawley is £895, per day.
The fee for running in-house Power BI courses in York is £895, per day.
Our charge for supplying customized Power BI training in Leicester is £795, per day.
Our fee for delivering customized Power BI training in Southend-on-Sea is £895, per day.
The cost of supplying in-house Power BI courses in South Hampshire is £895, per day.
The cost for running customized Power BI training in Bedford is £895, per day.
Our fee for delivering Microsoft Power BI courses in Barnsley is £895, per day.
Our price for delivering in-house Power BI courses in Blackburn is £895, per day.
Our price for running Microsoft Power BI courses in Gloucester is £895, per day.
Our charge for supplying customized Power BI training in Bournemouth is £895, per day.
Our price for supplying customized Power BI training in Aberdeen is £995, per day.
The fee for running on-site Power BI courses in Peterborough is £795, per day.
Our price for running customized Power BI courses in Milton Keynes is £795, per day.
The cost for running customized Power BI courses in Kingston upon Hull is £895, per day.
Our price for running Microsoft Power BI courses in Swansea is £895, per day.
Our charge for supplying on-site Power BI training in Belfast is £995, per day.