Analyze Time-Series Data With Power BIYou'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 TechniquesIn 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 AlgorithmsThen, 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.
Introduction to time series dataFree
An 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
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
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
In the following tracksFinancial Reporting in Power BI