31 Oct

Academy - Power BI: Enhance Your Data Model with DAX (Seattle, WA)

Academy - Power BI: Enhance Your Data Model with DAX (Seattle, WA)

Wednesday, October 31, 2018 (11:00 AM) to Wednesday, October 31, 2018 (3:00 PM) (Eastern Time)

Microsoft ADVANTA Building B 3009 160th Ave SE Bellevue, WA 98008
Brian Grant


You're Registered!
Why do you need the course?
To take your data model beyond simple aggregations and create more complex calculations that span multiple tables and millions of rows of data.

Course Objectives:
By the end of this course, you will be able to use DAX to create calculations in a Power BI Desktop data model. Specifically, you will be able to:
Understand the concepts of Data Modeling
Understand the consequences of data model design decisions
Understand concepts of calculated columns and measures
Gain familiarity with standard DAX patterns & CALCULATE
Understand evaluation contexts and their impact on calculations
Gain ability to parse data modeling formulas

This class is a combination of Lecture, Demo and Lab

The class is designed for someone with intermediate-level Power BI experience.

Please bring a laptop to the course, with the following connectivity and software installed:

Internet connectivity: You must be connected to the internet
  • At minimum, a computer with 2-cores and 4GB RAM running one of the following version of Windows: Windows 7, Windows 8, (64-bit preferred), Windows 8.1 or Windows 10 or Windows Server 2008 R2 or Windows Server 2012/R2 
  • Microsoft Power BI Desktop requires Internet Explorer 9 or greater
  • Verify if you have 32bit or 64bit operating system to decide if you need to install the 32bit or 64bit applications. 
  • Search for computer on your PC, right click properties for your computer
  • You will be able to identify if your operating system is 64 or 32 bit based on “system type” as shown below
  • Download and install Power BI Desktop: Download and install Microsoft Power BI Desktop from http://www.microsoft.com/en-us/download/details.aspx?id=45331. Please choose appropriate 64-bit or 32-bit version depending on your platform. Microsoft Power BI Desktop is available for 32-bit (x86) and 64-bit (x64) platforms
Download Class Files:
Copy Files from your USB to C:\Power BI_Adv_Model\ (Please return the USBs)

Brian Grant