Call Us: +32 2 466 00 16
Email: info@u2u.be
Follow Us:

Analyzing your data with Power BI for Business Users

3days
Training code
UBIPBE
Book this course

Introduction to Power BI

This module introduces the fundamental concepts of the Power BI platform. It provides a high level overview of the Power BI Desktop and Power BI Cloud Service. Participants will also setup a trial Office 365 subscription which will be used throughout the course when publishing Power BI artifacts and sharing Power BI artifacts.

  • The need for Business Intelligence
  • Self-Service BI versus Enterprise BI
  • Core concepts of Power BI
  • Introducing Power BI Desktop
  • Introducing the Power BI Service

Getting started with Power BI Desktop

This module provides an overview of Power BI Desktop. Participants learn the basics of how to create Queries to extract data from a datasource. Also the basic on how to create a Data Model and Report are explained in this module

  • The Power BI Desktop User Interface
  • Creating Queries to load data
  • Building a basic Data Model
  • Creating a basic Report
  • Publishing to the Power BI Service

Enhancing a Data Model in Power BI Desktop

Participants learn how a data model can be enhanced by building hierarchies inside tables, giving column sa meaningful name and data type. Participants also learn about the importance of having the correct relationships between tables

  • Renaming columns and tables
  • Hiding columns and tables from the Data Model
  • Column data type and formatting
  • Working with numerical fields
  • Sorting data in columns
  • Data categorization
  • Defining Hierarchies based on a single table
  • Defining relationships between tables
  • Working with Grouping and Binning
  • Working with Quick Measures

Designing Reports in Power BI Desktop

Participants explore all of build-in the visualizations in Power BI Desktop. Also the concept of slicers and filtering is converted in this chapter. Last but not least, participants learn how to work with custom visuals.

  • Overview of the build-in Visuals
  • Creating table and Matrix Reports
  • Working with Charts
  • Plotting spatial data
  • Using Slicers and Report Filters
  • Working with custom Visuals

Introduction to Power BI Service

  • What is the Power BI Service?
  • Power BI Service pricing and features
  • Working with Datasets and Reports

Creating Datasets and Reports in Power BI Service

  • Personal vs App Workspaces
  • Creating Datasets in the Power BI Service
  • Using Quick Insights
  • Creating Reports in Power BI Service
  • Printing Reports
  • Export to PowerPoint
  • Using Publish to Web with Reports
  • Analyze in Excel

Creating Dashboards and Analyzing Data with Power BI Service

  • Creating Dashboards
  • Printing Dashboards
  • Working with Power BI Q&A

Sharing Content in the Power BI Service

  • Sharing Reports and Dashboards with internal and external users
  • Sharing content with Office 365 groups
  • Creating Power BI Apps
  • Consuming Power BI Apps
  • Using Publish to Web with Reports

Using Power BI with Mobile Devices

  • Supported Platforms
  • Designing Dashboards for mobile devices
  • Accessing Reports and Dashboards from mobile devices

Power BI is a suite of business analytics tools to analyze data and share insights. Power BI Desktop transforms your company's data into rich visuals for you to monitor your business and get answers quickly with rich dashboards available on every device.

In this training you learn how to write queries with Power BI Desktop and Power BI Excel to collect data from databases, cubes, online Excel files, Facebook.... You will learn how to enrich the data model with relationships, hierarchies, DAX calculated columns and measures... And finally you will see how to create interactive reports using the large set of visualization available in Power BI Desktop and share them using PowerBI.com and Power BI Mobile apps.

If you are also interested in more technical topics like the the Power Query language, the languages R and DAX and Power BI Gateways, we recommend you to follow our 5-day course Analyzing your data with Power BI for BI Professionals.

This course is intended for people who have no prior knowledge of Power BI.

If you are also interested in more technical topics like the the Power Query language, the languages R and DAX and Power BI Gateways, we recommend you to follow our 5-day course Analyzing your data with Power BI for BI Professionals.

© 2018 U2U All rights reserved.