This Access Course concentrates on using creative queries, to extract data from large data sets to get insight from your data and report it. Learn and explore various query techniques from where clauses, to aggregation, joins and more. This private style tuition helps to maximise the value you get from the day.
Duration 1 Days 6 CPD hours This course is intended for This course is intended for: Data platform engineers Architects and operators who build and manage data analytics pipelines Overview In this course, you will learn to: Compare the features and benefits of data warehouses, data lakes, and modern data architectures Design and implement a batch data analytics solution Identify and apply appropriate techniques, including compression, to optimize data storage Select and deploy appropriate options to ingest, transform, and store data Choose the appropriate instance and node types, clusters, auto scaling, and network topology for a particular business use case Understand how data storage and processing affect the analysis and visualization mechanisms needed to gain actionable business insights Secure data at rest and in transit Monitor analytics workloads to identify and remediate problems Apply cost management best practices In this course, you will learn to build batch data analytics solutions using Amazon EMR, an enterprise-grade Apache Spark and Apache Hadoop managed service. You will learn how Amazon EMR integrates with open-source projects such as Apache Hive, Hue, and HBase, and with AWS services such as AWS Glue and AWS Lake Formation. The course addresses data collection, ingestion, cataloging, storage, and processing components in the context of Spark and Hadoop. You will learn to use EMR Notebooks to support both analytics and machine learning workloads. You will also learn to apply security, performance, and cost management best practices to the operation of Amazon EMR. Module A: Overview of Data Analytics and the Data Pipeline Data analytics use cases Using the data pipeline for analytics Module 1: Introduction to Amazon EMR Using Amazon EMR in analytics solutions Amazon EMR cluster architecture Interactive Demo 1: Launching an Amazon EMR cluster Cost management strategies Module 2: Data Analytics Pipeline Using Amazon EMR: Ingestion and Storage Storage optimization with Amazon EMR Data ingestion techniques Module 3: High-Performance Batch Data Analytics Using Apache Spark on Amazon EMR Apache Spark on Amazon EMR use cases Why Apache Spark on Amazon EMR Spark concepts Interactive Demo 2: Connect to an EMR cluster and perform Scala commands using the Spark shell Transformation, processing, and analytics Using notebooks with Amazon EMR Practice Lab 1: Low-latency data analytics using Apache Spark on Amazon EMR Module 4: Processing and Analyzing Batch Data with Amazon EMR and Apache Hive Using Amazon EMR with Hive to process batch data Transformation, processing, and analytics Practice Lab 2: Batch data processing using Amazon EMR with Hive Introduction to Apache HBase on Amazon EMR Module 5: Serverless Data Processing Serverless data processing, transformation, and analytics Using AWS Glue with Amazon EMR workloads Practice Lab 3: Orchestrate data processing in Spark using AWS Step Functions Module 6: Security and Monitoring of Amazon EMR Clusters Securing EMR clusters Interactive Demo 3: Client-side encryption with EMRFS Monitoring and troubleshooting Amazon EMR clusters Demo: Reviewing Apache Spark cluster history Module 7: Designing Batch Data Analytics Solutions Batch data analytics use cases Activity: Designing a batch data analytics workflow Module B: Developing Modern Data Architectures on AWS Modern data architectures
Duration 5 Days 30 CPD hours This course is intended for Consultants, Support, System Administrators Overview Upon completion of the course, students will be able to: Run a business process. Create a business process using the Graphical Process Modeler. Explain how to create a service configuration. Explain how to track an executable business process. Discuss the basics of Sterling B2B Integrator. This course teaches students techniques, tools, and recommended practices that can be used to run a business process, create a business process using the Graphical Process Modeler, explain how to create a service configuration, explain how to track an executable business process, and discuss the basics of Sterling B2B Integrator through a combination of lecture and hands-on labs. About IBM Sterling B2B Integrator High level overview of the Admin Console with an exercise to start the application XML and XPath Basics Review the basics of XML and XPath which is heavily used in the application Basic Business Process Concepts Reviewing what XML and XPath components are used to build business processes Reviewing how to manually execute a business process within the application Tracking and Troubleshooting Business Processes Exercises to demonstrate how to work with business process instances Graphical Process Modeler (GPM) Overview of the Graphical Process Modeler Exercises to walk through the development of a business process in the GPM Exercises for checking in, executing, and modifying business processes Introduction to Service Management Several exercises showcasing specific services/adapters and other functionality Best Practices Covers specific business process development methods that are best practice Mapping Introduction to the Map Editor and Standards Exercises to build and use an XML Encoder Map Typing Map Exercises to build and use a Typing Map Case Study Exercise to build an end-to-end solution using what was learned in previous exercises Tracking System Health Review of archiving, migrating, and deleting business processes Additional course details: Nexus Humans IBM Sterling B2B Integrator 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 IBM Sterling B2B Integrator 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.
Duration 5 Days 30 CPD hours This course is intended for The primary audience for this course are Application Consultants, Data Consultants/Managers, Developers, Program/Project Managers, and System Administrators. Overview This course is designed to give you the comprehensive skills needed to work with the Information Design Tool. The Information Design Tool enables designers to extract, define, and manipulate metadata from relational and OLAP sources to create and deploy SAP BusinessObjects universes.In this course you learn how to use data from different source systems (SAP and non-SAP) with the SAP BusinessObjects BI client tools. This five-day course is designed to give you the comprehensive skills and in-depth knowledge needed to create SAP BusinessObjects universes using the SAP BusinessObjects Information Design Tool. Basic SAP BusinessObjects Universe Design Describing Universes Defining the Components of a Universe Data Connections Defining connections Data Foundations Creating Data Foundations Using Joins Business Layers Accessing Data through the Business Layer Integrating the Business Layer Components Validating Objects Creating Measure Objects Creating Shortcut Joins Loops in a Data Foundation Resolving Loops with Joined Tables Resolving Loops Using Aliases Resolving Loops Using Contexts Detecting Contexts Editing Contexts Testing Contexts Resolving Recursive Loops Data Restrictions Defining Data Restrictions Applying Mandatory Data Restrictions Applying Optional Data Restrictions Lists of Values (LOV) Providing a List of Values Parameters Illustrating Runtime Parameters Object @functions Using Object @functions in Queries Applying the Aggregate Awareness Optimization Method Using Other @ Functions Navigation Paths Defining Drill Down Navigation Paths Derived Tables Creating Derived Tables Key Awareness Defining Numeric Keys Universe Management with Data Foundation and Business Layer Views Managing a Universe using the Data Foundation View Managing a Universe using the Business Layer View Universe Optimization Optimizing Universes Using Parameters Universe Deployment and Security Deploying a Universe Securing a Published Universe Creating Data Security Profiles Creating Business Security Profiles Assigning Security Profiles to Users Identifying the Priority of Security Settings Updating a Published Universe SQL Clause Processing Problems Determining How the Order of SQL Clauses Affects Data Returned Detecting Ambiguity Caused by SQL Requests Run Against Joined Tables Resolving Ambiguity Caused by SQL Requests Run Against Joined Tables Identifying Fan Traps Resolving Ambiguity Caused by SQL Requests Run Against Joined Tables Outer Join Problem Resolution Resolving an Ambiguous Outer Join Using @AggregateAware Universe Creation from Different Data Sources Identifying the Different Data Sources Creating an OLAP Universe Creating a Multi-source Universe Shared Projects Using Shared Projects Manipulating Other Designers' Resources Universe Conversion Converting Existing .unv Universes Translation Deploying Universes in Different Languages
Duration 2 Days 12 CPD hours This course is intended for Application Developers Business Analysts Developer End Users Functional Implementer Java Developer System Analysts Technical Administrator Overview Create administrator-level personalizations Personalize configurable pages Utilize advanced personalization features Implement flexfields on OA Framework-based pages Create custom look and feel definitions Create user-level personalizations This course will be applicable for customers who have implemented Oracle E-Business Suite Release 12 or Oracle E-Business Suite 12.1. This course will be applicable for customers who have implemented Oracle E-Business Suite Release 12 or Oracle E-Business Suite 12.1.
Duration 5 Days 30 CPD hours This course is intended for This course is intended for Database Administrators, Database Developers, BI professionals, and Business reporting users. Overview Upon successful completion of this course, students will be able to run Queries and retrieve results, perform conditional searches, and retrieve data from multiple tables. Before starting this course, make sure you meet at least one of the following prerequisites: Basic knowledge of the Microsoft Windows operating system and its core functionality. Basic working knowledge of Relational Databases. In this course, students will gain a good understanding of the Transact-SQL language. They will be able to create queries, sort, filter the data, execute procedures with T-SQL. Course Outline 1.Introduction to Microsoft SQL Server 2.Introduction to T-SQL Querying 3.Writing SELECT Queries 4.Querying Multiple Tables 5.Sorting and Filtering Data 6.Working with SQL Server Data Types 7.Using DML to Modify Data 8.Using Built-In Functions 9.Grouping and Aggregating Data 10.Using Subqueries 11.Using Table Expressions 12.Using Set Operators 13.Using Windows Ranking, Offset, and Aggregate Functions 14.Pivoting and Grouping Sets 15.Executing Stored Procedures 16.Programming with T-SQL
Duration 1 Days 6 CPD hours This course is intended for This basic course is for users and developers familiar with earlier versions of IBM InfoSphere Information Server or IBM InfoSphere MDM who want to learn about new features in V11.3 Overview The objectives of this course are as follows:- Learn about the new features of DataStage V11.3- Learn about the new features of Information Analyzer V11.3- Learn about the new features of Data Click V11.3- Learn about the new features of the Information Governance Catalog V11.3 This course is designed to introduce you to new features in data integration and governance in IBM InfoSphere Information Server V11.3 and IBM InfoSphere MDM V11.3. Outline Unit DS: New Features in IBM InfoSphere DataStage V11.3 Unit DC: New Features in IBM InfoSphere Data Click V11.3 Unit IA: New Features in IBM InfoSphere Information Analyzer V11.3 **All units are accompanied by hands-on lab exercises. Additional course details: Nexus Humans KM650 IBM What is New in IBM InfoSphere Data Integration and Governance? V11.3 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 KM650 IBM What is New in IBM InfoSphere Data Integration and Governance? V11.3 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.
The Emotional Logic workshop is designed to provide enlightening mindset shifts and educational activities around emotions, their purpose, and our values.
Duration 5 Days 30 CPD hours This course is intended for This course is designed for application developers. Overview Describe the benefits of implementing a decision management solution with Operational Decision Manager.Identify the key user roles that are involved in designing and developing a decision management solution, and the tasks that are associated with each role.Describe the development process of building a business rule application and the collaboration between business and development teams.Set up and customize the Business Object Model (BOM) and vocabulary for rule authoring. Implement the Execution Object Model (XOM) that enables rule execution.Orchestrate rule execution through ruleflows. Author rule artifacts to implement business policies.Debug business rule applications to ensure that the implemented business logic is error-free.Set up and customize testing and simulation for business users.Package and deploy decision services to test and production environments.Integrate decision services for managed execution within an enterprise environment.Monitor and audit execution of decision services.Work with Operational Decision Manager features that support decision governance. This course introduces developers to IBM Operational Decision Manager V8.9.2. It teaches participants the concepts and skills required to design, develop, and integrate a business rule solution with Operational Decision Manager. This course begins with an overview of Operational Decision Manager, which is composed of two main environments: Decision Server for technical users and Decision Center for business users. The course outlines the collaboration between development and business teams during project development. Through instructor-led presentations and hands-on lab exercises, participants learn about the core features of Decision Server, which is the primary working environment for developers. Participants design decision services and work with the object models that are required to author and execute rule artifacts. Participants gain experience with deployment and execution, and work extensively with Rule Execution Server. In addition, students become familiar with rule authoring so that you can support business users to set up and customize the rule authoring and validation environments. Participants also learn how to use Operational Decision Manager features to support decision governance. Introducing IBM Operational Decision Manager Exercise: Operational Decision Manager in action Developing decision services Exercise: Setting up decision services Programming with business rules and developing object models Exercise: Working with the BOM Exercise: Refactoring Orchestrating ruleset execution Exercise: Working with ruleflows Authoring rules Exercise: Exploring action rules Exercise: Authoring action rules Exercise: Authoring decision tables Customizing rule vocabulary with categories and domains Exercise: Working with static domains Exercise: Working with dynamic domains Working with queries Exercise: Working with queries Debugging rules Exercise: Executing rules locally Exercise: Debugging a ruleset Enabling tests and simulations Exercise: Enabling rule validation Managing deployment Exercise: Managing deployment Exercise: Using Build Command to build RuleApps Executing rules with Rule Execution Server Exercise: Exploring the Rule Execution Server console Auditing and monitoring ruleset execution Exercise: Auditing ruleset execution through Decision Warehouse Working with the REST API Exercise: Executing rules as a hosted transparent decision service (HTDS) Additional course details: Nexus Humans WB402 IBM Developing Rule Solutions in IBM Operational Decision Manager V8.9.2 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 WB402 IBM Developing Rule Solutions in IBM Operational Decision Manager V8.9.2 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.
Get ready for an exceptional online learning experience with the Big Data Analysis, Data Science, Fintech & Python for Data Analyst bundle! This carefully curated collection of 20 premium courses is designed to cater to a variety of interests and disciplines. Dive into a sea of knowledge and skills, tailoring your learning journey to suit your unique aspirations. The Big Data Analysis, Data Science, Fintech & Python for Data Analyst is a dynamic package, that blends the expertise of industry professionals with the flexibility of digital learning. It offers the perfect balance of foundational understanding and advanced insights. Whether you're looking to break into a new field or deepen your existing knowledge, the Data Analysis package has something for everyone. As part of the Big Data Analysis, Data Science, Fintech & Python for Data Analyst package, you will receive complimentary PDF certificates for all courses in this bundle at no extra cost. Equip yourself with the Data Analysis bundle to confidently navigate your career path or personal development journey. Enrol today and start your career growth! This bundle comprises the following courses: CPD Quality Standards Courses: Big Data Analytics with PySpark Power BI and MongoDB Big Data Analytics with PySpark Tableau Desktop and MongoDB Building Big Data Pipelines with PySpark MongoDB and Bokeh Develop Big Data Pipelines with R & Sparklyr & Tableau Develop Big Data Pipelines with R, Sparklyr & Power BI Learn Python, JavaScript, and Microsoft SQL for Data Science SQL for Data Science, Data Analytics, and Data Visualization Excel Data Analysis Introduction to Data Analytics with Tableau Business and Data Analytics for Beginners Google Data Studio: Data Analytics Basic Data Analysis FinTech Learning Outcome: Gain comprehensive insights into multiple fields. Foster critical thinking and problem-solving skills across various disciplines. Understand industry trends and best practices through the Data Analysis Bundle. Develop practical skills applicable to real-world situations. Enhance personal and professional growth with Data Analysis. Build a strong knowledge base in your chosen course via Data Analysis. Benefit from the flexibility and convenience of online learning. With the Data Analysis package, validate your learning with a CPD certificate. Each course in this bundle holds a prestigious CPD accreditation, symbolising exceptional quality. The materials, brimming with knowledge, are regularly updated, ensuring their relevance. This bundle promises not just education but an evolving learning experience. Engage with this extraordinary collection, and prepare to enrich your personal and professional development. Embrace the future of learning with the Big Data Analysis, Data Science, Fintech & Python for Data Analyst, a rich anthology of 15 diverse courses. Each course in the Data Analysis bundle is handpicked by our experts to ensure a wide spectrum of learning opportunities. ThisBig Data Analysis, Data Science, Fintech & Python for Data Analyst bundle will take you on a unique and enriching educational journey. The bundle encapsulates our mission to provide quality, accessible education for all. Whether you are just starting your career, looking to switch industries, or hoping to enhance your professional skill set, the Big Data Analysis, Data Science, Fintech & Python for Data Analyst bundle offers you the flexibility and convenience to learn at your own pace. Make the Data Analysis package your trusted companion in your lifelong learning journey. CPD 35 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Big Data Analysis, Data Science, Fintech & Python for Data Analyst bundle is perfect for: Lifelong learners looking to expand their knowledge and skills. Professionals seeking to enhance their career with CPD certification. Individuals wanting to explore new fields and disciplines. Anyone who values flexible, self-paced learning from the comfort of home. Career path Unleash your potential with the Big Data Analysis, Data Science, Fintech & Python for Data Analyst bundle. Acquire versatile skills across multiple fields, foster problem-solving abilities, and stay ahead of industry trends. Ideal for those seeking career advancement, a new professional path, or personal growth. Embrace the journey with the Data Analysis bundle package. Certificates Certificate Of Completion Digital certificate - Included Certificate Of Completion Hard copy certificate - Included You will get a complimentary Hard Copy Certificate.