SAP Business Warehouse Query Fundamentals
If you're a business analyst, controller, or developer who wants to create consistent reports and flexible analyses faster, this course is for you. You'll learn how to develop a prototype database, queries, and workbook in SAP Business Warehouse.
What you'll learn
Creating a business analysis often requires several days, and without the right tooling, it can be full of errors once it's finished. This course, SAP Business Warehouse Query Fundamentals, will teach you how to create analyses efficiently and accurately by showing you the fundamentals of creating SAP BW Queries in the Query Designer. We are going to build a BW based Excel workbook. I want you to follow the exercises, because you will be able to perform important tasks in the system. First, you'll be introduced to the Plan and Actual Sales Comparison Workbook that you'll develop throughout the course, learning how to develop the master data tables and infocube, as well as basic data warehousing concepts. Next, you'll work in the Query Designer, creating two different queries and setting properties and filters for each. Finally, you'll finish the column structure of your query and create virtual key figures for it. After watching this course, you'll be able to boost your analytical productivity and answer complex business questions based on the quality database of SAP Business Warehouse with ease.
Table of contents
About the author
Laszlo is an official certified SAP BW/BI consultant and trainer and he is a founding director of Expertise-Team, a consulting, training and software development company (expertise-team.com). Laszlo has over 10 years of experience in the IT field and he is passionate about teaching people how to make the most out of their SAP BW/BI System and doing Data Warehousing, Planning, Reporting and Analyses in the best way possible. He also focuses on technologies like ABAP, C# and other software pra... more