Power BI Advanced Course in English
Power BI Advanced Course (in English)
The Power BI Advanced training course is a 2-day 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.
SignOn has the status 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.
What are the benefits for you?
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.
For whom?
- 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
Foreknowledge
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. Are you unsure whether this training suits your knowledge and skills? Then contact us for advice or call us on 020-820 83 62.
After following this course you will have knowledge of:
- Context
- 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
- Templates
- Parameters
- Cumulative Columns (running total)
- Extra Visualizations and additions new versions
- Histogram
- Forecasting models (Forecast)
- Dax Advanced: Extra Column Functions
- Dax Advanced: Extra Time Intelligence Measurements
- DAX Advanced (Advanced)
- Additional DAX functions
- Extra Parts
Language
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.
Teaching material
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
After the training you will receive a certificate.
Follow-up course
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.
Permanent Education: Achieve 12 PE-points
The Power BI Desktop & Online Advanced + DAX training 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.
Training forms
You can choose from different training forms: Class online, classroom on location or in-company / customization. View all our COVID-19 measures regarding our training courses here.
- Classroom online (Virtual Classroom via Microsoft Teams)
You can follow the online training at your own workplace or at home. Technically, anyone can follow the training. For this you need a laptop or PC (possibly a second monitor) and a stable internet connection. There is time for personal attention, the trainer can possibly look at your screen to answer all your questions. With the Online training (Virtual Classroom via Microsoft Teams) you will receive the same quality and service that you are used to from us. View the training dates here and register immediately. - Classroom on location
Employees from different companies are present during this classroom training. As a result, you can already participate from 1 person, and still benefit from an attractive group rate. Fully catered for, including an extensive lunch. View the training dates here and register immediately. - In-company / customization
Our in-company training is specifically tailored to your company. In a personal telephone conversation or via e-mail, we map out your situation, work and learning goals and advise you which solution is best for you. The experienced and specialized Power BI trainer only deals with what is important for your work situation. That makes our tailor-made training effective. We can provide customized training courses in Dutch, English or German. In addition to many practical benefits, the choice for an in-company training also provides an attractive discount. Depending on the number of participants, the discount can be as much as 50% compared to participation in an open training. For information about the in-company training you can contact us and request a quote via this link or by telephone at 020-820 83 62.
Exclusive aftercare
If you have questions after the Power BI Fundamentals training? Please contact your trainer at support@signon.nl. You will receive an answer almost immediately with extra explanation; by phone or e-mail. This unique aftercare service is exclusively for participants of our training courses.
Want to know more?
Do you have questions or want more information? Or do you want to know whether this Power BI Fundamentals Course matches your needs and level of knowledge? Please feel free to contact us via contact form, info@signon.nl or call us on 020-820 83 62.