InvestmentNews takes advisers through the developments and innovations in technology that'll change the way you do business today and tomorrow.

Microsoft Excel in the age of Big Data

How are traditional data tools adapting to this bold new era of BIg Data?

Jan 6, 2014 @ 9:25 am

By Lowell Putnam and Niko Karvounis

Let's face it, Big Data is one of the most overused buzzwords today — but hype or no, Big Data is real and it's powerful. The ability to quickly crunch large volumes of data in real-time and generate results truly transforms how advisers, analysts, investors and businesses work. Which got us thinking — how are traditional data tools adapting to this bold new era? We're thinking specifically about a program that we've all used: Microsoft Excel.

Savvy analysts and investment managers swear by Excel, and with good reason — there's a lot of to love about it, and it's certainly one of our customers' favorite tools. Unfortunately, their giant spreadsheets don't quite qualify as Big Data (even if they do sometimes clock in at multiple megabytes). And while no one can dispute Excel's usefulness, the program has some traits that lag behind recent innovations in data science.

True Big Data horsepower requires capabilities in all of the following areas:


Today's Big Data horsepower can generate insights and analyze patterns with an efficiency and “aha”-inducing elegance that was once impossible. In contrast, while Excel is a great calculation and analysis tool, it's not really built for creative querying or automatically highlighting notable trends.


Excel is old school in that it's purely two dimensional (rows and columns). With today's databases, data can be organized and assessed along multiple dimensions, using a number of intersecting variables. As data becomes easier (and cheaper) to work with, the notion of manually processing data in a 2-D grid will become increasingly difficult for users to swallow.

Data Visualization

While Excel allows users to build charts, that process is often extremely painful. Mislabeled axes or garbled data have caused us all chart heartburn; and worse, the resultant graphs often look clunky or cheesy. Today's advances in technology and techniques around data visualization mean there's no reason to suffer graphics that aren't easily customizable, intuitive, and beautiful.

Fat Finger Protection

Entering massive amounts of data in Excel is simply mind-numbing. Oftentimes, one wrong input can mess up your whole model, leaving you scouring multiple worksheets for the single guilty typo. Today, that data extraction, aggregation, and checking/cleaning process can be automated … and should be!

Learning Curve Efficiency

Excel can do a lot, but odds are that you don't know how to take advantage of most of it. The level of training and outright dedication that Excel often demands is uniquely daunting. With everything we know about user best practices and interactive data design today, these barriers to usability seem unnecessary and downright counterproductive.

Don't get us wrong, we're Excel fanatics. In fact, Excel is open in the background as we write this (two books, twelve sheets, vlookups as far as the eye can see). But we're also big believers in Big Data, and in making data science as reliable and accessible as possible.

As best practices evolve — and the role of software in investors' and analysts' workflows grows – the odds are that the next must-have tool won't look all that much like Excel. Instead, 21st-century analysis tools will do more to guide investors to notable patterns in data sets, automate complex calculations, and bridge the gap between dense number-crunching and at-a-glance, multi-dimensional insights.

Lowell Putnam and Niko Karvounis are co-founders of Quovo, an investment insights company that reimagines sophisticated portfolio analytics and data management tools for investors.


What do you think?

View comments

Recommended for you

Featured Research

The 2015 InvestmentNews Adviser Technology Study

This in-depth study provides a blueprint for the industry, providing actionable information to advisers, along with the latest solutions to help them drive profitability, efficiency and growth for their firm.

Featured video


Why broker-dealers are on a roll

Deputy editor Bob Hordt and senior columnist Bruce Kelly discuss last year's bounce-back for IBDs.

Latest news & opinion

Top 10 IBDs ranked by revenue

These independent broker dealers generated the most revenues in 2017.

8 podcasts advisers listen to when they aren't working

Listening to podcasts for the fun of it.

UBS continues to cut loans to recruits, while increasing compensation to brokers

The wirehouse reduced recruitment loans 20% and increased bonus loans 68% in the first quarter.

Things are looking up: IBDs soared in 2017

With revenue up, interest rates rising and regulation easing, IBDs are soaring.

SEC advice rule may give RIAs leg up over broker-dealers

Experts say advisers will be able to point to their role as fiduciaries as a differentiator in the advice market.


Hi! Glad you're here and we hope you like all the great work we do here at InvestmentNews. But what we do is expensive and is funded in part by our sponsors. So won't you show our sponsors a little love by whitelisting It'll help us continue to serve you.

Yes, show me how to whitelist

Ad blocker detected. Please whitelist us or give premium a try.


Subscribe and Save 60%

Premium Access
Print + Digital

Learn more
Subscribe to Print