Loading...

SAP Business Intelligence Data Warehousing

Course code: SB03

5 days

In this course you will learn the basic components of BI, and then, in more detail, the fundamentals of the data warehousing component.

Course content >

Who Should Attend?

Everybody

Prerequisites

None
Contact us for booking information

Course Contents

In this course you will learn the basic components of BI, and then, in more detail, the fundamentals of the data warehousing component. This will include creation and maintenance of objects, configuration and execution of a data loading processes, and utilizing performance enhancement options. This course will prepare you to: Understand the BI tools and gain a high-level understanding of their functions Define and design a data model in BI to fulfill the information requirements of your company for a cost centre accounting scenario. Use extraction, transformation and loading (ETL) Use SAP Business Content to speed up the implementation of BI know what tools are available for improving query runtime

SAP Net Weaver BI Overview

  • Fundamentals of Data Warehousing and Business Intelligence
  • SAP Business Intelligence (BI) Overview
  • NetWeaver Solution Delivery: IT Practices, Scenarios
  • NetWeaver Business Intelligence: Data Warehousing Overview

BI Data Warehouse Layer

  • Data Warehousing Workbench
  • InfoProviders: Business Purpose
  • InfoObjects: Characteristics
  • InfoObjects: Key Figures
  • The BI InfoCube: An Extended Star Schema
  • Creating InfoCubes

Data Acquisition & Transforms

Systems

  • Data Flow: Overview
  • Loading Master Data from an SAP Source System
  • Loading Transaction Data from an SAP Source System
  • ETL Processes and Loading Hierarchies

Data Acquisition - Non SAP Sys

  • Extraction from Non-SAP Systems: Overview
  • Flat File Loading

Business Content

  • BI Content Discovery (Metadata Repository)
  • BI Content Activation

Other InfoProviders

  • DataStore Objects
  • VirtualProviders and Real-Time Data Acquisition
  • MultiProviders and BI InfoSets

Administration of Data Targets

  • System Administration Tasks in BI: Overview
  • Administration of InfoCubes
  • Administration of DataStore Objects
  • Process Chains

Introduction to Query Performs

  • Introduction to Query Performance Optimization in BI
  • BI Aggregates
  • BI Accelerator
  • Statistics Overview
  • Modelling and Enhancing Web Templates Stylesheets