Skip to content
Getting Digital
All LevelsUdemy6 hours on-demand videoEnglish

DAX Power Pivot Time Intelligence - 10 Easy Steps

Support the Needs of Business Intelligence Using Custom Calendars and Time Period Functions in DAX.

Taught by Gilly Dow
Suitable for everyone
Enroll in This Course
✓ Instant access✓ Learn at your pace

Affiliate disclosure: if you enroll through links on this page, the course provider may pay us a commission. This comes at no extra cost to you and does not influence how we describe courses.

What You'll Learn in This Course

Master key concepts and practical skills through structured learning modules. By completing this curriculum, you'll gain valuable expertise applicable to real-world scenarios.

Learning Outcome 1

Support the needs of Business Intelligence using Time Period Functions in DAX

Learning Outcome 2

Create running-totals with DATESYTD(), DATESQTD() & DATESMTD()

Learning Outcome 3

Learn how to use PREVIOUSYEAR() and related DAX functions including PREVIOUSQUARTER(), PREVIOUSMONTH() & PREVIOUSDAY()

Learning Outcome 4

Customise DAX ready Time Intelligence functions with DATEADD()

Learning Outcome 5

Learn how to create base measures including FIRSTDATE(), LASTDATE(), ENDOFMONTH() & STARTOFYEAR()

Skills You'll Develop

This comprehensive DAX Power Pivot Time Intelligence - 10 Easy Steps curriculum is designed to take you from foundational concepts to advanced implementation. Each module builds upon the previous, ensuring a structured learning path that maximizes knowledge retention and practical application.

Hands-on LearningPractical ExercisesReal-World ProjectsIndustry Best Practices

Course Requirements & Target Audience

Understand what you need to succeed in this course and determine if it's the right fit for your learning goals

Prerequisites & Requirements

What you need before starting this DAX Power Pivot Time Intelligence - 10 Easy Steps course:

  • You should be familiar with DAX Power Pivot basics i.e. how to create a data model covered in DAX Power Pivot - 10 Easy Steps for Beginners or DAX Power Pivot - 10 Easy Steps for Intermediates
  • The course is run in Excel 2016 - however, Excel 2013 & 2010 users can follow along
  • IMPORTANT: You need a version of Excel that is compatible with Power Pivot (Excel 2013/2016/2019 Standalone, Office 365, Enterprise E3/E5, Office Professional 2016, etc.)
  • This course is designed for PC users (Power Pivot is currently unavailable with Excel for Mac)

Who This Course Is For

This course is perfect for:

  • Motivated learners at any level
  • Self-paced students
  • Anyone interested in the subject

This course might not be suitable if:

  • • You're looking for a quick tutorial rather than comprehensive learning
  • • You prefer learning without structured curriculum
  • • You need highly specialized or niche content

Course Information & Details

Everything you need to know about this online course, from duration to certification

Course Instructor

Gilly Dow

Expert instructor with industry experience

Course Language

English

All materials in English

Start Your Learning Journey Today

This online course offers comprehensive training with expert instruction, practical exercises, and a certificate of completion. Join thousands of students advancing their careers through quality online education.

Udemy Course

Course Enrollment

Get instant access to all course materials

Comprehensive Program

Professional training from $179.99

Pricing may vary. Check the course provider for current promotions and exact pricing.

What's Included

  • 6 hours on-demand video
  • 1 downloadable resource
  • Access on mobile and TV
  • Certificate of Completion
  • Full lifetime access
View Course & Enroll

Affiliate disclosure: if you enroll through links on this page, the course provider may pay us a commission. This comes at no extra cost to you and does not influence how we describe courses.

Browse Udemy
  • Instant access after enrollment
  • Learn at your own pace
  • Direct enrollment with Udemy

Where this course fits

Concepts behind this area

Networking

IP Addressing

IP addressing is the scheme that gives every interface on a network a numeric address, with IPv4's four-byte addresses now supplemented by IPv6's much larger space, and with private ranges reserved for use inside networks that reach the internet through translation.

Networking

Subnetting

Subnetting divides an address block into smaller networks by choosing how many leading bits identify the network, written as a prefix length or a subnet mask, so that each subnet has its own range of host addresses and its own routing entry.

Networking

Routing

Routing is how packets move between networks: each router holds a table of known destinations and the next hop toward each, learned by configuration or by a protocol, and forwards each packet to the most specific match.

Hosting & Cloud

Caching

Caching keeps the result of expensive work, such as a rendered page or a database query, and serves that stored copy until it expires, making it the largest single source of speed on any busy website.

Hosting & Cloud

Uptime & SLA

Uptime is the proportion of time a service answers requests, quoted in nines, and a service level agreement is the contract clause setting out how that proportion is counted and what the provider owes when it falls short.

Hosting & Cloud

Kubernetes

Kubernetes is an open-source system that runs containers across a cluster of machines, keeping the number and placement of running copies matched to a declared desired state, and restarting, rescheduling and scaling them without a person intervening.

The field, explained: Hosting & Cloud

Wider context: the fields we cover, the glossary and certification exams, all written by us rather than pulled from a provider feed.