966 Business courses in Leatherhead

There is a lot to learn in Power BI, this course takes a comprehensive look at the fundamentals of analysing data and includes a 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 utilise the online Power BI service. It looks at authoring tools that enable you to connect to and transform data from a variety of sources, allowing you to produce detailed reports through a range of visualisations, in an interactive and dynamic way. It also includes a detailed look at formulas by writing both M functions in Power Query, and DAX functions in Desktop view. This knowledge will allow you to take your reports to the next level. The aim of this course is to provide a complete introduction to understanding the Power BI analysis process, by working hands-on with examples that will equip you with the necessary skills to start applying your learning straight away. 1 Getting Started The Power BI ecosystem Opening Power BI Desktop Power BI's four views Introduction to Dashboards 2 Importing Files Importing data sources Importing an Excel file Importing a CSV file Importing a database Connect to an SQL Server Database Import vs. Direct Query Importing from the web Importing a folder of files Managing file connections 3 Shape Data in the Query Editor The process of shaping data Managing data types Keeping and removing rows Add a custom column Appending tables together Hiding queries in reports Fixing error issues Basic maths operations 4 The Data Model Table relationships Relationship properties 5 Merge Queries Table join kinds Merging tables 6 Inserting Dashboard Visuals Things to keep in mind Inserting maps Formatting Maps Inserting charts Formatting Charts Inserting a tree map Inserting a table, matrix, and card Controlling number formats About report themes Highlighting key points Filter reports with slicers Sync slicers across dashboards Custom web visuals 7 Publish and share Reports Publishing to Power BI service Editing online reports Pinning visuals to a dashboard What is Q&A? Sharing dashboards Exporting reports to PowerPoint Exporting reports as PDF files 8 The Power Query Editor Fill data up and down Split column by delimiter Add a conditional column More custom columns Merging columns 9 The M Functions Inserting text functions Insert an IF function Create a query group 10 Pivoting Tables Pivot a table Pivot and append tables Pivot but don't aggregate Unpivot tables Append mismatched headers 11 Data Modelling Expanded Understanding relationships Mark a date table 12 DAX New Columns New columns and measures New column calculations Insert a SWITCH function 13 Introduction to DAX Measures Common measure functions Insert a SUM function Insert a COUNTROWS function Insert a DISTINCTCOUNT function Insert a DIVIDE function DAX rules 14 The CALCULATE Measure The syntax of CALCULATE Insert a CALCULATE function Control field summarisation Things of note 15 The SUMX measure X iterator functions Anatomy of SUMX Insert a SUMX function When to use X functions 16 Time Intelligence Measures Importance of a calendar table Insert a TOTALYTD function Change financial year end date Comparing historical data Insert a DATEADD function 17 Hierarchies and Groups Mine data using hierarchies Compare data in groups

NPORS Cat And Genny Training or Cable Avoidance Training Prioritising the safety of underground utilities in construction and excavation projects is essential, necessitating comprehensive Cat and Genny training. In these sessions, workers receive education on operating Cable Avoidance Tools (CAT) and Signal Generators (Genny), Cat and Genny. The Cat and Genny use electromagnetic signals to detect buried cables and pipes before digging commences. Through comprehensive Cat and Genny training, workers become proficient in using CAT and Genny equipment, enabling them to accurately map out the locations of underground infrastructure. This proactive approach not only enhances on-site safety but also contributes to efficient project management by minimising the risk of accidental damage and costly delays. The aim of the NPORS Cat & Genny Training is to Provide training in Cable Avoidance and Service Location (Cat and Genny).The Cat and Genny Course is designed for any person working on the roads, setting out before a build, surveying and any others who may be excavating an area where pipes or cables may be buried underground. Price Match Promise Book with Confidence at Vally Plant Training At Vally Plant Training, we guarantee unbeatable value with our Price Match Promise. When you choose us for your Cat and Genny Course, you can book with confidence, knowing that we will not be beaten on price. If you find a lower price for the same NPORS Cat And Genny Course, we’ll match it—ensuring you receive top-quality training at the best possible rate. Your skills, our commitment—always at the best price. CAT & GENNY Training is designed for construction professionals and workers involved in excavation who need to operate Cable Avoidance Tools and Signal Generators. This training is ideal for individuals who have prior experience in excavation but require formal instruction on the safe and effective use of these specific tools to prevent accidental damage to underground services. Participants should have a basic understanding of excavation work, and if unsure of their eligibility for this advanced training, are encouraged to contact our training coordinators for more information. The CAT & GENNY training program is divided into two main sections: a theoretical module and a practical application module. The theory part covers the principles of operation, safety procedures, and risk assessment associated with underground utility detection. The practical module provides hands-on experience with both the Cable Avoidance Tool and Signal Generator, emphasising field techniques and problem-solving. Upon completion of the Cat And Genny course, participants will receive comprehensive revision materials to reinforce key concepts covered during the training. Introduction to CAT and Genny Training CAT and Genny , also referred to as CAT & Genny or CAT and Genny Training, are essential tools used in the construction and utility sectors to help locate and avoid underground cables and pipes during excavation works. CAT, which stands for Cable Avoidance Tool, is designed to detect signals naturally emitted by metallic services like electrical cables. Meanwhile, the Genny, short for Signal Generator, is used alongside the CAT to apply a signal to underground utilities that do not naturally emit detectable signals, such as telecoms or fibre . Understanding how to operate these tools is crucial for anyone involved in excavation. Proper use of CAT and Genny can prevent costly and dangerous errors, such as accidentally cutting through power lines or water pipes. The training not only focuses on how to use these devices effectively but also covers the best practices for scanning different types of terrain and interpreting the signals received. This ensures that workers can conduct their tasks safely and efficiently, minimising the risk of disruption and damage to underground services. What Is CAT and Genny Training? CAT and Genny Training provides comprehensive instruction on using Cable Avoidance Tools (CAT) and Signal Generators (Genny) to locate underground utilities safely. This training is critical to reduce the risk of accidentally striking underground assets during excavation, which can lead to severe safety hazards and financial losses. What Does Our CAT and Genny Training Course Cover? Our CAT and Genny Training Course covers: Basics of operating CAT and Genny equipment: Understanding the device controls, functions, and proper handling. Detection techniques: Learning how to detect different types of services, including electric, gas, and water. Practical applications: Hands-on training with both simulated and live environments to practice safe scanning and detection. Safety protocols: Emphasising safety procedures to prevent injuries and accidents. Legal compliance: Overview of health and safety regulations related to excavation work. Who Needs CAT and Genny Training? CAT and Genny Training is essential for anyone involved in excavation and groundworks. This includes utility workers, construction workers, civil engineers, site managers, and anyone else who may need to locate underground utilities as part of their job. The Cat And Genny Course is crucial for preventing damage to underground infrastructure like gas, water, telecoms and electrical lines, which can result in costly repairs and dangerous accidents. Do You Need to Be Trained to Use a CAT Scanner? Yes, training is highly recommended to use a CAT scanner effectively and safely. While not legally mandatory, proper training ensures that operators can accurately interpret the scanner’s signals and avoid potential hazards when working near underground utilities. Specialised Genny Tool Training Course Overview: The Genny Course is designed specifically to train users on the effective operation of the Genny tool, a crucial component of the CAT and Genny system used for detecting underground utilities. Key Learning Outcomes: → Understanding Genny Signals: Participants will learn how different signals can be applied and traced using the Genny, improving their ability to detect non-metallic utilities such as plastic water pipes. → Optimising Signal Strength: Training includes adjusting the Genny’s signal strength to suit various soil conditions and utility types, ensuring clearer and more accurate detections. Practical Applications: → Hands-on Practice: Extensive field practice sessions are included to give participants real-world experience in using the Genny effectively. →Troubleshooting Common Issues: Learners will be taught how to troubleshoot common operational issues to minimise downtime and enhance field productivity. Advanced Techniques: → Using Genny with CAT4: Instructions on how to integrate Genny use with the CAT4 detector for enhanced detection capabilities. → Interpreting and Mapping: Skills in interpreting the Genny’s output and using integrated mapping tools for accurate utility mapping. Safety Protocols: → Safe Operation Practices: Emphasis on safety measures to prevent accidents during the use of high-frequency signals. → Maintenance and Daily Checks: Training on regular maintenance routines and daily checks to keep the Genny in optimal working condition. Certification: → Qualification and Certification: Upon completion of the course, participants receive a certification that validates their proficiency in using the Genny tool according to industry standards. Scanning Techniques with CAT and Genny General Scanning Techniques: → Sweeping Motion: Always use a slow, steady sweeping motion with the CAT device. Begin scanning at least a few meters away from the expected area of the utilities to avoid missing any signals. → Directional Scans: Perform scans in multiple directions — both parallel and perpendicular to the expected direction of the utility lines to ensure thorough coverage. → Depth Perception: Adjust the depth settings based on preliminary scans to get an accurate depth estimate of buried utilities. Specific Use of Genny: → Direct Connection: When available, use the direct connection method with the Genny to induce a precise signal into a specific utility line. This is particularly useful in crowded areas with multiple utility lines. → Induction Mode: Use the Genny’s induction mode when direct connections are not possible. Ensure the Genny is placed on the ground vertically for optimal signal transmission. How to Use the CAT and Genny to Find Hidden Wires and Pipes Getting Ready: Check the Tools: Make sure the CAT and Genny are ready to use and have full batteries. Set Up the Genny: Pick the right sound for the Genny to use so it can find wires or pipes under the ground. If you can, connect the Genny to the pipe or wire with a special wire. Using the Genny: Stand it on the Ground: Put the Genny on the ground where you think there might be something hidden. Turn it on to send a beep into the ground. Connect it for Better Finding: Sometimes, you connect the Genny to something like a pipe for a clearer beep. Using the CAT: Start with Power Mode: Turn on the CAT and use the power mode to find beeps from wires that are on. Try Radio Mode: Next, switch to radio mode to hear beeps from metal things like pipes. Finally, Use Genny Signal Mode: Use this mode to hear the special beeps from your Genny to find hidden stuff like plastic pipes. How to Look Properly: Move Slowly: Walk slowly with the CAT over the area. If you move too fast, you might miss some beeps. Check in a Cross Pattern: First walk in one direction and then the other direction to make sure you cover all the area. Understanding What You Hear: Listen to the Beeps: A loud beep means you are close to a wire or pipe. If the beep sounds the same as you move, it probably means you found a wire or pipe. Staying Safe: Look Before You Dig: Always check by looking in the hole to make sure what the CAT and Genny found before you start digging. Keep the Tools Working Well: Make sure your tools are working right by checking them often. 500 mm from utilities; Always use insulated digging tools when close to underground utilities Frequently Asked Questions On Cat & Genny Training What is CAT and Genny training? CAT and Genny training provides instruction on how to use Cable Avoidance Tools (CAT) and Signal Generators (Genny) effectively to detect underground utilities and avoid accidental strikes during excavation. The training covers operational techniques, safety procedures, and the correct interpretation of the equipment’s signals. Why is CAT and Genny training important for construction workers? This Cat And Genny Course is crucial for safety and efficiency on construction sites. It helps workers avoid costly damages to underground utilities such as water pipes, electricity cables, and communication lines, which can lead to severe consequences including service outages, legal liabilities, and endangerment of worker and public safety. 3. How Long Is the Certification Valid? The certification received after completing CAT and Genny Training is generally valid for three to five years. After this period, a refresher course is recommended to keep up with new technologies and changing safety regulations. 4. Is CAT and Genny training required by law in the UK? While not specifically mandated by law, CAT and Genny training is strongly recommended under the UK Health and Safety Executive guidelines (HSE) to meet the legal duties under the Health and Safety at Work Act. It is considered best practice for anyone involved in excavation works. Cat & Genny 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 cable avoidance 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 practical training area to simulate an actual working environment for the cat & genny course. Our Cable Avoidance training and test packages are priced to be competitive. Discounts are available for multiple bookings We can send a fully qualified NPORS cat & genny Tester to your site nationwide, to reduce the amount of time away from work 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.

Understand the needs and benefits arising from a structured project risk management approach, the process and supporting methods for identifying analysing and responding to risks. Course overview Duration: 2 day (13 hours) Our Project Risk Management course addresses risk management throughout the project lifecycle. This course is designed for project staff, including project leaders, sponsors, project team members, support staff and functional staff involved in project activity. The workshop is especially suited to teams working on bids, feasibility and project start up. The workshop covers the need and benefits arising from a structured project risk management approach, the process and supporting methods for identifying analysing and responding to risks, human behavioural factors affecting risk management performance, and organisational interfaces and governance requirements. Objectives  By the end of the course you will be able to: Describe success factors and benefits arising from effective risk management Explain human behaviour factors affecting risk management Establish the project context and conduct an initial risk assessment Define an appropriate strategy and produce a risk management plan Define risk identification strategies and apply appropriate identification methods Identify and record important risk information including ownership Establish risk probability and impact levels; produce probability impact charts and severity time charts Establish exposure levels and contingency requirements Explain the principles of quantitative analysis Define and evaluate response options Implement effective risk management process control Content Principles of risk management Terminology Purpose Success factors Benefits and overall process Human factors that impact on risk management Initiate Analyse and determine context factors relevant to risk management Develop a robust risk management strategy for the life of the project How to conduct an initial risk assessment and define an outline strategy Identification Development of a risk identification strategy Appropriate methods and their strengths and weaknesse Determine an appropriate strategy and identify risks in a given case study Animating text Slide titles Bullet points Applying animation to Slide Master Assessment Methods commonly used for assessing and prioritising risks Evaluating exposure and contingency requirement Demonstration of quantitative methods and exercises to assess risks and contingency levels Planning and implementing responses Appropriate methods for responding to risks Defining implementation and control plans Assigning ownership Defining appropriate plans Conducting net benefits analysis and examining effectiveness Manage process Organisational interfaces and specific requirements to ensure appropriate controls Improvements and compliance with governance requirements

Learn how create and structure enterprise projects and programmes. Course overview Duration: 2 days (13 hours) Our P6 Project Planning and Controls Fundamentals course is an intensive two day course aimed at experienced planners and project controllers who need to use Primavera to create and manage detailed plans. It includes creating EPS levels, projects, WBS levels and detailed activity and resource planning. Experience of project planning and scheduling techniques is essential. Objectives  By the end of the course you will be able to: Create a programme structure Create projects and set project properties Create programme milestones Create a Work Breakdown Structure (WBS) Create detailed plans including activities, links and resources Progress the schedule Manage actuals Customise layouts Use the reporting tools in Primavera Content Programme Management Creating EPS elements Defining the programme structure Navigating the EPS structure Finding programmes Project Management and WBS Creating projects Setting project properties Validating projects Assigning project codes Building a work breakdown structure Creating a WBS structure Creating WBS elements Work package management Top Down budgets Allocating top down budgets Budget change Programming milestones and activity planning Creating programme milestones Setting constraints Linking milestones Scheduling Using the schedule function Detailed activity planning Creating activities Relationship types Creating relationships Adding milestones Assigning activity codes Resourcing, workloads and baselining Resource types Creating resources Resource attributes Assigning resources Switching resources Split load resource assignment Reduced hours resource assignment Checking workload Reviewing workload Dealing with resource conflicts Assignments view Baselining Creating baselines Assigning baselines Working with layouts Creating layouts Customising columns Setting filters Sorting and grouping Changing the timescale Customising the Gantt Creating activity code breakdown structures Progressing the schedules Updating task status and remaining duration Setting the data date Monitoring and reporting Exporting and importing information Primavera standard reports Creating custom reports Creating portfolios Printing Printing your schedule Printing to other packages

Learn how to use Master Projects and Resource Pools to create better visibility across projects. Course overview Duration: 4 hours This course shows you how to create Master Projects allowing you to roll several sub projects into a master view. It also shows techniques to create resource pools to share resources between projects to enable you to better manage your resource teams and check resource loading. This half day course looks at how to practically do this and setup both elements. This is aimed at existing users of Microsoft Project who need to create master schedules and share resources and loadings. Objectives  By the end of the course you will be able to: Create master projects Insert and update sub projects Create a resource pool Share resources between projects Check resource loadings between projects Content Working with multiple projects Consolidating projects Linking to sub projects Setting the master project as read only Saving consolidated projects Working on consolidated projects Setting task links between projects Getting source project information Removing projects from the consolidation Sharing resources Creating a resource pool Sharing resources Opening projects that share resources Updating the resource pool Refreshing the resource pool Opening a resource pool Removing resource sharing

Learn how to use Microsoft Project to create and resource robust project plans and how to maintain and track throughout the project lifecycle. Course overview Duration: 1 day (6.5 hours) Our Project Planning and Control course gives you the essential skills to use Microsoft Project to build, resource and monitor project schedules. It looks at initial setup, building plans, using a work breakdown structure and managing resources through to baselining and progressing your schedule. This course is designed for new or existing users of Microsoft Project, and no previous experience of Project is required. Knowledge of planning techniques would be an advantage. Objectives  By the end of the course you will be able to: Create project schedules Build a Work Breakdown Structure Create relationships Set baselines Manage resources Set deadlines and task properties Print and report on your project Update and track project schedules Content Creating a new project Project defaults Project start date Setting default hours per day/week Setting daily working times Project timeline Building a project Creating a work breakdown structure Adding tasks and durations Estimated durations Setting milestones Recurring tasks Linking, Baselining and Resourcing Setting start dates and dependencies Task Inspector Resourcing Assigning resources Filtering available resources Baseline Setting a baseline Removing a baseline Managing resources Resource properties Dealing with over allocations Tasking information Constraint dates Setting deadline Assigning task specific calendars Task types Updating your project Completing work Completing work per resource Updating tasks Updating the project Rescheduling work Change highlighting Printing and reporting Setup and Printing Visual reports Using the Timeline Creating Dashboard reports

Use the features in project to report effectively on your plans. Course overview Duration: 4 hours Our Project – Reporting course is aimed at experienced users of Project who need to create reports in their project plans. It looks at using the different types of report in Project, exporting data to other packages, building new reports and sharing reports between projects. Experience of using Project to create and resource plans is required. Objectives  By the end of the course you will be able to: Print and PDF data from your project Use timelines Setup filters and groups Import and export data Create and share dashboard reports Content Printing and reporting Setup and Printing Creating PDFs Visual reports Using the Timeline Filtering and grouping Applying filters Applying grouping Creating your own filters and groups Importing and exporting data Importing data into Project Exporting data Creating and saving data maps Dashboard reports Using dashboard reports Creating dashboard reports Adding widgets Customising data shown

Look at some of the more advanced planning features available in Project. Course overview Duration: 1 day (6.5 hours) Our Project – Advanced Planning and Control course looks at advanced planning and resourcing techniques in Microsoft Project and how to customise your schedule to give better visibility and flexibility. The course is designed for experienced users of Project who have attended our Project Planning and Control introduction course or have equivalent knowledge. You must be confident using Project to build and resource schedules and create task dependencies. Objectives  By the end of the course you will be able to: Work with different types of task Amend resource load on a task Work with multiple resource rates Create custom tables Add custom fields Create calculated fields Add drop down lists in fields Filter and extract information Create new views Export information Content Advanced planning techniques Splitting tasks Task types Spreading work across activities Advanced resourcing techniques Resource types Assignment views Effective dates Work contours Overtime work Using multiple resource rates Creating custom tables Customising tables Adding fields Creating custom fields Adding text, number, date and time fields Using flag fields Defining pick lists Renaming custom fields Creating calculated fields Creating formulas Using graphical indicators Uploading and tracking progress Completing work Completing work per resource Updating tasks Updating the project Working with the status date Rescheduling work Viewing baseline against schedule Project overview statistics Working with filters Building standard filters Building interactive filters Task and resource filters Using highlight filters Creating custom views Creating customised views Customising text styles Using grouping techniques Exporting information Exporting to Excel

Some people naturally possess an ability to sell and others over time develop their own style. We have created a highly practical course to give you the confidence and ability to sell over the phone or face to face. We focus the exercises, theory and discussion on your own job role and experiences to ensure you can return to the workplace to deliver tangible results. This 2-day course is designed for individuals who are new to selling, those in a sales role but have not received any formal training, or professionals who would like to brush up and enhance their current selling skills and learn some new techniques. Course Syllabus The syllabus of the Essential Selling Skills course is comprised of seven modules, covering the following: Module One Understanding the Customer The importance of good customer care Selling vs. selling attitude The reasons people buy Adopting a positive approach Module Two Self-Awareness Understanding your selling style Adapting your selling style to your customer Understanding your customers buying style Module Three Effective Communication and Rapport Building Why does communication need to be effective? Actively listening to your customers' needs Right question at the right time The impact of positive and emotive language Module Four Taking a Consultative Approach Different styles of selling Taking a consultative approach to selling Preparation techniques Buyer behaviour and motivation A selling approach to match the buyers mind Module Five Presenting the Solution Selling the benefits Sales tool kit Unique sales points Advanced questioning techniques Module Six Gaining Commitment Recognising and acting upon buying signals Dealing with customers concerns No means no? How to cope in stressful situations Module Seven Confirming the Sale Confirming or closing? Effective confirming techniques Going the extra mile Benefits For you as an individual This course will increase your confidence and ability to sell, having provided you with tools and techniques to achieve maximum results. Delegates always leave with fresh ideas, energy and motivation to succeed. For an employer The attitude of the delegates and the results they deliver will speak for themselves. All techniques are easy to apply back into the workplace for an immediate impact. What will I learn? By the end of the course, participants will be able to: Appreciate the need for preparation before a sales appointment Effectively identify and meet needs with advanced questioning techniques Identify verbal and non-verbal buying signals Construct professional answers to questions and possible objections Present your products and/or services with the buyer in mind Identify and use a selling style appropriate to capture the buyer's attention Recognise and overcome major objection types How to apply effective confirmation techniques with the buyer in mind Real Play Option We offer an innovative solution to engage the learners and bring real negotiation and closing scenarios to life. We use actors who improvise scenarios which have been specified by the group. The group is split the group into 2 sub-groups, one with the actor, the other with the trainer. Each group has a brief and has to instruct their trainer/actor on how to approach the scenario supplied. The actor and trainer perform the role play(s) as instructed by their respective teams; however during the action they can be paused for further recommendations or direction. The outcome is the responsibility of the team(s) - not the performers. Scheduled Courses This course is not one that is currently scheduled as an open course, and is only available on an in-house basis. For more information please contact us.

Discover how disposable vapes like the Flavour Beast DCP 20K can assist you in quitting smoking. Explore benefits such as controlled nicotine intake, reduced harmful chemicals, and the convenience of shopping at a Canadian vape shop online.