Autoplay
Autocomplete
Previous Lesson
Complete and Continue
SAP Analysis for Microsoft Office Training
Glossary of Terms
Glossary of SAP Analysis for Microsoft Office
Refer a Friend and Get 10% off for you and for them
Give 10% and Get 10%
Follow our LinkedIn SAP Learner Community for lot of Free Content
SAP Learner Community of LinkedIn
Session 1 - Introduction to Analytics
Session Video - Introduction to Analytics (55:00)
Lab Activity - Introduction to Analytics
Quiz
Session 2 - Introduction to Analysis for Office
Session Video - Introduction to Analysis for Office (26:19)
Assignment - Introduction to Analysis for Office
Lab Activity - Introduction to Analysis for Office
Quiz
Session 3 - Basic Navigation and Features
Session Video - Basic Navigation and Features - Part A (52:42)
Session Video - Basic Navigation and Features - Part B (38:46)
Assignment - Basic Navigation and Features
Lab Activity - Basic Navigation in SAP Analysis for Microsoft Office
Quiz
Session 4 - Dimension Properties
Session Video - Dimension Properties (44:27)
Assignment - Dimension Properties
Lab Activity - Modifying Dimension Properties in an SAP Analysis for Microsoft Office Model
Quiz
Session 5 - Measure Properties & Query Properties
Session Video - Measure Properties Query Properties (50:06)
Assignment - Measure Properties and Query Properties
Lab Activity - Analyzing Data with Measure and Query Properties in SAP Analytics Cloud
Quiz
Session 6 - Filtering Data
Session VIdeo - Filtering Data (68:40)
Assignment - Filtering Data
Lab Activity - Filtering Data in Microsoft Excel
Quiz
Session 7 - Advanced Calculation, Filter by Measure, Hierarchy
Session Video - Advanced Calculation, Filter by Measure, Hierarchy (63:22)
Assignment - Advanced Calculation, Filter by Measure, Hierarchy
Lab Activity - Advanced Calculation, Filter by Measure, Hierarchy
Quiz
Session 8 - Suppressing zero, Filter Inserting in Workbook
Session Video - Suppressing zero, Filter Inserting in Workbook (52:13)
Lab Activity - Suppressing Zeros and Inserting Filters in Excel
Quiz
Session 9 - Formatting options in SAP Analysis for Office
Session Video- Formatting options in SAP Analysis for Office (29:21)
Assignment - Formatting options in SAP Analysis for Office
Lab Activity - Formatting Options in SAP Analysis for Office
Quiz
Session 10 - Advanced Features
Session Video - Advanced Features (46:41)
Assignment - Advanced Features
Lab Activity - Advanced Features in SAP Analysis for Microsoft Office
Quiz
Session 11 - Charting, Reporting
Session Video - Charting, Reporting (39:34)
Assignment - Charting, Reporting
Lab Activity - Charting, Reporting in SAP Analysis for Microsoft Office
Quiz
Session 12 - Inserting Lines in Crosstabs, Combining Datasets, and Recapping Charts
Session Video - Inserting Lines in Crosstabs, Combining Datasets, and Recapping Charts (52:26)
Assignment - Inserting Lines in Crosstabs, Combining Datasets, and Recapping Charts
Lab Activity - Inserting Lines in Crosstabs, Combining Datasets, and Recapping Charts
Quiz
Session 13 - Linking the Dimension and Combining Cross Tabs
Session Video - Linking the Dimension and Combining Cross Tabs (48:07)
Assignment - Linking the Dimension and Combining Cross Tabs
Lab Activity - Linking the Dimension and Combining Cross Tabs
Quiz
Session 14 - Grouping Members
Session Video - Grouping Members (45:22)
Assignment - Grouping Members
Lab Activity - Grouping Members in SAP Analysis for Microsoft Offic
Quiz
Session 15 - Conditional Formatting
Session Video - Conditional Formatting (42:02)
Assignment - Conditional Formatting
Lab Activity - Conditional Formatting
Quiz
Session 16
Session Video (42:02)
Assessments
Assessment - Introduction to SAP Analysis for Microsoft Office
Assessment - Basic Navigation and Features
Assessment - Report Building
Assessment - Data Analysis and Visualization
Assessment - Data Modeling and Planning
Assessment - Integration with Other SAP Tools
Assessment - Advanced Topics
Additional Lab Activity
Lab Activity - Installing SAP Analysis for Microsoft Office
Lab Activity - Connecting to SAP Systems and Data Sources
Lab Activity - Exploring the SAP Analysis User Interface
Lab Activity - Basic Data Retrieval and Filtering
Lab Activity - Navigating the Workbook Environment
Lab Activity - Working with Queries and Workbooks
Lab Activity - Formatting and customizing Tables and Charts
Lab Activity - Using Formulas and Functions
Lab Activity - Creating and Modifying Reports
Lab Activity - Grouping and Aggregating Data
Lab Activity - Adding Calculations and Custom Measures
Lab Activity - Enhancing Reports with Filters and Slicers
Lab Activity - Building Interactive Dashboards
Lab Activity - Creating Data Visualizations with Charts and Graphs
Lab Activity - Exploring Data trends with Conditional Formatting
Lab Activity - Using Drill-down and Drill-through Functionality
Lab Activity - Creating Data Models with the Analysis for Office Modeler
Lab Activity - Working with Hierarchies and Dimensions
Lab Activity - Creating Input-ready Reports for Planning and Budgeting
Lab Activity - Creating and maintaining Data Models in the Analysis for Office Modeler
Lab Activity - Connecting to SAP BW and HANA Systems
Lab Activity - SAP BusinessObjects Web Intelligence Reports
Lab Activity - Creating and using SAP Analysis Office add-ins for Microsoft Excel
Lab Activity - Collaborating with other users in the SAP Analytics Cloud
Lab Activity - Using the Analysis for Office SDK for custom development
Lab Activity - Performing Advanced Data Modeling with BEx Query Designer
Lab Activity - Using SAP Analysis for Office with SAP S4HANA
Lab Activity - Performing predictive analytics with SAP Analysis Office and SAP Predictive Analytics
Capstone Projects / Case Studies - SAP Analysis for Microsoft Office
Capstone Project - SAP Analysis for Microsoft Office - Developing a Comprehensive Budgeting and Financial Reporting System
Capstone Project - SAP Analysis for Microsoft Office - Developing a Sales Analytics Dashboard and Report
Capstone Project - SAP Analysis for Microsoft Office - Developing an Integrated Supply Chain Analytics System
Interview Questions and Answers
Interview Questions - SAP Analysis for Microsoft Office - Set 1
Interview Questions - SAP Analysis for Microsoft Office - Set 2
Interview Questions - SAP Analysis for Microsoft Office - Set 3
Configuration Guides (Downloaded from the Internet as it is available for Public Use)
Configuration Guide - Analysis Plug-in User Guide
Configuration Guide - SAP Analysis for Microsoft Office - Practical Guide
Interview Questions and Answers
Interview Questions - Set 1
Interview Questions - Set 2
Interview Questions - Set 3
Prepare your LinkedIn Profile
LinkedIn Cheat Sheet
Prepare your Resume
Resume Cheat Sheet
Final Quiz
Test your Skills!
Teach online with
Assignment - Linking the Dimension and Combining Cross Tabs
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock