Description
Course info
Level
Beginner
Updated
February 27, 2017
Duration
2h 25m
Description

Conditional formatting is an important concept for driving the focus of the reader and for ranking the information. Our queries function well, but they are still inflexible. The variables make our queries flexible. In this course, Becoming a SAP Business Warehouse Query Expert, you'll learn how to develop a complex, but flexible sales tactical analysis in Excel with Query Designer and with Bex Analyzer. First, you'll explore conditional formatting with exceptions and creating top lists with conditions in the Query Designer. Next, you'll learn how to create a flexible query with variables. Then, you'll discover how to model and develop an interactive Excel based analysis with design items in Bex Analyzer. Finally, you'll learn how to design the workbook with Bex Styles. By the end of this course, you'll know the important reporting tools of SAP Business Warehouse in all necessary details and be ready to develop nice and flexible Excel based analytical applications that your users will love.

About the author
About the author

Laszlo is an official certified SAP BW/BI consultant and trainer with over 10 years of IT experience. He specializes in SAP Business Warehouse/Business Intelligence but also enthusiastic about other solutions like ABAP, C# and new software practices.

More from the author
SAP Business Warehouse: The Big Picture
Beginner
1h 22m
12 Oct 2015
More courses by Laszlo Meszaros
Transcript
Transcript

Hi everyone, my name is László Mészáros and welcome to my course, “Becoming a SAP Business Warehouse Query Expert”.

I am a SAP Business Warehouse Developer at Expertise Team. SAP Business Warehouse is SAP’s Enterprise Data Warehouse product and it’s used by thousands of companies.

In this course, we are going to learn how to develop a complex, but flexible sales tactical analysis in Excel with Query Designer and with Bex Analyzer.

Some of the major topics that we will cover include:

  1. Conditional formatting with Exceptions and creating top lists with Conditions in the Query Designer
  2. Creating a flexible query with variables
  3. Modeling and Developing an interactive Excel based analysis with Design Items in Bex Analyser
  4. Designing the workbook with Bex Styles
By the end this course, you’ll know the important reporting tools of SAP Business Warehouse in all necessary details and be ready to develop nice and flexible Excel based analytical applications that your users will love.

Before beginning the course, you should be familiar with the basics of SAP Business Warehouse and Query Design.

I hope you’ll join me on this journey to learn SAP Business Warehouse with the Becoming a SAP Business Warehouse Query Expert course, at Pluralsight.