Tricia Aanderud

Excel is Still Not an Enterprise Reporting Solution

NO RATINGS
View Comments: Newest First | Oldest First | Threaded View
Page 1 / 3   >   >>
Zimana
User Rank
Blogger
Re: Cultural resistance
Zimana   1/30/2017 12:04:19 PM
NO RATINGS
Not unusual for directors to not know how to use the software that employees are suppose to know and be SME on.  You touch upon a critical aspect - that small business is really impacted by leadership with limited practical knowledge on software essential for tactics and strategy.

Zimana
User Rank
Blogger
Re: Change resistant
Zimana   1/30/2017 11:31:46 AM
NO RATINGS
Good point Joe about misuse. It speaks to the idea about how tools can be misused by being mistrained on their usage. Excel is not for every situation, but like many spreadsheets, its value depends on the user intent and information contained in the file. It is possible to poorly train people on how to use the full capabilities of a software and extract value. 

SethBreedlove
User Rank
Data Doctor
Re: Cultural resistance
SethBreedlove   1/30/2017 1:01:31 AM
NO RATINGS
When  I worked for major tech company the scenior director who was in charge of user experience and had been with the company for 25 years did not even have the basic understanding of Excel.  

Now let's talk about smaller companies where that is just the norm.  Sadly, the most advance analytical solution is the lowest common demonitor of expertise. 

magneticnorth0
User Rank
Data Doctor
Re: Cultural resistance
magneticnorth0   1/29/2017 12:40:13 PM
NO RATINGS
Now that you mention it, Joe, I realize that learning how to draw ERDs might actually be more valuable than learning program logic. Tools like Airtable make it easier to build databases for practically anything, but what use would the tool be if the user can't design a database structure? On the other hand, while I love the intellectual rigor of programming, it's hardly ever useful to a person who doesn't do it for a living.

magneticnorth0
User Rank
Data Doctor
Re: Cultural resistance
magneticnorth0   1/29/2017 12:30:28 PM
NO RATINGS
@Tricia In my experience, it's the boss's boss who calls him out. Not learning technology that the company has decided to use is a perfirmance issue.

Broadway0474
User Rank
Blogger
Re: Cultural resistance
Broadway0474   1/28/2017 12:31:13 AM
NO RATINGS
Hey @Joe, how about we just not load Excel onto people's computers from day 1. If they don't have it, they can't use it, no?

James Connolly
User Rank
Blogger
Re: Cultural resistance
James Connolly   1/26/2017 4:10:28 PM
NO RATINGS
@Joe. I wonder if it's the company that clings to Excel as a reporting tool or the individuals who have used for everything over the years and can't let go.

Joe Stanganelli
User Rank
Blogger
Re: Cultural resistance
Joe Stanganelli   1/26/2017 11:14:45 AM
NO RATINGS
@TriciaAA: At the end of the day, I believe that you'll inherently have more trouble getting companies to switch to a different tool -- which will require added investment and training -- than in getting companies to implement more/better training on the tools they're already using.

And then, if you're especially clever, assuming you do a good job on the training, you can drop hints in that training process and the planning and post-mortem processes as to how other tools can do even more and/or do things better...and then get interest that way.

Joe Stanganelli
User Rank
Blogger
Re: Cultural resistance
Joe Stanganelli   1/25/2017 10:45:46 AM
NO RATINGS
@Broadway: As the old saying goes, leave it to man to blame the problems of his feet on his shoes.

Pardon me for saying so, but it seems to me that, by that logic, whenever somebody does something stupid and isn't paying attention and accidentally hurts themselves in a workshop with a bandsaw or other power tool, we should start seriously discussing a ban on power tools in workshops.

Tools of any kind require knowledge and a certain degree of training (even if it's just a few minutes of "DO IT LIKE THAT" and "NEVER DO THIS").  If you don't have training on, say, R (which is super powerful and nifty and open source and all that fun stuff, but also is--I'm sorry--NOT intuitive to use) or SAS or whatever, you're gonna screw that up too.

FWIW, I remember being taught how to use Excel in high school.  The teacher, walking behind us once, stopped behind me, looked at my screen and what I was doing, and marveled at how far I had gotten in an assignment -- and by doing things that he had not taught us yet.

He asked me how I knew how to do what I had just done.

I said, somewhat sheepishly, "I didn't.  I just clicked on Help."

At that point, he stopped the entire class, got everyone's attention, and spent the next minute or two emphasizing the importance of what I had just done -- clicking on Help.

Sorry, but you won't convince me that this stuff is hard.

And Microsoft Office is ubiquitous.  So there's really no excuse for not learning the fundamentals if you're going to work in an office environment.

Moreover, MSFT Office technology hasn't changed too much since my high school days.  On a side note, therefore, I'd humbly suggest that we'd do better to have better computer and technology training in the public-school classroom than spend so much time focusing on the standard stuff that nobody ever needs to know (absent it being a key part of their profession) and everybody forgets in a year anyway.

Broadway0474
User Rank
Blogger
Re: Cultural resistance
Broadway0474   1/22/2017 9:21:03 AM
NO RATINGS
But Joe, if users commonly have problems with a tool, isn't it an indication that the tool isn't easy to use, and if so, not such a good tool? If a tool is meant to be used widespread --- and Excel is on nearly every computer at work --- shouldn't it be designed for ease of use?

Page 1 / 3   >   >>
Information Resources
More Blogs from Tricia Aanderud
Where did all the election predictions go so wrong? And, what does the failure of analytics to predict the Trump victory mean to the future of big data?
Election blather just might be turning people off from their social media use. Do you read? Do you turn off? Do you blather?
When presenting data it's easy to stay focused on the number. But remember that there are real people with real concerns and emotions behind those numbers.
While pretty pictures as reports look nice -- and easy to understand -- for an analyst, the consumer of that data might sit there and say, "Huh?"
Radio Show
A2 Conversations
UPCOMING
Jessica Davis
Data Analysts in Training: Meeting Tomorrow's Demand


3/8/2017   REGISTER   0
ARCHIVE
Jessica Davis
Our Bodies, Our Data: Medical Records For Sale


2/21/2017  LISTEN   62
ARCHIVE
Jessica Davis
Energy Analytics: Using Data to Find Savings


2/14/2017  LISTEN   44
ARCHIVE
Jessica Davis
Sharpen Your Analytics & Data Management Strategy


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