Business Intelligence

Part 1 : Introduction

• Goal of the project
• What is for User?
  • For the end-user:
  • For the administrator user:
  • For the developer:
• OLAP
  • Who uses OLAP and Why?
• Terminologies

Part 2 : Architecture

• Schema
• Components
  • The Cube
  • The CLI interface
  • The Cube Definition
  • The Web Client
  • The OpenOffice plugin
  • The OpenERP interface
• Extra libraries
• Introduction to the OpenObject Module
  • Explanation of the components

Part 3 : MDXAlchemy

• MDXOverview
  • Independent yet Integrated to OpenERP
  • Supported Databases
• A look at few examples to write MDX Queries

Part 4 : Installing

• Installation of BI
  • Installing OpenERP Server and OLAP module
  • Installing Web Interface

Part 5 : Configuration

• Configuration Interface
  • Introduction
  • Connecting to an Existing Database
  • Writing a Schema
• Defining Schema in XML
• XML in open object
  • Introduction to the OpenObject Module
  • Explanation of the components
• Creating Cube Definition using XML file

Part 6 : Using CommandLine Interface (CLI)

• Command Line Interface
  • Introduction to the cli
• Running Automated Test Cases
• Reports
• WebService Interface

Part 7 : Using Cube Browser

• Cube Browser
  • Goal behind Cube Browser
• Loading the Cube
• Creating your report with drag and drop
• Swapping Rows and Columns
• Adding Slicer
• Drill Up/Down
  • Drill Down on a Member
  • Drill Up on a Member
• Graphs

Part 8 : Using Cube Designer

• Goal of Cube Designer
  • Basic features
• Database Introspection
• Defining Cube
• Defining Dimension
• Defining Hierarchy
• Defining Level
• Defining Measure