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

  • 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

  • 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

  • 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

Designing Reports in Power BI Desktop

  • 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 Group 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 Dashboards with internal users
  • Sharing Dashboards with external users
  • Sharing content with Office 365 groups
  • Creating Content Packs
  • Consuming Content Packs
  • Using Publish to Web with Dashboards

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.

© 2017 U2U All rights reserved.