Microsoft Power BI Beginner 1-Day Training Course
Introduction
This course is for new users of Power BI and will offer a thorough understanding of how it works. The user must have knowledge of Excel to Advanced level.
Objective
Duration
1-Day Training Course.
Course Outline
Power BI Basics
-
Overview of Power BI
-
The Power BI screen, Toolbars & Menus
Creating Reports in Power BI Desktop
-
Introduction to Reports
-
Tables and Matrix Tables
-
Styles, Formatting and Conditional Formatting
-
Changing the Method of Aggregation
-
Tables and Cards
Filtering Dates
-
Using Slicers
-
Visual Filters & Page Filters
-
Drill Through Filter
Graphs & Visualisations
-
Column, Stacked and 100% Charts
-
Trend Analysis
-
Pie, Donut, Area and Ribbon Charts
-
Scatterplots
-
Bubbleplots
-
Maps
Interactive Dashboards
-
Creating interactive dashboards
-
Publishing dashboards
Getting Live Data from the Web
-
Using the data to produce a visualisation
Microsoft Power BI Intermediate 1-Day Training Course
Introduction
This course is for existing users of Power BI, who would like to move to the next level and start using DAX formulas.
Objective
Duration
1-Day Training Course.
Course Outline
-
Index Columns and Conditional Columns
-
Query Editor – Merging, Appending
-
Hierarchy’s
-
Relationships
-
Creating and Managing Relationships
-
Using the Related formula
-
DAX Formulas
-
Date & Time
-
Text
-
Sum/Max/Min/Average/Count
-
Calculate
-
Filter
-
Sumx
-
Enhancing Power BI
-
Transforming Data
-
Aggregating Data
-
Data Connections and Sources
-
Loading data from a variety of sources
-
Visualising Data
-
Donut charts
-
Line & Clustered Column charts
-
Treemaps
-
Bookmarks
-
Key Influencers
-
Decomposition Trees
-
Buttons and Q&A