Forthcoming Events

Birmingham May 30: Register here

London June 13: Register here

Manchester June 27: Register here

Not what you were looking for? Email to talk to us about on site training or bespoke courses

The Microsoft Power BI Basic Design course will take your staff from little or limited reporting experience to an intermediate report writer and analyst using Microsoft Power BI Desktop and Power BI Online. The course will cover: Overview and Toolset, Apps in Power BI Online, Accessing Data from Excel, Using Quick Measures, Introduction to DAX, Publishing Reports, Creating Dashboards, Using Q&A and Best Practices.
Duration: 1 Day
Availability and Schedule: Please enquire

Course Topics:

1.   Overview and Toolset

An introduction to Power BI, its history and the tools available to author and share reports.

2.   Power BI Apps from AppSource

Introducing apps provided by different SaaS applications.

3.   Accessing Data from Excel

Power BI Desktop, the companion application to Power BI online. Students will connect to the most popular data repository, Microsoft Excel, allowing organisations to use Power BI’s advanced visualisations instead of relying on Excel charting.

4.   Publishing Reports

Here we will look at publishing reports to Power BI online and creating organisational apps to share these reports through the organisation. Finally, we will consider the options available if, for any reason, an organisation cannot use Power BI online.

5.   Creating Dashboards

Elements of multiple reports published to Power BI online can be brought together into dashboards, allowing insights across multiple business areas whist keeping the underlying models and reports properly focused. Here we will see how we can create dashboards using Power BI content, and enrich them with content from the web and other sources.

6.   Creating Quick Measures

Simple aggregates will only take you so far.  Here we show how you can create simple time intelligence such as year to date and month on month growth using Power BI’s “Quick Measures” feature.

7.   Introduction to DAX

Introducing the DAX language, a language that allows the creation of advanced analytics, whist remaining accessible to anyone with a basic knowledge of Excel formulas.

8.   Using backgrounds, themes and templates

For most companies, it is important to present a consistent business brand.  This can be difficult when a tool offers the freedom of design that Power BI does.  In this section, we’ll see how you can use backgrounds, themes and templates to show Power BI visuals to their best, whilst preserving your corporate brand.

9.   Using Q&A and Best Practices

Natural language query has long been the dream of BI – here we see how it can be achieved using Power BI’s Q&A feature on our dashboards. We will see how it works and how it can be used.