135 Business Analysis courses delivered Live Online

Duration 4 Days 24 CPD hours This course is intended for This class is designed for enterprise architects, solution architects, and business analysts working to earn their Salesforce Application Architect credential, or for application architects looking to get more hands-on experience. Overview Design data models that scale gracefully Leverage Salesforce sharing mechanisms at an advanced level Evaluate the nuances of field types and pick the right one for the circumstances Make data model decisions that minimize record locking and other performance degradations Dive into the two cornerstone domains of being an Application Architect: Data Architecture and Management, and Sharing and Visibility. In this 4-day workshop, our Architect experts will present you with a case study scenario that will be broken down and digested through iterative exploration. Learn how to design and build secure, scalable, and high-performing solutions through a combination of lecture, demos, hands-on exercises, and workshop presentations and discussions. APPLICATION ARCHITECT OVERVIEW * Assess the Requirements to Become an Application Architect * Understand the Real-World Expectations of Application Architects * Review the Core Characteristics of Successful Application Architects SCENARIO INTRODUCTION * Review the Application Architecture Scenario * Identify Scenario Problem Areas * Identify Scenario Actors and Licensing ARCHITECTURE DOCUMENTATION * Understand Key Architecture Documentation Requirements * Learn About Best Practices for Artifact Documentation * Produce Architecture Documents DATA MODELING * Identify Relationship Types and Their Impact on Record Access, User Interface, and Reporting * Review the Considerations for Changing Field Types * Review the Considerations for Modifying Data Models with Schema Builder * Review the Considerations for Importing and Exporting Data * Identify Use Cases of External Objects * Determine an Appropriate Data Model * Understand Design Implications with Complex Environments and Large Data Volumes (LDV) DATA MANAGEMENT * Review the Considerations for Working with LDV * Review Data Lifecycle Concepts and Mechanisms * Review Master Data Management and System of Record Concepts * Review Data Migration, Planning, Preparation, and Execution * Identify Potential LDV and Calculate Expected Volumes * Go Further with Indexes Standard and Custom Skinny Tables * Lock Records SECURITY MODEL * Review the Considerations for Working with Internal and External Sharing Models * Restrict and Extend Object and Field Access * Determine Sharing Solutions * Identify Record Sharing Mechanisms (Declarative, Programmatic, Implicit) * Understand Teams Concepts (Account, Opportunity, Case) * Understand Person Accounts and Its Implication on Sharing * Encrypt Data SHARING IN COMMUNITIES * Understand Community Security Mechanisms * Secure Integration Endpoints * Integrate and Specify Connected Apps and Named Credentials ADVANCED SECURITY & VISIBILITY CONCEPTS * Implement Security & Visibility Controls with Apex and Visualforce * Review Territory Management and Its Implication on Data Management, Sharing, and Visibility * Review Divisions and Its Implication on Data Management, Sharing, and Visibility * Understand Security and Visibility Controls on 'Special' Objects SOLUTION DESIGN * Determine When to Leverage Standard Products Functionality vs. Custom Build vs. AppExchange * Understand Declarative and Programmatic Configuration * Get to Know the Order of Execution * Automate Business Processes * Consider Reporting and Analytics Needs * Consider How to Store and Access Content/Files * Apply Solution Design Concepts to Real-World Problems and Scenarios DEPLOYMENT & INTEGRATION BEST PRACTICES * Review the Application Lifecycle * Understand How Sandboxes Should Be Used * Review Deployment Options * Identify Integration Patterns WRAP-UP * Review a Practice Scenario * Review What Was Covered ADDITIONAL COURSE DETAILS: Nexus Humans Salesforce Build Application Architect Expertise (ARC901) 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 Salesforce Build Application Architect Expertise (ARC901) 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 This course is designed for project managers, Scrum masters, business analysts, and team leaders looking to effectively manage their development projects using Team Foundation Server 2017. Overview The course also demonstrates how TFS facilitates the use of storyboards to prototype experiences, request stakeholder feedback, foster team collaboration, and generate reports. The final two modules of the course provide an overview of how testers and developers can work effectively using appropriate tools in the Visual Studio family. In this course, attendees will plan a new software development project and go through the steps to initiate the project using Visual Studio 2017. This includes recording requirements, creating a product backlog, and estimating effort for backlog items. INTRODUCING THE MICROSOFT VISUAL STUDIO 2017 FAMILY * What?s new in Visual Studio 2017 * Overview of the Visual Studio 2017 family * Overview of product features * Project workflow across the Visual Studio 2017 suite of products * INITIATING A NEW PROJECT * Organizing projects in TFS * Understanding process templates * Creating a new team project * Setting team project properties * Switching between team projects * WORK ITEM PRIMER * Overview of work items * Traceability between work items * Searching and creating custom queries * Work item charting and pinning charts * Work item tagging * Configuring project notifications * CREATING OUR PRODUCT BACKLOG * Examining requirement types * Creating backlog items * Creating requirement hierarchies using features * The importance of acceptance criteria * AGILE ESTIMATION * Introduction to estimation * Using story points * Planning Poker and other popular estimation techniques * Adding your estimates to TFS work items * WORKING FROM THE PRODUCT BACKLOG * Introducing the Kanban board * Entering and editing details on the Kanban board * Customizing columns, including using split columns and limiting WIP * Recording our Definition of Done (DoD) * Understanding the Cumulative Flow Diagram * WORKING IN SPRINTS * Specifying your sprint schedule and your team capacity * Selecting items for the sprint backlog using forecasting * Decomposing requirements into tasks * Using burndown charts to track progress * Monitoring work using the task board * Working with unparented work items * RETROSPECTIVES * The importance of retrospectives * Conducting an efficient sprint retrospective * What you should avoid in your retrospective * WORKING WITH TFS TEAMS * Configuring teams in our team project * Managing work from a master backlog * Allocating work to our teams * Configuring iterations for TFS teams * ENHANCING REQUIREMENTS USING STORYBOARDS * Overview of storyboarding capabilities * Creating a storyboard to illustrate a requirement * Linking a storyboard to a work item * GETTING STAKEHOLDER FEEDBACK * Introducing the Microsoft Feedback Client * Using the Microsoft Feedback Client to provide rich feedback to the team * Adding continuous feedback into your workflow * FOSTERING TEAM COLLABORATION * An overview of the various clients * The use of email in sharing information * Choosing the appropriate client tool * CREATING AND CUSTOMIZING REPORTS * Overview of reporting architecture * Reviewing the out of the box reports * Adding new reports * Creating ad hoc reports using Excel * OVERVIEW OF AGILE TESTING * The role of the tester in a sprint planning meeting * A lap around web-based test management * Creating a test plan * Creating manual test cases from requirements * OVERVIEW OF AGILE DEVELOPMENT * Using My Work to select tasks from the sprint backlog * Understanding the value of linking changesets to work items * The importance of unit testing * Creating a continuous integration build * ADDITIONAL COURSE DETAILS: Nexus Humans Managing Agile Projects Using TFS 2017 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 Managing Agile Projects Using TFS 2017 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 1 Days 6 CPD hours This course is intended for This overview-level course is ideally suited for professionals seeking an introduction to microservices architecture and its application within a business context. Ideal attendee roles include software developers, system architects, technical managers, and IT professionals who are part of teams transitioning to a microservices approach. It's also an excellent starting point for non-technical roles such as product owners or business analysts who work closely with technical teams and want to better understand and become conversant in the language and principles of microservices. Overview This course combines engaging instructor-led presentations and useful demonstrations with engaging group activities. Throughout the course you'll explore: Understand the Basics of Microservices: Get to know the fundamental principles and characteristics of microservices and how they revolutionize traditional software development approaches. Explore the Design of Microservices: Gain an overview of how microservices are designed based on business requirements and what makes them unique in the software architecture world. Overview of Managing and Scaling Microservices: Get an introduction to how microservices are managed and scaled independently, and understand the significance of these features in your business operations. Familiarize with the Microservices Ecosystem: Learn about the typical patterns, best practices, and common pitfalls in the microservices world, setting a foundation for future learning and implementation. Introduction to Microservices in a Business Context: Acquire a basic understanding of how microservices can be aligned with specific business capabilities, and get a glimpse into how they can coexist with legacy systems in a business setting. Microservices have rapidly emerged as a popular architectural style, breaking down applications into small, independent services that can be developed, deployed, and scaled individually. Microservices offer a robust method to address a variety of projects, such as e-commerce platforms and content management systems, enhancing scalability and boosting productivity. This technology, when employed correctly, can greatly increase software delivery speed and system resilience, making it a crucial skill set for modern technology professionals.Understanding Microservices - A Technical Overview is a one-day course ideally suited for technical professionals seeking an introduction to microservices architecture and its application within a business context. Under the guidance of an industry expert, this engaging class combines lecture-style learning with lively demonstrations, case study review and group discussions.Throughout the course you?ll explore the principles and characteristics that define microservices, how to identify suitable projects for a microservices approach, the factors to consider when designing them, and the strategies to effectively manage and scale them within complex systems. You?ll also learn about the best practices, patterns, and anti-patterns, arming you with the knowledge to make the right architectural choices. This course also explores the real-world implementation of microservices in a business enterprise. We'll discuss how to align the application of microservices with your organization's specific business capabilities, and offer strategies for smoothly integrating this technology within existing legacy systems. INTRODUCTION TO MICROSERVICES * Understand what microservices are and their role in modern software development. * Introduction to Microservices: what they are and why they matter. * Monolithic vs Microservices: highlighting the shift and benefits. * Key principles and characteristics of microservices. * Identifying suitable applications for microservices transformation. * Demo: Analyzing a sample application and identifying potential microservices ARCHITECTING AND MANAGING MICROSERVICES * Learn the basic strategies for scaling and managing microservices. * Scaling Microservices: from a single service to hundreds. * Key components of a microservices architecture. * Introduction to resilience patterns: Circuit-Breakers and Bulkheads. * Load management and provisioning in a microservices setup. * Understanding the role of cloud services in microservices. * Optional Demo: Illustrating how a microservice-based application scales in real-time DESIGNING MICROSERVICES * Learn the key aspects to consider when designing microservices. * Defining microservice boundaries: Deciding the scope of a microservice. * Communication patterns in microservices. * Understanding Microservice endpoints. * Exploring data stores and transaction boundaries in microservices. * Overcoming challenges in Microservices design. * Demo: Designing microservices for a hypothetical business requirement IMPLEMENTING MICROSERVICES IN A BUSINESS ENTERPRISE * Understand the process and considerations for implementing microservices in an enterprise context. * Assessing enterprise readiness for microservices. * Building the business case for microservices: strategic advantages and potential challenges. * Aligning microservices with business capabilities. * Organizational changes: Team structures and processes for microservices. * Dealing with Legacy Systems: Strategies for microservices integration. * Demo: Exploring a case study of successful microservices implementation in a business enterprise THE MICROSERVICES ECOSYSTEM * Understand the key tools and best practices in the Microservices ecosystem. * Understanding the typical Microservices Stack. * Monitoring and Logging in Microservices. * Introduction to Docker: Containerization of Microservices. * Deployment strategies in a Microservices setup. * Introduction to Orchestration in Microservices * Demo: Containerizing and deploying a simple microservice MICROSERVICES DEPLOYMENT STRATEGIES * Understand various ways to safely introduce changes in a microservices environment. * The concept of Blue-Green Deployment: changing services without downtime. * Canary Releases and Feature Toggles: slowly rolling out changes to users. * Database changes in a microservices environment: keeping data consistent. * Demo: Examining various deployment strategies MICROSERVICES BEST PRACTICES AND DEVOPS * Learn key strategies to ensure a smooth operation of your microservices setup. * The DevOps culture in Microservices: collaboration for efficiency. * Defining a Minimum Viable Product in a Microservices setup: building small, delivering fast. * Dealing with data in a distributed setup: managing Data Islands. * The importance of Continuous Integration/Continuous Delivery in a microservices setup. * Governance: Keeping track of your services and their consumers. * Demo: Visualizing a simple continuous delivery pipeline MICROSERVICES PATTERNS AND ANTI-PATTERNS * Learn about common do's and don'ts when working with microservices. * Understanding patterns that help with efficient microservices operation. * Recognizing and avoiding anti-patterns that can hinder performance. * Dealing with common challenges: dependencies between services, managing service boundaries. * Demo: Examples of real-world patterns and anti-patterns SIMPLE OVERVIEW OF OAUTH AND OPENID FOR MICROSERVICES * Introduction to OAuth and OpenID: What they are and why they matter in Microservices. * The role of tokens in OAuth 2.0: How they help in securing communications. * A simplified look at OpenID Connect: Linking identities across services. * Demo

Duration 3 Days 18 CPD hours This course is intended for This course is geared for anyone needing to interface with an Oracle database such as end users, business analysts, application developers and database administrators / DBAs. Overview Working within in a hands-on learning environment, guided by our expert team, attendees will develop a practical approach to Oracle Database Technology. Throughout the course participants will explore: Using PL/SQL programming language for database applications and development incorporating PL/SQL modules within the application architecture from the initial design and planning phase The essentials of building executable PL/SQL program units Each of the major segments of a working program and how these interact with each other during program execution Important error or exception handling capabilities of the language. How database-resident program units can be used as part of the overall database application architecture Applying these new skills to the development of PL/SQL packages. Advanced database programming capabilities and benefits How database triggers can be used as part of an advanced database application design Oracle 19c PL/SQL Fundamentals is a three-day, hands-on course that introduces Oracle database programming using the PL/SQL programming language. Throughout the course students will explore the core syntax, structure and features of the language. This course will also lay the foundation for the entire Oracle PL/SQL programming series, allowing one to progress from introductory topics to advanced application design and programming and finally onto writing complex high-performance applications. The course also explores applying the newly learned skills to the development of database applications. Participants will learn how to use database-resident stored program units such as procedures, functions, packages and database triggers. Students will also learn about the latest features in Oracle 19c. SELECTION & SETUP OF THE DATABASE INTERFACE * Considering Available Tools * Selecting the Appropriate Tool * Oracle Net Database Connections * Oracle PAAS Database Connections * Setup SQL Developer * Setup SQL *Plus * Setup JDeveloper * About BIND and Substitution Variables * Using SQL Developer * Using SQL *Plus CHOOSING A DATABASE PROGRAMMING LANGUAGE * What is Database Programming * PL/SQL Programming * PL/SQL Performance Advantages * Integration with Other Languages PL/SQL LANGUAGE ESSENTIALS * PL/SQL Program Structure * Language Syntax Rules * Embedding SQL * Writing Readable Code * Generating Readable Code * Generating Database Output * SQL * Plus Input of Program Block DECLARE SECTION * About the Declare Section * Declare Primitive Types * Declaration Options * Not Null * Constant * Data Dictionary Integration * % Type * Declare Simple User-Defined Types * Type ? Table * Type ? Record * Extended User Defined Types BEGIN SECTION * About the Begin Section * Manipulating Program Data * Logic Control & Braching * GOTO * LOOP * IF-THEN-ELSE * CASE EXCEPTION SECTION * About the Exception Section * Isolating the Specific Exception * Pragma Exception_INIT * SQLCODE &SQLERRM Example * SQL%ROWCOUNT & Select ? Into BEYOND THE BASICS : EXPLICIT CURSORS * About Explicit Cursors * Extend Cursor Techniques * For Update of Clause * Where Current of Clause * Using for ? Loop Cursors INTRODUCTION DATABASE RESIDENT PROGRAMMING UNITS * About Database ? Resident Programs * Physical Storage & Execution * Types of Stored Program Units * Stored Program Unit Advantages * Modular Design Principles CREATING STORED PROCEDURES AND FUNCTIONS * Stored Procedures & Functions * Create Procedure / Create Function * Creating Procedures & Functions * Raise_Salary() Procedure * Salary_Valid() function * The Parameter Specification * Default Clause * System & Object Privileges * Using the Development Tools EXECUTING STORED PROCEDURES AND FUNCTIONS * Calling Procedures & Functions * Unit Testing with Execute * Anonymous Block Unit Testing * Specifying a Parameter Notation * SQL Worksheet Unit Testing * Calling Functions from SQL MAINTAINING STORED PROGRAMMING UNITS * Recompiling Programs * Mass Recompilation Using UTL_RECOMP() * Dropping Procedures & Functions * Drop Procedures & Functions * Drop Procedure / Function * Data Dictionary Metadata * Using USER_OBJECTS * Using USER_SOURCE * Using USER_ERRORS * Using USER_OBJECT_SIZE * Using USER_DEPENDENCIES MANAGING DEPENDENCIES * Dependency Internals * Tracking Dependencies * The Dependency Tracking Utility * SQL Developer Dependency Info * Dependency Strategy Checklists CREATING & MAINTAINING * About Packages * Creating Packages * Maintaining Packages * Performance Considerations ADVANCED PACKAGE CAPABILITIES * Definer & Invoker Rights * White Lists & Accessible By * Persistent Global Objects * Defining Initilization Logic * Object Orientation Support ADVANCED CURSOR TECHNIQUES * Using Cursor Variables * Using SYS_REFCURSOR * Using Cursor Expressions USING SYSTEM SUPPLIED PACKAGES * DBMS_OUTPUT() * UTL_FILE() * FOPEN() Example DATABASE TRIGGER CONCEPTS * About Database Triggers * DML Event Trigger Sub-Types * Database Trigger Scenario * Trigger Exhaustion Mechanisms * Trigger within SQL Worksheet CREATING DATABASE TRIGGERS * Statement Level Triggers * Using Raise Application_Error() * Row-Level Triggers * Examples of Triggers * Employee_Salary_Check Example * Employee_Journal Example * Budget_Event Example * Instead of Triggers * Triggers within and Application MAINTAINING DATABASE TRIGGERS * Call Syntax * Trigger Maintenance Tasks * Show Errors Trigger * Drop Trigger * Alter Trigger * Multiple Triggers for a Table * Handling Mutating Table Issues IMPLEMENTING SYSTEM EVENT TRIGGERS * What are System Event Triggers * Defining the Scope * Available System Events * System Event Attributes

Duration 3 Days 18 CPD hours This course is intended for This is an introductory level SQL course, appropriate for anyone needing to interface with an Oracle database or those needing a general understanding of Oracle database functionality. That would include end users, business analysts, application developers and database administrators. Overview Working in a hands on learning environment led by our expert practitioner, attendees will explore: Basic RDBMS Principles The SQL Language and Tools Using SQL Developer SQL Query Basics WHERE and ORDER BY Functions ANSI 92 Joins ANSI 99 Joins Subqueries Regular Expressions Analytics A company?s success hinges on responsible, accurate database management. Organizations rely on highly available data to complete all sorts of tasks, from creating marketing reports and invoicing customers to setting financial goals. Data professionals like analysts, developers and architects are tasked with creating, optimizing, managing and analyzing data from databases ? with little room for error. When databases aren?t built or maintained correctly, it?s easy to mishandle or lose valuable data. Our SQL Programming and Database Training Series provides students with the skills they require to develop, analyze and maintain data and in correctly structured, modern and secure databases. A full presentation of the basics of relational databases and their use are also covered. BASIC RDBMS PRINCIPLES * Relational design principles * Accessing data through a structured query language * Entity relationship diagrams * Data Domains * Null values * Indexes * Views * Denormalization * Data Model Review THE SQL LANGUAGE AND TOOLS * Using SQL*Plus * Why Use SQL*Plus When * Other Tools Are Available? * Starting SQL*Plus * EZConnect * SQL Commands * PL/SQL Commands * SQL*Plus Commands * The COLUMN Command * The HEADING Clause * The FORMAT Clause * The NOPRINT Clause * The NULL Clause * The CLEAR Clause * Predefined define variables * LOGIN.SQL * Command history * Copy and paste in SQL*Plus * Entering SQL commands * Entering PL/SQL commands * Entering SQL*Plus commands * Default output from SQL*Plus * Entering Queries * What about PL/SQL? USING SQL DEVELOPER * Choosing a SQL Developer version * Configuring connections * Creating A Basic Connection * Creating A TNS Connection * Connecting * Configuring preferences * Using SQL Developer * The Columns Tab * The Data Tab * The Constraints Tab * The Grants Tab * The Statistics Tab * Other Tabs * Queries In SQL Developer * Query Builder * Accessing Objects Owned By Other Users * The Actions Pulldown Menu * Differences between SQL Developer and SQL*Plus * Reporting Commands Missing In SQL Developer * General Commands Missing In SQL Developer * Data Dictionary report * User Defined reports * Using scripts in SQL Developer WHERE AND ORDER BY * WHERE clause basics * Comparison operators * Literals and Constants in SQL * Simple pattern matching * Logical operations * The DUAL table * Arithmetic operations * Expressions in SQL * Character operators * Pseudo columns * Order by clause basics * Ordering Nulls * Accent and case sensitive sorts * Sampling data * WHERE and ORDER BY in SQL Developer * All, Any, Some FUNCTIONS * The basics of Oracle functions * Number functions * Character functions * Date functions * Conversion functions * Other functions * Large object functions * Error functions * The RR format mode; * Leveraging your knowledge ANSI 92 JOINS * Basics of ANSI 92 Joins * Using Query Builder with multiple tables * Table Aliases * Outer joins * Outer Joins In Query Builder * Set operators * Self-referential joins * Non-Equijoins ANSI 99 JOINS * Changes with ANSI99 * CROSS Join * NATURAL Join * JOIN USING * JOIN ON * LEFT / RIGHT OUTER JOIN * FULL OUTER JOIN SUBQUERIES * Why use subqueries? * WHERE clause subqueries * FROM clause subqueries * HAVING clause subqueries * CORRELATED subqueries * SCALAR subqueries * DML and subqueries * EXISTS subqueries * Hierarchical queries * TOP N AND BOTTOM N queries * Creating subqueries using Query Builder REGULAR EXPRESSIONS * Available Regular Expressions * Regular Expression Operators * Character Classes * Pattern matching options * REGEX_LIKE * REGEXP_SUBSTR * REGEXP_INSTR * REGEXP_REPLACE * REGEXP_COUNT ANALYTICS * The WITH clause Reporting aggregate functions Analytical functions User-Defined bucket histograms The MODEL clause PIVOT and UNPIVOT Temporal validity MORE ANALYTICS * RANKING functions * RANK * DENSE_RANK * CUME_DIST * PERCENT_RANK * ROW_NUMBER * Windowing aggregate functions * RATIO_TO_REPORT * LAG / LEAD * Linear Regression functions * Inverse Percentile functions * Hypothetical ranking functions * Pattern Matching ADDITIONAL COURSE DETAILS: Nexus Humans Introduction to SQL Programming Basics (TTSQL002) 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 Introduction to SQL Programming Basics (TTSQL002) 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.