We use cookies, including third-party cookies from Google to serve personalized ads through AdSense, to operate this site and understand how it is used. By continuing to browse, you accept this use. See our Privacy Policy and Terms of Use for details, including how to opt out of personalized advertising.
Accept
SmartData CollectiveSmartData Collective
  • Analytics
    AnalyticsShow More
    What Kind of Problem-Solving Distinguishes Data Analysts From Software Engineers -- AI-generated illustration
    What Kind of Problem-Solving Distinguishes Data Analysts From Software Engineers
    7 Min Read
    chatgpt image jul 21, 2026, 04 34 30 pm
    4 Core Benefits of Predictive Maintenance after Vibration Analysis
    10 Min Read
    How Does Data Mining Boost Customer Satisfaction in Logistics? Harnessing Analytics for Results -- AI-generated illustration
    How Does Data Mining Boost Customer Satisfaction in Logistics? Harnessing Analytics for Results
    11 Min Read
    chatgpt image jul 13, 2026, 04 23 45 pm
    How Data Analytics Helps Companies Improve User Engagement
    19 Min Read
    chatgpt image jul 13, 2026, 03 59 46 pm
    How Data Analytics Improves Multi-Location Search Strategies
    10 Min Read
  • Big Data
  • BI
  • Exclusive
  • IT
  • Marketing
  • Software
Search
© 2008-25 SmartData Collective. All Rights Reserved.
Reading: How Many Analysts Does It Take To Screw In A Lightbulb?
Share
Notification
Font ResizerAa
SmartData CollectiveSmartData Collective
Font ResizerAa
Search
  • About
  • Help
  • Privacy
Follow US
© 2008-23 SmartData Collective. All Rights Reserved.
SmartData Collective > Business Intelligence > How Many Analysts Does It Take To Screw In A Lightbulb?
Business Intelligence

How Many Analysts Does It Take To Screw In A Lightbulb?

Steve Bennett
Steve Bennett
7 Min Read
How Many Analysts Does It Take To Screw In A Lightbulb?
Illustration generated with FLUX.2 [klein 4B] via Cloudflare Workers AI.
SHARE

An old joke but a question I face each time I am asked gather a team to create a sustainable analytic capability in an organisation. Well I’ve finally collected together my thoughts and I believe I have a model that can be used to plan the resource requirements for a range of analytic objectives.

A couple of things to be aware of if you want to use this:

  • It is based on my work with large commercial organisations – those with 1,000 employees or more (sometimes 10’s of thousands more).
  • I almost always use specialist BI toolsets such as Business Objects, Cognos, SAS, Informatica, Infosphere, etc.
  • My experience has been that the model works equally well for business as usual (BAU), project activities, or a combination of both.

It may be that this model is less applicable outside of the ‘large commercial organisation’ domain – but I don’t yet know why it wouldn’t be. I have used this model across a range of industries and have talked with many people working in many types of non-commercial environments. Nothing they have said has indicated that they have fundamentally different analytic needs from my own. I am interested if anyone reading this has a different opinion.

Anyway, enough prevaricating, here is the resource model:

2010 Team Sizes 

 (Click to open a larger version in a new window)

 So the minimum team required for an organisation wanting to have a modest analytic capability is 6 people: A business sponsor and a team of 5:

    • Business Subject Matter Expert who understands what the business requires analytics for – what will work, and what wont. This person is also an analytics evangelist (but usually not a ‘tools’ or techniques expert when they start in the role) who will work with the business as a trusted advisor. This is the person that understands the real business requirement for analytics.
    • Data Steward who is responsible for data conversion and ongoing quality. This is the person that understands how to deliver business data that is ‘fit for purpose’.
    • Data Business Analyst who is able to understand business requirements and create new and original (innovative) solutions to the analytic requirements of the business. This is the person that understands the ‘nature of data’ and can apply this knowledge using diverse tools and techniques like UML, BPR, SQL to give structure and process to the solution.
    • Analytics Manager and Technology Solution Architect who manages the analytics team and is the main designer of the technology solution that will be used to deliver analytic products to the business. This is the person that understands how to deliver analytic services.
    • Report Writer, help desk and trainer who gets business people to use the analytic solution and then helps support them and further improve the ‘analytic products’.

    If you are really, really lucky, then either the Data Business Analyst or the Report Writer also have the skills to use structured analytic techniques. But 9 times out of 10, this isn’t the case. Small team such as the one I describe, are effective at data integration and starting the business in using reports and dashboards for insight. Structured analytic techniques will be important a few years down the track as the organisation’s capabilities grow.

    The table below gives you an idea of how these roles become more specialised as the team grows:

    2010 Team Roles 

     (Click to open a larger version in a new window)

    So these are the roles and skills that I believe are required if you are to be successful. They do reflect my personal biases for:

    • A strong business focus and led approach where IT’s main role is providing the infrastructure platform
    • Delivering a self-service analytic capability into the business wherever possible (as opposed to building a large team that provides analytics to the business)

    Like the BICC advocated by the Gartners and Forresters of this world, I’m sure that there are a number of models that work. The above is one that has stood the test of time for me.

    Link to original post

    TAGGED:business intelligence
    Share This Article
    Facebook Pinterest LinkedIn
    Share

    Follow us on Facebook

    Latest News

    Retailers Should Stop Treating Every Stockout as Equal -- AI-generated illustration
    Retailers Should Stop Treating Every Stockout as Equal
    Business Intelligence Exclusive
    Best Vibe Coding Cleanup Specialists in the USA: Fix or Rebuild? -- AI-generated illustration
    Best Vibe Coding Cleanup Specialists in the USA: Fix or Rebuild?
    Development Exclusive
    Using Warehouse, Transportation and Order Data to Plan Distribution-Center Capacity -- AI-generated illustration
    Using Warehouse, Transportation and Order Data to Plan Distribution-Center Capacity
    Big Data Exclusive
    Flat editorial illustration: The article centers on AI budget discipline for 2027 business planning, linking AI spending to measu
    10 AI Trends That Should Shape Your 2027 Business Plan
    Artificial Intelligence Exclusive

    Stay Connected

    1.2KFollowersLike
    33.7KFollowersFollow
    222FollowersPin

    You Might also Like

    SnapLogic: Making Big Data Integration as a Service a Hadoop Reality
    Uncategorized

    SnapLogic: Making Big Data Integration as a Service a Hadoop Reality

    4 Min Read
    Next query: NoSQL and Business Intelligence
    Business IntelligenceData WarehousingSQL

    Next query: NoSQL and Business Intelligence

    7 Min Read
    AI And Augmented Reality Merge For New Business Solutions
    Artificial IntelligenceBig DataBusiness IntelligenceExclusiveKnowledge Management

    AI And Augmented Reality Merge For New Business Solutions

    7 Min Read
    Big Data Offers Remarkable Valuation Tools for Cryptocurrency Speculators
    AnalyticsBig Data

    Big Data Offers Remarkable Valuation Tools for Cryptocurrency Speculators

    6 Min Read

    SmartData Collective is one of the largest & trusted community covering technical content about Big Data, BI, Cloud, Analytics, Artificial Intelligence, IoT & more.

    AI chatbots
    AI Chatbots Can Help Retailers Convert Live Broadcast Viewers into Sales!
    Chatbots
    The Art of Conversation: Enhancing Chatbots with Advanced AI Prompts
    The Art of Conversation: Enhancing Chatbots with Advanced AI Prompts
    Chatbots

    Quick Link

    • About
    • Contact
    • Privacy
    Follow US
    © 2008-26 SmartData Collective. All Rights Reserved.
    Welcome Back!

    Sign in to your account

    Username or Email Address
    Password

    Lost your password?