Skip to main content
HomePower BI

Trend Analysis in Power BI

Enhance your reports with trend analysis techniques such as time series, decomposition trees, and key influencers.

Start Course for Free
3 hours9 videos25 exercises15,156 learnersTrophyStatement of Accomplishment

Create Your Free Account

GoogleLinkedInFacebook

or

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

Training 2 or more people?

Try DataCamp for Business

Loved by learners at thousands of companies


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.
For Business

Training 2 or more people?

Get your team access to the full DataCamp platform, including all the features.
DataCamp for BusinessFor a bespoke solution book a demo.

In the following Tracks

Certification Available

Data Analyst in Power BI

Go To Track
  1. 1

    Exploring Time Series Data

    Free

    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.

    Play Chapter Now
    Starting to explore time series data
    50 xp
    Statements about time series analysis
    50 xp
    Exploring AirBnB time series
    50 xp
    Generating a new date variable
    100 xp
    Analyzing trends by day of week
    100 xp
    Calculating year-over-year change
    100 xp
  2. 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.

    Play Chapter Now
  3. 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.

    Play Chapter Now
  4. 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.

    Play Chapter Now
For Business

Training 2 or more people?

Get your team access to the full DataCamp platform, including all the features.

In the following Tracks

Certification Available

Data Analyst in Power BI

Go To Track

datasets

Exercises and DatasetsDataCamp vs. Local Experience

collaborators

Collaborator's avatar
Carl Rosseel
Maarten Van den Broeck HeadshotMaarten Van den Broeck

Senior Content Developer at DataCamp

Maarten is an aquatic ecologist and teacher by training and a data scientist by profession. He is also a certified Power BI and Tableau data analyst. After his career as a PhD researcher at KU Leuven, he wished that he had discovered DataCamp sooner. He loves to combine education and data science to develop DataCamp courses. In his spare time, he runs a symphonic orchestra.
See More
Jacob Marquez HeadshotJacob Marquez

Data Scientist at Microsoft

Jacob H. Marquez is an insatiable learner and lifelong builder. He is a data scientist by day, answering audacious questions to support customer experience and company goals. He is a serial hobbyist by day and night: being an educator, building a coffee recommendation app, drinking coffee, writing on Medium, and amateur cycling and muay thai. He has a bachelor's in psychology and a master's in computational analytics (2024).
See More

What do other learners have to say?

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

Create Your Free Account

GoogleLinkedInFacebook

or

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