D6: Power BI Essentials (2-3 days)

In-Person and Virtual Classroom(in-house only) - Live, instructor-led, interactive training

All of our courses are available for In-house Training. We can also run training virtually. We provide live, instructor-led, interactive courses and our world-class instructors guide you through every step. Our Course Facilitators have over 20 years' experience in delivering training for clients all over the world. A number of Public Courses are scheduled for Perth. Face-to-Face interstate and international training is back in full swing but can still be delivered using online platforms.

All the key aspects you need to know to begin developing Power BI reports for your business.

Before you proceed, just to let you know, we sometimes find that people would be better learning the Power BI features that are already built into Excel. Power Query and Power Pivot are awesome and may be more relevant to your daily work right now than Power BI. Take a look at our Power Query and Power Pivot (with a bit of Power BI) course here.

Power BI is awesome too though so if you’re not sure which course is right for you, drop us an email to discuss.

Our Public courses are aimed at smaller groups of 3 – 8 people so that there is more opportunity for the instructor to assist on a 1-1 basis and discuss the attendee’s specific real-world scenarios.

NOTE:  For Public Courses a minimum of 3 attendees must have signed up 4 weeks in advance of the course otherwise the course will be postponed, and full refunds offered. The 3rd day option also requires a minimum of 3 attendees to proceed.

Book Now

Related Courses

D7.1 DAX Booster for Power BI (1 day)
This intermediate to advanced hands-on course is focused on enhancing your understanding of the amazing capabilities of DAX. Get an understanding of the key elements of DAX language, with a sound understanding of key data modelling concepts.
D7.2 Power Query Booster (1 day)
This intermediate to advanced hands-on course is focused on enhancing your understanding of the amazing capabilities of Power Query and the ”M” language. Get a solid understanding of Power Query functionality, the “M” language, and how to handle more complex data transformations.

 

Create stunning interactive reports and share amazing insights! Power BI gives Excel users the power to extract data from multiple sources, link it together, perform calculations and create powerful visualisations. 

What is Power BI – Take a look here?

Power BI is an AMAZING cloud-based business analytics service provided by Microsoft that allows users to transform data into rich, interactive visual reports that present a 360-degree business view and improve business decision making.

Power BI Desktop is a development platform from Microsoft that allows users to connect to a huge range of data sources, clean and transform messy data, create relationships between data sets, perform calculations and prepare stunning interactive reports.

Power BI.com allows users to publish their interactive reports and share certain features of those reports with others. Reports published to PowerBI.com can be set to refresh automatically and can be interacted with online using any browser or mobile device.

See what attendees are saying about the course

 

Expert Facilitator | Customise & run this course In-House | Course Enquiry

Key Advantages of Power BI

  • Easily connect to multiple data sources, including Excel files, SQL Databases, Google Analytics, SharePoint, CSVs, ODBC and many more
  • Quickly prepare raw data for analysis by recording data transformations
  • Simply drag and drop to easily create relationships between different data sources. NO VLOOKUP REQUIRED!
  • Create custom report calculations for measuring profitability, margins, KPIs and any other desired areas using the powerful DAX formula language
  • Easily prepare interactive data visualisations colour-coordinated with corporate colours using built-in or custom templates
  • Quickly publish reports to Power BI.com for users to interact with using any browser, mobile phone or tablet
  • Customize reports and dashboards

Pre-requisites

This is an introductory course and although it does not assume any prior experience with Power BI, participants will gain much more from the course if they have at least used Power BI a little prior to attending.  Participants who have taught themselves Power BI will also benefit from attending as the course will fill-in a number of gaps in their knowledge and will also extend what they know.

A general understanding of databases, Excel formulas, and Excel Pivot Tables is useful though not essential.

Course Outline

Day 1-2

Introduction to the Power BI Environment

•           Key components and how each works

•           Report functionality and how to use this to get the data you want

•           Build your first report in just a few minutes

Preparing Dashboard Data

Most of the work in a Power BI project is in preparing and structuring your datasets so that they are ready for use in Power BI visuals.

•           How to import data into Power BI Desktop from a wide variety of data sources

•           How to join different data sets together, even if they come from different files, databases or other sources

•           How to clean and transform your data so it’s ready for use with Power BI

•           Delving into “Get Data” and an introduction to understanding “M” code (Power Query language)

•           How to turn short, wide data tables into long, tall tables and why this is so useful for Power BI

•           Joining multiple data tables together and understanding relationships

•           How to create efficient data models: merging, appending and structuring your datasets to create the optimal structure

•           Learn how to apply your Power Query skills to Excel and when to choose one over the other

•           Different techniques for creating and utilising a Calendar table that you can use to slice and summarise your reports

•           Create queries that automatically report errors and missing codes

•           Learn how to automatically combine all the Excel, CSV or Text files in a folder into one table and see how you could apply this

•           Learn the principles of filter context, how critical this is for DAX formulas, and how to modify this in calculations to produce the results you need

•           Learn how DAX formulas work and how they’re different from Excel (even though they look similar!)

•           When to use a calculated column in a table and when to write a measure

•           Key DAX concepts and formulas include grouping and naming measures, aggregation functions, counts, time-related calculations, conditional tests, preventing errors, dealing with multiple date fields in one table and building measures that are based on other measures.

Creating Interactive Visualizations

•           Creating interactive visualisations

•           Adding/changing information presented in a visualisation

•           Incorporating custom visuals

•           Adding custom colour schemes to a dashboard

•           Create pre-filtered reports and charts that allow your users to drill down to see more detail

•           Learn how to create chart tooltips that automatically pop-up when a user hovers over the charts

•           See how to setup your reports and dashboards for use on mobile phones and other devices

Using POWERBI.com to add value to your Reports

•           How to create and share dashboards

•           Learn a variety of different ways to share your Power BI reports, and when to apply each one

•           How to create new visualisations just by typing a sentence

•           How to create an Excel pivot table from a report that’s been published to PowerBI.com

•           How to create alerts that automatically send e-mails if an indicator goes over or under a specified value

•           Learn how to set up a gateway that will refresh data that is sourced from inside your organisation

•           Scheduling data refreshes so that your reports are always up-to-date

•           Setting up security so that different users automatically see different views of the same report when they login

Apply your Skills to a Real-life Situation

We finish the second day with an extended exercise where you apply the skills you’ve learned to a real-life series of datasets.  In this exercise, you’ll create a data model, build your calculated fields and measures, then produce reports and visuals … all without any step-by-step instructions.  It’s designed to be as close to real-life as possible and provides a great test for your new skills.

Comprehensive course notes, exercises and completed solutions are included.

Day 3 [optional]: Your Power BI Project

This day is optional but it’s when most participants get the maximum benefit from this course so we highly recommend taking the extra day!

Bring your own project along and work on this while receiving any help and coaching you need to solve your reporting challenges.

You’ll not only get to practice applying what you’ve just learned, but you’ll also walk away with something practical that you can start using in your office tomorrow.

Working on your own data makes the course far more relevant and meaningful for you, it allows us to help you structure your data models, queries and DAX formulas correctly, and it allows us to help you solve any additional problems that may arise but which were not covered as part of the standard course.

Many previous participants have remarked that they obtained the most value from the course during the third day because otherwise, they wouldn’t be able to do what they need to do.

In addition, you can always come back at any time in future and attend more of these workshop days if you’d like to.

 

This course provides 7.5 contact hours per day towards continuing education requirements.

Who should attend?

  • Excel users & analysts that focus on extracting, re-organizing and analyzing data
  • Anyone involved in creating visualizations & data modelling
  • Anyone interested in saving huge amounts of time in automating the work involved in creating recurring reports and dashboards

Register Now!

No Events

 

Related Courses

D3 Power Query and Power Pivot for Excel (2 days)
This Power BI course is focused on real-world techniques and goes in-depth into how to get the most from these amazing utilities: Power Query, Power Pivot, Power BI Desktop
D5 Power Query in a Day (1 day)
The course covers the core elements needed to get an understanding of what Power Query can do and how to apply multiple techniques to convert messy data into clean tables for analysis.
D7.1 DAX Booster for Power BI (1 day)
This intermediate to advanced hands-on course is focused on enhancing your understanding of the amazing capabilities of DAX. Get an understanding of the key elements of DAX language, with a sound understanding of key data modelling concepts.
D7.2 Power Query Booster (1 day)
This intermediate to advanced hands-on course is focused on enhancing your understanding of the amazing capabilities of Power Query and the ”M” language. Get a solid understanding of Power Query functionality, the “M” language, and how to handle more complex data transformations.

 

Facilitator: Wyn Hopkins

Excel MVP, B.Sc. (Hons) Accounting & Financial Management | LinkedIn | Wyn qualified as a Chartered Accountant with PricewaterhouseCoopers in the UK in 2000, before working as an analyst for the FTSE 100 companies HBOS and Barclays. Microsoft awarded him the status of  Most ValuableProfessional for the 5th year running in 2021. This recognises his expertise and willingness to share his knowledge via blogs, articles and community events Wyn is an experienced Trainer and Excel / Power BI Developer. Since joining Access Analytic in 2007, he has delivered hundreds of amazing solutions for clients including many for Chevron and other leading organisations in Perth.

Facilitator: Jeff Robson

Masters (Applied Finance), B.Com (Accounting & Information Systems), FAIM, F Fin, GAICD, CISA, Excel Expert| LinkedIn | Jeff is the founding Director and Principal Business Analyst at Access Analytic Solutions. He has over 20 years’ experience in chartered accounting, business management and consulting. Jeff holds a Masters in Applied Finance and is a Certified Information Systems Auditor. He is highly regarded and recognised around the world as an expert in the field of financial modelling and Power BI reporting. His achievements have been recognised by his peers and he is a Fellow of both the Financial Services Institute of Australasia and the Australian Institute of Management. Jeff has extensive experience in best practice management reporting, data analytics, business analysis, and financial modelling and is also an entertaining international presenter and trainer on these subjects. Jeff is the author of a number of white papers on financial modelling on subjects such as Financial Modelling Best Practices and Financial Model Auditing. He provides training for companies throughout Australia, New Zealand, Asia, South Pacific, the Middle East, and Africa.

Facilitator: Yury Tokarev

PhD, Chartered Accountant, Bachelor of Business (Finance and Economics), Microsoft Certified Excel Expert (MCEE) | LinkedIn | Yury is a Director and an International Training Specialist at Access Analytic Solutions. He has over 25 years of experience in corporate finance, chartered accounting, and consulting. Prior to his current role he worked in Business Services and Advisory at WHK Chartered Accountants and Corporate Finance at one of the top European Investment Banks. Yury has wealth of experience having delivered hundreds of Financial Modelling, Power BI and Excel solutions to clients ranging from start-ups to multi-billion corporations, including Chevron, Woodside, Northern Star Resources, Quadrant Energy, TransAlta and many more. Yury is also an international trainer on these subjects, and provides training for companies throughout Australia, Asia, the Middle East, South Pacific and South America.

Benefits & Inclusions

Practical: Highly experienced facilitators who actively and regularly consult to clients also.
Applicable: apply what you learn to your job to further your career.
Hands-on: the course is designed to provide maximum hands-on experience.
Passionate: Our facilitators love this subject!
Clear: we specialise in translating complex subjects into concepts that are easy to understand.
On-going help: you can always e-mail the facilitator to get help at any time in future.
Comprehensive course notes.
Networking: meet industry peers and hear how they approach this subject.
Certificate of completion, showing 7.5 hrs of Continuing Professional Development (CPD) per day.
… and much more!

Companies today are demanding increasing value and greater returns from their training budget.

The best way to achieve this is to run in-house courses where we come to your office and provide a customised course for your staff.

Benefits

  • More Relevant: we can customise our courses to suit your training needs and may even be able to incorporate some of your own data or models into the training to make it more relevant and useful for the participants
  • More Flexible: schedule the training when it suits you best.  You can even schedule the training days across multiple weeks to reduce the impact on workloads & schedules.
  • More Convenient: we come to your office so there’s no travel time or cost for your staff.  We are happy to travel to remote office locations, interstate or overseas.
  • More Affordable: in-house courses are up to 80% cheaper than sending the same number of people on a public course.  This lets you train more people for less!
  • No hidden extras: we provide a fixed fee up-front that includes all costs
  • Small or Large: in-house training is cost-effective for groups as small as 4 people.  You can even organise your own group if you wish by combining with other companies/colleagues!

Call us on +61 8 6210 8500 to discuss your requirements or enquire online.

Discount:
A 10% discount applies when booking 10+ full days of training in any 30 day period

Calendar

Power BI Essentials (2 days) Face-to-Face Training

ATI Mirage Level 1/863 Hay Street, Perth, WA, Australia

All the key aspects you need to know to begin developing Power BI reports for your business. Create stunning interactive reports and share amazing insights! Power BI gives Excel users the power to extract data from multiple sources, link it together, perform calculations and create powerful visualisations.

Get Tickets A$1,499.00 – A$1,699.00

Power BI Essentials (2 days) Face-to-Face Training

ATI Mirage Level 1/863 Hay Street, Perth, WA, Australia

All the key aspects you need to know to begin developing Power BI reports for your business. Create stunning interactive reports and share amazing insights! Power BI gives Excel users the power to extract data from multiple sources, link it together, perform calculations and create powerful visualisations.

Get Tickets A$1,499.00 – A$1,699.00

Power BI Essentials (2 days) Face-to-Face Training

ATI Mirage Level 1/863 Hay Street, Perth, WA, Australia

All the key aspects you need to know to begin developing Power BI reports for your business. Create stunning interactive reports and share amazing insights! Power BI gives Excel users the power to extract data from multiple sources, link it together, perform calculations and create powerful visualisations.

Get Tickets A$1,499.00 – A$1,699.00