Details

Goals

Create reports with Power BI Desktop

Be able to manipulate data in Power Query

Be able to manipulate a data model in Power Pivot

Prerequisite

Knowledge of the Windows work environment

Contents

Interface

  • What is Power BI?
  • Basic Concepts
  • Components of Power BI Desktop:
    • Power Query
    • PowerPivot
    • Power View

Import data

  • Load data from different sources:
    • Excel files
    • Text files
    • Relational Databases
    • Web Pages
  • Updating Data

Data Model

  • Create relationships in the data model
  • Add measures (aggregate calculations) to a table
  • Unidirectional and bidirectional filters
  • Add a column of data
  • Using date and time data
  • Introduction to DAX (Data Analysis eXpressions)

Visualizations

  • Create a simple report
    • Charts
    • Tables
    • Matrixes
    • Slicers
  • Add visualizations
  • Filter a page
  • Filter a report
  • Explore data from a visualization (drill down)

Power Query

  • Transform Data:
    • Sort
    • Filter
    • Exclude rows depending on their positions
    • Data types
    • Pivoting data
    • Unpivoting data
    • Group Data
  • Duplicate a query
  • Create a reference to an existing query
  • Add columns:
    • Use the automatic features
    • Use functions
  • Combine queries:
    • Append a query to another query
    • Merge queries
  • Add parameters
  • Create a function
  • Overview of the advanced editor

Online Power BI

  • Share data by using the Microsoft Power BI services

Sign up

Next session(s)

Mon. 04 Jul. Tue. 05 Jul. 2022

Thu. 14 Jul. Fri. 15 Jul. 2022

Wed. 28 Sep. Thu. 29 Sep. 2022

Need a custom training?

None of the trainings fit your requirements? You have specific needs? Key Job trainers are versatile and flexible. Contact us!