Dashboard Guy

Vehicle Quality and Customer Satisfaction Dashboard

2008-10-06T15:53:00.000-07:00

This Xcelsius Dashboard offers an executive in the automotive industry a daily executive report. The KPIs and Metrics on this business intelligence dashboard include:

Sales KPIs

Unit Sales by Car Model
Average Dealer Incentives
Average Purchase Price

Customer Satisfaction Metrics

Satisfaction Ratings
New Vehicle Quality
Long-term Reliability
Service Satisfaction

This dashboard was implemented with Crystal Xcelsius

Pharma Sales Dashboard

2008-09-04T07:51:00.000-07:00

Here is a screenshot capture of an actual production dashboard from the Bristol Myers Squibb pharmaceutical company. It's used by the sales managers to track sales metrics.

Some project summary information about this sales dashboard project:

The challenge

The existing systems to handle BMS’s (Bristol Myers Squibb) Sales and Market Research reports and analytics were custom built on Access and Excel. The increasing complexity of the business and personnel changes led to the system performance deteriorating and it was proving time consuming and expensive to maintain. Multiple data sources needed to be integrated to facilitate the complexity of the reporting and analysis required. Maintaining the accuracy of the data sources and the relationships between them also proved to be a complex and time consuming process. Too much time was spent validating, correcting and manually manipulating data with insufficient time left to perform in-depth analysis.

Overall, there was a poor flow of data to the brand teams and sales force with a lack of support for analytical and reporting tools for Key Account Managers.

The solution

After a thorough evaluation of companies specialising in Pharma Business Intelligence solutions, BMS selected the PharmaAnalytics platform and XLCubed from Data Intelligence.

Within three months, the first successful production run of the BMS PharmaAnalyticsTM instance had been completed. The resulting Microsoft SQL ServerTM Analysis Services Cube contained 23 integrated data sources, representing over 40 files. In parallel, over 100 integrated dashboards and reports covering all the needs of the brand teams, sales force, market research, healthcare management teams and senior management team were developed leveraging XLCubed.

Topic: Excel Access Dashboard for Pharmaceutical Sales Metrics Dashboard

Building an Excel Bullet Graph

2008-08-19T11:59:00.000-07:00

Bullet charts are excellent devices for clear data visualization. They have become part of the graphing toolset for a number of dashboard and business intelligence graphing software applications.

Did you know that you can build them yourself for use in Excel?

Here are a couple of great tutorials for doing so.

The first comes from Micheal Alexander of Excel 2007 Dashboards & Reports For Dummies fame.

He has a video at DataPigTechnologies.com on exactly how to create bullet graphs in Excel.

Here is a screenshot from the video. Click on the image to enlarge it.

Another great tutorial on Excel bullet chart construction is from Charley Kyd of ExcelUser.com.

His page on bullet graphs is quite excellent. Here is a screenshot of a part of the tutorial. You can also download example excel worksheets with the bullet charts so be sure to visit the link.

Excel Template for Dashboards

2008-06-24T06:54:00.000-07:00

An easy solution for business intelligence dashboard reporting is sitting right under our noses! Consider implementing dashboard reporting in Excel.

Everyone has Microsoft Excel, so why don't more people use it for creating dashboard reports? Well, the consensus among the dashboard designers I spoke to seems to be that one can't get dashboard designs out of Excel that don't look like, well, dashboards made in Excel.

Yes, we've all seen those dashboards that are simply a collection of Excel graphs. Well, take a look at this nice dashboard layout:

Yes, that slick looking layout is done in 100% Excel. It's a dashboard Excel Template that is all set up and ready to point at your data. Use that link to check out the details.

Even Stephen Few likes the dashboard. See his blog entry in Visual Business Intelligence titled When Expensive Dashboard Software Doesn't Work, Do It with Excel.

Go Excel for dashboards!

Business Benefits of Digital Dashboards

2008-06-18T07:29:00.001-07:00

If you are trying to justify a business intelligence dashboard project in your enterprise, here are some charts that you may find helpful. Whether you are calculating Return on Investment (ROI) or building a business case more anecdotally, there are both business benefits and technical benefits.

Here are some business benefits of using enterprise dashboards:

Improved Decision Making

Faster Time-to-Market

Improved Competitive Advantage

Improved Customer Satisfaction

Better Productivity

More Profits

And here are some significant technical advantages of business dashboards:

Rapid Problem Detection

Faster Response to KPI Changes

Reduction of Work

Improved Organizational Alignment

Identification of Problems

Management of Exceptions

Better Visibility into Remote Operations

Increased Operational Efficiencies

Here are the charts. Please click on the graphics to enlarge them:

Tags: Digital Dashboard Business Benefits

Flex Dashboard Example

2008-06-13T09:09:00.001-07:00

Here's an example of a RIA dashboard using Flex technologies. It's an interactive flex demo so check it out at the link.

The demo was done as part of the Degrafa project (Declarative Graphics Framework for Flex) and you can read about it on this post about the Degrafa Dashboard Concept Example.

Tags: Degrafa Dashboards, Flex, RIA Dashboard

Personal Health Metrics Dashboard

2008-05-21T08:54:00.000-07:00

Digital dashboards are perfect for tracking Key Performance Indicators and metrics throughout the corporate world, but how about using them to track personal metrics as well? Here is a screenshot of a personal health metrics dashboard used to track weight management regimines.

Equipment Sales Dashboard Metrics

2008-05-13T09:02:00.001-07:00

Here is a look at an equipment sales dashboard that tracks key performance indicators and metrics for a UK-based exercise equipment dealer. Note that the focus is clearly on tracking the various financial metrics such as gross margin, sales quantity, sales value, cost of goods, and various slices by factors such as sales channel, region, product group and payment type.

News Dashboards for Tracking Sports Events

2008-05-12T15:06:00.000-07:00

The growing popularity of digital dashboards indicates that the dashboard design pattern's efficacy extends beyond that of traditional business intelligence. We are seeing it used more and more as navigation elements and information presentation layouts.

Here are a couple of news type dashboards. Specifically, these were used to track the March Madness that occurs during the NCAA tournament.

Management Dashboard with Sparklines

2008-05-06T07:22:00.000-07:00

If the idea of a BI dashboard or scorecard is to present business intelligence in as concise a manner as possible, then one absolutely must look to charts and graphs that are information-rich yet efficient in terms of screen real estate. Sparklines and bullet charts come to mind.

Take a look at the charting options made possible by Microcharts, a charting solution for Excel used by many business dashboard implementation teams.

Here's a good example of a management dashboard with sparklines and bullet charts.

Here are some sample charts:

There is an online demo of this Excel management dashboard.

Lifecycle of a Business Intelligence Dashboard

2008-03-09T11:31:00.001-07:00

One naturally assumes that the more mature a business intelligence dashboard gets, the more usage it gets and the more data it shows. But that isn't always the case. Interestingly, I have a great example of a dashboard that lately has gotten less informational.

"But how can that be?", you ask. Well, I'm talking about a dashboard that is meant to track a particular process, one that naturally narrows in terms of its focus. I'm talking about the very popular Yahoo Election 2008 Political Dashboard. Take a look at today's screenshot of the dashboard:

See what I mean? As the life cycle of this particular area of study matures, we'll get less range of data. Yes, we'll have more depth, but visually, we'll have to change the UI or else it will just look like a sparse matrix.

Excel Dashboard Tutorial

2008-01-23T07:34:00.000-08:00

Note to all excel users interested in Excel Dashboard development - a new excel dashboard tutorial has just been released at this link:

http://budurl.com/exceldashboardlesson

All business intelligence dashboard practitioners are encouraged to watch that video lesson by Chandoo.

Update on this post about Excel Dashboard Tutorials: An excellent series of posts on how to use microsoft excel for dashboard reports has been posted on Dashboards By Example: Excel Dashboard Tutorials. The Dashboard Spy article includes links to sample excel dashboard worksheets that you can download.

As each version of Excel grows in features and visual sophistication, the product becomes a really compelling choice as a dashboarding platform. In my opinion, even if the functionality wasn't there (oh - but it is, especially in the Office 2007 version - very dashboard friendly!), Microsoft Excel is a must-consider choice simply because of the size of its user base.

This being the case, it behooves us dashboarders to understand the dashboarding capabilities of Excel.

What better way than to walk through a real hands-on workshop with an information visualization pro like Jorges Camoes? Check out his post titled "How to Create a Dashboard in Excel" and be sure to download and follow along with his tutorial.

Here is a screenshot of the dashboard you'll be creating. It's a Demographics Dashboard.

Web-based Project Management Dashboard

2008-01-15T09:12:00.000-08:00

Here is a powerful way to manage distributed project management. Take a look at this screenshot from a product called Valleyspeak Project Server. Click on the thumbnail below to enlarge the dashboard screenshot.

This product allows the continued use of Microsoft Project while allowing the entire team to access the project status information from anywhere. Yes, of course you can take the approach of outfitting the entire team with licensed copies of MS Project, but this method allows one copy to power a browser-based version for everyone.

Tags: Project Management Dashboard

Dashboards in Microsoft CRM 3.0

2007-10-09T07:29:00.000-07:00

A Microsoft CRM developer was telling me about his project to build some enterprise dashboards in Microsoft CRM. He showed me this post about CRM 3.0 dashboards.

Out of the box, there is no way to generate the dashboards that everyone is clamoring for. But, as the blog post linked to above shows, you can use the Microsoft CRM SDK to generate some very nice dashboards.

Here is a look at their very nice work. The charts are flash-based.

Security Dashboards

2007-10-01T09:41:00.000-07:00

Dashboards for monitoring the status of network, web and email security are now common place. I can't think of many network security products that do not offer dashboards as the primary method of interacting with the end user.

Here are 2 dashboard screenshots of a security product.

You'll see liberal use of lights to show various states of key metrics.

Here is a closer look at one of the lower level pages:

Network Metrics Dashboard

Business Intelligence Dashboard Vendor Landscape Report

2007-09-06T20:29:00.000-07:00

Do you know the top five BI tool vendors of 2006? The Dashboard Spy knows. He has done it again with this post about a recent IDC ranking of business intelligence tool vendors. How does he come up with such interesting reporting on dashboarding news? Yes, as the Spy said, this Dashboard Guy wants to be like the Dashboard Spy.

As provided by the Dashboard Spy, here is the link to the IDC report excerpt entitled "Worldwide Business Intelligence Tools 2006 Vendor Share". as provided by BI dashboard vendor SAS.

Here are the market share and revenue statistics of the business intelligence tool vendors:

Be sure to click on this image to enlarge it for legibility.

Dashboard for Tracking Video Stream Metrics

2007-08-14T07:13:00.000-07:00

Executive Dashboards are built to visually impart a sense of key performance indicators. You get to "feel" how your business is doing. The "intuition" that you get from using an enterprise dashboard is often the result of the various gauges, dials, charts and graphics on the dashboard.

Sometimes, however, you really need to see line items of data on your dashboard. Summaries of various sales figures, totals of financials, etc. This is often best accomplished by displaying small tables on the dashboard.

Here is a good example of the mix of graphic and tabular content that can be used on a dashboard. This particular dashboard screenshot is of an application built to track the metrics of a site that delivers streaming video and audio. Obviously, it is critical that the site owners see the reach of their content distribution. It has charts, graphs and a map. Additionally, there are several portlets that are table-based. To help legibility, the rows feature alternate-row coloring.

Click on the dashboard to enlarge the screenshot.

Tags: Dashboard, Dashboard Design, Executive Dashboard

Cholesterol and Triglyceride Monitoring Dashboard

2007-07-30T06:56:00.000-07:00

One of the reasons that executive dashboards are the latest new thing is that they are so old. Is that a contradictory statement? No, the idea of an executive dashboard is comfortable because it seems so familiar to a range of users. Today, we all think of enterprise dashboards as web-based applications, but for years, the dashboard layout was a popular first view of a client-server or desktop application.

In that sense, many software architects used the application dashboard as a summary of key indicators, a jump-off point for navigation, and a way to make the look and feel compelling and useful. The dashboard as a UI design pattern has been sucessfully used for many years.

Today we look at a desktop application done in an executive dashboard style. This cholesterol and triglycerides monitoring dashboard allows the user to manage their cholesterol management regimen. The left side navigation includes doctor, exercise, diet, data, library, money and preference sections. Right side portlets include content such as to-do lists, email reminders, tasks, lab results and charts of the user's cholesterol and triglyceride levels.

Click on the screenshot of the monitoring dashboard to enlarge your view:

In terms of the design, it is functional, but I think there is a slight problem with the left side navigation. I am assuming that the onstate left nav bar is the doctor tab (as evidenced by the appearance of the sub-level navigation panel in blue). However, shouldn't the left navigation drive the right-side content? If so, the right side should show doctor-related content? Maybe it does, or maybe the first left side navigation item should be "My Dashboard".

Tags: Monitoring Dashboard, Executive Dashboard Design, Dashboard Example, Business Intelligence

Favorite links: Executive Dashboards by The Dashboard Spy

Websphere Dashboard for Insurance KPIs

2007-07-13T06:51:00.000-07:00

This executive dashboard was produced with the IBM Websphere Portal Server and their Portlet Factory using the Websphere Dashboard Framework. Typical of executive dashboards, it provides a visually-based summary of key metrics and KPIs. It is a business dashboard, in this case, created especially for the insurance industry.

Click on this screenshot to enlarge the view of this executive dashboard.

The Insurance KPI dashboard shows the overview tab which summarizes performance metrics such as Premiums Revenue Tracking, Number of New Policies Written, Average Policy Size, Underwriting Analysis and Underwriting Speed.

IBM does not support this particular dashboard as a product, but does offer the code for download to the dashboard development community as a jump start to an insurance industry dashboard. If you are developing dashboards with IBM Websphere Portal Server, check out the code download page for the IBM Dashboard KPI for Insurance.

Tags: Websphere Dashboard, Websphere Portal Dashboards, Insurance Dashboards, Executive Dashboards

Creating Traffic Light Indicators in Xcelsius Using the Bubble Chart Component

2007-07-05T06:59:00.000-07:00

Those of us using Crystal Xcelsius for executive dashboards often wish there was an out-of-the-box component for traffic light-style performance indicators. Red/Green/Yellow indicator lights are universally understood as indicators of state and are universally found on practically all executive dashboards. In fact, most business executives actually think in terms of green/red, good/bad modalities.

The author of my favorite book on Crystal Xcelsius ( Crystal Xcelsius For Dummies ) has an article where he shows step by step instructions on how to produce these neat executive dashboard traffic lights (click on the images to enlarge if necessary):

The basic idea is to use the built-in bubble chart component and strip everything out except for the bubble. Here is the usual bubble chart:

This link to the Xcelsius traffic light tutorial is definitely worth visiting. The author carefully illustrates each step that he takes, including the construction of the underlying excel spreadsheet and how to tie the series into Xcelsius.

Tags: Xcelsius Dashboard Indicators, Executive Dashboards

PGA Executive Dashboard for Media Convergence

2007-06-21T07:14:00.000-07:00

Executive dashboards replacing TV? The idea of watching a sports event on the web instead of on television has been kicked around for a long time. The rationale is that the web can offer interactivity and drill down capabilitiy that the TV set just can't (forget about the age-old pursuit of interactive TV - it's like looking for the fountain of youth!). Now with the widespread adoption of digital dashboards, it looks like it is now ready for prime time.

Well, in today's Executive Dashboard post, here is a dashboard screenshot taken while some avid golf enthusiast was watching a PGA tournament online. It comes from this post at skye journal. It has a skype conferencing window on the left so that he can chat with fellow fans (the ultimate live color commentary), a golf tournament dashboard provided by pga.com in the middle and a slingbox video feed on the right.

Note that in this paradigm, the actual video is all the way on the right. What is more important is the interaction with fellow fans and monitoring relevant KPIs, metrics and statistics via the golfing dashboard. Is this the future of television? Will people be dialing it to their executive dashboards?

Here is the executive dashboard screenshot. Click on the dashboard to enlarge the image.

Tags: Interactive dashboard, executive dashboards, enterprise dashboards, golf dashboard

Executive Dashboard Project Sponsor Wants a Bigger Logo?

2007-06-08T12:35:00.000-07:00

"Don't want to tell you how to do your job, but make the logo bigger. Make the logo as big as you can." Sounds familiar right? We've all been on projects where we get design advice. How to handle this?

Over at the enteprise-dashboard.com collection of executive dashboard screenshots, there is a pointer to a hillarious graphic design song (bet you didn't know that was a genre of music!) called Make the Logo Big.

The direct url to the song is

http://www.underconsideration.com/MaketheLogoBigger.mp3

You can read more about it at http://www.enterprise-dashboard.com/2007/06/08/make-the-logo-bigger-please/

Executive Dashboard for Sales Representative Metrics

2007-06-05T06:48:00.000-07:00

Today's executive dashboard screenshots serve sales representatives and sales executives by providing role-based display of metrics and KPIs critical for monitoring the company's marketing and sales activities. The enterprise dashboards are composed of portlets or widgets that contain content in the categories of financials, marketing activities, sales force automation (SFA) and standard portal functionality (calendar, links, history, etc.)

This first business intelligence dashboard shows the content that a sales representative receives upon loggin in to the application. The view is quite SFA-centric, with the list of accounts, contact information, top customers chart, calendar and contact information right at the top of the fold. The lead stage contact information is shown along with each lead's status information.

This next executive dashboard is for the business user role of sales manager. Note that in addition to the metrics and kpis available to the sales representative, the sales manager also sees sales cycle metrics and marketing campaign status.

Remember to click on the screenshots above to examine these executive dashboards in detail.

Tags: Executive Dashboards, Sales Dashboard, Marketing Dashboard

Executive Dashboard for Wireless Network Metrics

2007-05-31T10:32:00.000-07:00

Executive dashboards provide at-a-glance summaries of key performance indicators in a highly visual manner. This allows for quick understanding of metrics that spreadsheets simply can't provide. These executive dashboard screenshots show how a wireless provider uses executive dashboards to monitor the health of their network.

The wireless network operator is innundated with performance data. The trick is to translate the overwhelming number of data points into not just network performance trends, but, more importantly, into real management metrics.

This first executive dashboard screen is straight-forward and is composed of four graphs. Click on the dashboard screenshots to enlarge the views:

One of the most common requests by users of an executive dashboard is the ability to select reports and customize their views. These next two dashboard screenshots show how this is done in this dashboard system.

In the above screenshot, the user selected the reports they wanted to appear. In the screenshot shown below, the user can configure the charts and graphs themselves.

Executive Dashboard Shows Project Status At A Glance with these Colorful Indicators

2007-05-16T13:51:00.000-07:00

Executive Dashboards are visual in nature of course, but have you ever seen a dashboard with only big red, green, and yellow indicator lights? The design of this executive dashboard is slick and works well. They augment the information with hover-over, tool tip-type of explanations.

This executive dashboard tracks IT projects. There are 2 tabs - dashboard and builds. This screenshot of the dashboard shows the status of the projects by color. Green shows successful builds, red shows broken builds, yellow shows that a build is in progress and the grey indicates that the build has not yet occurred. And, yes - your eyes are OK, the colors are soft (a web 2.0 style influence and perhaps an aid to black and white printing).

This next screen shows the Builds view. It is also graphically oriented.

This final dashboard screenshot shows the detail view. As a more data-intensive screen, it has more text, but it also starts off with a big icon to show the state of the build:

Law Firm KPIs & Metrics on an Executive Dashboard

2007-04-09T19:03:00.000-07:00

This series of excellent executive dashboards focuses on law practice management via monitoring financial and client KPIs. They are the output of a hardworking executive dashboard guru at the law firm of Bryan Cave. Based on Redwood Analytics, these dashboard screenshots show exactly what gets a lawyer's juices going. Take a look at these metrics. This first dashboard screenshot starts off with a listing of clients and their attributes (fees collected, fees billed, collection contribution, billing contribution, effective rate, collection realization).

Click on the images below to open them fully to see all the details of each executive dashboard.

Upon drilling down into a client's details, we see financial metrics such as speed of collection, accounts receivables, and most interesting, how such KPIs for this client compare to firmwide metrics:

Gauges allow for a visual depiction of the financial metrics on this executive dashboard:

Finally, we get to see the planning module where each lawyer can plan out how much each engagement can contribute to their numbers.

Tag: Executive Dashboard