ADVANCED POWER BI FEATURES FOR TRAINING: TIME SERIES
In the previous tutorials, we went through the basic features of Power Bi, like formatting and labeling. This tutorial will guide you through using some of the advanced features of Power Bi, like working with Time Series.
Before we understand what Time Series means, we need some data to work with. Visit the link given below:
Navigate to the section called – Timeseries, Aggregation, and Filters and click on the link to download the excel file containing some data.
Open the excel file to observe the kind of data it contains. Notice that the structure of data is such that it is difficult to study it. The data structure is quite unusual here. It is because computers can process only this type of data structure.
You must have guessed the next step. It’s time to import this excel file into Power Bi. You already know how to do that.
After loading the data to Power Bi, go through it once again.
HOW IS DATA AGGREGATED IN POWER BI
Select the Period and Unemployed tabs in the Fields section and create a Line chart. While studying the line chart, you will notice that the number of employed people of all age groups and gender aggregates into one entity. So now, the number of unemployed people is not being classified further. It is how data aggregation takes place in Power Bi.
HOW TO DEAL WITH TIME SERIES IN POWER BI
Before we understand the ways to deal with time series, we must know the reason behind dealing with time series. In the above line chart, notice that the x-axis represents the year. What if we change it to month or day? That way, we will be able to understand our data better.
Go to the Visualizations section and notice that the Axis contains some levels where each level represents time. How do we switch between these levels? Do not worry. Navigate to the Data/ Drill menu, and click on the Show Next Level button. This is how your line chart will look after that.
The level has changed from Year to Quarter. But a crucial thing to note here is that we are dealing with the total number of unemployed people. It does not give us a specific pattern. So what do we do now? We need to look at the average number of unemployed people per year or per quarter. How do we do that? In the Visualizations section, go to the drop-down menu under Values and select Average. Now you will notice that the line chart is much more informative and has a pattern.
Is there any way to make our report more informative? We are now going to divide the year level into quarters. Click on the Drill Up button to restore our chart. So, restore the Values to sum.
Click on the Expand Next Level button. Each year is now divided into four quarters, making the chart more informative.
If you keep expanding the levels, the number of points on the x-axis will keep increasing.
So, this is how we deal with time series in Power Bi. In the next tutorial, we will learn about some more advanced features of Power Bi for Training purpose.