· 

Create simple Excel Dashboards

You want to use the data which is provided by the Business Warehouse in your monthly report or any other report. The SAP Reporting tools like BEx Analyzer or Analysis for Office provides this data in "data tables". These are not easy to read and maybe it isn't possible to see at first glance what you want to express.

SAP Analysis for Office: BEx Analyzer result
SAP BEx Analyzer result

To make this a little presentable, you build your own reports with VLOOKUP or other Excel formulas. The result is usually like the following:

SAP Analysis for Office: BEx Analyzer result formatted
SAP BEx Analyzer result formatted

Now this often fits into the corporate identity (CI) of the company. But it is often difficult to understand and contains also a lot of redundant information. The following dashboard is inspired by the HICHERT guidelines. This is still not perfect, but it shows what is possible.

SAP Analysis for Office Simple Dashboard with Excel components
Simple Dashboard with Excel components

Here another example of a diagram what not really says a lot.

Ugly Excel chart with no statement
Ugly Excel chart with no statement

In contrast, you can see on the following picture immediately, as the sales of each product group for the current month developed. In the team view you can see an overview over your profit margin.

SAP Analysis for Office: Simple overview in Excel with a table and indicators
Simple overview in Excel with a table and indicators

Such simple dashboards are quickly created in Excel, unfortunately hardly anyone takes time for it. These examples were created in Excel 2010. With Excel 2013 you have more opportunities to present data.

author.


I am Tobias, I write this blog since 2014, you can find me on twitter and youtube. If you want you can leave me a paypal coffee donation. You can also contact me directly if you want.

SAP Analysis for Office - The Comprehensive Guide
The book SAP Analysis for Office - The Comprehensive Guide by Tobias Meyer is a pdf book about SAP Analysis for Office. It is based on Analysis for Office 2.8 and contains 346 Pages.
45,00 €
SAP Analysis for Office - The Comprehensive Guide
SAP Analysis for Office - The Comprehensive Guide is a pdf book about SAP BusinessObjects Analysis for Office. It is based on Analysis for Office 2.7 and contains 299 Pages.
37,00 €
SAP Analysis for Office - The Comprehensive Guide
SAP Analysis for Office - The Comprehensive Guide is a pdf book about SAP BusinessObjects Analysis for Office. It is based on Analysis for Office 2.6 and contains 272 Pages.
27,00 €

Write a comment

Comments: 0