Power BI - an essential toolkit

Member price: £335 + VAT

Non-member price: £395 + VAT

Timing: 9.30am-4.30pm

Overview

Empower your business analysis with data-driven decisions. Make unified data visualisations and share insights that drive success. Transform, unify, analyse and visualise data.

This course uses Power BI Desktop and Microsoft Excel for the live exercises.

• Essential overview of the Power BI suite of analytical tools
• Data structures and setup best practice
• Import, transform and analyse complex datasets
• Build fast yet detailed visualisations from a variety of data types
• Create detailed insights from built-in functions that drive business decisions
• Produce bespoke visualisations using DAX functions

Who should attend

This course is for anyone wanting to get to know Power BI tools in a business context. This includes:

• Finance professionals
  • Accountants
  • Auditors
  • Business partners
• Analysts / Power Users
  • Data Analysts
  • Application specialists
• Decision makers and spreadsheet users who want to upgrade their skills into Power BI

What you will learn

• Discover Power BI reporting by creating fast visualisations that are interactive
• Enhance your analytical work by synthesising datasets from a variety of sources
• Learn how to transform, unify and reconcile datasets easily with built-in tools
• Write your own DAX functions to maximise the potential of reports
• Uncover Power BI tricks to gain deeper insights for data-driven decision making

Information for Online Live dates

Please read the following guidance carefully, which only applies if you are attending this course online:

• In addition to the Online Classroom, you will need to have your own version of Excel open to complete the exercises
• It does prove to be challenging to follow-on with the exercises using only 1 screen as you will need to be regularly switching between open windows. We recommend to either:
  • Extend from a computer to a 2nd screen - please refer to this link for guidance on how to correctly setup a second monitor https://support.microsoft.com/en-us/help/4340331/windows-10-set-up-dual-monitors or
  • Use 2 computers, or
  • Use a tablet for the online classroom and a computer for the Excel
• Please note that our courses are based on Excel for Windows and it is recommended that you are using at least Excel 2010 or a later version. MAC users are welcome but please note that there may be some tools and functionality that will differ from what is being presented. The presenter will accommodate for MAC versions on the course.

Questions?

BPP | Tel: 0330 060 3303 | Email: ldicas@bpp.com