Master DAX fundamentals : Power BI, Power Pivot & SSAS udemy course free download
What you'll learn:
Power BI DAX Fundamentals Mastering the Key Concepts
- Key Concepts in Power BI for DAX Power BI Fundamentals of the DAX index
- Row Context is something you’re familiar with Power BI.
- Filter Context is something you’re familiar with Power BI.
- In Power BI, you’re familiar with iterators.
- Context Transition is something you’re familiar with Power BI.
- Expanded Tables in Power BI are something you’re familiar with.
- You improve your Power BI DAX skills.
Requirements::
- You should have some prior familiarity with Power BI and DAX knowledge (based on my first Power BI course – Power BI Masterclass beginners to advanced (or comparable)).
- This course covers the fundamentals. (For specific issues, we do not address visualization or complex DAX patterns.)
Description:
Data Analysis and data modelling made easy with Data Analysis eXpressions. DAX can be used in Power BI, Power Pivot and Analysis Services.
Analyse and Model your data with in Power BI, Excels Power Pivot and Analysis Services with Data Analysis eXpressions.
This is a hands on course
Course Overview
In the first section of this course you will be introduced to the use of the most common DAX expressions, such as SUM and SUMX, COUNT, ROUND, DIVIDE, MIN, MAX, IF Statements, TEXT expressions, Variables and More
In the next section of this course you will learn the fundamentals of how DAX works. This section will include both theory and examples and it is of utmost importance that you understand how DAX works. We will discuss Row context and Filter context, ALL, FILTER, RELATEDTABLE, CALCULATE, EARLIER, Relationships and much more.
In the third section of this course you will learn about Time Intelligence and Date Tables. We will look at expressions such as TOTALYTD, SAMEPERIODLASTYEAR, DATESADD, DATESBETWEEN, CALENDERAUTO, and we will explore how many of these functions work using CALCULATE
Each section of this course contains Activities to complete. These Activities are of utmost importance. When it comes to learning DAX, practice is a must.
Who this course is for:
- Analysis Services Users
- Power BI Users
- Excels Power Pivot Users
- Those that need to model data using SSAS, Power BI or Power Pivot
- Data Analyst, Finance and Accounting Staff, Marketing Professionals, Business Managers and all those involved with reporting
- This course is NOT for you if you are already comfortable working with basic and intermediate level DAX
Course Details:
- 3 hours on-demand video
- 6 articles
- 4 downloadable resources
- Full lifetime access
- Access on mobile and TV
- Certificate of completion