• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

857 Spa courses in Leeds

NPORS Lorry Loader Training

5.0(3)

By Vally Plant Training

Lorry Loader Training The aim of the Lorry Loader Training or Clamshell Bucket Courses is to provide the candidate with the basic knowledge and practical skills involved in operating a Lorry Loader ( HIAB ) or clamshell bucket courses, and on successful completion of the practical test, you will be issued with the NPORS Identity card with or without the CSCS logo. Discounts are available for multiple bookings NPORS/CSCS Lorry loader Experienced Worker Test or Training can only be delivered on our customer’s sites nationwide, Therefore reducing downtime and disruption of works to our clients. Experienced operator – NPORS Lorry Loader Test Book with Confidence at Vally Plant Training At Vally Plant Training, we guarantee unbeatable value with our Lorry Loader Experienced Test Price Match Promise. When you choose us, you can book with confidence, knowing that we will not be beaten on price. If you find a lower price for the same NPORS Lorry Loader Experienced Worker Test, we’ll match it—ensuring you receive top-quality training at the best possible rate. Click for our terms and conditions Your skills, our commitment—always at the best price. NPORS Lorry Loader Test is for operators who have received some form of training in the past or alternatively has been operating the Lorry Loader for several years. If you are unsure if you qualify to go down the test route please contact us to discuss this in more detail. Discounts are available for multiple bookings There are two parts to the lorry loader test, a theory section comprised of 25 questions and a practical session. Lorry Loader Training Course: Safely Operating Mobile Crane Vehicles 1. Introduction to Lorry Loaders Overview of lorry loader types and configurations Understanding the components and controls of a lorry loader Different applications and lifting capacities of lorry loaders 2. Lorry Loader Safety Procedures Importance of safety in lorry loader operation Pre-operational checks and inspections Understanding load charts and load capacities Personal protective equipment (PPE) requirements Emergency procedures: shutdown, lockout/tagout, and evacuation protocols 3. Lorry Loader Operation Basics Starting, stopping, and controlling the lorry loader, include emergency stops Familiarisation with lorry loader controls: boom, remote, and outriggers Manoeuvring the lorry loader on different terrain types: roads, construction sites, etc. Lifting and lowering loads safely and accurately 4. Load Handling Techniques Proper assessment of loads: weight, size, and stability Positioning the lorry loader for efficient loading and unloading Securing loads with proper rigging techniques: slings, chains, and hooks Stacking and de-stacking loads safely and efficiently Using other professionals to complete the work. Slinger signaller to direct the load 5. Site Safety and Hazard Awareness Identifying potential hazards in the workplace Working safely around pedestrians, other vehicles, and obstacles Recognising environmental hazards: overhead obstructions, power lines, etc. Understanding site-specific safety rules and regulations 6. Maintenance and Inspections Importance of regular maintenance for lorry loader performance and reliability Daily, pre-shift, and post-shift inspection procedures Lubrication points and maintenance schedules Identifying and reporting mechanical issues and wear parts replacement 7. Practical Hands-On Training Practical exercises in lorry loader operation under supervision Manoeuvring through obstacle courses and confined spaces Load handling exercises: lifting, positioning, and placing loads Emergency response drills: simulated scenarios to test response and decision-making skills 8. Assessment and Certification Written examination to assess theoretical knowledge Practical assessment of lorry loader operation skills Certification upon successful completion of the course A lorry loader training course, by Vally Plant Training provides participants with the essential knowledge, skills, and confidence to operate lorry loaders safely and efficiently in various work environments. By covering topics such as safety procedures, operation techniques, load handling, site awareness, maintenance practices, and practical hands-on training, participants can enhance their proficiency and contribute to a safer and more productive workplace. Whether you’re a novice operator or an experienced professional, investing in lorry loader training is essential for ensuring compliance, reducing risks, and maximising productivity in lifting operations. Lorry Loader Training Available 7 days a week to suit your business requirements. VPT have a team of friendly and approachable instructors, who have a wealth of knowledge of lorry loader and the construction industry We have our own training centre conveniently located close to the M5 junction 9, In Tewkesbury. With its own purpose-built HIAB practical training area to simulate an actual working environment. Our Lorry Loader or clamshell bucket courses and test packages are priced to be competitive. Discounts are available for multiple bookings We can send a fully qualified NPORS LORRY LOADER Tester to your site nationwide, to reduce the amount of time away from work More courses: Polish your abilities with our dedicated Lift Supervision Training, Slinger Signaller Training, Telehandler Training, Cat & Genny Training, Plant Loader Securer, Ride-On Road Roller, Abrasive Wheel Training, Lorry Loader Training and Scissor Lift Training sessions. Learn the safe and effective operation of these vital machines, crucial for construction and maintenance tasks. Elevate your skills and career prospects by enrolling in our comprehensive courses today. Frequently Asked Questions 1. What is the aim of the Lorry Loader Training course? • The course aims to provide candidates with the basic knowledge and practical skills involved in operating a Lorry Loader (HIAB) or clamshell bucket. Successful completion of the practical test will result in receiving the NPORS Identity card with or without the CSCS logo. 2. What does the Lorry Loader training course cover? • The course covers various aspects, including: o Types and configurations of lorry loaders o Safety procedures and pre-operational checks o Operation basics, including controls and manoeuvring o Load handling techniques o Site safety and hazard awareness o Maintenance and inspection procedures o Practical hands-on training and assessments 3. What is the duration of the Lorry Loader Training course? • For experienced operators, the course is a 1-day test, accommodating up to 4 candidates. For novice operators, it is a 2-day training session, accommodating up to 3 candidates. 4. Where is the training conducted? • Training can be conducted at the client’s site nationwide, which helps reduce downtime and disruption to work. The training centre is located near the M5 junction 9 in Tewkesbury, with a purpose-built HIAB practical training area. 5. What are the certification options available? • There are two certification options: o NPORS traditional card (valid for 5 years) o NPORS card with CSCS logo (initial RED trained operator card valid for 2 years, upgradable to BLUE competent operator card upon completing relevant NVQ) For those looking for a “NPORS Lorry Loader Training near me,” our widespread operations make it convenient for you to access Vally Plant Trainings top-quality training no matter where you are in the UK

NPORS Lorry Loader Training
Delivered In-Person in Tewkesbury or UK WideFlexible Dates
Price on Enquiry

NPORS Excavator Training

5.0(3)

By Vally Plant Training

360 Excavator Training Courses From The objective of the NPORS 360 Excavator Training courses is to deliver comprehensive theoretical and practical training, ensuring the safe utilisation of excavators. This course covers the proficient operation of both wheeled or tracked excavators, catering to potential Digger operators. Upon successfully completing the NPORS Excavator Training Course, participants will be awarded the red trained operator card or the NPORS Traditional card, signifying their competence in completing the 360 excavator courses. Book direct with Vally Plant Training Today. This Novice 360 Excavator courses span five days and provides personalised 1 on 1 training, offering participants a focused and tailored learning experience to enhance their skills in excavator operation. Our price is structured to 1 on 1 training helping you to gain the Digger Driver Ticket 360 Excavator courses or testing can be carried out on your site Nationwide or our site in Gloucestershire NPORS Excavator Test Book with Confidence at Vally Plant Training At Vally Plant Training, we guarantee unbeatable value with our Excavator Experienced Test Price Match Promise. When you choose us, you can book with confidence, knowing that we will not be beaten on price. If you find a lower price for the same NPORS Excavator Experienced Worker Test, we’ll match it—ensuring you receive top-quality training at the best possible rate. Click for our terms and conditions Your skills, our commitment—always at the best price. NPORS Excavator Test is for operators who have been using the excavators in the workplace for a few years or that they have had some form of in-formal training in the past. If you are unsure if you qualify to go down the test route please contact our team to discuss this in more detail. If you book this route with us you will receive revision notes for the 25 questions. Discounts are available for multiple bookings NPORS Lifting Operations, Excavator As A Crane is an add on to the excavator operator card to enable the operator to safely pick and carry underslung loads, you can add the excavator as a crane at the same time as your 360 Excavator Training Turn your Excavator red card to blue with our hassle free Excavator NVQ, for more information EXCAVATOR NVQ 360 Excavator Training Course: Mastering Operation, Safety, and Maintenance 360 Excavators are versatile and powerful pieces of machinery widely used in the construction industry for various tasks, from digging trenches to lifting heavy loads with the use of Quick Hitches and Tilt Rotators. However, operating an excavator requires more than just basic knowledge of its controls; it demands proficiency, safety consciousness, and a comprehensive understanding of its capabilities. In this detailed course outline, Vally Plant Training will delve into the essential content covered in an 360 Excavator training course, designed to equip participants with the skills and knowledge needed to operate, maintain, and safely manoeuvre excavators on construction sites. If you’re keen on mastering the art of manoeuvring those heavy-duty machines, the 360 digger training at Vally Plant Training is just what you need. This course is designed to transform you into a pro at operating 360-degree excavators, making you adept at a variety of tasks, from digging to precision handling. The program is tailored to cater to both beginners and experienced operators, ensuring that everyone walks away with valuable skills. For newcomers, there’s an extensive 5-day hands-on 360 digger training where you’ll be immersed in learning the ins and outs of these massive machines, ensuring you get ample time to practice and perfect your technique. The 360 excavator courses for a Novice are 1 on 1 training, this will give you 100% of available time on the excavator learning more than the basics to enable you to pass the NPORS 360 excavator training course first time. Introduction to 360 Excavator Training All Health and safety legislations covered Overview of excavator types and configurations Components and anatomy of an excavator Understanding hydraulic systems and controls 360 Excavator courses Safety Procedures Importance of safety in excavator operation Pre-operation inspection checklist Safe entry and exit procedures Personal protective equipment (PPE) requirements Emergency shutdown procedures 360 Excavator Operation Basics Starting and shutting down procedures Familiarisation with controls: joysticks, pedals, and switches Basic manoeuvres: moving forward, backward, turning, and slewing Operating the boom, arm, and bucket controls Operate Quick Hitches and Tilt Rotators if fitted Understanding machine stability and centre of gravity Excavation Techniques Digging trenches and excavating foundations Sloping and benching techniques for safe excavation Loading dumper trucks and stockpiling materials Precision excavation for utilities and pipelines Lifting and Rigging: Excavator as a crane Overview of Excavator lifting capacities and load charts Selecting appropriate lifting attachments Rigging techniques: using hooks, slings, and chains Safe lifting practices and procedures Excavator Maintenance Importance of regular maintenance for optimal performance Daily, weekly, and monthly maintenance checks Lubrication and greasing points Troubleshooting common issues and repairs Site Safety and Hazard Awareness Identifying and mitigating hazards on construction sites Understanding underground utilities and potential hazards Working safely near power lines and other overhead obstructions Site-specific safety protocols and regulations Practical Hands-On Training Practical exercises in operating an excavator under supervision Manoeuvring in various terrain conditions Excavation tasks: digging trenches, loading trucks, etc. Lifting and rigging exercises with simulated loads NPORS Assessment and Certification Written examination to assess theoretical knowledge Practical assessment of excavator operation skills Certification upon successful completion of the Excavator Course Excavator Variations Micro Excavator up to 1Tons: Excavator Below 10T Excavator above and below 10T Wheeled Or Tracked 180 excavator (3CX) Lifting Operations (additional) Quick Hitch Training Frequently Asked Questions 1. What is 360 excavator operator training, and why is it necessary? 360 Excavator training provides individuals with the skills and knowledge needed to safely and efficiently operate excavators, heavy machinery used in construction, mining, and other industries. It’s essential for ensuring the safety of operators, preventing accidents, and maximising productivity on job sites. All Vally Plant Trainings Excavator Novice courses are 1 on 1 training helping you to gain the digger driver ticket 2. Who should undergo 360 excavator operator training? Anyone who operates or intends to operate excavators should undergo proper excavator training. This includes construction workers, heavy equipment operators, site supervisors, and contractors. Training is also valuable for individuals seeking employment in industries where excavators are commonly used. 3. What topics are covered in excavator 360 course programs? Excavator training programs typically cover a range of topics, including equipment familiarisation, safety procedures, pre-operation inspection, proper operation techniques, trenching and excavation techniques, site hazards identification, and emergency procedures. Our Training programs include hands-on practical training. 4. How long does excavator 360 course take? The duration of excavator training programs can vary depending on factors such as the level of experience of the participants and the depth of the curriculum. Basic training courses may last anywhere from a few days to 2 weeks. Vally Plant Training can also offer shorter refresher courses for experienced Excavator operators. Contact Vally Plant Training For more information 5. Is 360 excavator training Courses mandatory? While excavator training may not be legally mandated,, many employers require operators to undergo 360 Excavator Training as part of their occupational health and safety policies. Additionally, regulatory bodies and industry associations often recommend or require training certification for operating heavy machinery like excavators on site. 6. Where can I find reputable excavator training courses? Reputable 360 excavator training courses are offered by a variety of sources, including vocational schools, community colleges, private training providers, and equipment manufacturers. It’s important to choose a program that is accredited, led by experienced instructors, and covers relevant industry standards and regulations. Additionally, employers may offer in-house training or provide recommendations for external training providers. Call Vally Plant Training for all reputable training including 360 excavator training. How much does a 360 excavator driver earn?A 360 excavator driver earns Approximately between £24,000 and £40,000 pa. This will depend on things like competence, qualifications, skills, and the amount of work you have completed over the years. holding the NPORS Excavator Operator card will give you a better chance of work.How To Apply For 360 Excavator TrainingIf you want to apply for the 360 excavator Training courses in Gloucestershire then please use our contact form to enquire about our excavator courses. Contact us to find more about the other courses that we offer, and any special offers we have running each month. Please give us as much information as possible about the course, like, is this the first time on the machine or have you had previous certification on the plant.. 360 Excavator Training Courses Available 7 days a week to suit your business requirements. VPT have a team of friendly and approachable instructors, who have a wealth of knowledge of the excavator and the Construction & Agricultural industry We have our own training centre conveniently located close to the M5 junction 9, In Tewkesbury. With its own purpose-built Excavator practical training area to simulate an actual working environment. Our 360 Excavator Training Courses and test packages are priced to be competitive. Discounts are available for multiple bookings We can send a fully qualified NPORS Excavator assessor to your site nationwide, to reduce the amount of time away from work to complete the 360 Excavator Training or travel to Vally Plant Training’s Facility in Gloucestershire. Our more courses: Polish your abilities with our dedicated Lift Supervision Training, Slinger Signaller Training, Telehandler Training, Cat & Genny Training, Plant Loader Securer, Ride-On Road Roller, Abrasive Wheel Training, Lorry Loader Training and Scissor Lift Training sessions. Learn the safe and effective operation of these vital machines, crucial for construction and maintenance tasks. Elevate your skills and career prospects by enrolling in our comprehensive courses today. Ever wondered what it feels like to take control of a 13-tonne excavator? Now’s your chance to find out with this thrilling 13T Excavator Digger Driving Experience. For a full two hours, you’ll be in the driver’s seat, operating one of these colossal machines just like the professionals you’ve seen on motorways and construction sites across the country. Under the expert guidance of the UK’s Number 1 accredited training organisation, you’ll learn how to manoeuvre this massive piece of machinery with skill and precision. From loading dumpers and moving dirt around to digging impressive holes, you’ll experience the raw power and versatility of a 13-tonne excavator first-hand. For those looking for a “NPORS Excavator Training near me,” our widespread operations make it convenient for you to access Vally Plant Trainings top-quality training no matter where you are in the UK

NPORS Excavator Training
Delivered In-Person in Tewkesbury or UK WideFlexible Dates
Price on Enquiry

Tableau Desktop Training - Foundation

By Tableau Training Uk

This Tableau Desktop Training course is a jumpstart to getting report writers and analysts with little or no previous knowledge to being productive. It covers everything from connecting to data, through to creating interactive dashboards with a range of visualisations in two days of your time. For Private options, online or in-person, please send us details of your requirements: This Tableau Desktop Training course is a jumpstart to getting report writers and analysts with little or no previous knowledge to being productive. It covers everything from connecting to data, through to creating interactive dashboards with a range of visualisations in two days of your time. Having a quick turnaround from starting to use Tableau, to getting real, actionable insights means that you get a swift return on your investment of time and money. This accelerated approach is key to getting engagement from within your organisation so everyone can immediately see and feel the impact of the data and insights you create. This course is aimed at someone who has not used Tableau in earnest and may be in a functional role, eg. in sales, marketing, finance, operations, business intelligence etc. The course is split into 3 phases and 9 modules: PHASE 1: GET READY MODULE 1: LAUNCH TABLEAU Check Install & Setup Why is Visual Analytics Important MODULE 2: GET FAMILIAR What is possible How does Tableau deal with data Know your way around How do we format charts Dashboard Basics – My First Dashboard MODULE 3: DATA DISCOVERY Connecting to and setting up data in Tableau How Do I Explore my Data – Filters & Sorting How Do I Structure my Data – Groups & Hierarchies, Visual Groups How Tableau Deals with Dates – Using Discrete and Continuous Dates, Custom Dates Phase 2: GET SET MODULE 4: MAKE CALCULATIONS How Do I Create Calculated Fields & Why MODULE 5: MAKE CHARTS Charts that Compare Multiple Measures – Measure Names and Measure Values, Shared Axis Charts, Dual Axis Charts, Scatter Plots Showing Relational & Proportional Data – Pie Charts, Donut Charts, Tree Maps MODULE 6: MAKE TABLES Creating Tables – Creating Tables, Highlight Tables, Heat Maps Phase 3: GO MODULE 7: ADD CONTEXT Reference Lines and Bands MODULE 8: MAKE MAPS Answering Spatial Questions – Mapping, Creating a Choropleth (Filled) Map MODULE 9: MAKE DASHBOARDS Using the Dashboard Interface Dashboard Actions This training course includes over 25 hands-on exercises and quizzes to help participants “learn by doing” and to assist group discussions around real-life use cases. Each attendee receives a login to our extensive training portal which covers the theory, practical applications and use cases, exercises, solutions and quizzes in both written and video format. Students must use their own laptop with an active version of Tableau Desktop 2018.2 (or later) pre-installed. What People Are Saying About This Course “Excellent Trainer – knows his stuff, has done it all in the real world, not just the class room.”Richard L., Intelliflo “Tableau is a complicated and powerful tool. After taking this course, I am confident in what I can do, and how it can help improve my work.”Trevor B., Morrison Utility Services “I would highly recommend this course for Tableau beginners, really easy to follow and keep up with as you are hands on during the course. Trainer really helpful too.”Chelsey H., QVC “He is a natural trainer, patient and very good at explaining in simple terms. He has an excellent knowledge base of the system and an obvious enthusiasm for Tableau, data analysis and the best way to convey results. We had been having difficulties in the business in building financial reports from a data cube and he had solutions for these which have proved to be very useful.”Matthew H., ISS Group

Tableau Desktop Training - Foundation
Delivered in Birmingham + 2 more or UK Wide or OnlineFlexible Dates
Price on Enquiry

Working Safely - IOSH Award (In-House)

By The In House Training Company

A high-impact programme designed to be fun and to get people fully involved. The first-class, jargon-free content is based on what people need to know in practice, not off-putting legal language. This introductory course covers: Introducing Working Safely: Accidents can happen to anyone. The realities of the human suffering behind the statistics. The importance of personal responsibility. Defining hazard and risk: Focusing on the six broad hazard groups, participants are asked to think about the hazards and risks they come across in their own work. 'Risk assessment' demystified. Identifying common hazards: All the main issues - aggression and violence, asbestos, bullying, chemicals and harmful substances, computer workstations, confined spaces, drugs and alcohol, electricity, fire, getting in and out, height, housekeeping, lighting, manual handling, noise, personal hygiene, plant and machinery, slips and trips, stress, temperature, vehicles and transport, and welfare facilities. Improving safety performance: Bridging the gap between management and workforce, encouraging participants to play their part. Also covered: contract work, inspections, safe systems and permits, protective equipment, signage, emergency procedures, reporting and health checks.

Working Safely - IOSH Award (In-House)
Delivered in Harpenden or UK Wide or OnlineFlexible Dates
Price on Enquiry

Personal resilience (In-House)

By The In House Training Company

This workshop-based bite-size will provide space to explore some practical tools and ideas on how to be more resilient when faced with challenging and tough situations. There is an opportunity to do a self assessment and bring it to the day as a means to identify areas to work on and begin to master skills that will enhance resilient thinking. There will be time to explore what resilience is and understand the range of practical tools and techniques available that can be used beyond the workshop itself. By the end of the workshop participants will be able to: Discuss and evaluate their personal strengths and areas for development in being more resilient at work Understand what resilience involves and how to identify and challenge their own beliefs that undermine resilience Understand the four aspects of resilience - confidence, adaptability, building support and maintaining a clear perspective Understand how to use resiliency tools to help to cope better with the challenge of change Review and evaluate their learning and have an action plan to take back and implement in the workplace 1 Welcome, introductions and objectives Breaking the ice 2 Identifying current challenges in relation to work How we handle these challenges 3 Defining resilience and how and why it helps our personal effectiveness and thinking 4 Resilience skills and how to develop them 5 Learning a resilience tool that promotes new ways of thinking / working 6 Review and evaluation of learning Action planning

Personal resilience (In-House)
Delivered in Harpenden or UK Wide or OnlineFlexible Dates
Price on Enquiry

Business writing skills (In-House)

By The In House Training Company

This very practical workshop is designed to enable participants to improve the impact, clarity and accuracy of their business documents - both internal and external.: This workshop will help participants: Identify the purpose of writing their documents - to themselves and to their readers Recognise and meet the needs of their readers Plan documents systematically and improve the layout, flow and structure Express the content more clearly, concisely and correctly Adapt the tone and style of writing to the circumstances Proof-read and edit work effectively, using formal marks and techniques Improve visual layout, format and appearance 1 Course objectives Welcome and Introductions The problems now - group discussion 2 Writing better business documents What points to highlight / exclude Starting off Introductions Conclusions Executive summaries 3 Rules and standards George Orwell's famous maxim Why write? - clarifying your aims and objectives A seven-step method for better preparation The three-stage process for writing well Grouping information for your reader 4 Proof-reading and editing The difference between proof-reading and editing Proof-reading methods and strategies Proof-reading marks and techniques Training your eye for detail Knowing what to look for 5 Effective editing Grammar and English standards Words - usage and spelling Sentences - units of thought Paragraphs - themes Punctuation - spotting and correcting common errors Say what you mean - active v passive language 6 How's your English? Grammar quizzes and punctuation test Spotting spelling errors Rephrasing jargons and clichés Common error's and mistakes 7 Document layout House style Use of white space Fonts and effects 8 One-to-one workshops These are practical sessions with one-to-one consultation with colleagues and the trainer They are held at key points to consolidate the learning from different sessions 9 Course summary Summary of key points Action plans

Business writing skills (In-House)
Delivered in Harpenden or UK Wide or OnlineFlexible Dates
Price on Enquiry

Power BI - advanced (1 day) (In-House)

By The In House Training Company

This course starts with data transformation strategies, exploring capabilities in the Power Query Editor, and data-cleansing practices. It looks at the Advanced Query Editor to view the M language code. This course focuses on advanced DAX measures that include filtering conditions, with a deep dive into time intelligence measures. Like the M query language, DAX is a rich functional language that supports variables and expression references. This course also looks at the creation of dynamic dashboards and incorporates a range of visualisations available in Power BI Desktop and online in the AppSource. The course finishes with a look at setting up end user level security in tables. 1 The query editor Split by row delimiter AddDays to determine deadlines Advanced query editor 2 Fuzzy matching joins Matching inconsistencies by percentage Matching with transformation table 3 Logical column functions Logical functions IF, AND, OR Using multiple conditions Including FIND in functions 4 Editing DAX measures Make DAX easier to read Add comments to a measure Using quick measures 5 The anatomy of CALCULATE Understanding CALCULATE context filters Adding context to CALCULATE with FILTER Using CALCULATE with a threshold 6 The ALL measure Anatomy of ALL Create an ALL measure Using ALL as a filter Use ALL for percentage 7 DAX iterators Anatomy of iterators A closer look at SUMX Using RELATED in SUMX Create a RANKX RANKX with ALL 8 Date and time functions Overview of functions Create a DATEDIFF function 9 Time intelligent measures Compare historical monthly data Create a DATEADD measure Creating cumulative totals Creating cumulative measures Visualising cumulative totals 10 Visualisations in-depth Utilising report themes Create a heatmap Comparing proportions View trends with sparklines Group numbers using bins Setting up a histogram 11 Comparing variables Visualising trendlines as KPI Forecasting with trendlines Creating a scatter plot Creating dynamic labels Customised visualisation tooltips Export reports to SharePoint 12 User level security Setting up row level security Testing user security

Power BI - advanced (1 day) (In-House)
Delivered in Harpenden or UK Wide or OnlineFlexible Dates
Price on Enquiry

Power BI - intermediate (2 day) (In-House)

By The In House Training Company

This course is designed for those already using Power BI Desktop and are ready to work with more comprehensive elements of analysing and reporting in Power BI. The course maintains a balanced look at data analysis including the Power Query Editor, with a deep dive into writing DAX formulas, and enhanced dashboard visualisations. The aim of this course is to provide a more complete understanding of the whole Power BI analytics process, by working with business examples that will equip you with the necessary skills to output comprehensive reports and explore Power BI's analytical capabilities in more depth. 1 The Query Editor Grouping rows in a table Split row by delimiter Add days to determine deadlines The query editor 2 Fuzzy Matching Joins Matching inconsistencies by percentage Matching with transformation table 3 The Query Editor M Functions Adding custom columns Creating an IF function Nested AND logics in an IF function 4 DAX New Columns Functions Including TRUE with SWITCH Using multiple conditions The FIND DAX function The IF DAX function Logical functions IF, AND, OR 5 Editing DAX Measures Making DAX easier to read Add comments to a measure Using quick measures 6 The Anatomy of CALCULATE Understanding CALCULATE filters Add context to CALCULATE with FILTER Using CALCULATE with a threshold 7 The ALL Measure Anatomy of ALL Create an ALL measure Using ALL as a filter Use ALL for percentages 8 DAX Iterators Anatomy of iterators A closer look at SUMX Using RELATED with SUMX Create a RANKX RANKX with ALL 9 Date and Time Functions Overview of functions Create a DATEDIFF function 10 Time Intelligent Measures Compare historical monthly data Create a DATEADD measure Creating cumulative totals Creating cumulative measures Visualising cumulative totals 11 Visualisations In-Depth Utilising report themes Applying static filters Group data using lists Group numbers using bins Creating heatmaps Comparing proportions View trends with sparklines 12 Comparing Variables Visualising trendlines as KPI Forecasting with trendlines Creating a scatter plot Creating dynamic labels Customised visualisation tooltips Export reports to SharePoint

Power BI - intermediate (2 day) (In-House)
Delivered in Harpenden or UK Wide or OnlineFlexible Dates
Price on Enquiry

Environmental awareness and management (In-House)

By The In House Training Company

A flexible, modular-based, programme to heighten participants' awareness of ways in which their operations can affect the environment, the principles of environmental management and the practical steps they need to take as individuals and as an organisation to improve environmental performance. Depending on the course modules selected, this programme will give participants: Increased awareness of relevant environmental issues A greater understanding of, and commitment to, the organisation's environmental management programme Preparation for any responsibilities they may have under an Environmental Management System Further benefits according to options chosen 1 Environmental awareness Definition of 'the environment' Key environmental issuesGlobal warmingOzone depletionAcid rainAir qualityWater pollutionContaminated landLand take and green belt shrinkageResource usageHabitat destruction and species extinctions. Option: This module can be used to explain the key environmental issues related to the activities of your own organisation. Diagrams, photos, pictures, examples and statistics relevant to your own organisation are used where possible to illustrate the points being made. 2 Environmental legislation Key elements of environmental legislation affecting the activities of your organisation - including international, European and UK legislation. Legislation of particular relevance to your organisation - how it affects the operations of your organisation Option: Legislation can be dealt with according to which aspect of the environment it protects (eg, air, water, waste) or which part of your organisation's activities it affects Consequences of breaching legislation 3 Environmental management systems Overview of what an environmental management system isHow is an Environmental Management System (EMS) designed and put together?Key elements (emphasising Plan - Do - Check - Review cycle)The need to continually improve Pros and consReasons for having an EMSBenefits of an EMSConsequences of not managing the environmentCosts of installing an EMS Explanation of ISO 14001 and EMAS standards and guidance as applicable to the EMSs of your organisationOverview of your organisation's EMSHow it was set up / is being developed / operatesWho is responsible for itKey parts of system (eg, environmental policy, objectives and targets) identified and discussedEMS documentation - what and where it is. Workshop option: Brainstorm 'Pros and cons' with the participants, come up with all their ideas for good and bad things about EMS and demonstrate that the 'good' list is longer than the 'bad' 4 Environmental consequences Define what an environmental impact is and discuss how they are determined, with reference to the EMS Identify why we want to determine the environmental consequences of operations and activities; how they are used in the EMS for planning, and reducing the impact on the environment Establish key environmental consequences of construction and operational activities on the site; discuss significance ranking and the control measures in place in your organisation. Workshop option: In small groups, participants are asked to identify the impact on the environment of your organisation's activities or a part of their activities. They are then asked to rank these impacts in terms of their significance, using guidelines provided to help them be aware of the contributing factors (eg, frequency, severity). For a selected number of the impacts, the participants are asked to identify what control measures there are and which of these they play a part in. All stages can be discussed with trainers as a whole group at various stages during the workshop. 5 Protected species, nature conservation and invasive weeds Nature conservation, landscape and visual issues in the planning process - overview of key nature UK wildlife legislation, EIA, appropriate timing of surveys, Hedgerow regulations and landscape and visual impact issues Ecological issues - ecological legislation, significant species, hedgerows Archaeology in the development process - why archaeology is important, organisation in the UK, legislation and planning guidance Construction phase issues and consents - major environmental issues during construction, including water resources and land drainage consents, discharges to land or water, water abstraction, public rights of way, tree protection, waste management, Special waste, noise, good practice pollution control and Environmental Audits Identification and management of invasive weeds - including legal position regarding management 6 Chemicals and fuels handling and storage How health and safety management is closely linked to environmental management of materials Planning - what mechanisms are in place for planning materials use; legislation, guidance and policies which define how to manage materials Materials storage - what are the considerations for storing materials, covering:Labels: what are the different types and what do they tell us?Storage facilities: what are the requirements for safe storage of materials (eg, signs, secondary containment, access, segregation, lids/covers)Handling: safe handling for protecting the environment, organisational procedures, high risk situations (eg, decanting, deliveries), how to reduce the risks (eg, use of funnels, proper supervision, training)COSHH and MSDS: brief explanation of legislation and its role in environmental control of hazardous materials, how to use the information provided by COSHH assessments Option: These sessions can be illustrated with photographs/pictures and examples of good and bad storage and handling practices Workshop Options: Labelling Quiz - quick-fire quiz on what different labels tell us; Build a Storage Facility - participants are asked to consider all the environmental requirements for building a safe storage facility for their organisation 7 On-site control measures Overview of the legislation associated with nuisance issues on site and mitigating problems when they arise Examples of bad practice, including fuel storage tanks and mobile equipment - costs involved with prosecution of fuel spills, remediation costs, management costs, legal fees, bad PR coverage Identification and management of contaminated land and relevant legislation Workshop option: Participants are provided with a site plan containing information on site features, environmental conditions and indications of potential issues 8 Waste management Why worry about waste? - a look at how waste disposal can impact on the environment, illustrated by examples of waste-related incidents, statistics on waste production on national, industry-wide and organisational levels, landfill site space, etc Legislation - overview of the relevant legislation, what the main requirements of the regulations are, what penalties there are, and the associated documentation (waste transfer notes) Waste classification - a more in-depth look at how waste is classified under legislation according to hazardous properties, referring to Environment Agency guidance Handling and storage requirements - what are the requirements of the applicable waste legislation and how are they covered by organisational procedures? Examples of good and bad environmental practice associated with handling and storing waste. Workshop option: 'Brown bag' exercise - participants pass round a bag containing tags each with a different waste printed on. They are asked to pick out a tag and identify the classification and the handling, storage and disposal requirements for the waste they select Waste minimisation - overview of the waste minimisation 'ladder' and its different options (elimination, reduction, reuse and recycling), benefits of waste minimisation, examples of waste minimisation techniques Workshop option: Participants are asked to identify opportunities that actually exist within the organisation for minimising production of waste that are not currently being taken advantage of 9 Auditing Requirements for environmental auditing of operations Auditing the EMS Types of internal and external audits Requirements EMS standards (ISO 14001 and EMAS) Carrying out internal audits and being prepared for external audits Workshop options:Mock audit 'Brown Bag' - can be used either for trainers to test participants as if they were in an audit situation, or for the participants to test each other and practice their auditing technique. The bag contains tags each with a different topic printed on (eg, waste skips); participants pass the bag round and select a tag; they are then questioned by the trainer or another participant about that topic as if they were in an audit situation. If the participants are auditing each other, they will be provided with a set of guidelines to keep in mind during the workshop.Virtual auditing - a more practical workshop where participants review photographs of situations/activities relevant to the organisation's operations. They are asked to identify all the good and bad environmental practices that are occurring in the situations. 10 Incident response What should you do when an incident does happen? What should be in a spill kit? When should you call in the experts? When should you inform the Environment Agency or Environmental Health Officer? Workshop option: The participants are provided with some incident scenarios and asked to develop a response to the incident 11 Monitoring and reporting Environmental monitoring programmes and procedures Monitoring and reporting as control measures for environmental consequences Monitoring and environmental 'STOP' card systems - personal and behavioural monitoring and reporting

Environmental awareness and management (In-House)
Delivered in Harpenden or UK Wide or OnlineFlexible Dates
Price on Enquiry

Body Piercing Training Course 1 or 2 Days-choose your own dates .

By Sassthetics Training Academy

One -2- One Body Piercing Training Course . 1 or 2 days depending on the level of mentorship you require. Blackpool based

Body Piercing Training Course 1 or 2 Days-choose your own dates .
Delivered In-Person in Blackpool or UK WideFlexible Dates
FREE