Ik ben op zoek naar

Power BI Course | Desktop & Online (Level I) – English

  • trainings duur 2 days
  • trainings prijs995,- excl. VAT per participant
  • max aantal deelnemers Max 10 participants
  • Including teaching material
  • Classroom training
  • Including certificate
  • Including catering
  • Unique aftercare

Power BI Course | Desktop & Online (Level I) – English

Power BI Course – English

After following this Power BI 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, 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 that 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 are the benefits for you?

During the two-day Power BI Desktop & Online course, you will receive, in addition to many exercises, various practical examples to work with. As a result, after following the course you know how to make effective, efficient analyzes, interactive reports and dashboards in an instant.

Permanent Education: Achieve 12 PE-points

Koninklijke NBA 12 PE-uur

Royal NBA 12 PE-hour Our Power BI Desktop & Online training is accredited by the Royal Dutch Professional Association of Accountants (NBA). With this training you can immediately get 12 PE points.

For whom?

This training focuses on:

  • Analysts, Controllers, Accountants, Financial Specialists, BI specialists and other experienced Excel users who want to build BI dashboards.
  • Users who want to know more about Microsoft Power BI Desktop
  • 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

Foreknowledge

Excel pivot tables and Pivot tables are familiar parts to you. Knowledge of PowerPivot for Excel is also an advantage.

Language

The working language during the training is English. We can provide customized company training in Dutch or English. The software can be in English or Dutch.

Classroom or in-company course

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 in the tab above and register immediately.

In addition, we also offer this classroom training as in-company training.

  • In-company customization
    Our in-company Power BI course is specifically tailored to your company. The experienced and specialized trainer(s) only treat what is relevant to your work situation. That makes our customized training courses very effective. For information about the in-company customized training you can contact us and request a quote via this link or by telephone via 020-8208362.

Preparation

We kindly ask you to create a Power BI account directly at registration via www.powerbi.com with your business e-mail address. During the Power BI training you can therefore work with your personal account.

Exclusive aftercare

Do you run into questions during your daily work after training? Then contact your Power BI trainer via support@signon.nl. You will receive an answer almost immediately with additional explanation; by telephone or e-mail. This unique aftercare service is exclusively for participants of our training courses.

More information?

Do you have questions or want more information? Feel free to contact us via info@signon.nl, call us on 020-820 83 62 or use the contact form.

Follow-up training

Do you want to follow a follow-up course after this Power BI basic course? Then the Power BI Desktop-Online Advanced + DAX course is highly recommended!

Other courses in English:

Excel Advanced Course (in English)

Content

Training program

The following topics are covered during the two-day training Power BI Desktop & Online:

Power BI desktop introduction

  • What are dashboards, reports and data sets
  • Demo several examples: on laptop, website, iPad.
  • Installing the Desktop tool
  • Create an Account on PowerBI.com First encounter with PowerBI desktop
  • Using reports, filters etc.
  • 5 minutes to wow: Create a report  within 5 minutes

Retrieving data from different data sources

  • Importing from various sources: CSV, TXT, Access
  • Merging several source files
  • Import and merge files from  folders
  • Restructuring of data, splitting columns
  • Unpivotting  of excel tables to make them useable
  • Retrieving data from  Websites
  • Basic knowledge of M language within Power BI desktop

Linking various sources and creating Relationships

  • Linking to relational models in Excel, Access, Databases
  • Creating links between CSV and Excel files
  • Difference between Dim and fact tables

Modeling data and date tables

  • Restructuring of columns
  • Customize field types
  • Create hierarchies
  • Preparation for calculations
  • Setting up a date table using Dax, with hierarchies
  • Setting up multiple calculated measures for the OLAP cube, beginning of DAX.  With functions likeSum, Count, DistinctCount, Related, Calculate
  • Understanding the difference between calculated columns and measures:
  • Understanding the difference between implicit and explicit measurements

Visualization of data in Power BI Desktop: various ways

  • Visuals by using  tables, matrices, shapes, charts, map shapes
  • Building reports with slicers, filters
  • Creating  3D slicers
  • Use internal date hierarchies for matrices and graphs
  • Formatting  of reports, tables
  • Filters on page or report level
  • Conditional formatting
  • Importing additional Visual AidsS
    • TreeMap charts, Slicers, Funnels, Gauges s, KPI meters, Time Slicers

PowerBI On line

  • Working directly in Power BI Online
  • Linking data from OneDrive
  • Analysis of restrictions in Online environment
  • Instantly publish from PowerBI desktop
  • Dashboards (switchboards) vs. Reports
  • Linking pages and cards to dashboards
  • Using Q & A within Power BI desktop
  • Extra possibilities with tiles
  • Customizing Visual interactions within reports
  • Searching of reporting information on website

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.

Official certificate

After the training you will receive the official Power BI Desktop and Online Level I certificate from SignOn.

Choose a start date: Power BI Course | Desktop & Online (Level I) – English

Start Location
Start date: Vr. 10-04-2020
in: Utrecht
schedule
sign up
Days and times:
  • vr. 10 april 2020 09:00 - 16:00
  • vr. 17 april 2020 09:00 - 16:00
Location: BCN Utrecht - ICT Centre (BCN Utrecht)
Daltonlaan 100
3584 BJ Utrecht
Start date: Wo. 13-05-2020
in: Amsterdam
schedule
sign up
Days and times:
  • wo. 13 mei 2020 09:00 - 16:00
  • wo. 20 mei 2020 09:00 - 16:00
Location: Aristo Amsterdam
Teleportboulevard 100
1043 EJ Amsterdam
Start date: Do. 11-06-2020
in: Utrecht
schedule
sign up
Days and times:
  • do. 11 juni 2020 09:00 - 16:00
  • do. 18 juni 2020 09:00 - 16:00
Location: BCN Utrecht - ICT Centre
Daltonlaan 100
3584 BJ Utrecht
Start date: Do. 10-09-2020
in:
schedule
sign up
Days and times:
  • do. 10 september 2020 09:00 - 16:00
  • do. 17 september 2020 09:00 - 16:00
Location:

Start date: Do. 01-10-2020
in: Utrecht
schedule
sign up
Days and times:
  • do. 01 oktober 2020 09:00 - 16:00
  • do. 08 oktober 2020 09:00 - 16:00
Location: Aristo Utrecht
Brennerbaan 150
3524 BN Utrecht
Start date: Di. 10-11-2020
in: Amsterdam
schedule
sign up
Days and times:
  • di. 10 november 2020 09:00 - 16:00
  • di. 17 november 2020 09:00 - 16:00
Location: Aristo Amsterdam
Teleportboulevard 100
1043 EJ Amsterdam
Start date: Do. 10-12-2020
in: Utrecht
schedule
sign up
Days and times:
  • do. 10 december 2020 09:00 - 16:00
  • do. 17 december 2020 09:00 - 16:00
Location: Aristo Utrecht
Brennerbaan 150
3524 BN Utrecht
Show more dates

Cost

Cost – Power BI Desktop & Online Level I Course

The course costs € 995 per participant. This includes all current teaching materials, a reference work (pdf) and the official SignOn certificate. In addition, course participants who have followed a course with us can use our exclusive aftercare service. So, there are no additional costs afterwards. The price of the training does not include 21% VAT. The VAT number is stated on the invoice.

In-company group rate

If you sign up with a group of five or more people for a Power BI course at the company location (in-company), we can offer an attractive group rate. For information about our group rates you can contact us and request a quote via this link or by telephone via 020-8208362.

Good to know

Tax-deductible

The government stimulates knowledge and skills in the Netherlands. That is why SignOn’s courses are (partially) tax deductible. How much you can deduct depends on your situation. Do you want to know more? Check the website of the Tax Authorities.

Employers

As an employer you can deduct the full training costs for employees as operating costs. This applies to the training itself, but also to other costs such as books, registration fees, administration costs, the certificate or extra supervision. At SignOn all these costs are already included in the price.

Individuals

If you follow a course at your own expense, it is often deductible for income tax purposes. This way, continuing to study is affordable. The education or course must be relevant to your current or future work. If you spend more than € 250 on mandatory costs for a relevant course or course, you can deduct a maximum of € 15,000. Check the website of the Tax Authorities.

Knowing more?

Do you have questions or want more information? Feel free to contact us via info@signon.nl or call us on 020 – 820 83 62.

 

Incompany-training

SignOn is specialized in customized trainings. We can change the content for the training to your wishes. You"ll get an practice-oriented customized training. See this page for more information about our incompany trainings. Inform without obligation.

Request quote - Power BI Course | Desktop & Online (Level I) – English






At your business location throughout the Netherlands

Alkmaar, Almere, Alphen aan den Rijn, Amersfoort, Amstelveen, Amsterdam, Apeldoorn, Arnhem, Assen, Breda, Delft, Den Bosch, Den Haag, Deventer, Dordrecht, Drachten, Ede, Eindhoven, Emmen, Enschede, Gouda, Groningen, Haarlem, Haarlemmermeer, Heerenveen, Heerlen, Hilversum, Hoorn, Kerkrade, Leeuwarden, Leiden, Lelystad, Maastricht, Middelburg, Nieuwegein, Nijmegen, Roermond, Rotterdam, Terneuzen, Tilburg, Utrecht, Veenendaal, Venlo, Westland, Zaanstad, Zoetermeer, Zwolle

beste opleider van Nederland
  • SignOn check Uitgeroepen tot beste opleider
  • SignOn check De beste trainers
  • SignOn check Inclusief digitaal naslagwerk
  • SignOn check Inclusief certificaat
  • SignOn check Unieke nazorg
  • SignOn check We request your data to process your registration.
  • SignOn check Your information will not be provided to third parties.
  • Read our privacy statement for more information.
Run 4 School

When taking a training you give children in South Africa a chance to learn. For every enrollment we donate € 2,50 per participant to Run4Schools.

Read more about Run4Schools

Meer informatie nodig?

We helpen u graag verder