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.

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.

• Introducing Query Fundamentals 16mins
• Creating the Bookstore Database with the Data Flow Wizard 48mins
• Creating Simple Queries in the Query Designer 34mins
• Creating New Columns with Virtual Key Figures 44mins