Power BI Basics course (English)
Learn the fundamentals of Power BI! After following this Power BI Basics course you can, among other things, make advanced analyzes, interactive reports and data models. You get direct access to all important data from local and cloud-based sources such as Excel, AFAS, SharePoint, Dynamics 365 and hundreds of other programs. Do you want to share this data directly with your colleagues? Then we help you get to know the many possibilities of Power BI Desktop, so you can do everything simpler and faster. In this course you will also learn how to set up a Power BI model with Dim and Fact tables.
You will be guided through recognizable examples through the first basic formulas of the DAX formula language. 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. You use the Power Query and Power Pivot functions to collect, clean and enrich business data via standard tools and the start of DAX. After you have designed a BI (Business Intelligence) model, you can start analysis and reporting via the Pivot Table function. Finally, you learn how you can publish your reports to PowerBI.com and how you can share them with your colleagues.
What will I learn?
During this 2-day Power BI Basics course in English, you will receive, in addition to many exercises, various practical examples to work with. As a result, after the courses you know how to make effective, efficient analyzes, interactive reports and dashboards instantly. This allows you to apply multiple components of Power BI after following this course. For example: Advanced Analytics, Interactive reports, Data models, Dashboards, Set up a Power BI model with Dim and Fact tables, Basic formulas of DAX
Who should attend?
Experienced Excel users who want to build BI dashboards and want to learn more about Microsoft Power BI Desktop.
- Fundamentals of Power BI
- Power BI Desktop & Online introduction
- Retrieving data from various data sources
- Linking various sources and creating relationships
- Modeling data and date tables
- Visualization of data in Power BI Desktop:
- Various shapes
- Power BI Online
To be able to follow this Power BI training course, knowledge at Excel Advanced level and knowledge of pivot tables is required. Are you unsure whether your knowledge is sufficient for this training? Contact us for free advice, call (+31) 020 – 820 83 62 or use our contactform.
The standard language during the course is 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.
Power BI Advanced training course (also in English)
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.