Informatec Power BI

Microsoft Power BI Modular TRAINING

Business analysts need to identify potential opportunities and weaknesses within companies and develop effective solutions. Our training provides the right skills for all knowledge levels and industries to leverage Power BI professionally.

Informatec Power BI Modular Training

 

COURSE DESCRIPTION

The Microsoft Power BI training is a scenario-based, modular course that provides a structured introduction to Power BI over three days, covering everything from the basics to advanced features. A key advantage for companies: the training can be tailored to participants’ existing knowledge. Power users can attend individual days without repeating content they already know. Trainers coordinate with the client in advance to ensure the course is customized and highly effective. Participants learn best practices for data modeling, calculations, and visualization, connect data from multiple sources, transform it using Power Query, and create DAX calculations — including filter manipulation and time-intelligence functions. Additionally, they learn how to manage, share, and efficiently deploy reports and dashboards. Practical examples, design concepts, and a look at upcoming Power BI features round off the training.

 

TARGET AUDICENCE

This course is aimed at companies and teams who want to systematically build their Power BI skills, regardless of previous experience. It is ideal for teams with varying skill levels and organizations that want participants to learn at their own pace. Companies with at least three Power BI users can benefit from compact, hands-on group training for up to ten participants, offering optimal cost-efficiency. No prior experience with Power BI is required, but participants should have basic Excel and data analysis skills. Familiarity with relational and non-relational data is helpful but not required, as is knowledge of cloud technologies and web applications.

 

CONTENTS

  • Introduction to Power BI
  • Connecting and transforming data
  • Creating data models
  • Developing DAX calculations
  • Designing interactive visualizations
  • Applying best practices for visualizations
  • Publishing and sharing reports
  • Implementing time-intelligence functions
  • Performing advanced analyses
  • Exploring new and upcoming features
  • COURSE REQUIREMENTS

    • Knowledge of working with data
    • Understanding of data analysis and visualization concepts
    • Excel skills are an advantage
    • A general affinity for data is beneficial
    • The course content builds on each other; knowledge from earlier training days is required for later topics
  • TECHNICAL REQUIREMENTS

    • Microsoft Power BI Desktop (free download)
    • PC or laptop with a Windows operating system
  • TARGET GROUP

    • Business Users
    • Business Analysts
    • Data Analysts
    • Data Architects
  • LANGUAGE

    • German
    • English on request
  • TRAINING MODALITIES

    • Virtual / On-site
    • Public / Private (for groups of up to 10 persons)
  • DURATION

    • 3 individual training days - can be booked and combined flexibly

Detailed Program Training Microsoft Power BI Modular

  • Introduction to Power BI

    • Overview of Power BI and use cases
    • What is ETL? – Loading data with Power Query
    • Getting started with data modeling
    • Creating your first calculation
    • Creating your first visualization
  • Advanced Data Modeling & Visualization

    • Further Calculations with DAX – Understanding Filter Context
    • Advanced Data Visualization
    • Learning Resources and Tools
    • Understanding How a Power BI Data Model Works
    • Data Modeling: Analyzing Details
  • Extended Data Preparation, DAX & Visualization

    • Next Steps with Power Query (Creating Parameters, Importing Specific Data, Analyzing Data Quality)
    • Advanced Calculations with DAX
    • Calendar Calculations – Time Intelligence
    • Functions for Advanced Data Analysis – Advanced Analytics
    • Visualization Best Practices

REQUEST FOR MICROSOFT POWER BI TRAINING

I hereby agree to the privacy policy.

* Mandatory field to answer your request

Our Microsoft Power BI Expertise

CHOOSE THE RIGHT TRAINING PARTNER!

  • LONG-STANDING MICROSOFT PARTNER

    Informatec Microsoft Partner

  • CERTIFIED POWER BI DATA ANALYSTS

    Informatec certified Data Analyst

  • MICROSOFT CERTIFIED TRAINER
     

    Informatec Microsoft certified Trainer

You are in good hands at the Informatec Data Intelligence Academy. Data is our passion and turning people into data experts is our vocation. In addition to Power BI training, as a Qlik Authorised Training Partner we offer official Qlik training courses.

Visit our Qlik Academy

 

The locations

The training courses take place at the COOP Tagungszentrum Muttenz (Basel-Land) or at the Ambassador House Zurich, where participants find the perfect setting for their training.

COOP convention center Muttenz (Basel Area)

  • COOP_Tagungszentrum
  • COOP_Tagungszentrum
  • COOP_Tagungszentrum
  • COOP_Tagungszentrum
  • COOP_Tagungszentrum

Ideal location: 15 minutes’ ride from Basel city centre (tram line 14, stop Freidorf), a few kilometers from the highway, parking available

First-class infrastructure: spacious premises, innovative working environment with modern conference facilities, all rooms with natural daylight, soundproof doors and air conditioning

Pleasant atmosphere: idyllic park, restaurant with market-fresh cuisine, professional service team

Address: COOP Tagungszentrum, Seminarstrasse 12-22, 4132 Muttenz

Route

 

Ambassador House Zürich

  • Ambassador House Zürich
  • Ambassador House Zürich
  • Ambassador House Zürich
  • Ambassador House Zürich

In the heart of Zurich North: The district offers a modern residential environment, many new restaurants, numerous shopping opportunities and a recreation area with its own lake. The Ambassador House is easily accessible by car and public transport. Underground parking available.

Hotspot for seminars: With various meeting rooms, conference rooms and auditoriums. State-of-the-art technology, first-class facilities, catering of choice and extensive services.

Hospitality at a high level: In the Ambassador House and Spaces, experience the flair of the coworking area and move around in a modern city island!

Adress: Ambassador House, Thurgauerstrasse101, 8152 Opfikon

Route