881 Courses in Coventry

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

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 workshop has been designed to help managers understand their responsibilities and what they need to do to ensure compliance with current workplace legislation - including the fire safety and CDM regulations. The day will cover the legal background - including an appreciation of how safety legislation has evolved and why; the logic behind recent developments and the implications for staff and employers; key areas of current legislation; roles and responsibilities in health and safety management, including monitoring contractors and suppliers effectively; implementing sound health and safety policies and procedures; getting staff on board, and implementing effective systems. Also, recognising potential risks and hazards and developing strategies to minimise their impact in the workplace. This course will give participants an understanding of: The broader context of the key areas of health and safety regulation which apply to your organisation Existing health and safety practice and guide them in how to shape and implement an effective health and safety policy What they should do and the procedures to support it Potential areas of risk in the workplace - and how to take action to minimise the threat to staff safety How sound health and safety processes can contribute to business performance 1 Understanding the workplace legislation Overview of health and safety and workplace legislation Compliance, the role of the facilities manager, and who is accountable? Breakout session to discuss where we are now and to highlight issues of concern Applying required policies and procedures Developing and implementation/review of the safety policy Communicating with users, clients and contractors Health and safety manual 'Selling' health and safety 2 Key legislation - a practical working guide Asbestos Regulations Construction (Design and Management) Regulations 2007 / 2015 Control of Substances Hazardous to Health (COSHH) Regulations Disability Discrimination Act (DDA) Display Screen Equipment (DSE) Regulations 1992 Electricity at Work Regulations 1989 Fire Precautions (Workplace ) Regulations 2006 Health and Safety (Consultation with Employees) Regulations 1996 Health and Safety (First Aid) Regulations 1981 Health and Safety at Work etc. Act 1974 Management of Health and Safety at Work Regulations 1992 Manual Handling Operations Regulations 1992 Portable Appliance Testing (PAT) Provision and Use of Work Equipment Regulations 1992 REACH - Registration, Evaluation, Authorisation and restriction of Chemicals Reporting of Injuries, Diseases, and Dangerous Occurrences Regulations (RIDDOR) 1995 Waste Electrical and Electronic Equipment (WEEE) Regulations 2006 Work Equipment Regulations 3 Controlling contractors Understanding the Regulations Selecting and assessing contractors Understanding and setting accountability Why a method statement? How to apply a permit to work system Safe systems of work Round-table discussion to bring out issues from participants' own experience 4 Risk assessment Understanding your hazards Identifying specialist areas How to undertake these assessments Implementation of sound systems and processes Syndicate exercise identifying where assessments are needed and carrying out assessments 5 Keeping the work environment safe Sick building syndrome and legionella Asbestos Waste management Pest control Provisions for first aid Accident reporting and investigation At-work driver safety Security 6 Fire safety Understanding the Regulatory Reform Fire Safety Order Fire certificates The fire risk assessment Testing fire-fighting equipment? Emergency procedures Workshop to examine the procedures for dealing with different types of emergencies 7 Ergonomics programme Ergonomics - important or irrelevant? Are you complying with HSE regulations? Furniture and equipment Display screen equipment assessments Homeworking - your concern or not? Syndicate exercise to review what to do when relocating or refurbishing an office 8 Inspecting and auditing Role of Health and Safety Executive Inspectors - 'be prepared' FM role Staff/trade union involvement Independent audits Records and reports Communicating the results 9 Action plan Participants to list actions they need to take after the course

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.

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.

Transport Compliance, Audits, Health and Safety, HGV compliance, PSV compliance, Compliance, Templates, Toolbox Talk, Professional Development, Assistance, Operator Licence assistance,

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.

Belonging & Connection

This foundational course will help all managers better understand what a procurement function does, including the processes, tools and techniques it employs to reach its goals and how it measures its business performance. PARTICIPANTS WILL LEARN HOW TO: Explain the contribution of procurement to the overall business objectives. Explain the added value that can be obtained by a business when it manages its procurement activities efficiently and effectively. Understand the complex activity of procurement and the challenges it presents for risk management. Develop good quality procurement practices that will manage the expectations of all stakeholders Identify methods by which a procurement function can be measured and performance monitored. Perform contract management activities. Understand ways in which improvements might be identified and implemented. COURSE TOPICS INCLUDE: Procurement and business objectives Stakeholder Management Commercial Specifications Whole Life Costing Targeted procurement Procurement planning Supplier Appraisal and selection RFQ & ITT & Evaluation Contract Management

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