913 Business courses in Northampton

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

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

RSPH level 2 Identifying and Controlling Food Allergy Risks Training Course Do you need an allergy trainer to come to your food business and teach your staff face to face about food and drink allergens, their dangers and how to control them? Our allergy trainer can come to your business and deliver this course at your business premises. Although we are based in London, we are happy to travel and deliver this course at your business location. (Trainer travel fees may be applicable depending on your location). Staff will receive interactive training and coaching on allergens and intolerances with an experienced trainer. We can also tweak the training to include issues you would like to cover. See our website for more details. Special offer for on-site allergy training. £250 plus £20pp includes RSPH exam fees (usually £350 plus £30pp) This course is suitable for any catering business such as restaurants, pubs, hotels, cafes, catering companies, cooks, self employed, artisans, event caterers and more. This course is also important for staff who are Front of House, who take customer orders and relay the orders to cooks and chefs and other people who are preparing food for customers who have allergies and or intolerances. This is a short one day training course, typically 9am-3pm. Topics covered include- Allergens, Allergen Identification, Cross contact, Cross Contamination, Allergic Reactions, Food Intolerances, Coeliac, Anaphylaxis, Natasha's Law, UK Food Safety Regulations, Allergy Controls, Substituting ingredients, Customer Communication and what to do in an Emergency. Contact us to book training.

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.

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.

Belonging & Connection

HACCP Trainer. on site delivery nationwide

HACCP Trainer and HACCP Training Courses

Overview The objective of this course is to equip professionals with comprehensive knowledge and practical skills in WEB 3 technologies and crypto assets. Participants will gain a deep understanding of the underlying principles of blockchain, the operational mechanics of cryptocurrencies, the potential impact of these technologies on the banking sector and the latest trends. Who the course is for Consultants Analysts Managers C-Level executives People in need of knowledge to develop a blockchain strategy People working with blockchain projects Regulators Course Content To learn more about the day by day course content please request a brochure To learn more about schedule, pricing & delivery options, book a meeting with a course specialist now

Learn the basics of Data Science, combining a supported #CISCO Skills for All online course with practical learning and a project to help consolidate the learning.