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.