Introduction to Data Warehousing :
- Architecture of Data Warehousing
- OLTP Vs OLAP
- Multi-Dimensional Modeling/ Star Schema Vs Entity Relationship Modeling
- Enterprise Reporting, Query and Analysis
- ETL and Reporting Tools
- Evolution of SAP BW/BI and HANA Landscape
Introduction to SAP BW/BI :
- Evolution of HANA
- Evolution and Architecture of SAP BW with HANA
- Modeling, Extraction and Reporting
- Installation of SAP HANA Studio and SAP GUI
MODELING of SAP BW 7.5 with SAP HANA :
- Introduction of basic terminology and objects
- Data Extraction and Data Flows
Info Providers:
- Master Data – Attributes, Texts, Hierarchies
- Standard, Write-optimized , Direct Update DSO’s
- Standard Info Cube and Virtual Provider
- Logical Layers: Info Set and Multi Provider
- Open Hub Destination
- Analysis Process designer
HANA Optimized Objects
- HANA-Optimized InfoCube
- Semantically Partitioned Object
- Advanced Data Store Object
- Open ODS Views
- Composite Provider