Coming next: The Second Factory →

Back to Library
Leadership & Teams✓ Principle

The Risk Creator Paradox (Your "Shadow IT" is Creating All the Value)

The Problem

IT calls them "risk creators." Those business analysts with crazy Excel macros. VBA wizards. VLOOKUP masters building their own reports because IT takes 6 weeks. IT leadership says "they're creating risk—undocumented code, wrong data sources, no version control!" So you try to shut them down. Force everything through IT. And guess what happens? Business value drops 40%. Why? Because those "risk creators" were the only ones actually solving business problems quickly. They were working around a broken system, not creating the problem. You just eliminated your most productive people because they didn't follow the rules.

The Principle

Flip the narrative. Those Excel power users aren't risk creators—they're value creators who lack proper tools. Instead of shutting them down, enable them. Give them governed data models. Train them on real BI tools. Turn them into citizen developers. The magic happens when you accept the uncomfortable truth: these "risky" analysts were creating most of your business value anyway. They just need better tools and light governance, not prohibition. Think manufacturing: you don't ban skilled machinists from customizing their stations—you give them better equipment and safety standards. Same with analytics.

🎯

3 Steps to Take Action

  1. 1

    **Identify Your Shadow IT** Find the business analysts building their own solutions: - Complex Excel macros - Access databases - Custom reports outside IT systems - VLOOKUP masters Don't judge. Just inventory. Ask: What business problems are they solving? Typically: They're solving real problems IT can't prioritize or takes too long to address.

  2. 2

    **Measure the Value (Before You Kill It)** For top 10 shadow IT solutions: - What business value do they create? - What decisions depend on them? - What would break if they disappeared? - How much time would IT need to replace them? Often: You'll find these "risky" solutions are mission-critical. If total value >$1M annually, you can't afford to shut them down. You need to enable them properly.

  3. 3

    **Enable, Don't Prohibit** Create a citizen developer program: - Give them access to real BI tools (Tableau, Power BI) - Provide governed data models (so they use good data) - Train on best practices - Light governance: peer review, data quality checks - Clear escalation path to IT for complex needs IT's new role: Build platforms, not every solution. Measure: % of solutions built by citizen developers (target: 50%+). Business value created by citizen developers vs IT.

💡 Inspired By

A major bank's self-serve BI transformation (2017). Recognized "risk creators" were actually value creators who needed enablement, not prohibition.

This is what Analytics Pitfalls & Principles is about: people helping people.

In Practice

A major bank had 47 "shadow IT" analysts building complex Excel tools. IT wanted to shut them down: "Too much risk! Uncontrolled!" Before acting, they asked: "What business value are these Excel tools creating?" Answer: $14M in operational savings annually. These analysts were solving real problems IT couldn't prioritize. New approach: Don't shut them down—enable them. Gave them access to Tableau, Power BI, governed data models. Trained them on best practices. Created "citizen developer" program with light governance (peer review, data quality checks). Result: Those 47 analysts became the most productive part of the analytics org. Built 60% of new solutions. IT focused on data platforms and complex engineering. Business value jumped 180%. The "risk creators" became heroes when you gave them proper tools and guardrails instead of handcuffs.

More on Leadership & Teams

From the book

In the book, Sarah Chen is asked to build her own successor. The test is whether the operation still works when she is not standing there.

This card is one of 57 drawn from The Auction Block by Brian Cariveau — the story of an analytics leader with 90 days to fix what the cards describe.

Each leadership pattern falls into a few pitfalls most often. Find your pattern.The Analytics Leadership Mirror: free, 5 minutes, no account