Chapter 2. QlikView Dashboard Financial KPIs

There are literally thousands of key performance indicators on http://www.kpilibrary.com. Many are the same, or very similar, formulas with different names, and every business concern's CEO and CFO have their own measure that helps them measure business performance in a way that is meaningful to them.

In this chapter, you will learn about the following concepts:

  • What are key performance indicators (KPIs)?
    • Display sales as a KPI
    • Our first thermometer-type gauge
  • What are the three most common financial KPIs?
    • How to create and display the KPIs: Return on Investment (ROI), Return on Assets (ROA) and Return on Expenses (ROE) in a QlikView dashboard
    • Set expressions
    • Gauge displays
  • How to use QlikView to extend your revenue ratio reporting
    • List Box sheet objects vs charts
  • Common size income statement

What are key performance indicators?

Key performance indicators, also known as KPIs, are measurements used to judge how well your business is doing. They lend themselves well to use in visual displays, such as graphs, thermometers, charts, and gauges used in dashboards. A visual of a KPI in a dashboard should not be complicated, should not require elaborate explanation, nor should it be redundant to the actual numeric information.

Dashboards should display key information in a quick-to-digest format. Often, gauges, dials, and thermometers are used incorrectly, causing confusion rather than clarification. If you want to know more than the recommendations in the dashboard analyses in this book, suggested reading about good dashboard design is Stephen Few's Information Dashboard Design.

If we display the current sales in the current month, we hope that it will show a rising number daily. But just a number by itself might be meaningless to most of us. Are sales going up at a faster rate than average sales, sales during the same period last year, or expected or forecasted sales? A dashboard visual conveys that information without the need for elaborate text explanations. A dashboard visual of a specific KPI should allow the user to follow through to investigate more detailed information.

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

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