Power BI Advanced (English)

Power BI Advanced Course (English)

The Power BI Advanced training course is a 2-days practice-oriented course in which we elaborate on the use of Power BI Desktop and is the follow-up to the Power BI Basics Course. Among other things, we pay attention to the proper design of a model and choices for column calculations or measurements. DAX is a formula language with which you can perform all kinds of calculations with your data in Microsoft Power BI. The language is comparable, sometimes even identical, to Excel formulas. But with DAX even more is possible and the usage is a bit more complex. Working with DAX functions is lifted to a higher level, and we will work out the extra visualizations further in the training.

Who is this course for?

This training is designed for professionals who already work with Power BI and want to use it at a more advanced level. Think of controllers who need to build forecasting models, data analysts dealing with complex or large datasets, and BI specialists who want to master DAX properly and improve their data model design. Participants typically come from finance, analytics, operations, HR, or sales. The course is taught entirely in English, which makes it well-suited for international teams and organisations working in English. Not sure if this course matches your level? Feel free to contact us.

What you will be able to do after this course

• You apply advanced DAX functions, including filter functions, time intelligence, iterator functions, and statistical calculations
• You design proper semantic data models with star schemas, fact tables, dimension tables, and optimised relationships
• You build forecasting models and cumulative calculations using time-based DAX patterns
• You create dynamic reports using bookmarks, field parameters, drill-through, and visual calculations
• You implement row-level security to control data access per user role
• You use the CALCULATE function confidently and understand row context, query context, and filter context
• You publish and manage reports in Power BI Online with the right workspace structure

Prerequisites

For the Power BI Advanced course, you need advanced Excel skills and a solid working knowledge of Power BI Desktop and Power BI Online. This includes basic data modelling, working with Power Query, and writing simple DAX measures. The Power BI Basic course at SignOn is the natural preparation. Not sure if your background is sufficient? Contact us via contact or call us at 020 820 83 62.

Why SignOn for this course?

There are many IT training providers in the Netherlands. Yet organisations and professionals choose SignOn time and again. There are concrete reasons for that.

• Expert trainer-consultants: Only certified professionals (such as MCTs) with at least ten years of hands-on experience.
• Personal attention: Small groups with plenty of room for your specific learning goals and direct lines of communication, also after you finish.
• Own learning approach: Always up-to-date, proprietary course materials combined with a strong blended learning methodology.
• Including aftercare: Up to one year of direct support from your trainer-consultant for practical questions after the training.

Blended Learning at SignOn

The ‘classroom live’ and ‘virtual classroom’ Power BI course is supported by the digital SignOn Learning Environment with an introduction video, up-to-date course materials, various exercises and a handy Power BI installation document so you can briefly prepare for your training. At SignOn, learning does not stop after attending this two-day training course. You can ask questions to our trainers for one year and get access to the learning portal for one year with additional exercises, useful tips & tricks, monthly update videos on the latest Power BI features and an invitation to a free webinar.

Practical information

Duration: 2 days
Language: English
Course materials: You receive digital English-language course materials, including a PDF reference guide. You also get one year of access to a learning portal with exercises, tips, and monthly update videos on new Power BI features.
Format: Classroom at a location in the Netherlands, virtual classroom via Microsoft Teams, or in-company tailored to your organisation (available in English, Dutch, and German)

Certificate

After the training you will receive a certificate.

Follow-up course

After the Power BI Advanced course, the logical next step is the Power BI Expert Course. That course takes you deeper into advanced Power Query techniques, performance optimisation, and building scalable reporting solutions. It is the right choice if you want to work at an expert level and build complex, enterprise-grade Power BI environments.

Exclusive aftercare

Any questions after the Power BI Advanced course? Please contact your trainer at [email protected]. You will receive a quick response with extra explanation; by phone or e-mail. This aftercare service is exclusively for participants of our training courses.

Meet your trainer

This training is given by one of our Power BI experts. They have years of experience and current knowledge. They know what you encounter every day and provide useful tips and tricks. Because they not only provide training but also work as Power BI consultants. Meet our Power BI trainers:

Jeroen

Freddy

More information