An introduction to Power BI and a hands-on experience on how to leverage Power BI 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.

Masterclass

 

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. 

Related events

Share this page

TOP