Becoming a SAP Business Warehouse Query Expert

Become a BW Query Expert by taking part in the "SAP Business Warehouse Plan and Actual Comparison of Book Sales" project. This course will help you build flexible optimized queries and integrate your results with Excel.
Course info
Level
Beginner
Updated
Feb 27, 2017
Duration
2h 25m
Table of contents
Description
Course info
Level
Beginner
Updated
Feb 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
Oct 12, 2015
More courses by Laszlo Meszaros