Duration 2 Days 12 CPD hours This course is intended for Application Consultant Business Analyst Business Process Architect Business Process Owner / Team Lead / Power User Developer Enterprise Architect Solution Architect Trainer Overview This course will prepare you to: Understand the basic concepts of SAP data warehousing Position the value-added of SAP Data Warehouse Cloud Integrate on-premise SAP Sources Model in SAP Data Warehouse Cloud Consume Data in SAP Analytics Cloud This course will prepare you to:Understand the basic concepts of SAP data warehousingPosition the value-added of SAP Data Warehouse CloudIntegrate on-premise SAP SourcesModel in SAP Data Warehouse CloudConsume Data in SAP Analytics Cloud Course Outline Getting started with data warehousing and the training environment Short introduction in SAP BW Bridge and other sources SAP Data Warehouse Cloud: -Introducing SAP Data Warehouse Cloud -Describing Spaces, integration options, operations and best practices -Introducing modeling in the Data Builder -Introducing modeling the Business Layer Describing consumption options in SAP Analytics Cloud Additional aspects in SAP Data Warehouse Cloud Outlook and roadmap Additional course details: Nexus Humans DSP01 SAP Introduction to SAP Data Warehouse Cloud training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the DSP01 SAP Introduction to SAP Data Warehouse Cloud course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.
Microsoft Excel training | Excel Courses for Accountants: Excel Courses Overview Microsoft Excel is the world's most popular spreadsheet program, learning how to use the software with Osborne Training shows that you've taken one of the best Excel training courses available. Comprehensive excel courses come with up to date material to practice at home and during your class. Excel courses for accountants This course is a highly recognised excel course for accountants. We will also provide a step by step manual of all the tricks you can do using Excel spreadsheets to gain better management reporting and budgeting skills. It is a fundamental program for professional Accountants. Excel spreadsheets are the most powerful tool, extensively used for reporting and analysis. Having advanced skills in excel can excel your career and help you to stand ahead of the competitive job market. Advanced skills in Excel is a must for any potential professional accountants and who are already running a practice or considering opening a practice. Certificate of Attendance Excel Course Content Creating worksheets, formatting text Simple and complex formulas Handling rows and columns Average, max and min functions and using charts. Use of IF Formula Summing Techniques Cell References Formula Linking Tables and Bordering Look up References (Vlookup, Hlookup, etc) Data Validation Conditional Formatting Date & Time Formulas Charts & Graphs Protection & Security Creating Pivot Table Pivot Table Analysis
This course follows the Institute of Occupational Safety and Health's syllabus. A one-day programme, it is suitable for all people at all levels in the workplace and gives a basic introduction to the principles of environmental management. On successful completion of the course, participants will be able to: Understand the terms 'environment' and 'pollution' Understand the terms 'hazard' and 'risk' related to the environment Better appreciate environmental issues generally, and specifically in respect of their organisation Identify hazards to the environment from working practices Outline the procedures/controls necessary to prevent damage to the environment 1 What is the environment? - putting the environment in context Key environmental issues and how we contribute Definition of the environment 2 Working with the environment What is pollution? Sources, receptors and pathways Environmental consequences workshop - identifying the environmental consequences of our working practices Environmental risk assessment Effective control mechanisms 3 Protecting the environment - Environmental Management Systems What is an Environmental Management System (EMS)? What are the benefits of having an EMS? EMS structure and models Identifying what elements of EMS your company has and how they work Roles and responsibilities 4 Choice of module Option 1: Organisation-specific moduleThis module can be used to introduce environmental concepts that are specific to your activities and operations, and will be compiled through discussion with your organisation Option 2: Environmental best practiceIf no organisation-specific module is required, or if participants from a number of organisations attend, generic operational environmental best practices can be covered instead. Areas covered include waste management, fuel storage and use, hazardous materials, emissions to air and water and environmental incidents
Duration 1 Days 6 CPD hours This course is intended for Employees not working in a centralized office. Overview The Telework and Telecommuting workshop will cover strategies to help participants learn skills required for working outside the office that include proper self-management, manage time efficiently, know different methods of organization and planning, identify various forms of communication and address and resolve challenges that teleworkers can face. The Telework and Telecommuting workshop will cover strategies to help participants learn skills required for working outside the office that include proper self-management, manage time efficiently, know different methods of organization and planning, identify various forms of communication and address and resolve challenges that teleworkers can face. Getting Started Workshop Objectives Pre-Assignment Core Skills Required Self-Management Time Management Organizing and Planning Communication Self-Management (I) Solving Problems on Your Own Being and Staying Motivated You Have More Freedom ? Don?t Abuse It You and Only You are Accountable Self-Management (II) Recognize and Remove Bad Habits Reflect on Mistakes and Learn from Them Establish Good Habits Be Assertive with Yourself Time Management (I) Build a Little Flexibility into Your Schedule Identify and Remove Time Wasters Working with Time Zones Using Free Time Wisely Time Management (II) The Urgent/Important Matrix Setting and Sticking to Deadlines The Glass Jar: Rocks, Pebbles, Sand and Water Recognize When You Are Procrastinating Organizing and Planning (I) Plan for Additional Stress When to Seek Help Being Proactive ? Not Reactive Establish Priorities and Attainable Goals Organizing and Planning (II) Setting Up Your Home Office Remove Unneeded or Distracting Items When Technology Fails Develop a Normal Working Day Communication (I) Stay in the Loop Use the Correct Medium Be Clear and to the Point Virtual Communication Can Be Impersonal Communication (II) Open and Frequent Communication Share Your Information Have a Collaborative Attitude Setting Expectations with Family and Friends Additional Challenges Building Trust and Rapport Feeling Isolated Always in the Office Lack of or Less Feedback Wrapping Up Words from the Wise
Duration 2 Days 12 CPD hours This course is intended for Executives, Project Managers, Business Analysts, Business and IT stakeholders engaged in improving the delivery of products and services that meet user needs through the use of Microsoft SharePoint; Anyone who wants to improve their Business Analysis skills; Project stakeholders concerned with SharePoint requirements. Overview Plan, manage and close requirements for a project in reduced time using good business analysis practices Minimize project uncertainty and risk by applying good techniques Ensure your project delivers required functionality and adds value to the business Create an environment of self-management for your team that will be able to continuously align the delivered product or services with desired business needs, easily adapting to changing requirements throughout the process. Requirements can change frequently during a SharePoint project, and therefore projects need a streamlined, flexible approach to requirements change management. SharePoint professionals want to develop systems and services which are both high-quality and high-value, and the easiest way to achieve this is to implement the highest priority requirements first. This enables the projects to maximize value for their stakeholders. Introduction ? Roles involved in a SharePoint project The opportunities and challenges of a SharePoint project The business analysis process BA role vs. project manager role BA / PM competencies Case Study Exercise Understanding SharePoint Requirements Business, User, Functional, Quality-of-service and implementation requirements Requirements vs. specifications Requirements vs. business rules Risk management and risk response strategies Analyzing requirements Characteristics of effective requirements Case Study Exercise SharePoint Requirements Modeling Identify high level scope Identify initial requirements stack Identify an architectural vision Plan your iteration Iteration modeling Model storming Test driven development Case Study Exercise The Change Management Process Managing the Solution Scope and Requirements Capturing the Requirements Traceability Maintaining the Requirements for re-use Managing Requirements Conflicts Preparing the Requirements Package Building the Requirements communications plan Case Study Exercise Assessing & Validating Requirements Validating and verifying SharePoint Requirements Creating a master test plan Create test scenarios and test cases Case Study Exercise Additional Information Useful books and links on managing requirements and projects for SharePoint initiatives
Duration 2 Days 12 CPD hours This course is intended for Este curso est dise¤ado para cualquier persona que quiere convertirse en unSCRUM Master. Overview El curso de formaci¢n asegura que el candidato obtendr los conocimientosnecesarios de la metodolog¡a SCRUM con el fin de aplicar y adaptarlos a unescenario espec¡fico. SCRUM es una metodolog¡a adaptativa, iterativa, r pida, flexible y efectiva dise¤ada para entregar valor significativo de una manera r pida a lo largo de todo el proyecto. Informaci¢n general µgil y SCRUM Informaci¢n general: µgil Manifiesto µgil Principios de µgil Metodolog¡a µgil Informaci¢n general SCRUM Ventajas SCRUM Roles de SCRUM Roles centrales Roles no-centrales Propietario de producto Master SCRUM Equipo SCRUM Fases de proyecto SCRUM Iniciar Planificar y Estimaci¢n Implementar Revisi¢n y Retrospecci¢n Lanzamiento Entradas, Herramientas, y Salidas para cada proceso en cada fase Escala de Scrum Escalabilidad de Scrum Scrum en Programas y Portfolios (Carteras) Reuni¢n Scrum de Scrums (SoS) Transici¢n a Scrum Mapeo de los Roles tradicionales a Scrum Manteniendo el envolvimiento de las partes interesadas (stakeholders) Importancia de Apoyo Ejecutivo Additional course details: Nexus Humans SCRUM Master Certified training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the SCRUM Master Certified course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.
Duration 3 Days 18 CPD hours This course is intended for The primary audience for this class are Application Consultants, Business Process Architects, Business Process Owners/Team Leads/Power Users, and Program/Project Managers Overview Explore settings to map requirements in the area of Sales and Distribution (S&D) that require knowledge of cross-application Customizing functionsUnderstand and consider complex relationships in mapping organizational structuresConfigure and adapt special functions like copy control, text control, output controlUnderstand system modification options and personalization techniques This course is ideal for students who are requiring detailed cross-application configuration knowledge to map requirements integrated to sales and distribution. Copy Control Modifying Copy Control Text Control Identifying Text Sources Configuring Text Control Output Adjusting Output Determination Adjusting Output Types Using PDF-Based Forms in the Sales Process Enhancements & Modifications Using Enhancement Technology Adjusting the Screen Setup of a Transaction Using Table Controls Adjusting Lists in Sales and Distribution Controlling Customer Master Data Using Account Groups Adjusting the Screen Setup of a Transaction Using Transaction Variants Adding New Fields Performing System Modifications Using Classic Enhancement Technology Performing System Modifications Using the Enhancement Framework Additional course details: Nexus Humans SCM650 SAP Cross-Functional Customizing in Sales and Distribution training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the SCM650 SAP Cross-Functional Customizing in Sales and Distribution course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.
Duration 5 Days 30 CPD hours This course is intended for This course is designed for business analysts. Overview After completing this course, you should be able to:Describe the benefits of implementing an Operational Decision Manager solution, and the collaboration that is required between the business and development teamsIdentify the main user roles that are involved in designing and developing an Operational Decision Manager solution, and the tasks that are associated with each roleExplain modeling concepts and the UML notation that is relevant to modeling for business rules and eventsDefine and implement object models for business rulesSet up the rule authoring environment in Designer by working with decision services and synchronizing across development and business environmentsCustomize the vocabulary that is used in rulesDiscover and analyze business rules for implementationUse the Operational Decision Manager rule editors to author business rules and decision tablesRun tests and simulations in the Decision Center Enterprise console to validate decision logic and rule changesExplain governance issues and work with Operational Decision Manager features that support decision governance This course introduces business analysts to IBM Operational Decision Manager V8.7.1. You learn the concepts and skills that are necessary to capture, author, validate, and manage business rules with Operational Decision Manager. Course Outline Course introduction Introducing IBM Operational Decision Manager V8.7.1 Exercise: Operational Decision Manager in action Modeling for business rules Exercise: Building the model on paper Exercise: Implementing the model Understanding decision services Exercise: Setting up a decision service Working with the BOM Exercise: Working with the BOM Introducing Decision Center Exercise: Exploring the Decision Center Business console Exercise: Exploring the Decision Center Enterprise console Introducing rule authoring Exercise: Understanding the case study Discovering and analyzing rules Exercise: Discovering rules Exercise: Analyzing rules Working with conditions in rules Exercise: Working with conditions in rules Working with definitions in rules Exercise: Working with definitions in rules Writing complete rules Exercise: Writing complete rules Authoring decision tables and trees Exercise: Authoring decision tables and trees Exercise: Authoring rules: Putting it all together Running tests and simulations in the Enterprise console Exercise: Running tests and simulations in the Enterprise console Introducing decision governance Exercise: Working with the decision governance framework Course summary
Duration 1 Days 6 CPD hours This course is intended for This course is for employees of Sun Life who want to learn how to use HUE when working with SQL databases. Overview Upon successful completion of this course, students will be able to operate HUE when interacting with SQL databases. In this course, students will learn how to operate HUE when interacting with SQL databases. Executing a Simple Query Connect to the SQL Database Query a Database Save a Query Modify and Execute a Saved Query Performing a Conditional Search Search Using One or More Conditions Search for a Range of Values and NULL Values Search Data Based on Patterns Working with Functions Perform Date Calculations Calculate Data Using Aggregate Functions Manipulate String Values Organizing Data Sort Data Rank Data Group Data Filter Grouped Data Summarize Grouped Data Use PIVOT and UNPIVOT Operators Retrieving Data from Multiple Tables Combine the Results of Two Queries Compare the Results of Two Queries Retrieve Data by Joining Tables Exporting Query Results Generate a Text File Generate an XML File Additional course details: Nexus Humans SQL Querying Fundamentals with HUE - Part 1 training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the SQL Querying Fundamentals with HUE - Part 1 course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.
Duration 4 Days 24 CPD hours This course is intended for Application Consultants and Technical Consultants Overview Understand and have a clear overview of SAP MIIUnderstand SAP MII data, service enablement, messaging, visualization, and business logic servicesUse SAP MII tool to integrate various data from different data sources (Synchronous and Asynchronous)Use SAP MII to connect manufacturing shop floor system and SAP ERP system in addition to XML functions and document buildingUse SAP MII new features: Self-Service Composition Environment, Manufacturing Data Objects, Plant Information Catalog, KPI and Alert Frameworks This is a fundamental course students should take in order to gain an understanding of the SAP MII product, which is the foundational product of SAP Connected Manufacturing. Course Outline Introduction to SAP MII SAP MII Administration and linkages to NetWeaver Administration Data Server and Enterprise Configuration Navigation and Home Page Themes Developing with SAP MII Workbench & Self-Service Composition Environment (SSCE) Query & HTML5 Display Templates Time Engine MII HTML5 JavaScript functions MII Reporting and Localization Business Logic Services (Basics) Plant Information Catalog and SAP Plant Connectivity KPI and Manufacturing Data Objects (MDO) Alerting Framework Additional course details: Nexus Humans SCM380 SAP MII - Manufacturing Integration and Intelligence Fundamentals training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the SCM380 SAP MII - Manufacturing Integration and Intelligence Fundamentals course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.