Business Online Course by Udemy, On Sale Here
Take your Data Analysis Expression Skills to the Next Level with DAX for Power BI, Power Pivot and Analysis Services
An excellent training about Business Analytics & Intelligence
Mastering Intermediate DAX – Power BI, Power Pivot & SSAS
Data Analysis and data modellingmade easy with Data Analysis eXpressions. DAX can be used in Power BI, Power Pivot and Analysis Services. Analyse and Model your data with inPower BI, Excels Power Pivot and Analysis Services with Data AnalysiseXpressions. This is a hands on courseCourse OverviewIn the First section of this course you will refresh the fundamentals of how DAX works. as this section is a refresher section we will work through example rather fast. We will discuss Row context and Filter context, ALL, FILTER, RELATEDTABLE, CALCULATE, EARLIER, Relationships and much more. The aim of section 2 is to introduce youto some DAX functions that we will be working with in more detail later in this course. Many of the functions and expressions we will use in this section allow you alter or amend how totals and subtotals are shown. Functions covered will include ISFILTERED, ISCROSSFILTERED, ALLSELECTED, HASONEVALUE and SELECTEDVALUESIn Section 3 we will look in dept at CALCULATE and Contest Transition. You will learn when to use FILTERinside CALCULATE and also when it is useful to combine CALCULATEand VALUES. Section 4 is packed with Case Studies. We will look at different problems and the solutions. The first case study will focus onparent-child-hierarchy and include functions such as PATH and PATHLENGHT. The second case study will look at different Moving Averages using EARLIER, FILTER, VALUES and AVERAGE. In the third case study we will look at the use of Iterator functions over different granularities. Finally you will learn about about advanced relationships. We will look atBIDirectional Filters and the use of USERELATIONSHIPEach section of this course contains a folder to download. The folder contains the examples shown in the course and also activities for you to complete. These Activities are of utmost importance. When it comes to learning DAX, practice is a must.
Udemy is the leading global marketplace for learning and instruction
By connecting students all over the world to the best instructors, Udemy is helping individuals reach their goals and pursue their dreams.
Study anytime, anywhere.
Reviews
There are no reviews yet.