2355 Courses in London

2 Day Supervising First Aid for Mental Health course is a specialized program catering to leaders and supervisors, equipping them with essential skills to foster a mentally healthy work environment.

This course starts with the basics then moves seamlessly to an intermediate level. It includes a comprehensive yet balanced look at the four main components that make up Power BI Desktop: Report view, Data view, Model view, and the Power Query Editor. It also demonstrates how to use the online Power BI service. It looks at authoring tools that enables you to connect to and transform data from a variety of sources, allowing you to produce dynamic reports using a library of visualisations. Once you have those reports, the course looks at the seamless process of sharing those with your colleagues by publishing to the online Power BI service. The aim of this course is to provide a strong understanding of the Power BI analysis process, by working with real-world examples that will equip you with the necessary skills to start applying your knowledge straight away. 1 Getting started The Power BI process Launching Power BI Desktop The four views of Power BI Dashboard visuals 2 Connecting to files Connect to data sources Connect to an Excel file Connect to a CSV file Connect to a database Import vs. DirectQuery Connect to a web source Create a data table 3 Transforming data The process of cleaning data Column data types Remove rows with filters Add a custom column Append data to a table Fix error issues Basic maths operations 4 Build a data model Table relationships Manage table relationships 5 Merge queries Table join kinds Merging tables 6 Create report visualisations Creating map visuals Formatting maps Creating chart visuals Formatting chart Tables, matrixes, and cards Control formatting with themes Filter reports with slicers Reports for mobile devices Custom online visuals Export report data to Excel 7 The power query editor Fill data up and down Split columns by delimiter Add conditional columns Merging columns 8 The M formula Creating M functions Create an IF function Create a query group 9 Pivot and unpivot tables Pivot tables in the query editor Pivot and append tables Pivot but don't summarise Unpivot tables Append mismatched headers 10 Data modelling revisited Data model relationships Mark a calendar as a date table 11 Introduction to calculated columns New columns vs. measures Creating a new column calculation The SWITCH function 12 Introduction to DAX measures Common measure categories The SUM measure Adding measures to visuals COUNTROWS and DISINCTCOUNT functions DAX rules 13 The CALCULATE measure The syntax of CALCULATE Things of note about CALCULATE 14 The SUMX measure The SUMX measure X iterator functions Anatomy of SUMX 15 Introduction to time intelligence Importance of a calendar table A special lookup table The TOTALYTD measure Change year end in TOTALYTD 16 Hierarchy, groups and formatting Create a hierarchy to drill data Compare data in groups Add conditional formatting 17 Share reports on the web Publish to the BI online service Get quick insights Upload reports from BI service Exporting report data What is Q&A? Sharing your reports 18 Apply your learning Post training recap lesson

All organisations are legally required to have at least one designated Fire Warden. It's also common sense, given that every year there are nearly 20,000 commercial fires in the UK. This course will help participants: Assess their awareness and knowledge of the principles of fire safety and the associated risks involved at work Understand the responsibilities of being a Fire Warden Understand the main types of firefighting equipment 1 Introduction to fire safety What to do in an emergency Causes and effects of fire The fire warden's duties and responsibilities 2 Fire risk control How to raise the alarm Assembly points, roll calls, drills Fire prevention and fire risk assessment Understanding the fire triangle 3 Practical fire safety Types of portable fire extinguishers Maintenance of firefighting equipment Fire signs In-house checks The fire bag/box

Using an excavator as a crane is a common practice in certain construction and lifting operations. Using the digger as a crane requires appropriate training and skills However, it’s important to note that excavators are primarily designed for digging and earthmoving, not lifting. Using an Excavator as a Crane involves some inherent risks, and it’s crucial to follow safety guidelines and manufacturer recommendations. To book the NPORS Excavator as a Crane training or test please contact us to schedule your Training Here are some general considerations and steps you might take when using an excavator as a crane: 1. Check Manufacturer Guidelines: Always consult the manufacturer’s guidelines and specifications for the specific excavator model you are using. Manufacturers provide load charts and other essential information to ensure safe operation. 2. Understand Load Capacities: Know the lifting capacities of your excavator at various boom lengths and angles. Exceeding these capacities can lead to instability and accidents. 3. Use Proper Attachments: If your excavator is equipped with a lifting attachment, make sure it is designed and rated for lifting operations. Using inappropriate attachments can compromise safety. 4. Stabilise the Excavator: Ensure that the excavator is on stable ground. Extend the outriggers or stabilisers to provide additional support and prevent tipping. 5. Inspect the Excavator: Regularly inspect the excavator for any signs of wear, damage, or malfunction. Pay particular attention to the boom, hydraulics, and other critical components. 6. Position the Excavator: Position the excavator in a way that allows for a stable lifting operation. Avoid working on slopes or uneven surfaces. 7. Rigging and Lifting Techniques: Use proper rigging techniques, and ensure that the load is properly secured. Lift the load smoothly and avoid sudden movements. 8. Maintain Clear Communication: Establish clear communication between the operator and any ground personnel involved in the lifting operation. Use hand signals or radios to coordinate movements. 9. Avoid Exceeding Reach Limits: Do not exceed the excavator’s reach limits. Lifting loads beyond the recommended reach can lead to instability. 10. Training and Certification: Ensure that operators are properly trained and certified for lifting operations. Holding the NPORS Excavator As A Crane bolt on is essential for lifting operations Operating an excavator as a crane requires specific skills and knowledge. 11. Weather Conditions: Consider weather conditions, especially wind speeds, as they can affect the stability of the excavator during lifting operations. Always prioritise safety when using equipment for tasks it wasn’t originally designed for. If the lifting requirements are frequent or extensive, it may be more appropriate to use a dedicated crane with the necessary capacity and features. Remember, safety is paramount in any construction or lifting operation. Frequently Asked Questions 1. What is Excavator As A Crane Training, and why is it necessary? Excavator As A Crane Training provides individuals with the skills and knowledge required to safely and effectively use excavators for lifting operations. Although excavators are primarily designed for digging and earthmoving, this training ensures operators can perform lifting tasks safely, minimizing risks and accidents on job sites. 2. Who should undergo Excavator As A Crane Training? This training is essential for anyone involved in using excavators for lifting operations, including machine operators, construction workers, and site supervisors. Proper training ensures that individuals understand equipment operation procedures, load capacities, and safety protocols. 3. What topics are covered in Excavator As A Crane Training programs? Training programs cover a range of topics, including: Manufacturer guidelines and load charts Understanding load capacities at various boom lengths and angles Proper use of lifting attachments Excavator stabilization techniques Rigging and lifting techniques Positioning and communication strategies Safety procedures and weather considerations Regular inspection and maintenance of equipment 4. Is Excavator As A Crane Training mandatory in certain industries? While not legally mandated in all areas, many employers in the construction and lifting industries require operators to undergo training as part of their occupational health and safety policies. Compliance with excavator as a crane training requirements helps prevent accidents and ensures regulatory compliance. 5. Where can I find reputable Excavator As A Crane Training courses? Reputable Excavator As A Crane Training Courses are offered by various institutions, including industry associations, equipment manufacturers, and specialized training providers like Vally Plant Training. It is important to choose a program that offers accredited certification and covers relevant industry standards and best practices.

This course is designed to provide delegates that intend to work as part of a confined space rescue team with an introduction to planning and executing casualty rescue procedures and the equipment which may be required. This is intended for delegates who already hold a high risk (full Breathing apparatus) qualification such as our CS2. Note: A pre-requisite qualification is required to complete this course. The ESS CS2 course (https://www.vp-ess.com/training/confined-spaces/cs2-(high-risk)-confined-space-entry-full-breathing-apparatus,-self-rescue-and-ba-control/) must have been completed within 6 months as a pre-requisite for this CS3 course. Book via our website @ https://www.vp-ess.com/training/confined-spaces/cs3-introduction-to-working-as-a-member-of-a-confined-space-rescue-team/ or via email at: esstrainingsales@vpplc.com or phone on: 0800 000 346

Learners develop an essential understanding of caring for people with dementia, and covers the benefits of positive communication, use of medication, and importance of highly individualised, person-centred care

The aim of this course is to provide an overview of the principles and practice for leading and managing a portfolio of smaller projects in a multi-project / multi-task environment. It presents a range of practical methods and techniques relevant to the smaller project scenario, using exercises and case studies to show how these can be applied. The scope of the programme includes: The course also emphasises the importance of the leadership and team-working skills needed by project managers and team members in carrying out their roles. The principal training objectives for this programme are to: Explain and demonstrate the key principles of successful project management Demonstrate a range of useful project management tools and techniques Define the role, and help participants understand the skills required by, the project leader Provide a structured framework to help participants manage multiple projects Identify opportunities to improve project management within the organisation DAY ONE 1 Introduction (Course sponsor) Why this programme has been developed Review of participants' needs and objectives 2 Managing smaller projects Projects and project management Lessons from past projects; the essential requirements for success Differences between projects; characteristic project life cycles Key issues and challenges of smaller projects The multi-project world; project portfolio management 3 Project exercise Syndicate teams plan and manage a small project Review of the project exercise: What are the keys to successful management of small projects? 4 Setting up the project Getting organised Managing the definition process Identifying and managing project stakeholders Working with the customer to define the scope and agree deliverables 5 Case study 1 Defining the project scope and deliverables Syndicate teams define the scope and deliverables for a typical project 6 Project planning The importance and cost benefit of effective planning Planning the plan; deciding how detailed a plan to create Packaging the work and estimating timescales and costs Developing project / resource schedules; setting milestones for control v Identifying and managing critical path activities 7 Case study 2 Creating the project plan Syndicate teams develop and analyse the project plan DAY TWO 8 Managing project risks Identifying risks to the project outcome, timescale and cost Evaluating risks and adopting an appropriate risk strategy Defining risk ownership; keeping a simple risk log Keeping risk management up to date; staying pro-active Integrating planning and risk management 9 Project control Managing change, minimising scope creep Selecting the data needed to provide early warning of problems Monitoring performance easily with 'S' curves and slip charts Using trend forecasting to assess true project status Running project review meetings 10 Managing a multi-project portfolio Understanding the world of multiple projects Establishing ownership of project / programme management Classifying projects and creating the 'master schedule' Defining and applying project lifecycle management Resource management: essential pre-requisites and mechanisms Project prioritisation criteria and techniques; pain / gain analysis 11 Managing the multi-project team Characteristics of small project teams / part-time team membership Clarifying line and project management responsibilities Implementing effective manpower planning Establishing professional working practices in the team Developing project management competences in the team Establishing team roles and integrating team members 12 Course review and transfer planning (Course sponsor present) Identify actions to be implemented individually Identify corporate opportunities for improving project management Sponsor-led review and discussion of proposals Conclusion

This course aims to provide a more in depth understanding of confidentiality and record keeping. Providing information on the importance of accurate and true record keeping.

This two-day programme gives the key insights and understanding of contracting principles and the impact they have on business and operations. The course is designed for individuals involved in or supporting contracting who want to improve their commercial management skills; individuals in functions such as project management, business development, finance, operations who need practical training in commercial management; general audiences wanting to gain a basic understanding of commercial management. This is an assessed programme, leading to the International Association for Contracts & Commercial Management (IACCM)'s coveted Contract and Commercial Management Associate (CCMA) qualification. The programme addresses 31 different subject areas, across the five stages of the contracting process. By the end of the course the participants will be able, among other things, to: Develop robust contract plans, including scope of work and award strategies Conduct effective contracting activities, including ITT, RFP, negotiated outcomes Negotiate effectively with key stakeholders, making use of the key skills of persuading and influencing and to work with stakeholders to improve outcomes Set up and maintain contract management systems Take a proactive approach to managing contracts Make effective use of lessons learned to promote improvements from less than optimal outcomes, using appropriate templates Develop and monitor appropriate and robust Key Performance Indicators to manage the contractor and facilitate improved performance Understand the approvals process and how to develop and present robust propositions Make appropriate use of best practice contract management tools, techniques and templates DAY ONE 1 Introductions Aims Objectives Plan for the day 2 Commercial context Explaining the contracting context Define the key objective The importance of contact management Impact upon the business 3 Stakeholders How to undertake stakeholder mapping and analysis Shared vision concept, How to engage with HSE, Finance, Operations 4 Roles and responsibilities Exploring the key roles and responsibilities of contract administrators, HSE, Finance, Divisional managers, etc 5 Initiating the contract cycle Overview of the contracting cycle Requirement to tender Methods Rationale and exceptions 6 Specifications Developing robust scope of works Use of performance specifications Output based SOW 7 Strategy and award criteria Developing a robust contract strategy Award submissions/criteria 8 Managing the tender process Review the pre-qualification process Vendor registration rules and processes Creation of bidder lists Evaluation, short listing, and how to use of the 10Cs© model template and app 9 Types of contract Classify the different types of contracts Call-offs Framework agreement Price agreements Supply agreements 10 The contract I: price Understanding contract terms Methods of compensation Lump sum, unit price, cost plus, time and materials, alternative methods Cost plus a fee, target cost, gain share contracts Advanced payments Price escalation clauses DAY TWO 11 Risk How to manage risks Risk classification Mitigation of contractual risks 12 Contractor relationship management session Effectively managing relationships with contractors, Types of relationships Driving forces? Link between type of contract and style of relationship 13 Disputes Dealing with disputes Conflict resolution Negotiation Mediation Arbitration 14 Contract management Measuring and improving contract performance Using KPIs and SLAs Benchmarking Cost controls 15 The contract II: terms and conditions Contract terms and conditions Legal aspects Drafting special terms 16 Managing claims and variations How to manage contract and works variations orders Identifying the causes of variations Contractor claims process 17 Completion Contract close-out process Acceptance/completion Capture the learning/HSE Final payments, evaluation of performance 18 Close Review Final assessment

Dementia affects around 820,000 people in the UK. This figure is likely to rise to one million by 2025 and two million by 2051. It is one of the main causes of disability in later life and with research being desperately underfunded, it costs the UK over £26 billion a year. Understanding dementia and the person-centred care that is required is fundamental to high quality care.