COURSE INFORMATION
This course is aimed at Business Analysts who want to expand on their knowledge of Power BI Desktop.
- Themes
- Further Visualisation tools
- Further DAX Functions
- Data Management
- Publishing to Power BI Service
Themes
- Apply a theme to a report
- Create a custom theme
- Create a template with a theme and standard pages
Visualising Data
- Additional Visuals
- Hierarchies
- Format Pane
- Conditional Formatting
- Sparklines
- Edit Interactions
Further DAX
- What if Analysis using DAX logic
- Time Intelligence Functions
- Quick measures
- Debugging DAX Functions
- Using Variables
- Formatting DAX measures
- SUMX Function
Data Management
- Import vs Direct Query
- Setting up a Schema
- Creating a single set of values
- Different ways to create a Date Table
- Measures v Calculated Columns
- Publish Reports with Power BI Service (requires Power BI service licence)
- Implementing Row Level Security
- Define roles and rules
- Publish report to Power BI Service
- Create Dashboards
- Add tiles to Dashboards
- Add other data to a Dashboard
- Using Insights
- Sharing Dashboards
Report Management (requires Power BI service licence)
- Implementing Row Level Security
- Define roles and rules
- Manage security in Power BI Service
- It is recommended you have completed the Introduction to Power BI desktop course.
- £495
- One day trainer led or virtual