Time Series Analysis in Power BI
Learn to analyze data over time with this practical course on Time Series Analysis in Power BI. Work with real datasets & practice common techniques.
Start Course for Free5 Hours13 Videos36 Exercises
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.Training 2 or more people?Try DataCamp For Business
Loved by learners at thousands of companies
Course Description
Analyze Time-Series Data With Power BI
You've taken datasets and analyzed them from every possible angle, but did you know that there is one dimension that every analysis shares in common? That's right; it's time! Have you ever thought about how your data varies over time as well?Practice Common Analysis Techniques
In this Time Series Analysis in Power BI course, you will work with two different datasets and practice common techniques to analyze data over time. You will start by analyzing Superstoredata for Point of Sale (PoS) data across various locations and times, where you will calculate changes with different kinds of window, period-to-date, and period-over-period functions.Use Built-In and DAX Algorithms
Then, you will dive into financial data from Microsoft (NASDAQ: MSFT) and see how we can forecast data into the future, using both built-in and DAX algorithms to do so.Following the course, you will have a well-rounded toolkit to tackle time series data and master the fourth dimension.
For Business
Training 2 or more people?
Get your team access to the full DataCamp library, with centralized reporting, assignments, projects and moreIn the following Tracks
Financial Reporting in Power BI
Go To Track- 1
Introduction to time series data
FreeAn introduction to time series data. Learn to identify common patterns and formats of time data, and transform them to meet your needs.
Fundamentals of time series data50 xpIdentifying time series analysis types100 xpTime series variation50 xpAnalyzing birth rates100 xpAnalyzing influenza100 xpBasics of time series data transformation50 xpOrder of operations100 xpTransforming dates50 xpCalculating shipping delays100 xpCalculating receivables delay100 xpAnalyzing promotion effectiveness100 xp - 2
Working with window functions
Learn about and create window functions within Power BI to analyze data over a set period of time.
Window functions in Power BI50 xpIdentifying window functions100 xpAverage population50 xpSegment performance100 xpRolling average sales100 xpRolling total quantity100 xpApplications of window functions50 xpSteps to calculate year over year change100 xpAnalyzing five star reviews50 xpHistorical segment performance100 xpDiscount rate distribution100 xpCustomer ranking100 xp - 3
Looking ahead with forecasting
Learn the basics of forecasting and how to predict values in the future using different methods in Power BI.
Forecasting in Power BI50 xpForecasting order of operations100 xpForecasting types of energy consumption50 xpSetting forecast expectations100 xpForecasting MSFT close price100 xpHindcasting MSFT close price100 xpForecasting in Power BI: DAX50 xpWhen to use CAGR100 xpForecasting types of energy consumption - DAX50 xpCreating forecasting variables100 xpForecasting with CAGR100 xpForecasting with CMGR100 xpCourse wrap-up50 xp
For Business
Training 2 or more people?
Get your team access to the full DataCamp library, with centralized reporting, assignments, projects and moreIn the following Tracks
Financial Reporting in Power BI
Go To TrackCollaborators
Kevin Barlow
See More
Data Professional
Kevin has over a decade of experience working with data in various applications. He is passionate about helping people and companies find insights from their data and hopes to teach you some of the strategies and techniques he has learned throughout his career.
What do other learners have to say?
Join over 13 million learners and start Time Series 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.