Training: Power BI – Get started

Ref. MPB-11
Duration:
3
 days
Exam:
Not certifying
Level:
Fundamental

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

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.
Prix de l'inscription
CHF 2'150.-
Inclus dans ce cours
  • Training provided by an industry expert
  • Digital documentation and materials
  • Achievement Badge

mar13Juin(Juin 13)09:00ven16(Juin 16)17:00VirtuelFeaturedVirtual Etiquettes de sessionMPB-11

mar13Juin(Juin 13)09:00ven16(Juin 16)17:00Genève, Route des Jeunes 33B, 1227 CarougeFeatured Etiquettes de sessionMPB-11

mer02Aoû(Aoû 2)09:00ven04(Aoû 4)17:00VirtuelVirtual Etiquettes de sessionMPB-11

mer02Aoû(Aoû 2)09:00ven04(Aoû 4)17:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionMPB-11

mer13Sep(Sep 13)09:00ven15(Sep 15)17:00VirtuelVirtual Etiquettes de sessionMPB-11

mer13Sep(Sep 13)09:00ven15(Sep 15)17:00Genève, Route des Jeunes 33B, 1227 Carouge Etiquettes de sessionMPB-11

mer11Oct(Oct 11)09:00ven13(Oct 13)17:00VirtuelVirtual Etiquettes de sessionMPB-11

mer11Oct(Oct 11)09:00ven13(Oct 13)17:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionMPB-11

mer15Nov(Nov 15)09:00ven17(Nov 17)17:00VirtuelVirtual Etiquettes de sessionMPB-11

mer15Nov(Nov 15)09:00ven17(Nov 17)17:00Genève, Route des Jeunes 33B, 1227 Carouge Etiquettes de sessionMPB-11

mer20Déc(Déc 20)09:00ven22(Déc 22)17:00VirtuelVirtual Etiquettes de sessionMPB-11

mer20Déc(Déc 20)09:00ven22(Déc 22)17:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionMPB-11

Horaires d’ouverture

Du lundi au vendredi, de 8:30 à 18:00.

Contactez-nous

Votre demande

Opening hours

Monday to Friday, from 8:30 am to 06:00 pm.

Contact us

Your request

X
X
X
X