DAX Power Pivot Time Intelligence - 10 Easy Steps: Standard & 4-4-5 Custom Calendars

This course builds upon the skills learned in the first course in this series DAX Power Pivot – 10 Easy Steps for Beginners. I’m going to assume you are up-to-speed with the basics but I highly recommend you check out my first eBook course first if you haven’t.
You have already gotten your hands dirty with Power Pivot and DAX functions so you know how awesome it is. Now you are ready to take your skills to the next level by delving deeper and acquiring a more thorough understanding of how Power Pivot handles Time data.
Data Analysis Expressions (DAX) includes Time Intelligence functions to support the needs of Business Intelligence analysis by enabling you to manipulate data using time periods, including days, months, quarters, and years, and then build and compare calculations over those periods.
The first part of the course concentrates on DAX time-ready functions ideal for a standard calendar – the kind you hang on your wall. So, if that’s how you roll at work – this is perfect for you.
The second half raises the stakes and you will learn how to manipulate DAX to generate your own custom functions to work with 4-4-5 custom calendars used in many different industries including retail.
In order to do this, I’ll introduce you to some new DAX functions that will elevate your skills enabling you to build custom DAX functions for those pesky non-standard calendars.
Even if this doesn’t fit your remit – DO IT ANYWAY! Your level of understanding will increase leaps and bounds and your confidence will soarrrrr!!! Plus, it’s GREAT fun and you’ll learn heaps along the way!
What you will learn in this course:
Performing Date Calculations in DAX with a Standard Calendar
•Building a standard Calendar table
•Running Totals with: Month-to-Date (MTD), Quarter-to-Date (QTD) and Year-to-Date (YTD)
•Computing the moving annual total for Fiscal Year Ends
•Aggregating and Comparing Growth %’s over time
•Time intelligence with CALCULATE()
•Computing periods from the Prior Year
•Closing Balance, End-of-Month, First Date, Last Date, End of Month and Start of Year
•Computing values Between Dates
Performing Date Calculations in DAX with a 4-4-5 Custom Calendar
•Building a custom Calendar table
•Working with multiple Calendar tables
•Manipulating DAX Patterns
•Custom Time intelligence with CALCULATE()
•Custom Time intelligence with CALCULATE(), FILTER() and ALL()
•Aggregating and Comparing Growth %’s over time
Will it be easy? Yes and no – the first half of the course – the DAX “time-ready” functions are intuitive and straightforward.
The custom Time Intelligence functions you create can be challenging but if it were easy where’s the satisfaction in that??
I provide examples that we work through together. Then it’s over to you with practice exercises for you to help embed and consolidate your skills. I always provide the solutions – so, you’re never on your own. What’s not to love?
Files to Download
Please visit www.gdteach.co.uk – just click on the DAX Time Intelligence page to download the files to complete the steps and practice exercises – scroll to the bottom of the web page to see how to download them. The AdventureWorks database is included in the download.
I have included an email grabber so that I can send you the files and let you know about new releases in this series. This information is for my purposes only and I will never pass on your information to any other party or supplier – that’s a promise!
If you are a visual learner and would prefer to view as I complete the steps and practice exercises, the accompanying online course is available on Udemy from late July 2017 and comes with a screenshot packed supporting pdf user guide!
Head on over to my website and click the link to get a super 67% discount on the full price.
There’ a no questions asked, 30-day money back guarantee! What's not to love?
In the meantime, please Click the Buy now button to take your DAX skills to the next level