Archive for "Business Intelligence"

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

Business Intelligence, Posts Jul 19, 2011 No Comments

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.

BI Vendor Products - AdHoc Query & Analysis (2011)

Read more »

Share

New Product Names within SAP BusinessObjects Version 4.0

Business Intelligence, Business Objects, Posts Jul 14, 2011 1 Comment

 

The latest version of SAP Business Objects, released in 2011, has been officially named SAP BusinessObjects 4.0 with the title “XI” being removed from the release number. Many of the client tools in the SAP Business Objects application suite will also have a new name in the new version.

 

Business Objects Application Names for BOBJ XI 3.x vs. BOBJ 4.0

Business Objects (BOBJ) 4.0 - New Application Names

 

Source: http://bit.ly/gVurCF

Read more »

Share

BI Market: Operational Reporting (Vendors and Products) – 2011

Business Intelligence, Posts Jul 12, 2011 No Comments

Operational reports are pre-designed business reports that focus on listings of data at the detailed level with data presented within a highly-structured format. Also known as “canned reports”, operational reports enable organizations to present data in a logical format and are designed to support the day-to-day activities of an organization at the transaction level. They are typically developed by information technology (IT) departments and/or advanced report users that have a good understanding of reporting tools, business rules, and database concepts. In addition, operational reports can be scheduled, refreshed, and distributed on a regular basis. Fundamentally operational reports are used by people with the responsibility for improving their organization’s operations.

In 2011, the market leading vendors for operational reporting include: SAP Business Objects, Oracle, IBM, MicroStrategy, Microsoft, Information Builders (IBI), Pentaho, JasperSoft, Actuate, and LogiXML.

BI Vendor Products - Operational Reporting (2011)

Read more »

Share

Components of SAP BusinessObjects: Universes

Business Intelligence, Business Objects, Posts Jul 11, 2011 No Comments

A BusinessObjects Universe is a middleware device that contains a business representation of a data warehouse, data marts, or other reporting database. Fundamentally, the universe enables the end-user of BusinessObjects to interact with data without having to understand the complexities of database logic or be familiar with where the physical data is stored. Moreover, the universe is built around common business terminology that describes the business environment and provides the end-user the ability to intuitively query and retrieve exactly the data that they need.

Also known as a “semantic layer”, the universe is an intermediary layer between a database or data source and dependent reports, queries, or dashboards.  The universe is a requirement as a data source for WebIntelligence and Xcelsius dashboards, while being optional as a data source for Crystal Reports.

Role of Business Objects Universe

A universe is developed using the BusinessObjects Designer tool and a universe file (.unv) contains:
•  Database connection information
•  Objects grouped into classes seen by the users
•  Objects that map to database structures
•  A schema of tables and joins based on the database
Components of a Universe Include:
•  Classes – Logical groupings of fields and objects
•  Tables – Mappings to database tables and views
•  Objects – Structures that map to database fields
•  Joins – SQL specifications on how tables relate (contains both inner and outer join information)
•  Contexts – Groups of related tables with their related joins

Universe within BusinessObjects Designer

Key Advantages of Utilizing a BusinessObjects Universe:
•  Only the universe developer needs to understand the structure of the underlying database.
•  Cryptic database jargon is hidden from end-users
•  The designer tool allows the creation of the universe in an easy-to-use graphical interface.
•  The data is read-only so there is no danger of the data being edited or changed by the end user.
•  Reports can be created using a simple interface using drag and drop techniques.
•  All data fields utilize consistent business terminology.
•  Standards can be applied across data fields.

Read more »

Share

Components of SAP BusinessObjects: Explorer

Business Intelligence, Business Objects, Posts Jul 07, 2011 No Comments

BusinessObjects Explorer is a relatively new component of the SAP BusinessObjects product suite that provides a more advanced and intuitive data exploration interface for business intelligence end-users, both casual and power users.  Explorer encompasses the simplicity and speed of web-search technologies with the trust and analytical power of conventional business intelligence technologies to provide deep understanding and immediate answers to both simple and sophisticated business questions.  BusinessObjects Explorer provides end-users with the capability of quickly exploring and visualizing large data sets.  Features includes searching and sorting, interactive drilldowns, and various types of dynamic graphical visualizations while navigating through corporate data.

SAP BusinessObjects Explorer

Features and Functions of BusinessObjects Explorer

Robust Search Capability
• Search Experience Similar to Google or Yahoo – Users enter keywords to find instant business information with return results ranked by relevance.
• Search Concurrent Data Sources – Reach data across an entire SAP BusinessObjects landscape and any data source that it accesses.
• Self-Service Access – Pervasive searches with queries directly to data without the need for a predefined report or query.
Trust and Power of a Conventional Business Intelligence System
• Guided Data Exploration – The most relevant keyword search results are presented first, allowing end-users to access additional contextually relevant details as they explore.
• Intuitive Visualization – The system automatically generates charts and grapchs that best represents the information being queries – no cryptic data model or data knowledge is required by any end-user.
• Team Collaboration – Share information easily via e-mail, embedded URL, and other popular communication formats.
Ease of Deployment to End-Users
• Leverages Existing BusinessObjects Infrastructure – Reuses existing universes, security, and administration services already deployed within the BusinessObjects platform.
• Limited End-User Training Required – Intuitive end-user interface and functionality allows first-time users to get started with next-to-no formal training.
• Rapid Implementation Schedule – Add search, exploration, and visualization functionality to an existing BusinessObjects deployment in as little as a few days.

 

Read more »

Share

Components of SAP BusinessObjects: Web Intelligence (WebI)

Business Intelligence, Business Objects, Posts Jul 05, 2011 No Comments

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

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

Read more »

Share

Components of SAP BusinessObjects: Crystal Reports

Business Intelligence, Business Objects, Posts Jul 04, 2011 No Comments

Crystal Reports is an operational reporting environment and component of the SAP BusinessObjects suite of products.  Fundamentally, it is a tool that enables report authors to easily design interactive reports and connect them to virtually any data source. It is the ideal solution for canned or published reports as it allows for the creation of high-fidelity, pixel-perfect reports. Additionally, end-users benefit from on-report sorting and filtering – giving them the power to execute decisions instantly.

More details and graphics of Crystal Reports can be found on the Portfolio Page.

Crystal Reports - Sample Report in Designer Tool

Crystal Reports - Sample Report in Designer Tool

With Crystal Reports, report authors and end-users can leverage an intuitive interface, access data spread across multiple systems, design reports with guided interactivity, and embed reports within both client-server and web applications.  Crystal Reports can be used for report design, application development, and web report delivery.

Read more »

Share

Components of Oracle BI Enterprise Edition (OBIEE) – Oracle Delivers

Business Intelligence, Oracle BI, Posts Jun 22, 2011 No Comments

Oracle Delivers is a component of the Oracle Business Intelligence Enterprise Edition suite that provides activity monitoring and alerting that can reach users via multiple channels such as:

•  Email
•  Dashboards
•  Mobile devices

Oracle Delivers includes a web-based self-service alert creation and subscription portal, and a workflow engine that allows for initiation and passing of contextual information to other alerts. Furthermore, it can dynamically determine recipients and personalized content to reach the right users at the right time with the right information.

Oracle BI Delivers

In a nutshell, Oracle Delivers notifies business users with relevant reports and data when events occur. Notifications can be sent and received utilizing most common communication channels.

 

Read more »

Share

Components of Oracle BI Enterprise Edition (OBIEE) – Oracle Publisher

Business Intelligence, Oracle BI, Posts Jun 16, 2011 No Comments

Oracle Publisher (formerly XML Publisher) is a component of the Oracle Business Intelligence Enterprise Edition suite is an enterprise-level operational reporting tool that separates the data from the presentation. This means that developers from the information technology department can define the data sources, and business users can specify the report layout. The same data source can be used by multiple report templates.  By separating the task of finding the data from the task of deciding how to present them, the business user can define a report template with exactly the format he or she wishes.

Oracle BI Publisher

 

Rather then having an independent report design environment, Oracle Publisher leverages both MS Word and Adobe Acrobat as a user interface for the creation of richly-formatted operational reports.

Oracle BI Publisher

Read more »

Share

Components of Oracle BI Enterprise Edition (OBIEE) – Oracle Answers

Business Intelligence, Oracle BI, Posts Jun 14, 2011 No Comments
Oracle Answers is a component of the Oracle Business Intelligence Enterprise Edition suite that provides ad-hoc query and analysis capabilities to end-users.  Users can processes data from multiple data sources in a pure web environment. In addition, users are isolated from underlying data structures as they view and work with a logical view of the information.  This logical view of the information is presented to the user in business terms.  The interface of Oracle Answers is highly-intuitive and enables end-users to create:
• Queries
• Data tables
• Interactive charts and graphs
• Pivot tables
• Reports
• Prompts

Oracle Answers provides a point-and-click interface that allows end-user to develop robust ad-hoc queries and reports. Users simply drag-n-drop fields to create layouts with reports, queries, and charts on the right-hand side of the application.  Data fields are subsequently on listed on the left-hand side.

Oracle BI Answers

In addition, Oracle Answers is tightly integrated Oracle Interactive Dashboards. Reports, prompts, tables, charts, & graphs created in Oracle Answers can be easily saved, shared, modified, formatted, or integrated within dashboards of the Oracle Interactive Dashboards application.

Read more »

Share
Facebook Like Button for Dummies