Course Overview

Data is an important tool in the control of our processes and organisations. To do this effectively and efficiently, we use all kinds of approaches and software tools. This training course familiarises you with the most important concepts so that you can place things in the right context.

Course Objectives

  • Analysis on the basis of supply structured data (e.g. Data Lake)
  • Analysis on the basis of demand-structured data (e.g. Star Schemas)
  • Decoupling point between supply and demand data structures for flexibility (e.g. Data Vault)

Course Content

  • Is data a liability or an asset?
  • Identifying the most important data analysis architectures and the differences between them;
  • Data modelling, what is it good for?
  • Differences and similarities between star schema and Data Vault models. Which one works best in which situation?
  • What is a Data Vault and what can you do with it?
  • Is a Data Vault the same as a data warehouse?
  • In what ways can we collect data from different sources and make this data available in an integrated way for analysis purposes. (data logistics)
  • How do we translate source data to a form that is usable for analysis?

Course Overview

Data Analysis is a process of applying statistical and mathematical techniques systematically to understand, explore, and analyze data to find patterns, and draw inferences that help businesses make data-driven decisions. This typically involves multiple activities such as data collection, exploration, cleaning, pre-processing, and organizing data. Many times, data analysis is an iterative ongoing process where the data is continuously collected and analyzed simultaneously. There are two primary methods for data analysis.

Qualitative techniques and quantitative techniques. Quantitative data analysis techniques involve working with quantitative/numerical data including statistics, percentages, and calculations. These techniques also include working with algorithms, mathematical analysis tools, and software to manipulate data and uncover hidden business value. For example, quantitative data analysis used to assess market data helps a company decide a price for its new product.
Qualitative data analysis involves, working with non-numerical data i.e categorical variables. Qualitative data analysis is also used in many business processes, such as identifying themes and patterns, answering research questions, etc to improve a product.

This course provides an overview of data concepts and what data analysis is and then deep dives into the fundamentals of Data Analysis such as statistics and probability. This course also focuses on widely used data analysis methods such as regression along with detailed steps to perform the same.

*Must have Microsoft Excel in order to complete class activities.

Course Objectives

  • Data Analysis process, benefits and use cases
  • Basic of Probability and Statistics
  • Measure of data spread and distributions
  • Inferential Statistics and Hypothesis Testing
  • Applications of Statistics and Probability theory
  • Forecast trends using linear regression analysis

Course Content

  • 1. All about Data 
      
    Data in the real world
  • A brief on various formats and sources of data
  • 7 V’s of Data
  • Structured vs Unstructured vs Semi-Structured data
  • Data processing types

Introduction to Data Analysis 

  • Need for Data Analysis
  • Applications and Use Cases of Data Analysis
  • Data Analysis Methodology
  • Types of variables
  • Numerical vs Categorial Variables

Descriptive Statistics 

  • Measures of Central Tendency
  • Measures of Dispersion
  • Data Skewness and Kurtosis
  • Understanding Outliers
  • Understanding missing values
  • Role of Descriptive Statistics in Data Analysis

Inferential Statistics 

  • Population and Sample
  • Statistics vs Parameters

Introduction to Probability 

  • Basics of Probability
  • Axioms of Probability
  • Conditional Probability and Bayes theorem
  • 2. Applications of Conditional Probability 
      
    Understanding Probability Distributions 
  • Discrete Probability Distributions
  • Continuous Probability Distributions
  • Performing Distributions in Excel
  • Why understanding Data Distributions is important for Data Analysis

Data Analysis Process 

  • Understanding Covariance and Correlation
  • Understanding univariate vs Bivariate vs Multi variate data analysis
  • Understanding Regression
  • Simple Linear Regression
  • Multiple Linear Regression
  • Exercise

Introduction to Predictive Analytics 

  • Exercise

Course Overview

This 1-day DAMA DMBoK Data Management Specialist course addresses all disciplines as identified Data Modeling specialist exam by the international standard, DAMA Body of Knowledge (DMBOK2) and is aimed to individuals interested in developing concrete professionalism in the field of Data Management with a specialisation in Data Modelling And Design

This course provides a solid foundation of the different information disciplines across the complete Data Modeling, Data Management spectrum and introduces students to the different levels of Industry professional certification the DAMA Certified Data Modelling And Design Professional (CDMP).

The data modeling specialist course explores different data modeling methodologies. It helps understand how to select, implement, and interpret suitable statistical analyses and designs for practical data scenarios and problems. In addition, it explores various features of data modeling including Data Models, Data Implementation, Design Quality Management, Data Designs, Modeling Styles, and System Development Lifecycle among others.

Course Objectives

  • To help understand data modeling methodologies.
  • To help comprehend how statistical designs and analyses work.
  • To help teach the application of data models.
  • To help comprehend different data model styles.
  • To explain how different data designs and models may be utilized for business problems and scenarios.
  • To explain how System Development Lifecycle works.

Course Content

  • Database Design and Data Modeling
  • CDMP Breakdown
  • Explanation of Data Design and Modeling
  • Comprehension of SDLC and Lifecycle
  • Understanding the Development of Data
  • Explanation of a Data Model
  • Representations of Data Models
  • Significance of Data Modeling
  • Reasons for the Production of a Data Model
  • Data Model Levels
  • Symbols of Entity Relationships
  • Notations and Cardinality
  • Enterprise Data Model
  • Physical Data Model
  • Logical Data Models
  • Conceptual Data Models
  • Subject Area Models
  • Independent and Dependent Entities
  • Significance of Comprehending Entities
  • Types of Relationships
  • Recursive Relationships
  • Many to Many Relationships
  • Entity Subtypes
  • Role Name Usage
  • Physical and Conceptual Terms
  • Primary Keys
  • Entity Keys
  • Alternate Keys
  • Benefits and Drawbacks of Natural versus Surrogate Keys
  • Data Model and Process Relationships
  • Components of a Logical Data Model
  • Normalization Rules
  • Normalization Approaches
  • Normalization Definition
  • Principles of Database Design
  • Best Practices of a Physical Database Design
  • Comprehension of Partitioning
  • Transformation of Logical to Physical Data Model
  • ACID Test
  • Classification of Modeling Tools
  • The Alternative to ACID

Course Overview

This course is ideal for those who have detailed cross-functional configuration knowledge in copying control, text control, and output control to reflect business requirements in SAP S/4HANA Sales

Course Objectives

This course will prepare you to:

  • Understand and consider complex relationships in mapping organizational structures
  • Configure and adapt special functions such as copy control and text control
  • Configure output control (NAST-based and BRFplus-based Output Management)
  • Adjust Material Master Record Field Selection
  • Understand system modification options

Course Content

  • Organizational Structures
    • Creating Organizational Elements
    • Applying Shared Master Data and Cross-Division Sales
  • Copy Control
    • Understanding the Concept of Copy Control
    • Modifying Copy Control for Sales Documents
    • Analyzing Copy Control for Delivery and Billing Documents
  • Text Control
    • Identifying Text Sources
    • Configuring Text Control
  • Output
    • New Output Management
    • Output Determination with Condition Technique
    • Understanding Basic Principles of Processing Printed Output
  • Material Master Record Field Selection
  • Enhancements and Modifications
    • Using Enhancement Technology
    • Performing System Modifications Using Classic Enhancement Technology
    • Performing System Modifications Using the Enhancement Framework
    • Adding New Fields

Course Overview

Create your own data model and canvas app to support a scenario for a fictional company. You’re provided high-level specifications on the custom tables, columns and canvas app needed to complete this project.

Course Content

Get started with Power Apps canvas apps

This module introduces the learner to Power Apps. It starts with an introduction video briefly describing the “why” (case for Power Apps) and the “what” for what users can do with Power Apps. The units then take users through the “how” instilling in them the confidence that they can use Power Apps to interact with their data.

  • Introduction to Power Apps
  • Start Power Apps
  • Exercise – Create your first app in Power Apps
  • Power Apps data sources
  • Exercise – Create an app from Excel using Copilot
  • Use Power Apps with Power Automate and Power BI
  • Designing a Power Apps app
  • Check your knowledge
  • Summary

Customize a canvas app in Power Apps

In this module, we’ll show learners how to customize their app, a necessary skill for taking advantage of the capabilities of Power Apps. This unit builds upon the app produced in the first unit.

  • Improve your app by making basic customizations
  • Explore controls and screens in canvas apps
  • Exercise – Introduction to formulas in canvas apps
  • Exercise – Create basic screen navigation for a canvas app
  • Check your knowledge
  • Summary

How to build the User Interface in a canvas app in Power Apps

In this module, learners will learn how to build UI for their app including theming, icons, images, personalization, form factors and controls. In their learning path, thus far, learners have used basic controls with little to no customization. This unit shows how to make an app more personal and help it fit branding or personal requirements.

  • Use themes to quickly change the appearance of your app5 min
  • Brand a control
  • Icons
  • Images
  • Personalization
  • Build for phones or tablets
  • Exercise – Create and adjust UI for a new canvas app
  • Check your knowledge
  • Summary

Work with external data in a Power Apps canvas app

Do you need to connect an app to access data? Then this module is for you. It focuses on connecting your app to a data source.

  • Introduction
  • Data-source overview
  • Add a data source
  • Add Office 365 users to your application
  • Display and interact with your data in a gallery
  • Move data between collections and data sources by using Collect
  • Exercise – Work with external data in a canvas app
  • Check your knowledge
  • Summary

Write data in a Power Apps canvas app

Forms can be used to view, edit, and create records. This module demonstrates how to use forms to write data to your data source. Topics will include form setup, the different form modes, and how to configure a submit button.

  • Introduction to forms
  • Form modes
  • Adding and customizing an Edit form
  • Submit your form
  • Special properties
  • Exercise- Working with forms
  • Check your knowledge
  • Summary

Publish, share, and maintain a canvas app

You’ve built your first app. Now, it’s time to publish, share it with others, and maintain subsequent versions of the app.

  • Introduction
  • Exercise – Publish your app
  • Exercise – Share your app
  • Exercise – Maintain your app
  • Application lifecycle management
  • Check your knowledge
  • Summary

Guided Project – Create and manage canvas apps with Power Apps

Create your own data model and canvas app to support a scenario for a fictional company. You’re provided high-level specifications on the custom tables, columns and canvas app needed to complete this project.

  • Introduction
  • Prepare
  • Exercise – Create a canvas app that connects to a data source
  • Knowledge check
  • Summary

Course Overview

This course will give you a comprehensive overview and in depth knowledge of the planning process in SAP S/4HANA. After attending this class, you will understand the major business processes, functions and configuration in consumption-based planning.

Course Objectives

  • Explain the materials planning process in Materials Management and Operations
  • Use the different consumption-based MRP procedures
  • Describe the forecasting technique and its function

Course Content

Consumption-Based Planning

  • Describing the basics and prerequisites of material requirements planning (MRP)
  • Outlining different MRP procedures
  • Maintaining the material master for consumption-based planning
  • Setting up a reorder point plan

Planning Run

  • Describing the planning run
  • Executing a planning run
  • Converting planning results
  • Evaluating the planning results
  • Calculating lot sizes
  • Outlining MRP Live

Forecasting

  • Explaining basics of the forecast
  • Executing and postprocessing the forecast
  • Performing forecast-based planning
  • Performing the time-phased planning
  • Performing automatic reorder point planning

Additional Options in Consumption-Based Planning

  • Explaining source determination in materials planning

Course Overview

In this new training SM255, you will get to know the different elements of SAP Solution Manager Change Request Management. Then, you will configure the SAP standard processes of the Change Request Management scenario. Additionally, you will outline the different adaption capabilities of these processes to your needs. The theoretical lessons are supported by various hands-on.

Course Objectives

  • This course will prepare you to:
    • Describe the various elements of SAP Solution Manager Change Request Management
    • Configure the SAP standard process for the Change Request Management scenario
    • Outline how to customize the Change Request Management process according to your needs

Course Content

  • Overview Change Request Management
  • Basic Setup Steps for Change Request Management
  • Master Data
  • Defining the Landscape for Change Request Management
  • The Change Request Management Processes
  • Monitoring
  • Retrofit
  • Customizing Change Request Management

Course Overview

Business analysis is achieving worldwide recognition as a profession in its own right. The CBAP® and CCBA® designation are marks of distinction for intermediate and advanced-level practitioners, recognizing their demonstration of the knowledge and skills necessary for effectiveness and a professional level of competence in business analysis principles and practices. This CBAP certification training course is intended to comply with the International Standards Organization (ISO) 17204 standard for certifying the competence of personnel. 

Course Objectives

Analyze and remember the most important elements of the Business Analysis Body of Knowledge®Record progress and identify gaps in your business analysis qualificationsAnalyze your unique combination of education, knowledge, and skills to determine the best way to package it for the CBAP or CCBA applicationExplore the nature and construction of the application and examinationImprove your chances of success with the CBAP certification processInfluence your organization to recognize the value of CBAP / CCBA certificationImportance of documenting your education and experience for continued certification requirementsWhat knowledge from the BABOK and other sources comprise the CBAP and CCBA certificationsUse practical methods for improving testing success

Course Content

1. Welcome to Boot Camp

• Components of the CBAP® Certification
• Components of the CCBA® Certification
• Introduction to the CBAP and CCBA Examinations
• Philosophy of the Exams
• Overview of CBAP and CCBA Exam Content
• Overview of the CBAP/CCBA Prep Boot Camp

2. CBAP/CCBA Certification: The Credentials

• The International Institute of Business Analysis (IIBA)
• The CBAP Certification
• The CCBA Certification
• The Certification Application Processes
• The Examination Processes
• The Professional Code of Conduct
• The Examination Structures

3. Business Analysis and Key Concepts Overview

• What is Business Analysis?
• The Role and Competencies of the Business Analyst
• The Systems/Software Development Life Cycle (SDLC)
• Project and Requirements Life Cycle Management
• Project Roles and Competencies
• Requirements Engineering Basics
• Levels of Requirements, Tool and Techniques
• Perspectives, Systems, Processes, and Actors

4. The Business Analysis Knowledge Areas

• Business Analysis Planning and Monitoring
• Elicitation and Collaboration
• Requirements Life Cycle Management
• Strategy Analysis
• Requirements Analysis and Design Definition
• Solution Evaluation

5.  Underlying Competencies

• Analytical Thinking and Problem Solving
• Behavioral Characteristics
• Business Knowledge
• Communication Skills
• Interaction Skills
• Tools and Technology

6. Techniques

• Elicitation and Collaboration Techniques
• Diagramming and Modeling Techniques
• Root Cause Analysis Techniques
• Acceptance and Evaluation Definition Techniques
• Post-Project Assessment Techniques

7. Perspectives

• Agile
• Business Intelligence
• Information Technology
• Business Architecture
• Business Process Management

8. A Guide to Success on the Exams

• Review of Key Topics
• Key Tips to Remember for the Exam
• Final Test Hints and Tricks
• Practice examination

Course Overview

This course is designed to provide an overview of the fundamental concepts and procedures of manufacturing (aka production planning and execution) within SAP S/4HANA Enterprise Management.

Course Objectives

  • Provide an overview of the fundamental concepts and procedures of planning
  • Gain an overview of the manufacturing methods.

Course Content

Overview of Supply Chain Planning

  • Supply Chain Planning at a Glance
  • Fiori and System Landscape

Master Data

  • General Master Data in Manufacturing
  • Master Data for In-house Production

Demand Planning

  • Principles and Tools for Demand Planning

Demand Management

  • Demand Management Basics
  • Make-to-Stock Production
  • Make-to-Order Production

Material Requirements Planning

  • MRP Basics
  • MRP Live
  • Production Planning and Detailed Scheduling

Overview of Production Execution

  • Production Types

Production with Production Orders

  • Production Orders: Characteristics and Execution

Production with Process Orders

  • Process Orders: Characteristics and Execution
  • Production with Repetitive Manufacturing

Repetitive Manufacturing: Characteristics and Execution

  • Material Staging with Kanban

Kanban: Characteristics and Execution

Course Overview

Analyze your business today and map the path to tomorrow.

In this course, you’ll learn to model business processes as they are currently enacted, assess the quality of those business processes, and collaborate with the stakeholders to identify improvements.

The course begins by teaching you the roles and responsibilities of the business analyst and the process for analyzing business systems, including how to determine a business system’s health. You will learn how to identify business processes that could become more streamlined. Master the process of communicating with stakeholders to understand their process needs as well as their perceptions of the problems. Using seven different modeling techniques, you’ll explore different facets of the business process, identify the most effective solution to the process, and clearly define the future process state. Once a new process is defined, you’ll learn how to convey those process changes to others, gain organizational support for making the changes, and plan for a successful change project.

Course Objectives

On completion of this course delegates will be able to;

  • Determine the quality of a business process
  • Identify business processes that need to be analyzed and possibly improved
  • Define “business process analysis” and the responsibilities of the business analyst
  • Determine when a process action team (PAT) is called for
  • Charter and lead a process action team
  • Identify all of the stakeholders in a business process
  • Choose appropriate information gathering technique(s) for each type of stakeholder
  • Prepare for and perform information gathering activities
  • Provide feedback to stakeholders to verify and gain additional information
  • Define the goal of a business process
  • Determine how to measure the effectiveness of a business process
  • Use a variety of methods to model a business process and its data
  • Perform root-cause analysis of the problems with a business process
  • Enumerate options for improving a business process
  • Make a sound business case for improving a business process
  • Obtain stakeholder buy-in and sign-off
  • Plan a process improvement project
  • Analyze the results of a process improvement project

Hands-On Exercises

  • Perform the Deming bead experiment
  • Choose a business process to analyze
  • Complete a project mini-charter
  • Complete a stakeholder analysis
  • Identify information gathering methods for your project
  • Prepare to interview the stakeholder
  • Interview the stakeholder
  • Document the information gathered
  • Perform and document a GQM analysis of your process
  • Prepare for a follow-up meeting with the stakeholder
  • Hold a follow-up meeting with the stakeholder
  • Update information about the process
  • Use the ETVX process definition paradigm
  • Draw a SIPOC diagram
  • Draw a use case diagram
  • Draw a process flowchart
  • Draw a swim lane diagram
  • Draw a data flow diagram
  • Draw an entity relationship diagram
  • Hold another feedback session with the stakeholder
  • Perform causal analysis
  • List sources of standards and industry best practices
  • Use the STP method to identify improvement options
  • Model the improved process
  • Prepare the process improvement proposal
  • Present the process improvement proposal
  • Prepare a project plan for your process improvement
  • Provide feedback on the BPA process

Course Content

Define the “Quality of a Business Process

  • People
  • Process
  • Tools
  • Inputs

Choose a Business Process to Analyze

Understand the Business Analysis Process

  • Definition of “Business Process Analysis”
  • The Process of Business Process Analysis
  • Role of the Business Analys

Charter the Process Action Team

Identify the Stakeholders of a Business Process

Choose Information Gathering Techniques

Gather Information

  • Preparation
  • Execution
  • Feedback & Validation

Document the Process Goal and Metrics

  • Perform GQM Analysis

Model the Current (As-Is) Process

  • ETVX Process Model
  • SIPOC Analysis
  • Use Case Diagrams
  • Process Flowcharts
  • Swim Lane Diagrams
  • Data-Flow Diagrams (DFD)
  • Entity-Relationship Diagrams (ERD)

Determine Causes of Problems

  • Fishbone (Ishikawa) Causal Analysis

Determine Process Improvement Options

  • Modeling the Improved (To-Be) Process

Make the Business Case for Process Improvement

Plan the Implementation

Hold a Project Retrospective