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