Page Content
On this page, you will find the following resources on Modeling & Wrangling:
Getting Started
- Article: Introduction to Data Models in SAP Analytics Cloud
- Webinar: Getting Started with Data Preparation and Modeling Calculations
- Help: Create your First Model
- Video: How to Import Data into Models
- Video: Create a Model from a Spreadsheet
- Video: How to Create Models from Files
- Help: Introduction to the Modeler
Data Model Types
In Q2/2021 the "New Model" has been introduced. Now, modelers have the choice between the new and the classic account model. Each model type has its specific advantages and strengths depending on what you would like to achieve with it. Therefore we invite you to learn about the new model to be able to make the right decision for each project.
- Help: Getting Started with the New Model Type
- Webinar: Introducing the New Model in SAP Analytics Cloud
- Webinar: Data Acquisition for Planning with the New Model
- Webinar: Advanced Currency Conversion using the New Model
For modeling specifically for planning use cases, please check out the respective section on the Planning topic page.
Helpful Resources
- Videos: Working with Models Video Playlist
- Help: Data Integration Limits for Models, Datasets, and Stories
- Videos: How to Create Hierarchies in Datasets and Models
- Help: Building a Query for Incremental Loads
- Article: Importing Transaction Data into a Model from a File
- Videos: How to Create Datasets or Stories with Embedded Datasets
- Blog: Updating the model with additional or new fields in SAP Analytics Cloud
- Blog: Improved Models with Structure and Data Foundation View
- Blog: Data Import Methods in Import Data Connections – SAP Analytics Cloud
- Blog: Tip & Trick for Master Data Search with SAP Analytics Cloud
- Video: How to Blend Data Sources in Your Stories
- Blog: Step by step guide to create a Planning Model in Sap Analytics Cloud using Excel file
- Blog: How to model & analyze data with SAP Analytics Cloud -Series
Calculations
- Help: All Formulas and Calculations
- Article: Applying Aggregation in SAP Analytics Cloud
- Article: Working with Formulas in SAP Analytics Cloud
- Video: Calculated Measures and Formulas in SAP Analytics Cloud
- Video: Aggregations and Exception Aggregations in SAP Analytics Cloud
Geo
- Help: Creating a Model with Coordinate or Area Data for Geospatial Analysis
- Video: Enrich Geographic Dimensions in an Imported Data Model
- Help: Analyzing Geographical Data with SAP Analytics Cloud and SAP HANA Spatial
- Blog: Choropleth Layer integration with SAP BW Live Connection in SAP Analytics Cloud
- Blog: Enhancing BW objects with geo-capabilities
