Mastering Intermediate DAX - Power BI, Power Pivot & SSAS
What you'll learn
- Carry out difficult DAX expressions in Power BI, Power Pivot and SSAS
- Have the ability to modify the current filter context with DAX expressions
- Have the ability to modify how totals and subtotals are shown
- Explain and work with Context Transition in DAX
- Work with hierarchies and related functions
- Calculate different moving averages without using Time Intelligence functions
- Work with advanced calculations using iterators
- Understand Bidirectional filters
- Advanced relationships and UseRelationship
Requirements
- You should be familiar with either Power Pivot, Power BI or Analysis Services
- You should have a want to learn DAX (Data Analysis Expressions)
- You should have a basic working knowledge of DAX ( material covered in Master the Fundamentals of DAX)
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 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 you to 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 SELECTEDVALUES
In Section 3 we will look in dept at CALCULATE and Contest Transition. You will learn when to use FILTER inside CALCULATE and also when it is useful to combine CALCULATE and VALUES.
Section 4 is packed with Case Studies. We will look at different problems and the solutions. The first case study will focus on parent-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 at BI Directional Filters and the use of USERELATIONSHIP
Each 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.
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 intermediate or advanced level DAX
Instructor
- 4.2 Instructor Rating
- 2,784 Reviews
- 154,272 Students
- 11 Courses
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 analysis.
Having immersed myself in the Web3 landscape since 2016, I've become a leading voice in simplifying complex concepts, making Web3 and Blockchain technology accessible to all. And so, my journey took an exciting turn in 202 when I embraced the transformative potential of Web3, Blockchain, and Digital Assets and pivoted my training to focus on web.
Founder of A Block of Crypto: As the founder of A Block of Crypto, I am passionate about demystifying the world of cryptocurrency and blockchain. Through engaging courses and interactive online meetups, I strive to make Web3 and blockchain technology as intuitive as ABC. My mission is not just to educate but to onboard and retain users in the rapidly evolving Web3 ecosystem.
What I Offer:
Comprehensive Courses: Dive deep into the fundamentals of Web3, Blockchain, and Crypto with my meticulously crafted courses designed for beginners and seasoned professionals alike.
Interactive Online Meetups: Join our vibrant community and participate in regular online meetups where you can network with like-minded individuals, ask questions, and stay updated on the latest developments in the world of Web3.
Web3 Support: Whether you're navigating your first crypto project or exploring decentralized finance (DeFi) protocols, I'm here to provide guidance and support every step of the way.
Let's Connect: Embark on your journey into the exciting world of Web3 and Blockchain with me. Follow me on Udemy to stay updated on upcoming courses, events, and exclusive learning opportunities. Together, let's unlock the full potential of decentralized technology and shape the future of finance and beyond.