Microsoft: Power BI Desktop

Power BI (Business Intelligence) – a stand-alone Microsoft business intelligence software that is free to download (mobile Apple and Android versions also available).

Power BI uses the same engine as Excel to “get and transform data” in the form of Power Query, Power Pivot, and Calculated Fields.

Power Pivot allows for data to be collected and “cleaned”.   Cleaning involves changing, adding, deleting, or modifying columns, and inserting calculations.  Where necessary various tables of data can be linked and relationships formed between them to enable more effective analysis.

Skills covered:
This workshop is an introduction to Power BI Desktop – a very powerful data analysis tool that makes data analysis relatively straight forward.
It can analyse vast amounts of data, from a variety of sources, e.g. internet, Excel, Access, CSV files, text files, and external databases SQL.
The data can then be set out in clear, understandable, visual formats to be shared, e.g. reports, charts, maps, and dashboards.

You will need to have downloaded Power BI Desktop onto your laptop:
(Ctrl + Click:  Downloads | Microsoft Power BI

Skills needed:
This is an Intermediate/Advanced level workshop and so you should be familiar with Excel tables and have some basic knowledge of Pivot Tables. Any knowledge of Power Pivot and Power Query will also be useful but is not essential.

You are welcome to contact the trainer to discuss whether the workshop may be suitable for you.

This workshop is interactive and attendees will gain hands-on experience.  Raw data to work with and detailed notes will be provided.

Limited spaces to ensure student-centred learning.

Read about the trainer, Bernard Pfister, and additional workshops here

Register to attend below.

For more information, contact Julia at,
or call 06 759 9080

Tuesday, 27th July, 2021
9:30 a.m. to 11:30 a.m.
Taranaki Chamber of Commerce
Single Ticket (Member) incl GST:
Single Ticket (Non-Member) incl GST:

Step 1 of 4 - Event Details


Choose if you are booking as a member or non-member

First time here? If you’re a current Chamber member and this is your first time registering for an event on our new website, please click here and enter your email address to be sent your password.

Forgotten Password


Total (incl GST)

Registration Policy:
Payment is required prior to course attendance, and your registration will be confirmed once payment has been made.

Cancellation Policy:
Any cancellation and/or changes must be made in writing to the Taranaki Chamber of Commerce no less than ten working days prior to the course in order to receive a full refund/credit. No refund or credit will be given for cancellations made after this or for non-attendance at the course.