2422 Courses in Burnham-on-Sea

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

This is an essential programme for any member of staff whose role requires a high level of attention to detail. The focus is specifically on the handling of text and data, whether at the input stage or when collating information into reports and documents for use by others. The session looks at both prevention and cure. For 'prevention', it focuses on understanding how common errors occur and on developing an awareness of the factors which influence our level of attentiveness. It introduces key psychological theories around attentiveness including the 'capacity' and 'bottleneck filter' models. And it looks at how working styles can affect attention to detail. For 'cure', the programme looks at how to minimise the effect of stress on concentration as well as introducing a number of tools and techniques for promoting accuracy - at both the input and the checking stages. Particular attention is paid to proof-reading techniques. By the end of the session, participants will: Appreciate why errors occur Understand how stress and other factors can affect focus and accuracy Know how to improve accuracy and reduce errors when handling text and data Be able to proof-read text and number-based documents more accurately 1 The importance of accuracy The impact of mistakes Why accuracy is so important Main reasons why errors occur 2 Attentiveness theory The 'capacity' and 'bottleneck filter' models Selective attention Chunking - big picture / little picture 3 Preparing for accuracy Working styles - how they affect detail-orientation Identifying and minimising the impact of stress on concentration 4 Practical strategies How to improve accuracy and reduce errors when inputting text Managing interruptions and distractions Proofing text and numbers

Most people only use a fraction of Excel's capabilities. This workshop shows what you've been missing! This course will help participants: Nest formulas Get the most from pivot tables Use conditional formatting Write array formulas Explore the lookup functions Calculate by criteria Use 'goal seek' and 'scenario manager' for what-if analysis Record macros 1 Nesting formulas Principles of nesting formulas together Using IF with AND or OR to answer questions Nesting an AND function in an IF Nesting an OR function in an IF 2 Advanced pivot table reports Grouping dates, numerical and text items Running percentage analyse Running analyses to compare data Inserting Field calculations Finishing off with a user-friendly dashboard 3 Advanced conditional formatting Colour table rows based on criteria in it Applying colour to approaching dates Exploring the different rule types 4 Lookup functions Going beyond the VLOOKUP function Lookups that retrieve data from left or right The versatile INDEX and MATCH functions Retrieving data from columns with duplicates 5 Calculate by criteria Using SUMIFS to sum by criteria Finding an average by criteria with AVERAGEIFS Use SUMPRODUCT to multiply then add different values 6 What-if analysis Use Goal Seek to meet targets Forecast reports with the Scenario Manager 7 Recording Macros Macro security Understanding a Relative References macro Recording, running and editing macros Saving files as Macro Enabled Workbooks Introduction to VBA code Making macros available across workbooks Add a macro button to the Quick Access toolbar

This two-day programme gives the key insights and understanding of contracting principles and the impact they have on business and operations. The course is designed for individuals involved in or supporting contracting who want to improve their commercial management skills; individuals in functions such as project management, business development, finance, operations who need practical training in commercial management; general audiences wanting to gain a basic understanding of commercial management. This is an assessed programme, leading to the International Association for Contracts & Commercial Management (IACCM)'s coveted Contract and Commercial Management Associate (CCMA) qualification. The programme addresses 31 different subject areas, across the five stages of the contracting process. By the end of the course the participants will be able, among other things, to: Develop robust contract plans, including scope of work and award strategies Conduct effective contracting activities, including ITT, RFP, negotiated outcomes Negotiate effectively with key stakeholders, making use of the key skills of persuading and influencing and to work with stakeholders to improve outcomes Set up and maintain contract management systems Take a proactive approach to managing contracts Make effective use of lessons learned to promote improvements from less than optimal outcomes, using appropriate templates Develop and monitor appropriate and robust Key Performance Indicators to manage the contractor and facilitate improved performance Understand the approvals process and how to develop and present robust propositions Make appropriate use of best practice contract management tools, techniques and templates DAY ONE 1 Introductions Aims Objectives Plan for the day 2 Commercial context Explaining the contracting context Define the key objective The importance of contact management Impact upon the business 3 Stakeholders How to undertake stakeholder mapping and analysis Shared vision concept, How to engage with HSE, Finance, Operations 4 Roles and responsibilities Exploring the key roles and responsibilities of contract administrators, HSE, Finance, Divisional managers, etc 5 Initiating the contract cycle Overview of the contracting cycle Requirement to tender Methods Rationale and exceptions 6 Specifications Developing robust scope of works Use of performance specifications Output based SOW 7 Strategy and award criteria Developing a robust contract strategy Award submissions/criteria 8 Managing the tender process Review the pre-qualification process Vendor registration rules and processes Creation of bidder lists Evaluation, short listing, and how to use of the 10Cs© model template and app 9 Types of contract Classify the different types of contracts Call-offs Framework agreement Price agreements Supply agreements 10 The contract I: price Understanding contract terms Methods of compensation Lump sum, unit price, cost plus, time and materials, alternative methods Cost plus a fee, target cost, gain share contracts Advanced payments Price escalation clauses DAY TWO 11 Risk How to manage risks Risk classification Mitigation of contractual risks 12 Contractor relationship management session Effectively managing relationships with contractors, Types of relationships Driving forces? Link between type of contract and style of relationship 13 Disputes Dealing with disputes Conflict resolution Negotiation Mediation Arbitration 14 Contract management Measuring and improving contract performance Using KPIs and SLAs Benchmarking Cost controls 15 The contract II: terms and conditions Contract terms and conditions Legal aspects Drafting special terms 16 Managing claims and variations How to manage contract and works variations orders Identifying the causes of variations Contractor claims process 17 Completion Contract close-out process Acceptance/completion Capture the learning/HSE Final payments, evaluation of performance 18 Close Review Final assessment

The work of a technical team is invariably challenging and often unpredictable. Definition of the work can be problematic, timescales can be hard to estimate and the right technical approach difficult to select. Staff involved in this type of work usually have very high levels of specialist knowledge in their field and have high expectations of those who lead them. In addition to the challenges of the work, the team leader often has to balance the need for professional excellence with financial and commercial considerations and to ensure that team goals are realistic by being an effective negotiator with other project and senior managers. These characteristics make technical team leadership a demanding and complex activity. This programme aims to help participants develop the skills needed to become an effective technical team leader. The objectives of this programme are to help participants: understand the significance of leadership skills and their impact on team performance review the key skills needed to be an effective, 'multi-dimensional' team leader and learn how to develop, adapt and apply them in practice learn how to identify the preferred leadership style for the context and organisational culture and how to develop personal style versatility understand the role of the project leader in building an effective team and the skills required to promote and sustain team performance gain a better understanding of the interpersonal skills needed to motivate individual team members and harness the full potential of the team DAY ONE 1 Technical teams and leadership What is a leader? How much can leadership be learned? The team environment and the impact of leadership skills The characteristics of high performance teams and their leaders Some useful models and theories of leadership explored Types of leadership; choosing how to use leadership power Evaluating personal leadership style; how to develop style flexibility 2 Essential skills for team leaders 3 key dimensions of effective leadership: inwards, outwards and upwards Developing and promoting a 'team vision': strategic thinking skills The vital role of communication skills and how to develop them Understanding others; emotional intelligence skills Being a visible leader; behavioural and influencing skills Building effective relationships; the importance of trust and respect DAY TWO 3 Leading inwards to build the team The role of leadership in developing team performance Understanding individuals in the team; recognising team role preferences Managing conflict and promoting positive team dynamics Setting standards, maintaining discipline and rewarding performance Harnessing team potential: building motivation within the team Promoting team learning; the team leader as coach / mentor 4 Leading outwards and upwards to support the team Negotiating realistic team goals; effective influencing skills Gaining empowerment and support from the key stakeholders Leading upwards: knowing when and how to take the initiative Building team credibility within the organisation; helping the team deliver Becoming an effective team player in leadership teams Building and maintaining rapport with influential stakeholders

The aim of this course is to provide project managers, project engineers and project support staff with a toolkit they can use on their projects. The tools range from the simple that can be used on all projects to the advanced that can be used where appropriate. This programme will help the participants to: Identify and engage with stakeholders Use tools for requirements gathering and scope management Produce better estimates using a range of techniques Develop more reliable schedules Effectively manage delivery DAY ONE 1 Introduction Overview of the programme Review of participants' needs and objectives 2 Stakeholder management Using PESTLE to aid stakeholder identification Stakeholder mapping The Salience model Stakeholder engagement grid 3 Requirements management Using prototypes and models to elucidate requirements Prioritising techniques Roadmaps Requirements traceability 4 Scope management Work breakdown structures Responsibility assignment matrix 5 Delivery approaches Sequential Agile 6 Estimating Comparative estimating Parametric Bottom-up Three-point estimating Delphi and Planning Poker Creating realistic budgets DAY TWO 7 Scheduling Critical path analysis Smoothing and levelling Timeboxing Team boards Monte Carlo simulations Probability of completion 8 People management Situational Leadership The Tuckman model Negotiation Conflict management Belbin 9 Monitoring and control Earned value management 10 Course review and action planning Identify actions to be implemented individually Conclusion PMI, CAPM, PMP and PMBOK are registered marks of the Project Management Institute, Inc.

Agile project management, already widely used for software development, is increasingly recognised as having much more general application. Continuous improvement programmes, business change projects, new technology development, research and development and a variety of other scenarios characterised by rapid change and high uncertainty can all benefit from an Agile approach. This programme presents the concepts and methods of Agile project management, and shows how to apply them to a range of project and change management situations. Participants will learn: how Agile project management can help with project and change management the 4 values and 12 principles of the Agile 'manifesto' and the range of Agile methodologies how to apply Agile project management methods and techniques in a range of project scenarios alternative Agile project management methods and how they can be applied and adapted what makes Agile project teams succeed the key roles and responsibilities needed to enable Agile project teams to work effectively how to encourage an Agile mindset within their organisation and how to move toward an Agile approach to managing projects 1 Introduction to Agile project management Overview of 'classical' project management and methodologies The link between project success and management performance Limitations of classical approaches and the need for Agile methods The 4 values and 12 principles of the Agile manifesto explained Agile project management values:Individuals and interactions over processes and toolsWorking outputs over comprehensive documentationCustomer collaboration over contract negotiationResponding to change over following a plan The cultural challenges of using Agile project management Choosing when and how to adopt Agile project management 2 Initiating a project using Agile project management Some key Agile methodologies explained: SCRUM, XP, Crystal Identifying and engaging project stakeholders; defining roles and responsibilities Setting the project vision and goals; defining project scope The Agile approach to requirements capture and elicitation of needs Tools and techniques for capturing and characterising requirements The role of documentation, reporting and process management 3 The Agile approach to definition and planning Understanding Agile planning; the 'planning onion' concept Developing the culture needed for collaborative involvement and iterative planning Defining project deliverables; the 'product backlog' concept Tools and techniques for defining and prioritising requirements in Agile projects Understanding and applying Agile estimating techniques Dealing with uncertainty and managing risks 4 The Agile approach to execution and delivery The results orientated, fast adapting culture of Agile teams The monthly 'Sprint' process for project planning and review The disciplines needed for effective daily SCRUM meetings Reviewing progress, managing change and project reporting Testing, completing and handing over of work packages Managing the interface between the project team and the business 5 Leadership and teamwork in Agile project teams Why Agile teams are different: the importance of individuals and interactions The skills and attributes needed to lead an Agile project team The challenges faced and skills needed by Agile team members Recognising team development needs; adopting the right leadership style Making the transition from project manager to Agile coach Key coaching skills explored: mentoring, facilitating, managing conflict

'Selling' doesn't work. You've got to help customers buy. And that means engaging with the customer in a positive way, showing that you understand their requirement and giving them confidence that your product or service is the best possible way of meeting that requirement. This may sound painless but there's more to it than meets the eye and it's all too easy to get it wrong. You need to follow a process. This programme will help participants: Understand 'how buyers buy' and align their selling activities accordingly Recognise the difference between 'latent pain' and 'active vision' opportunities Conduct effective pre-call planning and research Stimulate interest and establish credibility with your prospects Get prospects to share / admit high priority pain Engage in consultative dialogue that promotes the differentiating strengths of your offerings Gain access to 'power' people within an opportunity Effectively qualify and disqualify opportunities based on objective decision criteria Better control and manage sell cycles Improve their chances of winning competitive opportunities Shorten sales cycles and avoid 'no decision' Negotiate the steps leading to a successful sale 1 An introduction to selling Understanding the key points that encourage a customer to purchase from us The difference between consultative selling and a transactional sale Understanding the roles that trust and empathy play in a sale Understanding how tricks and manipulation can sink a sale Vital pre-meeting research that must take place before a conversation Understanding how the customer sees us and why positioning is important 2 Structuring the sales conversation process Defining a set process for structuring a sales call with a chance to demonstrate understanding How the first minute of a conversation can destroy a sale Understanding BPO objectives for a sale How a step-by-step sales conversation process helps win more sales Understanding the mis-match between the customers buying process How our sales processes can lead to mistakes 3 How and why people buy An insight into the emotional factors behind how people arrive at purchasing decisions Using research from neuroscience that shows how sales people can really make mistakes Understanding how people make decisions about larger purchases Understanding the stakeholders in companies and their buying motives How to analyse the stakeholders and determine a win-plan 4 Understanding the funnel Studying the sales and buying process to understand the ratios of sales to prospects and better forecasting Understanding the role of forecasting in sales analysis Why many forecasts are nearly always wrong Understanding the stages of a sales process How 'verifiable outcomes' can really change forecasting 5 Questioning techniques Understanding the different questioning techniques and when they should be used Using the 'knowledge tree' as a framework for questioning Understanding the use of real empathy to help customers uncover their needs How effective research can really empower your questions How to ask 'high gain' questions How to ask difficult questions without feeling intrusive 6 Features and benefits How to practically apply them in a sales scenario How to align the benefits to customers' business goals Really understanding the difference and how to demonstrate true economic benefits to a customer How to discover business goals, and align value propositions to these How to craft an effective value proposition for a customer Using the SAR storytelling method to really engage customers to align their thinking patterns Using the latest neuroscience research that explains what customers are really thinking 7 Overcoming objections How 'confirmation bias' can hinder any sales conversation How the CLARA method of responding to customer concerns can dramatically improve the chances of customers responding to us in a positive way Practising the method to become comfortable and congruent with it 8 Closing the sale A deep dive into what closing is How different sales have different closes How too many closing methods can destroy a sale How to lead up to a close with a logical sequence of questions Using the ACSAT trust method of closing A clear methodology with a chance to practise the skills in a fun way

If you are a Mental Health First Aider or MHFA Champion you have skills for life that support you and the people around you. We believe that mental health should be treated equally to physical health - and just like physical first aid, Mental Health First Aid training should be kept up to date. The four-hour MHFA Refresher course will empower you to: Keep your awareness of mental health supports current Update your knowledge of mental health and what influences it Practice applying the Mental Health First Aid action plan Outline About mental health Stress and factors that influence mental health Mental health continuum and stigma Frame of reference and non-judgement Reintroducing ALGEE Warning signs of mental ill-health Depression and anxiety Suicide and first aid for suicidal crisis Psychosis and first aid for severe psychotic episodes Practising our MHFA sills Self-care, wellbeing and recovery

Mental Health First Aid (MHFAider) is an internationally recognised training course that teaches people how to spot the signs and symptoms of mental ill health and provide help on a first aid basis. We don't teach people to be therapists, but we do teach people how to respond in a crisis, and how to reach out before a crisis happens. The training gives people tools to support themselves and each other, so everyone can talk about mental health and seek help when needed. As an MHFAider you will be able to: Recognise those that may be experiencing poor mental health and provide them with first-level support and early intervention Encourage a person to identify and access sources of professional help and other support Practise active listening and empathy Have a conversation with improved mental health literacy around language and stigma Discuss the role in depth, including boundaries and confidentiality Practise self-care This course is ideal for those who would like to become an MHFAider to: Gain the knowledge and skills to spot signs of people experiencing poor mental health Be confident starting a conversation and signpost a person to appropriate support Alongside the best evidence-based Mental Health First Aid (MHFA) training, MHFAiders are also provided with three-year access to ongoing learning and support through the MHFAider Support App 1 Introduction to MHFAider (3 hours 30 mins) MHFA and the MHFAider role Introduction to the MHFAider Action Plan 'ALGEE' What is Mental Health? Helpful and unhelpful language Undersign our Frame of Reference, understanding how we make sense of the world Understanding stress & the Stress Container 2 Understanding Mental Health (4 hours) What influences mental health? The Mental Health Continuum What is anxiety? What is a traumatic event? Active listening and empathy What are eating disorders? What is self-harm? What is substance misuse? MHFA conversation practice 3 MHFAider in practice (4 hours) Applying ALGEE What is depression? What is suicide? What is psychosis? MHFA conversation practice 4 Next steps (3 hours) Recovery and lived experience Applying ALGEE Boundaries in the MHFAider role MHFA conversation practice Moving forward in the MHFAider role and your MHFA action plan Self-care