1804 Courses in Coventry

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

This course is suitable for everybody although it has been specifically designed to help employers to provide a positive mental health culture within their organisation. Learners will gain a comprehensive knowledge of a range of the most common mental health conditions and the skills of how to act.

NPORS Appointed Person Course or Training NPORS Appointed Person Lifting Operations Training is aimed at anyone who is required to plan safe systems of work using lifting equipment and to gain the NPORS Appointed Person operator card. The aim of the course is to provide candidates with underpinning knowledge to prepare them for the role and responsibility. It is recommended that prior to attending this course individuals should have some experience of working with lifting equipment, especially mobile cranes. It is important that all delegates have a good understanding of spoken and written English for the appointed person course. NPORS is an approved CSCS Partner Card Scheme, firstly providing evidence that individuals working on construction sites have the appropriate training and qualifications but more importantly for the safe operation of the appointed person. Furthermore, training criteria is based on the approved standards of the Construction leadership Council. Experienced Appointed Person Test For experienced Appointed Persons you must complete a 1 day refresher training course. For refresher training you must have held a certificate or card in the past Appointed Person Course Duration: Experienced Worker Test: 1 day refresher training, maximum of 6 candidates Novice: 5 day’s training, maximum of 6 candidates Location*: Tewkesbury or at our clients’ site nationwide Mileage and accommodation charges may apply Certification NPORS Traditional card – lasts for 5 years and is mainly accepted with housebuilders, utilities, port and marine as proof of competence OR NPORS card with CSCS logo – accepted by all major building contractor’s. The initial card is the RED trained operator card which lasts for 2 years and can be upgraded to BLUE competent operator card further to completion of relevant NVQ. CSCS Health & Safety Test If you require the NPORS Appointed Person Red operator card with the CSCS logo on then you must have completed the operatives health and safety test within the last two years. In house certificates: suitable as proof of operator competence accepted for insurance and HSE compliance. The Appointed Person Course Includes: This Appointed Person Course covers essential legislation, crane appreciation, lifting accessories, and planning lifting operations. It culminates in writing a risk assessment and method statement. Legislation LOLER, PUWER, HASAWA. Codes of practice BS7121. Roles and responsibilities of personnel involved with lifting operations. Crane appreciation, crane types, capabilities and limitations. Duty charts. Crane terminology. Documentation and certification for lifting equipment and lifting accessories. Crane stability/ground conditions. Safe Load Indicators (SLI) and Safe Working Loads (SWL). Lifting accessories. Types of accessories and use. Slinging techniques. Down rating of accessories. Sling angles. Communications. Planning a lifting operation. Writing a risk assessment (end test). Writing a method statement (end test). Appointed Person 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 lifting equipment 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 AP Course. Our Appointed Person training and test packages are priced to be competitive. Discounts are available for multiple bookings We can send a fully qualified NPORS Appointed Person Tester to your site nationwide, to reduce the amount of time away from work Frequently Asked Questions 1. What is the NPORS Appointed Person Lifting Operations Training? This training is designed for individuals required to plan safe systems of work using lifting equipment. It provides the knowledge necessary to prepare for the role and responsibilities of an Appointed Person. 2. Who should take this course? Anyone involved in planning and managing lifting operations, especially those with prior experience with lifting equipment, should take this course. 3. What does the course cover? The course covers legislation, codes of practice, roles and responsibilities, types of cranes, duty charts, lifting accessories, risk assessment, and method statement preparation. 4. How long is the course? The course duration is 5 days for novices and 1 day for experienced individuals seeking a refresher. 5. What certification do I receive upon completion? Participants receive an NPORS Appointed Person operator card, valid for 5 years or an NPORS card with CSCS logo. 6. Are there any prerequisites? Candidates should have a good understanding of English. For the NPORS card with CSCS logo, a CSCS Health & Safety test must have been completed within the last two years. 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.

This course aims to provide managers and supervisors with a thorough understanding of the different aspects of health and safety in the workplace. With a focus on the role of supervision, learners on this course will develop the essential knowledge and understanding to enable them to discharge their health and safety responsibilities and ensure the safety of their workplace colleagues. The programme has a particular focus on:

This one-day workshop is designed to enhance your PowerPoint skills to achieve dynamic presentations that work with you, making it easier to deliver a polished, professional presentation. You will learn advanced PowerPoint skills that will save you time and elevate your presentations. This course will help participants: Create custom shows to personalise presentations for individual clients Make the Slide Master work collectively with slide layouts and themes Seamlessly interact with external content using links Work with advanced animations and transitions, and video/audio tools 1 Themes and Masters Add a Design theme to a presentation Make changes to the Slide Master Delete layouts from the slide master Saving a slide master with themes as a template 2 Advanced graphics and diagrams Drawing, duplicating and resizing shapes Grouping, aligning and stacking shapes and graphics Using SmartArt for diagrams and organisation charts 3 Graphs and charts Inserting and formatting a chart Linking an Excel chart to a slide Linking Excel tables to a slide Animating charts 4 Video, Custom animation and Hyperlinks Adding and editing video Animating pictures and drawings Hyperlink to another Slide or Website Compressing and optimising media 5 Presenting Reuse slides Hide slides Rehearsing timings Enabling a presentation to run continuously

The Paediatric First aid course provides the comprehensive set of practical skills needed by first aiders in childcare settings. Giving both the ability and knowledge to deal with first aid emergencies and common childhood illnesses. It meets the standards required to help comply with Ofsted regulations.

Many organisations find that project teams struggle to create and maintain effective plans. Estimates are often overly optimistic and risks go unmanaged until the inevitable happens. Resource managers also find it hard to forecast the likely loading on their departments and requests for support are not provided in a consistent format. This programme has been developed to address these needs in a very practical, hands-on format. Case study work can be based on simulations or on the organisation's current projects for maximum benefit to participants. The aim of this training is to develop and enhance participants' planning and risk management skills in order to maximise the success of project work undertaken by the organisation. The principal training objectives for this programme are to: Provide a structured, integrated approach to planning and risk management Demonstrate practical tools and techniques for each stage of planning Show how to organise and involve relevant people in the planning process Explain how to use the plan for forecasting and pro-active project control Identify ways to improve planning, both individually and corporately The course will emphasise the importance of participative planning techniques that improve the quality of plans whilst reducing overall time and cost of planning. The course will encourage discussion of internal procedures and practices and may be customised to include them if required. DAY ONE 1 Introduction (Course sponsor) Why this programme has been developed Review of participants' needs and objectives 2 Projects and planning Why plan? The benefits of good planning / penalties of poor planning Planning in the project lifecycle; the need for a 'living' plan The interaction between target setting and the planning process Team exercise: planning the project 3 Planning the plan Defining the application and structure of the plan Impact of planning decisions during the project lifecycle Using available time to create an effective plan 4 Defining deliverables Assessing the context; reviewing the goals and stakeholders Developing the scope and defining deliverables; scope mapping Understanding customer priorities; delivering value for money Case study: defining the project deliverables 5 Creating the work breakdown Building the work breakdown structure Detailing the tasks and sub-tasks; structured brainstorming Defining task ownership; the task responsibility matrix 6 Creating and using a logical network Developing the logical network; task boarding Determining the critical path and calculating float Accelerating the plan; concurrent programming and risk Individual and group exercises DAY TWO 7 Developing resource schedules Deriving the Gantt chart from the network Developing the detailed resource schedules Calculating the expenditure profile ('S' curve) 8 Estimating task durations and costs Understanding estimates: effort, availability and duration Estimating tools and techniques Application of estimating techniques during the project lifecycle 9 Case study Developing the project plan Refining the project plan Team presentations and discussion 10 Managing risks and refining the plan Awareness of contractual issues associated with risk Identifying and evaluating risks; deciding ownership Managing risks: determining levels of provision and contingency Controlling risks: maintaining an up-to date risk register 11 Planning for pro-active control The earned value analysis (EVA) concept and its predictive value Deriving the measures needed for cost and delivery performance Practical issues associated with implementing EVA 12 Using and maintaining the plan Tracking progress and updating the plan Publishing and controlling the plan 13 Course review and transfer planning (Course sponsor present) Identify ways of implementing the techniques learnt Sponsor-led review and discussion of proposals Conclusion

The CIEH Foundation Certificate in Occupational Health and Safety supports businesses in their legal obligations to ensure employees are protected from harm. This course is ideal for those who want to develop their knowledge of health and safety issues in the workplace and of the regulations for maintaining a healthy and safe working environment. This course will focus on common hazards and how to control them. It will help you work more safely and be more aware of how your own actions can affect the health and safety of others.

One of our greatest strengths is our ability to tailor any of our open management courses to the needs and requirements of different businesses in different industries. We understand that whilst our open management training courses provide a wealth of knowledge in their particular area of focus, not all of it may be relevant for your business and the particular industry you operate in.Rather than making delegates sit through management training that is irrelevant to their job role, we offer bespoke management training where we tailor the course to cover the specific needs of your organisation, ultimately relieving the inevitable boredom and "switching off" that would come with having to sit through training that a person knew they would not need. Why choose us for your bespoke management training needs? We have provided tailored, bespoke management training courses to some of the largest organisations in the UK. Using our acquired experience and knowledge of running these courses, we will be able to work with you to create a bepoke management training programme that delivers a significant return on investment, both in terms of tangible and intangible results. ILM accredited management training courses Because we charge a daily training rate rather than a per delegate fee, if you have a number of delegates requiring management training, a bespoke management training course can often be less expensive than putting them all on an open course. A number of courses have been accredited by the ILM, which means you can be assured as to the standard of the course content and delivery. For more information on these, please see our page on ILM Management Training. All of our ILM Programmes are provided in partnership with BCF Group Limited, which is the ILM Approved Centre we deliver under. Interested in finding out more about bespoke management training? Between us, we can come up with a training plan which will provide relevant, bespoke management training for your delegates which will maximise the return on both your time and cost. We are happy to come to your premises or arrange training facilities nearer to your location if this would be more convenient. Feedback Below is a small selection of past feedback for our management training and development courses and programmes: "Excellent instructor. I looked forward to our monthly lectures knowing that I would have a good laugh but also that I would learn more about the subject and myself. He has been very helpful to me and the rest of the students, not just during the lectures but often in his own time. His enthusiasm for all of the subjects covered during the course was evident throughout, which again helped me to enjoy and understand the subjects and lectures.  If I get the chance in future to attend a further course with you, I would jump at the chance."Senior Acquisitions SurveyorGalliford Try "A very accomplished trainer and someone who I would very much like to be involved in our business training going forward. The feedback I have had from all levels of our team structure is excellent."Group HR OperationsEADS Personnel Services UK "Phil has a lot of energy which he throws into the course. This visably broke down resistance and attendees entered into the exercises wholeheartedly."Senior QSBullock Construction Scheduled Courses Unfortunately this course is not one that is currently scheduled as an open course, and is only available on an in-house basis. Please contact us for more information.

The Paediatric First aid course provides the comprehensive set of practical skills needed by people working in childcare settings. Giving both the ability and knowledge to deal with first aid emergencies.