Power BI Advanced Course in English

Niveau
Tijdsduur
Logo van SignOn ICT Trainingen+
Opleiderscore: starstarstarstarstar_half 9,2 SignOn ICT Trainingen+ heeft een gemiddelde beoordeling van 9,2 (uit 784 ervaringen)
Beste opleider van Nederland

Winnaar Beste opleider van Nederland 2018: #2 in Automatisering & ICT/IT.

Winnaar Beste opleider van Nederland 2017: #1 in Automatisering & ICT/IT.

Lees meer over Beste Opleider 2019.

Tip: meer info over het programma, prijs, en inschrijven? Download de brochure!

Startdata en plaatsen

Er zijn nog geen startdata bekend voor dit product.

SignOn ICT Trainingen+ biedt haar producten standaard aan in de volgende regio's: 's-Hertogenbosch, Alkmaar, Almere / Lelystad, Alphen aan den Rijn, Amersfoort, Amsterdam, Antwerpen, Apeldoorn, Arnhem, Assen, Breda, Brugge, Brussel, Delft, Den Haag, Deventer, Dordrecht, Drachten, Ede, Eindhoven, Emmen, Enschede, Gent, Gouda, Groningen, Haarlem, Haarlemmermeer, Heerenveen, Hilversum, Leeuwarden, Leiden, Luik, Maastricht, Middelburg, Nijmegen, Roermond, Rotterdam, Terneuzen, Tilburg, Utrecht, Veenendaal, Venlo, Westland, Zaanstad, Zoetermeer, Zwolle

Beschrijving

Coronabeleid
Veiligheid en gezondheid staan voorop tijdens onze trainingen. Daarom voldoen wij meer dan 100% aan de vereisten die de overheid stelt rondom het coronavirus, volledig conform de 1,5 meter norm en protocol. Per 15 oktober 2020: mondkapjesplicht op alle cursuslocaties.

  • Uitgeroepen tot Beste ICT Opleider van Nederland
  • Hoge opleiderscore 9.3/10 gebaseerd op meer dan 785 cursisten ervaringen! 
  • CEDEO gecertificeerd
  • PE- erkend
  • Cursuslocaties van topkwaliteit in Amsterdam, Utrecht, Rotterdam, Eindhoven en Zwolle
  • Incompany maatwerk trainingen in heel Nederland
  • Online trainingen via Virtual Classroom via Microsoft Teams, Zoom of Webex
  • Unieke switchgarantie

Als u zich aanmeldt met een groep van 5 of meer personen voor een cursus op uw bedrijfslocatie (incompany), dan kunnen wij u een aantrekkelijk groepstarief aanbieden. 

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 visual…

Lees de volledige beschrijving

Veelgestelde vragen

Er zijn nog geen veelgestelde vragen over dit product. Als je een vraag hebt, neem dan contact op met onze klantenservice.

Nog niet gevonden wat je zocht? Bekijk deze onderwerpen: Power BI, Business intelligence, Splunk, Microsoft Power Platform en C/C++.

Coronabeleid
Veiligheid en gezondheid staan voorop tijdens onze trainingen. Daarom voldoen wij meer dan 100% aan de vereisten die de overheid stelt rondom het coronavirus, volledig conform de 1,5 meter norm en protocol. Per 15 oktober 2020: mondkapjesplicht op alle cursuslocaties.

  • Uitgeroepen tot Beste ICT Opleider van Nederland
  • Hoge opleiderscore 9.3/10 gebaseerd op meer dan 785 cursisten ervaringen! 
  • CEDEO gecertificeerd
  • PE- erkend
  • Cursuslocaties van topkwaliteit in Amsterdam, Utrecht, Rotterdam, Eindhoven en Zwolle
  • Incompany maatwerk trainingen in heel Nederland
  • Online trainingen via Virtual Classroom via Microsoft Teams, Zoom of Webex
  • Unieke switchgarantie

Als u zich aanmeldt met een groep van 5 of meer personen voor een cursus op uw bedrijfslocatie (incompany), dan kunnen wij u een aantrekkelijk groepstarief aanbieden. 

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.  

Course Content – Power BI Advanced

During this course we will take a closer look to the more advanced features of Power BI. It focusses on creating good data models, using DAX to create advanced measures and calculations and create more advanced visualizations.

Content

  • Short Review of needed knowledge
  • Setting up a data model in a PBIX file
  • Creating a Date table
  • Creating measurements tables
  • Advanced Dax
  • The CALCULATE function with various combinations
  • Relationships and relationship measures
    • Passive or inactive relationships
    • Many to many relationships
    • Creating calculations over  relationships
    • CALCULATE with USERELATIONSHIP
    • CALCULATE with CROSSFILTER
  • Variables in DAX
  • Use the what if parameter in reports
  • Setting up dynamic titles using VALUES, CONCATENATEX, SELECTEDVALUES
  • Targets vs. Actuals (month)vs (day)
  • Report Design:
    • Slicers
    • Themes
    • Drill through pages
    • Bookmarks
    • Renewed analysis
  • Making and using theme’s
  • Parameters in Power Query
  • Most used DAX functions
    • SUMX, RANKX, TOPN, FILTER, CONCATENATEX, FILTER, IF, LASTDATE
  • Various commonly used time intelligence functions
    • DATEADD
    • TOTALYTD
    • SAMEPERIODELASTYEAR
  • Cumulative columns
  • Various additional visualizations and additions on newer versions
  • Sparklines, Gantt diagram, bookmarks, 3D drills
  • Histograms
  • Forecasting with Power BI
  • Table functions in Power BI
  • Pareto analysis
  • Forecasting extended

Blijf op de hoogte van nieuwe ervaringen

Er zijn nog geen ervaringen.
  • Vraag informatie aan over deze cursus. Je ontvangt vanaf dan ook een seintje wanneer iemand een ervaring deelt. Handige manier om jezelf eraan te herinneren dat je wilt blijven leren!
  • Bekijk gerelateerde producten mét ervaringen: Power BI.

Deel je ervaring

Heb je ervaring met deze cursus? Deel je ervaring en help anderen kiezen. Als dank voor de moeite doneert Springest € 1,- aan Stichting Edukans.

Er zijn nog geen veelgestelde vragen over dit product. Als je een vraag hebt, neem dan contact op met onze klantenservice.

Download gratis en vrijblijvend de informatiebrochure

Aanhef
(optioneel)
(optioneel)
(optioneel)
(optioneel)
(optioneel)
(optioneel)
(optioneel)
We slaan je gegevens op, en delen ze met SignOn ICT Trainingen+, om je via e-mail en evt. telefoon verder te helpen. Meer info vind je in ons privacybeleid.