Web Intelligence

BI Market: Ad-Hoc Query & Analysis (Vendors and Products) – 2011

July 19, 2011/0 Comments/in Business Intelligence, Posts /by Adam Getz

Query and analysis solutions enable business users and analysts to rapidly generate business queries and reports from enterprise data based upon business question of the data. Also known as “ad-hoc” querying, these tools typically provide intuitive, graphical interfaces that shields users from technical complexities and allows users to leverage business terminology instead of the more technical database names. The business focus of these tools allows nontechnical professionals to be comfortable with their data and allows them to quickly and efficiently satisfy their own information needsin real time with minimal assistance from system developers. Commonly, query and analysis environments include a middleware layer that converts database conventions into business nomenclature that is more intuitive and understanding to end-users. Moreover, query & analysis environments give users the capability to access and analyze data in a unique and personal manner. Utilized primarily by business users, query and analysis solutions provide an environment that enables interactive methods to query data, present data in an ad-hoc manner, and find information on an as-needed basis.

In 2011, the market leading vendors for ad-hoc query and analysis include: SAP Business Objects, Oracle, IBM Cognos, MicroStrategy, Microsoft, Information Builders (IBI), Pentaho, Jaspersoft, & SAS.

Components of SAP BusinessObjects: Web Intelligence (WebI)

July 5, 2011/0 Comments/in Business Intelligence, Business Objects, Posts /by Adam Getz

Web Intelligence (WebI) is an ad-hoc query and reporting environment within the SAP BusinessObjects suite of products. Fundamentally, it is an environment that provides self-service access to data. Web Intelligence contains reporting, querying, and information analysis in one integrated product, helping end-users turn business insights into effective decisions. With just a few clicks of the mouse, WebI users can quickly access and format information as well as easily analyze information to understand underlying trends and root causes.

Web Intelligence contains a highly-interactive data interface that allows the report user a great deal of flexibility to view data from different perspectives. Although many report users may only need to build their reports from scratch, it is often necessary for the users to adjust reports to answer current business questions. With Web Intelligence, users can easily edit queries and reports to reflect their latest information needs.

WebInteligence (WebI) – Sample Report


The following options can be taken advantage by user of Web Intelligence …
• View, edit, remove report, section, or block filters
• Format and re-size cells, tables, and charts
• Set breaks and sorts
• Insert calculations
• Add rows and columns to tables
• Create and duplicate tables and charts
• Turn a grid into a chart or a chart into a grid
• Create formulas and variables
• Edit cell formulas in place
• Recombine report objects within tables and charts

SAP BusinessObjects 4.0 E-Learning Catalog

March 15, 2011/0 Comments/in Business Objects, Posts /by Adam Getz

SAP is now offering official product tutorials to assist in learning the latest SAP BusinessObjects 4.0 suite of products. Each product page acts as a dynamic library of material where content is added as it is created. Below is the list of products with available interactive and animated tutorials online. For more information on what’s available, please click here.

• SAP Crystal Reports 2011

• SAP Crystal Reports for Enterprise

• SAP BusinessObjects Dashboards

• SAP BusinessObjects Web Intelligence

• SAP BusinessObjects Explorer

• SAP BusinessObjects Information Design Tool

• SAP BusinessObjects Business Intelligence Platform

• SAP BusinessObjects Analysis (coming in Q1-2011)

Resources: SAP BI Suite ELearning Catalog

Source: http://www.pieterhendrikx.com/category/sapbo/page/3/

Sample Charter for a BI Center of Excellence (BI COE)

December 9, 2010/0 Comments/in Business Intelligence, Center of Excellence, Posts /by Adam Getz

Sample BI Center of Excellence (BI COE)

In order to ensure a predictable and repeatable usage of Business Intelligence (BI) services across organization X, and to maximize the value of licensing cost, organization X’s information technology department has adopted the formation of a Business Intelligence Center of Excellence (BI COE). This BI COE performs at an enterprise level and serves as a cross-functional team with a permanent, formal organization structure. The team includes defined tasks, roles, responsibilities and processes for supporting and promoting the effective use of business intelligence across the organization.

In addition, organization X has chosen to standardize on an organization-wide reporting and decision support platform from SAP Business Objects to provide analysts and decision-makers across the enterprise with easy and flexible access to critical data. While Business Objects is being made available to the users through-out the enterprise, there is a need to establish and uphold best practices, guidelines, policies, standards and training to ensure the usability, sustainability and maintainability of the environment.

Fundamentally, the BI COE at organization X has three major responsibilities:

1. Application/security administration of Business Objects environment
2. Management and support of Business Objects application infrastructure

• Web Intelligence

• InfoView

• Crystal Reports

• Xcelsius Dashboards

3. Oversight, development, and implementation of enterprise business intelligence projects.