Course Description

This 5-day BW405 SAP BW/4HANA Query Design and Analysis training course provides an overview of SAP BW/4HANA and detailed knowledge to design BW Queries in both SAP BW/4HANA and SAP BW powered by SAP HANA. Users of either system will gain the knowledge to create query definitions using the eclipse-based BW Query Designer in SAP HANA Studio and to make them available for analysis.

All ExistBI trainers are SAP certified and enthusiastic! The course is offered onsite or via live instructor-led virtual classroom. All delegates receive course materials and access to our licensed environment for hands-on labs.

Course Summary

Next Public Course Dates

UK & Europe:

  • 24 - 28 November 2025
  • 8 - 12 December 2025
  • 12 - 16 January 2026

US & Canada:

  • 17 - 21 November 2025
  • 1 - 5 December 2025
  • 15 - 19 December 2025

More dates

Prerequisites
  • Essential: No pre-requisites
  • Recommended: Experienced and sound knowledge of the subject matter of at least one SAP Business Suite or one SAP S/4HANA application course
Duration
  • 5 Days
Available Formats
  • Public Virtual Live Instructor-Led
  • Private Virtual Live Instructor-Led
  • Private Onsite
Audience
  • Application Consultant
  • Business Analyst
  • Power Users
  • Data Consultant/Manager
  • User

Course Modules

  • Introduction to SAP HANA and SAP BW/4HANA
  • Report Launching and Navigation in Reports
  • Simple Queries
  • Key Figures in Queries
  • Characteristics, Attributes, and Hierarchies in Queries
  • Structures in Queries
  • Variables in Queries
  • Exceptions and Conditions in Queries
  • Report-Report Interface
  • Query Performance Optimization
  • Query Management
  • Authorizations Overview
  • SAP Analytics Overview
  • SAP Analytics Cloud Overview

Testimonials

The trainers clear and obvious enthusiasm for number crunching, analytics, and teaching others is infectious. He doesn’t waste time, shows exactly what you need to know and is genuinely hilarious.

Every one of my employees had tons of positive stuff to say.

★★★★★

- Benjamin G, MXSG Analysis and Integration Chief, US Air Force

Absolutely loved the enthusiasm and appreciate the knowledge he brought to class!!!

★★★★★

- Shelly Fruits, KPERS

Thoroughly enjoyed the training. The trainer was fantastic! It is rare but always an awesome experience when a trainer is also an experienced practioner with a breadth of knowledge and hands on experience… even well beyond the subject matter at hand. I had the feeling that the trainer could have answered in detail any question we might have had related to not only BDM but Hadoop and other relevant big data topics as well. Time well spent and I hope to encounter Tomi again.

★★★★★

- Rick Kirk, CTO, Alliant Energy / Ernst & Young

Upcoming Public Virtual Live Instructor-led Course Dates

UK & Europe:

US & Canada:

    To discuss your project requirements, send us a message

      For a free assessment, quick quote or training information, send us a message

        To book this course, please fill in your details and submit the form.

          To book this course, please fill in your details and submit the form.

            To discuss your training requirements or book a class, drop us a line