Courses 1 to 6 are our mainstream courses for people with little or no experience of Power BI. The other titles are add-on subjects which may be taken as a way to learn about new features and functions in Power BI or as a method for topping up existing knowledge.
Please contact us if you wish to discuss.
This session is designed for those people who wish to acquire the basic skills & knowledge to get started with Power BI Desktop.
You will learn about the key components of Power BI and how they work together.
You will learn how to create a simple report using data imported from an Excel workbook.
Delegates do not need any previous experience of Power BI but must have a basic understanding of PC’s, including familiarity with a keyboard and mouse.
A basic understanding of Excel would also be beneficial.
This session follows on from the first; you learn about the key steps associated with building a typical business report.
You will learn how to build ‘measures’ (calculations) and will be introduced to ‘calculated columns’, you will learn when to use one over the other.
You will also be introduced to some of the most common DAX functions and how and when to use them.
This session is designed for those people who already use Power BI but want to be more creative and dynamic when building business reports.
It is recommended that delegates have some experience of importing and working with files of different types.
In this session you will learn some techniques that will help to maximise the report canvas, so information remains easy to read and avoids over-crowding & confusion.
This session is designed for those people who are confident in building reports but want to improve their design skills when it comes to presenting a range of information in a single report.
Most reports include dates so information can be aggregated over various calendar periods, years, month & days for example. This session includes reporting at a calendar and financial year end.
In this session you will learn the importance of creating a dates table and how to connect it to the data model.
This session is designed to complement session 2 above but can also be run independently.
This session is designed for users who are confident at building Power BI reports, but want to extend their knowledge to working with dates and other calendar periods.
It would be helpful if the user had a basic understanding of how a data model works.
In this session delegates will expand their knowledge of DAX. They will learn about important key principles of DAX which under-pin the creation of more dynamic and complex reports.
It is advisable that delegates have already completed the Creating dynamic reports using ‘measures’ and ‘calculated columns’ session before attempting this one.
Upon completion, delegates should be able to apply what they have learnt and build more complex and dynamic business reports & dashboards.
The Power BI Service is sometimes referred to as Power BI online, it is a SaaS (Software as a Service) part of Power BI.
In the Power BI service, you can build reports, dashboards and apps and share them securely with your colleagues & business partners.
This session is for people will a good understanding of Power BI and the relationship between data and reports.
They should be familiar with the concept of building charts & tables either in Excel or other similar applications.
This session demonstrates how to use data that is available online from sites like ‘Wikipedia’.
Attendees should already have a good knowledge of Power BI and must be conversant with importing data from various file types.
Learn about some of the new Power BI Desktop functionality and learn how to use these new features.
This section is aimed at people who already use Power BI on a regular basis but want to learn about the latest features & functionality and how to use them.
The content for this session will change over time as new Power BI features & functionality becomes available.
You can create visually rich report tool tips that appear when you hover over visuals, based on report pages you create in Power BI Desktop.
This section is aimed at people that already use Power BI on a regular basis and want to learn about new ways of engaging with their report consumers.
Power BI comes with several mapping visuals by default. In this session we will review some of these options as well as looking at the new Azure Map visual.
With visually appealing maps and easy-to-understand content, you will be able to gain more insight into your data.
This session is for experienced Power BI users who want to expand their skills and experience by learning to visualise their information geographically rather than be limited to a flat chart or table.
*Users will need an active MS Azure account to use the new Azure Map visual.
In this session users will learn some best practices & tips & tricks to help them build better visualisations that stand out from the crowd.
This session is for experienced Power BI users who are looking for new ways to improve their report design skills and want to encourage report consumer engagement.
We will update the above content and add new without notice as new features, functionality and processes become available.
Where a group size is five or less, delegates will be able to direct questions to the tutor throughout the session. However, because of time constraints, groups greater than five will not be able to ask questions, however delegates will be able to email them up to five days after the session.
If you would like to know more about these courses and how they could benefit your organisation, please contact us. I will be pleased to discuss a bespoke proposal for three sessions in one day, or 10 sessions taken over a calendar month. We can be very flexible with these courses, so if you have a particular requirement, just ask.