Learnit Training
Course Power BI Sequel
  • Small groups
  • Covid-19 safe
  • Experienced teacher
  • Possible online
  • Practical training

Even more insight into your management information? Get the maximum from Microsoft Power BI? Learn it in the 2-day course Power BI sequel of Learnit.

Yes, I want to know more

Course Power BI Sequel

Do you already make your management reports in Power Bl? Become a Microsoft Power BI professional with Learnit's two-day follow-up Power BI course. The core of this Power BI Continuous training lies in the numerous possibilities with DAX Functions in Power BI. During the training various demonstrations will be given about different types of DAX formulas, sometimes simple, in the beginning often quite difficult. The purpose of all these tasks is to get acquainted with the DAX formulas and to learn to recognise the different types. You will learn how to import, combine and enrich data from different file types, and how to add complex calculations and measurements to your data. You will also learn to create advanced visuals for even more insight into your financial results. An intensive and practical business intelligence follow-up course for Power BI super users who want to get the most out of the program.

Topics

In The two-day course Power BI sequel, the following topics are covered:

  • Repetition of basic principles of Power BI:
    • Making data transparent
    • Power Query Editor
    • Power BI Desktop and Online
  • Importing data sources
    • Importing data via Query Editor
    • Dynamic file location with Parameter
  • Structuring data in the Query Editor
  • Structure, modify and expand data
    • Structuring data in the data view
    • Activating/deactivating relationships
    • Expand data
  • DAX Functions and formula tables
    • DAX Function Categories
    • Calculated columns with RELATED
    • Sum of calculated columns with SUMX
  • Calendar table as the core of the data model
    • Adding, modifying, expanding and dynamically creating DAX Calendar
    • Time Intelligence Functions
  • Expand data model with Tables & Relationships
  • The Power BI Report View
    • Bookmarks
    • Slicer Synchronization
    • Importing themes from the Internet
    • Create templates for your own corporate identity
    • Editing interactions between visuals
    • Locking objects
    • Parameter tables
    • What if parameters
    • Expand standard Visual Pallet from the MarketPlace
  • DAX Features & Formulas
    • CALCULATE
    • Using parameters in DAX formulas
    • Parameters in the Query Editor

Target

Do you use Microsoft Power BI but the standard reports and presentations don't fully meet your needs? The follow-up Power BI course is intended for financial professionals who make reports in Microsoft Power BI and want to get the most out of the program. For even more insight and even better control information.

Lesmethodiek

In The Power BI course you will learn by using examples from your daily practice and a practical workbook to get even more out of your financial reports and dashboards with the Business Intelligence tool Power BI. Theory and practice alternate between each other and you will get to work directly with the scholar on one of the Cursuslap tops. There is plenty of opportunity to practice with Power BI and ask questions.

This course uses Microsoft Power BI and Microsoft Excel.

Results

After completion of the course Power BI sequel:

  • Do you know how to import, combine and enrich data in Power BI
  • you can import data from various external sources
  • Can you use data analysis to create complex connections and relationships between data
  • Do you know how to explain differences between measurements and calculated columns
  • Easily apply advanced calculation formulas to your data using DAX.
  • you really know all about data visualization report display in Power BI
  • Can you effectively create data tables
  • Can you apply conditional formatting and visualizations to your tables
  • you can work with (homemade) templates
  • you can work with the DAX Calendar and Time Intelligence features

Prior knowledge

To follow the course Power BI Follow-up, prior knowledge on the level of the training Power BI Basis is required.

Language

The training is provided by default in Dutch. The trainer controls the English language. English course material can be used. When registering at least 3 participants, the training can also be provided entirely in English.

Investment

Mentioned prices are per person, including course material. Lunch is included in the training on location.

On location Online
Duration 2 days 4 sessions of three hours
Price per day, excl. VAT € 425,- € 340,-
Total, incl. VAT € 1028,50 € 822,80

Certificate

After completing the training, a LEARNIT certificate will be issued as proof of participation.


Online

We also organize this training online. For this we use Webbex or Zoom. Logging in with Skype is also possible. On request this training can also be organized with Microsoft Teams.

The training lasts 4 sessions of 3 hours, spread over 4 weeks.

  • Until one year after the training you can participate for free.
  • Against payment of the catering costs you can also participate in a classroom training.

References

De cursus Power BI Vervolg is beoordeeld met een gemiddelde van 8.4.

"This training is suitable if you enjoy Power BI and want to get more out of it. You will learn two important things: how to neatly arrange and combine data and how to effectively use the most important functions."

- Power BI Continued