Chapter 8. Garnish with Reference Lines, Trends, Forecasting, and Clustering

In this chapter, we will cover:

  • Understanding how to create and use trend lines
  • Understanding and using the forecasting functionality
  • Understanding and using reference lines - bullet chart
  • Understanding how to perform clustering

Introduction

There are often circumstances when we need to show some benchmarks and then compare actual performance against those benchmarks. We may also be required to find out the trend of our business to understand whether the underlying market conditions are working in our favor or not. Further, looking at the historic performance, we may also be required to do some forecasting in order to decide on future targets. Keeping these points in minds, we will focus on some specific analytics in terms of computing and understanding the trends in our data; using the built-in forecasting model to compute a forecast from our data; and, lastly, understanding how we can benchmark our data against thresholds using reference lines.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
3.139.67.5