4088 Courses in London

This is an essential programme for members of staff whose role exposes them to aggressive or violent behaviour. 1 What's happening? Issues around us Risks in context Personal experiences 2 Safety fundamentals Following internal policy and procedure Personal safety and lone working Use of technology 3 Nipping issues in the bud Recognising early warning signs Avoiding causing problems for ourselves 4 Calming - Reaching - Controlling Tips and techniques for potentially calming a situation Reaching and building rapport Accelerants - tips on avoiding accelerating a situation Assertiveness techniques Non-verbal behaviour Active listening and the use of questions and distractions Exploring ways forward and identifying win/wins Avoiding the secondary argument Fogging The 'drama triangle' If all else fails... 5 Harassment, stalking and on-line bulling What constitutes harassment and definition of stalking On-line bullying Steps to take 6 Reporting principles Importance of incidence reporting Taking care of us What next?

This course is designed for those already using Power BI Desktop and are ready to work with more comprehensive elements of analysing and reporting in Power BI. The course maintains a balanced look at data analysis including the Power Query Editor, with a deep dive into writing DAX formulas, and enhanced dashboard visualisations. The aim of this course is to provide a more complete understanding of the whole Power BI analytics process, by working with business examples that will equip you with the necessary skills to output comprehensive reports and explore Power BI's analytical capabilities in more depth. 1 The Query Editor Grouping rows in a table Split row by delimiter Add days to determine deadlines The query editor 2 Fuzzy Matching Joins Matching inconsistencies by percentage Matching with transformation table 3 The Query Editor M Functions Adding custom columns Creating an IF function Nested AND logics in an IF function 4 DAX New Columns Functions Including TRUE with SWITCH Using multiple conditions The FIND DAX function The IF DAX function Logical functions IF, AND, OR 5 Editing DAX Measures Making DAX easier to read Add comments to a measure Using quick measures 6 The Anatomy of CALCULATE Understanding CALCULATE filters Add context to CALCULATE with FILTER Using CALCULATE with a threshold 7 The ALL Measure Anatomy of ALL Create an ALL measure Using ALL as a filter Use ALL for percentages 8 DAX Iterators Anatomy of iterators A closer look at SUMX Using RELATED with SUMX Create a RANKX RANKX with ALL 9 Date and Time Functions Overview of functions Create a DATEDIFF function 10 Time Intelligent Measures Compare historical monthly data Create a DATEADD measure Creating cumulative totals Creating cumulative measures Visualising cumulative totals 11 Visualisations In-Depth Utilising report themes Applying static filters Group data using lists Group numbers using bins Creating heatmaps Comparing proportions View trends with sparklines 12 Comparing Variables Visualising trendlines as KPI Forecasting with trendlines Creating a scatter plot Creating dynamic labels Customised visualisation tooltips Export reports to SharePoint

Maximising the team's sales capability is the key aim for any sales manager. When sales people struggle to hit their targets, it falls to the sales manager to provide support and help colleagues to find their way again. One of the most effective techniques for sales managers to improve and maintain sales performance is by providing live sales coaching. Sales coaching encourages sales people to find their own solutions and take responsibility for their own development. This course will help participants: Develop people to fulfil their sales potential Provide motivational feedback Identify strengths and weaknesses of their team members Understand personal learning styles Identify and adapt for different personality styles Prepare and conduct on-the-job observations Motivate sales people to greater performance 1 How is sales coaching different from sales training? What is coaching? Discover how coaching empowers sales people Learn the best time to use sales coaching Decide which people should be coached first Creating a development plan 2 Understanding learning, behavioural and communication styles Use practical tools to help you assess individual styles Tap into the essence and energy of the person you are developing Understand your own learning, behavioural and communication preferences Develop a strategy to adopt for each member of your team Discover what motivates you and your salespeople to perform Appreciate how this knowledge will improve your sales conversion 3 Using the GROW coaching model Learn the secrets of a successful coaching session Discover the importance of SMART objectives and instructions Understand and capture what coachees are currently doing right Develop their problem-solving and decision-making skills Help your colleagues crystalise their plans and actions Provide follow-up opportunities to embed the learning 4 Giving motivational feedback Understand why effective feedback is so powerful in sales Learn key models for motivational feedback Discover how to manage and structure more difficult conversations Understand the power of positive reinforcement Encourage sales people to coach and support colleagues 5 Putting it into practice Use realistic scenarios to provide opportunities for practice Discover what it feels like to be coached Receive immediate feedback on your coaching style Share common performance issues with fellow sales managers Create a personal development plan 6 Preparing on-the-job observations and joint visits Build a strategy for coaching and team development Prepare an observation template for effective coaching Learn the key elements of preparation for your next coaching session Agree common areas to focus on with coachees 7 Action planning Personal action plans

An insightful, enjoyable and experiential programme to help you analyse data and information and make a balanced decision based upon sound commercial reasoning. It will enable you to identify options, make decisions and take actions based on a thorough analysis combined with instinct and intuition to make a positive effect on profitability. This programme will help you: Identify ways to analyse data and sort relevant from irrelevant information Develop analytical and numerate thinking, and consider the financial implications of a decision Make decisions based on sound commercial reasoning - a mix of intuition and analysis Select from a range of tools to analyse a situation and apply these effectively Understand how costs and profits are calculated Use tried-and-tested techniques to manage and control your budgets Appreciate the fundamentals of financial analysis Focus on the bottom line Identify the basics of capital investment appraisal for your business Evaluate results and seek opportunities for improvement to your business 1 The commercial environment What do shareholders and investors want? What do managers want? Profit v non-profit organisations Investor expectations 2 Financial and non-financial information Risk and reward considerations Drivers of commercial decisions 3 Running a business A practical exercise to bring financial statements to life Different stakeholder interests in a business The impact and consequences of decisions on financial statements 4 Where do I make a difference to the organisation? How can I contribute to an improved business performance? Key performance indicators - measuring the right things A 'balanced scorecard' approach - it's not all about money! 5 A 'balanced scorecard' approach Analysing and reviewing my contribution to the business direction What is the current focus of my commercial decisions? Developing the business in the right way - getting the balance right! Where should/could it be in the future? Do my decisions support the overall vision and strategy? 6 Making commercial decisions Left-brain and right-brain thinking Convergent and divergent thinking Analysis and instinct Interactive case study exercise - emotional and rational decisions Reflection - what is my style of making decisions 7 Let's consider the customer! Identifying target markets Differentiating propositions and products Customer service considerations Marketing considerations and initiatives Pricing strategies and considerations 8 Strategic analysis The external environment The internal environment LEPEST analysis SWOT analysis Forecasting Group activity - analysing markets and the competition How do these improve your decisions? 9 Comparing performance Analysing key financial ratios Ways to compare performance and results Break-even analysis 10 Profit and loss accounts and budgeting Managing income and expenditure The budgeting process How does this link to the profit and loss account? Managing and controlling a cost centre/budget The role of the finance department Different ways of budgeting Incremental budgeting Zero-based budgeting 11 Understanding the balance sheet Purpose of balance sheets Understanding and navigating the content What does a balance sheet tell you? How do you affect your balance sheet? Links to the profit and loss account A practical team exercise that brings financial statements to life 12 Business decisions exercise How does this improve your decisions? A practical exercise to apply new knowledge and bring commercial thinking to to life The impact and consequences of decisions on financial statements 13 Working capital Why is this important? The importance of keeping cash flowing Business decisions that affect cash Calculating profit 14 Capital investment appraisal Capex v Opex Payback Return on investment The future value of money The concept of hurdle rate 15 Lessons learned and action planning So what? Recap and consolidation of learning The decisions that I need to consider Actions to achieve my plan

The aim of this course is to provide an overview of the key principles and techniques for leading and managing project work. It will focus on the core principles and generic methods of project management, showing how these can be applied to typical projects. The scope of the programme includes: The course also emphasises the importance of the leadership and team-working skills needed by project managers and team members in carrying out their roles. The principal training objectives for this programme are to: Explain and demonstrate the key principles of successful project management Demonstrate a range of useful project management tools and techniques Define the role of, and help participants understand the skills required by, the project leader Illustrate the use of project skills through examples and case studies Identify ways to improve project management, both individually and corporately DAY ONE 1 Introduction (Course sponsor) Why this programme has been developed Review of participants' needs and objectives 2 Key concepts and requirements for success Projects and project management Lessons from past projects; the essential requirements for success Differences between projects; characteristic project life cycles The challenges of project management; the role of the project manager Project exerciseA team exercise to demonstrate the challenges of project management 3 Defining project objectives and scope Identifying the stakeholders; key roles and responsibilities Getting organised; managing the definition process Working with the 'customer' to define the project scope 4 Project case study: part 1 Defining the project objectives: syndicate teams define the objectives and scope for a typical project 5 Project planning The nature of planning; recognising planning assumptions Planning the plan; the importance of team involvement Developing the work breakdown structure Estimating task resources, timescales and costs Developing the project schedule Analysing the plan and identifying the critical path 6 Project case study: part 2 Creating the project plan Syndicate teams begin development of their project plans (for completion after session 7) Team presentations and group discussion (after session 7) DAY TWO 7 Managing project risks Understanding and defining project risks Classifying risks and adopting an appropriate risk strategy Identifying, evaluating and managing project risks Agreeing ownership of project risks; the risk register Integrating planning and risk management 8 Project control Pro-active and re-active control; striking the right balance Pre-requisites for effective, pro-active project control Avoiding unnecessary 'scope creep' and controlling change Selecting the data needed to provide early warning of problems Monitoring project performance: 'S' curves, slip charts, earned value Getting good data and assessing project status Defining the roles and responsibilities for control Setting up a routine process for keeping up to date Managing and controlling multiple projects 9 Project case study: part 3 Controlling the project Teams control their project as new developments take place 10 Course review and transfer planning (Course sponsor present) Identify actions to be implemented individually Identify corporate opportunities for improving project management Sponsor-led review and discussion of proposals Conclusion

In the fast-changing world of business, and especially IT, everyone in the organisation should be involved in sales. One of the best ways is to give the customer an outstanding experience. The customer experience is the competitive battlefield of today. Sales may be won or lost here. You can either close a sale for a quick buck, or open a long-term relationship to create a high lifetime value customer. By developing excellent communication skills, rapport and, most of all, a desire to serve and listen to the needs of the customer to the best of their ability, both sales teams and other IT professionals will create trust, nurture relationships and develop awareness of other opportunities with the customer. By the end of this course, participants will be able to: Understand the power of a positive customer experience in developing sales opportunities Recognise and develop a sales opportunity when it arises Engage with customers and develop rapport and trust Use verbal and non-verbal communication skills and pick up on signals Ask powerful questions - and listen to the answers Create 'magic moments' for the customer Turn a complaint into an opportunity Know when to ask for referrals and testimonials Pass on leads to the relevant people 1 Introduction Aims and objectives Beliefs about sales 2 Building rapport First impressions Short cuts to rapport Finding common interests 3 Selling or serving? Managing emotions and behaviour - Transactional Analysis Moments of truth - creating 'magic moments' Speed sells - the follow-up 4 Meetings Planning a successful meeting Pre-meeting connection and assistance Sales meeting failure reasons Right v wrong mindset 5 Communication - verbal and non-verbal The 3 Vs - Visual, Verbal, Vocal Picking up on signals 7 power questions Questioning techniques LISTEN - 3 types of listening skills 6 Influencing 6 levels of influence Framing to change perspectives Turning complaints into opportunities 7 Referrals The power of referrals How and when to ask for a referral 5 steps from rapport to referral 8 Presentation and pitching (optional session) Basic presentation structure and delivery Creating powerful impressions Creating a 60-second pitch The elevator 10-second pitch - answering 'What do you do?' Sales presentations Emotion v Intellect - how to engage Using visuals

Telephone selling can be a challenge. It can be a pressured environment and sales professionals need to be able to maintain peak performance in order to meet - and preferably exceed - their targets. This programme will help make it easier for them. The expert trainer covers the whole process, to help participants see it from their customer's perspective. The focus is on how to use a practical understanding of sales psychology, and of the nature of the telephone sales conversation, to help make it easier for customers to buy. This programme will give your team the skills to: This course will help participants: Understand why people buy - and how that makes it easier to sell Manage the sales process better Steer their sales calls to a more positive outcome Recognise - and respond to - customer buying signals Meet and overcome objections Choose the most appropriate techniques for closing with confidence Enhance their resilience Improve their communication skills on the telephone 1 Introduction Aims and objectives Overview Self-appraisal of current skills and development areas 2 The sales approach What selling means Why selling is like nature 3 The telephone as an instrument of communication Qualities of the telephone How telephone communication differs from face-to-face Advantages and drawbacks of the telephone How to optimise selling over the telephone Communication techniques to help you stand out from the crowd 4 Creating a relationship Professional telephone etiquette Building a rapport Connecting with the customer so that they feel you are on the same wavelength 5 The structure of a sales call Opening the call - creating a positive first impression Effective questioning to gather information and establish need Identifying and presenting the features and benefits of the product or service Matching the benefits to customers' needs Recognising and responding to buying signals Anticipating, meeting and overcoming objections Closing the sale and asking for the order - different closing techniques The importance of testimonials - how to obtain them and when to use them 6 Listening skills The challenges of accurate listening How to enhance listening skills Ensuring the customer feels heard and understood through empathetic listening 7 Shaping and using a script Developing a script to increase levels of confidence Leaving the door open 8 Managing the campaign Organisation and call planning Identifying your target market group Planning who and when to call Logging constructive information 9 Personal management The importance of persistence Is there a time to back off? Stamina - optimising energy levels Bouncing back 10 Practising the new information Pulling the details together Practising in a supportive environment 11 Action planning Personal learning summary and action plan

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

M&O of engineering plant and services is becoming more important to the success of the core business. To select the right M&O technique for specific plant and equipment it is necessary to know what options are available, what they deliver and how they should be implemented. This course will help you consider options and techniques that provide best value based on that thorough understanding of the business need. M&O will increasingly be required to demonstrate it is delivering the optimum of cost and value and the main purpose of the course is to show how this can be achieved. Note: this is a purely indicative list of topics that can be covered. The content, duration, objectives and material used would all be adapted to match your specific requirements. This course will help you: Determine what the business needs from the M&O service Determine the cost and value of the various M&O options Prepare and present the business case for the selected M&O strategy Introduce meaningful KPIs based on performance-based service by the M&O provider Undertake a review of current M&O and make recommendations for improvement Introduce energy and carbon management performance criteria in M&O Better deal with project risk and uncertainties Motivate others to deliver a reliable and cost effective M&O service Note: this is a purely indicative list of topics that can be covered. The content, duration, objectives and material used would all be adapted to match your specific requirements. 1 What is maintenance and what is operation? - their relative importance to the business 2 Comparison of the various maintenance options and techniques, including: Planned preventative Run to failure Condition monitoring Business focused Business critical Total productive Reliability centred maintenance 3 Forms of contracts and service, including: Comprehensive Input driven Output driven Limited replacement Performance based M&O 4 Selecting the right options and making the business case 5 Continuous commissioning as a tool for delivering best value 6 Case studies

Budgeting is more than mere vague oversight. Budgeting should deliver the corporate strategy, add shareholder value and lead to a well-run business - for the benefit of all involved in it. Effective budgeting leads to real control - effective day-to-day operational control and more. This course demonstrates what proper budgeting and operational control can do. This course will help ensure that participants: Appreciate the importance of the budgeting process Take ownership of it Use it as a daily working tool - not an annual exercise - to help run their part of the operation Improve their reporting against budget Ensure their delivery against budget 1 Objectives of budgets The budget process Stages - what is the prime aim of a budget? What is forecasting? ObjectivesPlanningImplementation 2 Budget and cost control focus Choosing objectives Links with corporate strategy Links with resource management Can the accounting systems cope? 3 Traditional budgeting and control Benefits and drawbacks The process Control and feedback Reporting - what can be expected? 4 Advanced budgeting and control Understanding the business process Taking out costs Cost awareness ZBB - as valid as ever 5 Reports Reports for action The purpose of a report Content - deliverables and feedback Culture is so important