Comments
View Comments: Newest First | Oldest First | Threaded View
Page 1 / 2   >   >>
Joe Stanganelli
User Rank
Blogger
Re: Cultural resistance
Joe Stanganelli   1/14/2017 2:58:02 PM
NO RATINGS
@SaneIT: Without championing Excel, there are some problems with this argument.

For instance, Tricia writes:

"A co-worker did not understand how to use the formulas correctly, which resulted in the wrong totals being reported. The list continued and most of it was related to lack of skill or attention to detail."

So...the problem was other people's stupidity, poor training, and inattention.  Let's not blame the hammer because the carpenter bashed it against his head instead of the 2x4.

And to your point: "it's working, stop messing with it" -- well, if I was an Excel-using manager watching my employees constantly screw it up, I'd take that attitude too!

> " In this case what the manager probably needs is a handful of examples that show how often the data is wrong and the problems that it causes."

That certainly works for some people, but let's remember, of course, that anecdotal evidence is not the plural of science.

Excel is a tool with its uses.  There are far more advanced tools that can do really nifty things and are more user-friendly, to be sure, but let's not dump all over Excel simply because certain people don't know how to read a formula.







kq4ym
User Rank
Data Doctor
Re: Cultural resistance
kq4ym   1/14/2017 10:42:01 AM
NO RATINGS
Habit and attempts to save money are not easy to overcome even when shown it's fighting against us. The managers who keep the old ways even when in the case of Excel, will eventually see the real problems in getting accruracy around the department and among departments when everyone has there own data collecting and recording favorite method.

Joe Stanganelli
User Rank
Blogger
Re: Change resistant
Joe Stanganelli   1/11/2017 11:59:18 AM
NO RATINGS
> Misusing Excel

There's the key in all of this.  Misuse.

Excel certainly isn't the best tool for everything, or even most things, but it can be a darn useful tool at times.  Additionally, all those tales of woe of people misunderstanding or screwing something up can be fixed by training and even by technology solutions (for instance, there are many ways to lock formulas and prevent editing).

For the sake of argument, I would posit that *one* advantage Excel offers (other than the obvious: being ubiquitous and low cost) is that -- unless you're lazy or not paying attention (which, unfortunately, is most people a lot of the time) -- it tends to compel understanding if you want to do anything useful with it or glean anything insightful from it (albeit not necessarily in the most efficient or effective way).

Conversely, a lot of GUI-based, "plug-and-play" solutions tend to impede true understanding when it comes to the "behind the scenes" of data reporting and data analysis -- as I've written about for A2 previously, here: allanalytics.com/author.asp?section_id=1408&doc_id=241161

James Connolly
User Rank
Blogger
Re: Change resistant
James Connolly   1/10/2017 10:12:47 AM
NO RATINGS
@Tricia. Misusing Excel in terms of collecting numerical data, customer names and the like is bad enough. Where I've developed headaches over the years is when someone uses Excel to collect just text-based forms data. So there might be 200 or more rows, each with columns for name, address, company, but then longer-form text entries of several hundred words. So, you end up reading what amounts to articles as someone describes a learning experience, an issue with their manager, or a problem with a product, etc.

When people are completing qualitative surveys some of those rows extend from "A" and "B" to "ZZ". They expect us to read that way!

PredictableChaos
User Rank
Prospector
Re: Change resistant
PredictableChaos   1/9/2017 4:15:16 PM
NO RATINGS
@Tricia,

I'm frustrated just reading about this manager!  My first approach would have been to do the actual analysis is a better tool and drop the results out for presentation in a set of XLS charts.

Sounds like the manager was not only ignorant, but a micro-manager and would not have been happy to find out that Excel wasn't the actual source of the analysis.

Time to look for another position elsewhere. Given that the organization already has better tools, you might not have to go too far.

SaneIT
User Rank
Data Doctor
Re: Cultural resistance
SaneIT   1/9/2017 9:03:31 AM
NO RATINGS
I run into this not only as comfort but as "it's not broke, don't fix it" which is a tad bit short sighted because it's broken, they just don't realize it until way down the line.  In this case what the manager probably needs is a handful of examples that show how often the data is wrong and the problems that it causes.  These examples need to be brought along with the system/processes to prevent these errors.  Without those pieces the manager will likely continue down the path of "it's working, stop messing with it."

TriciaAA
User Rank
Prospector
Re: Change resistant
TriciaAA   1/9/2017 8:41:36 AM
NO RATINGS
IN this case the organization had some extremely advanced tools  and could have bypassed anyone doing work in the spreadsheet and simply had the end result output to XLS format.  It would have resolved the issues of calculating in the wrong columns, bad formulas, etc.

I guess it is resistance to change because why would you drink the magic elixer over continuing to suffer. 

TriciaAA
User Rank
Prospector
Re: Cultural resistance
TriciaAA   1/9/2017 8:27:27 AM
NO RATINGS
You make a good point @Jessica Davis.   The person describing this situation had pleaded with him to make the right decision. She was asking my advise on how to pull him toward a better tool. Every arguement we brainstormed she had already tried.

I believe the guy is stubborn. The only way you combat that situation is with upper management issuing a directive.  I don't think the person I spoke with thought that would provide any career enhancement for her.

Sad.

TriciaAA
User Rank
Prospector
Re: Cultural resistance
TriciaAA   1/8/2017 9:41:59 AM
NO RATINGS
I think that is the main problem - how do you move managers in particular out of their comfort zone? It is amazing to me that the person doesn't hold himself accountable for having accurate data. 

I feel like some kind of zealot.  Lol!

tomsg
User Rank
Data Doctor
Re: Cultural resistance
tomsg   1/6/2017 4:33:42 PM
NO RATINGS
I am guessing that this was all that was in his comfort zone. No amount of logic will move someone who just doesn't understand the technology. A move could only make him look bad ( or worse, ignorant).This is a real barrier in some organizations.

Page 1 / 2   >   >>


Latest Blogs
Understanding retail customers means knowing what they will want and when they will want it. To deliver that, retailers must be able to see customer behavior across physical stores, the web, mobile apps, and more.
Chatbots, AI, virtual reality, machine learning, and more will be featured as leading edge technologies for retailers attending the NRF Annual Convention and Expo in New York City. But many retailers are still getting their arms around advanced analytics.
Is your manager a help or a hindrance when it comes to your analytics work and initiatives?
Looking to find a new favorite beer? Check out these visualizations to track it down.
The rise of Amazon Alexa and Google Home introduce a new competitor for search engines -- IoT home devices with supporting AI. Here's how analytics planning must change to accommodate the new world.
Radio Show
A2 Conversations
UPCOMING
Jessica Davis
Analytics: Make the Most of Data's Potential in 2017


1/19/2017   REGISTER   0
ARCHIVE
Jessica Davis
A2 Radio: Can You Trust Your Data?


12/20/2016  LISTEN   70
ARCHIVE
James M. Connolly
Retail Analytics: See Where Style Meets Statistics


12/6/2016  LISTEN   53
ARCHIVE
James M. Connolly
Why the IoT Matters to Your Business


11/29/2016  LISTEN   45
ARCHIVE
James M. Connolly
Will Data and Humans Become Friends in 2017?


11/22/2016  LISTEN   40
ARCHIVE
James M. Connolly
We Can Build Smarter Cities


10/20/2016  LISTEN   31
ARCHIVE
James M. Connolly
Visualization: Let Your Data Speak


10/13/2016  LISTEN   70
ARCHIVE
James M. Connolly
How Colleges and Tech Are Grooming Analytics Talent


9/7/2016  LISTEN   56
ARCHIVE
James M. Connolly
How Machine Learning Takes Handwriting Recognition to New Levels


8/25/2016  LISTEN   40
ARCHIVE
AllAnalytics
A Look at Tomorrow's Data Scientist


8/9/2016  LISTEN   83
ARCHIVE
James M. Connolly
Analytics and the Making of a President


7/21/2016  LISTEN   76
Information Resources
Quick Poll
Quick Poll
About Us  |  Contact Us  |  Help  |  Register  |  Twitter  |  Facebook  |  RSS