Dashboards by Example
    Business dashboard users, data visualization experts, IT teams, & executive management - Welcome to Volume 1 of Dashboards By Example!   Please send in your dashboards!

For more Business Intelligence Dashboard Examples, use this link to the Dashboard Spy sitemap: Dashboard

Archive for December, 2006

This is an archive of the unique and controversial resource on Enterprise Dashboards known as The Dashboard Spy blog on Enterprise Dashboards. This is Volume 1 of the dashboard screenshot collection where you will find 837 dashboard screenshots of various dashboard implementations. Included in this collection are executive dashboards, enterprise dashboards, performance dashboards, corporate dashboards, balanced scorecards, BI dashboards, business intelligence dashboard - the list goes on. What is the difference between all those terms? That's part of the fun! Start studying these screenshots and learn.

Here is an interesting way to find more enterprise dashboards to study: Click this link for a random dashboard. You'll never know what dashboard you'll see next.

Task Control Dashboard - using enterprise dashboards for running and monitoring IT tasks

Sunday, December 31st, 2006

Business Intelligence Dashboard Post.  Ready for an interesting dashboard to study? Let’s look at this IT dashboard.

Monitoring an automated task control management system is best done using a dashboard style interface. When you have lots of information to present and the need to allow for many possible drilldowns to detail levels, it’s hard not to use the dashboard approach. This enterprise dashboard allows the set up, execution and monitoring of IT related tasks such as scripts, batch jobs, database queries, etc. The tasks can be grouped according to system functions or business processes. The dashboard is a nice mix of machine level information such as utilization levels and business functions such as the business process flow diagram.

Task Control Dashboard

Note: Hey, Dashboard Spies!: Do you know how smart you are getting by reading The Dashboard Spy? From pig production to airplane crew size optimization to monitoring presidential campaigns, we’ve examined enterprise dashboards from all aspects of business. I’ll do my share to keep snooping around for those elusive dashboard screenshots that keep this dashboard screenshot collection interesting.

So what or who is The Dashboard Spy? As his about page states, The Dashboard Spy is just a guy interested in the design of enterprise dashboards. He could not find any executive dashboard design source books (or even screenshots of real business dashboards) and so set about creating his own. Finally convinced to post his extensive collection of dashboard screenshots online, he was amazed to find how popular it has become. If you have a nice screenshot of a digital dashboard, balanced scorecard, or any business intelligence graphic to share, please send an email to info _at_ dashboardspy.com. Also check out The Dashboard Spy’s favorite books on business dashboards.

PS: If you find yourself part of an enterprise dashboard effort, you must study Enterprise Dashboards: Design and Best Practices for IT, the only book on actually implementing enterprise dashboards.


ERP Dashboard for Sales - enterprise dashboards as front ends for ERP systems

Sunday, December 31st, 2006


Business Intelligence Dashboard study: Here is today’s performance dashboard to study. Look for best practice ideas to emulate.

We all know that ERP packages are quite ambitious. Basically they contain the entire data model for the company. The weak points have been the tremendous effort it takes to match the data model with the business processes (some companies find it easier to change their processes to match the package’s data models!) and the front ends. As of late, dashboards have become the favorite way for users to access their ERP data.

This sample sales dashboard comes from the Enterprise 21 ERP software package. The idea is that all the data captured by the ERP package can be translated into these types of charts. Each user can configure charts and set up their pages to contain the charts they want. Here we see a sales dashboard view with KPI metrics such as sales, gross margins, and product comparisons. The technology looks a little dated (client/server app, clunky graphics), but I bet the users still love it.

Sales Dashboard ERP Package

Homework: If you are on an enterprise dashboard project, do yourself a favor and take a look at Enterprise Dashboards: Design and Best Practices for IT, the only book on actually implementing enterprise dashboards.

So what or who is The Dashboard Spy? As his about page states, The Dashboard Spy is just a guy interested in the design of enterprise dashboards. He could not find any executive dashboard design source books (or even screenshots of real business dashboards) and so set about creating his own. Finally convinced to post his extensive collection of dashboard screenshots online, he was amazed to find how popular it has become. If you have a nice screenshot of a digital dashboard, balanced scorecard, or any business intelligence graphic to share, please send an email to info _at_ dashboardspy.com. Also check out The Dashboard Spy’s favorite books on business dashboards.

Oracle Business Intelligence Dashboard Screenshots

Wednesday, December 20th, 2006

Scoring a 3.7 in the 2005 Meta Group ranking of Enterprise Dashboard vendors is Oracle. Since the report was issued, much as gone on in the world of Oracle and its plans for business intelligence dashboards. First, let’s take a look at an excerpt from the Meta Group report. Back then, it focused on Oracle Reports Dashboards:

Oracle Reports 9.0.4

Oracle Reports is a strong product for Oracle database reporting requirements. However, it is rarely considered for reporting needs beyond an Oracle environment. This is reflected in the low scores for presence and connectivity.

Strengths

• Strong Excel support with a common add-in used between Oracle Reports and Discoverer
• Check in/check out and versioning support for multiple developers provided with Oracle SCM
• Reasonable pricing and flexible in negotiations

Limitations

• Connectivity to heterogeneous sources requires DBA setup of database connectors
• No access to non-relational legacy data sources
• Scheduling of reports based on periodicity and events requires custom coding
• No out-of-the-box security integration with non-Oracle solutions

Its been a busy time since that report for Oracle in terms of Enterprise Dashboards and Business Intelligence. They have acquired companies and released new versions of enterprise BI software. As often the case when a company is assembling its product line for a new market, the message sometimes is not clear. Such was the case at the 2006 ODTUG (Oracle Users Group) conference. As reported by the AMIS blog (sorry for stealing so much content, but, hey, this is the Dashboard Spy!)

Oracle BI Strategy

A fascinating topic this year: Oracle’s BI Strategy. For many years - probably since the launch of the Oracle 9iR2 database with embedded OLAP (multi dimensional workspaces) and DataMining engine as well as a rich set of ETL and BI supporting enhancements in the SQL engine - the theme for Oracle in BI has been: do as much in the database as possible. And a lot can be done in the database, especially the hard work, leaving little more than the presentation and handling of user interaction to the client tools, like Discoverer OLAP and BI Beans. With the release of the Discoverer Drake release last year and OWB 10gR2 this year as well as a set of new features for BI applications in the 10gR2 release of the RDBMS, the technology stack seemed pretty much in place. And then… there was Siebel.

Siebel has something Oracle never really achieved: a notable presence in the BI arena at enterprise level. The Siebel Analytics product with pre-built ETL processes and Multidimensional Cubes for standard ERP  and CRM applications like SAP, Oracle Applications, Siebel and JDEdwards has a real presence in the board rooms when it comes to BI, whereas Oracle’s products on the whole seem to be more technology driven and slightly less business focused. With the exceptions of OFA, OSA and EPB &B (Enterprise Planning and Budgeting).

In Sunday’s general session, we were given an overview of the BI strategy. Frankly, it was not clear at all. And in hindsight, it was a strange combination of the Siebel approach: business oriented, database independent and the ‘traditional’  Oracle approach with strong emphasis on the database and web-enabled technology. This presentation started with Siebel Analytics - now Oracle BI Server - in the board room and concluded with Mark Rittman’s demonstration of the Data Quality option in Oracle Warehouse Builder. Covering an enormous territory and never quite bridging the gap.

On Monday I sat in on the BI Strategy session by Christina Kolotouros, who seemed not at ease with the story she was telling. Apparently, a lot of changes are being made in this period and the dust has not yet fully settled. Christina’s introduced the BI Suite Editions- Standard Edition One, Standard Edition and Enterprise Edition, with a clear split between traditional Oracle BI technology and the Siebel based stacks - and tried to demonstrate a unified approach to Business Intelligence. Oracle BI Server - pka Siebel Analytics Server - is a middle tier product, written in C++, that can be approached through ODBC. It knows how to extract data from various heterogeneous data services and sources, of which the Oracle database is but one. And historically, as I am being told, not even the primary one since Siebel had better and earlier support for specific features in SQL Server and DB2. Yet Christin’a story was that the BI Server ‘uniquely leverages the Oracle database’. It probably will eventually, but whether is actually does that today is somewhat hard to believe. She did not elaborate on this unique support, so it remains very uncertain whether the BI Server at this point leverages the OLAP engine or the Data Mining functionality of the Oracle RDBMS. And whether it has specific understanding of Analytical SQL Functions, Materialized Views, In-Line queries and the likes. It may and if not it will. The presentation did not make it clear, which may be an indication in its own right.

Christina presented the release-plans for the BI Suite, with a 10.1.2.2 release followed by 11g for the Standard Edition - remember that’s Discoverer and associated technology - without giving specific dates. She made it clear that while Discoverer will be further enhanced, no major new functionality - especially if it would impact the tool’s architecture. Again, this sounds a lot like the predicament of Oracle Forms.

The report goes on, but I’ll leave it to you to check the source. Here are a smattering of different enterprise dashboards from Oracle. If you have more examples of oracle-related business dashboards, please send them to The Dashboard Spy. Thanks.

Oracle BI Server Architecture

Oracle Reports Dashboard

Screenshot of Oracle Portlet Configuration

Screenshot Oracle Dashboard

 

The Dashboard Spy Business Intelligence Dashboards Blog

Microsoft Enterprise Dashboard Screenshots

Tuesday, December 19th, 2006

Dashboard Topic:

Microsoft Dashboard

Continuing on our whirlwind tour of the enterprise dashboard vendors covered in the Meta Group study of enteprise reporting and dashboard vendors, we get to Microsoft. One note concerning the Microsoft business intelligence offerings. As you know, Microsoft has agressively moved into this space via the repositioning of their current products, introduction of new BI platforms and products, and the acquisiton of other products in this space. As a result, it can be somewhat confusing figuring out exactly what product to look at when considering Microsoft for an enterprise dashboard project. From the new Excel 2007 which has nifty features right out of the box perfect for executive dashboard visualization to the new Sharepoint 2007 to the behind-the-scenes ability of SQL Server, there are many options to consider.

BTW, for an interesting read on Microsoft’s move into BI, take a look at this article.

Here is a map of the Microsoft BI solution stack. I found it at the great BI blog, Bidirectional.

Microsoft enterprise dashboard solutions

In this Microsoft Business Intelligence technology stack, we have:

  • Business Scorecard Manager (BSM)
  • Microsoft SharePoint Portal Products & Technologies
  • Microsoft Excel
  • QL Server Integration Services (SSIS)
  • SQL Server Analysis Services (SSAS)
  • SQL Server Reporting Services (SSRS)
  • SQL Server Relational Database Management System (SSRDBMS)

Now, given the above, let’s get back to looking at the Meta Group’s assessment. In that study, Microsoft achieved a rating of 4.1 which tied them with SAS for fifth place. Note that in the 2005 study, Meta focused on Microsoft’s SQL Server Reporting Services (SSRS):

Microsoft Reporting Services 1.0 SP2

Microsoft Reporting Services is a new entrant to the enterprise reporting and dashboards market space. Reporting Services is not sold as a separate product. Rather, it is bundled with the SQL/Server database product. This has resulted in Reporting Services being widely distributed in a short period of time, though the actual of use of the product is not known. The integration of Reporting Services with Visual Studio offers developers a familiar environment for development. However, Reporting Services lacks native data connectivity to most other applications (e.g. typically ODBC or OLE DB connectivity support). In addition, despite market awareness and attractive price point, we have not seen many large enterprises standardize on
it for enterprise reporting.

Strengths

• Connecting to Oracle natively supported out of the box
• All reports available as a Web services
• Best-in-class usability
• Above-average score in pricing; Microsoft offers one of lowest-cost enterprise reporting solutions

Limitations

• Minimal (formatting and limited formulas support) integration with Excel
• No support of non-relational legacy data sources
• No support of heterogeneous joins
• No support for sharing of parameters across a series of reports or reuse of parameters

 

The Microsoft Dashboard screenshots shown here will be a mix of various Microsoft BI products. Please excuse the uncategorized nature of these selections, but you can search the rest of this blog for particular types of Microsoft enterprise dashboards.

MS Office 2007 Enterprise Dashboard

Microsoft business scorecard

Excel dashboard

Sharepoint Enteprise Dashboard

Tags: Microsoft Dashboard

Another post on a Microsoft Dashboard

 

The Dashboard Spy Business Intelligence Dashboards Blog

SAS Enterprise Dashboard Screenshots

Monday, December 18th, 2006

Enterprise Dashboard vendor, SAS, scored a 4.1 in the 2005 Meta Group Enterprise Reporting and Dashboard Assessment that we’ve been detailed these past few posts. The 4.1 score ties SAS with Microsoft, and put them in a tie for fifth place. See the original post, Meta Group Rating of Vendors for Enterprise Reporting and Enterprise Dashboards, for the source study download.

In the study, Meta had this to say about SAS:

SAS WebReportStudio (Part of BI Server Version 9.1 Product)

SAS WebReportStudio is an effective enterprise reporting and dashboard product that is delivered as part of the BI Server product. WebReportStudio is not sold as a separate product. With the release of SAS 9, WebReportStudio has improved. In addition to very strong data connectivity, SAS can embed and reuse analytical stored processes.

Strengths

• Best-in-class connectivity with out-of-the-box support for more than 70 data sources
• WYSIWYG report design environment that renders real data in design mode
• Strong support of multiple languages and international requirements
• Good support of Excel with add-in component

Limitations

• Low presence and scalability and performance scores due to WebReportStudio being a relatively new product
• No support for cascading parameters, though scheduled to be addressed during 2005
• No support of content caching, though this is expected to be supported during 2005
• Pricing limited to per CPU and enterprise options and is based on a subscription model

Before we look at a sampling of some SAS dashboards, let me point out the great resource that SAS has in Dr. Robert Allison. He’s produced some wonderful, award-winning enterprise dashboards using SAS technology. Also, he has been willing to share SAS code, for example, here’s how to emulate Excel-style graphs using SAS as we see in this screenshot:

SAS code to generate excel graphs

Here are some enterprise dashboards done using SAS. Feel free to submit more and I’ll update this post to include them:

SAS webreportstudio

SAS sales dashboard graph

The Dashboard Spy Business Intelligence Dashboards Blog

Enterprise Dashboards - Buy versus Build

Friday, December 15th, 2006

Enterprise Dashboards” - the term for many of you do NOT make you think of packaged software, but of custom-built applications. Some of you have written to me about the current extremely long series of posts on The Dashboard Spy that is basically a survey of enterprise reporting and dashboard vendor products as reviewed by the Meta Group. Basically you want me to get back to featuring enterprise dashboards as built by IT departments without all these fancy (and expensive, you claim) packages.

The screenshots of your custom-built enterprise dashboard applications are piling up, and I do promise to get back to featuring them. My heart is on the custom-build side, I must admit, but it behooves us to see what the package vendors are offerring in terms of enterprise dashboard software. They do have the edge when it comes to quick deployment (especially against the average corporate IT department thinking about BI dashboards for the first time).

A couple of years ago, a vendor released a “Dashboard buy vs build” whitepaper with some great points. I’ll post this longish (but well worth reading) excerpt here:

Numerous tradeoffs exist in making this decision. Keeping in mind that we are characterizing this decision as “build all of it yourself” vs. “buy some from a third party, and build the rest”, we will examine each of the following tradeoffs :

1) The Cost of Development Resources
2) Total Time for Implementation
3) Quality of the Resulting Solution
4) Performance of the Resulting Solution
5) Protection of Investment for the Future
1) The Cost of Development Resources

It would be overly simplistic to say that the cost of the third party product is to be weighed against the cost of the personnel that would be deployed to develop the equivalent solution. Sometimes the costs may appear to be similar, but there are a number of other important considerations:

Build:

IT employees assigned to develop an enterprise infrastructure monitoring system from scratch are starting at “square one.” Developing even the simplest of graphical interfaces for the front end often requires research and development of new skills. These employees may be very good at what they currently do, but they are probably not familiar with all the issues associated with building a sophisticated monitoring system. They may be able to do it eventually, but there is inefficiency inherent in this approach. The total cost in this situation is not only in the employees’ time, but also the training in lower-level development skills that would not be necessary if they were building atop a
product.

Sometimes, especially during slow economic times, a company will attribute a lower cost to deployment of their own employees on an internal development project. Rationalizing that they are “already paying them”, the company assumes that the cost is zero. However, even in slow times, it is rare to find a situation where these employees are truly “doing nothing.” If their efforts are applied to the development of a new monitoring system there is certainly a cost associated with it.

The total cost of building the solution involves not only the employees’ time, but also the intangible cost of the inefficiency of using developers without the necessary skills on such a project.

Buy:

Of course, there is a cost associated with purchasing a third party product and learning to use it. There is also a cost associated with the accompanying higher-level development, although it is likely to be far less than that of developing the entire system.

Employees assigned to working with a product will be starting at a much higher level since many of the components necessary for the solution are already in place. With proper training, in a short amount of time they are typically able to produce powerful and effective solutions for the monitoring problems. In addition, the expertise of these employees will be used more effectively as it is applied at a higher level directly to the problems that the monitoring system must solve. They have the
knowledge to effectively make use of a product.

2) Total Time for Implementation

It is obvious that the implementation of a monitoring system built on top of a solid foundation
will take much less time than one built from scratch. However, there are other, even more important, aspects to consider about the development schedule:

Build:

Since an internal do-it-yourself development project begins at square one, it can often
take several months before even the simplest features become available. At that point,
the real work begins, as more complex features can take many months to develop.
Even after a year, the system may have no more capability than what would have been
obtained out of the box using a product.

Developers, even good ones, are notorious for underestimating the time that it will take
to implement a new project, particularly in an area with which they are not so familiar.

This is due not to a shortcoming in their programming skills, but rather a failure to
anticipate the degree to which unexpected problems and surprises will delay their
efforts. It can often take days or weeks to finally uncover why that one object causes
the Netscape browser to crash, for example. Such unexpected problems can result in
huge delays in the project.

Often, the people called on to work on internal development projects are some of the
best developers in the group. While this may seem like a good thing, the fact that they
are so good means that others in the group will constantly be calling on them for help in
resolving some emergency situation that arises. While these developers may be officially
tasked on the new project, the fact is they will undoubtedly be interrupted many times,
sometimes for lengthy periods, as duty calls. This is another situation that can wreak
havoc on the schedule for development of the monitoring system.

All the while this development is going on and delays are mounting, there continue to be
application process failures and bottlenecks causing untold cost to the organization, as
the old way of doing things is perpetuated and reinforced.

Buy:

Typically, within one month of installation, there can be seen an immediate and
measurable benefit to the company in using a package product. Since the product is fully tested and has been deployed in many different environments, it is likely that smooth installation will be followed by a period of rapid progress in development of useful monitoring displays and applications.

By starting with a highly advanced base of features, including a graphics display builder, built-in data access methods, and a powerful and flexible historian, developers take far less time to produce effective systems. Even with the inevitable day to day interruptions, they are able to construct and deploy applications quickly and easily.

Surprises are minimized, as most common issues have already been addressed by the vendor, given its long experience in building such systems.

As the IT department becomes more adept at using the product, the solutions produced
become even more effective and useful. Developers are spending their time advancing
the solution they built in the early stages, far outpacing the benefits that might come from
developing it oneself.

Instead of taking a year to re-invent functionality that already exists in the products, the IT group is quickly producing advanced solutions based on a proven solid foundation. This is a result that is vastly more valuable to the organization. Significant benefits in reduction of downtime and improvement in overall system performance are seen in a very short time.

3) Quality of the Resulting Solution

The quality of the solution produced solely by internal development can be reasonably good.
However, there are some important issues to consider:

Build:

The fact is that internal developers will probably be “reinventing the wheel” by developing a basic application monitoring capability from scratch. As part of the project, it will be necessary to develop a basic foundation for managing multiple dynamic graphics displays, handling the interface to data variables to drive these displays, and important ancillary functions, like historical data archival and retrieval.

While none of these things are terribly complicated on the surface, it is common knowledge that the first implementation of anything is nowhere near as good as the second and third time you do the same thing. Thus, the implementation made by internal developers is not likely to be as good as one developed by a third party with a great deal of experience in the area and multiple revisions of its product.

Additionally, some of the best features in a product  come about through repeated exposure to many different customer use cases. This exposure can only occur over a long period of time. It is unlikely that within a single company environment, there will be enough exposure and development
response to result in a feature set nearly as rich as that provided by a vendor.

Buy:

A solution produced using packaged software as a foundation is likely to be much higher quality by many measures.

Typical vendors have experience building high performance graphical systems for monitoring and control of sophisticated applications. During this time, techniques have been developed and honed over many revisions of the product to manage large numbers of graphics objects and data references, to filter data in various ways, and to perform functions on raw data. Exposure to many different types of problems has resulted in a very rich feature set, designed to graphically visualize data in many different ways.

4) Performance of the Resulting Solution

While the internal IT group may be capable of developing a reasonably good process monitoring application, there are a number of areas related to performance of the resulting application that need to be considered:

Build:

Typically, an internal build-it-yourself development project starts out simple. In the zeal to demonstrate something working, a quick implementation is often made, using the most obvious data structures. String compares are often done to find named objects, large tables of data are retained in memory to simplify coding, object replication is ignored, and memory leakage and growth is not considered a problem in the early stages.

It is only after the system starts to be used on a larger scale that significant performance issues emerge. At this point, so much code may have been written using the simpler data structures that it becomes impossible to change without significant effort. Ugly patches and workarounds get applied, which ultimately do not work very well and result in a maintenance nightmare.

The result seen in most cases is a system that performs slowly, gobbles up memory, and often crashes. In time, it becomes very difficult to add new features. Overall, the monitoring system itself becomes a burden and may never actually be used.

Many man months can be spent correcting the results of designs that were well intended, often by very good programmers. Usually, these people have a great deal of expertise in specific business domains, but are asked to develop applications where they do not have the experience. Costs grow rapidly in correcting problems introduced by this approach.

Buy:

In contrast, a solution built on top of a robust package is likely to perform significantly better.
The algorithms and data structures used in the applications have been improved over many versions of the product. They have been specifically designed to manage large numbers of objects and data variables and are optimized to provide best possible performance. Memory usage has been extensively analyzed to avoid leakage and minimize consumption.

What all this means for the IT department is that little or no time needs to be spent reworking code in order to achieve good performance. It can be assumed that the best possible performance is already available by building on top of the existing system.

5) Protection of Investment for the Future

Every few years, there occurs some significant change in the computing environment. This is one of the issues most overlooked when considering how to develop an internal application process monitoring system.

Build:

The internal development group is often consumed by the demands placed on it for designing and implementing the monitoring system in the first place. It is typically not an area of expertise, so there is a need to do research and develop new skills. Usually, it takes all available resources to come up with a reasonably good solution matching the current requirements.

In this process, it is highly unlikely that much thought will be given to planning for ways to build the system so that it can be ported to the next generation computing environment which may emerge a few years from now. That next generation always seems so far off … yet in reality it is often much closer than one thinks. If this issue is not addressed up front, it is likely that in a few years all the work that was done to internally develop a useful monitoring system will have to be thrown away and a new project started from scratch. We see this all the time.

Buy:

While this issue may not seem terribly important right now, many years of experience reveals this to be one of the most costly overlooked issues of all, when you think for the longer term. Protecting your investment against obsolescence must be a priority.

 

The Dashboard Spy Business Intelligence Dashboards Blog

Enterprise Dashboard Cosmetics

Tuesday, December 12th, 2006

On this blog, we focus on the value that the “cosmetic” elements can give to business intelligence dashboards. I’ll probably get into big trouble for this post, but a long-time reader of The Dashboard Spy sent me this graphic and I just have to show it to you.

As the submitter explains:

Hello Dashboard Spy, I have submitted a few sas/graph dashboards in the past. But this one is not like my previous dashboard screenshots, and it is just for “fun” (and please keep my name anonymous ;)  Hopefully it won’t offend the women-drivers too much (use your own discretion about how much trouble posting it on your site will bring you! :) I guess the story-line could go something like this…

“A lot of people complained that my dashboards looked too ‘plain’, and I should concentrate on the ‘cosmetics’
of my dashboards more.  So, here you go - the cosmetic dashboard…”   ;) Just thought you might enjoy it! …

 

Dashboard Cosmetics

The Dashboard Spy Business Intelligence Dashboards Blog

Hyperion Enterprise Dashboard Screenshots

Tuesday, December 12th, 2006

The Meta Group ranking of enterprise dashboard vendors placed Hyperion in fourth place with a score of 4.3. For the original analysis, take a look at Meta Group Rating of Vendors for Enterprise Reporting and Enterprise Dashboards. Just to recap, Information Builders, Business Objects, Actuate, and Cognos placed ahead of Hyperion with the following scores:

Ranking of enterprise dashboard vendors

Today, we look at some enterprise dashboard screenshots from Hyperion. First, let’s see exactly what Meta Group said in their report:

Hyperion Performance Suite 8.3 (Intelligence and SQR)

Hyperion offers a solid enterprise reporting and dashboard product, and it finished in the middle of the overall ranking. Hyperion acquired SQR and other intelligence components through the acquisition of Brio during 2003. Such products are OEMed by numerous other software vendors, most notably PeopleSoft. Although Hyperion scored well in most areas of the evaluation, it scored last in the area of development environment.

Strengths

• Best-in-class support for parameters
• Above-average support for connectivity and scalability and performance
• Strong security integration capabilities out of the box

Limitations

• No out-of-the-box alerting capabilities
• Minimal (formatting and limited formulas support) integration with Excel; this will be addressed during
2005
• No WYSIWYG report design in SQR
• Separate desktop tool for creating connections and connection pooling

Now, on to the enteprise dashboard screenshots. Among the BI dashboards shown here is an interesting compliance dashboard for Sarbanes-Oxley.

Hyperion 9 Dashboard       Hyperion Compliance Dashboard

 

SOX compliance dashboard

 

Hyperion Dashboard

 

Hyperion Executive Dashboard  
Hyperion Sales Dashboard

Hyperion Analyzer Dashboard

The Dashboard Spy Business Intelligence Dashboards Blog

If you are new to enterprise dashboards, you really must start by reading the book by Malik:

Enterprise Dashboards: Designs & Best Practices for IT

To give you a flavor of the wonderful nuggets of enterprise dashboard knowledge, here is a quote from Mr. Malik in which he talks about the SMART elements that enterprise dashboards should have:

So, let us establish the basic characteristics specific to an enterprise dashboard with a useful acronym—SMART. A dashboard must be SMART in that it contains the following underlying elements, which are essential for success: