Learning Power BI

On site MS Power BI trainings

Power BI courses

We are ready to organize the trainings at your office or external site, customized for your company or team. We welcome any participants from beginners to experts, moreover, according to your needs, we deliver trainings specifically for programmers. We prepare our presentations with customized content, including sample data typical to your industry and reporting solutions.

Optimal number of participants: 5-15

Goal:

  • In one day, we introduce the main functions of Power BI, and major components
  • We create a simple report in Power BI Desktop, which is capable to render both in web browser and mobile device.
  • We publish the report to Power BI Service in the cloud, and create a dashboard with natural language query (Q&A)
  • We open the published report and the dashboard in a web browser and on a mobile device, and we learn the relevant functions
  • We share the report with our colleagues and
  • Finally, we print and export the report and the data in different formats.

 To whom this training could be useful?

  • Power BI end users
  • Power BI report creators, focusing on data visualization

Contents:

Introducing the Power BI ecosystem

Power BI Desktop:

  • Loading data from different data sources to the Power BI data model
    • Differences between imported and DirectQuery datasets
    • Learn about the basic types of data sources, Excel, SQL Server, Web
    • Basic data transformation and data cleansing functions in PowerQuery
  • Creating reports from the data model using different visualizations
    • Basic elements: text, image, shapes, buttons
    • Table and matrix
    • Filters and slicers
    • Bar and column charts
    • Trend analysis visuals
    • Distribution visuals
    • Maps
    • Mobile reports
    • R and Python visuals
    • AI-driven visuals
  • Publish to the Power BI Service

Power BI Service:

  • Introducing Power BI Home
  • Workspaces - dashboards, reports, datasets
  • Creating dashboards from existing reports and using the Q&A function
  • Functions regarding opening reports and dashboards in a browser
  • Collaboration: share and comment reports and dashboards
  • Printing and exporting reports and dashboards

Power BI Mobile:

  • Functions regarding opening reports and dashboard on mobile devices
  • Differences between portrait and landscape modes
  • Collaboration: share and comment reports and dashboards

Goal:

  • Learn the possibilities in Power BI and major components in detail
  • We create a simple report in Power BI Desktop, which is capable to render both in web browser and mobile device
  • We publish the report to Power BI Service in the cloud, and create a dashboard with natural language query (Q&A)
  • We open the published report and the dashboard in a web browser and on a mobile device, and we learn the relevant functions
  • We share the report with our colleagues, we print and export the report and the data in different formats.
  • We learn to use different data sources, import, DirectQuery and composite datasets
  • Data modeling and the basics of the DAX language
  • Data storytelling, with bookmark navigation and interactive reporting methods

To whom this training could be useful?

  • Users working with Excel functions and reports, Power BI report builders (e.g. business analysts, controllers, financial specialists)
  • For users wanting more than they can learn on the 1-day training

Contents:

 Introducing the Power BI ecosystem

 Power BI Desktop:

  • Loading data from different data sources to the Power BI data model
    • Import datasets, DirectQuery and composite data models
    • Learn about many types of data sources, CSV, Excel, SQL Server, Folder, Web, Pdf, Access etc.
    • Deep knowledge of the features of PowerQuery
    • Optimization methods, best practices
  • Data modeling with the VertiPaq engine
    • Data model: tables, relationships and hierarchies
    • Types of relationships, cross-filter directions, active/inactive relationships
    • Data modeling best practices
    • DAX language basics, computed columns and measures, computed tables, writing simple DAX queries
    • Quick Measures
    • Creating what-if analysis based on parameters
  • Creating reports from the data model using different visualizations
    • Basic elements: text, image, shapes, buttons
    • Table and matrix
    • Filters and slicers
    • Bar and column charts
    • Trend analysis visuals
    • Distribution visuals
    • Maps
    • Mobile reports
    • R and Python visuals
    • AI-driven visuals
  • Reporting techniques with Bookmarks
    • Bookmarks, spotlights
    • Differences between bookmarks created by the report developer and personal bookmarks
    • Navigation with bookmarks
    • Data storytelling, slideshows
  • Publish to the Power BI Service

 Power BI Service:

  • Introducing Power BI Home
  • Workspaces - dashboards, reports, datasets
  • Creating dashboards from existing reports and using the Q&A function
  • Functions regarding opening reports and dashboards in a browser
  • Collaboration: share and comment reports and dashboards
  • Printing and exporting reports and dashboards

 Power BI Mobile:

  • Functions regarding opening reports and dashboard on mobile devices
  • Differences between portrait and landscape modes
  • Collaboration: share and comment reports and dashboards

Goal:

  • Learn the possibilities in Power BI and major components in detail
  • We create a simple report in Power BI Desktop, which is capable to render both in web browser and mobile device
  • We publish the report to Power BI Service in the cloud, and create a dashboard with natural language query (Q&A)
  • We open the published report and the dashboard in a web browser and on a mobile device, and we learn the relevant functions
  • We share the report with our colleagues, we print and export the report and the data in different formats.
  • We learn to use different data sources, import, DirectQuery and composite datasets
  • Data storytelling, with bookmark navigation and interactive reporting methods
  • PowerQuery and Power BI Dataflows in detail
  • Learn the DAX language in detail
  • Learn advanced data modeling

To whom this training could be useful?

  • BI/DWH developers
  • For users wanting more than they can learn on the 2 day training 

Contents:

Introducing the Power BI ecosystem

 Power BI Desktop:

  • Loading data from data sources:
    • Power Query M Formula Language basics, functions, parameters, templates
    • Import datasets, DirectQuery and composite data models
    • Learn about many types of data sources, CSV, Excel, SQL Server, Folder, Web, PDF, Access etc.
    • Deep knowlege of the features of PowerQuery
    • Optimization methods, best practices
  • Dive deep into the DAX language
    • Resolve various tasks with DAX
    • Table functions
    • CALCULATE function
    • DAX date and time functions, date table
    • Virtual Relationships in DAX
    • DAX samples: dynamic slicers, parameter table, segments, dynamic X axis, Top N and others, rankings
    • DAX virtual tables
    • Optimizing DAX queries with DAX Studio
  • Data modeling with the VertiPaq engine:
    • Optimize data set performance with composite model and aggregation
    • Handling bidirectional cross-filtering issues
    • Avoid circular dependencies
    • Data model: tables, relationships and hierarchies
    • Types of relationships, cross-filter directions, active/inactive relationships
    • Data modeling best practices
    • DAX language basics, computed columns and measures, computed tables, writing simple DAX queries
    • Quick Measures
    • Creating what-if analysis based on parameters
  • Creating reports from the data model using different visualizations
    • Basic elements: text, image, shapes, buttons
    • Táblázat és matrix
    • Filters and slicers
    • Bar and column charts
    • Trend analysis visuals
    • Distribution visuals
    • Maps
    • Mobile reports
    • R and Python visuals
    • AI-driven visuals
  • Reporting techniques with Bookmarks:
    • Bookmarks, spotlights
    • Differences between bookmarks created by the report developer and personal bookmarks
    • Navigation with bookmarks
    • Data storytelling, slideshows
  • Publish to the Power BI Service

Power BI Service:

  • Introducing Power BI Home
  • Workspaces - dashboards, reports, datasets
  • Creating dashboards from existing reports and using the Q&A function
  • Functions regarding opening reports and dashboards in a browser
  • Collaboration: share and comment reports and dashboards
  • Printing and exporting reports and dashboards
  • Loading data from data sources
  • Dataflows

Power BI Mobile:

  • Functions regarding opening reports and dashboards in a browser
  • Differences between portrait and landscape modes
  • Collaboration: share and comment reports and dashboards

Why choose us?

Because we teach by doing and demonstrating, with more than one instructor if needed, solving specific use cases, even specific programming tasks to show the possibilities of reporting in Power BI.

Our teachers are developers working with BI technologies every day, experienced in numerous project and have current Power BI certifications.

Companies we trained: