The Fundamentals of Data Analysis and Modelling with DAX for Power BI, Power Pivot and Analysis Services
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.
Explain and use Calculated Columns and Measures
Explain and use aggregation functions and expressions in DAX such as SUM and COUNT
Explain and use table functions such as Filter and RelatedTable
3 Lectures
18 Lectures
10 Lectures
13 Lectures
3 Lectures
With over 25 years of expertise in Accountancy, Business Management, and Operations, I, Paula, am a seasoned CPA (Certified Public Accountant) dedicated to empowering learners with practical skills and knowledge. As a former Microsoft MVP (Most Valuable Professional) in Excel for two consecutive years (2020 & 2021), I've been recognized for my commitment to excellence in spreadsheet solutions and financial...
Super, actually this is what I needed that each and every concept is explained as it should be .Thanks
Awesome
The instructor was great at explaining the concepts, and I really appreciated how she put what each DAX expression was doing in laymen's terms. My only disappointment came from the fact that most of the examples were shown in PowerPivot. I was expecting more examples to be done in Power BI, as that per the course name, and was the reason why I bought the course.
I learned a lot, but I found some of the mistakes distracting and I was disappointed by the lack of guidance in the final task.
Thank you for this course!
Conteúdo bem abrangente, poderia melhorar as legendas.
I now have a better understanding of the difference between a calculated column and a DAX measure.
good course for the beginners
This was repeat of a course written some time ago for power pivot or power query. power bi was just a toss in. good stuff the teacher needs to update the material
Your email address will not be published. Required fields are marked *
Saba T.
Very bad. Alot of only accent and unclear words. Not enough content