{"product_id":"introduction-to-dax-for-power-bi","title":"Introduction to DAX for Power BI","description":"\u003cdiv\u003e\n\u003cp\u003eThis \u003cstrong\u003eIntroduction to \u003cabbr title=\"Data Analysis Expressions\"\u003eDAX\u003c\/abbr\u003e for Power \u003cabbr title=\"Business Intelligence\"\u003eBI\u003c\/abbr\u003e\u003c\/strong\u003e presents Data Analysis Expressions (DAX) in Power BI from an intermediate to an advanced level. The journey starts with an introductory discussion about DAX, the syntax of DAX statements, and how to write structured DAX in the DAX editor. You also get an introduction to DAX Studio, a third-party tool that can be used to write DAX. You can decide if you want to use DAX Studio for the course exercises.\u003c\/p\u003e\r\n\u003cp\u003eWe will discuss many of the functions in DAX and how they could be used in a Power BI Project including explaining the use of iterator functions vs standard statistical functions. There are discussions explaining Calculated Columns, Tables, and Measures discussing the differences. There is also an explanation about Quick Measures and how we can utilize those. We will explain DAX Context and where those contexts apply. There are separate discussions for the CALCULATE function, the usage of a Data Model and incorporating a Date Dimension, and also using Time Intelligence Functions. We will conclude with a discussion around utilizing DAX with Row Level Security.\u003c\/p\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch3\u003eIntroduction to DAX for Power BI Benefits\u003c\/h3\u003e\n\u003cul\u003e\n\u003cli\u003e\u003cp\u003eStructure DAX with Power BI and DAX Studio\u003c\/p\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cp\u003eExtract business intelligence by using DAX\u003c\/p\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cp\u003eAdd value with measures, calculated columns and calculated tables using DAX\u003c\/p\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cp\u003eUtilize the different types of Dax functions\u003c\/p\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cp\u003eAppreciate DAX context and where it applies\u003c\/p\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cp\u003eUnderstand the use of a Data Model and how to extend it\u003c\/p\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cp\u003eCreate a Star and\/or Snowflake schema as your data model\u003c\/p\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cp\u003eAdd a Date dimension to your model\u003c\/p\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cp\u003eImplement Row Level security with DAX\u003c\/p\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cp\u003eDevelop a Star Schema from a Flat File Schema\u003c\/p\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cp\u003eDecide when to use M in Power Query or DAX in Power BI\u003c\/p\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cp\u003eLeverage continued support with after-course one-on-one instructor coaching and computing sandbox\u003c\/p\u003e\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\u003ch3\u003eIntroduction to DAX for Power BI Course Outline\u003c\/h3\u003e\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eIntroduction to DAX for Power BI Course Information\u003c\/h4\u003e\n\u003cp\u003e\u003cb\u003ePrerequisites\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eIntroduction to Power BI Training\u003c\/li\u003e\n\u003cli\u003ePower BI: Hands-On Reports and Dashboards Training\u003c\/li\u003e\n\u003cli\u003ePower BI: Advanced Data Modeling and Shaping\u003c\/li\u003e\n\u003cli\u003eor equivalent working experience\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eAudience Profile\u003c\/b\u003e\u003c\/p\u003e\n\u003cp\u003eThis course has been designed specifically for experienced model developers. We recommend that attendees have prior experience working with Power BI Desktop to create data models.\u003c\/p\u003e\n\u003cp\u003e\u003cb\u003eExam Information\u003c\/b\u003e\u003c\/p\u003e\n\u003cp\u003eLearning Tree Exam provided at the end of class\u003c\/p\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eIntroduction to DAX for Power BI Course Outline\u003c\/h4\u003e\n\u003cp\u003eChapter 1: Introduction to DAX\u003c\/p\u003e\n\u003cp\u003eIn this module, you will learn:\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eWhat is \u003cabbr title=\"Data Analysis Expressions\"\u003eDAX\u003c\/abbr\u003e?\u003c\/li\u003e\n\u003cli\u003eDAX Functions\u003c\/li\u003e\n\u003cli\u003eCalculated Columns and Tables\u003c\/li\u003e\n\u003cli\u003eQuick Measures and Measures\u003c\/li\u003e\n\u003cli\u003eDAX Context\u003c\/li\u003e\n\u003cli\u003eWriting DAX in Power \u003cabbr title=\"Business Intelligence\"\u003eBI\u003c\/abbr\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eHands-On Exercise 1.1: Introduction to DAX\u003c\/b\u003e\u003c\/p\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eChapter 2: Working with a Data Model\u003c\/h4\u003e\n\u003cp\u003eIn this module, you will learn:\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eUnderstand the role of the Data Model in Power BI\u003c\/li\u003e\n\u003cli\u003eDescribe the components of a Data Model\u003c\/li\u003e\n\u003cli\u003eWhat are Star and Snowflake schemas?\u003c\/li\u003e\n\u003cli\u003eFact and Dimension tables\u003c\/li\u003e\n\u003cli\u003eHow to build a Data Model from multiple Data sources\u003c\/li\u003e\n\u003cli\u003eWhy create a Date Dimension?\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eHands-On Exercise 2.1: Working with a Data Model\u003c\/b\u003e\u003c\/p\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eChapter 3: Using DAX in Power BI\u003c\/h4\u003e\n\u003cp\u003eIn this module, you will learn:\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eWriting DAX with DAX Studio\u003c\/li\u003e\n\u003cli\u003eFormatting DAX with DAX Formatter\u003c\/li\u003e\n\u003cli\u003eSummarizing and Aggregating functions\u003c\/li\u003e\n\u003cli\u003eWorking with Joins\u003c\/li\u003e\n\u003cli\u003eFiltering with DAX\u003c\/li\u003e\n\u003cli\u003eOther useful Dax Functions\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eHands-on Exercise 3.1 Working with DAX Functions – Part 1\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eDescribe the power behind the CALCULATE function\u003c\/li\u003e\n\u003cli\u003eAdd filters with the CALCULATE function\u003c\/li\u003e\n\u003cli\u003eIgnore filters with the CALCULATE function\u003c\/li\u003e\n\u003cli\u003eUpdate filters with the CALCULATE function\u003c\/li\u003e\n\u003cli\u003eDescribe Time Intelligence and the Time Intelligence functions\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eHands-On Exercise 3.2 Working with DAX Functions – Part 2\u003c\/b\u003e\u003c\/p\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eChapter 4: DAX and Row Level Security\u003c\/h4\u003e\n\u003cp\u003eIn this module, you will learn:\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eWhat is Row Level Security (\u003cabbr title=\"Row Level Security\"\u003eRLS\u003c\/abbr\u003e)\u003c\/li\u003e\n\u003cli\u003eUseful DAX functions for RLS\u003c\/li\u003e\n\u003cli\u003eDefining Roles for RLS\u003c\/li\u003e\n\u003cli\u003eCrating DAX Rules for RLS\u003c\/li\u003e\n\u003cli\u003eManaging Security and working with Members\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eExercise 4.1 Implementing Row Level Security\u003c\/b\u003e\u003c\/p\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eChapter 5: Comparing DAX and M\u003c\/h4\u003e\n\u003cp\u003eIn this module, you will learn:\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eOverview of \u003cabbr title=\"Power Query M formula language\"\u003eM\u003c\/abbr\u003e in Power Query\u003c\/li\u003e\n\u003cli\u003eWhen to use M or DAX\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e","brand":"Learning Tree","offers":[{"title":"269A14CN \/ 2026-09-28T09:00:00 \/ Ottawa","offer_id":47634346049755,"sku":"US-1365-IL","price":1640.0,"currency_code":"USD","in_stock":true},{"title":"266A75CN \/ 2026-06-29T09:00:00 \/ Online","offer_id":48216573280475,"sku":"US-1365-IL","price":1640.0,"currency_code":"USD","in_stock":true},{"title":"268C90US \/ 2026-08-24T09:00:00 \/ Herndon, VA","offer_id":48216573313243,"sku":"US-1365-IL","price":1640.0,"currency_code":"USD","in_stock":true},{"title":"26BB97US \/ 2026-11-24T09:00:00 \/ Herndon, VA","offer_id":48216573346011,"sku":"US-1365-IL","price":1640.0,"currency_code":"USD","in_stock":true},{"title":"271A22CN \/ 2027-01-04T09:00:00 \/ Ottawa","offer_id":48216573378779,"sku":"US-1365-IL","price":1640.0,"currency_code":"USD","in_stock":true},{"title":"272B27US \/ 2027-02-22T09:00:00 \/ Herndon, VA","offer_id":48291027419355,"sku":"US-1365-IL","price":1640.0,"currency_code":"USD","in_stock":true},{"title":"273A18CN \/ 2027-03-30T09:00:00 \/ Ottawa","offer_id":48523464736987,"sku":"US-1365-IL","price":1640.0,"currency_code":"USD","in_stock":true},{"title":"275B76US \/ 2027-05-25T09:00:00 \/ Herndon, VA","offer_id":48804198056155,"sku":"US-1365-IL","price":1640.0,"currency_code":"USD","in_stock":true}],"url":"https:\/\/learningtreeinternational-dirinfosec-hhs.myshopify.com\/products\/introduction-to-dax-for-power-bi","provider":"Learning Tree International","version":"1.0","type":"link"}