Microsoft Excel has been one of those products to which professionals have grown accustomed in the workplace, like paperclips and the pencil sharpener. Despite inroads from alternatives such as Google Docs, OpenOffice, and Zoho, Excel continues to be a widespread standard of business documentation software.
Yet Excel usage may be changing, making me wonder if we need to rethink the increasingly common belief that, in this day of advanced analytics, spreadsheet use should be deleted like a useless file. A renewed value of spreadsheets has been stirring and cultivating lately, thanks to the intensity of analytics demand in business. As companies look to compile data in a presentable format, we've seen new ways to import data into Excel. Much of this changes how we use spreadsheets, a tool which may have grown more desirable because of its familiarity in business settings.
Excel owes its swagger to two factors: the competitive environment and improved plugins for feature enhancement.
With the rise of competitive office suites from the likes of Google, OpenOffice.org, and Zoho, Microsoft has had to step up with similar features. Office365, an online collaborative version of Microsoft’s email, Web conferencing, documents, and calendar software is the result. Spreadsheets now provide more collaborative features among multiple users, removing concerns of maintaining “that one sheet” containing the right financial model or the correct data for a chart.
Meantime, Excel has long been able to import data from external sources, though essentially Microsoft Access and SQL. Yet new plugin programs have permitted additional data integration from sources such as Web analytics solutions. For example, Excellent Analytics, a free plugin, imports Google Analytics data while GA Data Grabber provides additional data import from paid search platforms AdWords and AdCenter.
Even Microsoft has provided further plugin program development. For example, its Advertising Intelligence plugin links Excel to Microsoft AdCenter paid search manager -- users can easily download Bing paid search data and perform keyword research outside of an AdCenter. And Microsoft Business Intelligence released a fuzzy search plugin that cleans dirty data through cell searches for user-specified text string arguments.
The end result is that critics should update their data management advice with respect to the spreadsheet. Separate, ad-hoc analysis is being replaced with the opportunity for presentational analysis of unstructured data. Plugin developers have a clear understanding of this potential refresh of spreadsheet value.
As Lars Johansson, one of the developers of Excellent Analytics, noted: “Well, at the end of the day, data usually end up in Excel at some point anyhow. Excel is adopted by a wide range of users, even the less technically inclined. Therefore Excel is a tool for data democracy.”
The new means to collaborate can encourage teams to discuss what data needs to be presented. There is also a better chance at managing the main copy instead a sole copy on a laptop.
Some general liabilities in using a spreadsheet remain, but most are linked to use-related causes. Databases are still the best places for storing data long term, and, even with cloud capabilities increasing their convenience, spreadsheets maintain a limited capacity for large datasets. Maintaining secure access to data in a spreadsheet also can be problematic, as companies grapple with how to keep data proprietary while still convenient to present.
Nonetheless, my point is that as we begin to reexamine our tools, it may be high time to give props to the lowly spreadsheet. It has come a long way since Visicalc, the first commercial spreadsheet software, and for many companies it will go a long way to meeting the data management challenges that lie ahead.
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.
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.
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
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.
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.
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.
Diego Klabjan, chair of the INFORMS University Analytics Program Committee and program director for Northwestern University's Master of Science in Analytics program, gives his advice for figuring out where to get an advanced analytics degree.
What Works: Open Source Analytics Software International Institute for Analytics WebinarOn Wednesday, Sept. 24, join IIA CEO and Co-Founder Jack Phillips, along with featured guest Gary Spakes, as we explore the five modernization stages that analytics hardware/software have experienced. We will discuss the considerations when calculating total cost of ownership of the analytics ecosystem.
2014 VA Interactive Roadshow -- Cary, NCThe 2014 VA Interactive Roadshow will feature SAS® Data Management and SAS® Visual Analytics experts covering topics like prepping data for VA and VA integration with SAS® Office Analytics. This year's events will keep presentations at a minimum and focus on giving attendees hands-on exposure to the latest version of VA.
Essential Practice Skills for Analytics Professionals Drawing on best practices from the field, this INFORMS course helps analytics professionals add value from beginning to end: listening to clients, framing the central problem, scoping a project, defining metrics for success, creating a work plan, assembling data and expert sources, selecting modeling approaches, validating and verifying analytical results, communicating and presenting results to clients, driving organizational change, and assessing impact.
Analytics 2014 The Analytics 2014 Conference is a two-day, educational event for anyone who is serious about analytics. This annual event brings together hundreds of professionals, industry experts and leading researchers in the field of analytics. All Analytics members save $500 on conference fees by using promo code ACAA.
Premier Business Leadership Series 2014 The Premier Business Leadership Series is an exclusive event for senior executives and decision makers that focuses on solving the current issues that affect governments and businesses globally. The Series is a unique learning and networking experience focused on the most innovative leadership strategies and analytic solutions for competing in todayâ€™s global economy.
2014 VA Interactive Roadshow -- BostonThe 2014 VA Interactive Roadshow will feature SAS® Data Management and SAS® Visual Analytics experts covering topics like prepping data for VA and VA integration with SAS® Office Analytics. This year's events will keep presentations at a minimum and focus on giving attendees hands-on exposure to the latest version of VA.
Data Exploration & Visualization Get hands-on training that focuses on the critical steps in the process of analyzing data: accessing and extracting data, cleaning and preparing data, exploring and visualizing data. This INFORMS course will use several of the most popular software tools intensively, and provide an overview of the range of software options.
Foundations of Modern Predictive Analytics In this INFORMS course, learn about modern predictive analytics, the science of discovering and exploiting complex data relationships. This course will give participants hands-on practice in handling real data types, real business problems and practical methods for delivering business-useful results.
2014 VA Interactive Roadshow -- AtlantaThe 2014 VA Interactive Roadshow will feature SAS® Data Management and SAS® Visual Analytics experts covering topics like prepping data for VA and VA integration with SAS® Office Analytics. This year's events will keep presentations at a minimum and focus on giving attendees hands-on exposure to the latest version of VA.
LEADERS FROM THE BUSINESS AND IT COMMUNITIES DUEL OVER CRITICAL TECHNOLOGY ISSUES
The Current Discussion
Visual Analytics: Who Carries the Onus? The Issue: Data visualization is an up-and-coming technology for businesses that want to deliver analytical results in a visual way, enabling analysts the ability to spot patterns more easily and business users to absorb the insight at a glance and better understand what questions to ask of the data. But does it make more sense to train everybody to handle the visualization mandate or bring on visualization expertise? Our experts are divided on the question. The Speakers: Hyoun Park, Principal Analyst, Nucleus Research; Jonathan Schwabish, US Economist & Data Visualizer
The hospitality industry gathers massive amounts of customer data, and mining that data effectively can yield tremendous results in terms of improved CRM, better-targeted marketing spend, and more efficient back-end processes. Roger Ares, vice president of analytics at Hyatt Corp., discusses the ways he and his staff use big data.
Charged with keeping track of travel assets, including employees, iJET International relies on data management best-practices and advanced analytics to keep its clients in the know on current and potential world events affecting travel, Rich Murnane, Director of Enterprise Data Operations & Data Architect, told All Analytics in an interview from the 2014 SAS Global Forum Executive Conference.
Jason Dorsey, chief strategy officer for the Center for Generational Kinetics and keynote speaker at last month's SAS Global Forum 2014, describes how Gen Y professionals are enhancing the makeup of multigenerational analytics organizations.
From analytics talent development to the power of visual analytics, All Analytics found a variety of common themes circulating throughout the exhibition floor and session discussions at the 2014 SAS Global Forum and SAS Global Forum Executive Conference events held last month in Washington, DC.
Talking with All Analytics live from the 2014 SAS Global Forum Executive Conference, Eric Helmer, senior manager of campaign design and execution for T-Mobile, discussed the importance of customer data -- starting internally -- in devising the mobile operator's marketing plans.
The big-data analytics market can be a confusing place. Among the vendors vying for your dollars are traditional database management providers, Hadoop startup services, and IT giants. In this video, All Analytics editors Beth Schultz and Michael Steinhart sit down in a Google+ Hangout on Air with Doug Henschen, executive editor of InformationWeek. Henschen discusses use cases for big-data analytics, purchase considerations, and his recent roundup of the top 16 big-data analytics platforms.
At the National Retail Federation BIG Show last month, All Analytics executive editor Michael Steinhart noted a host of solutions for tracking and analyzing customer activity in retail stores. From Bluetooth beacons to RFID tags to NFC connections to video analytics, retailers must find the right combination of tools to help optimize the shopper experience, streamline operations, and boost revenues.
The days when historical shipment trends and gut feelings were enough to forecast retail demand accurately are long over. SAS chief industry consultant Charles Chase outlines the benefits of pulling real-time sales information from point-of-sale and product scanner systems, then flowing that data into dynamic forecasting tools from SAS.
With today's advanced visual analytics tools, you can stream data into memory for real-time processing, provide users the ability to explore and manipulate the data, and bring your data to life for the business.
Dynamic data visualizations let analysts and business users interact with the data, changing variables or drilling down into data points, and see results in a flash. Advance your use of data visualization with tools that support features like auto-charting, explanatory pop-ups, and mobile sharing.
No doubt your enterprise is amassing loads of data for fact-based decision-making. Hand in hand with all that data comes big computational requirements. Can traditional IT infrastructure handle the increasing number and complexity of your analytical work? Probably not, which is why you need a backend rethink. Big data calls for a high-performance analytics infrastructure, as Fern Halper, a partner at the IT consulting and research firm, Hurwitz & Associates, discusses here.
Redbox's bright-red DVD kiosks are all but ubiquitous these days, located in more than 28,000 spots across the country. Jayson Tipp, Redbox VP of Analytics and CRM, provides an insider's look at how the company has accomplished its phenomenal nine-year growth.
InterContinental Hotels Group (IHG), a seven-brand global hotelier, has woven analytics into the fabric of its operations. David Schmitt, director of performance strategy and planning, shares IHG's analytics story and his lessons learned.