Description
Power BI Training Course Specification – Intermediate Level
An introduction to Power BI and Data Visualisation.
- Connecting to Excel and csv files.
- Connecting to SQL Databases.
- Connecting to One Drive / SharePoint.
- How to load all data in from a folder.
- How to manually create a table.
- Storage modes of tables and their advantages.
- Recap of Basic Data Transformations, covered in the basic Power BI training.
- Creating Conditional Columns.
- Merging, Editing, and Splitting Columns.
- Using Group By functionality in Power BI.
- Pivoting and Unpivoting data in Power BI.
- How to merge tables together.
- How to append tables together.
- Duplicating and Referencing tables.
- Methods to sort columns and use fill up and fill down functions.
- What can cause data errors and how to deal with them.
- Creating a Last Refresh Date.
- Relationship Cardinality and Direction
- Active vs Inactive Relationships
- How to identify the correct relationship to use when connecting tables=.
- How to avoid many-to-many relationships.
- What is a Database Schema?
- Types of schemas.
- Keeping your model tidy.
- Date tables
- Measure Tables
- What is context? An introduction to Measure Context and Row Context
- Introduction to Dax; Measures, Calculated Columns and Calculated Tables.
- How to use the Calculate function and editing filter context.
- How to use and the differences between Count(), CountRows() and DistinctCount().
- How to use and the differences between Min(), Max() and SelectedValue().
- How to use the Divide() function and its advantages.
- How to use the Related() and LookUpValue() functions.
- How to use and the differences between If() and Switch() statements.
- How to use the UseRelationship() function and where to use it.
- An introduction to the Dax Query View.
- The advantages of using the Dax Query view.
- The usefulness of using the Dax Query view when connecting to Power BI semantic models.
- How to use the Dax Query view.
- The Do’s and Don’ts of page design.
- How to make an effective page design for an end user.
- Conditional Formatting of Visuals.
- Dynamic measures and measure formatting.
- How to create and design ToolTips, using both the Default and Report Page types.
- Creating and adding effective data labels to visuals.
- Creating Drill Down and Drill Through functionality in a report.
- How to create effective Mobile reports.
- How to edit the interactivity between visuals.
- Synchronising slicers across a report.
- Creating bookmarks and the selection pane.
- Creating Help Pages for the end user.
- Creating Q&A and Key Influencer visuals.
- How to connect Excel to an online Power BI Report.
- Creating charts and visual in excel using data from Power BI.
