Tuesday, October 25, 2016

Dilbert on Why Self-Service Reporting, BI & Analytics Takes Faith

The term 'self-service' has been applied to reporting, business intelligence and analytics over the past few years.  While there are many business use cases for agile, 'self-service' approaches; it is a BI myth to believe that the need for a single consolidated source of truth is going away.  

So, why do I say that self-service BI takes 'faith'?  

Whether you trust sales person 1 who prepared a report in Excel or their favourite BI tool based on the centralized data warehouse that has ingested the raw sales data, applied consistent rules to modify the data and provide it in an easy to use and understand model or sales person 2 armed with an exported sales report, Excel to modify the data and a data discovery tool to report accurately on last month's sales, you need to trust the initial data quality, interim transformation process and final aggregation and visualization. 


Neither process is wrong, but there are obvious benefits to each approach and organizations should take a bi-modal approach to leverage the strengths of each.

My experience working with clients supports this.  There are several types of people who work at organizations, but at a bare minimum, there are data analysts (those trained and experienced working with data) and data consumers (those who either lack this training and experience or simply don't have the time).  We are not moving forward if we expect those in the second category to supernaturally 'help themselves'.  

Monday, February 8, 2016

Dilbert Sensors IoT Big Data Employee Hat

We've been hearing a lot about Big Data for years and big data sources getting increasing attention these days are smart machines and sensors. 


Sensors, like the one in Dilbert's stylish hat, can be embedded in wearable technology, enhancing what traditionally has been low tech clothing with numerous data points to be harnessed to create new and better products and solutions, ultimately better serving customers and improving profits.




Now, back to work!
 

Thursday, January 7, 2016

Dilbert Spreadsheet Error Ethics

I feel compelled to post this latest Dilbert strip on spreadsheet errors, as a follow up to yesterday's post.
I suppose this same type of question could apply to machine learning and other advanced analytics that could also be easily misapplied.

Do you have spreadsheets with critical errors that you're overlooking because they give you the answers you want?


Or, perhaps you have error free spreadsheets that are manually updated periodically (every day, week, month, etc.) that are an inefficient use of time?

Either way, there are both Excel-based and non-Excel based solutions to help!

Wednesday, January 6, 2016

Dilbert Spreadsheet Errors

There have got to be more posts on the problems with Excel and spreadsheet errors than pictures of cats on FaceBook at this point.
But, now that Dilbert has chimed in, we all know the issues are real!