Course Duration: 2 days
Prerequisites:
It is recommended that you have completed either the Excel Intermediate or Excel Advanced level workshops as well as Power Bi Introduction, or have equivalent experience. It is expected that you have a good understanding of Excel functions such as IF and VLOOKUP functions, as well as Defined Names, Importing Data and a basic understanding of PivotTables.
Subject Areas:
- Implementing Row Based security
- Using the Power BI service
- Creating workspaces / Apps / content packs
- The difference between a workspace and app and when to use
- Managing permissions
- Scheduling auto refresh
- Conditional Formatting (text & numbers)
- Drill downs (single visual / cross page)
- Creating dynamic themes / titles
- Using JSON files & Dax / slicers to create dynamic titles)
- Using bookmarks
- Import & Direct query and when to use
- Time intelligence (4 week calendar)
- Comparing historical periodical data using Sales data focussing on trends & forecasts
- Creating effective tooltips
- Data modelling
- Setting up a Schema
- Getting around common problems (e.g. creating a dataset of single values)
- DAX aggregates
- DAX logics
- Measures & new columns
- Emphasise on when to use a measure / calculated column
- Creating variables within measures & using Return / return if
- Working with untidy data
- Key influencers / decomposition tree analytics tools
- M query exposure – creating a 4-week calendar in Dax & M
