528 Courses in Edinburgh

Maximising the relationship and sales potential of each active account is key to the sustainability of any business relying on repeatable custom. In this workshop we start by looking at key techniques for analysing the profitability and development opportunities for different clients before deciding upon the strategy and skills needed for moving the relationship to that of trusted adviser and partner. By understanding and creating the need we can use our influencing skills to harness any sales development potential. By creating the habit of explaining our ideas in a way that also meets the need of the other party we help everybody make the right decisions for them. This course will help participants: Assess the sales profitability and potential of existing key accounts Prioritise where time and energy is directed for maximum profitability Understand the key players in the decision making unit Create a strategic plan for the development of each client target Develop proactive sales consultancy skills Learn advanced communication and influencing techniques 1 What makes an effective account manager? The difference between order taking and account management How do you define a key account in your business? Why should existing customers remain with your company? How do you compare to the competition? 2 How do I prioritise my account management activity? Use practical tools to help you assess revenue potential Analyse the investment required versus the return on your time Create a SWOT analysis on your clients - Strengths, Weaknesses, Opportunities & Threats Appreciate how this knowledge will improve your sales development 3 Planning strategies for each account Create a list of priority accounts and activities Learn how to develop a long-term and sustainable relationship Discover how they make their purchasing decisions Research the make-up of the Decision Making Unit for each client 4 Learning and utilising the six principles of influence Learn the secrets these principles offer sales people Discover how these principles will work for you Create an influencing strategy for influencers within the client Learn new habits of influence 5 Proactive sales skills Plan proactive sales meetings for key accounts Set primary and secondary objectives for every touch point with the customer Structure sales meetings for maximum effectiveness Help the customer commit and achieve their objectives 6 Putting it into practice Discuss real scenarios to plan for putting these skills into practice Share common issues with fellow sales people Create a personal development plan

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

We've all sat through far more bad presentations than good ones, but knowing what 'good' looks like is easier than successfully replicating it. Sales presentations are a performance and, as salespeople, fluffing our lines can cost us a lot more than hurt pride. Having discovered and understood the specific needs and burning issues our prospect has, then this course will help any salesperson avoid dropping the ball and instead wowing their prospects with a high-impact, tailored and compelling case for purchase. This course will help participants: Prepare mentally and physically for stand-up presentations Use voice modulation and bullet-pointing to demand attention Avoid boring their prospects Master the do's and don'ts of PowerPoint Deal more effectively with technical hitches and prospect's interruptions Use eye contact and engagement to avoid prospects 'tuning out' Deploy best practice essentials for presenting with colleagues Steer through the toughest Q&A 1 Preparing your presentation Mindset Knowing your objective(s) Vocal warm-up techniques Assembling pre-agreed benefits Time management Room set-up Technical preparation 2 How to open your presentation Vocal energy Summary and agreement of prospect's needs How to have posture and confidence Use of humour What to do with those dreaded hands Confident v non-confident body language 3 How to get and keep people's attention Bullet pointing Linking benefits to specific, stated needs Practical exercise - formulating and delivering tailored benefits Being selective with features Third party reinforcement and case studies 'Watering the garden' eye contact technique Practical exercise - participants practise 'sharing out' eye contact to audience How to handle a prospect's negative body language Handling interruptions 4 Presenting in groups Credentialing all participants Role delineation for group presentations Edifying other participants' messages - do's and don'ts How to maintain energy when not speaking Practical exercise - good and bad practice when not speaking Teamwork in Q&A sessions How to hand over professionally 5 PowerPoint do's and don'ts Use of visual aids Good and bad PowerPoint slides How to make PowerPoint work for you Classic PowerPoint errors Avoiding and handling technical problems Good and bad flipchart practice 6 Closing and / or achieving next action steps Power of summary Good Q&A practice Handling objections Practical exercise - handling objections on one's feet Creating consensus among prospect panel What to do when prospects disagree with each other When to trial close How to close on next action steps 7 Wrap-up Key learning points from each participant Action steps to be implemented on next presentations

This course provides participants with a comprehensive understanding of the requirements of the CDM Regulations 2015 and how these should be implemented in practice. The Regulations are put in context with other key health and safety legislation. The programme sets out clearly the roles and responsibilities of the principal duty holders and explores with the participants how these roles may vary on different types of project and procurement routes. The programme examines the content and appropriate level of information that should be included in the Pre-Construction Information and the Construction Phase Plan. The trainer will discuss best practice in implementing CDM through the new 2015 Regulations and Guidance. This course is essential for anyone who is involved in the procurement, planning, design or implementation of construction work. The course will provide you with: An overview of construction health and safety law, liability and enforcement A detailed understanding of the 2015 CDM Regulations and the part they play with other key legislation An explanation of the roles and responsibilities of all duty holders and the requirements for the CDM documentation Clear advice on current best practice for complying with the principles of the CDM Regulations and the changes introduced by the 2015 Regulations An understanding of how risk assessment should be applied practically throughout the design and how this responsibility is then transferred to contractors 1 Introduction Why manage health and safety? The costs of accidents Construction industry statistics Why CDM? Health and safety culture in the construction industry 2 Overview of health and safety law and liabilities Criminal and civil law Liability Enforcement and prosecution Compliance - how far do we go? Statutory duties 3 Health and safety law in construction Framework of relevant legislation Health and Safety at Work etc Act 1974 Management of Health and Safety at Work Regulations 1999 Construction (Design and Management) Regulations 2015 Who is responsible for the risks created by construction work? Shared workplaces/shared responsibilities Control of contractors - importance of contract law 4 Construction (Design and Management) Regulations 2015 Scope - What is construction? Application - When do they apply? The CDM Management System Duty holders (Client, Domestic Client, Designer, Principal Designer, Principal Contractor, Contractor) Documents (HSE Notification, Pre-Construction Information, Construction Phase Health & Safety Plan, H&S File) Management process The 2015 Guidance 5 Best practice - key issues in the CDM process The client and client management arrangements Competence and resource under CDM 2015 The role of the Principal Designer in practice Design risk assessment and the role of the Designer The CDM Documents (PCI, PCI Pack, Plan and File) Construction health, safety and welfare Making CDM work in practice 6 Questions, discussion and review

Where should management effort be directed? In controlling costs and ensuring proper engineering in live projects? - yes, of course, but true cost control comes by understanding, eliminating and minimising risk prior to a business committing any funds. This course studies the stages required for practical financial and business appraisals of projects and capital expenditure. This course has two primary objectives: To impart the knowledge and skills required to ensure as risk-free as possible expenditure of that scarce resource, cash - the investors', governments' or shareholders' money must not be squandered To improve the quality of the appraisal process in the widest sense - demonstrating how the process of project and capital expenditure appraisal can be used to dramatically improve cost control and deliver as risk-free as possible expenditure As a result of the course, participants will be able to: Understand the economics of appraisal Be in control of their projects from the start Understand the economics of their projects - and devise the most appropriate mode Carry out sensitivity analysis and identify risk Improve their methods of appraisal and approach Focus on the risk areas and take out risk and control costs before they over-run The benefits of attending this course will be demonstrable from day one. Thorough appraisals and risk assessment follow through to success in project management and detailed cost control and project management. 1 Introduction Why appraise? Taking risk out of investment The short- and long-term results of not appraising business expenditure 2 Developing an appraisal process The process - overall and stage-by-stage objectives Understand business and technical risks Manage resources and time Do you invest enough time and effort at this stage? Take out the risks - control costs before you are committed to contracts and action Checklists 3 Appraisal arithmetic Review of the arithmetic of appraisalThe time value of moneyThe effects of different interest or required ratesThe effects of inflation (or deflation) in prices and costs Understanding the economics of appraisal is essential 4 Appraisal measures Meaning and use of appraisal measures Identifying the most appropriate measures for your particular business Payback Discounted cash flow measures - NPV and IRR Other measures - FW, AW, Profitability Index The meaning of the measures and their application in practice 5 Cost benefit analysis The effect on decision-making of more intangible benefits Cost benefit analysis Ensuring costs are genuine Measuring intangible benefits Environmental issues Consideration of intangible benefits in the appraisal decision-making process 6 Developing appropriate models Developing models - examples of spreadsheet models and measures for many different situations Modelling investment opportunities - summarising outcomes Sensitivity analysis - identifying, quantifying and taking out risk 7 Developing an appraisal process The process - managing risk from the outset Using the process in risk management, negotiating and project management Take out risk by thoroughly knowing your project - developing your own process

This course provides participants with a comprehensive understanding of the requirements of the CDM Regulations 2015 and how these should be implemented in practice. The Regulations are put in context with other key health and safety legislation. The programme sets out clearly the roles and responsibilities of the principal duty holders and explores with the participants how these roles may vary on different types of project and procurement routes. The programme examines the content and appropriate level of information that should be included in the Pre-Construction Information and the Construction Phase Plan. The trainer will discuss best practice in implementing CDM through the new 2015 Regulations and Guidance. This course is essential for anyone who is involved in the procurement, planning, design or implementation of construction work. The course will provide you with: An overview of construction health and safety law, liability and enforcement A detailed understanding of the 2015 CDM Regulations and the part they play with other key legislation An explanation of the roles and responsibilities of all duty holders and the requirements for the CDM documentation Clear advice on current best practice for complying with the principles of the CDM Regulations and the changes introduced by the 2015 Regulations An understanding of how risk assessment should be applied practically throughout the design and how this responsibility is then transferred to contractors 1 Introduction Why manage health and safety? The costs of accidents Construction industry statistics Why CDM? Health and safety culture in the construction industry 2 Overview of health and safety law and liabilities Criminal and civil law Liability Enforcement and prosecution Compliance - how far do we go? Statutory duties 3 Health and safety law in construction Framework of relevant legislation Health and Safety at Work etc Act 1974 Management of Health and Safety at Work Regulations 1999 Construction (Design and Management) Regulations 2015 Who is responsible for the risks created by construction work? Shared workplaces/shared responsibilities Control of contractors - importance of contract law 4 Construction (Design and Management) Regulations 2015 Scope - What is construction? Application - When do they apply? The CDM Management System Duty holders (Client, Domestic Client, Designer, Principal Designer, Principal Contractor, Contractor) Documents (HSE Notification, Pre-Construction Information, Construction Phase Health & Safety Plan, H&S File) Management process The 2015 Guidance 5 Best practice - key issues in the CDM process The client and client management arrangements Competence and resource under CDM 2015 The role of the Principal Designer in practice Design risk assessment and the role of the Designer The CDM Documents (PCI, PCI Pack, Plan and File) Construction health, safety and welfare Making CDM work in practice 6 Questions, discussion and review

The aim of this programme is to provide current / prospective senior project managers with an in-depth review of the role and importance of project management in the organisation. It focuses on the strategic role of the project manager and aims to draw out the full scope of the role and how it impacts on project performance. The five key objectives of this programme are to enable the participants to: Identify the characteristics and attributes needed by project managers in ensuring the organisation is recognised as an industry leader in delivering successful projects Understand the full scope and impact of the project manager / leader's role in managing projects or programmes to maximise benefit to the business Define the hallmarks and skills required to manage significant business projects or project portfolios Develop an understanding of the skills required and their impact on the project through case study work and syndicate exercises Benefit from an effective forum for exchanging experience and fostering a sense of team spirit and mutual support between senior project managers DAY ONE 1 Introduction (Course sponsor) A vision of future opportunities and challenges The impact of project managers / leaders on future success 2 The determinants of success The contractor's perspective The client's perspective Success and failure: factors that determine the project outcome The impact of the project manager 3 Case study: Project Giotto How successful was this project? What were the primary factors that influenced the outcome? How relevant are these factors to current projects? Feedback and review 4 Project team exercise A practical exercise demonstrating the role of the project manager in managing the interfaces between the client, the project team and suppliers Review - what skills are required to be a 'world class' project manager? 5 The role of the Project Manager The role and skills of the 'world class' project manager The three key dimensions of effective project leadershipManaging influential stakeholdersManaging project performanceManaging the project team Project leadership skills appraisal (individual review) DAY TWO 6 Managing influential stakeholders Project management and the art of leadership Who are the influential stakeholders and how do they affect the project? What we need to do / not do, to build successful working relationships 7 Case study: Understanding the customer What are the likely problems the project manager will encounter? What should the project manager do to ensure an effective partnership? 8 Managing project performance Issues affecting commercial performance Joining up the project life-cycle: getting performance from inception to closure The roles of project manager, line manager and project sponsor 9 Project team exercise: Making the promise / delivering the promise An exercise demonstrating the commercial and team leadership skills needed by the project manager Review - what must the project manager do to optimise project performance? 10 Managing multi-functional project teams The challenges of building effective, multi-functional project teams Co-ordinating work across functional and organisational boundaries Maintaining strategic focus and balancing priorities 11 Making it happen Individual action planning Syndicate discussion 12 Course review and transfer planning (Course sponsor present) What will we do differently? How will we make it happen? Conclusion

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

Customers are astute and well-practised in researching and seeking information, solutions and added value in the minimum number of clicks online. There's only so much time they're willing to spend carrying on clicking. This mentality isn't just restricted to the world of B2C. In our increasingly hectic world, where information is expected to be available instantly, it applies just as much to B2B. In this workshop, we look at how putting yourself in the shoes of your customer and mapping their decision-making and buying journey is critical to ensuring that you provide what they perceive as fast solutions and added value. You will learn all about the three pillars for creating competitive brand experiences: Customer engagement planning puts you firmly in the shoes of your customer, helping you to build meaningful marketing communications delivered through the right resources at the right time to inspire your customers to engage with you. This programme will help participants to: Understand the evolution of the customer buying journey Map a customer buying journey for your brand or solutions Understand the customer micro-moments and signals indicating interest and buying intent, both online and offline Apply the psychology of branding to build marketing communications with impact Develop sales and marketing content that differentiates your brand(s) from the competition by demonstrating unique value and how you can meet your customer's needs 1 The evolution of the customer journey Understand how the use of mobile has had an impact on the customer buying journey where today's customers can research and compare products and solutions whenever and wherever they like, making the purchase journey even less linear Explore how marketers are adapting to this new customer behaviour and drawing upon various strategies to win the hearts and minds of their audiences 2 The See-Think-Do-Care framework Explore the many different frameworks used to track the customer journey Understand and apply the modern marketing model, where the internet has enabled the customer to hop between multiple touchpoints before making a purchase decision 3 Customer micro-moments and signals in their buying journey Understand the online and offline moments when customers seek information to research and make buying decisions Apply this understanding to build a marketing communication plan to reach customers at all stages of their buying journey 4 The role of branding in the customer journey Explore the psychology of branding Learn how to ensure your branding is relevant to your target customer needs Bring together your brand value and story to achieve brand loyalty 5 The Why-How-What framework Apply a systematic approach to build a successful and compelling brand Understand how starting with 'why' will help build your brand purpose Apply the content marketing matrix to communicate your brand's value Apply the hero-help-hub model to build engaging content marketing Actionable outcomes We will use your brand examples to provide opportunities for practice: You will learn and reflect on best practice examples of customer engagement You will discover your brand value, purpose and the 'sweet spot' to drive engagement with your customers You will create a customer engagement plan that can be implemented immediately within your business You will receive immediate feedback on your customer engagement plan You will have the opportunity to share common issues and solutions with your colleagues in the group

This very practical workshop has a simple objective: to help you prepare, design and deliver memorable and high-quality presentations. This programme will help you: Use a proven, structured tool-kit when designing and developing presentations Benefit from short cuts and best practice when designing and using Powerpoint presentations Select the right information, examples, exercises and activities - and use them well Prepare and structure a presentation or session appropriate to the audience, and to best achieve your objectives Maintain audience or group interest Develop and practise presentation skills to improve your voice tone, speech power and body language Use practical methods to control nerves and anxiety - develop higher levels of confidence and credibility Command a room, hold attention and create a high impact 1 Introduction Personal objectives Key messages and learning objectives of the workshop 2 Presentation skills What does good look like? Exercise: Characteristics of high/low impact presentations Presenting yourself as a 'winner' The energy / attitude model Exercise: Being a winner 3 Preparation skills - eight steps to preparing a great presentation, plus Powerpoint tips •The magic circle• How to 'assume the role' when presenting• The eight steps• Step 1 - develop your objectives- The five questions that you must answer before preparing your presentation- Defining your objectives and outcomes- Creating a first draft- Step 1 exercise• Step 2 - analyse your audience- Doing your homework: audience, event, venue- Developing a pre-event check-list- Methods and means for researching your audience- Step 2 exercise• Steps 3 and 4 - structure the main body of your presentation and state the main ideas- Ways to structure your presentation for maximum impact- Balancing and managing content and topics- Organising your information: 6 options and methods- Your 'one main point' and creating a 30-second summary- Steps 3 and 4 exercises• Step 5 - decide on supporting information, using the toolkit- Making your case convincing: ways to support your claims- Selecting and using relevant and interesting examples- Quotes, case studies and printed material- Presenting statistics, tables and graphs- Ways of maintaining visual interest- Transitions and links, creating a 'golden thread'- Step 5 exercise: Creating compelling stories and anecdotes4• Step 6 - create an effective 'opening'- Claiming the stage and creating a good first impression- The three most powerful ways of opening a presentation- The five elements of a strong opening- Step 6 exercise: Participants work individually to prepare an opening, focusing onpersonal introduction, and then deliver to the group, with structured feedback• Step 7 - develop transitions- Step 7 exercise / examples• Step 8 - create an effective close- Signalling and sign-posting; the importance of, and how to do it effectively- Five ways to close a presentation successfully- Step 8 exercise / examples• Presentation design and Powerpoint- An interactive review of participants' own real-life past presentations and advanced tipsand techniques on using Powerpoint effectively 4 Facilitation skills The three main types of group activity - triads, teams and main group How to select the right activity, define the objectives, set it up and run the debrief Using energisers - with examples Exercise: Dealing with 'difficult' behaviours Exercise: Working in triads, design and deliver 5 Tips and tricks: presentation and facilitation 10 reasons why facilitation fails Five golden rules for success Defining the session goals and the facilitation plan Open and closed questions - why and when to use Using a 'car park' to manage unresolved issues Using AV aids - tips and tricks Exercises: Including participants working in pairs to prepare a short section form of one of their own presentations 6 Putting it all together Summary of key learning points Action plan