1804 Courses in Coventry

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

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 follows the Institute of Occupational Safety and Health's syllabus. A one-day programme, it is suitable for all people at all levels in the workplace and gives a basic introduction to the principles of environmental management. On successful completion of the course, participants will be able to: Understand the terms 'environment' and 'pollution' Understand the terms 'hazard' and 'risk' related to the environment Better appreciate environmental issues generally, and specifically in respect of their organisation Identify hazards to the environment from working practices Outline the procedures/controls necessary to prevent damage to the environment 1 What is the environment? - putting the environment in context Key environmental issues and how we contribute Definition of the environment 2 Working with the environment What is pollution? Sources, receptors and pathways Environmental consequences workshop - identifying the environmental consequences of our working practices Environmental risk assessment Effective control mechanisms 3 Protecting the environment - Environmental Management Systems What is an Environmental Management System (EMS)? What are the benefits of having an EMS? EMS structure and models Identifying what elements of EMS your company has and how they work Roles and responsibilities 4 Choice of module Option 1: Organisation-specific moduleThis module can be used to introduce environmental concepts that are specific to your activities and operations, and will be compiled through discussion with your organisation Option 2: Environmental best practiceIf no organisation-specific module is required, or if participants from a number of organisations attend, generic operational environmental best practices can be covered instead. Areas covered include waste management, fuel storage and use, hazardous materials, emissions to air and water and environmental incidents

Any team member with Customer interaction (including internal) are the 'Ambassadors' of the company/organisation. If they project positive professionalism - they win others' confidence. If they appear or sound like they are in any way indifferent or unprofessional - they will cost sales and lose clients/customers. With this 2 day Training course, that will be tailored to your company/organisation, each person attending will upgrade their professional standards in people skills, telephone manner and email etiquette. No training in this area may well be a false economy as there is a much greater risk of disenfranchised customers and team members - and probably increases your competitors to win business at your expense. Professional customer care is all too frequently regarded as a token issue in most induction sessions for employees. Surprisingly it is very rarely considered as a key priority, despite being essential for ensuring customer commitment is secure and supplier/partnerships are robust. Excellent customer care is paramount in our ever increasingly competitive market and making customers feel valued and looked after is often a differentiator. This 2-day course will help you understand your customers and the vital importance of customer care in any organisation. You will gain the tools and techniques to apply your learning directly back into the workplace and deliver excellent customer care. Course Syllabus The syllabus of the Professional Customer Care course is comprised of four modules, covering the following: Module One What is Excellent Customer Care? Internal versus external customers Why customer care is important Meeting customer expectations Module Two Making a Personal Difference How do you measure customer care? Making a difference Taking ownership Positive mental attitude Displaying professionalism both face-to-face and over the telephone Using positive language Module Three Gathering Information and Offering Solutions Asking the right questions Active listening skills Summarising and clarifying skills Module Four Dealing with Difficult Situations How to give a 'service' no Demonstrating empathy Assertiveness techniques Handling a complaint Problem solving Saying 'sorry' Making realistic promises and keeping them Real Play Scenarios with a Professional Actor (Optional Extra) This programme benefits significantly from our innovative training feature: Real Play. Using a professional actor who performs role plays as different customer characters in carefully devised situations, the delegates have the opportunity to 'pause' the role play to coach and control their character to improve their skill sets and practice the theory delivered. These scenarios can deal with difficult situations and enacting options to ensure good customer relations are intact. The outcome of the scenario is the responsibility of the delegates, not the trainer and actor. The actor will remain in character throughout the de-brief in order to bring to life the impact and possible next steps. Objectives By the end of the course participants will be able to Adopt a professional telephone manner Communicate assertively by taking control and directing the conversation Deliver information positively by offering options and alternatives Develop a range of versatile behaviours to use when dealing with difficult situations by: Listening actively Using empathy Gathering relevant information through effective questioning Finding solutions to concerns/problems quickly and efficiently Speaking positively and assertively What Is The Benefit? For individuals this course will increase confidence and ability to deal with customers in all situations, which will in turn create customer loyalty and raise their profile. For an employer, ensuring that all customer facing employees are demonstrating excellent customer care instils confidence in the customers and promotes a positive image of the company. In-House Courses Every single team member or employee that has a role which involves engaging with a customer, client and/or a key partner/supplier has a responsibility for projecting a positive image of the organisation which they represent. That may sound obvious, but how many hundreds of experiences have you had as a customer where you were treated with indifference and a distinct lack of professionalism by the receptionist, the retail assistant, the tele-agent, the delivery person, the credit controller or the departmental manager of the operation that you were dealing with? Far too many to count? This is because professional customer care is regarded as a token issue in most induction sessions for employees - and it is very rarely considered as a key priority to ensure customer commitment is secure and supplier/partnerships are robust. Yet the hugely expensive churn in customer/client commitments and staff is enormously expensive and immensely disruptive to any organisation. The Importance of Customers and Clients Every client/customer engaging person needs to recognise that it is ultimately the client or customer that pays their wages. If they gain a basic understanding of the clients' motivations and behaviours, coupled with some core skills in how to care for them, they will attain the status of 'professional'. This will very quickly translate into increased revenues, retained loyalty, high commitment and far greater security for all parties. The foundation has to be based on the authentic commitment to both the customer and also to the organisation they work for. Disenfranchisement readily curdles into sloppy behaviours cloaked in unprofessional attitudes and demeanours; plenty there to repel the most loyal of customers. If your company or organisation relies on repeat business and retaining the confidence and commitment of your clients, then all of your team members - perhaps including managers who set the example and have the biggest influence on the where the needle points to in relation to professionalism - need to be trained on the core basics of professional customer care. Customer Care Programmes from Dickson Training Ltd We are delighted to boast about the many successes we have had in providing effective and long lasting improvements for many clients, where awards have been won and, more importantly, talent has been retained because their clients and customers keep on coming back. Professional customer care extends to suppliers and partners that you value and need to get the best service and rates from, as well as any 'internal clients' such as other departments where you need to rely on their support and collaboration in order to achieve your goals. It is amazing what effective professional customer care training can do for any organisation. Without it your organisation may be vulnerable, with it you are much more likely to see increased performances and much greater security and growth. 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.

A question of trust. Leadership implies followership. And that means trust. Because who's going to follow a leader they don't trust? This programme takes a values-driven approach to leadership. It gets current and aspiring leaders to hold up the mirror to themselves and to see their reflections as leaders of people. It asks them whether what they see justifies their view of themselves as leaders. It helps them understand just what it takes to be an effective leader. And it does so in a highly practical, constructive manner. It helps the course participants to truly understand the core skills of effective leadership. It focuses on the difference between leadership and management, defining what high performing teams do and how they do it. It helps people to see their teams from different perspectives, allowing them to adapt their styles to maximise team outputs. And it explores concepts such as emotional intelligence, authentic leadership and the RAIV approach (relationships-achievement-independence-vocation) to help explore underlying values and use them to drive effective leadership. Because what worth do our values have unless we put them into practice? The course will help you:• Appreciate the key skills a leader needs to be effective• Understand what the organisation expects of you as a leader• Recognise your leadership style and the impact it has on others• Consider your role models - who inspires you?• See leadership from the 'followers' perspective - how do you like to be led?• Discover what holds you back - limiting beliefs• Examine your core values -do they support your ambition?• Explore the concept of Emotional Intelligence - how do we manage ourselves?• Discover how to lead through change• Explore the concept of 'Authentic Leadership' - consider how it can work for you• Practice some of the skills essential to motivating and influencing for success• Use the RAIV approach to generating enthusiasm and commitment• Plan how best to 'walk the leadership talk' - in your role, in your organisation Above all, this course will help you put theory into practice, values into actions, in a mature, considered, effective way. Day 1 1 Welcome and introduction Participants are welcomed to the programme and invited to share their personal objectives and people challenges Participants given an action plan template to complete throughout the workshop Participants required to bring an inspirational quote to share with the group 2 What is leadership? The concept of 'leadership' The role of a leader Skills assessment for all participants# Leadership v Management Assess your team effectiveness 3 Your leadership style Leadership questionnaire You and your role models Push v Pull styles of leadership Empowerment v Control Team goals and role profiling Day 2 1 You, the leader Your core values Your communication style Situational leadership The Emotional Bank Account Buy Me Today 2 Are you Emotionally Intelligent? (EI) What is emotional intelligence? Self-assessment exercise Manage your emotions Nine strategies for promoting EI 3 Leading through change Identify the major changes affecting you / your team Types of change The roles of resistance How safe are you to talk to? Forcefield Analysis Day 3 1 Authentic Leadership (AL) What is AL? Managing perceptions is managing their truth A leadership challenge 2 Motivating and influencing for success What motivates you? Motivational theory Leading by example Influencing skills required Influencing styles The influence challenge! 3 Creating enthusiasm and commitment The RAIV approach (relationships-achievement-independence-vocation) Building self-worth What drives your team? Your leadership legacy Your commitment to leadership

Difficult Conversations

This one-day workshop is ideal for those looking to work with existing databases as well as creating a new Access database. You will learn effective ways to enter and extract data and convert data into a well-presented format for reports. This course will help participants: Plan and create a database Sort and filter records Use field data types Work with tables Create and manage a query Create and work with forms, and use the form wizard View, create and print reports 1 Access introduced Planning a database Creating a blank database Opening an existing database Security warnings The navigation pane Previewing database components Closing an Access database 2 Tables introduced Viewing and navigating table data Navigating using keyboard shortcuts Editing table data Adding records to tables Selecting and deleting records Finding and replacing data Filtering tables Summing table data 3 Queries introduced Opening a query in datasheet view Opening a query in design view Adding fields to a query Sorting query results Modifying datasheet view Saving and closing queries 4 Forms introduced Working with form data Sorting records Filtering records Working in design and layout views Changing object attributes 5 Reports introduced Opening and viewing reports Viewing a report in design view Previewing and printing report data Creating reports with auto report Creating reports with the report wizard Changing field attributes 6 Creating a new database Creating database tables Creating table fields Selecting field data types 7 Table relationships Introducing relationships Establishing table relationships The one-to-many relationship type Establishing referential integrity 8 Creating queries Streamline query criteria using wildcards Creating summary queries Creating queries based on criteria Running date queries Formatting field properties Building queries from multiple tables Summing in queries 9 Creating forms Creating a new form Inserting form fields Working with the property sheet The command button wizard The command button wizard Programming without typing Creating forms with embedded sub forms Creating forms with the sub form wizard Creating forms with the form wizard 10 Creating reports What are report bands? Managing report controls Basing reports on multiple tables Basing reports on queries Sorting and grouping records

The aim of this programme is to help attendees create better quality technical documents in an organised and efficient manner. It will give those new to the topic an appreciation of how to approach the task professionally whilst those with more experience will be able to refresh and refine their skills. The programme comprises three complementary one-day modules: The programme presents a structured methodology for creating technical documents and provides a range of practical techniques that help delegates put principles into practice. Although not essential, it is strongly advised that delegates for modules 2 and 3 have already attended module 1, or another equivalent course. Note: the content of each module as shown here is purely indicative and can be adapted to suit your particular requirements. This course will: Explain the qualities and benefits of well written technical documents Present a structured approach for producing technical documents Review the essential skills of effective technical writing Demonstrate practical methods to help create better documents Provide tools and techniques for specification and report writing Review how technical documents should be issued and controlled Note: the content of each module as shown here is purely indicative and can be adapted to suit your particular requirements. Module 1: Essential skills for technical writers 1 Introduction to the programme Aims and objectives of the module Introductions and interests of participants 2 Creating effective technical documents What is technical writing? how does it differ from other writing? Key qualities of an effective technical document Communication essentials and the challenges faced by technical writers The lessons of experience: how the best writers write The five key steps : prepare - organise - write - edit - release (POWER) 3 Preparing to write Defining the document aims and objectives; choosing the title Understanding technical readers and their needs Getting organised; planning and managing the process Integrating technical and commercial elements The role of intellectual property rights (IPR), eg, copyright 4 Organising the content The vital role of structure in technical documents Deciding what to include and how to organise the information Categorising information: introductory, key and supporting Tools and techniques for scoping and structuring the document Creating and using document templates - pro's and con's 5 Writing the document Avoiding 'blinding them with science': the qualities of clear writing Problem words and words that confuse; building and using a glossary Using sentence structure and punctuation to best effect Understanding the impact of style, format and appearance Avoiding common causes of ambiguity; being concise and ensuring clarity Using diagrams and other graphics; avoiding potential pitfalls 6 Editing and releasing the document Why editing is difficult; developing a personal editing strategy Some useful editing tools and techniques Key requirements for document issue and control Module 2: Creating better specifications 1 Introduction Aims and objectives of the day Introductions and interests of participants The 'POWER' writing process for specifications 2 Creating better specifications The role and characteristics of an effective specification Specifications and contracts; the legal role of specifications Deciding how to specify; understanding functional and design requirements Developing the specification design; applying the principles of BS 7373 Getting organised: the key stages in compiling an effective specification 3 Preparing to write a specification Defining the scope of the specification; deciding what to include and what not Scoping techniques: scope maps, check lists, structured brainstorming The why/what/how pyramid; establishing and understanding requirements Clarifying priorities; separating needs and desires: the MoSCoW method Useful quantitative techniques: cost benefit analysis, QFD, Pareto analysis Dealing with requirements that are difficult to quantify 4 Organising the content The role of structure in specifications Typical contents and layout for a specification What goes where: introductory, key and supporting sections Creating and using model forms: the sections and sub sections Detailed contents of each sub-section Exercise: applying the tools and techniques 5 Writing the specification Identifying and understanding the specification reader Key words: will, shall, must; building and using a glossary Writing performance targets that are clear and unambiguous Choosing and using graphics Exercise: writing a specification 6 Editing and releasing the document Key editing issues for specifications Issue and control of specifications Module 3: Writing better reports 1 Introduction Aims and objectives of the day Introductions and interests of participants The 'POWER' technical writing process for technical reports 2 Creating better reports What is a technical report? types and formats of report The role and characteristics of an effective technical report Understanding technical report readers and their needs The commercial role and impact of technical reports Getting organised: the key stages in compiling a technical report 3 Preparing to write reports Agreeing the terms of reference; defining aims and objectives Being clear about constraints; defining what is not to be included Legal aspects and intellectual property rights (IPR) for reports Preparing the ground; gathering information and reference documents Keeping track of information: note making, cataloguing and cross referencing Tools and techniques for developing a valid and convincing argument 4 Organising the content The role of structure reviewed; some typical report structures Who needs what: identifying the varied needs of the readership What goes where: introductory, key and supporting sections Creating and using model forms: the sections and sub sections Detailed contents of each sub-section Exercise: applying the tools and techniques 5 Writing the report Planning the storyline: the report as a journey in understanding Recognising assumptions about the reader; what they do and don't know Converting complex concepts into understandable statements Presenting technical data and its analysis; the role of graphics Presenting the case simply whilst maintaining technical integrity Exercise: writing a technical report 6 Editing and releasing the report Key editing issues for technical reports Issue and control of technical reports

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

Power BI is a powerful data visualisation program that allows businesses to monitor data, analyse trends, and make decisions. This course is designed to provide a solid understanding of the reporting side of Power BI, the dashboards, where administrators, and end users can interact with dynamic visuals that communicates information. This course focuses entirely on the creation and design of visualisations in dashboards, including a range of chart types, engaging maps, and different types of tables. Designing dashboards with KPI's (key performance indicators), heatmaps, flowcharts, sparklines, and compare multiple variables with trendlines. This one-day programme focuses entirely on creating dashboards, by using the many visualisation tools available in Power BI. You will learn to build dynamic, user-friendly interfaces in both Power BI Desktop and Power BI Service. 1 Introduction Power BI ecosystem Things to keep in mind Selecting dashboard colours Importing visuals into Power BI Data sources for your analysis Joining tables in Power BI 2 Working with data Utilising a report theme Table visuals Matrix visuals Drilling into hierarchies Applying static filters Group numbers with lists Group numbers with bins 3 Creating visuals Heatmaps in Power BI Visualising time-intelligence trends Ranking categorical totals Comparing proportions View trends with sparklines 4 Comparing variables Insert key performance indicators (KPI) Visualising trendlines as KPI Forecasting with trendlines Visualising flows with Sankey diagrams Creating a scatter plot 5 Mapping options Map visuals Using a filled map Mapping with latitude and longitude Mapping with ArcGIS or ESRI 6 Creating dashboards High-level dashboard Migration analysis dashboard Adding slicers for filtering Promote interaction with nudge prompts Searching the dashboard with a slicer Creating dynamic labels Highlighting key points on the dashboard Customised visualisation tooltips Syncing slicers across pages 7 Sharing dashboards Setting up and formatting phone views Exporting data Creating PDF files Uploading to the cloud Share dashboards in SharePoint online