If your Business Intelligence initiative or program is struggling it may be because you do not have effective BI Solution Architecture in place. BI Solution Architecture involves far more than just understanding a technology product stack. As its name suggests it is by nature a solution and it encompasses Business, Information, Application, Infrastructure, Data, Integration, and Service Architectures.
In this new video I show you how to design Business Intelligence Solution Architecture that will make your SAP BusinessObjects Business Intelligence initiatives successful. I use SAP BusinessObjects as my example but the concepts are actually vendor agnostic so you can use the ideas with numerous BI and data technologies.
The concept behind Query & Analysis is really about empowering the Business User and Analyst to interact with data on the fly in a Self-service BI environment. There a few tools available from SAP BusinessObjects that fulfil this criteria. First of all, here’s a little background, so as to avoid any confusion around what the products are.
Historically, the original Query & Analysis and Reporting tool was simply called ‘BusinessObjects’. Back then if you were to ask someone what reporting tool they were working with they would just say ‘BusinessObjects’. That was the only tool, until sometime later the first version of Web Intelligence was released. After BusinessObjects acquired Crystal Decisions the ‘BusinessObjects’ reporting tool was renamed Desktop Intelligence, sometimes also known as Deski. Running alongside Desktop Intelligence the thin client tool Web Intelligence was being developed.
Over the years Web Intelligence has grown to become SAP BusinessObjects’ flagship tool that allowing non-technical users to create new queries, slice and dice, and then drill down through their data all via a web browser. The advancement in Web Intelligence means that Desktop Intelligence is now coming to its end of life.
A second tool available is Voyager. Voyager is an Online Analytical Processing Tool (OLAP). In the BI 4.0 release Voyager is superseded by SAP BusinessObjects Analysis edition for OLAP and SAP BusinessObjects Analysis edition for Microsoft Office. It should be used when analysis is required against large data sets.
We also find it useful to think of a third tool under the Query & Analysis category. That is the search tool named Explorer. The original name for Explorer was Polestar.
Information Delivery & Discovery or IDD as it is frequently referred to can be thought of as the middle section of the SAP BusinessObjects BI stack. The two sections that sandwich it are Data Services and Enterprise Performance Management.
IDD comprises primarily of the Business Intelligence Platform , the Enterprise Reporting , and Query & Analysis components and Dashboarding