1292 Courses in Leicester

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 comprehensive course, developed in line with the esteemed guidelines of the Resuscitation Council (UK), Skills for Health, and the Faculty of Pre-Hospital Care (RCS Ed), is designed to enhance your abilities in delivering superior emergency care across various settings.

This course is designed specifically to help improve your collection rates. The UK's leading trainer in the subject uses practical examples and case studies to show how to use debt collection techniques that really work. This programme will help participants to: Understand debtors and communicate with them effectively Improve their telephone and writing skills Appreciate the key legal issues Track down 'gone-aways' Improve their collection rates 1 Giving credit and collecting debts The benefits when you get it right The cost of getting it wrong 2 Analysing yourself The importance of making the right 'first impression' Assessing your own personal communication style and how this affects your results How do you (or might you) look in the debtor's eyes? What would you like to change? 3 Analysing your debtors Types of debtorThe delaying debtorThe genuine debtorThe cashflow or hardship problem debtorThe ones who never intended to pay Spot the most common reasons and excuses for non-payment - and learn how to deal with them 4 Understanding debt recovery and the law Data protection issues County Court suing enforcement methods Human rights and debt recovery Retention of title matters 5 Telephone skills for debt recovery A 7-point plan which works every time Learning by example: listening to and analysing some pre-recorded (or live) collection callsWhat was done well?What should have been done differently?Did the collector recognise opportunities?Did the collector create opportunities where seemingly none existed?Did the collector negotiate well or not at all? 6 Writing skills for debt recovery Key phrases to avoid What to include A sample letter which gets results in over 90% of cases 7 Tracking down the 'gone aways' A unique debtor-tracing plan Why spend money on external tracers when you can find those 'gone away' debtors for yourself? 8 Course review The traps to avoid Key personal learning points

EQ is a pattern of how people's biases in their thinking leads them to think one choice or thing is better than another, as well as their clarity in differentiating within those biases to exercise clear and sound judgement. Where your thinking and responses lie within your biases spectrum, and your ability in adjusting to the situation you find yourself in, will determine responses equating to poor or strong Emotional Intelligence (EI). This course will enhance and promote the skill set necessary for any working leader or manager, allowing our in-depth emotional intelligence knowledge to be applied into your working environment. From an employer's perspective, this award can be a significant long-term return on investment by further developing your leaders and managers. What Does This Course Offer? Our program offers an EQ-SWOT™ assessment and EI Model in detail, and through activity and discussion we explore how applying and possibly adjusting, you may offer an improved Emotional Intelligence. Our learning experiences are successful because the outcomes are quickly embedded and demonstrate an immediate visible impact on the day-to-day working environment. Our engaging learning inspires employees to want to personally add value to the companies they work for. We also offer our Paradigm EQ-SWOT™ online assessment and report as a frame of reference within the program. This assessment should be completed before attending the program, and will be expanded upon during the program delivery. Course Content The Emotional Intelligence for Today’s Leadership and Management course covers the following topics: What makes EI so important within the workplace Self-Awareness and your EQ Profile The EQ unpacked Unconscious Bias & EI How to develop your EI quotient Accreditation Activity Our accredited tutors deliver training that encourages delegates to confidently and practically apply all they have learnt as soon as they get back into the business. To achieve this award, delegates need to prepare and deliver a 3 minute presentation* on the highlights of their learning and immediate application avenues when back in their working environment. *Participants will be given 30 minutes during the program to prepare for their 3 min presentation at the end of the program. Scheduled Course Dates Unfortunately this course is not currently scheduled as an open course as it is primarily run as an in-house programme. For more information, please contact us. In-House Courses This is our own management training course which has been developed and refined over the many years we have been providing it to delegates from organisations in virtually every industry. This means that the course syllabus is extremely flexible and can be tailored to your specific requirements. If you would like to discuss how we can tailor this management training course for you and/or run it at your premises, please contact us.

This course is designed to provide training for those undertaking the role of temporary works...

Generating new leads and new business can be both time-consuming and frustrating. It's not easy - it takes skill, careful preparation and the creation of effective models and methods, even perhaps using formal approaches and scripts. Once generated, a new lead or enquiry must also be carefully managed to maximise the potential revenue it can generate. But it's crucial to get it right. If your company can afford not to worry about getting new business - congratulations! If your company is completely confident that it is performing at peak potential in generating new leads - again, congratulations! But if your company is working in the real world, couldn't your team do with some help, to become even just that little bit more effective, to make the process just that little less painful? This highly practical, intensive workshop gives sales teams the proven strategies and tactics they need to build a sustainable new business pipeline. This course will help participants: Develop a clear and consistent process for new business development and lead-generation Master the secret of effective new business development and lead-generation - 'only sell the appointment or next stage of the sales process, not your product or service' Set and achieve the right level of new business development and lead-generation activity to achieve your personal and organisational sales goals Apply the key principles of effective prospecting and pipeline management using a proven toolkit and approach Overcome the most common 'put-offs' when conducting telephone or face-to-face business-development and lead-generation activities Develop an engaging telephone voice and manner - and a 'networking personality' Qualify potential opportunities with more accuracy on a consistent basis Prioritise opportunities and manage their time when sourcing new business Discover online sources of leads, contacts and referrals Overcome psychological blocks to cold or warm calling - theirs and the client's Identify potential prospects - and decision-makers and influencers within target prospects - with greater accuracy Make outbound sales or appointment calls with improved confidence, control and results Improve the conversion of calls to appointments by using more effective questions and sales messages Get past gatekeepers and assistants more effectively Make the most of your CRM software and systems 1 Online marketing - what works! Workshop overview and learning objectives Choosing your social media channels LinkedIn for sales and marketing Designing and implementing an effective new business email campaign online Creating a lead-generation strategy online - with case studies Avoiding common mistakes in social media marketing Case study: 'Best practice in social media sales and marketing' Using blogs and video-based marketing (eg, YouTube) New trends and how to keep your finger on the 'social media' pulse Twenty essential websites and online marketing tools 2 Making appointments by telephone Planning the call, telephone techniques, integrating with email and online marketing Developing a clear and consistent process to appointment-making Setting and achieving the right level of telephone activity to achieve your appointment goals Applying the key principles of effective prospecting and pipeline management generation, using a proven toolkit and approach Overcoming the most common 'put-offs' to seeing or engaging with you Overcoming psychological blocks to cold or warm calling - yours and the client's Identifying potential prospects - and decision-makers and influencers within target prospects - with greater accuracy Making outbound sales or appointment calls with improved confidence, control and results Improving conversion of calls to appointments by using more effective questions and sales messages The five keys to developing an engaging telephone voice and approaching manner 3 Power networking Strategies for networking and B2B referral-based marketing The importance, and different types, of networking How to work a room - preparation and strategy Communication dynamics in networking - the power of the listening networker Assumptions when networking Business networking etiquette Making connections, asking for cards, contact details and referrals, gaining follow-up commitments Building relationships - follow-up and follow-through 4 Developing new leads Strategies for first-time sales calls Gaining rapport and opening first-time and new business sales calls effectively Advanced consultative selling - questioning techniques to quickly and efficiently uncover opportunities, need areas and preferences Presenting your solution to a new or first-time customer - creating an enthusiastic and compelling personalised and persuasive summary of your proposal Value message - differentiate your solutions clearly and accurately, with tailored value statements Presenting the right initial USPs, features and benefits and making them relevant and real to the customer Smart ways to position price, emphasise value and be a strong player without being the cheapest or leading on price Learn and use advanced techniques to determine customer needs, value and decision-making criteria in depth on a first-time call 5 Organised persistence - CRM and prospect-tracking Organised persistence - sales tracking, following up on 'sleeping' customers, gaining referrals, time and territory management Maintaining a good database for maximising new business ROI Developing a contact strategy with different types and levels of contact Analysing your contact base using state-of-the-art software and tools Making the most of your CRM systems and solutions Understanding that your attitude makes a difference when sourcing new business Setting SMART objectives for new business development and lead-generation Practical exercise - setting personal development and business goals Time management tips to improve daily productivity New business pipeline management strategies for peak sales performance 6 Workshop summary and close Practical exercise - developing your new business action plan Review and feedback

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.

Masterclasses? Refreshers? Introductions? It depends what you're looking for and where you want to pitch them, but here are six tried-and-tested highly focused sessions that organisations can take individually or as a series, to help develop their teams' project management capabilities one topic at a time. Objectives for each individual session are set out below, as part of the session outlines. Taken together, as a series, however, these modules are an ideal opportunity to develop your team's levels of project management capability maturity, whether that's by introducing them to the basic principles, refreshing them on best practice, or giving them the opportunity to really drill down into a specific area of challenge in your particular operating environment. Session outlines 1 Stakeholder management Session objectives This session will help participants: Understand why stakeholders matter to projects Be able to identify and engage stakeholders Be able to categorise stakeholders by their significance 1 Key principles What does 'stakeholder' mean - in theory? What does this mean in practice? Why stakeholders matter Consequences of missing stakeholders The stakeholder management process:IdentifyAssessPlanEngage 2 Identifying stakeholders Rapid listing CPIG analysis PESTLE analysis Drawing on the knowledge and experience of others Other ways to identify stakeholders 3 Assessing stakeholders Which stakeholders are significant? Stakeholder radar Power-interest maps Power-attitude maps 4 Planning The adoption curve Dealing with obstacles Who should engage which stakeholder? How should the project's organisation be structured? How will communication happen? 5 Engaging Seven principles of stakeholder engagement 2 Requirements and prioritisation Session objectives This session will help participants: Understand how clarity of requirements contributes to project success Use different techniques for prioritising requirements Agree requirements with stakeholders Manage changes to requirements 1 Understanding and managing stakeholder needs and expectations What are 'requirements'? What is 'requirements management'? Sources of requirements - and the role of stakeholders Are stakeholders sufficiently expert to specify their needs? Do they understand the detail of what they want, or do they need help to tease that out? What do stakeholders want to achieve? Working within constraints Prioritising requirements - three techniques 2 MoSCoW prioritisation 'Must have', should have', 'could have, 'won't have this time' When to use MoSCoW 3 The Kano Model Customer satisfaction - 'attractive' and 'must-be' qualities When to use Kano 4 Value-based prioritisation Understanding risk v value Using risk v value to prioritise features and schedules 5 Agreeing requirements Perfect v 'good enough' Establishing acceptance criteria Requirements traceability Agreeing project scope 6 Changing requirements Why requirements change Why change control matters Impact on projects A formal change control process Paying for change - managing change for different types of project 3 Estimating Session objectives This session will help participants: Understand the different purposes estimates satisfy Be able to use different estimating techniques Understand how to achieve different levels of accuracy 1 Key principles What's an estimate? Informed guesswork What needs to be estimated? Costs, resources, effort, duration Tolerances Precision v accuracy 2 Estimating through the lifecycle Start Plan Do 3 Early estimates Comparative ('analogous') estimating Parametric estimating Using multiple estimating techniques 4 Bottom-up estimating Bottom-up ('analytical') estimating Pros Cons 5 Three-point estimating Three-point ('PERT': Programme Evaluation and Review Technique) estimating Uncertainty and the range of estimates Calculating a weighted average Three-point with bottom-up 4 Scheduling Session objectives This session will help participants: Understand how to create a viable schedule Be able to use different forms of schedule Understand the concept of the critical path 1 Key principles The planning horizon Rolling wave planning Release planning 2 Viable scheduling Creating a viable schedule Define the scope Sequence the work Identify the risks and build in mitigations Identify the resources Estimate the effort and durations Check resource availability Refine until a workable schedule is produced 3 Critical path analysis The critical path Network diagrams Sequence logic Practical application:Network diagram with estimated durationsThe 'forward pass'The 'backward pass'Calculating total floatIdentifying the critical pathCalculating free float Gantt charts 5 Risk and issue management Session objectives This session will help participants: Understand the difference between risks and issues Be able to identify and assess risks Understand ways of mitigating risks Manage issues 1 Key principles Understanding risk Threats and opportunities The risk management processPreparation - proactive risk managementThe process - identify, assess, plan, implementStakeholder communication Roles and responsibilities Risk management strategy The risk register Risk appetite 2 Risk identification Brainstorming Interviews Assumption analysis Checklists 3 Risk assessment and prioritisation Probability, impact and proximity Triggers Qualitative risk assessment Qualitative impact assessment Qualitative probability assessment Probability / impact grid Bubble charts Risk tolerance 4 Planning countermeasures To mitigate or not to mitigate? Categories of risk response Avoid and exploit Reduce and enhance Transfer Share Accept Contingency Secondary risks 5 Issue management What is an issue? Tolerances Issues and tolerances The PRINCE2 view of issues Ownership of issues An issue management process Issue register 6 Budgeting and cost control Session objectives This session will help participants: Understand what to include in a budget - and why Choose - and use - the appropriate estimating technique Align the budget with the schedule Understand how to monitor spend and control costs Trouble-shoot effectively to get projects back within budget Session format Flexible. The session can be tailored to the participants' average level of project management maturity - a 60-minute session (delivered virtually) is an effective introduction. A 90-minute session allows for more in-depth treatment. A half-day session (face-to-face or virtual) gives time for a more challenging workshop, particularly to discuss specific cost control issues with any of the participants' current projects. 1 Where is the money coming from? Can we pay from revenue? Do we need to borrow? How long will the project take to pay back? The lifecycle of the budget Through-life costs Stakeholder involvement 2 Estimating costs Reminder: the relationship between estimates Reminder: possible estimating techniques What do we need to estimate?PeopleEquipmentMaterialsFacilities and operating costsWork package estimateEstimated project costs Estimating agile projects 3 Aligning budget and schedule Scheduling and financial periods Spreading the budget 4 Reserves and agreeing the budget Contingency reserve Management reserve Agreeing the budget 5 Cost control Planned spend over time Actual spend over time Work completed over time Evaluating different scenarios: delivery v spend 6 Trouble-shooting Why are we where we are? What has caused the project to spend at the rate it is? Why is it delivering at the rate it is? What are the root causes? What can we do about it?

Support culture change by giving line managers the skills to look at practices within their areas, role model appropriately and address unacceptable behaviours. Our dynamic, assertive trainer for EDI has a very practical approach, with plenty of real-life examples to help participants view the subject from a new angle

This workshop will help you improve the impact, clarity, accuracy and effectiveness of your sales proposals. It takes bid and proposal teams right through the process, from start to finish - from forming the team and gathering the information, through to writing and reviewing the proposal document, and on to presenting it to the client. The learning points shared in the programme come from the trainer's extensive real-world experience with a wide variety of businesses. As a result of attending this programme, participants will be able to: Write more clearly, more grammatically and more persuasively Structure their written communications more effectively Avoid the 'howlers' that can cost you business Impress your clients Win more business 1 Bid strategy How to combine your knowledge of the market or customer, your products and services, and your competitors, to create a quality bid New insights into your comparative advantages and competitive position in the marketplace Understanding more about how your client views you and other suppliers A plan of attack to build on your strengths and attack the weaknesses of your competition Dealing with RFP/ITT situations 2 Teamwork How a bid or proposal team needs to prioritise and manage preparation time Co-ordinating input from team members Agreeing responsibilities 3 The importance and role of a well-written sales proposal Why bother? - the value of the sales proposal to you and to the customer What the customer wants and needs to make a decision in your favour Understanding and delivering on customer expectations Review and discussion of different proposals - with real-life examples 4 The best way to structure your sales proposals A section-by-section, page-by-page review of best practice in structuring great sales proposals How to improve the way you match your proposal to the customer's objectives and requirements Plan your sales documents systematically - to make them easy to read and more persuasive How to make your proposal look like the 'least risky' option 5 Making your proposal a compelling and persuasive proposition Choosing the right words that sell effectively Selecting the right content and information for your document or proposal Using an option matrix to summarise complex choices and increase final order value How to write an executive summary 6 Well-written and error-free Developing your writing style for maximum impact Expressing the content (ie, selling points) clearly, concisely and correctly Proof-reading and editing work effectively, using formal marks and techniques Improving visual layout, format and appearance Keeping it customer-focused 7 Presenting to the client - overview Presentation options Understanding the client's objectives - as well as your own The proposal review meeting - logistics Managing to the next step Designing and delivering a compelling presentation Isolating objections and concerns Follow-up and follow-through 8 Positioning your final proposal Finalising your bid - presenting the right 'best few' USPs, features and benefits and making them relevant and real to the customer Smart ways to position price and be a strong player - without being the cheapest How to differentiate yourselves by how you present, as well as what you present How to design and deliver a successful bid presentation 9 Bid presentation practice session with structured feedback Participants work in small groups or pairs to prepare and later present a sample section from a real life bid or proposal presentation The trainer will provide assistance and input During group review and discussions, input from others will be encouraged and many best practice ideas summarised 10 Managing the end game How best to draw-out, understand, isolate and answer customer objections, negotiate points and concerns How to read the situation to plan the next step Identifying negotiation tactics - and how to deal with them Planning for a negotiation and how to get the customer feel they have the 'best deal' 11 Workshop summary and close