BW310 – BW – Enterprise Data Warehousing

BW310 BW – Enterprise Data Warehousing

Contents

Course Overview

Unit 1: Data Warehousing

  • Lesson: Describing Data Warehouse Systems
  • Lesson: Describing Data Warehouse Architecture
  • Lesson: Using the Data Warehousing Workbench

Unit 2: Master Data Modeling in SAP BW

  • Lesson: Describing InfoObjects
  • Lesson: Creating Characteristic InfoObjects

Unit 3: The Loading of Master Data from SAP DataSources

  • Lesson: Describing Data Flow
  • Lesson: Creating a Characteristic for a Master Data Flow
  • Lesson: Creating a DataSource and Transformation for a Master
  • DataFlow
  • Lesson: Loading a Master Data Flow
  • Lesson: Modeling with the Graphical Data Flow Tool

Unit 4: Loading of Transaction Data from SAP DataSources

  • Lesson: Describing the Core InfoProviders
  • Lesson: Creating a Key Figure InfoObject
  • Lesson: Creating a DataStore Object (DSO)
  • Lesson: Loading Transaction Data into a DataStore Object (DSO)
  • Lesson: Activating data in a DataStore object
  • Lesson: Describing the Extended Star Schema of an InfoCube
  • Lesson: Creating InfoCubes
  • Lesson: Loading Transaction Data into an InfoCube

Unit 5: Loading from Flat File Data Sources

  • Lesson: Loading Data From a Flat File
  • Lesson: Describing the Data Flow in Detail
  • Lesson: Describing the Data Loading Process in Detail

Unit 6: InfoProviders in SAP BW

  • Lesson: Explaining Different InfoProviders Used in SAP BW
  • Lesson: Creating MultiProviders

Unit 7: SAP BI Content

  • Lesson: Using BI Content

Unit 8: Query Performance Optimization

  • Lesson: Optimizing Query Performance
  • Lesson: Monitoring Performance
  • Lesson: Creating and Filling Aggregates

Unit 9: SAP BW Administration

  • Lesson: Describing Administrative Tasks and Tools
  • Lesson: Administering the InfoCubes
  • Lesson: Administering the DataStore Objects
  • Lesson: Creating Process Chains

Course Overview

TARGET AUDIENCE

This course is intended for the following audiences:

  • Application Consultant
  • Technology Consultant
  • Project Manager
  • Application Consultant
  • Business Analyst
  • Business Process Owner/Team Lead/Power User
  • Program/Project Manager
  • Technology Consultant
  • User
  • End User
  • Super / Key / Power User

 

Unit 1 Data Warehousing

Lesson 1: Describing Data Warehouse Systems

Lesson Objectives

After completing this lesson, you will be able to:

  • Discuss the concepts of Business Intelligence and Data Warehousing

Lesson 2: Describing Data Warehouse Architecture

Lesson Objectives

After completing this lesson, you will be able to:

  • Describe Data Warehouse architecture
  • Describe data storage and flow

Lesson 3: Using the Data Warehousing Workbench

Lesson Objectives

After completing this lesson, you will be able to:

  • Use the Data Warehousing Workbench

 

Unit 2 Master Data Modeling in SAP BW

Lesson 1: Describing InfoObjects

Lesson Objectives

After completing this lesson, you will be able to:

  • Describe InfoObjects

Lesson 2: Creating Characteristic InfoObjects

Lesson Objectives

After completing this lesson, you will be able to:

  • Create characteristic InfoObjects

 

Unit 3 The Loading of Master Data from SAP DataSources

Lesson 1: Describing Data Flow

Lesson Objectives

After completing this lesson, you will be able to:

  • Describe data flow

Lesson 2: Creating a Characteristic for a Master Data Flow

Lesson Objectives

After completing this lesson, you will be able to:

  • Create a characteristic for a master data flow

Lesson 3: Creating a DataSource and Transformation for a Master DataFlow

Lesson Objectives

After completing this lesson, you will be able to:

  • Create the DataSources and transformation for a master data flow

Lesson 4: Loading a Master Data Flow

Lesson Objectives

After completing this lesson, you will be able to:

  • Load master data

Lesson 5: Modeling with the Graphical Data Flow Tool

Lesson Objectives

After completing this lesson, you will be able to:

  • Model with the graphical Data Flow tool

 

Unit 4 Loading of Transaction Data from SAP DataSources

Lesson 1: Describing the Core InfoProviders

Lesson Objectives

After completing this lesson, you will be able to:

  • Describe the purpose of InfoCubes and DataStore objects

Lesson 2: Creating a Key Figure InfoObject

Lesson Objectives

After completing this lesson, you will be able to:

  • Create key figure InfoObjects

Lesson 3: Creating a DataStore Object (DSO)

Lesson Objectives

After completing this lesson, you will be able to:

  • Describe a DataStore Object
  • Create DataStore Objects

Lesson 4: Loading Transaction Data into a DataStore Object (DSO)

Lesson Objectives

After completing this lesson, you will be able to:

  • Load transactional data into a standard DSO

Lesson 5: Activating data in a DataStore object

Lesson Objectives

After completing this lesson, you will be able to:

  • Activate data in a DataStore Object

Lesson 6: Describing the Extended Star Schema of an InfoCube

Lesson Objectives

After completing this lesson, you will be able to:

  • Describe different database schema
  • Describe the extended star schema of an InfoCube

Lesson 7: Creating InfoCubes

Lesson Objectives

After completing this lesson, you will be able to:

  • Create InfoCubes

Lesson 8: Loading Transaction Data into an InfoCube

Lesson Objectives

After completing this lesson, you will be able to:

  • Load transaction data into an InfoCube

 

Unit 5 Loading from Flat File Data Sources

Lesson 1: Loading Data From a Flat File

Lesson Objectives

After completing this lesson, you will be able to:

  • Create a flat file DataSource

Lesson 2: Describing the Data Flow in Detail

Lesson Objectives

After completing this lesson, you will be able to:

  • Explain the data acquisition
  • Explain the transformation process

Lesson 3: Describing the Data Loading Process in Detail

Lesson Objectives

After completing this lesson, you will be able to:

  • Describe the data loading process in detail
  • Explain the error Data Transfer Process (DTP) handling

 

Unit 6 InfoProviders in SAP BW

Lesson 1: Explaining Different InfoProviders Used in SAP BW

Lesson Objectives

After completing this lesson, you will be able to:

  • Describe the use cases and properties of different InfoProviders

Lesson 2: Creating MultiProviders

Lesson Objectives

After completing this lesson, you will be able to:

  • Construct a MultiProvider

 

Unit 7 SAP BI Content

Lesson 1: Using BI Content

Lesson Objectives

After completing this lesson, you will be able to:

  • Explain the purpose and usage of BI content

 

Unit 8 Query Performance Optimization

Lesson 1: Optimizing Query Performance

Lesson Objectives

After completing this lesson, you will be able to:

  • Identify performance optimization areas
  • Optimize query performance

Lesson 2: Monitoring Performance

Lesson Objectives

After completing this lesson, you will be able to:

  • Use statistical content

Lesson 3: Creating and Filling Aggregates

Lesson Objectives

After completing this lesson, you will be able to:

  • Create and fill aggregates

 

Unit 9 SAP BW Administration

Lesson 1: Describing Administrative Tasks and Tools

Lesson Objectives

After completing this lesson, you will be able to:

  • Describe administrative tasks and tools

Lesson 2: Administering the InfoCubes

Lesson Objectives

After completing this lesson, you will be able to:

  • Maintain InfoCubes

Lesson 3: Administering the DataStore Objects

Lesson Objectives

After completing this lesson, you will be able to:

  • Maintain DataStore objects

Lesson 4: Creating Process Chains

Lesson Objectives

After completing this lesson, you will be able to:

  • Create and maintain process chains

Submit your request

Is the course not scheduled? Let us know what works for you by clicking the button below and select your Interest. We will do our best to consider your request.

Note: Location can be for a Virtual Classroom

Register Interest

BW310 - BW - Enterprise Data Warehousing

Very Helpfull

User Rating: Be the first one !

Related Courses

  • TBW10 – BW Enterprise Data Warehousing TBW10 BW - Enterprise Data Warehousing Contents Course Overview Unit 1: Data Warehousing Lesson: Describing Data Warehouse Systems Lesson: Describing Data Warehouse Architecture Lesson: Using the Data Warehousing Workbench Unit 2: Master Data Modeling in SAP BW Lesson: Describing InfoObjects Lesson: Creating Characteristic InfoObjects Unit 3: The Loading of Master Data from SAP Data Sources Lesson: Describing Data Flow Lesson: Creating a Characteristic for a Master Data Flow Lesson: Creating a Data Source and Transformation for a Master […]
  • BW310E – BW – Enterprise Data Warehousing Level:Details, Configuration & Transaction Languages:English
  • BW310H – SAP BW powered by SAP HANA: Enterprise Data Warehousing BW310H Data Warehousing with SAP Business Warehouse powered by SAP HANA Contents Unit 1: Introduction to SAP HANA Lesson: Describing the Evolution and the Data Layout of SAP HANA Lesson: Describing the Concepts of Business Intelligence (BI) and Data Warehousing on Any Database Lesson: Outlining the basics of SAP Business Warehouse powered by SAP HANA Unit 2: Master Data in SAP Business Warehouse powered by SAP HANA Lesson: Describing Characteristic InfoObjects Lesson: Creating a generic DataSource Lesson: Creating Transformation and Data Transfer […]
  • BW330E – SAP BW Modeling & Implementation Level:Details, Configuration & Transaction Languages:English
  • HA350 – SAP HANA 2.0 SPS03 – Data Management HA350 SAP HANA 2.0 SPS02 - Data Management Contents Course Overview Unit 1: SAP HANA and Methods of Data Provisioning Lesson: Understanding the Basic Concepts and Capabilities of SAP HANA Lesson: Describing Methods of Data Provisioning Unit 2: Smart Data Access (SDA) Lesson: Describing Smart Data Access Unit 3: SAP HANA Enterprise Information Management (EIM) Lesson: Describing SAP HANA Enterprise Information Management and its Components Lesson: Using the Adapters Lesson: Describing Real-time Replication Lesson: Understanding Data […]
  • HDW410 – SAP SQL Data Warehousing HDW410 SAP HANA Data Warehousing SQL Approach Contents Course Overview Unit 1: Overview and Introduction Lesson: Why SAP SQL Data Warehousing Lesson: SAP HANA Platform Lesson: SAP HANA Development Environment Lesson: SAP HANA Enterprise Architecture Designer Lesson: SAP HANA Data Warehousing Foundation Lesson: SAP Data Hub Unit 2: Reference Architecture, Concepts, and Methods Lesson: Reference Data Warehouse Architecture Lesson: Reference Development Method Unit 3: Data Modeling Lesson: Modeling Approaches Lesson: Modeling Methods […]
  • BW410 – SAP BW/4HANA Data Warehousing BW410 Data Warehousing with SAP BW/4HANA Contents Unit 1: Introduction to SAP HANA Lesson: Describing the Evolution and the Data Layout of SAP HANA Lesson: Describing the Concepts of Business Intelligence (BI) and Data Warehousing on Any Database Lesson: Outlining the basics of SAP Business Warehouse with SAP BW/4HANA Unit 2: Master Data in SAP Business Warehouse BW/4HANA Lesson: Describing Characteristic InfoObjects Lesson: Creating a generic DataSource Lesson: Creating Transformation and Data Transfer Process (DTP) for Attribute Master Data […]
  • BW330H – SAP BW powered by SAP HANA: Data Warehouse Modeling BW330H SAP BW powered by SAP HANA: Data Warehouse Modeling Contents Course Overview Unit 1: Data Modeling with SAP Business Information Warehouse (SAP BW) Powered by SAP HANA Lesson: Understanding Modeling Objectives and Issues Lesson: Understanding SAP HANA From a Modeling Perspective Lesson: Understanding SAP BW From a Modeling Perspective Lesson: Comparing SAP BW with SAP HANA Unit 2: Business Review Lesson: Understanding the Relevant Skills and Exercises Lesson: Getting to know the ItelO Case Study Lesson: Understanding the ERP Model Unit 3: […]
  • SCM210 – SCM Core Interface APO SCM210 Core Interface (CIF) Contents Course Overview Course Goals Course Overview Unit 1: Course Overview Course Overview Unit 2: Architecture of Integration RFC Connection Business System Group Unit 3: Master Data Integration Overview of Master Data Integration Integration Model Master Data Transferring Master Data Changes Unit 4: Basic Master Data in the CIF Locations Product Master Unit 5: Integration of Transaction Data Transaction Data Overview Integration Model Transaction Data Unit 6: Routine Operation/Monitoring/Error […]
  • BPC420 – SAP Business Planning and Consolidation 11.0 version for SAP BW/4HANA: Administration and Planning BPC420 SAP Business Planning and Consolidation 11.0 version for SAP BW/4HANA: Administration and Planning Configuration Contents Course Overview Unit 1: Overview and Architecture Lesson: Discussing the Overview and Architecture Lesson: Describing BPC Components Unit 2: Configuration Lesson: Creating an Environment Lesson: Designing and Managing Dimensions Lesson: Designing and Managing Models Lesson: Designing and Maintaining Security Lesson: Defining Administration Parameters Unit 3: Data Analysis with the EPM Add-In Lesson: Connecting to […]