 Speaking with some finance folks, I mentioned the reason why they've not adopted Power BI if they are reporting. Some of them is thinking there's something in finance related calculations that they can't achieve in Power BI. And looking at some of those, I mentioned focusing as one of them. In Excel, it's pretty much straightforward, pretty much easy to do focusing. When you have your data modelled correctly, your calculations are running correctly. That's pretty much direct to achieve. But in Power BI, they've tried to exploit different same options where they would be able to forecast their data into the future. But before we go into that, for some of those that might be watching this video and we are not from a finance background or related studies, forecasting simply implies that we are trying to use our data to look at the future. We are looking into the future to say what is possible in the future. We might have sales. We have sales data running from probably January of the year till July of the year. So, presuming at the moment when July. But looking at that, we want to use our reporting tool to tell us what's possible from July down to December, what is the likely pattern we would observe in our sales. That is what forecasting is about. Forecasting is a way of learning from what pattern already exists within the data and using that to predict, sort of predict what will happen in the future. So, when we come to reporting, one is before you can forecast, you must have some amount of data that has some data attribute. So, if you have data and the data is not tied to any data attribute, obviously, you cannot do it forecast. So, you need to ensure that you have data and the data is tied to some dates. So now, this is Power BI and one of the things we know is that when we want to visualize time-based reports, we need to use a specific chart. You don't just jump into this. You want to visualize something that's related to date and then you select a pie chart. A pie chart will work for that. Or you select something like a map. It doesn't study. So, you want to ensure that you're picking the right visual. One of the visuals that are pretty excellent for visualizing time-based report or doing time-based reporting is your line chart. So, I have a place order for your line chart here already. So, just go onto populist days. I have it clicked on. So, I would have select my year and I will select my revenue. So, I'm visualizing my revenue by year. So, in 2013, we made this amount of revenue in 2014. 2015, that's what we made. And 2016, that's what we made. So, this is typically four years of data. What if we want to now project into the future to say, how much is it possible that we begin to make after 2016? So, what we would do is you have your chart selected like this. Ordinaryly, on your visualization screen, you see that depending on the chart that you have selected, you would say this button here, that's for visuals generally, then you say a format your visual icon. But because this is a line chart and some other related chart, you get to say this third one, which says add folder analysis to your visual. So, I would select that. And now from here, there are a lot of options, excellent options that we can bring in from here. Statistic related options. But the core of this video is not to look at the entire option. So, I just want to focus on the focus bit. And the focus, you see, we have a group for focus right at the bottom. It is turned off by default. So, before you use the first thing you want to do is to turn it on. So, I'm going to turn that on. But still nothing has been seen here. So, I would expand it. So, once I expand on this, you see that some now I have a sort of a projection, a different outlining out of my line chart. So, my line chart, the actual values are blue line and then there is something different going just off with some shadows around it. That is the focus side. And if you look at this chart very well, we'll notice that our data stopped on 2016. That is the actual. So, we now have data for 2016 to 2026. So, that's 10 years of focus already. And what it's saying is, by interpretation, is that what is expected is that our revenue should continue to grow in this pattern. And this has only been learned from what we have in the actual data. And the second thing to note, if I stay on 2018, for instance, you will see that we have the upper bound and the lower bound. The forecast is the actual line in between. But what it's saying is there is every tendency that our revenue figure would resonate between the two bounds. So, it's either it is higher than the forecast value itself, or it's lower than the forecast value. But it's projected that it's going to be within the shaded area that we can see. Sometimes you don't want to have 10 years of focus. 10 years of focus might just be too much of a prediction to make. But especially when you don't have enough data to fit into that and you're not running machine learning models. So, you may sort of want to reduce the number of years. And in a way that might tell on the accuracy of what you're looking at as well. So, the way to manage that under your focus group, you come here to where you have the focus length. So, it says 10. So, if I want to reduce this to 5 years, I'll just put a 5 here. And I'll come to this button and say apply. So, when I say apply, it reduces my forecast to 5 years of focus. And we'll say that we have less data to look at and then we have more space to look at on our line chart. A couple of other things you may want to do to say that, yeah, we have a confidence interval. This is some pretty much a statistical thing. Probably we have some videos that will address some statistical thing that we have on the analysis. But the confidence interval, the confidence level, they all are somewhat around. How confident are we? What level of confidence have we deployed in this our forecast? So, 95% confidence, 99%, 97% what level of confidence is feeding to this and what what does that imply? So, maybe we have something to talk to that in some of our next surveys. But you want to do some formatting on the forecast line, most especially because you are bearing in mind your users. You don't want them to presume that this line is continuous and this still talks about the actual amount you have made in the business. No, you don't want to confuse them. So, one of what is recommended is that your forecast is not actual. So, you want to make it dotted line. And this is from the standard as well. So, I come here to the style and then I just make it maybe a dashed line. So, it's not continuous. Yes, something like this. This is pretty much different from what we've seen from the actual lines. Actual line is continuous, solid. But some of the forecast is not solid and it's not continuous. You may also want to make it a bit more transparent or depending. So, you want to make it lighter or however just to ensure that people, your report users, they are not confused as to what they are saying. So, pretty much simple, pretty much direct how to build forecast into our Pavia report line chart specifically. Thanks a lot. I hope you found this helpful. Let's stay tuned for our next please.