Course Details
Course Outline
5 days course
Introduction to Power BI
- What is Power BI?
- The Power BI service
- Power BI Report Server
- Power BI Desktop
- Reports and Dashboards
- Datasets
- Row-Level Security
- Content Packs
- Natural Language Queries
Data Sources
- Connecting to Files
- Importing Excel Files
- Publishing to Power BI from Excel
- Updating Files in Power BI
- Data Refresh
- The Power BI Data Model
- Managing Data Relationships
- Optimising the Model for Reporting
- Hierarchies
- SQL Servers
- Other Data Sources
- R Script Data Connector
- Configuring Data for Q&A
- Creating Content Packs
- Creating a Group
Shaping and Combining Data
- The Query Editor
- Applied Steps
- Advanced Editor
- Shaping Data
- Formatting Data
- Transforming Data
- Combining Data
- Merging Data
Modelling Data
- What are the Relationships?
- Viewing Relationships
- Creating Relationships
- Cardinality
- Cross Filter Direction
- What is DAX?
- Syntax
- Functions
- Context
- Calculated Columns
- Calculated Tables
- Measures
Interactive Data Visualisations
- Power BI Reports: Page Layout and Formatting
- Multiple Visualisations
- Creating Charts
- Using Geographic Data
- Histograms
- Power BI Admin Portal
- Service Settings
- Desktop Settings
- Dashboard and Report Settings
