BW Training, done right!

10 years and 1000's of trainees

This is a truly a step-by-step course that will take you into the incredible world of BEx Query Design and Analysis. Watch just a few of our training videos and you will immediately understand how both BEx Analyzer and Query Designer work!

Learn by doing! Each section builds on the others to keep you both challenged and engaged.

After our introductory section, every module is independent so you can start from wherever you’d like. The more you learn and practice these skills, the better you will get. Feel free to take your time while you master this valuable set of Query Design skills.

This class will make you a highly proficient BEx Query Designer. By the end of this course you will confidently add BEx Query Design to your CV.

Course curriculum

  1. 1
  2. 2

    • Query Designer Report Properties

    • Quickly Add a Local Formula to Report Output

    • Query Designer Overview

    • Static Characteristic Restrictions

    • Filtering with Dynamic Variables

    • Selection Option Variable Filter

    • Using Multiple Selection Option Variable Filters

    • Dynamic Text Variables

    • Calculated Key Figures

    • Structures - Characteristic and Key Figure

    • Key Figure Hierarchies

    • Conditions

    • Exceptions
  3. 3

    • Query Designer - BEx Analyzer Filter

    • BEx Analyzer - Creating and Opening Views

    • BEx Query Designer - Creating Filters

    • Query Designer - Workbooks - Copy Sheet and Filtering

    • Local Formulas at the BEx Analyzer Level

    • Restricted Key Figures
  4. 4

    • Certification Prep Documents

Meet Your Instructor

Rob Davis

Professionally, I'm a Data & Analytics Sr. Principal with over ten years of consulting experience spanning insurance, healthcare, manufacturing, utilities, and higher education. I was coached by the best analytics mentors at Accenture & Slalom and today I leverage SAP BI/BW/BO to drive business strategy, increase agility, revamp customer experience, transform the way our customers use data to drive their business. I combine my real-life experience and academic background to deliver professional step-by-step coaching in the space of SAP Business Intelligence. I am also passionate about helping others and love to see each and every one of my students succeed.
portrait of instructor rob davis

FAQ

  • What version of SAP BI/BW?

    SAP BW 7.51. This training is backwards compatible through BW 7.3

  • Will this course help me prepare for BW Certification?

    All of our training courses fully prepare you for both Associate and Professional SAP Certification.

  • Is SAP Access required?

    Having SAP access is not a requirement, but I'd definitely recommend it. Please follow this tutorial to set up your own SAP BW trial: https://sapbwtraining.net/sap-access

  • Is SAP BI/BW a good module to start with?

    Absolutely! I personally started with BI/BW many years ago and loved it. I think BI/BW is a great place to start because it allows you to work with every line of business across an organization (Finance, HR, Accounting, etc.) because all of their data is in SAP BW. So you get exposure to a lot more lines of business. It’s also relatively easy to pick up as all development is done via the BW interface, no coding required.

  • How long will I get access to the course?

    Lifetime access!

  • Will I receive a certificate of completion when I finish the course?

    Yes! You will be granted a certificate of completion upon passing the end of course exam (no limit on retakes).

Testimonials

"Underpriced!"

Alex Cotoara

This course is very good. Has theory and examples and is well structured. Rob should price this kind of information accordingly, right now it is underpriced for the amount of effort he put into it. Great job!

"Perfect course to start learning SAP BW"

Miguel Gomez

I have really enjoyed this course: It goes throw all topics with examples, explaining all the possible options and characteristics. The voice and the sound is perfect. The teacher is also very good, the explanations are clear and he always provides examples. I asked some questions during the course and he has answered me in just a few hours. To sum up, I think it is a perfect course to start learning SAP BW.

"Worth the Investment!"

Joel P

For anyone who want to learn SAP and want to expand their knowledge or break into their BW consultant career I strongly recommend this course. Rob Davis writes in his instructor biography he was trained by the best analytics mentors from various consulting firms, Robs experience and customer support reflects exactly that, very helpful, easy to understand also the metaphorical answers makes it easier to fully grasp. They make it understandable, with help from pdf`s and videos they cover all angles, also the site updates continuously. Worth the investment and a lot cheaper then SAP´s extremely high prices. Great content and concise explanation. They really go the extra mile. Greatly appreciated

"I'm telling my coworkers!"

Chris G

I’ve already told all of my coworkers to take this training. It seems like I know more about BW from HALF of your training than most know at my current employer. They don’t even want to refresh queries – they just want my department to email or post refreshed data. I’m going to try to teach them as much as possible – sign as many up for your training as possible 😉

Let's get you skilled up on BEx Analyzer and Designer right now!

This course will get you quickly up to speed on real world BEx Query development and administration. You'll be amazed at what you'll soon be able to create on your own.
Enroll now

Trusted by