Power BI Basic (English)

Power BI Course – Basic (English)

After completing this 2-day Power BI Basics training, you will be able to create advanced analyses, build interactive reports, and create data models in Power BI. An ideal course for people starting with Power BI.

Importing Data

You will learn how to import data using queries from local and cloud-based sources such as Excel, SharePoint, AFAS, and SQL databases with the help of Power BI, Microsoft’s interactive tool.

Sharing data with colleagues
Would you like to share this data with your colleagues in a quick, easy and save way? We will help you gain extensive knowledge of the many possibilities of Power BI Desktop and Online. In this training, you will also learn how to set up a solid Power BI model with Dim (dimension) and Fact tables. This ensures your report not only looks good but also works fast – even with millions of rows of data.

DAX formula language
Power BI uses the advanced formula language DAX (Data Analysis Expressions) for calculations. This formula language is similar to Excel but offers more possibilities and is slightly more complex. Our trainers guide you through the most important basic functions of DAX using recognizable examples.

Power Query
With the Power Query Editor, you will learn to gather data, clean it up, and enrich it. After designing a data model, you can start creating an interactive report. Finally, you will learn how to publish your created reports in Power BI online and how to share them securely with your colleagues

What will I learn?

During the 2-day Power BI Basics course, you will get many exercises as well as various practical examples to work with. As a result, after completing this course, you will be able to apply all components of Power BI.

• The different components and basic usage of Power BI
• Importing data from different data sources
• Connecting various data sources and creating relationships
• Building an efficient and simple data model
• The importance of date tables and how to create them
• Visualizing information and creating reports
• Publishing and sharing reports via Power BI Online

Who should attend?

Business Consultants, HR staff, Marketers, Sales, Logistics and Finance employees, Analysts, Registered Controllers (RC), Business Controllers, Accountants (RA and AA), Financial Specialists, BI specialists, financial professionals, and other experienced Excel users who want to build BI dashboards.

Users who want to know more about Microsoft Power BI Desktop, need to combine and consult various datasets, want to visualize data outside of Excel, need to share data visualizations and other overviews online, and want to learn how to handle larger datasets.

Prerequisites

To get the most out of this Power BI Basics course, you need an advanced knowledge level of Excel. For example, you should be able to create pivot tables and (basic) formulas in Excel. Unsure whether to take the Power BI Basics or the Power BI Advanced training in English? Contact us for free advice, call (+31) 020 – 820 83 62 or use our contactform.

Blended Learning at SignOn

The classroom and online Power BI training is supported by the digital SignOn Learning Environment with an introduction video, up-to-date course material, various exercises, and a handy Power BI installation document so you can prepare briefly for your training. At SignOn, learning doesn’t stop after completing this two-day training. You can ask questions to our trainers for a year, get access to the learning portal with extra exercises, useful tips & tricks, monthly update videos about the latest Power BI Features, and an invitation to a free webinar. This unique teaching method enhances your learning results!

Language

This course is taught in English. This basic Power BI training is also available in Dutch. Looking for an inhouse Power BI training? Our inhouse course will be tailor-made and is available in English, Dutch and German.

Power BI courseware

SignOn always provides all participants with the comprehensive current Power BI course material. As a result, you also have a handy reference work after the training.

Certificate of Completion

After the training you will receive a certificate of completion that proves your newly-aquired Power BI knowledge.

Follow-up course

Power BI Course – Advanced (also in English)

Exclusive aftercare

Any questions after the Power BI Basic training course? Please contact your trainer at [email protected]. You will receive an answer almost immediately 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

Bart

More information