SAC Planning & Reporting - Complete Hands-On Training

Descripción

SAC Planning & Reporting - Complete Hands-On Training based on real customer scenario of P&L (income statement) planning This course will take you from zero to hero with a detailed hands-on scenario in SAC planning using one of the most frequently used planning scenarios - P&L (Profit & Loss, a.k.a Income Statement) planning. This is not a theoretical PPT-only driven training, but rather an end-to-end customer scenario-driven, completely hands-on course. After attending this training, you will also be able to take your certification with confidence and crack interviews. This training covers, in detail (hands-on) all the important SAC modeling, reporting & planning concepts: • SAC tool - look and feel • SAC connectivity with SAP and Non-SAP sources. • SAC Modelling Fundamentals - Public dimension, Private dimension, Hierarchies, Properties and much more. • Datasets in SAC and their usage. • Types of models in SAC (Analytic, Planning, Classic vs New measure-based) and the creation of each of these models from scratch. • Migration of classic models to new measure-based models. • Designing SAC stories using the GDrive flat files. • Basic and Advanced reporting functionalities in SAC Stories, such as blending, input controls, Geo-maps, and R-script-based widgets. • Creating Composites in SAC. • Creating all types of calculated and restricted measures in SAC. • Connecting SAC to S4HANA via oData services generated out of SAP Stnd CDS Views. • End-to-end planning of the customer scenario of P&L planning. • Creating FSV and S4HANA and loading data into SAC public dimensions. • Loading hierarchies from S4HANA to SAC public dimensions. • Loading transaction data from S4 CDS Views (oData service) to SAC planning model. • Creating planning input templates. • Creating Planning versions (public and private) using Version Management. • Creating Data Upload triggers in SAC planning for easy upload of forecast data. • Creating Data Actions using the advanced formula for a complex scenario. • Debugging data actions using the Tracing functionality. • Creating Multi actions in SAC. • Creating Data Locking to safeguard planning versions from modifications. • Creating workspaces in SAC for better content and security management. • Creating rolling forecast layouts in SAC planning input templates and reports. • Creating Allocations in SAC planning. • Creating simple and complex currency conversions in SAC. • Creating VDTs (Value Driver Trees) in SAC. • Creating Calendar tasks and using the calendar automation feature in SAC. • Creating the final report in SAC and concluding the end-to-end planning application. • Creating transport routes in SAC using the content network. • Business Content installation in SAC.

Lo que aprenderás

• Build an end-to-end SAC Planning & Reporting Application for FP&A - P&L planning customer scenario
• Complete hands-on based step-by-step instructions for modeling, reporting and planning in SAC
• Integrate S4HANA master and transaction data CDS Views using oData services and extract the attributes, text, hierarchies and transaction data into SAC planning
• Learn all the basic planning features such as Version Management, Disaggregation, Data Locking, Data Actions, Multi Actions, Allocations and Currency Conversion
• Learn all the advanced planning features such as VDTs, Rolling Forecast Layout & Calendar Functionality
• Learn all the basic Reporting functionalities such as ODEs, Input Controls, Story filters, Linked Analysis, Geo Maps, Blending, Sorting and Ranking
• Learn all the Advanced Reporting functionalities such as Variance analysis, Reference Lines, Conditional Formatting, Calculated and Restricted measures
• Learn about Live data connectivity between BW4HANA and SAC, S4HANA and SAC, Native HANA and SAC
• Learn about complex advanced-formula based data actions to achieve complex business requirements
• Interview Preparation Tips & tricks to excel any technical or managerial SAC interview
• Learn all the modeling aspects of both Analytic and Planning models such as private vs public dimensions, calculated dimensions, inverse formula and migration

Requisitos

• No programming skills or functional knowledge required. You will learn from the very basics step-by-step