Power BI Advanced (English)
NBA recognized educational institution
The NBA has signed SignOn ICT Trainingen B.V. designated as a recognized educational institution. The quality of our courses is regularly tested by Cedeo on behalf of the NBA. During an assessment, various components are examined, including the evaluations of the students. For this reason, completing the evaluation after a course is of great importance to us. Cedeo is an independent intermediary that grants the ‘Cedeo recognized’ quality mark to educational institutions, among others.
Cedeo Recognition: What Does It Mean for You?
Cedeo is a household name when it comes to training. There are approximately 300 Cedeo-recognized institutes in the Netherlands. By choosing a Cedeo-approved supplier, you can therefore be sure that you are choosing one of the better training institutes.
What is Cedeo?
Cedeo is an independent organization that has examined SignOn for customer satisfaction, quality, continuity and business orientation. This Cedeo recognition means that more than 80% of our customers are (very) satisfied with the quality of the training. With a high degree of satisfaction among these buyers about the various steps in, among other things, the pre-, implementation and post-process, SignOn meets the criteria of quality, continuity and business orientation and has been awarded the ‘Cedeo-recognised’ designation.
Permanent Education: Achieve 12 PE-points
This course is accredited by the Royal Dutch Professional Association of Accountants (NBA). The training is good for 12 PE points/PE hours.
Microsoft Certified Trainers
Our Microsoft Certified Trainers (MCT) are experts in their field and are certified according to Microsoft’s terms and conditions. In addition to providing training, they also work in projects and know daily practice like no other. As a result, they know what students have to deal with and encounter daily. They use their practical experience to enrich the theory in the classroom.
Microsoft Partner – Silver Data Analytics
SignOn has the statusstatus Microsoft Partner – Silver Data Analytics and thus demonstrates that the knowledge, skills and performance are of a high level. We show that we are fully aware of the latest techniques in Microsoft Power BI and Big Data.
Power BI Advanced Course in 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 Fundamentals 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.
During the 2-day course Power BI Advanced you will receive, in addition to many exercises, various practical examples to work with. This allows you to use the advanced components of Power BI after following this course, such as DAX.
Who should attend
- Users who have to combine and consult various data collections
- Users who want to visualize data outside of Excel
- Users who have to share data visualization and overviews online
- Users who want to learn how to edit larger data collections
- Users who want to know more about DAX functions, such as:
- Filter functions
- Information functions
- Logical functions
- Statistical functions
- Mathematical and trigonometric functions
- Text functions
- Functions for Time Intelligence Measurement
- And much more……..
- Controllers who will make Forecasting models
You have knowledge of Excel Advanced and Power BI Desktop and Online. If you have not followed Power BI Fundamentals Course (in English) or have not followed Excel Advanced training, enter the knowledge test here and determine your starting level immediately.
- Set up a repetition of a data model and create a date table
- Tables for measurements
- Calculation function: DAX’s Swiss army knife
- Using passive (inactive) relationships
- Understanding extended relationships, many to many, cardinality (Cardinality)
- Use of variable in DAX
- Help or Send Tables
- What If Parameters [What If]
- Top 10 DAX functions used
- Dynamic titles
- Targets (month) vs Actuals (day)
- Renewed Items
- Cumulative Columns (running total)
- Extra Visualizations and additions new versions
- Forecasting models (Forecast)
- Dax Advanced: Extra Column Functions
- Dax Advanced: Extra Time Intelligence Measurements
- DAX Advanced (Advanced)
- Additional DAX functions
- Extra Parts
The standard language during the course is English. In-company tailor-made training is also given in other languages. This basic training is also given in Dutch, see Power BI Basic course in Dutch.
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.
After the training you will receive a certificate.
Do you want to follow a follow-up course after this Power BI Fundamentals course? Then the Power BI Expert Course (in English) course is highly recommended.