Training: Power BI – Get started

Ref. MPB-11

Download PDF

Duration:

3

days

Exam:

Not certifying

Level:

Fundamental

Funding:

Temptraining

ITTA | Trainings | Office Automation | Power BI – Get started

Description

In this training, you will create interactive reports and dashboards. You will also learn to master Power BI Service for proficiently using the Desktop application, to understand best practices for creating high-performance reports with Power BI Desktop, and much more.

Participant profiles

Engineers
Business analysts
Data analysts and financials
Excel users who want to automate their work more efficiently than with macros

Objectives

Have the skills to use Power BI to acquire and transform data
Improve data for analysis and reporting and dashboards
Prepare for Power Query, DAX and Power BI Service training

Prerequisites

No prerequisites

Course content

Module 1: Introduction to the Power BI Ecosystem

Introduction
Recommended Technical Configuration
Understanding the Differences Between Licenses (Free, Pro, and Premium)
About the Power BI Ecosystem of Languages

Module 2: Creating Data Sets

Creating Data Sets from Relational Databases
Import vs. Direct Query vs. Live Connection
Creating Data Sets from Data Files (*.txt, *.accdb, *.xlsbs, *.csv, *.xml, *.json, etc.)
Creating Data Sets from Other Sources

Module 3: Data Transformation

Defining Metadata
Filtering Rows
Sorting Rows
Removing Columns
Renaming Queries
Best Practices (naming conventions, synonyms, comments, R, Python, creating a business model, etc.)
Combining (joining) Queries
Creating Tables “on the Fly”

Module 4: Initial Work with Visuals

Creating Visualizations in Power BI
Configuring Fields for Visualizations
Formatting Fields in the Modeling
Formatting Visuals
Trend Lines for Visuals
Page Formatting and Configuration

Module 5: Visualization and Analysis

Creating What-If Parameters
Creating Tooltip and Drill-Through Pages
Switching between Mobile and PC Views
Filtering and Drilling Down on Visuals
Segment/Dropdown Filtering
Controlling Links between Elements and Filters
Controlling Visual Interaction Effects
Data Updates
Scheduling Automatic Updates
Exporting Data Models as Pivot Tables in Excel
Performance Analyzer

Module 6: Data Management and DAX Calculations

Defining Metadata
Filtering Rows
Sorting Rows
Removing Columns

Module 7: Advanced Data Organization

Behavior of Power Query Parameters with Power BI File Models
Creating a Date Table
Customization and Controls
Creating Hierarchies or Measure Folders/Subfolders
Configuring Properties
Using Dynamic Parameters
Creating a Calendar Table (in DAX)

Module 8: Data Relationships and DAX Measures

Combining (merging) Queries
Adding a Column
Concatenating Columns
Creating Relationships

Module 9: Tools and Add-Ons

Related Tools (Excel Analyzer, Gateway, Report Paginator)
Recommended Add-Ons (DAX Studio, DAX Formatter, Power BI Helper, Theme Generator, etc.)

Module 10: Report Publishing and Sharing

Publishing a Report
Using Power BI Services Bookmarks
Sharing a Report and Managing Shares
Generating a QR Code for Easy Sharing
Creating, Managing, and Using Datasets

Documentation

Digital courseware included

Complementary courses

Power BI – Services | MPB-22

Temptraining funding

ITTA is a partner of Temptraining, the continuing education fund for temporary workers. This training fund can subsidize continuing education for anyone who works for an employer subject to the Collective Work Agreement (CCT) Rental of services.