Dashboards are a powerful way to communicate data to your team. One use for dashboards is tracking the progress of key performance indicators (KPIs). One KPI tracked at Lucid is the ranking and performance of our products in third-party marketplaces. Although there are enterprise-grade products to gather and visualize this type of data, you can generate automated dashboards with only Google Apps Script and Google Sheets.
Finally, create the dashboards from the formatted data. See How to Make a Killer Data Dashboard with Google Sheets for tips and tricks.
Via: How to Build Automated Dashboards With Google Apps Script and Google Sheets
“A picture is worth a thousand words”, the old saying goes, and in some cases, a picture is worth even more than that. The human eye is composed of some 30 or more discrete components, and along with the optical nerves and the brain functions that process sight, can take in a contrast ratio of around 100,000:1 (over time) and can distinguish about 10 million colors. That sight-brain-pathway is a pattern-matching wonder and has “regions of interest” that the eye/brain connection focuses on (http://www.cambridgeincolour.com/tutorials/cameras-vs-human-eye.htm).
Making up one of our primary senses, sight is immeasurably important to conveying information, and it’s vital to the Data Scientist to understand how to best use various visualizations to display and discuss data.
There is a book reference in this article from 2013 that still is a must-read for anyone attempting data visualization at any level. The best lesson is to look through other people eyes to appreciate how the information must “Look”. I go by a simple rule, “If my wife, who is not technical or a data scientist, can’t understand the visual it probably needs more work”
Via: Microsoft Developer, Buck Woody
Microsoft is trying to give the other “on-Demand” Business Intelligence vendors a run for their money. The enterprise folks didn’t give Power-BI a second glance when they leanered the only way to publish was to the cloud. Cloud = Bad. There was talk of SSRS being able to be the portal for all things Power-BI and now some if this has come true.
Microsoft has an Azure appliance that you can “play with” while Microsoft tunes things up. I think this is going to be a look-see for me in the near future. I will post what I find.
Tableau is one of the better Business Intelligence tools in the latest NEW BI tools being released that I call BI-Fresh. It works with many different data sources including some of the larger cloud based databases. While my experience is limited to Teradata data warehouse with Tableau I would recommend it for your short list for BI-Fresh evaluations. Here is a recent review done by ComputerWorld on the latest release 9.0 Beta.