SAP Business Warehouse Query Fundamentals
Pluralsight
Course Summary
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.
-
+
Course Description
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.
-
+
Course Syllabus
Introducing Query Fundamentals- 16m 20s
—The Query, the Excel Workbook, and Your 5-Minutes-sketch 5m 20s
—The Sketch 5m 59s
—System Requirements 2m 5s
—What Does This Course Give You? 2m 55sCreating the Bookstore Database with the Data Flow Wizard- 48m 29s
—Overview 1m 7s
—Introducing Analytical Databases 3m 41s
—Data Warehousing Concepts 14m 33s
—Creating Book Master Data 13m 36s
—Creating Bookstore Sales Infocube 6m 55s
—Adding Texts to Other Characteristics 7m 40s
—Summary 0m 54sCreating Simple Queries in the Query Designer- 34m 0sCreating New Columns with Virtual Key Figures- 44m 37s