The current market slowdown has put increased pressure on margins for most organizations. Today’s organizations are feeling the rising input costs, higher interest rates and tight money supply. Large companies may experience flat demand or even a decline from global oversupply in the next few years. The role of business intelligence (BI) to provide agile, adaptable and efficient business decision-making has become very important to meet these business challenges. Businesses will struggle to have the leading edge in the market if decision-makers cannot get the correct timely information to act upon. Most business users and decision-makers rely heavily on the IT department in order to get information and make day-to-day business decisions. This not only causes inordinate delays in decision-making, but also places dependency on IT. This increases the overall investment cost of BI for the organization. All these factors translate to higher operating costs, reduced productivity, customer dissatisfaction and, most importantly, higher levels of dissatisfaction among employees in organizations.

To gain an advantage over competition, organizations must innovate ways in which business users can quickly and easily get required information. This means a BI environment in which business users can get rich, accurate and real information at their fingertips as easily as we get information from a Google search. For this to happen, business and IT need to work together to create a self-service BI environment that enables business users to access information with minimum support from IT for their day-to-day operations, so as to increase the overall ROI on BI for the enterprise. The need for such self-service BI has become less of an aspiration and more of a requirement in today’s competitive business scenario.

Prioritize Self-Service BI

Most large organizations have multiple inconsistent BI environments, and a single data warehouse does not adequately cover all the lines of business. This is because the data warehouses in most organizations have been developed disparately, with the silo approach in mind. Business users do not have access to consolidated, unified data from which they can make fact-based, objective, relevant and timely decisions. In many companies, one single data warehouse cannot meet the BI needs of all groups. When a data warehouse does not adequately cover all lines of business, the users have to get data from different sources and consolidate it in one place, leading to several spread marts within the same organization.

Business users spend much time explaining what they need to their IT teams, and after they get the report or data, they spend time filtering the required information from the data they receive. The primary reason for this is that the design and technology choice in their existing architecture has limitations in terms of data structure in the data warehouse and limitations on report formatting capability at the front end. The nonavailability of standard formatted reports and difficulty creating ad hoc reports increases dependence on IT.

With all this difficulty and delay to access information with their existing BI environment, business users have reduced the usage of BI in many organizations. In such an environment, business users make many critical business decisions based on intuition and with reliance on fewer facts, making their business decisions more risk prone. The existing BI architecture, which has been developed over a period of time with a tactical approach, should be reassessed to come up with a long-term BI strategy. Organizations should become aware of and work toward achieving self-service BI by placing it on their priority list before the alarm bell starts ringing.

Create Self-Service BI

The approach for self-serve reporting is based on designing the intuitive information delivery layer, which will provide data analysis capabilities directly to users. The approach should have an end-state vision where business users can view the key performance indicators at strategic or tactical levels, like balanced scorecards, and can drill down to the operational level to understand process performance as well. The design should allow business users to correct or optimize the process and achieve incremental excellence. Business users should be able to use the English language on a Google-like search and get the corresponding information in a single window - for both structured and unstructured information. This search-based approach combined with centralized enterprise-wide metadata helps business users get the information in an accelerated manner. On the back end, the data warehouse schema and online analytical processing (OLAP) models should be redesigned to hide the database complexity. The BI reporting tool should be standardized to a single vendor. All this provides easy reporting capabilities to the end users for information analysis. The successful definition and implementation of the self-service BI program is achieved in four basic steps.

The first step is an as-is assessment of the existing landscape with respect to people, process, technology and governance. This study takes a deep dive in existing information delivery capabilities and their associated architectures. The data for the as-is study is gathered from existing system documentation and interviews and discussions with subject matter experts, business users of existing BI reports and the existing BI IT support team.

The second step is identifying the to-be needs. The various business units across the organization that access information from the existing BI environment and the potential users of BI are identified, forming groups of about 10 to 12 key users for each business unit. A focus group is made diverse with users from cross-functional areas to get an unbiased and overall organizational perspective. Focus group discussions are conducted with these users, revealing pain areas and possible suggestions on how to access information for their day-to-day work without IT support. All the needs that come out of these focus group discussions are documented, and they become the to-be needs to enable self-service BI.

The third step is the definition of the to-be BI state. This is based on the to-be needs gathered along with business and IT consensus regarding the business capabilities and technology solutions necessary to support defined corporate strategies. Based on the as-is assessment and to-be needs, analyze how various BI needs within the organization can be consolidated to create a single centralized BI reporting environment. This step translates into architectural and structural changes in the data warehouse design. In case there are several BI tools across the organization, a single vendor BI tool standardization approach is recommended. If the existing BI tools within an organization do not meet the current business requirements, a new suitable BI tool is recommended with a business case.

It is critical to understand that a single BI reporting tool is not an enabler for self-service BI. It’s only for standardization and rationalization, eventually providing a centralized competency framework. There could be recommendations on the report delivery process, like establishing a report certification model. This approach brings consistency and discipline to the BI environment across the organization.

The fourth and last step is creating an implementation roadmap for transition to the future self-service BI architecture. This includes a phased rollout plan incorporating both time and cost estimates in the form of multiple BI projects. This approach to self-service BI leads to a search-based reporting environment that is centralized, metadata-driven, easy to navigate and efficient.

The Challenges

Though challenging, in order to create an information-centric culture, it is critical to implement a strong data governance framework. Data governance should be spread across master data management, metadata management and data quality management. I have seen organizations struggle to develop a true data governance council, which considers all these factors.

Standardization to a single BI vendor tool or introduction of a new tool to achieve self-service BI has challenges on the technology side. It becomes difficult to make all business users happy by offering a single BI tool. Today, many BI vendors in the market have expanded their products to address most BI, planning, performance management and predictive analysis needs. However, there are some areas like planning and predictive analysis where a few niche players are considered best. A single BI vendor tool would not be able to effectively address all reporting, analytical and planning needs of users.

The other technology challenges are for organizations that use packaged BI and data warehouse solutions that come tightly integrated with their enterprise resource planning (ERP) applications. The data visualization and reporting features of such packaged data warehouses are not on par with some of the prominent BI reporting tools on the market. The leading BI reporting tool vendors offer connectivity to packaged data warehouses, but there are many limitations on the technology front during such implementations.

On the process side, the challenge is that few organizations have established or widely accepted processes to access information. In many organizations, users get the required information quickly by bypassing formal processes and using their personal currency. Establishing a common process would require some effort to get information. Process-related changes are critical in achieving a self-service BI environment, but they are also the most difficult to implement.

The most daunting challenge is on the cultural front. Although people within the organization may not be satisfied with the way their BI needs are being addressed, they resist any change because of their comfort levels with the existing BI tools and the learning curve involved. Any change in terms of technology creates excitement among business users but, at the same time, generates fear of learning a new tool or adapting to a new process. Business users try to avoid the additional responsibility of creating the report themselves. They also forget how to use the tool, even after being trained. In a short time span, they either stop using the tool or call IT for assistance like they used to do. The organization then finds itself exactly where it was before.

The IT team might think that tool standardization across the organization would put their jobs at risk. There could also be pressure groups within the organization trying to push their own sets of thoughts and ideas on how to achieve self-service BI the ways they see best, putting the organization’s goals second. To make things worse, too many conflicting ideas exist in the market that create confusion. Ideas like standardization versus working with disparate systems, single vendor or rationalization versus best of breed, hosted solutions versus managed, centralized versus distributed and unstructured versus structured data add up to make the customer more puzzled and lose direction from the correct way to achieve self-service BI.

The Benefit of Embracing Self-Service BI

The most visible change that organizations have seen by implementing self-service BI is more agility in their business. Business can react to market changes or even take advantage of market situations more quickly with self-service BI because they have faster access to BI. The increased speed is a result of lesser dependency on IT and quick and effective access to decision-making data. Data that typically takes a few days to generate can now be accessed in a few clicks. There is better overall control of the data, and many organizations have been able to clean hundreds of repetitive, unused reports from their BI environment. In the self-service environment, data is organized and structured in a better way on the back end and displayed better aesthetically on the front end, so business users can easily access information. New features in the BI tools transform mundane reports and give them new life.

The overall usage of BI increases in most organizations with a self-service BI environment. With most organizations, 80 percent of information that is requested by businesses for day-to-day work can be standardized, and the remaining 20 percent can be obtained by adding some flavors to the standardized information.* Standardization of information can reduce IT effort in catering to such requests by about 85 percent on average. For ad hoc requests, organizations realize that having a single version of the truth in a structured manner, with consistent standardized metadata across the enterprise, has solved several complexities. Selection of a more sophisticated reporting tool on top of this organized data structure has made life simpler for business users. There is fantastic response from organizations where self-service BI is implemented as automation in decision-making through rule-based engines. Such organizations could see 45 percent savings in cycle time and 55 percent cost reduction through automated decision-making processes. Embedded data quality in the reporting and rules services as part of self-service BI develop confidence in the decision-maker.

All this has made data ownership easier, and setting up a process under such an environment is much simpler and effective. Most companies experience overall cost savings in IT budgets by about 60 percent over the previous year’s spending. Eliminating many similar reports to create standard reports could reduce hardware costs by about 45 percent. Long-running queries from different users are also reduced, and this could give about a 30 percent boost to overall performance for complex reports. Having a single BI reporting tool across the organization as part of a self-service solution creates standardization for information access and simplifies the learning curve for the business users because they only have to learn one BI reporting tool. This creates considerable savings on training business users across the organization. All these are substantial benefits that self-service BI can give and could prepare organizations for bigger challenges. Organizations can thus raise their aspirations toward achieving their strategic vision.

*All statistics cited in this article are based on Tata Consultancy Services Ltd. select customers.

Register or login for access to this item and much more

All Information Management content is archived after seven days.

Community members receive:
  • All recent and archived articles
  • Conference offers and updates
  • A full menu of enewsletter options
  • Web seminars, white papers, ebooks

Don't have an account? Register for Free Unlimited Access