DataFramed

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

49 min

This episode explores what distinguishes a great Business Intelligence (BI) analyst from a good one, emphasizing that technical skills must be paired with strong communication, business acumen, and the ability to understand stakeholders' deeper needs. Helen Wall discusses the importance of the 'iceberg' approach (invisible groundwork like data modeling and semantic layers), the growing role of generative AI in BI, and the critical need for analysts to verify outputs rather than blindly trust them. The conversation also covers practical advice on documenting processes, learning new technologies, and maintaining cost-effective AI usage while ensuring data accuracy and regulatory compliance.

Summarized by Podsumo

🎧 Listen 🎙️ Ask about this episode

✨ Key Takeaways

1

Great BI analysts combine technical expertise with strong communication skills to understand stakeholder needs and build user-friendly, self-explanatory reports, rather than just coding in isolation.
2

The 'iceberg' analogy: Most impactful work in BI happens below the surface (data modeling, ETL, semantic layers), enabling consistent, scalable insights with minimal user friction.
3

Generative AI is transforming BI by enabling rapid prototyping and automation of repetitive tasks, but analysts must treat AI outputs as 'guilty until proven innocent'—rigorously verifying results against existing benchmarks.
4

A well-designed semantic layer (like Power BI's tabular model) reduces model size, improves consistency, and allows reuse across teams, preventing the chaos of ad hoc queries and helping control AI costs.
5

As AI takes over number crunching, human value shifts to critical thinking, domain expertise, and ensuring data quality—especially in high-stakes fields like finance, where a single error must be reported and corrected.

💬 Notable Quotes

"Developers inherently assume it's wrong until they've proved it right. — Helen Wall"
"It's easy to say wants all the data, but really you want the right data. — Helen Wall"
"[on documentation] Thinking about your future self and what you need to do often really helps other people as well. — Helen Wall"