2079 Other courses in Whetstone delivered Live Online

Learn how to work with and connect multiple data sets to effectively analyse and report on data. Course overview Duration: 1 day (6.5 hours) Within Excel you have some powerful features to enable you to connect and analyse multiple data sources. Power Query enables you to import and manipulate your data, Power Pivot enables you to connect multiple data sources and create pivot tables and pivot charts from them. This course is an introduction to Power Query and Power Pivot in Excel to get you started on creating a powerful reporting capability. Knowledge of working with Excel workbooks and relational databases would be an advantage. Objectives By the end of the course you will be able to: Import data from multiple data sources Edit and transform data before importing Add extra columns of data Append data Merge data from other tables Create data models Build data relationships Build Pivot Tables Build Pivot Charts Use Slicers and Timeline Filters Content Importing data Data sources Importing data Transforming data Editing your data Setting data types Removing columns/rows Choosing columns to keep Setting header rows Splitting columns Appending queries Appending data from other tables Adding text Columns from example Custom columns Conditional columns Merge queries Setting up and using merge queries Merging in columns of data Creating a data model The data model Multiple data tables Connecting tables Building relationships Relationship types Building visuals from multiple tables Analysing information using pivot tables Creating and modifying a Pivot Table Recalculating the Pivot Table Filtering the Pivot Table Searching the Pivot Table Drilling down to underlying data Customising field names Changing field formatting Pivot charts, slices and timelines Creating Pivot Charts Adding and using Slicers

It is estimated that more than 1.2 million people in the UK are living with a learning disability. Healthcare and social care workers must have an adequate understanding of the needs of people with learning disabilities. It is also essential that they listen to the needs, hopes and aspirations of those living with learning disabilities, their careers, friends, and families. An improved knowledge, together with current guidance and best practice recommendations help to improve the care provided to people who have learning disabilities.

This course is only availabe to new user as part of a developemental learning programe. This include a Digital Marketing Course Level 2, which we run on another platform. You are welcome to register your interest by booking a place on this course and will will contact you so you can enrole on our developmental learning programe, that focuses on giving you all the tools you need to run your own business. Welcome to your course! Thank you for choosing to develop your skills in dog walking and sitting. If you focus on this course, you will have all the tools and understanding starting your journey in what can be a profitable and rewarding career. The course is laid out in sections and sub-sections which break down the subject of that into smaller chunk-sized blocks. After each block you will have multiple choice questions to answer. The answer to these questions are contained within the information you have read in that section. None of the questions are trick questions and are intended to check your knowledge and not trip you up. At the end of the whole course, you will have 100 multiple questions that cover every section you have completed and these questions will be there to ensure you can interpret the information you have learned and also to check your knowledge. Your first session will be an online introduction to the course via an online meeting and will enable you to ask questions and meet others who are also completing the course along with you.  TIP: Set yourself time to work exclusively on this course and set yourself a regular time per day to get this completed. If you like many of us, we need to get back into the habit of studying, it takes a bit of structure to make that happen. In our modern age, it's easy to be distracted, with phone calls, your phone beeping and screaming for your attention. Please get yourself into a conformable place and ignore any distractions. This will allow you to get the work competed first time around.

Duration 3 Days 18 CPD hours This course is intended for Application Consultant Business Analyst Business Process Architect Business Process Owner/Team Lead/Power User Developer Development Consultant Program/Project Manager Solution Architect Technology Consultant Overview This course will prepare you to: Understand the SAP Cloud Solution Understand the SAP Cloud Strategy Understand Java Development Understand development in SAP Cloud Classify and use the various Cloud Platform services Understand the various CP Services Explore the Internet of things Get an overview of SAP Cloud Platform, integration Service Understand Extensions of SAP Cloud Solutions This course will introduce and inform you about the vast potential of SAP Cloud Platform with hands-on exercises to dive into this open platform. SAP Cloud Platform, Introduction Introduce SAP Cloud Platform (SAP CP) Explain Landscape Architecture-Relevant Terms Learn about typical Use cases Explore What is in it: Product Capabilities and Services Platform Concepts Understand Basic Platform Concepts Explore Datacenters Understand Security Digital Transformation - Java Development Introduce Digital Transformation, Java Development Explore 12 Factor Microservices Use the Supported Java Development Environment Explain Supported Java Programming Models by CF Operate Java Applications on SAP Cloud Platform NEO Digital Transformation ? SAP HANA Development Understand SAP HANA Development Understand the SAP HANA XSA Development on CF Digital Transformation ? HTML5/SAPUI5/Fiori Development Introduce HTML5, SAPUI5, and Fiori Development Use SAP UI5 Use SAP Fiori Agile Business ? Extend Application Introduce Agile Business Understand the Application Frontend x-tend the Application: Backend Explore SAP Cloud Platform Data and Storage Services Enterprise Optimization ? Integration Services Introduce Enterprise Optimization, Integration Services Explore Available Integration Services Enterprise Optimization ? Process Integration Introduce SAP Cloud Platform, Integration Service Implement iFlows Enterprise Optimization ? API Explain API Management Build and Publish APIs Internet of Things Services (IoT) Explore the Internet of Things (IoT) Other Interesting Services and Features Explain SAP Cloud Platform SaaS Extensions Explore SAP Cloud Platform Business Services Explain Cloud Platform Data and Storage Understand SAP Cloud Platform Security

Duration 5 Days 30 CPD hours This course is intended for Application Consultants, Developers, Solutions Architects, and System Administrators. Overview Work with SAP Fiori ApplicationsUnderstand and leverage the architectures and principles of SAP Fiori and SAP UX DesignConfigure and customize SAP FioriConnect SAP Fiori with other technologies This course provides participants with an overview of Fiori Design Principles. End-User Perspective Explore the Design of SAP Fiori Explore the SAP Fiori Launchpad Explore SAP Fiori Data Handling Personalize SAP Fiori Foundation Explain User Interfaces Explain Data Services Explain Application Types Architecture Examine SAP Fiori for Suite on Any DB Examine SAP Fiori for Suite on HANA Examine SAP Fiori for S/4HANA Examine SAP Fiori Mobile Configuration Create SAP Fiori Groups Create SAP Fiori Catalogs Create LPD_CUST Target Mappings Create SAPUI5 Fiori Target Mappings Create Web Dynpro Target Mappings Create Transaction Target Mappings Configure Analytical Applications Theming Use the UI Theme Designer Use SAP Screen Personas Integration Integrate SAP Workflow Operate SAP Fiori Standalone Explore SAP HANA Cloud Platform Additional course details: Nexus Humans UX100 SAP Fiori - Foundation 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 UX100 SAP Fiori - Foundation 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 operators and schedulers who perform duties that are related to batch workload automation. Overview In this course, you learn how to perform the following tasks:Explain the production terminology used with IBM Workload Scheduler and its production planning processMonitor production batch workload processesManage production batch workloadCreate and modify scheduling objectsSchedule new workloadsForecast future workloadsMigrate workload definitions from test to production environmentsCreate and maintain reports about production workloads This course provides professional report authors an opportunity to learn report building techniques using relational data models. Demonstrations and exercises will illustrate and reinforce key concepts during this learning opportunity. IBM Workload Scheduler Introduction About Workload Automation IBM workload automation offerings IBM Workload Scheduler terminology Workload Scheduler user interfaces Getting started with Application Lab Getting started with the Dynamic Workload Console Connecting the console to Workload Scheduler Getting started with the command-line interfaces Using the Application Lab Interface Using the processes status overview page Managing processes Using other Application Lab functions Monitoring Workload Scheduler Production Monitoring Workload Scheduler production by using queries Using the Workload Dashboard Monitoring system status and health Monitoring plan objects Using the What-if Analysis interface Monitoring the plan graphically Managing Workload Scheduler Production Managing the scheduling environment Managing scheduling objects in the plan Creating Scheduling Objects Using the Workload Designer Creating scheduling objects Creating variables and variable tables Creating prompts and resources Creating calendars Defining jobs Scheduling, Forecasting, and Migrating Workloads Creating job streams Applying jobs to job streams Setting time and date restrictions Using advanced scheduling options Creating job stream definitions by using composer Creating and using event rules Forecasting and previewing future dates Exporting and importing scheduling definitions Using Workload Application Templates Reporting with Workload Scheduler Using reporting features Using Common Reporting with Workload Scheduler Using the batch reporting utility Using the preformatted text-based report utilities

Duration 3 Days 18 CPD hours In this 3 day customized Intermediate SQL course students will learn additional commands and functions using labs/activities/content that correlates with this content. By understanding SQL, you get the knowledge of fundamental queries associated with data management so that you can verify, monitor, and control all the activities operating in the database. Lesson 1 Substring Instr / CharIndex Convert (data types and with Formatting) Replace RowCount / RowNum / Top )n) ÿ(Oracle/SQL Server functions) Case / If Then Else statements Exists Clause Find Duplicates using Group by and have clause (and other tips for analyzing data) Lesson 2 Set operations (UNION, UNION ALL, INTERSECT, MINUS) GROUP BY extensions (ROLLUP, CUBE, and GROUPING SETS) Loops / Cursors Common Table Expressions (CTEs) Lesson 3 Temp Tables / Views Advanced Subqueries Regular Expressions (RegEx) Linked Server Queries Qualified subquery predicates Aggregate functions Optimizing queries SQL Injection Lesson 4 JSON Parsing With Partition By With Over Fuzzy Logic - MDS.mdq.[Similarity]ÿ Additional course details: Nexus Humans Intermediate SQL Custom 3-Day Private Class Outline 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 Intermediate SQL Custom 3-Day Private Class Outline 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 Overview Topics Include:Installation of a multi-node Kubernetes cluster using kubeadm, and how to grow a cluster.Choosing and implementing cluster networking.Various methods of application lifecycle management, including scaling, updates and roll-backs.Configuring security both for the cluster as well as containers.Managing storage available to containers.Learn monitoring, logging and troubleshooting of containers and the cluster.Configure scheduling and affinity of container deployments.Use Helm and Charts to automate application deployment.Understand Federation for fault-tolerance and higher availability. In this vendor agnostic course, you'll learn the installation, configuration and administration of a production-grade Kubernetes cluster. Introduction Linux Foundation Linux Foundation Training Linux Foundation Certifications Laboratory Exercises, Solutions and Resources Distribution Details Labs Basics of Kubernetes Define Kubernetes Cluster Structure Adoption Project Governance and CNCF Labs Installation and Configuration Getting Started With Kubernetes Minikube kubeadm More Installation Tools Labs Kubernetes Architecture Kubernetes Architecture Networking Other Cluster Systems Labs APIs and Access API Access Annotations Working with A Simple Pod kubectl and API Swagger and OpenAPI Labs API Objects API Objects The v1 Group API Resources RBAC APIs Labs Managing State With Deployments Deployment Overview Managing Deployment States Deployments and Replica Sets DaemonSets Labels Labs Services Overview Accessing Services DNS Labs Volumes and Data Volumes Overview Volumes Persistent Volumes Passing Data To Pods ConfigMaps Labs Ingress Overview Ingress Controller Ingress Rules Labs Scheduling Overview Scheduler Settings Policies Affinity Rules Taints and Tolerations Labs Logging and Troubleshooting Overview Troubleshooting Flow Basic Start Sequence Monitoring Logging Troubleshooting Resources Labs Custom Resource Definition Overview Custom Resource Definitions Aggregated APIs Labs Kubernetes Federation Overview Federated Resources Labs Helm Overview Helm Using Helm Labs Security Overview Accessing the API Authentication and Authorization Admission Controller Pod Policies Network Policies Labs

Introducing you to the basic meanings on each card, covering different reading spreads and connecting deeply with your intuition so that you can read for yourself and others with accuracy and confidence.

AAT Distance Learning AAT Distance Learning simply allows you to study at a time and place to suit you, whether that be at home or at work. We understand that it can sometimes be difficult to get to a centre, for various reasons. That's why distance learning offers you the perfect way to fit your studies around your daily commitments, instead of the other way round, which is often the case. Our friendly course advisers will supply you with all of the learning materials such as course books, workbooks and software required to get you started. Moreover, you would get access to our State of the art VLC (Virtual Learning Campus), where you would be able to access ample study resources to support your studies. Moreover, with AAT home study, from time to time you can contact your personal tutor by email or by phone if you have any issue . For AAT distance learning courses courses we deliver the study books to your home address. In summary, AAT Distance Learning courses are self study method with tutorial support and you do not have to join any lecture sessions as you study according to your own pace. AAT Level 2 Distance learning course covers Coursebooks and workbooks delivered to your home address. Access to VLC or online student portal for additional aat study materials. Sage 50 Accounts software included in the study package. 4 computer based tests and 1 final Synoptic assessment. AAT Level 3 Distance learning course covers No of Coursebooks and workbooks delivered to your home address. Access to VLC(Virtual Learning Campus) or online student portal for additional aat study materials. 4 computer based tests and 1 final Synoptic assessment at an approved AAT Exam Centre. AAT Level 4 Distance learning course covers Coursebooks and workbooks for chosen subjects delivered to your home address. Access to VLC(Virtual Learning Campus) or online student portal for additional aat study materials. 5 computer based tests and 1 final Synoptic assessment at an approved AAT Assessment venue.