Comments
View Comments: Newest First | Oldest First | Threaded View
<<   <   Page 2 / 2
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.

Jessica Davis
User Rank
Blogger
Cultural resistance
Jessica Davis   1/6/2017 10:46:36 AM
NO RATINGS
In this particular case, I wonder if this is a matter of cultural resistance to giving up control. The manager is using Excel and forcing his employees to use it. What would it take to persuade him that a different approach would be better? Would he need to have control (and mastery) over that other platform? Or does he need to experience the pain of what goes wrong when you use an inadquate tool before he would consider alternatives?
Has anyone out there succeeded in this kind of persuasion before?

SaneIT
User Rank
Data Doctor
Re: Excel's role has changed
SaneIT   1/6/2017 9:01:52 AM
NO RATINGS
I think there are two issues here.  The first is using Excel as a database, the second is using it as a reporting tool.  The larger of the two issues is using it as a database and it is one of my biggest pet peeves when I see data duplicated into a hand entered Excel file.  Less frightening is Excel as a reporting tool.  Using data connectors to get your data from an actual database eases that issue but as noted in the article some times the crazy formulas used in Excel can make a real mess.  I instruct people that if they find themselves doing weird math tricks that the more appropriate method is building a view on the database server to do that math.  That way there's no fiddling with things and trying to make data sets match up.  No offense intended to the data professionals who work outside of an IT team but you really should have a great relationship with your database guys, learn to speak their language and you'll be amazed at how helpful they'll be.  They live for this kind of thing even you're in an organization that is filled with red tape I'm sure they would rather give you the data you need in a format you can use than watch you try hammering square pegs into round holes. 

 

Zimana
User Rank
Blogger
Re: Change resistant
Zimana   1/5/2017 4:20:04 PM
NO RATINGS
True, sometimes professionals are resistant to change.  We have to know our tools are reliable and fit our process to tackling tasks. Excel has been around long enough to build resistance to more advanced tools, even if those tools are really not as complaex as they used to be.  It's like assuming a car still has a carburetor and warms up slowly, when really fuel injection and better engine management is actually in place (as well as better experience).

T Sweeney
User Rank
Blogger
Change resistant
T Sweeney   1/5/2017 2:26:57 PM
NO RATINGS
It's not a perfect analogy, but an accountant I worked with years ago had a bookkeeping program she treasured that used MS-DOS. Which even in the summer of 2001 when she insisted I use it was a bit retro.

Our brains are resistant to change; I see my own tendencies here ("Another social media platform to learn/post to?" grumble grumble grumble). A function of age? Technology fatigue? probably some combo.

Zimana
User Rank
Blogger
Excel's role has changed
Zimana   1/5/2017 11:11:28 AM
NO RATINGS
Most managers don't realize that plugins and other tools have morphed excel's role as being more than a spreadsheet, yet definately not a replacement for a database. Tools like Neo4j are also overlooked - the interfaces on those tools are more people-friendly.  I think the interface on excel is what draws people - it's a spreadsheet and familiar to the most unsavvy professional. Says something about innovation of professionals - it's low - but also attest to how good that interface was.

<<   <   Page 2 / 2


Latest Blogs
Visualizations help communicate the meaning behind analytics to a variety of users. Now virtual reality is taking that a step further.
You've heard all about the data science talent gap that McKinsey cited in 2011, but there's a lot more -- including new information -- that you need to know about McKinsey's ongoing research. Learn more Thursday on All Analytics Radio.
What hybrid automobile offers the highest MPG? It's not the Prius anymore. Take a look at these visualizations to find out the new leader.
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.
Radio Show
A2 Conversations
ARCHIVE
Jessica Davis
Analytics: Make the Most of Data's Potential in 2017


1/19/2017  LISTEN   19
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
Information Resources
Quick Poll
Quick Poll
About Us  |  Contact Us  |  Help  |  Register  |  Twitter  |  Facebook  |  RSS