#369 How to Become a Top Business Intelligence Analyst | Helen Wall, Founder at Helen Data Design & Microsoft Influencer

2026-07-20 · Source: DataFramed · Field: Technology & Digital — Data Science & Analytics, Artificial Intelligence & Machine Learning · Depth: Intermediate, quick

Summary

Helen Wall, founder of Helen Data Design and a Microsoft-recognized business intelligence expert, discusses the distinctions between average and great BI analysts. The conversation highlights the "iceberg model" of analytics, where much critical work like data modeling and stakeholder communication occurs beneath the surface, unseen by users. Key topics include building and utilizing semantic layers, managing messy legacy projects, and creating documentation effective for both human understanding and AI agents. The discussion also covers the evolution of Power BI over five years, strategies for maintaining consistent and cost-effective AI outputs, and the emerging challenges of accountability in an agent-driven AI landscape. Wall emphasizes that technical skill is merely a starting point, with business understanding being equally crucial.

Key takeaway

For Business Intelligence Analysts aiming to advance beyond basic reporting, you must cultivate deep business understanding and master the unseen aspects of data work. Prioritize building robust semantic layers and comprehensive documentation that serves both human users and AI agents. This approach ensures your reports answer the right questions, improves data trustworthiness, and prepares you for accountability challenges in an AI-driven analytics future.

Key insights

Great business intelligence analysts prioritize understanding business needs and data context over mere technical execution.

Principles

• BI work is an "iceberg": much critical effort is unseen.
• Technical skill is a starting point, not the end goal.
• Documentation must serve both humans and AI agents.

In practice

• Focus on semantic layers for data clarity.
• Address messy legacy projects systematically.
• Consider AI output consistency and cost-effectiveness.

Topics

• Business Intelligence
• Data Analytics
• Power BI
• Semantic Layers
• AI Agents
• Data Documentation
• Legacy Systems

Best for: Data Analyst, Data Scientist, AI Student

Related on AIssential

• Semantic Layers in the Age of AI are 100% Needed — Semantic layers translate natural language queries into data operations, ensuring consistent data interpretation for AI and users.
• What Happens Now That AI is the First Analyst On Your Team? — AI is fundamentally reshaping cognitive work, shifting human roles from generation to validation across multiple skill sets.
• Your analysis was right. Nobody acted on it. — Effective communication of data insights to stakeholders is more critical for impact and career growth than technical accuracy.
• What does a Data Analyst Workflow Look Like? — A data analyst's workflow progresses from raw data ingestion and transformation to semantic standardization and utilization.
• How to use AI to optimize your data analyses (without becoming a hostage to the hype) — AI optimizes data analysis by automating tedious tasks, but human critical thinking and validation remain indispensable.
• Microsoft Fabric: The Missing Piece in My Power BI Journey — Understanding the complete data journey, not just dashboards, enhances Power BI development.

See Counsel's argued verdicts on the open AI decisions leaders are weighing →

Open in AIssential →

Editorial summary, takeaway, and curation by AIssential. Original article published by DataFramed.