Audience
Business Analysts, Financial Analysts, Data Scientists and Staff who need to use Power BI for producing reports from Excel, SQL Server and other databases.
Prerequisites
There are no prerequisites for this course.
Duration
2 days.
Course Objectives
This Microsoft Power BI training course shows attendees how to use the latest collection of on-premise and online tools to enable them to find, clean, model, and visualize data, share discoveries, and collaborate in intuitive new ways.
Power BI is the latest set of Microsoft BI tools for data mash up, data modelling, and data visualisation. The results can be deployed on-premise or in the cloud and can be visualised in browsers, on tablets, and on mobile phones.
This course will take you through the product, demonstrating functionality, with plenty of hands on so that you can learn to use this powerful tool to help you transform your rows of data into a compelling interactive visual story.
Course Content
Power BI Service
- Self-service BI
- Organisational BI
- Portal
- Content Items
- Datasets
- Connecting to Data
- Visualizing Data
Reports
- Reading View
- Editing View
- Visualisations and Custom Visualisations
- Dashboards
Power BI Mobile
- Native Applications (iOS/Android/Windows)
- Viewing Content
- Sharing & Collaboration
- Configuring Alerts
Power BI Desktop
- Data Models
- Schemas
- Relationships
- Connectivity
- Design Environment
- Navigation
- Importing Data
Transforming Data
- Queries & the Query Editor
- Data Previews
- Shaping & Cleansing Data
- Basic Transformations
- Loading Transformed Data
- Combining Datasets
- Functions
- Date Tables
Refining the Model
- Tables & Columns
- Data View
- Exploring Data
- Managing Schema & Data Changes
- Connections & Tables
- Data Refresh
- Relating Tables
- Rules & Limitations
- Auto-Detecting
- Relationship View
Calculations
- Data Analysis Expressions
- Calculated Columns
- Measures
- DAX Syntax
- DAX Functions
- Advanced Relationships