Course Code: XLPOWBI
Duration: 1 Day
COURSE AIMS:
This Microsoft Power BI Desktop Advanced training course is for anyone looking to use more of the advanced DAX functions, create quick measures, generate, and import structured report visuals and use Power Query Editor.
COURSE PRE-REQUISITES:
Delegates should have attended the Intermediate course or have previously use Power Bi and can create visuals and calculations using Calculated Columns & Measures.
COURSE OBJECTIVES:
On completion of this course, delegates will be able to:
- Create Formulas using DAX Functions
- Create custom column calculations
- Import visuals
- Add tooltips and sparklines to visuals
- Append and Merge Queries
COURSE CONTENT:
Source Data
- Copying and entering data into a new table
- Calculated table
Power BI Query Editor (PQE), for example
- Append and Merge queries
- Use Custom Column to create calculation
- Adding Conditional Column
- Transpose
- Detect Data types
- Reverse Rows
- Split Columns
- Choose columns
- Edit data in a new table
Advanced Visualisations
- Digital Storytelling by adding Tool Tips Page and Drill Down/Drill Through techniques
- Managing Visualisation relationships (e.g., properties)
- Importing Visuals (e.g., Histogram, Multi KPI, World flags)
- Decomposition Tree
- Working with Bookmarks
- •Adding Sparklines to visuals
- Applying Conditional formatting to dynamic titles
Advanced Data Analysis Expressions Functions for example,
- RELATED/RELATEDTABLE
- LOOKUP
- AND/OR/IF
- MID/FIND
- EDATE/DATEDIFF/DATEADD/SAMEPERIODLASTYEAR
- CALCULATE/FILTER/ALL/TOPN/ISFILTERED/ALLEXCEPT
- SUMMARIZE
- VALUES/HASNOVALUE/BLANK/SELECTED VALUE
- SUMX/AVERAGEX/RANKX
- Working with Variables
- Moving measured calculations from one table to another
- Using a Slicer to return different calculations
- Generate calculations using Quick Measures
Hints and Tips
- Edit Interactions
- Power BI Reports in PowerPoint
- Data Category (e.g., Image and Web URL)
Power BI Frequently Asked Questions
