Zomalex | Data and AI Training

Power BI Foundation Course Outline

Who should attend

Anybody who is getting started analysing data or building reports with Power BI.

Course Length

1 day (short version) or 2 days (preferred, full version)

Learning Objectives

Attendees will have a broad understanding of how to explore analyse and visualise data using Power BI and will be comfortable using Power BI Desktop to build reports and dashboards.

Pre-requisites

None

Course Content

This is a very practical hands-on course. Attendees will build Power BI visualisations, reports of increasing power and sophistication as the course progresses. Most time will be spent in lab exercises these will use data from public datasets. The course covers the following topics.

Import data from text/CSV files and spreadsheets
Clean and transform data – replace or remove bad values, filter the rows, group, summarise, pivot and unpivot data, calculate results
Build helpful and insightful visuals such as bar charts, line charts, scatter plots, matrix and table visuals, and maps
Filter data with slicers and the filter pane
Improve and polish reports: add text, images and other non-data elements to enhance the report; apply conditional formatting e.g. data bars; configure titles, axes, colours, labels.
Publish content to the Power BI Service

Example case study

One of the possible case studies for this course is an analysis of the scores in a recent series of Strictly, the BBC Saturday night dancing competition. More details are here. By the end of the course, you will have created some reports similar to those below.

A few comments from attendees of previous courses

“The tutor is very good at teaching and is very patient with all of his students. I really enjoyed the course and looking forward to attending the advanced course.”

“Mark is a excellent trainer, so patient and explained in details and got everyone to have a go.”

“The Power BI training was excellent and very interactive. The trainer, Mark, ensured that every participant had the chance to practice the different steps through a series of comprehensive exercises. He was highly flexible in his approach thus meeting the needs of our diverse group.”

“The Power BI training was very practical and I learned a lot from it. Mark tailored the course specifically to the group’s needs and was exceptional at ensuring everyone learned from the experience. I would definitely recommend him!”

“An engaging and informative training course; Mark has the ability to make complex software palatable and cater for a variety of ability levels simultaneously, ensuring no one was left behind nor bored by the pace of the sessions. Would thoroughly recommend!”

“The trainer was great. I learned a bunch of things, mostly around formatting data, also the solution re linking the calendar table to two columns simultaneously.”

“Mark was very conversant with the subject and helpful. He was resolving each and everyone’s issue before moving on the next topic. Very good training I would recommend.”