This is an example of a simple banner
☀️ It's summer at ITTA! Enjoy a 10% discount until July 31st on a selection of courses 🌴 ×

Training: Power BI – Get started

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

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

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

mer21Aoû(Aoû 21)09:00ven23(Aoû 23)17:00VirtuelAnnuléeVirtual Etiquettes de sessionMPB-11

mer21Aoû(Aoû 21)09:00ven23(Aoû 23)17:00Genève, Route des Jeunes 33B, 1227 CarougeAnnulée Etiquettes de sessionMPB-11

mer21Aoû(Aoû 21)09:00ven23(Aoû 23)17:00VirtuelConfirméVirtual Etiquettes de sessionMPB-11

mer21Aoû(Aoû 21)09:00ven23(Aoû 23)17:00Genève, Route des Jeunes 33B, 1227 CarougeConfirmé Etiquettes de sessionMPB-11

mer25Sep(Sep 25)09:00ven27(Sep 27)17:00VirtuelVirtual Etiquettes de sessionMPB-11

mer25Sep(Sep 25)09:00ven27(Sep 27)17:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionMPB-11

mer30Octven01NovVirtuelVirtual Etiquettes de sessionMPB-11

mer30Octven01NovGenève, Route des Jeunes 33B, 1227 Carouge Etiquettes de sessionMPB-11

mer04Déc(Déc 4)09:00ven06(Déc 6)17:00VirtuelVirtual Etiquettes de sessionMPB-11

mer04Déc(Déc 4)09:00ven06(Déc 6)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