Skip to main content

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 Exercises1950 XPData Analyst Track

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. You confirm you are at least 16 years old (13 if you are an authorized Classrooms user).

Loved by learners at thousands of companies


Course Description

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

  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

In the following tracks

Data Analyst

Collaborators

carlrosseel-73112126-9ed2-4866-942a-96fbf265b088Carl Rosseel
Maarten Van den Broeck Headshot

Maarten Van den Broeck

Content Developer at DataCamp

Maarten is an aquatic ecologist and teacher by training and a data scientist by profession. After his career as a Ph.D. 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 Headshot

Jacob 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?

I've used other sites—Coursera, Udacity, things like that—but DataCamp's been the one that I've stuck with.

Devon Edwards Joseph
Lloyds Banking Group

DataCamp is the top resource I recommend for learning data science.

Louis Maiden
Harvard Business School

DataCamp is by far my favorite website to learn from.

Ronald Bowers
Decision Science Analytics, USAA