An Introduction To Power BI And A Hands-On Experience On How To Leverage Power BI For Better Business Analytics

A two day workshop helping you to leverage Power BI as a useful tool for better business analytics. 

Power BI (including Power Query & Power Pivot) are the biggest Excel news items in the last 10 years. They give Excel users the power to draw information out of multiple sources, link it together then perform calculations on it that can then be sliced & diced any way you want.

This hands-on course is focused on real-world techniques utilising the amazing capabilities of Power Query, Power Pivot and Power BI. You will use Power Query to extract and shape data and then load it into Power Pivot. You will build a complex Power Pivot Model from scratch, write DAX formulas and set up interactive reports. You will get a more in-depth understanding of Power Query and Power Pivot reporting techniques

Join us at this 2-day workshop to get a hands-on experience on:

  • Understand how Power BI builds on the functionality of Excel’s native tools (e.g. PivotTables, slicers) and key analytical functions
  • Learn how to import data from a variety of electronic sources and relate them quickly to deliver key information in a timely manner
  • Leverage on best practice database design, realising the power of the Data Model by using LOOKUP lists and efficient database design
  • Get your one-stop introduction to Power BI’s Data Analysis Expressions (DAX) language
Users should already be comfortable with Excel to get the most from this course. Participants should be familiar with functions & concepts such as VLOOKUP and SUMIFS. The focus of the course is on Excel 2013/2016 and Power BI Desktop.

Power BI Fundamentals Workshop Leader

Jeff Robson

Principal Business Analyst and Chief Executive Officer

Access Analytic

 Masters (Applied Finance), BCom (Accounting & Information Systems), FAIM, F Fin, MAICD, CISA, MS Excel Expert
 

Jeff is the Principal and Founding Director of Access Analytic, a specialist consultancy that specialises in Power BI, data analytics, dashboards and financial modelling for clients worldwide.

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.

He is skilled in the development and maintenance of analytical tools and financial models for middle-market to large corporate transactions and clients, at all levels of complexity, in both domestic and international settings.

Why Attend 

  • Designed to be as close to real-life as possible, this practical two-day course will focus on providing participants with hands-on experience on leveraging Power BI as a useful tool for better business analytics.

Who Should Attend

  • This workshop has been specially designed for all Excel users and analysts who have responsibility for extracting, re-organising and analysing data, creating visualisations and data modelling, creating recurring reports and dashboards, and anyone else who is interested in saving significant time through automating the work involved in the above. 

Team Discounts


SEND 3 DELEGATES AND RECEIVE 5% OFF

SEND 4 DELEGATES AND RECEIVE 10% OFF

SEND 5 DELEGATES AND RECEIVE 15% OFF

5%OFF 10%OFF 15%OFF

Power BI Fundamentals Workshop Venue

This masterclass is held in a hotel in selected City CBD and delegates will be notified 4 weeks prior to the event.