BI Dashboard: Tips for Learning to Use the Tool

September 12, 2012
114 Views

When you start to learn how to work with the BI Dashboard tool – the blank slate can be the scariest single element you face.  What goes where? How can I make it look better?  Here’s some suggestions I have used.

When you start to learn how to work with the BI Dashboard tool – the blank slate can be the scariest single element you face.  What goes where? How can I make it look better?  Here’s some suggestions I have used.

Review Dashboard Sources

Use Google Images to find examples of what other designers have created.  When you can see an overview of dashboards as thumbnail images, the better ones are more apparent.  Study the colors and graphics used.  Note what really makes the data communicate its message versus what looks like a cool concept for the designer, such as putting a steering wheel on the dashboard! 

From the Google homepage, type dashboard or dashboard design or dashboard examples and select Images from the bar, as shown below.   You can then click on the more interesting ones to see a close up.  Also notice how the data is visualized – was the bar graph or the gauge more effective.  Can you understand within a few moments what the dashboard is measuring?

 dashboard google 011 BI Dashboard: Tips for Learning to Use the Tool

Recreate What You See For Fun!

Once you find some dashboards you admire, recreate the information using the BI Dashboard.  By using data that is not meaningful to you, its easier to work with the indicators to determine what patterns emerge based on how the data is presented.  Yes little data geek – do it for fun on Saturday nights!

Here’s one that a hotel management company could use to determine how the regional groups were performing.   The drop down on the right side changes the data view to show how each region performed. Looks like July 11 was a rough day.  I don’t like the way the Customer Satisfaction Ratings appear with the dots – probably I would change that to arrows.

dashboard google 021 BI Dashboard: Tips for Learning to Use the Tool

 This dashboard is for a lower level of management. I imagine a Call Center Manager using this dashboard to manage what is going on hour by hour across several locations.  I re-used the Locations indicator but I was really thinking it might be by product line or something more specific. 

The Call Arrival would allow the manager to predict if the call traffic was rising and this would be based on the average traffic from the past 7 days. The Agent Performance is based on how many calls the agent is able handle in an hour and the duration of the call.  The expectation being that newer agents would be slower and thus take more time to process the call.  However, if an experienced agent is taking longer the manager would want to know if the agent was getting more difficult calls that were taking longer to process or maybe the agent is spending too long at break time.  The agent may need a pep talk or time off.

dashboard google 03 BI Dashboard: Tips for Learning to Use the Tool

Your Turn

If you have a dashboard you want to show off – send me a screenshot and I’ll share them in a later post.

Related content:

  1. SAS BI Dashboard: Measuring the Conversion Rate with Google Analytics
  2. SAS BI Dashboard Rocks My Google Analytics Data Analysis
  3. SAS BI Dashboard: Google Analytics Dashboard Kicked Up a Notch
  4. What Can I Do With a Stored Process?
  5. Ready for the Next Generation of SAS?

You may be interested

The Race for 5G Is the Race for Data Dominance
Big Data
80 shares697 views
Big Data
80 shares697 views

The Race for 5G Is the Race for Data Dominance

Daniel Matthews - June 22, 2017

Have you noticed how often the phrase “by the year 2020” comes up? In the tech sphere, many are heralding…

The Direst Security Breaches of 2017 and How Data Centers Are Responding
Best Practices
108 shares1,372 views
Best Practices
108 shares1,372 views

The Direst Security Breaches of 2017 and How Data Centers Are Responding

Diana Hope - June 20, 2017

Cybersecurity is becoming a tremendous concern. By 2021, security breach cost will exceed $6 trillion a year. A number of…

Why Smart Data is the Key to Future Lending
Best Practices
55 shares1,129 views
Best Practices
55 shares1,129 views

Why Smart Data is the Key to Future Lending

Patrick Köck - June 20, 2017

Last month, big data and investment trading collided on the front page of The Wall Street Journal. The article titled…