Skip to main content
HomeBusiness Intelligence

Course

Trend Analysis in Power BI

IntermediateSkill Level
4.8+
2,922 reviews
Updated 10/2024
Enhance your reports with trend analysis techniques such as time series, decomposition trees, and key influencers.
Start Course for Free
Power BIData Manipulation3 hr9 videos25 Exercises1,950 XP37,879Statement of Accomplishment

Create Your Free Account

or

By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.

Loved by learners at thousands of companies

Group

Training 2 or more people?

Try DataCamp for Business

Course Description

Analyze Time-Series Data

In this course, you’ll learn how to analyze time series, visualize your data, and spot trends. You’ll build new date variables, discover run charts, and get into calculating rolling averages.

Understand Influencing Variables

Finally, you’ll find out how to identify which variables exhibit the most influence on the target variable using Power BI's decomposition trees and key influencers.

Prerequisites

Exploratory Data Analysis in Power BI
1

Exploring Time Series Data

In this chapter, you’ll get more familiar with time-based variables and the multiple ways to extract further variables using EDA for analysis—like day of week and time difference. You’ll get hands-on with Power BI as you build line charts to calculate new metrics and uncover trends hiding in your data—including period-over-period change and rolling averages.
Start Chapter
2

Analyzing Time Series in Power BI

In this chapter, you’ll get more familiar with time-based variables and the multiple ways to extract further variables using EDA for analysis—like day of week and time difference. You’ll get hands-on with Power BI as you build line charts to calculate new metrics and uncover trends hiding in your data—including period-over-period change and rolling averages.
Start Chapter
3

Decomposition Trees

One of the most powerful functions of EDA in Power BI is being able to identify which variables have the most influence on your target outcome. A native Power BI visualization tool enabling that is Decomposition Trees. You'll learn about Decomposition Trees, how to construct, then interpret in order to explain a target outcome by other variables.
Start Chapter
4

Key Influencers

In this chapter you'll build another native Power BI tool, Key Influencers visual. It helps you to understand how much a target outcome changes based on specific variables and segments of observations.
Start Chapter
Trend Analysis in Power BI
Course
Complete

Earn Statement of Accomplishment

Add this credential to your LinkedIn profile, resume, or CV
Share it on social media and in your performance reviewEnroll Now

Don’t just take our word for it

*4.8
from 2,922 reviews
83%
16%
1%
0%
0%
  • Travis
    2 hours ago

  • Joao Pedro
    5 hours ago

  • Deepa
    6 hours ago

  • Peter
    9 hours ago

  • Edwin
    12 hours ago

  • Claire
    17 hours ago

Travis

Joao Pedro

Deepa

FAQs

What prior Power BI skills do I need for this course?

You should already know how to create measures and columns using DAX, build common visuals like bar charts, and load data with Power Query. The prerequisite course is Exploratory Data Analysis in Power BI.

What datasets will I work with?

You will analyze a sample of 8,000 Airbnb listings from cities including New York, Paris, Rome, and Sydney, and a synthetic dataset of Glassdoor employee reviews covering ratings and professional history.

What can I do with time series data after completing this course?

You will be able to build run charts, calculate rolling averages, detect anomalies, and break down trends by categories using small multiples, all within Power BI Desktop.

What are the Key Influencers and Decomposition Tree visuals used for?

Key Influencers identifies which variables most strongly affect an outcome, while the Decomposition Tree lets you drill into a metric by multiple variables step by step. Both are native Power BI features that require no coding.

How is this course different from a statistics course?

The focus is on applying analytical concepts such as rolling averages, correlation, and anomaly detection visually inside Power BI, not on mathematical derivations. It is designed for practitioners who need actionable insights, not statistical theory.

    Join over 19 million learners and start Trend Analysis in Power BI today!

    Create Your Free Account

    or

    By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.

    Grow your data skills with DataCamp for Mobile

    Make progress on the go with our mobile courses and daily 5-minute coding challenges.