Skip to main content

A Sales Dashboard with Pentaho CTools

Managers and other decision makers in sales need information in a highly aggregated form so that they can make the right decisions. A sales dashboard displays sales and customer data in a brief, but comprehensive form, so that changes can be quickly detected (e.g. for closing rates). To achieve this, however, the data must be processed and arranged in a sensible way.

In this white paper, we will describe how to build a professional and easy-to-understand dashboard for a company sales department drawing on SAP data. In the process, we will be relying on several open source technologies. For staging, ETL (Extract - Transform - Load) and data warehousing, we will be using the Pentaho business intelligence suite. CTools (Community Tools) are open source extensions from Pentaho designed to simplify the creation of data visualizations.

A Sales Dashboard with Pentaho CTools


1    Introduction

2    The Sales Dashboard

    2.1    Pentaho CTools

        2.1.1    CTools Community Dashboard Editor

        2.1.2    CDA Community Data Access

        2.1.3    CCC Community Chart Components

3    The Data: SAP IDES

4    Dashboard best practices

    4.1    Always use complete and consistent, high-quality data

    4.2    Only display required key performance indicators (KPIs)

    4.3    Graphs and charts are the dashboard‘s main components

    4.4    Don't overtax your screen real estate

    4.5    High information density

    4.6    Simple presentation of diagrams

    4.7    Making comparisons

    4.8    Use a unified design concept

    4.9    Rules for diagrams

    4.10  Rules for text and tables

5    Implementing the sales dashboard

    5.1    Building the dashboard

    5.2    Performance

    5.3    Order volume by sales organization

    5.4    Order volume by division

    5.5    Order volume by sales channel

    5.6    Customer KPIs

    5.7    Market share for sales organizations

6    Conclusion

Download Whitepaper