5378 Learning courses

This programme has a simple objective: to help a sales team create and implementa comprehensive account development plan. If you want to earn strategic partner or preferred supplier status with your clients and customers then you need to add value to their business, consistently, and you can only do this if you have a plan - a key account management plan. This programme will help participants: Discover opportunities - through a deeper understanding of the customer's business Develop partnership - through a better 'value proposition' for the customer Increase repeat business - based on higher customer satisfaction Improve synergy - by getting everyone to 'sing from the same hymn sheet' Develop a collaborative account plan - validated by the customer and their own management Secure resources - management will align resources to execute soundly based account plans Win an increased share of 'customer wallet' - through systematic account development 1 The six principles of strategic account development Introduction to the PROFIT account development model:- Performance- Relationships- Objectives and goals- Feedback- Integration- Teamwork Practical account development strategies: overview and case studies 2 Performance Use practical tools to help you manage and measure account performance and success Design and build a monthly account dashboard for all sizes of account Prioritise and manage accounts and customers pro-actively and successfully, using proven planning tools Develop a cross-selling strategy to integrate products or solutions into the customer's business as closely as possible 3 Relationships How to build and manage key relationships within an account Qualifying and managing key influencers accurately Producing a 'relationship matrix' for each account quickly and easily Approaching and developing new contacts strategically Tools and techniques for successful tracking of contacts and call-backs Developing a coach or advocate in every customer organisation pro-actively 4 Objectives and goals Where are you now? - how to establish your competitive position within an account Know how to set, monitor and track key objectives for accounts over the short, medium and long term Selling against the competition - developing both long- and short-term sales strategies 5 Feedback - building loyal and satisfied customers The correct way to manage customer expectations and create listening loops within an account How to monitor and track your customer's perception and satisfaction with your organisation Building a personalised satisfaction matrix for each account Customer review meetings - best practice in building loyalty by regular joint planning events Understanding the concept of long-term customer value and the importance of adapting a customer-focused attitude 6 Integration How to integrate your products or solutions with the customer's business needs and processes Spot and react to early warning signals that may cause an account's loyalty to fade, reduce revenue or switch to a competitor Developing a loyalty strategy for key accounts or groups of smaller accounts Getting your message and strategy across to C-level contacts 7 Teamwork Working with others to achieve your account goals Gaining internal commitment from your organisation Managing and working with a virtual team Creating cross-departmental communication loops 8 Putting it all together Personal account reviews Personal learning summary and action plans

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

REFERENCE CODE 601/4322/8 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 Plastering activities in the workplace. It is not expected that candidates working in this industry all do the same activities so the qualification has been developed to allow opportunities for those carrying out work in either solid or fibrous Plastering. Those taking the qualification must also prove knowledge and competence in working at heights, calculating quantities and wastage and the use of powered and hand tools and equipment. All work completed must be done 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 units available and will allow employees from companies of all sizes and specialisms equal opportunity to complete. See the qualification Rules of Combination for more details on the specific skills required. In addition to this qualification there is a Level 2 qualification in Plastering and a number of other Construction and Construction related qualifications available through Oscar Onsite Academy. What is required from candidates? GQA qualifications are made up of a number of units that have a credit value or credits. This qualification consists of 4 mandatory units and 2 pathways, Solid and Fibrous. The qualification mandatory units have a total credit value of 31 credits-in addition the Solid plastering pathway requires achievement of 54 credits from the pathway mandatory units and a minimum of 14 credits required from the pathway optional group, giving a total of 99 credits. The fibrous plastering pathway requires achievement of all of the qualification mandatory units (31 credits) 45 credits from the pathway mandatory units and a minimum of 16 credits required from the pathway optional group a total of 92 credits for this pathway. The units are made up of the things those working in these job roles need to know to be able to do to carry out the work safely and correctly. These are called Learning Outcomes, and all must be met to achieve the unit. Mandatory units Level Credit 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 Additional units A/600/7882 Producing Granolithic Paving Work in the Workplace Producing Specialised Plasterer’s Surfaces in the Workplace 3 29 Pathway C – Solid – Pathway C1 – Solid Mandatory Units (54 credits) Producing Complex Internal Solid Plastering Finishes in the Workplace 3 27 Producing Complex External Rendering Finishes in the Workplace 3 27 Pathway C2 – Solid Optional Units – candidates must achieve a minimum of 14 credits Installing Direct Bond Dry Linings in the Workplace Installing Mechanically Fixed Plasterboard in the Workplace Running In-situ Mouldings in the Workplace Pathway D – Fibrous – Pathway D1 – Fibrous Mandatory Units (45 credits) Producing Complex Plasterwork Moulds in the Workplace Summary of the: GQA LEVEL 3 NVQ DIPLOMA IN PLASTERING (CONSTRUCTION) Installing Complex Fibrous Plaster Components in the Workplace 3 18 Pathway D2 – Fibrous Optional Units – candidates must achieve a minimum of 16 credits Running In-situ Mouldings in the Workplace 3 25 Repairing Complex Fibrous Plaster Components in the Workplace 3 16 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: Suggested sources of evidence are shown above, these can be supplemented by physical or documentary evidence, e.g. Accident book/reporting system Notes and memos Safety record Telephone/e-mail records Training record Customer and colleague feedback Audio evidence Records of equipment and materials Witness testimonies Work records Photographic/ video evidence 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 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, please contact Oscar Onsite Academy

SAP Training Online | Sap Training in London, UK What is SAP? SAP is one of the largest ERP(Enterprise Resource Planning) software in the world. It provides end to end solution for Financials, Manufacturing, Logistics, Distributions etc. SAP applications, built around their latest R/3 system, provide the capability to manage financial, asset, and cost accounting, production operations and materials, personnel, plants, and archived documents. The R/3 system runs on a number of platforms including Windows and MAC and uses the client/server model. SAP Career Potential You can become a SAP consultant. SAP consultants analyze, design, and configure new computer software and systems in accordance with their employers' or clients' specifications, as well as write programs such as forms, specifications, and interfaces. They also test new interfaces to ensure that system workflows are optimized and interact with end-users to make changes as requested and obtain feedback. As a SAP consultant, you could expect to earn £80,000-£150,000 per year. Which SAP Module Osborne Training offers training on various sap modules such as  Financial and Controlling Sales and Distribution Material Management CRM SRM HANA And many more... Study Options Instructor-Led Live SAP Online Training Students attending training through Online LIVE Training have a real-time, Live Instructor-Led student experience through the world-class Virtual Learning Campus. Online LIVE Training provides an engaging live classroom environment that allows students to easily interact with instructors and fellow students virtually. Classroom-Based Live SAP Training in London Osborne Training offers evening sessions for classroom-based training, where an experienced Tutor/Consultant goes through the whole SAP Training course from the London campus. Only selected modules are offered from the London campus. Free Certification from Osborne Training on completion. You may attempt for SAP certification exams online to get certificate directly from SAP. Syllabus varies depending on the module take. Please send a query to receive full syllabus information.

Whether you have to chair a meeting, pitch a proposal or speak at a conference you need good communication and presentation skills. Addressing a group of people with assurance and confidence does not come naturally to everyone. Our presentation skills training courses will teach you how to conquer your fears and give a successful and memorable performance. We will tailor the training to your specific needs, from coaching before an important keynote or honing your pitch to improving your negotiation and influencing skills, or learning how to network effectively. A typical course can cover: Recognising the strengths of your own communication style Using the different elements of voice and body language effectively Conquering your nerves and use body language to your advantage Pitching presentations so they meet your audiences’ needs Structuring a presentation so the audience is engaged from start to finish Using visual aids Handling questions All our presentation skills training is bespoke, with options including one-to-one coaching, combined training and coaching programmes and group training courses. All these courses can be delivered virtually, as well as face to face. As many of the skills needed to give a good presentation are shared with media interviews, we frequently combine our presentation skills and media interview skills training. Venue We deliver courses in the most appropriate format for your circumstances – whether face to face or online. Face to face courses are portable: they can be held in purpose-built studios, at your own offices or at an external venue. In the latter two cases, we create a mock studio for the practical exercises. Online courses give you flexibility and enable you to offer training to delegates from all over the world. We have run virtual courses for people from the Far East, South Asia, North America and Europe, as well as the UK.

Are you, or your company in need of high quality first aid training? Do you require excellent training to fully support colleagues in the workplace? MHA Training Ltd would love to help with any of these requirements. MHA Training is approved by Qualsafe Awards, an Awarding Organisation recognised by Ofqual. This means we can offer regulated Qualifications in these courses. All of our courses are aimed to help employers to comply with the Health & Safety (First Aid) Regulations. First Aid Training is required by who? A knowledge of basic first aid can make the difference between life and death. Studies have shown that effective first aid can be vital in the first few minutes after an emergency. There are plenty of success stories in the media about this training saving lives as it’s such an important life skill. A first aid qualification can help your resume, CV, or even open up job opportunities. There may also be opportunities to volunteer using your first aid skills. It has been a vital life skill that people have used for members of their own family not just in the workplace. The 3 main goals are to preserve life, prevent worsening and promote recovery. You never know when the need will arise to put these skills to use. The First Aid Training experience. A First Aid training course should be an interactive fun learning experience, not all chalk and talk. This is achieved by using fully qualified trainers/assessors, who are very experienced “hands on” training professionals. Our trainers are sympathetic to the needs of the individual trainee and adept at getting the best possible standard from the delegates. First Aid At Work Regulations: In the event of injury or sudden illness, failure to provide first aid could result in a casualty’s death. The employer should ensure that an employee who is injured or taken ill at work receives immediate attention. HSE will prosecute in cases where there is a significant risk, a disregard for established standards or persistent poor compliance with the law. HSE First Aid at Work – IMPORTANT! After 1st October 2013 the HSE is no longer responsible for approving providers of First Aid at Work courses. Providers must be approved by an Ofqual or SQA Awarding Body. MHA Training Ltd fully meets all of the new requirements. MHA Training has been established for 15 years, based at our training centre in Warrington, Cheshire. We provide an array of services On-Site also for clients around the North West in areas such as Manchester, Liverpool, Widnes, St Helens, Runcorn, Wigan, Preston and Leeds. Over the years we have expanded and have instructors available Nationwide.

This course is accredited by the National Vocational Driving Instructor’s Register. This intensive course is designed for experienced drivers wishing to become an instructor or someone who has been assigned as an assessor within their organisation wishing to upskill.

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 leadership role of the project manager is increasingly recognised as a key determinant in delivering success. These skills can often be critical in project situations, where tight budgets and deadlines demand the highest levels of team performance and where the working environment presents fresh challenges on a daily basis. This programme focuses on the leadership skills required of project managers and will benefit anyone involved in managing projects large or small wishing to extend or enhance those skills. The objectives of this programme are to help the participants: Understand the significance of leadership skills to the project manager and the impact of these skills on project performance Review the key skills needed to be an effective 'multi-dimensional' project 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 of a project 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 Introduction Aims and objectives Personal objectives 2 Project management and leadership What is a leader? How much can leadership be learned? The project environment and the impact of leadership skills The characteristics of high performance project teams and their leaders 3 Principles of effective leadership 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 4 Syndicate case study: Leadership in action Review of the role of leadership in a contemporary project Feedback and plenary discussion: effective project leadership 5 Team exercise: Leadership skills of the project manager Teams compete in performing a project simulation Project review and feedback Discussion of the outcome: role and skills of the project leader 6 Leadership skills for project managers The 3 dimensions of project leadership: inwards, outwards, and upwards The vital role of communication skills and how to develop them Developing a 'project vision': strategic thinking skills Understanding others; emotional intelligence skills Being a visible leader; behavioural and influencing skills Building effective relationships; the importance of trust and respect DAY TWO 7 Leading the project team The role of leadership in developing team performance Understanding individual strengths; 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 8 Leading through the organisation Gaining the support others; developing effective influencing skills Getting empowerment from key stakeholders Knowing when and how to take the initiative and lead Building and maintaining rapport with key partners Becoming an effective team player in leadership teams Becoming a business leader; leading colleagues and co-workers 9 Team exercise: Leadership and negotiation Teams engage in a negotiation exercise Exercise review and feedback Discussion of the outcome: negotiation skills of the project leader 10 Negotiation skills for project leaders Characteristics of effective negotiators Classic problem behaviours and mind-sets to avoid Getting to win-win; building partnership and trust 11 Leading more senior stakeholders The challenges and skills of leading and managing upwards Communicating with more senior stakeholders; building credibility Negotiating upwards: knowing when and how The role of networking skills; building and maintaining rapport Handling disagreements; the art of diplomacy Handling personality and style conflicts with more senior people

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