In today’s economic environment, organizations must use business intelligence (BI) to make smarter, faster decisions. The business case for BI is well established. Access to BI is what gives companies their competitive edge and allows them to discover new business opportunities. Yet, in too many organizations, decisions are still not based on business intelligence because of the inability to keep up with demand for information and analytics. IT has been stripped down to the barest numbers, even while information workers are demanding more control and faster access to BI and business data. To satisfy this demand and accelerate time to value, one approach involves setting up an environment in which the information workers can create and access specific sets of BI reports, queries, and analytics themselves—with minimal IT intervention—in a self-service BI (SS BI) environment.
Information workers become more self-sufficient by having an environment that is easy to use and supplies information that is easy to consume. It is these two themes—ease of use and information consumability—that play crucial roles in a fully functioning SS BI environment.
Self-service BI is defined as the facilities within the BI environment that enable BI users to become more self-reliant and less dependent on the IT organization. These facilities focus on four main objectives:
- easy access to source data for reporting and analysis,
- easy-to-use BI tools and improved support for data analysis,
- fast-to-deploy and easy-to-manage data warehouse options such as appliances and cloud computing, and
- simpler and customizable end-user interfaces.
Tenents of Self-Service BI
- Make BI tools easy to use
- Make BI results easy to consume and enhance
- Make it easy to access source data
- Make DW solutions fast to deploy and easy to manage
10 Key Recommendations
1. Don’t assume that simply installing easy-to-use BI tools creates a self-service BI environment.
It’s a start, but it just isn’t that simple. You must have a solid and sound infrastructure in place that supplies the required data. The infrastructure requires planning and design, data integration and data quality processing, data models for the data warehouse and marts, scalable databases, and so on. It requires an understanding of the types of data the information workers will need.
The bottom line is that your job is to make these functions look easy and appealing. Simply installing technologies will not make your BI environment self-service enabled. What will make it easier and more appealing is to have a complete and solid infrastructure in place that makes access easy, the creation of analytics simple, and the display of results easy to understand. It also means giving the right environment to the right workers. Whether consumer, producer, or collaborator, the technology must match the tasks users want to perform in a way that is simple and engaging.
2. IT needs to monitor the self-service BI environment.
There must be a layer of administration and manageability. Ensure that IT has monitoring and oversight capabilities when information workers deploy, share, and collaborate using BI capabilities. IT should be able to monitor the usage of any BI component that an information worker publishes, whether the data used was
from a governed or ungoverned source. They should also know who else is using it. IT must be able to determine which queries are too costly, long-running, or bog down the performance of other queries.
IT not only needs to monitor BI components, but also needs to secure, validate, and audit them.
The key here is to ensure that business users feel they have the “power” or ability to create their analytic capabilities while IT still has the ability to monitor when they need to jump in and help out.
3. Support collaborative business intelligence.
Enable different types of information workers to share BI results and work together to define new ways of viewing and analyzing data. Start simply—use a setup that IT can configure easily and use technology that the information worker can understand and use easily. SS BI may need to mimic something information workers are already familiar with (Microsoft Office, for example). Use technology that meshes with your traditional BI environment and/or interfaces seamlessly with it. You will need to provide collaborative features that enable teams of information workers to develop and publish charts, dashboards, and so on, and the users of these analytics to rate or comment on them.
4. Don’t give information workers too much responsibility.
Most information workers really don’t want the entire responsibility for generating information and reports. It’s not part of their job!
They may find the tools and infrastructure too difficult to use, or they may forget their training before they can use the environment. Make sure that those who do construct self-service BI components also define key metrics, entities, hierarchies, and terms in a consistent fashion.
They should be trained to use the existing technical and business metadata as well as the existing standards and nomenclature.
You should strive to strike a balance between self-service and IT-generated delivery of information. You can do this by taking small steps toward selfservice if your business users are not used to technology, fear doing something “wrong,” or feel they are not properly trained for these activities. Nothing will destroy a self-service environment faster than no one using it. It may take more handholding than you expect. One key successfactor, though, cannot be ignored—the business users must play by the rules when it comes to defining their metrics, analytics, algorithms, and so on.
5. Understand the information requirements of information workers and provide appropriate tools/ reports/dashboards.
Understand what each group of information workers wants to accomplish with BI. What are their motivations? What are their skill sets, capabilities, and even interest
in learning how to serve themselves? You may find that most of your information users are consumers with little interest in creating, producing, or generating their own reports, queries, or analytics. But be aware that information workers change their roles frequently.
The best practice here is to get inside the heads of your users to understand what it is that they want to do, accomplish, or create. One suggestion is to examine or be familiar with their compensation models. Their bonus structure will give you a clear idea of what motivates them at work!
In addition, keep in mind that this may be a new service to many business people. Their reluctance to embrace it may come from fear of the unknown, inertia around the way they have always done things, or ignorance about the benefits that they might receive from the environment. In any case, be prepared to change what the users can do—design ways to monitor the utilization of the environment. As users become familiar with the self-service environment, many may begin to change their role from consumer to producer, from producer to collaborator, and so on.
6. Create a starter set of standard reports, analyses, and widgets.
Provide a library of standard BI components (queries, reports, analyses, widgets). Make them appealing to information consumers (the largest audience). These can also act as templates for the information producers.
The best practice is to make these parameter-driven and customizable. It an amazing but true fact that one of these reports can replace hundreds of hard-coded, customized reports and analyses. The ability to select parameters based on immediate needs also makes consumers feel as though they are truly self-sufficient. They are not overwhelmed, because the BI results have simple, intuitive interfaces to filter, navigate, and analyze a predefined set of data. All of these “starter” components will help with the adoption of self-service BI simply because we all make better editors than creators. So the more that you supply, the faster the adoption.
7. Establish a governance committee.
The governance committee should consist of representatives from both the information worker population and IT professionals. Their responsibilities include reviewing requests for new components or modifications to existing standard ones, determining whether an existing component can satisfy a request or if a new one is needed, examining requests for self-service, determining what to provide, and identifying needed training.
Governance also includes the creation of role-based access and security by a particular user group as well as the determination of which self-service objects should be promoted to the governed environment for general use.
Remember that the governance committee should promote the use of self-service BI, not hinder its adoption. It is not meant to be a restrictive group, so it should perform the needed PR and communications about its purposes to ensure this message is heard.
8. Allow the data warehouse to be used with other types of data.
There are times when urgent business requirements cannot be satisfied in a timely manner using the data warehouse alone. It may be that other sources of data, such as operational data, external information, or analytic data from other sources, must be brought together for the needed analytic. In this case, data virtualization provides a quick way to give rapid and flexible access to multiple data sources. However, you will need to provide a monitoring mechanism for the sources accessed to ensure that the performance of these systems is not negatively affected.
The governance committee should be involved in this process.
We all know that emergencies happen—requests come in with an urgency that cannot be met through traditional mechanisms. Workarounds happen. In fact, there is data that may be needed regularly for analytics but should not or cannot be incorporated into the data warehouse—for example, real-time or sensitive data. Data federation technologies have come a long way to allow different data sources to be combined in a virtual fashion and yet act as if they were physically integrated.
Data governance and some form of monitoring will be needed to ensure that the end-run or workaround can be halted if the data is subsequently incorporated
into the data warehouse. Note: retrofitting can be painful!
9. Buffer less experienced information workers from the complexities of the BI environment.
Use features such as Web browsers, interactive graphics, wizards, drop-down lists, and prompts to guide users through BI tasks. This will free up IT professionals from spending large amounts of time responding to requests for new data, building new reports, and so on. It also gives the information consumers a sense of control and adds to the flexibility of the overall BI environment.
But beware—what’s intuitive to a BI professional is not necessarily intuitive to a naïve user. BI implementers have to think outside of their own boxes to truly understand what business users who want SS BI really need. It may mean doing their job for a day!
10. Watch your costs.
This is a major product differentiator.
If you already have a BI vendor’s platform in place, you can often add a self-service capability with minimal effort and cost.
Many vendors offer entry-level products geared toward companies with limited budgets. Some companies use open source solutions, but there may be additional “deployment” costs.
Consider software-as-a-service (SaaS) offerings to cut capital and IT staff costs.
You must be careful not to break your budget through your self-service BI implementation! There are many deployment options available to BI implementers today that can greatly reduce the costs of these environments. However, remember to ensure that their deployment options will fit into your overall conceptual and technical architecture.
Download the Report
This report describes the technological underpinnings of these four objectives in great detail while recognizing that there are two opposing forces at work—the need for IT to control the creation and distribution of BI assets and the demand from information workers to have freedom and flexibility without requiring IT help. Companies seeking to implement self-service BI must reach a middle ground in which information workers have free access to data, analytics, and BI components while IT has oversight into the SS BI environment to observe its utilization. This gives the information workers the independence and self-determination they need to answer questions and make decisions while giving IT the ability to monitor the SS BI environment and apply governance and security measures where necessary. For guidance, this report provides practical recommendations to ensure a successful SS BI environment.
To access the report, click here.
I actually wished to compose a small note to thank for you for many of the pleasant secrets you happen to be showing on this website.