IT can truly be the breaker of chains for self-service business intelligence (BI). Yeah, that’s right.

  • Free the users from the unending redundancy of data preparation.
  • Provide the data and systems sustenance that self-service BI needs to satisfy decision-making.

Steps IT Can Take

Here are some steps to take to start breaking those data chains.

  • Know your users and required functionality.
  • Identify special requirements beyond standard content.
  • Choose BI tools that serve multiple use cases.
  • Converge administrative features onto a single platform.
  • BI on BI is key for self-service success.

Save Time by Offering Services

Some customers I’ve talked to say that they still need at least a year of runway to plan system updates and upgrades. As the business requests new features, new charts, new data sources, and more, this lack of agility will increasingly not be tolerated. Instead, IT should function as an agency by offering services to support self-service BI:

  • Innovation Services (design thinking, digital disruption, live enterprise, etc.)
  • Training + best-practices (as self-service expands, automate some best practices)
  • Data Bureau (an enterprise store for internal, external, structured, unstructured, and curated enterprise data)
  • Tools Bureau (tools that satisfy a breadth of use cases for your wide breadth of users)
  • Sandbox Environments (a governed playground of data and technology that gives business the chance to ask and answer new questions in new ways)
  • Marketing and Community Building (for every $10, spend $8 implementing the project and $2 spreading the word about the impact)
  • Support for BI Collaboration (comments and workflow across BI tools and user groups)
  • Analytics on Analytics (How is the user base expanding? What is the license usage? Any impact to productive systems?)

Now, the chains will be different for every organization; however, you need to start by agreeing on responsibilities. The following table should get you started on some key questions to clarify.

For example, ad-hoc calculations. Where should those be happening? In the productive systems? Master data systems? Enterprise data warehouse? Semantic layer? Within individual reports? Undoubtedly, the answer will vary depending on the type of calculation, but you do still need to write it down. Yes, Breaker of Chains, unsexy documentation work will be an immense help to you.

Do you have a clear set of responsibilities for new self-service BI actions? Do you know where the information governance team assumes management of the data?

In the next blog, we’ll talk about the importance of a data strategy that can flexibly support self-service BI.