Posted on Leave a comment

BI System Builders Migrate Content to the New SAP BI 4.0 – Archive 2011

BI System Builders have successfully migrated their BI content and Business Analytics from XI 3.1 to SAP BI 4.0 using the new SAP Upgrade management tool. BISB maintain their live SAP BusinessObjects environment for the purposes of customer demonstrations and Proof of Concept.  The image below is an example of the upgrade. It shows a Business Analytic on the new BI 4.0 platform.  The Business Analytic was originally developed by BISB on the XI 3.1 platform and then upgraded to BI 4.0 . The Business Analytic has been developed using Web Intelligence (Interactive Analysis) and now leverages the new BI 4.0 charting engine.

Business Analytics with SAP BusinessObjects

Posted on

SAP Business Objects Live Office

SAP BusinessObjects

The SAP BusinessObjects Live Office application integrates with Microsoft Office using Microsoft’s Open Bridge Framework. We’ve created a live demo video entitled PowerPoints with SAP BusinessObjects Live Office which you can watch below. Live Office enables business users to embed corporate data from the data warehouse into Microsoft Office tools. This ability helps business users to become more self-sufficient, releasing them from their dependency on IT and providing them with ‘Self-Service BI’ access toTrusted BI data within the Microsoft Office tools they are familiar with. Once installed SAP BusinessObjects Live Office uses an intuitive wizard and integrated Microsoft Office tool bar to enable business users to select data easily from existing Crystal Reports and Web Intelligence Documents. Live Office users can also make ad hoc data selections based on a user friendly query panel that interfaces with the SAP Business Objects universe. Accessing the Single Version of the Truth quality assured data in this way increases user confidence in the accuracy of the data that is being analysed, consumed and shared. Live Office includes the functionality to instantly refresh data and change prompt parameter values. Live Office can also be used to feed Xcelsius Dashboards. Live Office documents can be published to SAP BusinessObjects business intelligence platform securely and then shared with colleagues as required. Live Office works with Microsoft Excel, Microsoft PowerPoint, Microsoft Word and Microsoft Outlook meaning that BI data can be directly embedded into your slide presentations and email messages. A practical example of beneficial use is to create a PowerPoint based management reporting slide deck pack. Many business users make the same presentations using the same slides over again but must continually capture numerous screen prints to remake the slide deck because the data values have changed. When Live Office is used the management reporting slide deck pack only needs to be created once. When next presenting just open the slide deck pack and then click ‘Refresh’ for the latest data! You can watch our video demo on the BI System Builders YouTube channel.

Posted on Leave a comment

Benefits of Bespoke Business Intelligence Training

This article relates to the use of bespoke BI training for the SAP BusinessObjects toolset.

Training has become commoditised. This approach can bring benefits to both the supplier and the customer. Once training materials have been standardised they can be maintained at a guaranteed quality. The customer’s expectation can be set and a single version of the training truth, so to speak, is established. After set up costs the supplier only needs to maintain the materials. The materials can then be replicated and sold for profit. They are now a product in their own right, a valuable commodity to the supplier.

However, key benefits of bespoke training are that it can be based on the organisation’s own data and be geared to help the organisation address its specific challenges. If the customer is an investment bank why provide training using data based on fashion clothing or white goods such as washing machines? You may laugh but this practice has happened in the past.

The benefit of using the organisation’s data is that the training has more meaning and value to those attending the course. Attendees get to watch and use the SAP BusinessObjects toolset in a way that is directly relevant to them. They are working with data from their own business process area. The SAP BusinessObjects universe that they interact with contains objects relevant to their daily work. This makes the application of the toolset directly relevant. Delegates complete the training with insight and ideas on how to directly apply SAP Business Objects tools to address their immediate business pains.
To achieve the bespoke training it is best to ring fence a dedicated BI environment. If budget exists install SAP BusinessObjects Enterprise on its own machine. Then take a cut of BI data, a snapshot in time. The data should be frozen and should not be overly complex. Overly large and complex data sets can be confusing to beginners becoming familiar with new BI tools.

If there is no budget for a separate environment it’s possible to do some clever things with Enterprise security to effectively section off a training environment on a machine being used for other purposes. The best environment for this is usually QA. If the QA environment is used, care should be taken when scheduling activities so that training and testing do not impact on each other.

Regardless of which environment is used the training will still need use of a dedicated snapshot of frozen data. Attempting to undergo training on live or changing data can easily wrong foot both the trainer and delegates. The training materials, for example a delegate workbook, should contain diagrams and screenprints based on the frozen data set so that both the written training materials and training practice match.
Bespoke training does not need to be prohibitive due to cost. BI System Builders maintain a core of BI knowhow that they then customise to a specific customer. It is not necessary to re-invent the wheel, just to adapt.

During 2009/10 Russell Beech adapted his core know how to design, author and deliver bespoke Business Intelligence training through BI System Builders to members of the UK Volkswagen Group. The training was based on SAP BusinessObjects InfoView and Web Intelligence using Volkswagen BI data.
Bespoke training can go way beyond commoditised training as it is geared to meet the specific requirements of the end users. At Volkswagen the advanced training course included a crash course in dimensional modelling and SQL. It also included workshops on how to practically apply advanced query building techniques to Volkswagen’s real life challenges using relevant data and data warehouse tables.