Zomalex | Data and AI Training

Home | Power BI | Excel | Python | SQL | Generative AI | Visualising Data | Analysing Data | Prices | Contact Us | info@zomalex.co.uk

Power BI Intermediate Course Outline

Who should attend

Anybody who wants to take their Power BI skills to the next level.

Course Length

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

Learning Objectives

Attendees will be able to use Power BI Desktop to analyse and clean data and build insightful reports and dashboards.

Pre-requisites

Basic familiarity with Power BI, for example by having attended the foundation course.

Course Content

The course covers the following topics.

• Use visual calculations: e.g., running sum, moving average, change on previous, year to date
• Calculate useful quantities with DAX e.g. sums, averages,
• Advanced clean and transform data e.g. summarise, pivot and unpivot data
• Build several chart types: bar charts, line charts, scatter plots, matrix and table visuals, and maps
• Use interactions between visuals (as a filter, highlight) to good effect
• Use field parameters to construct flexible charts
• Improve charts with reference lines e.g. averages, trends, clusters,
• Create drill-though pages
• Build custom tooltips

Example case study

One of the possible case studies for this course is to calculate the league table of football’s English Premier League from the match record. More details are here. By the end of the course, you will have created a report similar to the snapshot below.

A few comments from attendees of previous courses

“The course presenter was excellent - clear, patient, pleasant - he set a good pace and made sure everyone had grasped each concept.

“I really enjoyed the course. The trainer adopts a hands-on approach which ensures no one is left behind struggling.”

“Mark was extremely patient and a great teacher.”

“Mark is an experienced trainer and has an incredible breadth of knowledge within the data science field. We found our training course in Power BI to be useful and informative. We would recommend Mark as a trainer to other organisations.”

“Great presentation style from Mark with lots of opportunities to ask questions and talk about real scenario examples which all made it a really enjoyable and informative course. This has more than met my expectations. A wonderfully practical course both personally and professionally.”

“Mark has recently delivered two courses for my organisation. Power BI Developer and Power BI User. I liaised with him on the Power BI User course which was excellent. Mark met with myself and colleague to understand our needs and who would need training and then developed the courses we needed so that we could maximize usage. Between Day 1 and Day 2 of the course he created homework tasks which enabled the people being trained to practice Power BI and then on Day 2 they had the opportunity to ask their own questions based on what they had been practicing. He has been a pleasure to work with and as trainer has proven to be patient and adaptable. I know that those who did the training with Mark were left feeling excited about the prospect of what they do in Power BI.”