Power BI Training

Microsoft Power BI is a suite of business analytics tools providing cloud-based analysis of business data.

(The training sessions are usually held in German. Please contact us if you are interested in training sessions in English.)

Power BI Training

Target audience: Business analysts, Business users with a data affinity, Business intelligence developers
Length: 1 day ("Basic" module – pleases email to inquire about the "Advanced" and "Coaching" modules, see below) 
Dates: 11.02.2019 (Karlsruhe)
Times: 9 am – 5 pm 
Number of participants: min. 2, max. 8 
Price: 600 euros plus VAT

Using Power BI, you can analyze, evaluate and visualize business data in real time and by using the self-service method. This allows business users to easily obtain knowledge from their data and make informed decisions.

We have developed a training course that can be tailored to meet the exact demands of participants due to its modular structure:

  • “Basics” module (1 day)
  • “Advanced” module (1 day)
  • “Coaching” module (n days)

The above date relates to the “Basics” module (1 day). If you are interested in the “Advanced” or “Coaching” modules, please contact us directly by emailing patrick.maul@inovex.de or stefan.kirner@inovex.de. Thank you!

“Basics Training” module [1 day]

Theory:

  • Business Intelligence Basics and the evolution of Power BI
  • Overview of Power BI services – Power BI Desktop, Service, Report Server, Power BI Embedded
  • Interaction with other Microsoft data platform services
  • Introduction into data modelling – what are relations, keys, normalization and why are these important for us?

Hands-on:

  • Provision of sample data
  • Data import – Flat File connection
  • Data transformation – data cleansing, calculated columns, relations
  • Data visualization – diagrams, filters, buttons
  • Publication – Power BI Service, Power BI Report Server

 

Note:

  • The course fee includes training documentation, lunch, beverages and snacks.
  • Participants must bring their own notebook computer to the training.

Trainer:

Patrick Maul is a consultant and developer for business intelligence at inovex. He is a certified expert in Microsoft Power BI and has proven his capabilities in this field with a number of projects and training courses run in conjunction with specialist and IT departments.

(Also available to book)
„Advanced & Bring your own data“ module [1 day]

Theory:

  • Advantages and disadvantages of various modelling methods
  • Examples of data models from practice
  • Acquaintance with DAX language
  • Row-level security
  • Creating your own tables with inquiries
  • Inserting your own calculations
  • Creating code definitions
  • Using existing time intelligence in Power BI
  • Creating temporary tables
  • Making calculations more dynamic
  • Data gateways
  • Power BI Embedded
  • Performance optimizations
  • Power BI storytelling
  • Scaling Power BI with analysis services tabular models

Hands-on:

  • Hands-on connection with your company’s data sources
  • Data modelling, transformation and visualization of your data
  • Practical exercises using DAX language
  • Instructions and tips on designing reports
  • Integration into your ecosystem

A single day course will not always contain the entire scope of topics. Instead, the individual training sessions will provide information on focal points that have been decided with the participants at the start of the day.

(Also available to book) 
"Coaching“ module [contingent n day]

Individual consultation and coaching on Power BI

Example topics:

  • Connection of complex data sources
  • Doctor's Inn: Surgery for employees of your company to ask their own questions about Power BI
  • Creation of an authorization concept
  • Creation of corporate design guidelines & templates
  • Migration to the analysis services tabular model
  • And much more, by arrangement