Description
Power BI is a Microsoft product that allows for the creation of powerful, interactive visualizations using business intelligence. This training course will teach participants how to create highly interactive and sophisticated dashboards using Power BI.
Full Day Course Price: €600 per person
Click here to view the upcoming Virtual Live Training 1.5 hour session schedule.
To book onto a Virtual Live Training 1.5 hour session, or series of sessions, please click here.
Dates
- 19 May 2023, 1 Day
- 6 July 2023, 1 Day
- 20 September 2023, 1 Day
- 14 November 2023, 1 Day
TARGET AUDIENCE
This introduction level Microsoft Power BI training course is aimed at experienced Excel users who wish to use the Power BI interface to create their own reports and dashboards.
PREREQUISITES
No previous knowledge of Microsoft Power BI is required, however, participants should be experienced users of Excel. They should be able to create, edit and manipulate spreadsheets containing formulae and functions. They should also be able to create charts and pivot tables. Ideally they should have completed the Excel Introduction and / or Excel Intermediate training course.
GOALS AND OBJECTIVES
Having completed this course, participants will have a good working knowledge of Microsoft Power BI which will enable them to create interactive visualizations and business intelligence capabilities within their own organisations.
Introduction to Power BI
Introducing Power BI
The Power BI Analytics Service
Creating a Power BI Dashboard
Using Power BI
Using Excel as a Data Source for Power BI
The Power BI Data Model
Database as Data Source for Power BI
Using the Power BI Analytics Service
Importing Data into Power BI
Getting Data
Data Structure for Q&A
Shaping and Combining Data
Power BI Desktop Queries
Shaping Data
Combining Data
Modelling Data
Introduction to Modelling
Setup and Manage Relationships
Cardinality and Cross Filtering
Default Summarization and Sort By
Creating Calculated Columns
Creating Quick Measures
Simple Calculations and Measurements
Interactive Data Visualizations
Creating Visualizations
Setting Sort Order
Slicers, Timeline Slicers and Sync Slicers
Cross Filtering and Highlighting
Visual, Page and Report Level Filters
Drill Down and Drill Up
Hierarchies
Power BI Desktop Visualizations
Tables, Matrices and Charts
Simple Map Visualizations
Colour Formatting
Tooltips
Publishing and Sharing
Sharing Options Overview
Publish from Power BI Desktop
Publish to Web
Share Dashboard with Power BI Service
Print or Save as PDF
Export Data from a Visualization
Publishing for Mobile Apps
Export to PowerPoint
Direct Connectivity
Cloud Data
Connecting to Analysis Services
Developer API
Using the Developer API
Custom Visuals
Power BI Mobile App
Introduction to the Power BI Mobile App
Using the Power BI Mobile App
Power BI Embedded
Course Summary and Review
Recap of Topics Covered
Question Time