Pierre DeBois

Don't Toss Excel Out Just Yet

NO RATINGS
View Comments: Newest First | Oldest First | Threaded View
Pierre DeBois
User Rank
Blogger
Re: Long live Excel
Pierre DeBois   1/12/2012 10:12:31 AM
NO RATINGS
aaphril and Louis,

 

Thanks for the comments - it was probably a while before an Excel API could be considered.  Think about Microsoft and VBA as an example - they pulled VBA out of the Mac version for Excel, but placed it back again in the latest version. VBA is stilled used, but there were some limits in seeing its value.  Given that some businesses were storing data in Excel is revealing - it means that any sort of programming, VBA or API, was not given a due consideration.

Ariella
User Rank
Blogger
Re: Long live Excel
Ariella   1/12/2012 8:27:48 AM
NO RATINGS
@aaphil; @Louis Exactly!

Louis Watson
User Rank
Blogger
Re: Long live Excel
Louis Watson   1/12/2012 12:59:28 AM
NO RATINGS

No question Excel will continue to be vital to analyst of all skill sets and experience. As well it should be, it is a very powerful tool and still well worth learning.  

I agree with Ariella when she says that those who complain about Excel obviously don't know much about it.


aaphil
User Rank
Blogger
Re: Long live Excel
aaphil   1/11/2012 11:37:34 PM
NO RATINGS
Not to mention that many 'custom' solutions are built using the Excel API. So the native functionalities of the platform works for alot things, it's just a matter of knowing how to use it.

Shawn Hessinger
User Rank
Blogger
A question of flexibility
Shawn Hessinger   1/11/2012 10:19:24 PM
NO RATINGS
Pierre,

Excel remains a useful enough tool for working with data even if presentation and modeling tools change. In the end, I think it is a question of flexibility. If Excel remains easy to use in conjunction with other tools, I think it will remain an important tool in the foreseeable future.

Pierre DeBois
User Rank
Blogger
Re: Long live Excel
Pierre DeBois   1/11/2012 2:13:42 PM
NO RATINGS
Beth,

Per usual you get to core of it - cost can be a driver if something is familar and seems to be a nofix.  But what is slippery for many businesses is that they can become numbe to changes that could enhance a tool already used.  I mention Excel because it really was an eye openner as to how many analytic app for ti have been created, even for Excel for Mac.  And many small businesses are still learning how having familar software like accounting applications, project management applications, and email are on the cloud, so there is a convenience in delivering services not avialable before

Pierre DeBois
User Rank
Blogger
Re: Long live Excel
Pierre DeBois   1/11/2012 2:05:43 PM
NO RATINGS
Ariella,

Thanks for the post. Much of the difficult stems from using Excel as a data storage in some firms early on. I think most by know understand that there's Access. let along other databases that are better equipped for long-term data management.  But as I wrote, much of that overlook comes from misuse of what a spreadsheet can do.

Ariella
User Rank
Blogger
Re: Long live Excel
Ariella   1/11/2012 12:15:12 PM
NO RATINGS
On another board I participate in, I've seen many negative views of Excel. The posters indicate that the only way to go is to get custom software. But I question if they really know what Excel is capable of. Sure, if you buy the software specialized for your industry, it will seem to be the best choice, but many of the functions built into such programs are already available on Excel.

BethSchultz
User Rank
Blogger
Long live Excel
BethSchultz   1/11/2012 8:25:29 AM
NO RATINGS
Yesterday I posted a blog that talked, among other things, about the mainframe's lasting stature in the enterprise -- despite repeated doomsday predictions. Now I know Excel and mainframes are two highly different animals, but I think the point remains the same. I don't expect to see the end of the venerable spreadsheet any time soon in the enterprise. Yes, other business tools and more advanced analytics capabilities will supplement and complement Excel's use -- but from some folks, especially within companies creating a culture of data-driven decision-making, Excel will be a hanger-on. 

 

Information Resources
More Blogs from Pierre DeBois
Mobile moves to the forefront in analytics and Google's search algorithm plans, and that means you have to think about how your website's architecture serving the needs of the mobile world. Take a peek at what Google plans for April.
Data scientists are discovering R programming as an augment in data visualization and analysis.
Analytics solutions are making cohort analysis easier to implement, and customers easier to discover.
For all the benefits a company can achieve by doing marketing analytics well, there are pitfalls if that effort proves invasive in the customer's view.
Customer behavior is becoming more sophisticated online. To identify and respond to the behavior, new coding and advanced spreadsheet automation can help.
Radio Show
Radio Shows
UPCOMING
James M. Connolly
Predictive Analytics Create a New World of Marketing


3/31/2015   REGISTER   1
ARCHIVE
James M. Connolly
Sports Analytics Mean Fun and Business


3/24/2015  LISTEN   4
ARCHIVE
James M. Connolly
Secure Your Big Data in the Cloud


2/26/2015  LISTEN   114
ARCHIVE
James M. Connolly
Make It Big As a Data Scientist in 2015


2/11/2015  LISTEN   106
ARCHIVE
James M. Connolly
Big Data, Decisions & the Simulated Experience


2/3/2015  LISTEN   87
ARCHIVE
James M. Connolly
A Chat About Big Data, Machine Learning & Value


1/15/2015  LISTEN   125
ARCHIVE
Curtis Franklin Jr.
An Infrastructure for Analytics


12/18/2014  LISTEN   63
ARCHIVE
James M. Connolly
Prepare for the Internet of Things Data Blitz


12/16/2014  LISTEN   50
ARCHIVE
James M. Connolly
How Mature Is Your Analytics Program?


11/18/2014  LISTEN   148
ARCHIVE
James M. Connolly
Drive Big Decisions Using Data & Analytics


11/10/2014  LISTEN   73
ARCHIVE
Beth Schultz
Data Science & the Data-Driven Culture


10/30/2014  LISTEN   134
Information Resources
Infographic
Infographic
It Pays to Keep Insurance Fraud in Check
While 97% of insurers say that insurance fraud has increased or remained the same in the past two years, most of those companies report benefits from anti-fraud technology in limiting the impact of fraud, including higher quality referrals, the ability to uncover organized fraud, and improve efficiency for investigators.
Follow us on Twitter
Follow us on Twitter
Like us on Facebook
Like us on Facebook
Quick Poll
Quick Poll
About Us  |  Contact Us  |  Help  |  Register  |  Twitter  |  Facebook  |  RSS