View media kit
  • Product
    Offerings
    • AI analytics Explore data using natural language.
    • Self-service BI Let anyone analyze and explore data, no SQL required.
    • Embedded analytics Delivers AI-powered embedded analytics to customers.
    Features & Capabilities See All
    • Semantic layer The programmable semantic layer. Model your business in AML.
    • Analytics query language The composable query language built for AI reasoning.
    • Analytics as-code Define metrics and dashboards as code. Version control with Git.
    • Agentic BI development Develop BI with coding agents, locally or in browser
    • dbt integration Connect dbt transformation layer with Holistics BI layer
    • Canvas dashboard Empower your data storytelling with unparalleled flexibility
    • Reusable analytics Build reusable analytics components
    • Dynamic data sources Dynamically select data source by user and environment
    • All features Explore all powerful features in Holistics
  • Pricing
  • Docs
  • Blog
  • Customers
    Customer Stories
    • Customers & case studies Learn how our customers built reliable BI systems with Holistics
    • Support White-glove support to help you succeed with Holistics
  • Resources
    Learn
    • Worldview Our worldview on business intelligence
    • Not all semantic layers are equal Why the semantic layer is the real AI differentiator
    • Demo sandbox Try Holistics in your browser with sample data.
    • Documentation Learn how to get started with Holistics.
    • Support White-glove support to help you succeed with Holistics
    • Release notes What just got shipped!
    • Product roadmap What's shipping next?
    Engage
    • Community Ask questions, request new features or mingle with other Holistics users
    • Blog Inner Join - our blog on Business Intelligence for practitioners.
    • Newsletter Our weekly newsletter to 30K+ data professionals worldwide.
    • About us A decade betting on one idea: the semantic layer.
    • Contact us Have questions? Contact our team.
    • Partners Holistics consulting partner network.
    • Referral program Earn commission by referring prospects to Holistics
    Books
    • The analytics setup guidebook Build scalable analytics & BI stacks in the modern cloud era
    • Slice & dice: A self-service analytics comic What self-service analytics is, and why it is important.
    • Log in
    • Book a demo Book a demo
    • Offerings

      • AI analytics
      • Self-service BI
      • Embedded analytics
    • Features & Capabilities

      • Semantic layer
      • Analytics query language
      • Analytics as-code
      • Agentic BI development
      • dbt integration
      • Canvas dashboard
      • Reusable analytics
      • Dynamic data sources
      • All features
  • Pricing
  • Docs
  • Blog
    • Customer Stories

      • Customers & case studies
      • Support
    • Learn

      • Worldview
      • Not all semantic layers are equal
      • Demo sandbox
      • Documentation
      • Support
      • Release notes
      • Product roadmap
    • Engage

      • Community
      • Blog
      • Newsletter
      • About us
      • Contact us
      • Partners
      • Referral program
    • Books

      • The analytics setup guidebook
      • Slice & dice: A self-service analytics comic

← See previous newsletters

Sent to 19,366 subscribers

Huy Nguyen · October 13, 2021

Inner Join is Holistics's weekly business intelligence newsletter. This week: why the Data Org doesn't work well with each other, the arc of data adoption and defining data stack as code.


The Silos of Data Organization: Data Analysts vs Business Users

As a Data Analyst, you usually work with two types of stakeholders: the clients (business users) who ask for data, and the support (data engineers) who provide you with the data pipeline/raw data needed to do your work.

In theory, everyone is supposed to row in the same direction, working together nicely to make the business better.

In practice, it’s very common that you find yourself in a situation where the stakeholders are frustrated with each other. Things are moving slowly (or not at all). You can't stand the business people (they ask all the wrong questions)! All the cool Statistics stuff you learnt are not of use, you just spend most of your time second-guessing what they're trying to get at! Oh and, the data engineers are not responding to your requests! ...

What happens there?

You're facing what we call silos of data organizations : each of the data stakeholders only thinks about their own goals and working styles, without considering how to work well with each other.

In this week's (and next week's) post, I'd like to explore these relationships and what we can do about them.

The silos between Data Analysts and Business Users

As a Data Analyst, ask yourself: “When was the last time you get a data request from Business Users where they tell you what data they want with all the context, the reasons and complete analytical reasoning around why they want that data?”.

Yeah. If you're like most data analysts, the answer is: "Hmm, depends. But probably a long time ago".

How many times have you gotten back to them with some report, only to be responded with “Hmm doesn’t look like what I’m looking for? Can you try to change…”

This goes on for a few cycles, then you lose your patience. You have no motivation to produce high-quality results. You are annoyed and stressed by the constant requirement changes. You feel even worse when you are criticized for getting numbers wrong (sometimes). You told yourself: “I thought I’m supposed to use my brain to work on important analyses, turn out I’m just an English-to-SQL translator ”.

(An English-to-SQL translator, just in case it's not already clear enough, is someone who take a data request communicated in verbal language, translate that into the corresponding SQL query, execute it, get the results, and email that back to the requester. Well, how do you like this as a career?)

Why is this happening? This happens because the business users do not know what is necessary for the analyst to understand them. When they aren’t sure of what they want, they put out dozens of requirement changes, leaving the analyst confused and frustrated.

Are the business users to blame? Not really. As said, they just don’t know better! It is (ironically) the data team’s job (i.e. your job) to train and educate the Business Teams to have better data-driven thinking.

Of course, you will sometimes find certain people who are naturally data-driven in their thinking. These people are absolute pleasures to work with. They ask the right question, lay out their line of thinking clearly, and naturally provoke your data-geekiness.

Now. Let’s think from the business users’ perspective. Are they feeling frustrated too? Yes. They feel powerless because they have to go through Data Team for most of their data questions.

An analogy would be: When I was a student living in a rented apartment with the landlord, every time I went out and return home late after 11 pm, I’d have to call and ask the landlord to open the gate. This … worked, but errr, now I think twice (or thrice) when I want to hang out late. The fear of bothering someone!

That’s exactly what the business users feel. So after a few episodes of the above (plus the slow response time and mismatch in expectation of the report’s results), they stop relying on using data to inform their business decisions altogether.

So. What can we do to solve this situation?

A couple of (non-exhaustive) things that come to my mind:

(People) First, a mindset fix — Data Department should run themselves like a Product Organization, not an Outsourcing Team. They should be proactive about thinking how to add business values, instead of being reactive about it. They should engage with their business counterparts as equal thinking partners, rather than merely English-to-SQL translators.

I would also go out on a limb and suggest: The Data Department should aspire themselves to be the internal McKinsey consultants of the organization, bringing an analytical set of eyes to the business problems. This is, of course, extremely difficult to achieve. Where can you find good data-driven business thinkers with good data technical skills? But one should always dream.

(Process) Second, the Data Department should have put in place proper programs to systematically raise the data literacy levels of the entire org. I mentioned this last week on building a goldilocks-rule program so that the data-novice business users can “teach themselves data-driven thinking” without them even being aware of it.

(Tools) Third, for trivial data extraction, Data Department should put in place proper “self-serve” infrastructure and tooling, so that business teams don’t have to bother them with these constant ad-hoc questions.

Before I end this, for the Product-minded reader out there, I’ll leave you with this user-story style JTBD:

“Given I am a business user who is still novice about data-driven thinking.
When I try to make use of data to aid with my business decisions
There should be
a) A built-in training program for me to gradually learn to ask the right data questions.
b) An easy software interface for me to access the answer to the questions above.
c) A supportive data colleague to guide and consult me along the journey”

That’s it for this week. Next week, I’ll discuss the remaining silo: the relationships between Data Analysts and Data Engineers.

Do you agree or disagree with the above? How is your situation like? Let us know!

Get Inner Join in your inbox

Inner Join cuts past vendor noise to the durable ideas behind analytics, modeling and data organization.

Product
Self-service BI
Semantic Layer
Data Delivery
Embedded Analytics
Canvas Dashboard
What Makes Holistics Different
Compare with Looker
Compare with PowerBI
Compare with Tableau
Compare with QuickSight
Compare with Metabase
Resources
Docs
Not all semantic layers are equal
Demo Sandbox
Product Roadmap
Release Notes
Community Forum
Analytics Guidebook
Uptime Monitoring Service
Blog
Partners
BI Comparison Guides
Best BI Tools
BI Tools with Semantic Layers
Self-Service BI Tools
Embedded BI Tools
AI BI Tools
Security & Policies
Data Security
SOC2 Compliance
GDPR Compliance
Privacy Policy
Terms of Service
Support SLA
Responsible Disclosure
Data Processing Agreement
Company
About Us
Contact Us
Media Kit
Careers
Customers
Customer Login
Contact
Twitter
LinkedIn
Facebook
Singapore
14 Robinson Rd,
Far East Finance Building, #08-01A,
Singapore 048545
United States
2400 North Henderson Ave, # 1156
Dallas, Texas 75206
Vietnam
457 Nguyen Dinh Chieu, Level 2
Ban Co Ward, Ho Chi Minh, Vietnam
Copyright 2015 - 2026 Holistics Software. All Rights Reserved