Project 1: Building a COPA Model Using HANA Analytical View
Problem Statement: How to work with the COPA data model and successfully do reporting
Topics: This SAP HANA project lets you work with SAP HANA COPA (Controlling and Profitability Analysis) to evaluate market segments and classify them according to products, customers, or any combination of it. The aim of this project is to provide solutions for sales, marketing, product management, and corporate planning, along with offering support for internal accounting and decision-making.
- Building of COPA data models
- Creating detailed reports
- Account-based valuation approach
Project 2: Building HANA Data Models for Large Datasets
Problem Statement: How to make the most of an organization’s data assets and gain competitive advantage
Topics: In this project, you will be working on an enterprise dataset for helping an organization increase its revenue, while reducing cost and risk through better business decision-making. The business has outlets in different countries; sales are done for multiple products, and also the promotion of the business is done in different modes. Throughout the project, the Referential Integrity is maintained with tables/dataset files.
- Loading the Excel files to schema/tables
- Replicating and loading the tables
- Building a dashboard and a storyboard with SAP Lumira
Project 3: Implementing a Sales Project with SAP HANA Calculation View
Problem Statement: How to build a sales model using Calculation View in HANA
Topics: In this SAP HANA project, you will link TSPA, which is a standard SAP table for storing the Organizational Unit: Sales Divisions information. This is available within R/3/ECC SAP systems depending on the version and the release level. You will also link the customer, material, sales org, and sales-vision calculation views in order to create a Sales Billing CA view.
- Deploying SAP HANA Calculation View
- Using Star Join on a Fact Table
- Working with SAP HANA Organizational Unit
Project 4: Developing Reports Using SAP HANA
Problem Statement: How to create reports using SAP HANA
Topics: In this project, you will get detailed information about creating SAP HANA reports using SAP Business Objects Explorer, deploying various SAP HANA views such as attribute, analytical, and calculation views, creating SAP HANA Crystal Reports, and deploying MDX Provider for connecting HANA systems to Excel data, data modeling techniques, etc. Once you’ve completed your project, you’ll gain the expertise to build reports from multiple data sources and display them for valuable insights.
- Creating SAP HANA reports
- Deploying SAP HANA Business Objects Explorer
- Working with SAP HANA Crystal Reports
- Deploying MDX Provider