4 Phases of Analytics Evolution: From Spreadsheets to AI Workbenches
Skip to content
Data Analytics Nov 5, 2021

4 Phases of Analytics Evolution: From Spreadsheets to AI Workbenches

What lies ahead for business leaders looking to incorporate data analytics?

person looks at data visualization on screens

Riley Mann

Many years ago, I went looking for some “desktop AI”—artificial intelligence that would allow me to tease out trends in data. I knew about IBM’s Watson, so I went to the website in hopes of uploading data and getting access to some machine learning. “That’s not how it works,” a friend who worked at IBM told me at the time. “You can’t just press a button and get AI.”

Add Insight
to your inbox.

That’s not the case anymore. Today, AI tools and workbenches allow you to click your way to some pretty advanced modeling techniques, without requiring any knowledge of coding or programming language. That’s certainly not to imply that everyone can be a data scientist. But business professionals today can have AI at their fingertips for making data-based projections. Sometimes, it’s as simple as clicking a button that says “predictor.”

To put this in perspective, let’s examine the four phases of data-analytics technology for the businessperson—three that brought us to this point, and one on what lies ahead.

Phase One—Simple Data Management

For years, businesses have been organizing information on spreadsheets—most notably Excel—to run analyses, such as summary statistics by group. Of course, to get value out of the tool, the user needed to understand the output; otherwise, the exercise was meaningless—and potentially dangerous when making decisions based on something not fully known or understood.

For example, back in the spreadsheet days, a data analyst might have compared customer purchasing behaviors across different groups or segments. Let’s say the analysis showed higher average purchasing among Segment 1 than Segment 2, which led to the conclusion that Segment 1 customers were more important to the business. A slightly deeper analysis of variability might reveal that Segment 2 customers were actually more consistent purchasers. That is, a better understanding of what the tool could produce yielded a more effective use of the tool.

While the spreadsheet was a great start for the everyday business professional’s analytic needs, it could be a blunt tool without the necessary nuances for deeper insights.

Phase Two—Powerful, but Inaccessible, Tools

The next phase brought advanced AI technology for analyzing data into the business-world mainstream. But until a few years ago, the most powerful AI analysis was limited to only the programmers and developers who built models with code. If someone wanted to compare 10 different models to see which one was most effective at predicting an outcome, it would be necessary to write code for 10 different models.

Phase 3—Powerful, Accessible AI Workbenches

Today’s new consumer-facing tech tools combine powerful algorithms with great user interfaces. Unlike the Phase 2 tools, AI workbenches no longer require knowledge of coding to build many AI models. Additionally, the best AI workbenches easily run many models simultaneously and identify the best model for the data.

What remains unchanged from the earliest days of simple data management, however, is the importance of understanding the outcome. When an algorithm produces a result, there are right and wrong, simple and nuanced, ways of using that result.

Business professionals today can have AI at their fingertips for making data-based projections.

— Joel Shapiro

Returning to the example of the customer segments, if an AI model indicates that a certain customer segment is likely to increase in value, humans still need to decide what to do about it. Should they engage more with these customers to ensure a good outcome occurs or keep the status quo because these customers are likely to lead to a good outcome on their own? In other words, it takes human expertise, and AI provides valuable inputs to supplement that expertise.

I recently saw this in action as I watched a business team making decisions of how to deploy sales-team talent and resources in the coming year. Without any formal data-science training, the team had built an AI-generated graphic that predicted with high accuracy the purchasing behaviors of AI-defined customer segments.

Five years ago, this same team would have needed an expensive external data-analytics resource to tackle this project. But more likely, they would never have thought about building a predictive model in the first place. Today, though, this analysis is part of how they do business.

A recent Harvard Business Review article stated that the digital transformation that has emerged from the Covid pandemic has shown the importance of data analytics and AI for business leaders. It cited a recent survey by The AI Journal that found 72 percent of business leaders believe AI will play a positive role in the future.

The question, then, is what the future of consumer-facing AI tools will look like.

Phase 4—The Next Frontier of Analytics Tech

As we look ahead, a new frontier of productivity is emerging as analytics insights are integrated into everyday business processes and workflows. Currently, common “desktop AI” tools can show how various factors relate to outcomes; therefore, it would not be a heavy computational lift to take the next step and use those relationships to prescribe some optimal mix of inputs. To be clear, I don’t just want to see what’s behind the models (that is, “glass box AI”); I want the model to show me the optimal mix of inputs for all potential outcomes, and to tie that to the benefits of being right and the costs of being wrong for my specific decision.

My wish list for the future would also include improvements in the integration of data. Increasingly, AI is getting better with relevant external data. This seems to indicate a future market boom around AI’s ability to identify valuable external datasets, and easily integrate and configure them.

From there, it’s natural to imagine a suite of decision-making tools that can be truly customized, putting the power of AI tools at business professionals’ fingertips. This won’t turn them into data scientists, nor will it dilute the value of professional data scientists. However, more seamless integration of AI into everyday business will increase its value and usability, provided that the outcomes are well understood.


This article originally appeared in Forbes.

Featured Faculty

Clinical Associate Professor; Academic Director of Executive Education

Most Popular This Week
  1. Will AI Eventually Replace Doctors?
    Maybe not entirely. But the doctor–patient relationship is likely to change dramatically.
    doctors offices in small nodules
  2. What Is the Purpose of a Corporation Today?
    Has anything changed in the three years since the Business Roundtable declared firms should prioritize more than shareholders?
    A city's skyscrapers interspersed with trees and rooftop gardens
  3. What Happens to Worker Productivity after a Minimum Wage Increase?
    A pay raise boosts productivity for some—but the impact on the bottom line is more complicated.
    employees unload pallets from a truck using hand carts
  4. 3 Tips for Reinventing Your Career After a Layoff
    It’s crucial to reassess what you want to be doing instead of jumping at the first opportunity.
    woman standing confidently
  5. Why We Can’t All Get Away with Wearing Designer Clothes
    In certain professions, luxury goods can send the wrong signal.​
    Man wearing luxury-brand clothes walks with a cold wind behind him, chilling three people he passes.
  6. Why You Should Skip the Easy Wins and Tackle the Hard Task First
    New research shows that you and your organization lose out when you procrastinate on the difficult stuff.
    A to-do list with easy and hard tasks
  7. Which Form of Government Is Best?
    Democracies may not outlast dictatorships, but they adapt better.
    Is democracy the best form of government?
  8. 6 Takeaways on Inflation and the Economy Right Now
    Are we headed into a recession? Kellogg’s Sergio Rebelo breaks down the latest trends.
    inflatable dollar sign tied down with mountains in background
  9. How Are Black–White Biracial People Perceived in Terms of Race?
    Understanding the answer—and why black and white Americans may percieve biracial people differently—is increasingly important in a multiracial society.
    How are biracial people perceived in terms of race
  10. When Do Open Borders Make Economic Sense?
    A new study provides a window into the logic behind various immigration policies.
    How immigration affects the economy depends on taxation and worker skills.
  11. How Old Are Successful Tech Entrepreneurs?
    A definitive new study dispels the myth of the Silicon Valley wunderkind.
    successful entrepreneurs are most often middle aged
  12. How Has Marketing Changed over the Past Half-Century?
    Phil Kotler’s groundbreaking textbook came out 55 years ago. Sixteen editions later, he and coauthor Alexander Chernev discuss how big data, social media, and purpose-driven branding are moving the field forward.
    people in 1967 and 2022 react to advertising
  13. Why Do Some People Succeed after Failing, While Others Continue to Flounder?
    A new study dispels some of the mystery behind success after failure.
    Scientists build a staircase from paper
  14. How to Get the Ear of Your CEO—And What to Say When You Have It
    Every interaction with the top boss is an audition for senior leadership.
    employee presents to CEO in elevator
  15. Understanding the Pandemic’s Lasting Impact on Real Estate
    Work-from-home has stuck around. What does this mean for residential and commercial real-estate markets?
    realtor showing converted office building to family
  16. Immigrants to the U.S. Create More Jobs than They Take
    A new study finds that immigrants are far more likely to found companies—both large and small—than native-born Americans.
    Immigrant CEO welcomes new hires
  17. Podcast: What to Expect When Joining a Family-Owned Business
    There are cons—but a lot of pros, too. On this episode of The Insightful Leader, we’ll explore what it’s like to work at a family business when you’re not a family member.
More in Data Analytics