Power BI: Core features

  • Course types: Calendar course / In company
  • Version: Office 2013/2016
  • Takes place in: Antwerp, Brussels
  • Duration: 2 days
  • Price: € 950 VAT excl. / Cheaper course?

Description

Learn the basic principles of Power BI in two days

You may have heard of Power BI and already have seen a few examples in the form of visually appealing dashboards and reports. But how do you get started with it? In this two-day course we will look at the various phases you need to cover. We will retrieve our data via queries, create a data model with the necessary relationships and calculations, build an interactive report and publish it in the cloud. Finally we will create a dashboard in the cloud that we can share with colleagues.

Choose a date and location

Objectives

After completing this course you will be able to:

  • Import data via queries
  • Use queries to transform tables into usable, meaningful data
  • Create a data model with relationships, custom sort orders, date dimension tables etc.
  • Create reports in a Power BI Desktop environment
  • Create reports and dashboards in a Power BI Service environment
  • Share reports and dashboards with colleagues

Target Group

Anyone wishing to gain a solid grounding in creating and sharing reports and dashboards via Power BI.

Prerequisites

Prior knowledge of Power BI is not required. Familiarity with entering functions manually in Excel would be a bonus since you will not have a function wizard in Power BI.

Content

Part 1: Power BI

  • What are the components of Power BI?
  • What is the difference between Power BI Desktop and Power BI Service?

Part 2: Queries

  • Importing data
  • Converting data (remove duplicates, delete records, filter, add columns, unpivot)
  • Expanding tables with data from other tables (compare Vlookup)
  • Comparing tables (What is common to them? What is only in table 1? What is the total of these 2 or more tables?)
  • Arranging similar tables horizontally

Part 3: Data Modelling

  • The different data types
  • Relationships between tables
  • Defining a date dimension table
  • Defining custom sort orders
  • Setting up data categories
  • Hiding (auxiliary) columns from the model
  • Calculated columns
  • Measures (general functions, filter functions)
  • Context

Part 4: Reports in Power BI Desktop

  • Components of a report
  • Working with tiles
  • Standard visualisation options (stacked bar, stacked column, area, treemap, map, pie, slicers etc.)
  • Ad hoc filters
  • Filters in a report (visual level filters, page level filters, report level filters)
  • Publication to Power BI Service

Part 5: Power BI Service

  • Refreshing datasets
  • Difference between reports and dashboards
  • Creating dashboards
  • Quick insights
  • Q&A (ad hoc questions about the dataset)
  • Publishing data from Excel directly to dashboards

Part 6: Sharing

  • Sharing a dashboard with colleagues
  • Embedding a report in e.g. a SharePoint page

Choose a date and location

  • Dates
  • Days
  • Timing
  • Language
  • Location
  • Planning
  •  

Request an offer



Share this course on Facebook, Twitter, LinkedIn or e-mail

Practical info

The practical info and applicable cancellation conditions related to this training course.

 

Choose a date and location

€ 950 VAT excl.
Cheaper course?

Requesting a quotation

Would you like to organize this training course for your employees? At your offices or at a Xylos training centre? We transform your requirements into the perfect solution.

Request

Discount

SEVERAL PARTICIPANTS
If you enrol several employees for the same course on the same date, you will get a discount:

  • 2 employees: 15% discount on the 2nd subscription
  • 3 or more employees: 15% discount on the 2nd subscription and 40% on further participants

Questions?

Contact Astrid De Roeck

+32 2 264 13 20
xylos@xylos.com