We hear a lot about how AI will replace data analysts. The headlines are dramatic, and the predictions are bold. But if you work in this field, you know the reality on the ground is quite different: we’re still swamped with work and insights to deliver. There’s no doubt that things are changing, and they’ll keep changing at an accelerating pace. But the function of data analysis is far from dead in organisations of any size, whether you’re a small business or a large enterprise.

When we talk about data analytics as an organisational function, we simply mean it’s something everyone needs but can’t do themselves. It requires dedicated people or teams with the capabilities to properly analyse data and turn it into useful insights. This need hasn’t disappeared – it’s evolved and, in many ways, intensified as data becomes more central to business decisions.

How Data Analytics Has Evolved Over the Years

Data analytics has definitely changed over the years, and the transformation has been remarkable. It started with simple Excel analysis, where you needed to be fairly computer-savvy just to understand what was going on with formulas, pivot tables, and data management. Then came dashboard tools that made it much easier to visualise and describe the numbers, turning raw data into something decision-makers could actually use. More recently, we’ve seen increasingly advanced tools that require specialists to use effectively – Python, R, SAS, and other analytical platforms that offer powerful capabilities but come with a steeper learning curve.

Each wave of technology hasn’t replaced the previous one entirely. Instead, it’s added new layers of capability and complexity to the field. The fundamentals of good analysis remain the same, but the tools and expectations have expanded significantly.

Why Accessible Tools Haven’t Reduced Demand

Just because everyone can use Excel doesn’t mean data analysts are no longer needed. In fact, it’s exactly the opposite. The field is growing precisely because more people understand what’s possible with Excel and modern dashboard tools like Power BI, Google Looker, and Tableau. This wider understanding has actually increased demand, not reduced it. Business leaders now know what good data analysis looks like, which means they want more of it, done better, and faster.

When more people in an organisation can work with data at a basic level, it doesn’t eliminate the need for specialists. Instead, it raises the bar for what analysis needs to deliver. The questions become more sophisticated, the expectations higher, and the need for expertise more critical.

Think of it like web development. Despite tools like Wix, WordPress, and Shopify making basic websites accessible to anyone, professional websites can still cost over $100,000. Why? Because of the expertise required and the complexity of work involved when you need something truly tailored and effective. The same principle applies to data analytics. DIY tools handle the simple cases, but they can’t replace deep expertise when it really matters.

What AI Can’t Replace in Data Analysis

Here’s the thing: people can now easily find certain figures or ask an AI chatbot what last year’s sales were. The technology is impressive, and it’s genuinely useful for quick answers to straightforward questions. But validation, drilling down into the details, understanding context, and the creativity and experience needed to create new insights – that’s still firmly in the hands of skilled data analysts.

AI can retrieve information, but it can’t question whether that information is correct. It can’t spot the anomaly that signals a data quality issue. It can’t bring years of industry experience to bear on interpreting what the numbers really mean for your business. And it certainly can’t challenge assumptions or ask the uncomfortable questions that lead to breakthrough insights.

The tools may change, and they’ll continue to evolve. But the need for skilled analysis, critical thinking, and business understanding remains as strong as ever.

Get Support with Your Data Strategy

If you’re navigating the changing landscape of data analytics and want practical help bringing clarity to your data:

• Join our next online event to learn practical approaches to data and BI: Excel in BI Events
• Reach out for a conversation about your specific data challenges: Contact Us
• Explore our YouTube channel for actionable insights on data analytics and business intelligence: Excel in BI YouTube Playlist