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

+ Zoom

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


How politics are moving markets

The financial services industry stands at the unique intersection of politics and market fluctuation. Clients are anxious and the right adviser can steady he waters. Scott Kubie of Carson Group explains how.

Video Spotlight

The Search for Income

Sponsored by PGIM Investments

Recommended Video

Path to growth

Latest news & opinion

Finra ranking brokers in effort to crack down on industry's bad apples

All 634.403 reps have been ranked based on factors such as prior regulatory disclosures, disciplinary actions and employment history.

How to save retirement planning from tax reform

Losing big deductions, even in lieu of a larger standard deduction, may cause taxes to rise in retirement.

Advice firms in a tricky financial position

As revenue growth dips and salaries rise, nearly 90% of firms are at or near capacity.

In a turnaround, Wells Fargo Advisors sees slight bump in headcount

Racked by a scandal in its retail banking unit, Wells still managed to add 37 new advisers in the third quarter, a small number but an improvement nonetheless.

Social Security benefits to increase by 2% in 2018

Largest cost-of-living adjustment since 2012 may be offset for some by higher Medicare premiums.


Subscribe and Save 60%

Premium Access
Print + Digital

Learn more
Subscribe to Print