Power BI - An Essential Toolkit (ICAS)

Overview

Empower your business analysis with data-driven decisions. Make unified data visualisations & share insights that drive success.

Transform, unify, analyse and visualise data. Create Insights.

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 is this for?

• Accountants
• Auditors
• Business partners

• Data Analysts
• Application specialists

What will you 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

Please read the following guidance carefully, which applies only 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
• Please ensure that you have installed and have access to the Power BI Desktop App on your computer
• 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.