Training: Power BI – Get started

Ref. MPB-11

Download PDF

Duration:

3

days

Exam:

Not certifying

Level:

Fundamental

Funding:

Temptraining

ITTA | Trainings | Collaborative Tools | Analytics Platform - BI | Power BI – Get started

Description

In this course, participants will study 150 different types of charts, from the default charts to those made with R or Python. This is an advanced data visualisation course for those who need to build high value-added dashboards. This course prepares participants for the Power BI Services training.

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

Basic knowledge of Power View and Power Map in Excel
General knowledge of BI and database modeling

Course content

Module 1: Introduction
Module 2: Power BI vs PowerPivot, Power View, Power Map and Power Query
Module 3: Recommended technical configuration
Module 4: Understand the main differences between the various licenses (free, pro, premium)
Module 5: Related Tools (Excel Analyzer, Gatweay, Report Paginer)
Module 6: Recommended tools (DAX Studio, DAX Formatter, Power BI Helper, Theme Generator etc.)
Module 7: About the ecosystem of Power BI languages (SQL, MDX, M, DAX, R, Python, Javascript, …)
Module 8: Discover and cutomize the user interface (and change UI language)
Module 9: Browse the Help register
Module 10: Creater and manage your tabs (dashboards)
Module 11: Creating datasets from Databases (Web, Odata, Azure, SSAS, SQL Server, etc.)
Module 12: Import Power View charts
Module 13: Import vs Direct Query vs Live Connection
Module 14: Creating datasets from Data Models and Data Files (*.txt, *.accdb, *.xlsbs, *.csv, *.xml, *.json, etc.)
Module 15: Create tables “on the fly”
Module 16: Renaming Queries
Module 17: Best practices (naming convention, synonyms for the Q&A, commenting, R, Python, corporate template creation, etc.)
Module 18: Combining (append) Queries
Module 19: Fixing Metadata
Module 20: Filtering Rows
Module 21: Sorting Rows
Module 22: Eliminating columns
Module 23: Combing (merge) queries
Module 24: Adding a column
Module 25: Concatenating columns
Module 26: Create relationships
Module 27: Performing a Lookup to a related table
Module 28: Using the IF function
Module 29: Special behavior of Power Query parameters with Power BI file templates
Module 30: Adding a Date Table
Module 31: Defining Hierarchies and folders/sub-folders of measures
Module 32: Configuring Properties
Module 33: Utiliser des paramètres dynamiques
Module 34: Create a calendar table (with DAX)
Module 35: Manage links between tables
Module 36: Defining New measures with DAX (with or without quick measures)
Module 37: Adding visuals (table, clustered column chart, bar chart, map, card, matrix, kpi, …)
Module 38: Switch to Mobile/PC view designer
Module 39: Create What If parameters
Module 40: Filterings and Drilling visuals
Module 41: Slicer Filtering
Module 42: Control the links between the visuals and the filters
Module 43: Control the influence of interactions on visuals
Module 44: Refreshing Datasets
Module 45: Scheduling Data Refresh
Module 46: Export as a model as a PivotTable in Excel
Module 47: Performance Analyzer

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.