Category Archive
for: ‘Dashboards’

Film Selection Helper for Netflix

A quick example of a dashboard that connects to Netflix’s Odata catalog of movies. This shows all of the TV and Movie Titles available for instant viewing. Select a range of ratings, classifications, and film title to see the film’s synopsis. There are a few actions on this dashboard that filter and connect to the …

Read More

Tableau as a Dashboard (Take Two)

I’ve posted before about using Tableau as a dashboard platform – my first attempt was a ‘show and tell’, but didn’t conform to a particular user story and had limited dimensions available in the dataset. This updated version has a better dataset behind it, but also uses some new features of Tableau 6.0 such as …

Read More

Embedding Excel Workbooks (could easily be a dashboard)

Microsoft web apps are advancing nicely now – you are no longer tied to Facebook as the way to share documents – you can use Microsoft’s Skydrive. You can also embed documents, as shown below. I’ve recreated a table from an organization called the Third Way, “the leading moderate think-tank of the progressive movement”, apparently. …

Read More

Tableau as a Dashboard Platform

While recently at the Tableau User Conference, I wondered about the feasibility of using Tableau to produce ‘proper’ dashboards – that is, a dashboard with sparklines, and the right level of information, not just four revving gauges and a 3D pie chart.. I chose to (mostly) recreate the dashboard that I created in Excel for …

Read More

PowerPivot: A video introduction from MrExcel

Bill Jelen, aka MrExcel has written the first book on Microsoft’s new PowerPivot. PowerPivot is a the Office 2010 solution to link Excel to millions of rows of data held on databases or large text files. PowerPivot will ensure that Excel remains a useful, and perhaps even more serious, dashboard tool. I found this video …

Read More

If your sales dashboard tells you that sales are down, but not why, you don’t have a dashboard

I tweeted the following a while back: If your sales dashboard tells you that sales are down, but not why, you don’t have a dashboard It’s worth expanding on this a little more than the 140 characters allowed on Twitter.  What do I mean by this? Simply, if  your dashboard shows key performance indicators, or …

Read More

Using Google Chart API to create dashboards and sparklines

A few posts back I talked about using a plugin to the jquery javascript library to create sparklines in blog posts. One of my readers suggested using Google’s chart api to instead create the sparklines. From Google: What is the Google Chart API? The Google Chart API lets you dynamically generate charts with a URL …

Read More

Web-deployed dashboards without Flash or expensive BI tools (Protovis)

I discussed recently about how new javascript libraries (especially Protovis) have the potential to revolutionize information delivery to the web. As I haven’t seen any examples of these libraries being used to create a dashboard, I thought I’d be the first. This is my first iteration (click for the big, real version) – don’t read anything into the choice …

Read More

Great dashboards: dynamic charts in Excel 2007 and tables

I am working with a client to create dashboards to summarize data. Data is appended on a weekly basis, so any charts that show trending data must either be manually updated to include the new data (not workable), or the range somehow magically updated. As we are working in Excel 2007, I have used the …

Read More

Dashboard seminar – mark your calendars

I’m sure most readers of my blog will know Jon Peltier’s business,  and his excellent Excel/charting blog: Peltier Technical Services. Jon and I are teaming up to present a day-long training session on Excel Charting and Dashboarding. This training will take place on Wednesday, June 2, 2010, at the DoubleTree Hotel in Westborough, MA, in the Route 495 …

Read More
Page 1 of 212»