Power BI Advanced (English)

Tijdsduur
Locatie
Op locatie, Online
Startdatum en plaats

Power BI Advanced (English)

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

Winnaar Beste opleider van Nederland 2020: #2 in Automatisering & ICT/IT en #3 beste grote opleider.

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 van Nederland 2020.

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

Startdata en plaatsen

placeOnline training (from home or work)
25 jan. 2022 tot 1 feb. 2022
Toon rooster
event 25 januari 2022, 09:00-16:00, Online training (from home or work)
event 1 februari 2022, 09:00-16:00, Online training (from home or work)
placeOnline training (from home or work)
21 jul. 2022 tot 28 jul. 2022
Toon rooster
event 21 juli 2022, 09:00-16:00, Online training (from home or work)
event 28 juli 2022, 09:00-16:00, Online training (from home or work)
placeOnline training (from home or work)
19 sep. 2022 tot 26 sep. 2022
Toon rooster
event 19 september 2022, 09:00-16:00, Online training (from home or work)
event 26 september 2022, 09:00-16:00, Online training (from home or work)
placeOnline training (from home or work)
13 dec. 2022 tot 20 dec. 2022
Toon rooster
event 13 december 2022, 09:00-16:00, Online training (from home or work)
event 20 december 2022, 09:00-16:00, Online training (from home or work)

Beschrijving

SignOn ICT Trainingen+ verzorgt al ruim 19 jaar ICT trainingen en consultancy in heel Nederland.

  • Beste ICT Opleider van Nederland 2017, 2018 en 2020
  • Hoge opleiderscore 9.4/10
  • Microsoft Partner Silver Data Analytics
  • CEDEO gecertificeerd
  • PE- erkend
  • Cursuslocaties van topkwaliteit
  • Klassikaal op locatie | Klassikaal online | In-company / Maatwerk | Individeel | E-Learning
  • Unieke switchgarantie
  • Unieke nazorg en consultancy 

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

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++.

SignOn ICT Trainingen+ verzorgt al ruim 19 jaar ICT trainingen en consultancy in heel Nederland.

  • Beste ICT Opleider van Nederland 2017, 2018 en 2020
  • Hoge opleiderscore 9.4/10
  • Microsoft Partner Silver Data Analytics
  • CEDEO gecertificeerd
  • PE- erkend
  • Cursuslocaties van topkwaliteit
  • Klassikaal op locatie | Klassikaal online | In-company / Maatwerk | Individeel | E-Learning
  • Unieke switchgarantie
  • Unieke nazorg en consultancy 

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.

Skills gained

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

Prerequisites

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.

Skills gained

  • 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.

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

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.

Course outline – Power BI Advanced (English)

During this 2-days Power BI Advanced 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.

Context

Context is an important part for use of the correct DAX functions.

Explanation about various types of context

  • Driving context
  • Selection context
  • Filter context

Data modeling

  • Set up a good data model
  • Use DAX Studio (Basic)
  • Making a date table in DAX vs. Power Query
  • Other table functions such as filter & AddColumns
  • When do you use a measuring table?
  • How do you set a measuring table?
  • Use DisplayFolders
  • Difference between measurements and calculated columns
  • When do you use Dax and when Power Query
  • When an implicit or explicit measurement?
  • Formating measurements
  • Documentation of measurements

Calculation function: Dax swiss pocket knife

  • Extensive use of calculating in combination with other filters
  • Calculate with OR & AND.
  • Calculate with various filters options
  • Calculate with all-selected function
  • Calculate with all calcification function
  • Calculate with Values ​​function

Influence relationships with DAX

  • UserElatationShip function
  • Cross filter functions

Parameters in Power Query

  • Making dynamic parameter
  • Use dynamic parameter
  • Use parameters in a template file

Parameters in DAX

  • Create & use Dax parameters

Cumulative column functions

  • Cumulative columns via calculate, filter and max
  • Counting and cumulative columns via Rankx, filter and earlier
  • Use topn function

Time Intelligence functions

  • Create YTD / MTD functions
  • Compare periods (YOY / MOM ETC)
  • Apply Isinscope & Hasonvalue
  • Calculate continuous averages

Report Design

  • Use bookmarks
  • Add buttons and navigation
  • Theme design
  • Use tool tips
  • Make Drill-Through pages
  • Row Level Security Apply

Delivery formats

Choose a delivery format that suits you best. The following delivery formats are available for this course:

  • Virtual classroom

    Attend a the virtual classroom course from any location (workplace or home). You learn from a live instructor and are in contact with other participants. The instructor has the possibility to look at your screen (if necessary) to answer all your questions. This training will take place via Microsoft Teams (free of use).

  • Classroom live

    A face-to-face training on a location in the Netherlands. Employees from different companies are present during this classroom training. Fully catered for, including an extensive lunch.

  • In-company course

    Our in-company training is tailored to your company. The specialized trainer only deals with what is important for your company and work situation. That makes our tailor-made training very effective. We provide these training courses in Dutch, English and German. The choice for an in-company training 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. More information or request a quote.

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.

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 Office Specialist Expert

Our Microsoft Office Specialist: Expert are experts in their field and certified according to Microsoft’s conditions. In addition to providing training, they also work in projects and know the day-to-day practice like no other. As a result, they know what students have to deal with on a daily basis and what they can run into. They use their practical experience to enrich the theory in the classroom.

Cedeo Recognition: What Does It Mean for You?

Cedeo is a household name when it comes to education. 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 education institutes.

SignOn and the UWV

SignOn ICT Training is a recognized training partner of the UWV. SignOn ICT Training+ is one of the few ICT educational organizations recognized by the UWV to provide training to help people return to the labor process.

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)
(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.