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.

REGISTER MORE INFO






 

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

Bookings

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

DISCOUNT BENEFITS


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.

REGISTER

Event Information:
Date: 17th & 18th January 2019 at Benvenuto Conference Centre in Randburg

11th & 12th February 2019 at Benvenuto Conference Centre in Randburg

25th & 26th February 2019 at Birchwood Hotel & OR Tambo Conference Centre

7th & 8th March 2019 at Benvenuto Conference Centre

18th & 19th March 2019 at Birchwood Hotel & OR Tambo Conference Centre in Boksburg

14th & 15th May 2019 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
 

WORKSHOP OUTLINE

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
Modelling
  • Managing data relationships
  • Optimizing data models
  • Calculated tables
  • Explore time based data
Visualizations
  • 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

 

REGISTER

 

Accreditation
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