DAX Using MS Power BI (1)


The focus of the training is on the use of Microsoft Power BI custom visual called data storytelling visual. Prepared and pre-formatted data sources will be provided for all participants which will enable them to create compelling and powerful presentations using Microsoft Power BI data storytelling custom visual. The custom story-telling visual will in itself become a sort of animation within Power BI transforming data into engaging presentations which showcase certain business use cases that need to be viewed by or consumed by those who would be attending such presentations.

Learning Objectives

  • To provide participants with an overview of the subject matter for presentation
  • As best as possible, to demonstrate features that further enhance your capabilities in creating powerful data visualization
  • To give you a better understanding of the underlying principles of the DAX functionality
  • Learn, practice, and apply acquired understanding for your business / personal use


  • Must have a good background in MS Excel for at least 6 months
  • Preferably participated in actual learning experience using MS Power BI
  • Data Science background is an advantage (but not required)
  • Desire to further improve current MS Power BI skills and understanding

Who Should Attend

This course is intended to introduce participants to a step-by-step hands-on training workshop on MS Power BI.

  • Managers of business intelligence, analytics, and big data professionals teams
  • Current business and data analysts looking to add big data analytics to their skills
  • Data and database professionals looking to exploit their analytic skills in a big data environment
  • Recent college graduates and graduate students with academic experience in a related discipline
  • looking to move into the world of Data Science and big data

Program Duration

3 days, 4 hours each day

Program Outline/Course Overview

Day 1

  • Understanding DAX
  • Understanding the DAX syntax
  • Understanding the language of DAX
  • Understanding parameters of DAX
  • Using the authors’ DAX table sheets with examples
  • Understanding DAX categories
  • Using table functions
  • Using text functions

Day 2

  • Using Boolean functions
  • Using calculate function
  • Using filter function with calculate function
  • Understanding the MS power BII in sequencing and execution of its function
  • Understanding filter first then compute later
  • Using a related function for many one relationships

Day 3

  • Using related table function for one to many relationships
  • Understanding the DAX formula editor
  • Short cuts to the formula editor
  • Understanding variables in DAX
  • Evaluating variables and results
  • Understanding the sequences of variables in results
  • Creating a virtual table to store measures
  • Revalida shall be administered to all participants to verify their assimilation and practice of the training subjects shared, demonstrated, and applied

For a complete course outline, email trainings@gcssinc.com