17135 Other courses in Pontypridd delivered Online

About this Training Course Geomechanical evaluations are about the assessment of deformations and failure in the subsurface due to oil & gas production, geothermal operations, CO2 storage and other operations. All geomechanical evaluations include four types of modelling assumptions, which will be systematically addressed in this training, namely: 1. Geometrical modelling assumption: Impact of structural styles on initial stress and stress redistribution due to operations 2. Formation (or constitutive) behaviour: Linear elastic and non-linear behaviour, associated models and their parameters, and methods how to constrain these using 3. Initial stress: Relation with structural setting and methods to quantify the in-situ stress condition 4. Loading conditions: Changes in pore pressure and temperature on wellbore and field scale This 5 full-day course starts with the determination of the stresses in the earth, the impact of different structural styles, salt bodies, faulting and folding on the orientation of the three main principal stress components. Different (field) data sources will be discussed to constrain their magnitude, while exercises will be made to gain hands-on experience. Subsequently, the concepts of stress and strain will be discussed, linear elasticity, total and effective stress and poro-elasticity in 1D, 2D and 3D, as well as thermal expansion. Participants will be able to construct and interpret a Mohr-circles. Also, different failure mechanisms and associated models (plastic, viscous) will be discussed. All these concepts apply on a material point level. Next, geomechanics on the wellbore scale is addressed, starting with the stress distribution around the wellbore (Kirsch equations). The impact of mudweight on shear and tensile failure (fracturing) will be calculated, and participants will be able to determine the mudweight window stable drilling operations, while considering well deviation and the use of oil-based and water-based muds (pore pressure penetration). Fracturing conditions and fracture propagation will be addressed. Field-scale geomechanics is addressed on the fourth day, focussing on building a 3D geomechanical model that is fit-for-purpose (focussing on the risks that need evaluation). Here, geological interpretation (layering), initial stress and formation property estimation (from petrophysical logs and lab experiments) as well as determining the loading conditions come together. The course is concluded with interpretation of the field-wide geomechanical response to reservoir depletion with special attention to reservoir compaction & subsidence, well failure and fault reactivation & induced seismicity. Special attention is paid to uncertainties and formulating advice that impacts decision-making during development and production stages of a project. This course can also be offered through Virtual Instructor Led Training (VILT) format. Training Objectives Upon completing of this course, the participants will be able to: Identify potential project risks that may need a geomechanical evaluation Construct a pressure-depth plot based on available field data (density logs, (X)LOT, FIT, RFT) Employ log-based correlation function to estimate mechanical properties Produce a simplified, but appropriate geometrical (layered, upscaled) model that honours contrasts in initial stress, formation properties and loading conditions, including Construct and interpret a Mohr-circle for shear and tensile failure Calculate the mud weight that leads to shear and tensile failure (fracturing conditions) Identify potential lab experiments to measure required formation properties Describe the workflow and data to develop a field-wide fit-for-purpose geomechanical model Discuss the qualitative impact of pressure and temperature change on the risk related to compaction, well failure, top-seal integrity and fault reactivation Target Audience This course is intended for Drilling Engineers, Well Engineers, Production Technologists, Completion Engineers, Well Superintendents, Directional Drillers, Wellsite Supervisors and others, who wish to further their understanding of rock mechanics and its application to drilling and completion. There is no specific formal pre-requisite for this course. However, the participants are requested to have been exposed to drilling, completions and production operations in their positions and to have a recommended minimum of 3 years of field experience. Course Level Intermediate Trainer Your expert course leader has over 30 years of experience in the Oil & Gas industry, covering all geomechanical issues in the petroleum industry for Shell. Some of his projects included doing research and providing operational advice in wellbore stability, sand failure prediction, and oil-shale retortion among others. He guided multi-disciplinary teams in compaction & subsidence, top-seal integrity, fault reactivation, induced-seismicity and containment. He was also involved in projects related to Carbon Capture Storage (CCS). He is the founding father of various innovations and assessment tools, and developed new insights into the root causes seismicity induced by Oil & Gas production. Furthermore, he was the regional coordinator for technology deployment in Africa, and Smart Fields (DOFF, iField) design advisor for Shell globally. He was responsible for the Geomechanical competence framework, and associated virtual and classroom training programme in Shell for the last 10 years. He served as one of the Subject Matter Expert (SME) on geomechanics, provided Technical Assurance to many risk assessments, and is a co-author of Shell's global minimun standard on top-seal integry and containment. He has a MSc and PhD in Civil Engineering and computational mechanics from Delft University of Technology, The Netherlands. Training experience: Developed and delivered the following (between 2010 and 2020): The competence framework for the global geomechanical discipline in Shell Online Geomechanical training programs for petroleum engineers (post-doc level) The global minimum standard for top-seal integrity assessment in Shell Over 50 learning nuggets with Subject Matter Experts Various Shell virtual Geomechanical training courses covering all subjects Developed Advanced Geomechanical training program for experienced staff in Shell Coaching of KPC staff on Geomechanics and containment issues on an internship at Shell in The Netherlands, Q4 2014 Lectured at the Utrecht University summer school (The Netherlands, 2020) on induced seismicity among renowned earthquake experts (Prof. Mark Zoback, Prof. Jean-Philippe Avouac, Prof. Jean-Pierre Ampuero and Prof. Torsten Dahm) (https://www.nwo.nl/onderzoeksprogrammas/deepnl/bijeenkomsten/6-10-juli-2020-deepnl-webinar-series-induced-seismicity) Lectured at the Danish Technical University summer school (Copenhagen, 2021) summer school on Carbon Capture and Storage (https://www.oilgas.dtu.dk/english/Events/DHRTC-Summer-School) Virtual Carbon Capture and Storage (CCS): Project Risks & How to Manage Them training course (October and November 2021) POST TRAINING COACHING SUPPORT (OPTIONAL) To further optimise your learning experience from our courses, we also offer individualized 'One to One' coaching support for 2 hours post training. We can help improve your competence in your chosen area of interest, based on your learning needs and available hours. This is a great opportunity to improve your capability and confidence in a particular area of expertise. It will be delivered over a secure video conference call by one of our senior trainers. They will work with you to create a tailor-made coaching program that will help you achieve your goals faster. Request for further information post training support and fees applicable Accreditions And Affliations

About this Training Course Whether you are maintaining an oil rig or processing plant, good quality maintenance is critical to delivering a safe reliable product to your customers. Whatever your level of maintenance experience, this course will equip you with the valuable skills and understanding that will enhance your maintenance career. Too often the maintenance department is seen as the cause of why assets are unavailable, in poor condition yet are costing too much to maintain. By comparison, pace setting companies see maintenance as adding value to their assets and employ an integrated, holistic approach to their maintenance activities. This course will help you move towards that pace setting performance. This course is based on an integrated maintenance model that has been used by leading companies and consultants with success and recognised as best practice. Participants will learn the total impact that maintenance can have on a business, identify key elements (and value) of effective maintenance for their own plants to not only reduce costs but also improve performance. The critical types of maintenance will be covered from day-to-day activities to shutdowns and reliability improvement. The course will break down traditional functional boundaries and encourage a holistic approach to maintenance. With an organisation's maintenance process only as good as its weakest link, this course will guide participants through all the key steps of a maintenance process and its supply chain. Participants will understand what is considered a good standard for each step in the maintenance process, how to identify the weakest links and subsequently how they can accelerate their performance improvement. Participants will have the option of gaining a Bronze Level qualification from the Academy of Turnarounds Operations of Maintenance. For those who obtain a pass, they will receive a Pass certificate and for those who achieve the top quartile score, they will receive a Distinction level pass. This course can also be offered through Virtual Instructor Led Training (VILT) format. Training Objectives By the end of the course, participants will be able to: Explain the challenges and objectives facing maintenance organisations today Demonstrate the importance of work order systems and use techniques for time estimations and priority assignments Prepare a preventive maintenance program Apply project management techniques to effectively manage major maintenance activities and shut downs Use capital budgeting techniques to evaluate maintenance capital expenditures Demonstrate understanding of how to maintain the optimal stock levels of spare parts to ensure operational continuity Prepare the right Key Performance Indicators (KPIs) to evaluate and improve performance in maintenance Target Audience This course is not just for maintenance professionals. Maintenance teams cannot perform without effective integration with operations and supply chain functions. Availability losses are often caused by operations or design issues and pace setting companies have generated significant benefits by integrating operation and maintenance strategies and working more collaboratively. This course will help all members of the operations and maintenance teams and their supply chain better understand their respective roles in ensuring that maintenance is benefitting and not inhibiting their business. Course Level Basic or Foundation Trainer Your expert course leader is a highly experienced facilitator in maintenance improvement, change management, continuous improvement and capability development as a management coach and trainer. He has a strong focus on people with an emphasis on developing people and the practicalities of improving maintenance performance rather than just the theory. He has worked internationally across Europe, America, the Middle East and Africa with extensive experience in Oil and Gas, the Chemicals sector and manufacturing as well as working with clients in Steel and Power Generation. As a result, he can bring best practice from a wide variety of sources. He spent the first fifteen years of his career as a specialist trainer working for companies such as Lloyds British Training Services and Rolls Royce. He then went on to work as a Principal consultant for ABB consulting for 15 years. During this time, he refined some of the established improvement tools including how and when to apply them for maximum impact whilst still continuing to develop and deliver training in support of this. Recent work has included improvements to the Work Order to Work Execution processes of Engineering departments and focused on Reliability, Planning and Scheduling. This ongoing field experience has helped him test and refine specialist training in a number of areas. He has been able to use his own experience to contribute with other maintenance specialists to the Carcharodon models of excellence. Its methodologies are recognised as 'Best of the Best' standards providing the inspiration for two books, projects that have won awards such as the prodigious UK Chemical Industries annual Excellence in Engineering award and form the basis of this training. He was recently awarded a national award as coach of the year. He uses the same skills to ensure that he does not just preach maintenance best practice, he discusses it, explains it and ensures that delegates have a much more personal and flexible experience. POST TRAINING COACHING SUPPORT (OPTIONAL) To further optimise your learning experience from our courses, we also offer individualized 'One to One' coaching support for 2 hours post training. We can help improve your competence in your chosen area of interest, based on your learning needs and available hours. This is a great opportunity to improve your capability and confidence in a particular area of expertise. It will be delivered over a secure video conference call by one of our senior trainers. They will work with you to create a tailor-made coaching program that will help you achieve your goals faster. Request for further information post training support and fees applicable Accreditions And Affliations

Effective Personal Productivity will help you in four crucial areas: Become highly organised and effective in your own area of day-to-day responsibility. Set and track personal and team goals, manage priorities and hit project deadlines. Improve delegation and communication skills, ensuring the right work is done the right way by the right people. Identify areas for continual improvement in and outside of work and implement strategies to maintain a healthy, well-balanced life.

Duration 2 Days 12 CPD hours Overview What is JIRA Software? Managing agile projects using JIRA Software Managing project backlog Managing iterations / sprints Managing releases / versions Managing project components Managing security Managing fields and screens Managing custom issue types Viewing various burn-down/burn-up reports This course introduces students to JIRA Software which is one of the most popular agile project management tool. Agile methods help in accelerating the delivery of initial business value. Continuous planning and feedback ensures that value is maximized throughout the development process. JIRA Software lets you manage project backlog, plan and execute sprints, and manage releases. It also lets you view useful reports, such as, velocity, various burndown / burn-up charts. Navigating JIRA Connecting to JIRA Software JIRA Account System Dashboard Sidebars Global Sidebar Search Help Dashboards Projects Boards Issues Project Sidebar Summary Managing Projects What is a Project? What is a Project (Contd.)? Backlog Sprints Versions / Releases Issues What is Component? Project Name and Key Project Key Format Editing Project Key Caveats Editing Project Key Deleting Project Summary Managing Versions What is Version What is Version (Contd.)? Merging Versions Other Version Options Version Fields What is Version? Summary Managing Issues Issues What are Epics? Epics ? Types Creating a new Epic What is a Story? Creating a Story Story Estimation Tasks Sub-tasks Summary Managing Sprints Sprints What is typically done in Sprint Planning? Velocity Agile Board Sprint Naming Convention Sprint Execution Summary Search & Using JQL Search Search Types JQL JQL Examples Sharing search result Save Search and Reuse in a Board Summary Working with JIRA Dashboards and Reports What is a JIRA Dashboard? Creating a JIRA Dashboard Choosing a Dashboard Layout What is a Gadget? Gadgets Available Out-of-the-box Adding a Gadget to a Dashboard Adding a Gadget to a Dashboard (Example Calendar Gadget) Moving a Gadget Removing a Gadget from a Dashboard Viewing Dashboard as a Wallboard Deleting a Dashboard JIRA Reports Generating a JIRA Report Generating a JIRA Report (Example ? Burndown Chart) Viewing the Burndown Chart Report Categories Available Out-of-the-box Agile Reports Issue Analysis Reports Forecast & Management Reports For further details ? Summary Jira Agile Common Jira Software boards Scrum Agility Kanban Scrum vs. Kanban Scrumban History of Kanban Kanban for software teams Kanban boards Kanban boards (Contd.) Kanban cards The benefits of Kanban Planning flexibility Shortened time cycles Fewer bottlenecks Visual metrics Continuous Delivery Kanban ? Kanban backlog Summary Miscellaneous Issue Features Voting Watching an Issue Adding/Removing Labels Linking Issues Linking Issue (Contd.) Commenting on Issue Attaching a File to an Issue Attaching a File to an Issue (Contd.) Cloning (Copying) an Issue Cloning (Copying) an Issue (Contd.) Cloning (copying) an Issue (Contd.) Viewing an Issue?s Change History Viewing an Issue's Change History (Contd. Summary Managing Fields & Screens (OPTIONAL: TIME PERMITTING) Fields OOB Fields Custom Fields Field Type Screens Summary

Getting Started The CMI Level 5 Extended Diploma in Management and Leadership course is designed for practising or aspiring middle managers and leaders at operations, division, departmental or specialist level, who are typically accountable to a senior manager or business owner. Leading and managing individuals and teams to deliver in line with the organisational strategy is the primary role of a practising manager. You'll develop the core strategic skills and competencies required to manage teams and individuals effectively, enabling you to deliver long-lasting results. The CMI Level 5 Extended Diploma in Management and Leadership is an extensive course focusing on improving your capabilities and core management skills such as planning, problem-solving, leadership, strategy, communication, conflict, resource management and organisation. Achieving the CMI Level 5 Extended Diploma in Management and Leadership qualification will enhance your credibility and enable you to outperform in demanding roles and situations. You'll have a wide range of modules to choose from, and depending on your career goals, you can select the modules that will be most effective for your progression. Key Benefits For Learners: Improve your capabilities and core management skills Develop the knowledge and skills required for managing and leading individuals and teams Provide an extensive knowledge of skills to excel in specific management areas For Organisations: Deliver aims and objectives in line with wider organisational strategy Provide you with a fully wider range of skills and knowledge required to be a manager as part of an organisation Focus on the areas that are most appropriate to your role and organisation. Key Highlights Are you an aspiring Manager or Leader looking for career development? Then, the CMI Level 5 in Management and Leadership qualification offered by the School of Business and Technology London is the right solution for you. Remember! The assessment for the qualification is done based on assignments only, and you do not need to worry about writing any exam. With the School of Business and Technology London, you can complete the qualification at your own pace, choosing online or blended learning from the comfort of your home. Learning and pathway materials and study guides developed by our CMI-approved tutors will be available around the clock in our cutting-edge learning management system. Most importantly, at the School of Business and Technology London, we will provide comprehensive tutor support through our dedicated support desk. If you choose your course with blended learning, you will also enjoy live sessions with an assigned tutor, which you can book at your convenience.   Career Pathways The CMI Level 5 Management & Leadership can open many career pathways including, but not limited to: Operations Manager, with an estimated salary of £51,577 per annum Divisional Manager, with an estimated salary of £48,613 per annum Departmental Manager, with an estimated salary of £34,997 per annum Regional Manager, with an estimated salary of £51,372 per annum About Awarding Body Chartered Management Institute established over 60 years ago as the British Institute of Management back then; it has developed the UK's very first diploma in management studies. In the years that followed CMI has consistently been at the forefront of all aspects of management and leadership. Today CMI is the only chartered professional awarding body committed to offering the highest standards in management and leadership excellence. Presently over 100,000 managers use its unique services daily. CMI qualifications aim for managers and leaders at any level, and it remains the only Awarding Body which can award Chartered Manager status - the ultimate management accolade. Employers highly value the qualifications awarded by CMI, and boost your career prospects. What is included? Learn 100% online at your own pace Dedicated support from expert tutors Dedicated Support Desk Portal: You can raise queries, request tutor support and ask for a call back whenever you need guidance and assistance. Elevate Knowledge: Your tutors will provide formative assessment feedback for each module, helping you improve your achievements throughout the program Schedule online personal tutor meetings whenever you want, which will help you get the most out of your studies and provide guidance, support and encouragement 18 months support period 24-hour access to the online learning platform 'MyLearnDirect' Schedule live online classes for each module at your convenience. (Blended learning only) Quality learning resources and study guides developed by CMI-approved tutors. All assessment materials are conveniently accessible through the online learning platform 'MyLearnDirect' Induction: We offer online and flexible learning induction to help you settle in and prepare for your online studies Get Foundation Chartered Manager status upon course completion Fast Track to Chartered Manager status. You will be eligible to apply for Chartered Manager status, the ultimate professional accolade for managers, after completing the course and with 3+ years of experience in a managerial role. Access to CMI Management Direct. It has 100,000s of reliable and validated management and leadership resources, including company and industry reports, videos, checklists, E-books, and journals. You have access to CMI Membership and Support for the duration of your study. Assessment For each module you study, you will complete a written assignment of 3000 to 4,000 words and submit it online at your MyLearnDirect learning portal. The submitted assignments will be assessed by your CMI-approved tutor. Entry Requirements This course is designed for current or aspiring mid-level managers. You don't need any formal qualifications to study this course. However, to be eligible for this course, you must:  Be 19 years of age and over Have some team leading or supervisory experience or managerial experience in the junior or middle management level Possess the ability to complete the Level 5 course Our friendly admissions advisors will provide the best advice, considering your needs and goals.  Progression A possible progression route on successful completion of a CMI Level 5 in Management and Leadership would be to, Progress to other qualifications at the next level (e.g. from Level 5 Certificate to level 6 or 7 Certificate) Progression to Bachelor Degree Top Up in Business Management. Why gain a CMI Qualification? This online CMI Level 5 Extended Diploma in Management and Leadership course is perfect if you are a current or aspiring mid-level manager looking to advance in your career. The globally recognised CMI Level 5 Extended Diploma is perfect for you if you want to increase your opportunities for obtaining a middle management position. The substantial leadership skills and knowledge you'll develop with this course will be remarkably effective. You can fast-track to apply for Chartered Manager status, the ultimate professional accolade for managers, after completing the CMI Level 5 Diploma or Extended Diploma in Management and Leadership course and with 3+ years of experience in a managerial role. You may also wish to further your ongoing personal and professional development by accessing other CMI courses, such as the CMI Level 6 or Level 7 courses in Management and Leadership. Studying for a CMI qualification offers you more than just academic standing. When you enrol with us for the CMI Level 5 Extended Diploma in Management and Leadership, you will have access to CMI Membership and Support for the duration of your study alongside your qualification. CMI graduates achieve remarkable things: 72% agree that their CMI qualification gave them a competitive edge in the job application process. 89% agree they use the skills learnt on their accredited qualification in their current role. 88% agree that the accredited qualification gave them good career prospects. Recent CMI graduates earn a median of 28k compared to just 21k for a typical business studies graduate. Employers highly value the qualifications awarded by CMI, and over 80% of managers agree that a CMI qualification is essential to becoming a professional manager. Learners must complete a combination to a minimum of 540 TUT hours, 54 credits to achieve this qualification. There is a barred combination of units - learners taking 502 cannot select 503, 505 or 511 and learners taking 526 cannot select 501 or 502. Learners must request before enrolment to interchange unit(s) other than the preselected units shown in the SBTL website because we need to make sure the availability of learning materials for the requested unit(s). SBTL will reject an application if the learning materials for the requested interchange unit(s) are unavailable. Learners are not allowed to make any request to interchange unit(s) once enrolment is complete. UNIT1- Managing Performance Reference No : CMI 504 Credit : 5 || TQT : 50 LEARNING OUTCOME 1. Understand the rationale for managing performance within organisations. 2. Know how to manage performance. 3. Understand frameworks, diagnostic and evaluation tools used for performance management. UNIT2- Principles of Developing, Managing and Leading Individuals and Teams to Achieve Success Reference No : CMI 502 Credit : 6 || TQT : 60 LEARNING OUTCOME 1. Understand approaches to developing, managing and leading teams 2. Understand approaches to achieving a balance of skills and experience in teams. 3. Know techniques for leading individuals and teams to achieve success. UNIT3- Principles of Management and Leadership in an Organisational Context Reference No : CMI 501 Credit : 7 || TQT : 70 LEARNING OUTCOME 1. Understand factors which impact on an organisation's internal environment. 2. Understand the application of management and leadership theories. 3. Understand the knowledge, skills and behaviours to be effective in a management and leadership role. UNIT4- Principles of Delivering Coaching and Mentoring Reference No : CMI 507 Credit : 5 || TQT : 50 LEARNING OUTCOME 1. Understand the role and purpose of coaching and mentoring within an organisation. 2. Understand the use of models and processes used in workplace coaching and mentoring. 3. Know how to manage the delivery of effective coaching and mentoring. UNIT5- Managing Stakeholder Relationships Reference No : CMI 509 Credit : 4 || TQT : 40 LEARNING OUTCOME 1. Understand the different types and value of stakeholder relationships. 2. Understand the frameworks for stakeholder management. 3. Know how to manage stakeholder relationships. UNIT6- Managing Conflict Reference No : CMI 510 Credit : 5 || TQT : 50 LEARNING OUTCOME 1. Understand the types, causes, stages and impact of conflict within organisations. 2. Understand how to investigate conflict situations in the workplace. 3. Understand approaches, techniques, knowledge, skills and behaviours for managing conflict. UNIT7- Planning, Procuring and Managing Resources Reference No : CMI 516 Credit : 6 || TQT : 60 LEARNING OUTCOME 1. Understand the importance of effective and efficient resource use in organisations. 2. Know how to plan resources to meet organisational objectives. 3. Know how to procure resources. UNIT8- Principles of Innovation Reference No : CMI 517 Credit : 5 || TQT : 50 LEARNING OUTCOME 1. Understand the role of innovation within organisations. 2. Understand the process of managing innovation in an organisation. UNIT9- Principles of Marketing Products and Services Reference No : CMI 523 Credit : 6 || TQT : 60 LEARNING OUTCOME 1. Understand the role of marketing to support the achievement of organisational objectives. 2. Understand the factors in the organisation's marketing environment which impact on the marketing of a product or service. 3. Know how to market a product or service. UNIT10- Conducting a Management Project Reference No : CMI 524 Credit : 10 || TQT : 100 LEARNING OUTCOME 1. Know how to plan a management project. 2. Be able to conduct a management project. UNIT11- Managing Finance Reference No : CMI 520 Credit : 6 || TQT : 60 LEARNING OUTCOME 1. Understand finance within organisations. 2. Know how to set and manage budgets. UNIT12- Using Data and Information for Decision Making Reference No : CMI 521 Credit : 5 || TQT : 50 LEARNING OUTCOME 1. Understand the use of data and information in decision making. 2. Be able to interpret data and information to support decision making. 3. Know how to present data and information used for decision making. UNIT13- Managing Change Reference No : CMI 514 Credit : 5 || TQT : 50 LEARNING OUTCOME 1. Understand the reasons for change in organisations. 2. Understand approaches to change management. 3. Understand how to initiate, plan and manage change in an organisation. UNIT14- Creating and Delivering Operational Plans Reference No : CMI 515 Credit : 6 || TQT : 60 LEARNING OUTCOME 1. Understand the principles of operational planning in an organisation. 2. Know how to create an operational plan in line with organisational objectives. 3. Know how to manage and lead the delivery of an operational plan. UNIT15- Principles of Managing and Leading Individuals and Teams to Achieve Reference No : CMI 503 Credit : 5 || TQT : 50 LEARNING OUTCOME 1. Understand approaches to managing and leading teams. 2. Know how to achieve a balance of skills and experience in teams. 3. Know techniques for managing and leading individuals and teams to achieve success. UNIT16- Forming Successful Teams Reference No : CMI 505 Credit : 4 || TQT : 40 LEARNING OUTCOME 1. Understand the purpose and characteristics of successful teams. 2. Understand approaches to team formation. 3. Know how to analyse and respond to the challenges of team formation. UNIT17- Managing Equality, Diversity and Inclusion Reference No : CMI 506 Credit : 5 || TQT : 50 LEARNING OUTCOME 1. Understand legal and organisational approaches to equality, diversity and inclusion. 2. Understand the role and responsibilities of a manager in relation to equality, diversity and inclusion. 3. Know how to develop and implement plans which support equality, diversity and inclusion within an organisation. UNIT18- Principles of Developing a Skilled and Talented Workforce Reference No : CMI 508 Credit : 4 || TQT : 40 LEARNING OUTCOME 1. Understand the benefits of developing a skilled and talented workforce. 2. Understand the factors which influence workforce development. 3. Understand the scope of learning and development as part of a workforce development strategy. UNIT19- Principles of Recruiting, Selecting and Retaining Talent Reference No : CMI 511 Credit : 5 || TQT : 50 LEARNING OUTCOME 1. Understand the factors that impact on recruitment and selection. 2. Know how to plan for recruitment and selection. 3. Understand approaches to the recruitment and selection of a diverse and talented workforce. UNIT20- Workforce Planning Reference No : CMI 512 Credit : 4 || TQT : 40 LEARNING OUTCOME 1. Understand the rationale for workforce planning. 2. Understand the principles and practices of workforce planning. UNIT21- Managing Projects to Achieve Results Reference No : CMI 513 Credit : 6 || TQT : 60 LEARNING OUTCOME 1. Understand the role of projects in delivering organisational strategy. 2. Understand processes for initiating, planning and managing projects. 3. Understand the factors which contribute to effective project management. UNIT22- Managing Risk Reference No : CMI 518 Credit : 6 || TQT : 60 LEARNING OUTCOME 1. Understand the scope of business risk management. 2. Understand the process for managing business risk. UNIT23- Managing Quality and Continuous Improvement Reference No : CMI 519 Credit : 6 || TQT : 60 LEARNING OUTCOME 1. Understand the scope and purpose of quality management within organisations. 2. Understand approaches for managing quality. 3. Understand the application of continuous improvement within organisations. UNIT24- Managing the Customer Experience Reference No : CMI 522 Credit : 5 || TQT : 50 LEARNING OUTCOME 1. Understand the principles of managing the customer experience. 2. Understand the customer journey in the context of an organisation. 3. Know how to manage the customer experience. UNIT25- Using Reflective Practice to Inform Personal and Professional Development Reference No : CMI 525 Credit : 5 || TQT : 50 LEARNING OUTCOME 1. Understand the value of reflective practice to inform personal and professional development. 2. Know how to apply reflective practice to inform personal and professional development. UNIT26- Principles of Leadership Practice Reference No : CMI 526 Credit : 8 || TQT : 80 LEARNING OUTCOME 1. Understand leadership practice in an organisation. 2. Understand leadership styles 3. Understand the impact of leadership within organisations. UNIT27- Strategic Corporate Social Responsibility and Sustainability Reference No : CMI 608 Credit : 6 || TQT : 60 LEARNING OUTCOME 1. Understand corporate social responsibility and sustainability in organisational contexts. 2. Know how corporate social responsibility and sustainability is applied in an organisational setting. Delivery Methods School of Business & Technology London provides various flexible delivery methods to its learners, including online learning and blended learning. Thus, learners can choose the mode of study as per their choice and convenience. The program is self-paced and accomplished through our cutting-edge Learning Management System. Learners can interact with tutors by messaging through the SBTL Support Desk Portal System to discuss the course materials, get guidance and assistance and request assessment feedbacks on assignments. We at SBTL offer outstanding support and infrastructure for both online and blended learning. We indeed pursue an innovative learning approach where traditional regular classroom-based learning is replaced by web-based learning and incredibly high support level. Learners enrolled at SBTL are allocated a dedicated tutor, whether online or blended learning, who provide learners with comprehensive guidance and support from start to finish. The significant difference between blended learning and online learning methods at SBTL is the Block Delivery of Online Live Sessions. Learners enrolled at SBTL on blended learning are offered a block delivery of online live sessions, which can be booked in advance on their convenience at additional cost. These live sessions are relevant to the learners' program of study and aim to enhance the student's comprehension of research, methodology and other essential study skills. We try to make these live sessions as communicating as possible by providing interactive activities and presentations. Resources and Support School of Business & Technology London is dedicated to offering excellent support on every step of your learning journey. School of Business & Technology London occupies a centralised tutor support desk portal. Our support team liaises with both tutors and learners to provide guidance, assessment feedback, and any other study support adequately and promptly. Once a learner raises a support request through the support desk portal (Be it for guidance, assessment feedback or any additional assistance), one of the support team members assign the relevant to request to an allocated tutor. As soon as the support receives a response from the allocated tutor, it will be made available to the learner in the portal. The support desk system is in place to assist the learners adequately and streamline all the support processes efficiently. Quality learning materials made by industry experts is a significant competitive edge of the School of Business & Technology London. Quality learning materials comprised of structured lecture notes, study guides, practical applications which includes real-world examples, and case studies that will enable you to apply your knowledge. Learning materials are provided in one of the three formats, such as PDF, PowerPoint, or Interactive Text Content on the learning portal. Management Direct As part of the program, you will get access to CMI Management Direct, which provides a rich foundation of management and resource for students. The Management Direct is packed with content, including: E-Books Articles Leader videos Idea for leaders Models and so much more... How does the Online Learning work at SBTL? We at SBTL follow a unique approach which differentiates us from other institutions. Indeed, we have taken distance education to a new phase where the support level is incredibly high.Now a days, convenience, flexibility and user-friendliness outweigh demands. Today, the transition from traditional classroom-based learning to online platforms is a significant result of these specifications. In this context, a crucial role played by online learning by leveraging the opportunities for convenience and easier access. It benefits the people who want to enhance their career, life and education in parallel streams. SBTL's simplified online learning facilitates an individual to progress towards the accomplishment of higher career growth without stress and dilemmas. How will you study online? With the School of Business & Technology London, you can study wherever you are. You finish your program with the utmost flexibility. You will be provided with comprehensive tutor support online through SBTL Support Desk portal. How will I get tutor support online? School of Business & Technology London occupies a centralised tutor support desk portal, through which our support team liaise with both tutors and learners to provide guidance, assessment feedback, and any other study support adequately and promptly. Once a learner raises a support request through the support desk portal (Be it for guidance, assessment feedback or any additional assistance), one of the support team members assign the relevant to request to an allocated tutor. As soon as the support receive a response from the allocated tutor, it will be made available to the learner in the portal. The support desk system is in place to assist the learners adequately and to streamline all the support process efficiently. Learners should expect to receive a response on queries like guidance and assistance within 1 - 2 working days. However, if the support request is for assessment feedback, learners will receive the reply with feedback as per the time frame outlined in the Assessment Feedback Policy.

Diploma in Business Studies - Level 3 (Fast-Track mode) The objective of the Diploma in Business Studies - Level 3 qualification (Accredited by OTHM) is to provide learners with an in depth understanding of the operations and structure of businesses. Successful completion of this qualification will equip learners with the underpinning knowledge and skills required to succeed in employment or further studies. Diploma in Business Studies Key Highlights Program Duration: 6 Months (Regular Mode available) Program Credits: 60 Credits Designed for working Professionals Course Delivery: Online No Written Exam. The Assessment is done via Submission of Assignment Tutor Assist available Dedicated Student Success Manager Timely Doubt Resolution Regular Networking Events with Industry Professionals Direct entry into Year 1 of a three-year UK Bachelor's degree LSBR Alumni Status No Cost EMI Option Understanding of operations and structure of businesses. Underpinning knowledge and skills required to succeed in employment or further studies. Successful completion of the Program enables learners' direct entry into Year 1 of a three-year UK Bachelor's degree or pursue Level 4 Diplomas Mandatory units (Total Credits: 40) The Level 3 Diploma in Business Studies qualification consists of 4 mandatory units plus 2 optional unit for a combined total of 60 credits, 600 Total Qualification Hours (TQT) and 360 Guided Learning Hours (GLH) for the completed qualification. Introduction to Research and Academic Skills (10 credits) Using IT for Business (10 credits) Introduction to Economics and Accounting (10 credits) Introduction to the Business Environment (10 credits) Optional Units (Total Credit: 20) Choose any two of the below Optional Units Introduction to Customer Service (10 credits) Managing Business Events (10 credits) Introduction to Marketing (10 credits) Introduction to People Management (10 credits) Who is this course for? Working Professionals O-Level holders, Sales Marketing Professionals Requirements Open Entry. No formal qualification is required Career path Completion of your Level 3 Diploma in Business Studies qualification will meet the University standard academic entry requirements. However, each applicant will be subject to individual assessment and other entry requirements which may affect university entry.

Certified Associate in Project Management (CAPM)® Exam Prep: In-House Training: In-House Training This course gives you the knowledge you need to pass the exam and covers CAPM®-critical information on project management theory, principles, techniques, and methods Are you planning on taking the CAPM® examination? This course gives you the knowledge you need to pass the exam and covers CAPM®-critical information on project management theory, principles, techniques, and methods. You'll also have an opportunity for practical applications and time to review the kinds of questions you'll find in the CAPM® Exam. What you Will Learn Apply for the CAPM® Examination Develop a personal exam preparation plan Describe the structure, intent, and framework principles of the current edition of the PMBOK® Guide Explain the PMBOK® Guide Knowledge Areas, as well as their inter-relationships with the each other and the Process Groups Getting Started Program orientation The CAPM® certification process Certified Associate in Project Management (CAPM®) Examination Content Outline CAPM® eligibility requirements Code of Ethics and Professional Conduct Application options Foundation Concepts Skills and qualities of a project manager Project management terminology and definitions Relationship of project, program, portfolio, and operations management Project lifecycle approaches Project Integration Management Review Project Integration Management Knowledge Area Develop Project Charter Develop Project Management Plan Direct and Manage Project Work Manage Project Knowledge Monitoring and Controlling Perform Integrated Change Control Close Project or Phase Project Stakeholder Management Review Project Stakeholder Management Knowledge Area Identify Stakeholders Plan Stakeholder Engagement Manage Stakeholder Engagement Monitor Stakeholder Engagement Project Scope Management Review Project Scope Management Knowledge Area Plan Scope Management Collect Requirements Define Scope Create WBS Validate Scope Control Scope Project Schedule Management Review Project Schedule Management Knowledge Area Plan Schedule Management Define Activities Sequence Activities Estimate Activity Durations Develop Schedule Control Schedule Project Cost Management Review Project Cost Management Knowledge Area Plan Cost Management Estimate Costs Determine Budget Control Schedule Project Resource Management Review Project Resource Management Knowledge Area Plan Resource Management Estimate Activity Resources Acquire Resources Develop Team Manage Team Control Resources Project Quality Management Review Project Quality Management Knowledge Area Plan Quality Management Manage Quality Control Quality Project Risk Management Review Project Risk Management Knowledge Area Plan Risk Management Identify Risks Perform Qualitative Risk Analysis Perform Quantitative Risk Analysis Plan Risk Responses Implement Risk Responses Monitor Risks Project Communications Management Review Project Communications Management Knowledge Area Plan Communications Management Manage Communications Monitor Communications Project Procurement Management Review Project Procurement Management Knowledge Area Plan Procurement Management Conduct Procurements Control Procurements Summary and Next Steps Program Review Mock CAPM® Exam Getting Prepared for the CAPM® Exam After the CAPM® Exam

Data dashboards provide key information to stakeholders so that they can make informed decisions. While there are plenty of software solutions for building these essential data products, there is much less guidance on how to design dashboards to meet the diverse needs of users.  This course is for anyone who is building or implementing dashboards, and wants to know more about design principles and best practice. You could be using business intelligence software (such as Power BI or Tableau), or implementing bespoke solutions.  The course will give your team the ability to evaluate user needs and levels of understanding, make informed decisions about chart selections, and make effective use of interactivity dynamic data.  We’ll work with you before the course to ensure that we understand your organisation and what you’re hoping to achieve.  Sample learning content  Session 1: Data with a purpose Understanding the different types of dashboard. Information overload and other common dashboard pitfalls. Assessing user needs and levels of data fluency. Session 2: Planning a dashboard Assessing diverse user needs and levels of data fluency. Taking a User Experience (UX) approach to design and navigation. Applying an interative and collaborative approach to onboarding. Session 3: Graphs, charts and dials  Understanding how graphical perception informs chart choices. Making intelligent design choices to help users explore. Design principles for layout and navigation. Session 4: Using interactivity  Making effective use of filters to slice and dice data sets. Using layers of information to enable drilldown data exploration. Complenting dashboards with automated alerts and queries. Delivery We deliver our courses over Zoom, to maximise flexibility. The training can be delivered in a single day, or across multiple sessions. All of our courses are live and interactive – every session includes a mix of formal tuition and hands-on exercises. To ensure this is possible, the number of attendees is capped at 16 people.  Tutor Alan Rutter is the founder of Fire Plus Algebra. He is a specialist in communicating complex subjects through data visualisation, writing and design. He teaches for General Assembly and runs in-house training for public sector clients including the Home Office, the Department of Transport, the Biotechnology and Biological Sciences Research Council, the Health Foundation, and numerous local government and emergency services teams. He previously worked with Guardian Masterclasses on curating and delivering new course strands, including developing and teaching their B2B data visualisation courses. He oversaw the iPad edition launches of Wired, GQ, Vanity Fair and Vogue in the UK, and has worked with Condé Nast International as product owner on a bespoke digital asset management system for their 11 global markets. Testimonial “Alan was great to work with, he took us through the concepts behind data visualisation which means our team is now equipped for the future. He has a wide range of experience across the topic that is delivered in a clear, concise and friendly manner. We look forward to working with Alan again in the future.” John Masterson | Chief Product Officer | ImproveWell

Duration 3 Days 18 CPD hours This course is intended for This course is intended for information workers and data science professionals who seek to use database reporting and analysis tools such as Microsoft SQL Server Reporting Services, Excel, Power BI, R, SAS and other business intelligence tools, and wish to use TSQL queries to efficiently retrieve data sets from Microsoft SQL Server relational databases for use with these tools. Overview After completing this course, students will be able to: - Identify independent and dependent variables and measurement levels in their own analytical work scenarios. - Identify variables of interest in relational database tables. - Choose a data aggregation level and data set design appropriate for the intended analysis and tool. - Use TSQL SELECT queries to produce ready-to-use data sets for analysis in tools such as PowerBI, SQL Server Reporting Services, Excel, R, SAS, SPSS, and others. - Create stored procedures, views, and functions to modularize data retrieval code. This course is about writing TSQL queries for the purpose of database reporting, analysis, and business intelligence. 1 - INTRODUCTION TO TSQL FOR BUSINESS INTELLIGENCE Two Approaches to SQL Programming TSQL Data Retrieval in an Analytics / Business Intelligence Environment The Database Engine SQL Server Management Studio and the CarDeal Sample Database Identifying Variables in Tables SQL is a Declarative Language Introduction to the SELECT Query Lab 1: Introduction to TSQL for Business Intelligence 2 - TURNING TABLE COLUMNS INTO VARIABLES FOR ANALYSIS: SELECT LIST EXPRESSIONS, WHERE, AND ORDER BY Turning Columns into Variables for Analysis Column Expressions, Data Types, and Built-in Functions Column aliases Data type conversions Built-in Scalar Functions Table Aliases The WHERE clause ORDER BY Lab 1: Write queries 3 - COMBINING COLUMNS FROM MULTIPLE TABLES INTO A SINGLE DATASET: THE JOIN OPERATORS Primary Keys, Foreign Keys, and Joins Understanding Joins, Part 1: CROSS JOIN and the Full Cartesian Product Understanding Joins, Part 2: The INNER JOIN Understanding Joins, Part 3: The OUTER JOINS Understanding Joins, Part 4: Joining more than two tables Understanding Joins, Part 5: Combining INNER and OUTER JOINs Combining JOIN Operations with WHERE and ORDER BY Lab 1: Write SELECT queries 4 - CREATING AN APPROPRIATE AGGREGATION LEVEL USING GROUP BY Identifying required aggregation level and granularity Aggregate Functions GROUP BY HAVING Order of operations in SELECT queries Lab 1: Write queries 5 - SUBQUERIES, DERIVED TABLES AND COMMON TABLE EXPRESSIONS Non-correlated and correlated subqueries Derived tables Common table expressions Lab 1: Write queries 6 - ENCAPSULATING DATA RETRIEVAL LOGIC Views Table-valued functions Stored procedures Creating objects for read-access users Creating database accounts for analytical client tools Lab 1: Encapsulating Data Retrieval Logic 7 - GETTING YOUR DATASET TO THE CLIENT Connecting to SQL Server and Submitting Queries from Client Tools Connecting and running SELECT queries from: Excel PowerBI RStudio Exporting datasets to files using Results pane from SSMS The bcp utility The Import/Export Wizard Lab 1: Getting Your Dataset to the Client Additional course details: Nexus Humans 55232 Writing Analytical Queries for Business Intelligence training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the 55232 Writing Analytical Queries for Business Intelligence course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

This course is about collaborating with others in ways that will help you to communicate more efficiently as you work to understand and work with differences that lead to effective collaboration. In addition, the skills, processes and tools taught in this course can bring value to other aspects of your life.