To forecast future trends, you can use the Excel Forecast Sheet option – it’s the fastest and easiest way to see what’s going to happen in the future based on historical data. It uses the FORECAST.ETS function which, in addition to calculating the trend, can also fill in the missing data or recognize the seasonality of the data, and it also uses the FORECAST.ETS.CONFINT function to calculate the confidence interval. How to make a forecast manually?
Excel has recently made it easier to work with formulas that use arrays and constants – you no longer have to save them by pressing CTRL+SHIFT+ENTER! We can now use lists of values, given in curly brackets, as function arguments. This is great news, and the possibilities are manifold. In the following post, you will be able to see the real application of this feature…
Decomposition Tree is a Power BI visual that allows data analysis according to multiple reporting dimensions. You can view it as a sophisticated drill down tool. It performs data aggregation and gives the possibility of drilldown according to the given dimensions, and it also contains elements of artificial intelligence that help in the analysis and indicate the solution.