Excel Dashboard Templates

Learn how to create Excel dashboards.
Showing posts with label executive dashboard. Show all posts
Showing posts with label executive dashboard. Show all posts

Tuesday, August 14, 2007

Dashboard for Tracking Video Stream Metrics

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

Friday, July 13, 2007

Websphere Dashboard for Insurance KPIs

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.


Executive Dashboard Screenshot of Insurance Metrics

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

Thursday, July 5, 2007

Creating Traffic Light Indicators in Xcelsius Using the Bubble Chart Component

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

Thursday, June 21, 2007

PGA Executive Dashboard for Media Convergence

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

Tuesday, June 5, 2007

Executive Dashboard for Sales Representative Metrics

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

Wednesday, May 16, 2007

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

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:






Monday, April 9, 2007

Law Firm KPIs & Metrics on an Executive Dashboard

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