Udemyintermediateen

DAX Power Pivot Time Intelligence - 10 Easy Steps

Master DAX calendar functions for powerful business intelligence. Create custom calendars & time periods for accurate data analysis. Boost your BI skills!

4.6(374)
2,527students
5h 48m
Certificate
Gilly Dow
Gilly DowIT Training Consultant

Course Content

DAX Power Pivot Time Intelligence - 10 Easy Steps is an intermediate-level Udemy course taught by Gilly Dow. It runs 5h 48m, is taught in English, and includes a certificate of completion. Learners rate it 4.6 out of 5 from 374 reviews, with 2,527 students enrolled. It is a paid course, last updated April 2021.

Deepen Your DAX & Power Pivot Skills: Mastering Time Intelligence

This course is the perfect next step after completing "DAX Power Pivot – 10 Easy Steps for Beginners." You've already grasped the fundamentals of DAX and Power Pivot – now it's time to unlock advanced capabilities with time data.

Unlock the Power of Time Intelligence in DAX

Data Analysis Expressions (DAX) offers powerful time intelligence functions to analyze data across various time periods. Learn to manipulate data using days, months, quarters, and years, and build insightful calculations over those periods. This course provides a thorough understanding of how Power Pivot handles time data, empowering you to perform sophisticated business intelligence analysis.

What You'll Learn:

  • Performing Date Calculations in DAX: Master essential date functions for standard calendars.
  • Building a Standard Calendar Table: Create a robust calendar foundation for your Power Pivot models.
  • Running Totals: Calculate Month-to-Date (MTD), Quarter-to-Date (QTD), and Year-to-Date (YTD) totals.
  • Fiscal Year End Calculations: Compute the moving annual total for fiscal year-end reporting.
  • Growth Analysis: Aggregate and compare growth percentages over time.
  • Time Intelligence with CALCULATE(): Utilize the powerful CALCULATE() function for advanced time-based calculations.
  • Date Comparisons: Calculate Closing Balance, First Date, Last Date, End of Month, and Start of Year.
  • Values Between Dates: Extract data based on specific date ranges.
  • Performing Date Calculations in DAX with a 4-4-5 Calendar: Learn to handle complex calendar structures.
  • Custom Calendar Tables: Build and utilize custom calendar tables for specific industry needs.
  • Working with Multiple Calendar Tables: Combine and leverage multiple calendar tables in your models.
  • Manipulating DAX Patterns: Apply proven DAX patterns for efficient time intelligence calculations.
  • Custom Time Intelligence with CALCULATE(), FILTER(), and ALL(): Master advanced DAX techniques for complex time-based analysis.
  • Aggregating and Comparing Growth %’s over time: Gain deeper insights into performance trends.

Who is this course for?

This course is ideal for users who have completed the beginner course and want to:

  • Gain a deeper understanding of DAX time intelligence.
  • Build custom calendars to meet specific business requirements.
  • Perform advanced time-based analysis in Power Pivot.
  • Improve your DAX skills and confidence.

What Others Are Saying:

"So far it's been easy to follow. The instructor is doing a great job of explaining what she is doing. Looking forward to more advanced topics." - John Pertell

"Outstanding. It’s explained clear concise wonderful examples that are broken down and clearly explained fantastic course great teacher and teaching style. Highly recommend" - Stephen Davanzo

"Highly recommended course! For every single function mentioned in the course there are an example and practice exercise. Great!" - Elbina Rizakhanova

Difficulty Level:

The first half of the course focuses on intuitive "time-ready" DAX functions. The second half, involving custom time intelligence functions, presents a moderate challenge but is achievable with guidance and practice.

Software Compatibility:

While demonstrated in Excel 2016, this course is compatible with Excel 2010 & 2013. Differences will be noted where applicable.

Ready to take your DAX & Power Pivot skills to the next level?

[**TAKE THIS COURSE**](link to course)

Don't hesitate to message me with any questions or explore the FREE preview lectures to get a taste of what's inside! I'm excited to help you succeed.

$ whoami — the devs behind tutorialsearch.io

Want AI in your product? Hire the team behind TutorialSearch.io

LLM features, RAG, agents and automation wired into a real product — built by the devs who shipped this site.

5.0(179)
5h 59m
beginner
skillshare
5.0(308)
1h 35m
beginner
skillshare
5.0(234)
1h 36m
all
skillshare
5.0(346)
1h 6m
all
skillshare
skillshare