Power BI Advanced

Thu Oct 15 2020 at 09:30 am to Fri Oct 16 2020 at 04:30 pm
Tower Bridge Business Centre, 46-48 East Smithfield, E1W 1AW London, UK, London, United Kingdom

Tower Bridge Business Centre, 46-48 East Smithfield, E1W 1AW London, UK, London, United Kingdom

Created By:
Facebook
Spread the word


Power BI Training at Advanced Level


This Power BI Advanced training course is aimed at experienced Power BI users. The course delves into the M language behind the Query Editor, as well as the use of advanced DAX formulas. Delegates will also learn how to improve the user experience through the use parameter tables; how to customise the data model by including calculated tables; and how to work with advanced visuals and dashboard tiles.
Data Centralisation




The importance of data centralisation, Creating Dataflows, Gateway configuration, refreshing dataflows, Building reports from dataflows, Centralising datasets, Certifying datasets, Building reports from datasets


The Power Query Formula Language




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


Understanding M Code




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


Creating custom functions in M




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


Iteration Techniques




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


Advanced dashboard tiles




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




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


Working with calculated tables




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


Using parameter tables




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


Advanced Data Modelling and Visualization




Working with multiple fact tables, Using active and inactive relationships, Using the USERELATIONSHIP function, Creating dynamic visual properties, Using BLANK() to make visibility dynamic

iCause.com promotes public events for free and helps event organizers connect with nonprofits to attract more participants like you.

Additionally, the iCause Global Foundation enables good people to fund great causes around the world. Together, our impacts are limitless!

Created By:
Facebook
Spread the word

More Events in london

iNanoTech2020

London , United Kingdom

Thu Oct 15 2020

St Thomas' daytime antenatal classes - labour, birth, feeding and life with new baby

Antenatal Education Room , 8th floor, North Wing, St Thomas' Hospital, Antentatal Education Room, 8th Floor, North Wing, St. Thomas' hospital, London, United Kingdom

Thu Oct 15 2020

Rotherhithe Ladies Who Latte

Docklands Settlements Community Centre ~ Rotherhithe , 400 Salter Road, London, United Kingdom

Thu Oct 15 2020

Climbing Wall Instructor Assessment

Mile End Climbing Wall , Haverfield Road, London, United Kingdom

Thu Oct 15 2020
View all events in London