This Course Focuses On

Enabling users to interact with corporate information, to extract the reports and information they need as well as how to create compelling visualizations and reports that provide deep insights into your data.

DAX is a collection of functions, operators, and constants that can be used in a formula, or expression, to calculate and return one or more values. DAX helps you create new information from data already in your model.

Why is DAX so important?

It’s quite easy to create a new Power BI Desktop file and import some data into it. You can even create reports that show valuable insights without using any DAX formulas at all. But, what if you need to analyze growth percentage across product categories and for different date ranges? Or, you need to calculate year-over-year growth compared to market trends? DAX formulas provide this capability and many other important capabilities as well.

Learning how to create effective DAX formulas will help you get the most out of your data. When you get the information you need, you can begin to solve real business problems that affect your bottom line. This is the power in Power BI, and DAX will help you get there.



R4700.00 (excl vat)
R5405.00 (incl vat)


Contact Adele
on 011 867 7299 or email
Bookings and Enquiries Website | Email


10% discount for two or more delegates
10% discount if you attend two or more workshops
15% discount for four or more delegates

In-house at your offices
25% discount for 5 or more delegates
30% discount for 8 or more delegates
35% discount for 10 or more delegates

Who should attend this course?
Anyone who wants to become familiar with Microsoft’s Power BI product, whether you are a beginner, intermediate or advanced user.


Event Information:
Date: 22nd 23rd 24th October 2019 at Benvenuto Conference Centre in Randburg

6th & 7th November 2019 at Birchwood Hotel & OR Tambo Conference Centre

30th & 31st January 2020 at Benvenuto Conference Centre in Randburg

Map: View map
Duration: 2 Days
Cost: R4700.00 excl VAT
R5405.00 incl VAT
Surcharge: Strict Halaal and Kosher meals carry an additional surcharge


Getting Started
  • Introduction to Power BI
  • Using Power BI
  • The building blocks of Power BI
Getting Data
  • Overview of the Power BI Desktop
  • Connecting to data sources in the Power BI Desktop
  • Using the Query Editor
  • Managing data relationships
  • Optimizing data models
  • Calculated tables
  • Explore time based data
  • Create and customize simple visualizations
  • Slicers
  • Matrixes and tables
Exploring Data
  • Create and configure a dashboard
  • Share dashboards with your organization
  • Display visuals and tiles full-screen
Power BI and Excel
  • Upload Excel data to Power BI
  • Import Power View and Power Pivot to Power BI
  • Connect OneDrive for Business to Power BI




Front Foot Strategic Consulting has been awarded accreditation status as a provider of Education and Training in terms of the South African Qualification Authority Act.

Front Foot is a Majority Black-Owned Level 2 EME – 125% Recognition