SAP BusinessObjects Business Intelligence - An Introduction

Visit Tutorial Page ( Report)
In this course, we will Install SAP BusinessObjects programs, namely Information Design Tool (IDT) and Web Intelligence (WebI) - for free. We will create a sample database in Access 2010 (although you may already have your own database that you want to use), and then create a database connection to it. We will then create a "universe" in IDT, with a database Relational Connection, Data Foundation and Business Layer. We will then export this universe from IDT and open it in WebI. We will then create some tables and graphs. This is a quick overview of these two programs, following which you will have the programs on your machine, and can experiment for yourself.
  • Welcome
    • Introduction

      I'll introduce the course objectives.

  • Download and installing programmes, and creating database
    • Downloading and installing SAP programmes

      We'll be going on to SAP's website and downloading the programmes we need for this course - for free.

    • Creating sample database

      We'll be using Microsoft Access 2010 to create a sample database, which I will call "Southwind".

  • Creating the universe - using the Information Design Tool 4 Lectures
    • Create database connection and opening IDT

      We'll be creating a DSN (database connection) to our sample database, ready for our SAP program to use. We'll then open the Information Designer Tool (IDT) and connect to our database.

    • Create data foundation

      We'll be adding a data foundation layer, so that SAP can see what tables we want to use, and information about those tables. We'll be adding joins and primary keys.

    • Create business layer

      We'll start creating a business layer, so that we control what the end user has access to.

    • Enhance and export business layer

      We'll be refining our business layer, and then saving it to our hard drive.

  • Using Web Intelligence
    • Opening our universe in Web Intelligence

      We will open our universe in WebI. It's harder than you think!

    • Using WebI

      We'll now add a table and some graphs, based on our previous query.

    • File and Properties Menu

      Let's have a look at the various options you can use in WebI, starting with the File and Properties menu.

    • Report Elements

      We'll now go onto the Report Elements menu.

    • Format and Data Access menus

      Let's investigate the Format and Data Access menus

    • Analysis menu

      Let's look into the Analysis menu.

    • Page Setup, context menus and formulas.

      We'll finish with looking at the Page Setup menu, the context menus, and a brief look at all the formulas.

  • Thank you
    • Bonus Lecture

      Well done for completing this course. Let me give you a little present.

    • Many thanks

      Thank you for watching this course. I hope you have enjoyed it.

Write Your Review