Implementing Environmental Dashboards in your workplace

 

We’ve all seen them – those big, flat-panel televisions – colorfully beaming with real-time data points. Pure eye-candy! I am a big proponent of environmental dashboards in the office space. Dashboards serve a vital purpose as a communication hub – providing quick access to metrics the whole organization should be aware of. However, they should not over-extend their dialogue. We’re looking for no more than a 30 second “elevator pitch” on where the business stands. The reader should walk away knowing the successes, opportunities and where we stand toward our goals. Environmental dashboards should be the first thing you see when you walk in the doors for work each day and the last things you see on the way out.

Overview

Dashboards are in a unique space on the Data Visualization and Business Intelligence family. Unlike the other two which serve data discovery through interaction - dashboards are largely read-only. Furthermore, environmental dashboards need to be as clean as possible and without the traditional User Interface (UI) as that wastes space better served for eye-candy maps and widgets.

The process of setting up environmental dash-boarding in your organization should take you a couple of days to implement, provided you have all the resources at your disposal. I’ve broken the process down into these four easy steps.

  1. Dashboarding Caveats
  2. Choosing a service provider platform
  3. Picking hardware and physical setup
  4. Designing your dashboard

 

Step 1. Dashboarding Caveats

Dashboards do not have nearly the flexibility of implementation that a more powerful solution like Tableau, Chartio, SiSense, SAP or Qlikview (to name a few) does. They are intended to allow a user (of minimal technical background) to quickly connect to web based services and drop widgets on a dashboard.

  • The widgets themselves are generally ‘take it or leave it’, offering no or little flexibility
  • Make sure your services are supported (e.g. SalesForce, Google Analytics..) and that you can access the data you’re interested in
    • Typically, a set number of widgets are available for each service and customization is not generally afforded
  • Some dashboard services do not allow native database connectivity – so, if your data is in a warehouse, you need to look into this first.
    • This includes stuff like Microsoft Azure, AWS Redshift, and Google BigQuery
  • Widgets function off a single data source – so if you need a multi-source data point (e.g. merging mailchimp and GA) – you would have to create this functionality elsewhere (DW) and link to that (note my comment directly above)
  • Be mindful that this info is on public display to anyone in your office

Step 2. Choosing your dashboard provider

There is no shortage of dashboard providers out there and they all offer subtle variations on the same visual experience using a web-based platform. My personal favorites are LeftronicGeckoboard and Klipfolio. Now, there are plenty of comparison resources out there, so I will not re-invent the wheel here.

The most crucial thing for you to do is to catalog all the services you need to connect to for rendering your dashboard (Analytics platform, email, sales, facebook, twitter, et al.). If you don’t see your service listed, check with the dashboard provider as these dashboard services are very competitive and are constantly evolving. Also, make sure your metric (and dimensions) are supported – such as custom variables.

There seems to be a detente in pricing between them but pay close attention to the language between dashboards and users. If you have multiple screens in the office(s) (and the last one I did had 30!!!), then you may end up with a large delta between providers. Of course, you always can use a HDMI splitter/repeater to minimize costs (especially if you need to buy Chromeboxes for each device)

Lastly, all three that I recommended offer a 30 day free trial. So, kick the tires and see what works best for you.

Step 3. Picking hardware and physical setup

The objective here is to load the web-based dashboard in a full-screen and render it on the TV. The screen should also be big enough and centrally located so that people can read it from a distance. For that reason, I would not recommend anything less than 50″. Also, the screen should be wall mounted on an articulating (aka full-motion) mount so you can align it for appearance and use. Lastly, it goes without saying – hide the cables. In the immortal words of Sweet Brown: “Ain’t nobody got time for that!”

What you need:

  • If you don’t have a suitable >50″ flat panel TV
    • a 50-55″ or greater LED 1080p TV with smart functionality and WiFi ($550> USD)
      • Make sure you give your dashboard a test-run at the store before you buy!!
    • an articulating wall mount <$100 USD
    • Public WiFi router (if you don’t already have one)
      • Some Private corporate WiFi routers use integrated security which smart TV’s have issues with.
  • If you do have a 720p or greater >50″ flat panel TV
    • an articulating wall mount <$100 USD
      • Make sure it works with your screen as earlier TV’s had proprietary mount points
    • a Google ChromeBox (<$200 USD) with Keyboard and Mouse.
      • Get the least expensive one you can find. Remember, you’re only loading a webpage.
      • Some Chromeboxes had RJ45 connectors in case you need to connect to a local network

Since the dashboard components (“widgets”) are large and are going to be viewed from a distance: you can nix the 4k display as the premium will be lost. I’ve successfully re-used 720p displays in the past with great results.

Step 4. Designing your dashboard

When designing a dashboard its important to

  1. Get and constantly re-assess stakeholder input.
  2. Show data-points that are intuitive, meaningful and communicate a story (are we on budget or off?, what is moving the needle?)
    1. Data points should be tied to the respective time frame that stakeholder and their teams track to. e.g. Sales should be in monthly to allow sales to track to their goals. SEO, SEM, Social Attribution, and visitors should be in real-time to assist your marketing and social teams. Lastly, top pages/articles should be in real time as that helps explain what is driving traffic/sales
    2. Cluster your widgets by business group to aid in readability
    3. Keep the total number of widgets below 12 or 13. Otherwise the dashboard becomes antiseptic and daunting
    4. If you have a data point that is making a certain stakeholder look bad, offer to temporarily remove it. Otherwise you will erode goodwill.
  3. Although you’re sure this dashboard is idiot proof – GATHER THE TEAMS and present it. My experience is that people don’t want to ask for fear of looking like an idiot.
  4. Use the dashboard to celebrate “wins” (such as a high number of sales or visitors) – this will enforce the positive association

Thanks for reading and have fun with your dashboard. As always: feel free to post comments or suggestions if you have them.

David

Article by David

Your host and an experienced analyst dedicated to evangelizing the quantifiable, data-driven measurement of business with an emphasis on the customer relationship.

147 Comments


  1. An interesting discussion is worth comment. I think that you should write more on this topic, it might not be a taboo subject but generally people are not enough to speak on such topics. To the next. Cheers

  2. I really like swimming http://blog.cilek.com/etiket/hamilelik/ megalis with alcohol Aldi saw record sales growth of 32.7 over the same period last year and now controls 3.7 of the UK’s grocery market. Lidl achieved growth of 14.3. At the top end of the market, Waitrose saw sales rise 9.7 as it continued to open new stores. The supermarket, which is part of the John Lewis Partnership, meanwhile highlighted the extent of its ambitions online yesterday as it announced plans to build a second “dark store” distribution centre for its internet store near London. The depot will double the number of orders Waitrose can handle in the capital.

  3. Thank you so much for providing individuals with an exceptionally splendid possiblity to read articles and blog posts from this blog. It is always so excellent and also stuffed with fun for me and my office peers to visit your web site more than three times in one week to see the newest guides you have got. And indeed, I’m actually happy with all the extraordinary strategies served by you. Some 2 tips in this posting are completely the very best we have had.

  4. I definitely wanted to write down a simple message to thank you for the marvelous ideas you are giving at this website. My extensive internet lookup has now been paid with awesome facts and strategies to write about with my best friends. I ‘d state that that many of us readers are rather fortunate to exist in a magnificent website with so many wonderful professionals with very helpful techniques. I feel truly happy to have come across your entire web pages and look forward to plenty of more fabulous moments reading here. Thank you again for a lot of things.

  5. One important issue is that when you find yourself searching for a education loan you may find that you’ll need a cosigner. There are many scenarios where this is correct because you will find that you do not possess a past credit ranking so the financial institution will require you have someone cosign the financing for you. Interesting post.

  6. Awsome article and straight to the point. I don’t know if this is truly the best place to ask but do you people have any thoughts on where to get some professional writers? Thx 🙂

  7. I like what you guys are up too. Such smart work and reporting! Carry on the excellent works guys I have incorporated you guys to my blogroll. I think it’ll improve the value of my website :).

  8. I’m truly enjoying the design and layout of your site.It’s a very easy on the eyes which makes it much more enjoyable for me to come here and visit more often. Did you hire out adesigner to create your theme? Great work!

  9. It is really a nice and helpful piece of info. I am satisfied that you shared this
    useful information with us. Please keep us up to date like this.
    Thanks for sharing.

  10. undress rehearsal to submit oneself to questions more tabna.fette.club/gewicht-verlieren/nahrungsergaenzungsmittel-potenzsteigerung.html what eatables to eat. A registered dietitian can countenance you classify your tastiness of the month foods in a signed do to redundancy plan. Determine quagli.pijnstiller.shop/dokters-advies/hoe-groeit-je-haar-sneller.html starchy foods such as undamaged molecule breads and cereals, rice, noodles, or potatoes at every meal. Starchy foods are defeated down into glucose, which offer.kokosik.nl/instrucoes/261d03118a.html your fullness needs conducive to energy.

  11. I’m curious to find out what blog system you happen to be utilizing? I’m having some minor security issues with my latest website and I’d like to find something more safeguarded. Do you have any solutions?

  12. I have been exploring for a bit for any high quality articles or weblog posts
    on this kind of space . Exploring in Yahoo I at last
    stumbled upon this website. Studying this information So i am happy
    to show that I’ve a very excellent uncanny feeling I found out exactly what I needed.
    I most surely will make certain to don?t forget this website and
    provides it a glance on a constant basis.

  13. Thanks for your blog post. What I would like to bring up is that laptop memory needs to be purchased in case your computer is unable to cope with everything you do by using it. One can add two RAM memory boards with 1GB each, in particular, but not certainly one of 1GB and one having 2GB. One should always check the company’s documentation for the PC to make sure what type of storage is essential.

  14. thsxvftyep,We have a team of experts who could get you the correct settings for Bellsouth net email login through which, you can easily configure your email account with MS Outlook.

  15. I just want to say I am just new to blogs and truly enjoyed your web blog. More than likely I’m planning to bookmark your blog post . You really come with outstanding articles. Cheers for revealing your webpage.

  16. Hi, i feel that i noticed you visited my weblog so i came to return the prefer?.I am attempting to find issues
    to improve my website!I assume its ok to make use of some of your ideas!!

  17. txjdmero Yeezy,Thanks a lot for providing us with this recipe of Cranberry Brisket. I’ve been wanting to make this for a long time but I couldn’t find the right recipe. Thanks to your help here, I can now make this dish easily.

  18. Every code I attempt either leaves a huge gap at the top of the page, or at the end of the web page. Its definitely that code causing it. I have actually attempted so many codes attempting to hide the blog sites & extended network, but they all leave a white space either on top or at the bottom. Anyone got one that doesn’t cause the white gap? Or how to get rid of the white gap?.

  19. Analysts say recovery flight and recovery delivery 737 MAX is expected to take months rather than weeks. Boeing CEO Murenberg said in a statement: “We are temporarily adjusting the 737’s production system to accommodate the temporary suspension of the aircraft, which allows us to prioritize additional resources to focus on software certification. And let the 737 MAX resume flight.”

  20. I’m aiming to figure out as much regarding the online surfing community as I can. Can any person suggest their favorite blogs, twitter takes care of, or websites that you discover most comprehensive? Which ones are most popular? Many thanks!.

  21. Apple had expected it to reach this milestone more than six months ago, but in order to maintain its leading position, Spotify has expanded its various promotions, including the launch of a discount subscription package with video streaming service Hulu. Recently,

  22. Nike SB‘s latest and greatest for its yearly 4/20 celebrations arrives in the form of the Dunk High “Dog Walker,” pushing many a texture alongside a theme that is adhered to with stunning dedication.

  23. Simply exactly how does one earn money from blogs? Exactly how does one start it or deal with it? Exists a certain means to do it? Just just how does one generate income from blogs to begin with? Where does one get going in this? Do you need to promote and also utilize your bank card? Exist any certain sort of rules you have to adhere to? Do you have to establish the blog site up yourself or exist ones that aid you set up it up? Exactly how do you get advertisers on your blog site? Are individuals restricted to the variety of blogs online? How frequently do you earn money?. Many thanks for the assistance!.

  24. This is not a crazy idea in my opinion. We may enter the end of the ten-year bull market, we The volatility seen in the past six months is very different from the past 10 years.” Earlier this week,

  25. Sadly, doctors were not able to revive Daniel, and Linsey later learned Amelie did not survive her injuries either. The brother and sister — both of whom were dual citizens of the U.S. and U.K. — were among four Americans killed during the attacks, along with 40-year-old Wisconsin native Dieter Kowalski and 11-year-old student Kieran Shafritz de Zoysa.

  26. I enjoy you because of all your labor on this website. Debby loves making time for research and it’s obvious why. All of us know all concerning the compelling mode you make very helpful secrets through your web blog and as well recommend response from people about this topic then my child is studying a great deal. Have fun with the remaining portion of the year. You’re carrying out a very good job.

  27. you’re in point of fact a excellent webmaster. The
    web site loading pace is amazing. It kind of feels that you’re doing any
    unique trick. Moreover, The contents are masterwork.
    you have done a magnificent task on this subject!

  28. Thank you for your entire effort on this web site. My mom takes pleasure in managing internet research and it’s really obvious why. A lot of people know all regarding the compelling mode you make sensible thoughts through your web site and in addition recommend contribution from other people on the subject so our own girl has always been being taught a lot. Take advantage of the rest of the year. You’re the one conducting a very good job.

  29. Substantially, the post is actually the greatest on this worthw hile topic. I harmonise with your conclusions and also will thirstily look forward to your coming updates. Simply just saying thanks will certainly not simply be adequate, for the extraordinary lucidity in your writing. I can right away grab your rss feed to stay abreast of any kind of updates. Fabulous work and also much success in your business enterprize!

  30. Thank you for all your valuable efforts on this website. My mom takes pleasure in doing research and it’s simple to grasp why. We all learn all about the powerful tactic you offer priceless tips through your web site and as well attract participation from visitors on that area of interest so our favorite girl has always been studying so much. Take advantage of the remaining portion of the new year. You are performing a really great job.

  31. I’m curious to find out what blog system you’re utilizing? I’m having some small security problems with my latest website and I would like to find something more risk-free. Do you have any recommendations?

  32. Great site you have here.. It’s difficult to find
    high-quality writing like yours nowadays. I really appreciate people like you!
    Take care!!

  33. Thanks so much for providing individuals with a very terrific opportunity to read in detail from here. It is always very terrific plus jam-packed with amusement for me personally and my office colleagues to search your blog at minimum three times in 7 days to read through the newest secrets you have got. Not to mention, we are actually satisfied considering the surprising methods served by you. Certain 1 tips in this article are absolutely the most effective I’ve ever had.

  34. My spouse and i were really relieved Raymond could deal with his reports through the ideas he grabbed from your own web page. It is now and again perplexing just to happen to be giving out guidance that men and women might have been selling. We really figure out we have the website owner to appreciate because of that. The main illustrations you made, the easy website menu, the relationships you can make it possible to promote – it’s got all fantastic, and it’s really helping our son in addition to the family consider that this topic is enjoyable, which is certainly exceptionally indispensable. Thank you for the whole thing!

  35. Hey there! Do you know if they make any plugins to safeguard against hackers? I’m kinda paranoid about losing everything I’ve worked hard on. Any recommendations?

  36. You actually make it seem so easy with your presentation but I find this topic to be actually something which I think I would never understand. It seems too complicated and extremely broad for me. I am looking forward for your next post, I will try to get the hang of it!

  37. Howdy! I’m at work browsing your blog from my new apple iphone! Just wanted to say I love reading through your blog and look forward to all your posts! Keep up the great work!

  38. A lot of thanks for every one of your labor on this site. My niece really likes getting into research and it is obvious why. I know all relating to the compelling means you offer important solutions through the web site and even increase response from people on that subject matter and my girl is understanding so much. Take pleasure in the rest of the new year. You are carrying out a first class job.

  39. wonderful post, very informative. I wonder why the other experts
    of this sector do not notice this. You must continue
    your writing. I’m sure, you have a huge readers’ base already!

  40. Hello there, I discovered your web site by means of Google even as
    looking for a related matter, your website got here up,
    it seems good. I have bookmarked it in my google bookmarks.

    Hello there, simply turned into aware of your weblog via Google, and located that it’s
    truly informative. I’m gonna watch out for brussels. I’ll be grateful should you proceed this in future.
    Lots of folks might be benefited out of your writing.
    Cheers!

  41. Health officials said Friday that nearly 700 people at two universities in Los Angeles have been ordered to stay home because they might have had contact this month with two measles patients.

  42. Undeniably consider that that you said. Your favourite reason appeared to be on the web the easiest factor to have in mind of.
    I say to you, I definitely get irked even as folks consider
    worries that they plainly do not realize about. You controlled to hit the nail upon the top and
    defined out the entire thing without having side
    effect , people could take a signal. Will likely be back to get more.
    Thank you

  43. Excellent site you have here but I was curious about if you knew of any user discussion forums that cover the same topics
    discussed here? I’d really like to be a part
    of online community where I can get feed-back from other knowledgeable individuals that share the same interest.
    If you have any recommendations, please let me know.
    Many thanks!

  44. I don’t even understand how I finished up here, but I thought this submit used to be good.
    I don’t recognize who you might be but certainly you’re going to a well-known blogger if you
    happen to aren’t already. Cheers!

  45. Hi colleagues, how is the whole thing, and what you would like to say on the topic of this article, in my view its genuinely awesome in support of me.

  46. 5/11/2019 @ 09:58:32 In my estimation, fountainanalytics.com does a good job of handling topics of this type! While frequently intentionally contentious, the information is in the main thoughtful and challenging.

  47. Hey there! This is my first visit to your blog!
    We are a group of volunteers and starting a new project
    in a community in the same niche. Your blog provided us valuable information to work on. You have done a extraordinary job!

  48. You’ve made some decent points there. I checked on the net to
    find out more about the issue and found most people will go along with your views on this website.

  49. Excellent post. I was checking constantly this blog
    and I am impressed! Extremely useful info specifically the last part 🙂 I care for such info
    a lot. I was looking for this particular info for a very long time.
    Thank you and good luck.

  50. I don’t even know the way I finished up here, but I assumed this publish used
    to be good. I do not understand who you might be however definitely you are going to a
    well-known blogger if you aren’t already. Cheers!

  51. Very nice post. I just stumbled upon your blog and
    wished to say that I have truly enjoyed browsing your
    blog posts. In any case I’ll be subscribing to your feed and I hope you write again soon!

  52. Oh my goodness! an incredible article dude. Thank you Nevertheless I’m experiencing subject with ur rss . Don know why Unable to subscribe to it. Is there anyone getting an identical rss downside? Anybody who knows kindly respond. Thnkx

  53. I have to get across my respect for your kind-heartedness giving support to those people who really need assistance with that study. Your very own dedication to getting the message all through appeared to be extraordinarily functional and has in most cases encouraged regular people just like me to arrive at their pursuits. Your amazing warm and friendly help and advice can mean much to me and still more to my peers. Thank you; from each one of us.

  54. I am about to start a blog. Together with numerous other hopeful’s, I wish to eventually generate income off it. I noticed a great deal of websites do not allow you to earn money of google advertisement feeling and things like that. What are some sites I can start my blog on that will permit this considering that it seems to be one of the most successful method to make money off a blog?.

  55. I do love the manner in which you have presented this difficulty plus it does indeed provide me a lot of fodder for thought. Nevertheless, through what precisely I have personally seen, I really trust as other reviews pile on that folks continue to be on point and don’t start upon a tirade involving some other news du jour. Anyway, thank you for this exceptional piece and even though I can not really go along with this in totality, I regard the viewpoint.

  56. A person essentially help to make severely articles I might state. That is the first time I frequented your website page and up to now? I surprised with the analysis you made to create this particular post incredible. Excellent process!

  57. Thank you for this article. I’d personally also like to talk about the fact that it can become hard when you find yourself in school and just starting out to initiate a long history of credit. There are many individuals who are just simply trying to pull through and have a good or positive credit history are often a difficult element to have.

  58. I have learned several important things by means of your post. I’d also like to mention that there may be a situation in which you will obtain a loan and do not need a co-signer such as a Federal government Student Aid Loan. But when you are getting credit through a regular loan company then you need to be ready to have a cosigner ready to assist you to. The lenders can base that decision on the few factors but the most important will be your credit rating. There are some loan companies that will likewise look at your job history and come to a decision based on that but in many instances it will hinge on your report.

  59. Definitely believe that which you said. Your favorite justification seemed to be on the internet the easiest thing to be aware of. I say to you, I definitely get irked while people consider worries that they just do not know about. You managed to hit the nail upon the top and also defined out the whole thing without having side effect , people can take a signal. Will likely be back to get more. Thanks

  60. Attractive section of content. I just stumbled upon your site and in accession capital to
    say that I get in fact loved account your blog posts. Any
    way I will be subscribing for your feeds or even I success you get admission to constantly fast.

  61. Its such as you read my mind! You seem to know a lot
    about this, like you wrote the guide in it or something.
    I believe that you simply could do with a few p.c. to power the message home
    a little bit, however instead of that, this is fantastic blog.
    A great read. I will definitely be back.

  62. Yet another issue is that video games usually are serious in nature with the major focus on understanding rather than entertainment. Although, it comes with an entertainment factor to keep your sons or daughters engaged, just about every game is usually designed to improve a specific set of skills or programs, such as math concepts or scientific discipline. Thanks for your write-up.

  63. I was suggested this website by my cousin. I’m not sure whether this post is written by him as no one else know such detailed about my trouble.
    You’re incredible! Thanks!

  64. I’m interested in making my own music blog site and I’m constantly browsing several songs blog sites throughout the day discovering new music initially prior to other individuals that I recognize. But just how specifically do those blog sites discover that songs initially? Can I truly start by simply uploading the music I find on various other blogs?.

  65. Thanks for this article. I will also like to state that it can always be hard when you find yourself in school and simply starting out to create a long credit history. There are many pupils who are simply just trying to live and have a good or good credit history can occasionally be a difficult issue to have.

  66. One other issue issue is that video games are generally serious anyway with the main focus on understanding rather than fun. Although, there is an entertainment part to keep your kids engaged, just about every game is frequently designed to work with a specific set of skills or curriculum, such as math concepts or scientific discipline. Thanks for your publication.

  67. I’m searching for some really good service blog sites to include in my google viewers that are beneficial adhering to on an ongoing basis. Can you make and referrals? I have Seth Godin’s currently. Thanks!. It would certainly additionally be helpful if you told me why you suched as these blog sites.

Leave a Reply

Your email address will not be published. Required fields are marked *