Requirements

  • Experience analyzing business data
  • A basic understanding of data warehousing concepts
  • Knowledge of various business applications

Audience

  • Business Analysts
  • Data Analysts
  • Business managers
  • Business planners

Overview

SAP Business Warehouse (BW) is a model-driven data warehousing application for integrating, transforming, consolidating, cleansing, and storing data. SAP BW's high-performance infrastructure is based on the SAP NetWeaver ABAP platform.

This instructor-led, live training (online or onsite) is aimed at analysts who wish to use SAP Business Warehouse (BW) and SAP Business Intelligence (BI) to organize, evaluate and interpret critical business data.

By the end of this training, participants will be able to:

  • Understand how SAP Business Warehouse (BW) ties in with other SAP systems.
  • Use SAP Business Warehouse (BW) to grapple large amounts of data from different sources.
  • Apply Business Intelligence (BI) techniques to make better business decisions.
  • Migrate complicated Excel spreadsheet data to the more efficient SAP Business Warehouse (BW) centralized database.
  • Resolve inconsistencies in data that is sourced from multiple stores.

Format of the Course

  • Interactive lecture and discussion.
  • Lots of exercises and practice.
  • Hands-on implementation in a live-lab environment.

Course Customization Options

  • To request a customized training for this course, please contact us to arrange.

Course Outline

Introduction

What is a Business Warehouse (BW)?

What is Business Intelligence (BI)

Overview of SAP Business Warehouse (BW) and SAP Business Intelligence (BI)

How SAP BW Ties in with Other SAP Systems (SAP ERP, etc.)

Overview of SAP's ABAP Language

Setting up the Working Environment

Overview of the SAP BW Dashboard

How Data Flows in SAP BW

Understanding Data Mining in SAP BW

Case Study: Tackling Excel Table Data Nightmares

Planning out a Data Strategy

Acquiring Data from Multiple Data Sources

How Data is Read, Written and Stored

Staging Data in SAP BW

Transforming Data in SAP BW

Transferring Data in SAP BW

Distributing Data to Different BI Systems

Generating Reports in SAP BW

Understanding Data Modeling

Managing a Data Warehouse

Troubleshooting

Summary and Conclusion

Testimonials



Related Courses

SAP S/4 Hana (S/4Hana)

  21 hours

SAP ABAP for Developers

  21 hours

SAP ASE for Database Administrators

  28 hours

SAP Basis for Administrators

  35 hours

SAP Financial Accounting and Controlling (FICO) for Consultants

  28 hours

SAP Hana for Data Analysts

  21 hours

SAP Human Capital Management (HCM) for Consultants

  28 hours

SAP Hybris

  14 hours

SAP MM

  7 hours

SAP ERP Fundamentals

  28 hours

SAP EWM (Extended Warehouse Management)

  35 hours

SAP Automation with UIPath

  14 hours