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

Upcoming sessions

19 Aug 2019
28 Oct 2019
16 Dec 2019
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 basics 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 and Refreshing Data
  • 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 and by giving columns a meaningful name and data type. Furthermore, measures and calculated columns can be created using DAX. 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
  • Creating Hierarchies in tables
  • Defining calculated columns and measures using DAX
  • Working with Quick Measures
  • Defining relationships between tables

Designing Reports in Power BI Desktop

After the model has been fine-tuned, we can use it to create our reports. Power BI allows you to create very impressive reports, and in this module we will explore many visualizations as well as the interaction between these visualizations.

  • Overview of the Report Canvas
  • Adding textboxes, shapes and images
  • Using built-in visualizations
  • Add style and branding through themes
  • Printing a Power BI Report
  • Creating Power BI Templates

Enhancing Reports in Power BI Desktop

Sometimes a static report just isn't enough. In this module you'll learn how to make interactive reports which are easy to use for any type of end user. Take your reports to the next level.

  • Working with Slicers and Filters
  • Working with Drillthrough report pages
  • Working with Bookmarks
  • Visual hierarchies and drill-down behavior
  • Grouping and Binning
  • Using Custom Visuals
  • Create reports that are optimized for phones
  • Miscellaneous features

Introduction to Power BI Service

If you want to share models and reports with you co-workers, the Power BI service allows you to upload these to the cloud, and manage and share them with others. In this module you will learn about the general features of the Power BI service, the next modules dive into the details.

  • What is the Power BI Service?
  • Power BI Service pricing and features
  • Working with Datasets and Reports
  • Creating and using App Workspaces

Creating Datasets and Reports in Power BI Service

For some types of reporting you do not want to go through the hassle of creating a dataset in Power BI Desktop. That's why for a limited set of data sources we can start using them directly from the Power BI service without the need to first create an offline model. In this module you'll learn how to create these models directly in the Power BI Service.

  • Creating Datasets in the Power BI Service
  • Using Quick Insights
  • Creating Reports in the Power BI Service
  • Printing Reports
  • Export to PowerPoint
  • Embedding Reports in SharePoint Online
  • Analyze in Excel

Creating Dashboards and Analyzing Data with Power BI Service

Dashboards allow you to combine visuals from different reports into one page for quick access. This module teaches you to build and customize these dashboards in the Power BI Service.

  • Creating Dashboards
  • Printing Dashboards
  • Configuring Dashboards for Mobile Devices
  • Working with Power BI Q&A
  • Analyze in Excel

Sharing Content in the Power BI Service

Power BI has different mechanisms to share content with other users: Sometimes you want to share in order to develop something together, or you want others to customize something, or maybe you want others to have read-only permissions on the shared object. In this module you'll learn how to accomplish this with the different sharing options in the Power BI Service.

  • Sharing Reports and Dashboards with internal and external users
  • Sharing content inside an App Workspace
  • Creating Power BI Apps
  • Consuming Power BI Apps
  • Publishing Reports to the web
  • Subscribing to Report updates
  • Report usage metrics

Using Power BI with Mobile Devices

  • Supported Platforms
  • 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.

© 2019 U2U All rights reserved.