Search, explore and find the perfect course for you

Power BI for Office 365

Demand for data has never been higher. Keeping up with the business' needs has become increasingly difficult. Traditional ways of getting the business the data they need often has long planning cycles which make it difficult to adjust when the requirements or needs change.

Through Self-Service BI, business units can personalize Business Intelligence to their needs and solve problems at a much faster rate than any traditional BI solution. This is why businesses are looking to Self-Service BI to solve the smaller, but no less significant, problems that individual departments need addressed.

Target audience

This course is targeted for Power Users or End Users that are looking to design their own Power BI solutions.


You have a basic knowledge of MS Excel and want to learn how to use the more advanced tools and features of Self Service BI in Excel. Previous SQL Server knowledge is not required. It is not mandatory but ideally participants would have a basic understanding database terminology (tables, views column, rows, etc..)

What you will learn

Day 1


  • The Self-Service BI Lifecycle
  • Understanding the role Self-Service BI plays with IT

Introduction to Power Pivot

  • Why use Power Pivot?
  • Who should use Power Pivot?

Importing Data into Power Pivot

  • Data Sources and loading data
  • Refreshing and managing Data
  • Using Linked Tables

Creating Data Models

  • What is a Data Model?
  • Usability Enhancements
  • Creating Table Relationships
  • Creating Hierarchies
  • Building Key Performance Indicators (KPIs)

Introduction to DAX

  • Calculated Columns with DAX
  • Functions for String Manipulation
  • Conditional and Logical Functions
  • Navigation Functions
  • Creating Calculated Measures
  • Creating Aggregates

Building Power Pivot Reports

  • PivotTable Fundamentals
  • Working with Pivot Charts
  • Sorting, Filtering and Formatting Reports

Day 2

Introduction to Power Query

  • Power Query Overview
  • When and Why using Power Query?

Importing Data with Power Query

  • Importing Data from External Data Sources
  • Managing Data Refreshes

Using Power Query to Transform Data

  • Sorting and Filtering Data
  • Merge and Append Data
  • Split, Group and Replace Data

Introduction to Power View

  • Power View Overview
  • Who would use Power View?

Creating Basic Power View Reports

  • Exploring the Power View Designer
  • Data Source Options
  • Creating Bar and Line Charts
  • Using View Filters

Optimizing Power Pivot Models for Power View Reporting

  • Setting Report Properties in the Model
  • Adding Images to the Model
  • Adding Tooltips and Default Aggregates

Creating Interactive Reports with Power View

  • Adding Slicers for Filtering
  • Creating Animated Scatter Charts
  • Leveraging Images in Your Reports
  • Using Tiles as Filters
  • Mapping Geography Data
  • Exporting Reports

Introducing Power Map

  • Power Map Overview
  • Linking Geographical Fields to Power Map properties
  • Mapping Time Data
  • Creating a Power Map Tour

Using Power BI Q&A to Unleash your Data

  • Implementing Synonyms to Improve Search Results
  • Deploying to an Office 365 Power BI Site
  • User Interaction with Power Q&A

Course info

Course code: O202
Duration: 2 days
Price: 18 600 SEK



Related courses

Contact us for details

+46 40 61 70 720

All prices excluding VAT