383 Relationships courses in Sheffield

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 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

Are you looking for something that will help you understand yourself and how to interact with others more effectively? Would you like something that uses a simple four colour model to quickly allow you to understand your personality type and how you can use this knowledge to enhance your relationships and reach your goals, whatever they are? We think that Insights Discovery might be just the thing for you! What's even better is that our Discovery bundle includes both a copy of your unique profile and a 90 minute personal session with our executive coach, Cami Rose, to chat it all through and set you up for success using your new knowledge for the future. Just request a session and we'll be in touch with the link that will allow you to complete the Insights evaluator and arrange your personal coaching session at a time to suit you. Want Discovery for your team? We can do that too. Leave us your name and details and we'll be in touch to chat through your needs and objectives.

QA Level 3 Award In Emergency Paediatric First Aid (RQF) This page is here if you'd like us to run this course for you and your people, at our venue or yours (within 45 minute drive from Chesterfield, Derbyshire). If you'd like us to run this course for you and you're further away, please contact us direct for a quote.   If, instead, you're interested in an open/public course, please go here. Full day course Would you know what to do if you saw a child in need of First Aid? Being able to deal with paediatric emergencies can make the difference between the life and death of children, and save them a lot of suffering Course Contents: The Roles and Responsibilities of an Emergency Paediatric First Aider Assessing an Emergency Situation Accident Recording Minor Injuries Cuts, Grazes and Bruises Minor Burns and Scalds Managing an Unresponsive Infant or Child Recovery Position CPR Safe Use of an AED (Automated External Defibrillator) Choking Anaphylaxis Seizures Wounds and Bleeding Shock Benefits of this course: Would you know what to do if you saw a child in need of First Aid? Children are prone to minor injuries, but suffer from serious injuries also In 2014, 2,269 children in the UK were so badly bitten by an animal they had to be admitted to hospital More than 2 million children have accidents in the home for which they're taken to A&E - every year, with Under 5s accounting for 7% of all hospital emergency treatments Being able to deal with peadiatric emergencies can make the difference between the life and death of children, and save them a lot of suffering. This QA Level 3 Award in Emergency Paediatric First Aid (RQF) qualification is ideal for: - Parents/carers or family members who want to learn key paediatric first aid skills - Those who work with children and are not required to comply with Ofsted’s Childcare Register or Early Years Foundation Stage (EYFS) 2014 requirements Those who want to provide additional support in their organisation to existing paediatric first aiders that are trained to meet Ofsted’s Childcare Register or Early Years Foundation Stage (EYFS) 2014 requirements. For those who will be directly responsible for children, Ofsted requires people to do our two day Paediatric First Aid course instead We also run a Paediatric Annual Refresher to keep those life-saving skills up to date Accredited, Ofqual regulated qualification: Our Emergency Paediatric First Aid at Work course is a nationally recognised, Ofqual regulated qualification accredited by Qualsafe Awards.This means that you can be rest assured that your Emergency Paediatric First Aid certificate will fulfill the legal requirements. It is a very good way to make sure you and your employees are trained in First Aid for Children and Infants (babies).The Ofqual Register number for this course is 603/0786/9

QA Level 3 Award In Paediatric First Aid (Annual Refresher) (RQF) This page is here if you'd like us to run this course for you and your people, at our venue or yours (within 45 minute drive from Chesterfield, Derbyshire). If you'd like us to run this course for you and you're further away, please contact us direct for a quote.   If, instead, you're interested in an open/public course, please go here. Half day course Have you already got a valid Emergency Paediatric First Aid or Paediatric First Aid certificate? Can you still remember everything you were taught? Ofsted and HSE highly recommend Paediatric Annual Refreshers to keep your skills and knowledge up to date! Course Contents: Managing an Unresponsive Infant or Child Adult, Child and Infant Recovery Position Infant and Child CPR How to use an AED on an Infant and Child Choking Adult, Infant and Child Wounds and Bleeding Shock Benefits of this course: Have you already got a valid Emergency Paediatric First Aid or Paediatric First Aid certificate? Can you still remember everything you were taught? This course is fully accredited, thus ensuring you have done your due diligence It is taught in a fun, engaging, hands on way, so you get lots of practice in You will really enjoy yourself while re-learning these life-saving skills Accredited, Ofqual regulated qualification: Our Paediatric First Aid (Annual Refresher) course is a nationally recognised, Ofqual regulated qualification accredited by Qualsafe Awards.This means that you can be rest assured that your Paediatric First Aid certificate will fulfill the legal requirements. It is a very good way to make sure you and your employees are trained in First Aid for Children and Infants (babies).The Ofqual Register number for this course is 603/3153/7

Managing for Growth is designed for anyone who has management and leadership responsibilities within an organisation. Suitable for newly promoted managers, team leaders and supervisors through to senior managers; the objective of the programme is to develop a culture that will translate strategy into measurable outcomes by engaging these leaders to facilitate change and innovation. The programme is extremely effective at giving managers the tools and skills to deliver sustainable change and business growth. It's also been proven to reduce costs and increase profit – even before the programme has ended.   Managing for Growth is built upon three aspects common to every job:   Managing Resources. Ensuring that the resources available are appropriate for the tasks for which they are required and are being used effectively. Learning how to control and coordinate a mix of available resources for maximum efficiency. Managing Relationships. Positively influencing people’s behaviour in order to motivate them and promote effective working. Focusing on listening skills, we share ways to improve communication and teamwork to get the best from both internal and external relationships. Controlling Routines. Investigating the processes/systems/routines/series of actions that are linked together to achieve a desired outcome. Recognising the importance of controlling, developing, simplifying and following routines.   Managing for Growth shows your team leaders, supervisors and managers how to cultivate a culture of teamwork and continuous improvement within your organisation.   Focus for Action Throughout the programme the participants take part in work-based activities that will cause them to evaluate every aspect of their job and identify areas for improvement. By the end of the programme, the participants act on these action lists and implement improvement projects that will deliver measurable results.   Continuous Improvement Managing for Growth sets the framework for continuous improvement by transferring skills and knowledge enabling your team leaders to translate organisational strategies into real, measurable outcomes.   Format Designed for groups of up to 6 people, the programme is spread over 4 months with the first 7 sessions being held every 2 weeks and the final session a month later. Each session lasts approximately 2 hours.

First Aid Sessions For Children And Young People Children are quite capable of applying First Aid to help others As a matter of fact, children as young as 3 have saved their parents' lives by staying calm and calling an ambulance These short sessions will cover a variety of subjects, depending on their age These sessions can be held as Mini Medics or as other sessions Session Contents: For younger primary school children, we tend to cover:Calling for HelpRecovery PositionChokingMinor Injuries For older primary school children, we tend to cover:Calling for HelpRecovery PositionCPR and Use of an AEDChokingMinor Injuries For secondary school pupils, we tend to coverCalling for HelpRecovery PositionCPR and Use of an AEDChokingMinor InjuriesBleeding Injuries Benefits of this course: In order to take part in our Qualsafe Awards Accredited training courses, one has to be 14 or 16 years old Younger children are quite capable of applying First Aid to help others As a matter of fact, children as young as 3 have saved their parents' lives by staying calm and calling an ambulance According to the Resuscitation Council UK, and the European Resuscitation Council, all school children should be taught how to perform CPR Therefore, we are teaching Children and Young People the basics of First Aid in small groups This QA Level 3 Award in Emergency Paediatric First Aid (RQF) qualification is ideal for:Parents/carers or family members who want to learn key paediatric first aid skillsThose who work with children and are not required to comply with Ofsted’s Childcare Register or Early Years Foundation Stage (EYFS) 2014 requirements We now also have the option of running these sessions as Mini Medics sessions Just ask! Accreditation These sessions will not be accredited. We are happy to create in-house certificates for the youngsters. We can also give the children a Mini Medics book and certificate if you like or prefer - this will incur an additional charge per child.

REFERENCE CODE 610/0134/X COURSE LEVEL NVQ Level 3 THIS COURSE IS AVAILABLE IN Course Overview Who is this qualification for? This qualification is aimed at those who are involved in either site carpentry including first and second fixing, those who are involved in shopfitting site work or those who carry out shopfitting bench work. The qualification is at level 3 although there may be some units at different levels. Level 3 qualifications are primarily aimed at those who are fully trained and experienced in a wide range of work activities, It is not expected that candidates working in this industry all do the same activities or use the same equipment and machinery so the qualification has been developed to make it as widely available as possible. All work completed must be carried out in accordance with Building Regulations and Industry recognised safe working practices, including the disposal of waste. The qualification is structured to ensure that there is a high degree of flexibility within the pathways and units available and will allow employees from companies of all sizes and specialisms equal opportunity to complete. The qualification consists of 3 pathways. What is required from candidates? Qualifications are also required to indicate the number of hours of teaching someone would normally need to receive in order to achieve the qualification. These are referred to as Guided Learning Hours (GLH). The GLH for this qualification is 404. Pathway 1 Site Joinery, Pathway mandatory units Level Credits Installing bespoke first fixing components in the workplace Installing bespoke second fixing components in the workplace Setting up and using transportable cutting and shaping machines in the workplace Erecting roof structure carcassing components in the workplace Confirming work activities and resources for an occupational work area in the workplace Developing and maintaining good occupational working relationships in the workplace Confirming the occupational method of work in the workplace Conforming to general health, safety and welfare in the workplace Pathway 1 Site joinery – Optional units minimum of 1 unit must be achieved Erecting structural carcassing components in the workplace Maintaining non-structural and structural components in the workplace Pathway 2-Shopfitting site work-Pathway mandatory units Marking out from setting out details for routine shopfitting products in the Summary of the: GQA LEVEL 3 NVQ DIPLOMA IN WOOD OCCUPATIONS (CONSTRUCTION) Installing shopfitting frames and finishings in the workplace Installing shopfitting fitments in the workplace Installing shopfronts and finishings in the workplace Setting up and using transportable cutting and shaping machines in the workplace Confirming work activities and resources for an occupational work area in the workplace Developing and maintaining good occupational working relationships in the workplace Confirming the occupational method of work in the workplace Conforming to general health, safety and welfare in the workplace Pathway 3 – Shopfitting-Bench Work – Pathway mandatory units Producing setting out details for routine shopfitting products in the workplace Marking out from setting out details for routine shopfitting products in the workplace Manufacturing routine shopfitting products in the workplace Confirming work activities and resources for an occupational work area in the workplace Developing and maintaining good occupational working relationships in the workplace Confirming the occupational method of work in the workplace Manufacturing bespoke shopfitting products in the workplace Setting up and using fixed machinery in the workplace Conforming to general health, safety and welfare in the workplace Pathway 3 – Shopfitting – Bench work – Pathway optional units a minimum of 1 unit must be achieved Producing CAD setting out details in the workplace Producing wood and wood-based products using computer numerically controlled/numerically controlled (CNC/NC) machinery in the workplace Producing setting out details for bespoke shopfitting products in the workplace Assessment Guidance: Evidence should show that you can complete all of the learning outcomes for each unit being taken. Types of evidence: Evidence of performance and knowledge is required. Evidence of performance should be demonstrated by activities and outcomes, and should be generated in the workplace only, unless indicated under potential sources of evidence (see below). Evidence of knowledge can be demonstrated though performance or by responding to questions. Quantity of evidence: Evidence should show that you can meet the requirements of the units in a way that demonstrates that the standards can be achieved consistently over an appropriate period of time. Potential sources of evidence: The main source of evidence for each unit will be observation of the candidate’s performance and knowledge demonstrated during the completion of the unit. This can be supplemented by the following types of physical or documentary evidence: Accident book/reporting systems Photo/video evidence Safety records Work diaries Training records Timesheets Audio records Telephone Logs Job specifications and documentation Meeting records Delivery Records Records of toolbox talks Witness testimonies Equipment Correspondence with customers Prepared materials and sites Notes and memos Completed work Please Note that photocopied or downloaded documents such as manufacturers or industry guidance, H&S policies, Risk Assessments etc, are not normally acceptable evidence for GQA qualifications unless accompanied by a record of a professional discussion or Assessor statement confirming candidate knowledge of the subject. If you are in any doubt about the validity of evidence, contact Oscar Onsite Academy

Are your sales people too stressed, running on adrenalin, perhaps driving towards burnout, struggling to reach targets? Wouldn't you rather they delivered consistently good performance, sustainable over longer periods of time, with less stress (for both them and you)? This uniquely empowering workshop will help your team develop naturally high levels of focus, energy and motivation. They will attain a sense of grounded euphoria, giving them a very distinct and ethical edge in selling. A one-day programme, it gives salespeople an introduction to the 'Natural Superheroes' concepts and resources, tools and techniques, to help them improve their sales performance - realising greater sales potential, developing deeper and more profitable client relationships, winning more business. Through this experience, sales teams gain: Information about profiling clients to instantly understand more about their deepest drives and true needs so they can be genuinely met and, where possible, exceeded Insights into deep, honest and very 'real' reasons for sales procrastination - participants are given specific workable strategies they can easily apply to overcome sales resistance, by tapping their natural motivational styles An understanding of communicating at the very highest levels with different people so they truly understand your sales message and have a significantly more positive sales experience A realisation of their very specific natural sales talents as individuals and as a team A deeper level of experience and understanding of what specifically drives their own behaviour and the behaviour of their clients - these unique insights explain not only how but exactly why people behave the way they do An experience of what it takes to be unshakeable under pressure and manage the sales processes and relationships to a positive outcome for all Brand-new insights into working with and handling difficult people across all levels of authority An understanding of the pitfalls and the psychological traps we set ourselves which cause unnecessary stress, anxiety and frustration on a daily basis and, in turn, limit our sales performance Access to very simple and practical tools that massively increase self-awareness, engender accountability and responsibility and develop emotional sales mastery 1 Introducing 'Natural Superheroes' for sales What is a 'Natural Superhero'? Defining emotional intelligence in the context of sales and why it is so important Knowing yourself - why most people don't know themselves at all and how we can understand exactly what drives our behaviour for the purpose of improving sales performance specifically Knowing exactly why others, and specifically clients and team members, behave the way they do - understanding the real motives behind people's good and bad behaviour in a sales meeting Simple steps to freeing yourself of any anxiety, pressure and false sense of limitation when selling Being yourself in sales - why this is not as easy as it sounds but how you can make it effortless How to take control of achieving the sales performance you really need and want for yourself and others Strategies that raise your self-awareness, increase an authentic and sustainable sense of self-confidence, in difficult situations and in moments of crisis 2 Understanding yourself, your team members and your customers - using the Enneagram Introducing the Enneagram and why it is so valuable to sales people and their clients Exploring the 9 types of motivational drives and why people have different reasons for buying from you Core types and wings - understanding the influence of other motivations either side of the core Enneagram type How to confirm the profile of your client - using celebrities from the world of politics, cinema, sports - we explore how to identify each type - what are their core drives, why have they arisen and how can we use these insights to help you in improving your sales performance The 3 levels of behaviour within your personal profile and that of your clients Lookalike Enneagram types - mistaken identities - how to avoid these traps when profiling your clients and your team How to communicate effectively in a sales environment with each of the different Enneagram types - communication strategies for positive impact on morale, performance and, ultimately, sales results How to interpret and make use of the results of your online personal profile - participants complete an online profile before the event and have the opportunity to analyse their results with a view to improving their sales performance How sales teams sabotage their own performance and that of other people within the team - and how to stop it Uncovering your particular edge in a sales role - what unconsciously trips you up as a sales person? How the Enneagram helps us in sustaining a truly great sales performance over time 3 Why positive thinking alone doesn't work in sales Why 'PMA' does not stand for positive mental attitude when selling - learn its alternative meaning that can serve you even more effectively in a sales role 3 steps and exercises that naturally increase PMA The value of making unconscious thinking conscious and how to do this without any pain or discomfort in a sales meeting Why each Enneagram type has a different experience of PMA in terms of their outward behaviour and how to know when you are maximising your sales performance 4 Measuring success How to measure the development of your individual profile as a sales person Development planning and review Into the future - how to continue your Natural Superhero development

QA Level 2 Award In Cardiopulmonary Resuscitation And Automated External Defibrillation (RQF) Full day course Gives learners the knowledge and skills to give CPR and use an AED safely Covers maintenance of AEDs (Automated External Defibrillators) Course Contents: The principles underlining basic life support The principles underlining resuscitation Different types of cardiac arrest Recovery Position CPR Choking Safe Use of an AED (Automated External Defibrillator) AED maintenance Benefits of this course: In the UK there are over 30,000 cardiac arrests a year outside of hospital But only less than one in ten survive to be discharged from hospital When someone has had a cardiac arrest, every minute makes a huge difference You can help save people's life by starting CPR as soon as possible, and use an AED (Automated External Defibrillator) to restart their heart This course helps to give you the skills and confidence to save people's lives, and make a huge difference not just to them, but also to their families and loved ones Accredited, Ofqual regulated qualification: Our Cardiopulmonary Resuscitation and Automated External Defibrillation course is a nationally recognised, Ofqual regulated qualification accredited by Qualsafe Awards. This means that you can be rest assured that your CPD & AED Certificate is a very good way to make sure you and your employees are trained in First Aid. And of course, all of our training courses are run in a fun and engaging, interactive and varied way, ensuring your employees have the skills and knowledge they need! The Ofqual Register number for this course is 603/2654/2 This page is here if you'd like us to run this course for you and your people, at our venue or yours (within 45 minute drive from Chesterfield, Derbyshire). If you'd like us to run this course for you and you're further away, please contact us direct for a quote.   If, instead, you're interested in an open/public course, please go here.