Skip to Content
author's profile photo Former Member
Former Member

Dashboard Reporting

Hi Friends,

Can you give me solutions in Dashboard Reporting.

1)What is Dashboard Reporting

2)When we go for Dashboard Reporting

3)What are the Prerequisites for dashboard Reports

4)Any Designing principles for Dashboards

5)Can you tell me Design and Implementation Approach for Dashboards

6)Can you provide step by step document on Dashboard Reports

Regards

Add a comment
10|10000 characters needed characters exceeded

Related questions

5 Answers

  • Posted on May 25, 2009 at 06:03 AM

    Hi,

    Dashboard reporting is one form of designing the report in a better way so that giving a good look and feel for the report.

    Please refer the link for more details

    http://www.sap.com/solutions/sapbusinessobjects/sme/xcelsius/index.epx

    http://www.sap.com/solutions/sapbusinessobjects/sme/xcelsius/demos/index.epx

    Rgds,

    Murali

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 25, 2009 at 06:14 AM

    hi,

    hv a look:

    Blog:

    /people/martin.mouilpadeti/blog/2006/10/22/dashboard-reporting-techniques-in-bi

    Privious Threads:

    dashboard-reporting

    dashboard-reporting

    Designing Dashboard:

    https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/60af3f6c-8501-2c10-57bc-e11d9f6d69b6

    Regards,

    Archana

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 25, 2009 at 08:48 AM

    SAP BI Sales Dashboard

    Dashboards monitor the performance of your business in the same way a dashboard in your car monitors the status of the engine and the caru2019s performance .

    It is hard to take a decision from tabular data which contains endless rows and columns and the solution for this is a Dashboard which gives summarized information at higher level and can be displayed with awesome layout with different colors in the form of bar charts, column charts, pie charts and speedometers.

    Scenario for a Dash Board

    A dashboard supports a manager or executive by doing three things :

    It answers fundamental questions about the business or business unit.

    The dashboard should answer basic business questions: fundamental questions about the health of the

    business that can be financial, operational or comparative in nature.

    It alerts the user to issues or problems in such areas as production, sales and revenue.

    A dashboard should alert the executive or manager when something goes wrong. How an u201Calertu201D is defined is based on the needs of the business.

    It helps make decisions that impact the business.

    Finally, the executive or manager will use the information from a dashboard to make decisions. Sometimes these decisions can be very straightforward and can be answered by a single KPI, but more often business decisions will be complex and require a variety of inputs.

    Heart of Dash Board

    The heart of any dashboard is the KPI. KPIs can measure all sorts of things, such as: Inventory levels, Monthly gross profit, Sales revenue by business unit, by product, by region, Top customers, Accounts receivable, Employee attendance rates and many more.

    We can report these KPIs individually, but by keeping all KPIu2019s in a single page, we are creating single access point to the users to view all information available to them.

    KPIs are most often presented in tables, charts and graphs. Different executives and managers will need different KPIs to support their views of the business.

    Absolutely this will save lot of precious time, gives clarity on decision that needs to be taken and helps the users to understand the KPIu2019s trend with business flow.

    Dashboard Reporting became more popular because of single view on multiple KPIu2019s, these reports are more helpful for managers, business analysts, and corporate decision makers. Now a days Dashboard Reporting has became backbone to management level reporting.

    Data Source for Dash Board

    The data for the KPIu2019s may come from different data sources and from different source systems. The source data will often be kept in a variety of places. Some of these will be operational systems, such as SAP or PeopleSoft, and some will be data warehouses.

    It is important for information architects to understand where the data is coming from, and how it is getting into the dashboard. Data accessibility will have an impact on how the dashboard is designed.

    Types of Dash Board

    Interactive Dashboard Reports (Multidimensional reports)

    Formatted Dashboard Reports (Fixed rows / columns)

    Interactive Dashboard reports allows the user to browse the information as much detail by changing the views and drilldowns and drill across.This report is highly navigation able across different business entities. We can able to change the selection parameters and choose the different variant that you like to view the information required

    Formatted Dashboard Reports are predefined structured reports that have limited navigation. These reports won't allow the users to change predefined default view, helpful for PDF reporting (or) Scorecards

    Technical Process

    Customization

    During the requirements-gathering phase of the project, executives and managers will voice the need for different KPIs. Also, based on their level within the organization, some information may have to be protected from some users.

    Users will also want to customize the dashboard. The dashboardu2019s interface should also allow users to pick which KPIs they see first, as well as set their own alert levels.

    Usersu2019 interests may change over time, and alert levels can change depending on the business environment. Pre-set alert levels should be programmed into the dashboard, if these are known, but unless the business requirements state otherwise, users should be allowed to change these to suit their situations.

    Finally, the more robust portal servers will allow integration of other business systems into the dashboard, such as email, news feeds, and so on.

    *SAP BEx Web Application Designer (WAD)*

    SAP BEx Web Application Designer (WAD), delivered with SAP BW, is used to create Web applications. It generates HTML pages that contain BW-specific content such as tables, charts, or maps. These objects retrieve BW data and place it in a Web application as HTML. In general, setting up a dashboard using Web AD consists of customizing and not programming.

    Create all BEx Queries with required variants tune them perfectly

    Differentiate table queries and graph queries

    Choose the graph type required that meet your requirement

    Draw the layout how the Dashboard page looks like

    Create a web template that has navigational block / selection information

    Keep navigational block fields are common across the measures

    Include the relevant web items into web template

    Deploy the URL/ iView to users through portal/intranet

    Advantages of Dashboard

    Multiple KPIu2019s in single graphical view (scorecard view )

    Communicate information more effectively.

    Gain greater insight into your business data.

    Persuade your audience.

    Drill down /across /jump into info set

    Build a graphical dependency between KPIu2019s

    Trend the KPIu2019s over period of months.

    Share the dashboards through Broadcasting

    Cheers,

    Neel.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 20, 2011 at 01:29 PM

    Hi,

    I am also very interested in this subject, but the reference is very limited. You can share documents as well as experience? Thanks!

    Add a comment
    10|10000 characters needed characters exceeded

    • There is a lot of effort and discussion about 'dashboards'. Quite simply a "dashboard" or "cockpit" is a dynamic report that shows key information to a business user. The concept is modeled after the dashboard or cockpit of a vehicle or aircraft. While there is huge amounts of information available, only the information that is critical to the operator (heading, altitude, speed, fuel state, aircraft status, etc..) is displayed.

      Each business will have their own favorite Key Process Indicators (KPI). Some businesses will prefer graphical displays, some numeric. Each customer's requirements will vary widely.

      Dynamic dashboards (such as those generated by Crystal Dashboard (Xcelcius) and Visual Composer) enable the user to interact with the dashboard by clicking on specific items and then drilling down into other views or more detailed information.

      The keys to dashboard performance are minimal information and high performance infoproviders.

      Learn your customer's needs before designing. Giving an aircraft pilot the dashboard of a farm tractor will produce poor results.

  • author's profile photo Former Member
    Former Member
    Posted on Jun 28, 2011 at 12:51 PM

    Thanks for your post. It's useful for our community.

    Same material can be found at [Graphic designer KPI|http://keyperformanceindicators.info/graphic-designer-kpi/]. I hope it's useful for you and you like it. Please continue sharing more infomation at this topic.

    Best rgs!

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.