Autoplay
Autocomplete
Previous Lesson
Complete and Continue
SAP Analysis for Microsoft Office Training
Glossary of Terms
Glossary of SAP Analysis for Microsoft Office
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
Session Video - Suppressing zero, Filter Inserting in Workbook
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock