Name: Level 3 Endorsed Award in Delivering Health and Social Care Training (Healthcare Train the Trainer)
Price: 1465 GBP
Availability: InStock

Wakefield

<section data-element_type="section" data-id="0ce9887" fr-original-style=" color: rgb(102, 102, 102);" id="isPasted" style="color: rgb(102, 102, 102); box-sizing: border-box;"><div data-element_type="column" data-id="7a86ad6" fr-original-style="" style="box-sizing: border-box;"><div data-element_type="widget" data-id="675df2c" data-widget_type="heading.default" fr-original-style="" style="box-sizing: border-box;"><h2 fr-original-style=" color: var( --e-global-color-primary );" style="color: var( --e-global-color-primary ); box-sizing: border-box;">Overview</h2></div></div></section><section data-element_type="section" data-id="b65f267" fr-original-style=" color: rgb(102, 102, 102);" style="color: rgb(102, 102, 102); box-sizing: border-box;"><div data-element_type="column" data-id="3dd6aa2" fr-original-style="" style="box-sizing: border-box;"><div data-element_type="widget" data-id="c69717a" data-widget_type="text-editor.default" fr-original-style="" style="box-sizing: border-box;"><p fr-original-style="" style="font-size: 16px; color: var(--text); box-sizing: border-box;">This one day Accident Investigation course will give participants the necessary information and skills to enable them to carry out a thorough and effective accident investigation.</p></div></div></section><section data-element_type="section" data-id="0cef489" fr-original-style=" color: rgb(102, 102, 102);" style="color: rgb(102, 102, 102); box-sizing: border-box;"><div data-element_type="column" data-id="203cb18" fr-original-style="" style="box-sizing: border-box;"><div data-element_type="widget" data-id="8959dcf" data-widget_type="heading.default" fr-original-style="" style="box-sizing: border-box;"><h2 fr-original-style=" color: var( --e-global-color-primary );" style="color: var( --e-global-color-primary ); box-sizing: border-box;">Description</h2></div></div></section><section data-element_type="section" data-id="9e0fd79" fr-original-style=" color: rgb(102, 102, 102);" style="color: rgb(102, 102, 102); box-sizing: border-box;"><div data-element_type="column" data-id="f99a0e9" fr-original-style="" style="box-sizing: border-box;"><div data-element_type="widget" data-id="ab83b21" data-widget_type="text-editor.default" fr-original-style="" style="box-sizing: border-box;"><p fr-original-style="" style="font-size: 16px; color: var(--text); box-sizing: border-box;">This course will provide attendees with the necessary information and skills, to reach the right conclusions, make effective, practical recommendations and thereby make a significant contribution to improving workplace health and safety.</p><p fr-original-style="" style="font-size: 16px; color: var(--text); box-sizing: border-box;">Topics covered:</p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Accidents &amp; Accident Causation</strong> &ndash; If an organisation does not properly control risks, the outcome of an accident often depends on chance. Because the outcome of an accident cannot be accurately predicted, the only way to effectively reduce accidents is by controlling the underlying causes of all the different accident types.</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Accident Reporting Process</strong> &ndash; Reporting of Injuries, Diseases &amp; Dangerous Occurrences Regulations 1995 (RIDDOR)</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">The Process</strong> &ndash; You have 2 top priorities when you are first notified of an accident. The first is to the injured person to ensure that appropriate medical attention is available. The second priority is then to ensure that the area is made safe to ensure no other persons are injured</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Accident Investigation</strong> &ndash; Every employer has a Moral, Legal &amp; Economic obligation to protect the health and safety of employees while at work</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">The Cause of Accidents</strong> &ndash; During an accident investigation you will be looking for the unsafe acts and the unsafe conditions which contributed to the accident. If you carry out the investigation effectively, then you will find the root cause or causes of the accident</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Facts to be Collated</strong> &ndash; When you conduct an accident investigation you should be seeking to obtain information on unsafe acts, unsafe conditions, immediate failures and latent failures. To find out these various elements of the accident you need to ask the questions who, where, when, and what, which will give you details of the event</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Reaching Conclusion</strong> &ndash; Identifying all the failure modes, satisfy all the answers to what, where, why, who etc., and thus identify all the causes of the accident</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Review of Session</strong> &ndash; Creating an action plan to embed learning.</li></ul></div></div></section><section data-element_type="section" data-id="b20f93d" fr-original-style=" color: rgb(102, 102, 102);" style="color: rgb(102, 102, 102); box-sizing: border-box;"><div data-element_type="column" data-id="4b3b5e2" fr-original-style="" style="box-sizing: border-box;"><div data-element_type="widget" data-id="a8e6bc7" data-widget_type="heading.default" fr-original-style="" style="box-sizing: border-box;"><h2 fr-original-style=" color: var( --e-global-color-primary );" style="color: var( --e-global-color-primary ); box-sizing: border-box;">Who should attend</h2></div></div></section><section data-element_type="section" data-id="ebf9787" fr-original-style=" color: rgb(102, 102, 102);" style="color: rgb(102, 102, 102); box-sizing: border-box;"><div data-element_type="column" data-id="1d649dc" fr-original-style="" style="box-sizing: border-box;"><div data-element_type="widget" data-id="77cbe1b" data-widget_type="text-editor.default" fr-original-style="" style="box-sizing: border-box;"><p fr-original-style="" style="font-size: 16px; color: var(--text); box-sizing: border-box;">Managers, leaders, trainers, health and safety officers and anyone involved in health and safety training and/or procedures.</p></div></div></section><section data-element_type="section" data-id="966e6ed" fr-original-style=" color: rgb(102, 102, 102);" style="color: rgb(102, 102, 102); box-sizing: border-box;"><div data-element_type="column" data-id="f23eae0" fr-original-style="" style="box-sizing: border-box;"><div data-element_type="widget" data-id="d112203" data-widget_type="heading.default" fr-original-style="" style="box-sizing: border-box;"><h2 fr-original-style=" color: var( --e-global-color-primary );" style="color: var( --e-global-color-primary ); box-sizing: border-box;">Requirements for Attendees</h2></div></div></section><section data-element_type="section" data-id="30b0186" fr-original-style=" color: rgb(102, 102, 102);" style="color: rgb(102, 102, 102); box-sizing: border-box;"><div data-element_type="column" data-id="51d5a6b" fr-original-style="" style="box-sizing: border-box;"><div data-element_type="widget" data-id="47f746b" data-widget_type="text-editor.default" fr-original-style="" style="box-sizing: border-box;"><p fr-original-style="" style="font-size: 16px; color: var(--text); box-sizing: border-box;">None.</p></div></div></section>

Inovra Group

Business Development

Professional Development

Accident Investigation

Group booking for up to ten delegates on the course.  See FAQ for delivery location details.

Group Session

London

<h2>Management of Value (MoV®) Foundation</h2>
<p>This interactive MoV® Foundation course provides a modular and case-study-driven approach to learning Management of Value (MoV). The core knowledge is structured and comprehensive; and well-rounded modules cover the methodology and various techniques. A case study is used to help appreciate the relevance of MoV in its practical application.</p><h3>What you will Learn</h3>
<p>Upon completion of an MoV course candidates should be able to discuss and explain:</p>
<ul>
<li>The main processes and techniques used within MoV and the reasons for using them</li>
<li>How MoV may be applied at portfolio, program, project and operational levels</li>
<li>The differences in applying MoV at different stages in a project and the expected outputs from a MoV Study at each stage</li>
<li>The circumstances under which MoV should be used</li>
<li>The concept of value and how value may be improved</li>
<li>The main benefits arising from the use of MoV</li>
<li>Approaches for implementing MoV</li>
<li>How to respond to external and internal influences</li>
<li>The principles of embedding MoV into an organization</li>
<li>The key topics in document checklists, the toolbox, health check, organizational maturity and individual competence.</li>
</ul>
<p>Upon successful completion of this course, you will be able to:</p>
<ul>
<li>Organize and contribute constructively to a Management of Value (MoV) Study</li>
<li>Demonstrate a knowledge of MoV principles, processes, approach and environment</li>
<li>Analyse a company, program or project to establish its organizational value; includes identification and weighting of Value Drivers</li>
<li>Pass the AXELOS MoV Foundation Examination</li>
</ul><section>
                    <h3>Introduction to value management and MoV</h3><ul><li>Value and Value Management</li><li>Capabilities, Outcomes, Benefits and Disbenefits</li><li>What is Value?</li><li>What is Management of Value (MoV)?</li><li>Why use MoV?</li><li>Where use MoV?</li><li>When MoV should be used?</li><li>What using MoV involve?</li><li>Selected MoV benefits</li><li>Relationship with other AXELOS Global Best Practices and Models</li><li>How MoV fits with other AXELOS Global Best Practice Guides</li></ul><h3>MoV principles</h3><ul><li>Align with organization's objectives</li><li>Focus on functions and required outcomes</li><li>Balance the variables to maximise value</li><li>Apply throughout the investment decision</li><li>Tailor MoV to suit the subject</li><li>Learn from experience and improve</li><li>Assign clear roles and responsibilities and build a supportive culture</li></ul><h3>MoV processes</h3><ul><li>Frame the programme or project</li><li>Gather information</li><li>Analyse information</li><li>Process information</li><li>Evaluate and select</li><li>Develop Value Improving Proposals</li><li>Implement and share outputs</li></ul><h3>MoV techniques</h3><ul><li>Function Analysis</li><ul><li>Function Analysis System Technique (FAST)</li><li>Traditional (or classic) FAST</li><li>Technical FAST</li><li>Customer FAST</li></ul><li>Value Trees</li><li>Measuring value</li><ul><li>Value profiling (a.k.a. value benchmarking)</li><li>Simple multi-attribute rating technique (a.k.a. SMART)</li><li>Value index</li><li>Value metrics</li><li>Value for money (VfM) ratio</li><li>Value Engineering / Analysis</li></ul></ul><h3>Common techniques used in MoV</h3><ul><li>Analysis of information</li><ul><li>Benchmarking</li><li>Process Mapping</li><li>Root Cause Analysis</li><li>Discounted Cash Flow Analysis</li></ul><li>Generating Ideas</li><ul><li>Brainstorming</li></ul><li>Evaluation and option selection</li><ul><li>Option Selection Matrix</li><li>Idea selection</li><ul><li>Allocation to Categories</li><li>Idea Selection Matrix</li></ul></ul><li>Weighting techniques</li><ul><li>Paired Comparisons</li><li>Points Distribution</li></ul><li>Developing VIPs</li><ul><li>Developing Proposals</li><li>Cost Benefit Analysis</li><li>Building Decisions</li></ul><li>Implementing VIPs</li><ul><li>Implementation Plans</li><li>Feedback</li></ul><li>Following up</li><ul><li>Tracking Benefits</li></ul></ul><h3>Approach to Implementation</h3><ul><li>Generic approach to MoV implementation</li><li>Plan the MoV activities</li><li>Understand and articulate value</li><li>Prioritize value</li><li>Improve value</li><li>Quantify value</li><li>Monitor improvements in value</li><li>Learn lessons</li></ul><h3>Environmental factors</h3><ul><li>Portfolio Considerations</li><li>Programme considerations</li><li>Project considerations</li><li>Operational Considerations</li></ul><h3>Embedding MoV into an organization</h3><ul><li>Benefits of Embedding MoV into an organization</li><li>MoV Policy</li><li>MoV Policy  Composition</li><li>Embedding MoV into an organisation  Key steps</li><li>Suggested MoV Management Structure</li><li>Overcoming barriers</li><li>We do it anyway</li><li>It takes up too much time</li><li>We can't afford to make the changes</li><li>What's in it for me?</li><li>Don't fix it if it ain't broke</li><li>Fixed returns on investment</li></ul><h3>MoV products</h3><ul><li>Briefing Meeting Agenda (A.1)</li><li>Communications Checklist (A.2)</li><li>Equipment list for an Effective Study/Workshop (A.3)</li><li>Invitation to join the Study Team (A.4)</li><li>Option Evaluation Matrix (A.5)</li><li>Plan the Study (A.6)</li><li>Recording Idea Selection (A.7)</li><li>Reporting Study outputs (A.8)</li><li>Scoping the Study (A.9)</li><li>Study or Workshop Handbook (A.10)</li><li>Value-Improvement Proposal Forms (A.11)</li><li>Value Improvement Tracking Report (A.12)</li></ul><h3>MoV toolbox</h3><h3>MoV health check and maturity model</h3><ul><li>P3M3 Maturity Model</li><li>MoV Maturity Model (aligned with P3M3)</li></ul>


                </section>

IIL Europe Ltd

Management of Value (MoV) Foundation: In-House Training

General Admission

<p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This e-learning course will help you and your staff become familiar with the role and responsibilities of the designated safeguarding lead in your organisation. It will develop both your competence and confidence in carrying out the role of Designated Safeguarding Lead (DSL).</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course Description</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This course provides advanced knowledge of child protection procedures and will help you to recognise and know what to do if you believe that a child is at risk. The course aims to provide advanced information on reporting strategies, policies and procedures. It also covers how to make your working environment safe for children, including safe practices; what to do if you believe that a child is at risk; who to approach or report to; what actions to take and which legislation applies in this area.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">It will look at the role of the Designated Safeguarding Lead, Information Sharing, confidentiality, consent, prevent, radicalisation and what we should expect from children&rsquo;s social care and enable you to take on the role in your organisation.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Designated Safeguarding Lead (DSL) - Formally known as the Safeguarding Children Level 3 One Day Course Is in Line with Ofsted&rsquo;s new safeguarding children briefing for section 5 inspectors, Ofsted Inspection Framework &amp; Working Together to Safeguard Children (July 2018), Keeping Children Safe in Education (Sept 2022). You are required to have undertaken the recognised course.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course Modules&nbsp;</strong><br fr-original-style="" style="box-sizing: border-box;">Module 1: Introduction to Child Protection / Safeguarding<br fr-original-style="" style="box-sizing: border-box;">Module 2: Legislation and Guidance<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">&nbsp;</strong><br fr-original-style="" style="box-sizing: border-box;">Module 3: Role of the Designated Person<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">&nbsp;</strong><br fr-original-style="" style="box-sizing: border-box;">Module 4: Responding to Disclosure and Reporting<br fr-original-style="" style="box-sizing: border-box;">Module 5: Child Protection Record Keeping<br fr-original-style="" style="box-sizing: border-box;">Module 6: Information Sharing / Confidentiality &amp; Consent<br fr-original-style="" style="box-sizing: border-box;">Module 7: Core Procedures: Referrals / Strategy Discussion / Section 47<br fr-original-style="" style="box-sizing: border-box;">Module 8: Core Procedures: Child Protection Conferences / Child Protection Plans / Core Groups</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">&nbsp;</p>

Child Protection Training Uk

This course will help you and your staff become familiar with the role and responsibilities of the designated safeguarding lead in your organisation.  It will develop both your competence and confidence in carrying out the role of Designated Safeguarding Lead (DSL).  Formally known as Level 3

Designated Safeguarding Lead Online Course

<div>
</div>
<section>
<div>
<h2><strong>About this Training Course</strong></h2>
<p>This intensive 5 full-day has been designed as a separately bookable course comprising 3 days of Well Integrity (Basic) and 2 days of Advanced Well Integrity.</p>
<p>The intensive 3 full-day course will equip the participants with a thorough knowledge of well integrity management and risk assessment in producing assets. Based on the regulatory requirements and using real examples and exercises from around the world, this represents best practice integrity management within the oil and gas industry.</p>
<p>When to take action with a well is a critical decision, both from a safety and economic perspective. A consistent approach to decision-making provides certainty within the organisation, focusing effort, and spending wisely. The decision-making steps will be set out to ensure all critical aspects are captured consistently. Risk analysis approaches used by different organisations and examples of risk management and risk-ranking methods will be discussed.</p>
<p>The 2 full-day course will deepen the participants' knowledge of well integrity management, and skills for designing, operating, and maintaining well equipment. The ultimate goal is to optimise productivity at the lowest Unit Operating Cost (UOC) and to maintain mechanical integrity throughout well life cycle.</p>
<p>Well Integrity management is looked at in three distinct stages. The first stage is during the well design which includes material selection, engineering design, cement design, coating and inhibitors and cathodic protection. The second stage is monitoring the well during the life of the well, locating possible leaks and / or loss of metal. The last stage is to manage and control any well integrity issues using specialised products, services and techniques.</p>
</div>
</section>
<section>
<div id="accordion">
<div>
<div>

Training Objectives 

</div>
<div id="collapseOne">
<div>
<p><strong>1. </strong><strong>Well Integrity Training:</strong></p>
<p>Upon completion of this course, the participants will be able to:</p>
<ul>
<li>Define the building blocks of a successful well integrity management system</li>
<li>Develop an approach to risk management, understand risk analysis and methods applied across the industry</li>
<li>How do we 'Make Wells Safer', learn about emerging technologies for well integrity problem diagnosis and new techniques available to 'repair' the issues</li>
<li>Execute the basic elements of well integrity management training for field operators</li>
<li>Evaluate well design elements that enhance or hinder well integrity status definition during the operating phase of the well life-cycle</li>
<li>Gain the demonstrable benefits of well integrity management from field experience</li>
<li>Review cases studies and discuss them to enhance knowledge and take on board lessons learned</li>
</ul>
<p><strong>2. Advanced Well Integrity:</strong></p>
<ul>
<li>Define well integrity well categorization based on compliance to the barrier policy outlined in the regulations and develop an approach to risk management</li>
<li>Discuss well-completion design and construction to create a 'integer' well with the lowest life cycle maintenance cost from a WIM perspective</li>
<li>Monitoring and surveillance of well integrity, focusing on barrier competence such as cementing and corrosion</li>
<li>Investigate and manage well integrity issues, causes &amp; potential solutions</li>
<li>Understand repairs needed to address 'Loss of Well Operating Envelope'</li>
<li>Gain an overview understanding of Well Suspension &amp; Well Abandonment</li>
<li>Discuss further case studies as well as conduct a post course test</li>
</ul>
</div>
</div>
</div>
<div>
<div>

Target Audience 

</div>
<div id="collapseTwo">
<div>
<p>Invaluable for production, operations, and integrity professionals involved in implementing &amp; managing well integrity and seeking to improve performance. It is also essential for those who need to develop and implement such systems, or who have a general need to know and understand more about well integrity management. The course will also provide a fresh approach for senior professionals and managers. Designed for professionals in the oil and gas industry who are involved in the design, construction and operation of wells from the following disciplines:</p>
<ul>
<li>Production Maintenance</li>
<li>Production Operations</li>
<li>Drilling Engineering</li>
<li>Safety engineering</li>
<li>Well Intervention</li>
<li>Well Integrity Engineering</li>
<li>Asset Management</li>
</ul>
</div>
</div>
</div>
<div>
<div>

Course Level 

</div>
<div id="collapsecl">
<div>
<ul>
<li>Intermediate</li>
<li>Advanced</li>
</ul>
</div>
</div>
</div>
<div>
<div>

Trainer

</div>
<div id="collapseFive">
<div>
<p>Gordon Duncan has over 40 years of experience in the Oil &amp; Gas industry. During that time, he has worked exclusively in well intervention and completions. After a number of years working for intervention service companies (completions, slickline &amp; workovers), he joined Shell as a well service supervisor. He was responsible for the day-to-day supervision of all well intervention work on Shell's Persian/Arabian Gulf platforms. This included completion running, coil tubing, e-line, slickline, hydraulic workovers, well testing and stimulation operations. An office-based role as a senior well engineer followed.</p>
<p>He was responsible for planning, programming and organising of all the well engineering and intervention work on a number of fields in the Middle East. He had a brief spell as a Site Representative for Santos in Australia before joining Petro-Canada as Completions Superintendent in Syria, then moved to Australia as Completions Operations Superintendent for Santos, before returning to Shell as Field Supervisor Completions and Well Interventions in Iraq where he carried out the first ever formal abandonment of a well in the Majnoon Field. While working on rotation, he regularly taught Completion Practices, Well Intervention, Well Integrity and Reporting &amp; Planning courses all over the world. In 2014, he started to focus 100% on training and became the Technical Director for PetroEDGE.</p>
<p>Since commencing delivering training courses in 2008, he has taught over 300 courses in 31 cities in 16 countries to in excess of 3,500 participants.</p>
</div>
</div>
</div>
<div>
<div>

POST TRAINING COACHING SUPPORT (OPTIONAL)

</div>
<div id="collapseCS">
<div>
<p>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.<br />
Request for further information post training support and fees applicable</p>
</div>
</div>
</div>
<div>
<div>

Accreditions And Affliations

</div>
<div id="collapseSeven">
<div>
               </div>
</div>
</div>
</div>
</section>

EnergyEdge - Training for a Sustainable Energy Future

Renewable Energy

Oil & Gas

Well Integrity (Basic and Advanced)

Team of 10, pp

Normal Fee, pp

<div>
</div>
<section>
<div>
<h2><strong>About this Training Course</strong></h2>
<p>In turbulent times for the entire Energy Sector, Oil &amp; Gas E &amp; P segments are coming under tremendous pressure to reinvigorate. Oil Majors like <em>Shell Plc</em> are no longer termed as Oil &amp; Gas Company but also branded as <em>SHELL Energy</em>, with technology at its forefront. The Risks, Scope and Context of Engineering, Procurement, Construction, Installation and Commissioning (EPCIC) Projects is evolving rapidly. Thus, the success of a project is dependent on the practical 'know how' in scoping, contract drafting, negotiation and execution competencies. Understanding the essential ingredients of contracts and mastering the international contracting principles will equip the participants to identify vague and ambiguous clauses, avoid dangerous and often hidden terms, and better understand the controlling position in a project.</p>
<p>In this 3 full-day course, the participants will find out how to negotiate legacy contracts where parties are not allowed to edit any clauses during the bidding process. The participants will learn from the Case Law Reports and analysis to take home lessons learned from bitter experiences of their peers in the industry. It is designed to help those who need a solution to manage current contractual issues or those who execute contracts regularly and want to be more proficient in managing their contracts and projects, with changing contexts.</p>
<p>The course is developed with the underlying objectives for the participants to:</p>
<ol><li>Enhance their current knowledge of the legal principles governing international Contracts from formation, execution to breaches, redresses and dispute resolution either as a party or as a consortium member or as a coverture.</li><li>Manage Consortium and Joint Venture Partners inter-relationship and contractual responsibilities.</li><li>Identify dangerous exposures due to joint and severally liable requirements of consortium-based contracts.</li><li>Effectively Manage Risks of Projects, with Enforceable Contract Documents, by learning the purpose and potential benefits of maintaining evidence in compliance to the contract clauses.</li><li>Learn the Contract Enforcement Nuggets of Owners and the Variation Claims Strategies of the Contractors.</li><li>Allocation of contract management related roles / assignments and WBS within consortium partners for effective project management and profitable results.</li><li>Use of Contract Terms &amp; Conditions for enhancing project performance, monitoring, reporting, and achieving timely completion, thereby avoiding delays and disputes.</li></ol>
<p>This course can also be offered through Virtual Instructor Led Training (VILT) format.</p>
</div>
</section>
<section>
<div id="accordion">
<div>
<div>

Training Objectives 

</div>
<div id="collapseOne">
<div>
<p>Upon completion of the course, the participants will have learnt:</p>
<ul>
<li>Project management strictly in accordance with the contract and the corporate strategies.</li>
<li>How to ensure that Variations Order claims are appropriately managed in turnkey and lump-sum contracts.</li>
<li>Manage contemporary challenges and market factors with direct or indirect impact on the contracts.</li>
<li>Managing all members of the Supply Chain from vendors to logistics services providers.</li>
<li>Cost Engineering and Performance Management.</li>
<li>How to manage Consortium Partners, Contractors, and Owner's representatives.</li>
<li>When and how to obtain / grant extension of time (EOT) and costs.</li>
<li>Ability to identify rights and obligations of each party to a contract instead of making subjective decisions.</li>
<li>Ability to be firm in negotiations without violating terms of the agreements.</li>
<li>Ability to spot different legal systems, contract laws and arbitration rules.</li>
<li>Ability to negotiate and avoidance of disputes and resolution in amicable manner, in accordance with the provisions of the contract.</li>
<li>Competency in developing and maintaining documentary evidence and traceability for all works executed during the project.</li>
</ul>
</div>
</div>
</div>
<div>
<div>

Target Audience 

</div>
<div id="collapseTwo">
<div>
<p>This course is specially curated for professionals from International Oil &amp; Gas Industries including Offshore &amp; Marine Sectors. They include the <strong>heads of strategic business units, contracts managers, project directors, project managers, general managers, corporate legal counsels, procurements and supply chain managers, lawyers and legal professionals</strong> engaged in the EPCIC Segments of the Oil &amp; Gas Industry.</p>
<p> </p>
</div>
</div>
</div>
<div>
<div>

Course Level 

</div>
<div id="collapsecl">
<div>
<ul>
<li>Intermediate</li>
</ul>
</div>
</div>
</div>
<div>
<div>

Trainer

</div>
<div id="collapseFive">
<div>
<p><strong>Principal Management Consultant</strong></p>
<p>Chartered Valuer and Appraiser (CVA)</p>
<p>FACICA | FAMTAC | FAIADR | M.S.I.D | Member, AIEN</p>
<p>LL.M. (IP Law), M. Sc. (Maritime Studies),</p>
<p>M. Tech (Knowledge Engineering), MBA,</p>
<p>First Class CoC (MCA, UK), B. E. (Elect)</p>
<p>Your expert course leader, during the last 47 year period, has worked and consulted in the industry verticals encompassing: Technology, Oil &amp; Gas Exploration &amp; Production, Petrochemical Process Plants and Power Plant Construction Projects, Logistics &amp; Warehousing, Marine, Offshore, Oil &amp; Gas Pipelines, Infrastructure Development Projects (Ports, Offshore Supply Bases, Oil &amp; Gas Terminals and Airports etc), EPCIC Contracts, and Shipyards, in South East Asia, Africa, Middle East, Americas and Europe.</p>
<p>He serves as the Principal Management Consultant with a management consultancy in Hong Kong and Singapore, specialising in the fields of corporate management consultancy, international contracts reviews and alternative dispute resolutions services. He undertakes special assignments for conducting audits and valuation of intangible properties involving proprietary processes for licensed production, and licensing of intellectual property rights (IP Rights) in patents, trademarks, and industrial designs. He is frequently engaged for assignments like due diligence, acquisitions, mergers, resolving various operational issues, technology transfer and agency services contracts reviews, cost controls, and enhancement of Supply Chain Management. He has been conferred the credentials of Chartered Valuer &amp; Appraiser (CVA) by SAC and IVAS, in accordance with the international valuation standards setting body IVSC.</p>
<p>His consulting experience includes Charterparty Management, Business Process Re-engineering, Diversifications, Corporate Development, Marketing, Complex Project Management, Feasibility Studies, Dispute Resolutions and Market Research.</p>
<p>He has successfully assisted Marine and offshore E &amp; P clients in managing contractual disputes arising from various international contracts for upgrading &amp; conversion projects. He continues to be actively engaged in claims reviews, mediation, arbitration, litigation, and expert witness related assignments, arising from international contracts and Charterparty Agreements.</p>
<p>He graduated with a Bachelor's degree in Electrical Engineering, MBA in General Management, Master of Technology in Knowledge Engineering, Master of Science in Maritime Studies, and LL.M. (IP Law). He also holds professional qualifications in Business Valuations and Appraisers for CVA, arbitration, law, and marine engineering, including the Chief Engineer's First-Class Certificate of Competency (MCA, UK).</p>
<p>He is further qualified and accredited as Certified International Arbitrator, Chartered Arbitrator, Sports arbitrator under CAS Rules, WIPO Neutral, Australian Communications and Media Authority (ACMA) Bargaining Code Arbitrator, Accredited Adjudicator and Accredited Mediator (Malaysia). He is admitted to the international panels of arbitrators and neutrals with WIPO, Geneva; ACICA, AMTAC and ACMA, Australia; BVIAC (British Virgin Islands); JIAC (Jamaica); HKIAC Hong Kong; AIAC, Malaysia; AIADR, Malaysia; KCAB, Seoul, South Korea; ICA, Delhi, India; ICC (Singapore); SISV, Singapore; SCMA, Singapore; SCCA, Saudi Arabia; VIAC Vienna, Austria; Thailand Arbitration Centre (THAC), and Mediator with AIAC Malaysia, CMC, and SIMI Singapore.</p>
</div>
</div>
</div>
<div>
<div>

POST TRAINING COACHING SUPPORT (OPTIONAL)

</div>
<div id="collapseCS">
<div>
<p>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.<br />
Request for further information post training support and fees applicable</p>
</div>
</div>
</div>
<div>
<div>

Accreditions And Affliations

</div>
<div id="collapseSeven">
<div>
               </div>
</div>
</div>
</div>
</section>

EPCIC Contract Drafting and Management: With Essential Elements of International Contract Laws

<p style="color: rgb(255, 255, 255); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(255, 255, 255);"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><u fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Annual Child Protection Awareness Two Hour Course (In House)</strong></u></span></p><p style="color: rgb(255, 255, 255); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(255, 255, 255);"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">We are offering an Annual Child Protection Awareness Course at your organisation for up to 50 people for a low cost of &pound;800+vat.</span></p><p style="color: rgb(255, 255, 255); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(255, 255, 255);"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">It&rsquo;s essential that anyone who works or volunteers with children or young people has the knowledge and skills needed to help keep children safe. But what does that mean in practice?</span></p><p style="color: rgb(255, 255, 255); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(255, 255, 255);"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Statutory guidance sets out the child protection requirements for people working or volunteering with children in the UK. We can offer you an annual child protection awareness course for your staff looking at the following areas:</span></p><ol style="color: rgb(255, 255, 255); box-sizing: border-box;" fr-original-style=" color: rgb(255, 255, 255);"><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Introduction and Background to Safeguarding - Why this course is important, laws and guidance and the difference between safeguarding and child protection</li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Mechanics of Safeguarding - Keeping Children Safe in Education, individual responsibilities, governing body or proprietor responsibilities, headteacher responsibilities, DSL responsibilities, training, online safety and students missing from education.</li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Recognising Abuse and Neglect - Where does abuse take place?, signs of abuse in a student, general indicators, physical abuse (bruising, bite marks, burns and scalds, fractures, scars), recognising emotional abuse, recognising sexual abuse and recognising neglect.</li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Types of Abuse and Neglect - Radicalisation, extremism and terrorism, Prevent, reporting concerns, Prevent guidance, female genital mutilation (FGM), forced marriage and modern slavery.</li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Further Types of Abuse and Neglect - Child sexual exploitation (CSE), child criminal exploitation (including county lines), serious violent crime, grooming, online abuse, child trafficking, harmful sexual behaviour, child on child abuse, cybercrime, bullying and cyber bullying, domestic abuse, self-harm and self-neglect, other issues, children with additional vulnerabilities</li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Taking Action - Dealing with disclosures of abuse, concerns about abuse, recording information, confidentiality and record keeping, the continuum of need, the single assessment process, universal services, early help/prevention, child in need, child protection concerns, identifying children who might need early help, child protection procedures, local authority child protection procedures, looked after children and safeguarding, working with parents and further resources.</li></ol><p style="color: rgb(255, 255, 255); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(255, 255, 255);"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">This course is for any organisation that works with children and young people, no matter what sector you work in and can be run at anytime (two hour session), during the day or evening time.</span></p><p style="color: rgb(255, 255, 255); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(255, 255, 255);"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Contact us for further information.</span></p>

We are offering an Annual Child Protection Awareness Course at your organisation for up to 50 people for a low cost of £800+vat.

It’s essential that anyone who works or volunteers with children or young people has the knowledge and skills needed to help keep children safe. But what does that mean in practice?

Statutory guidance sets out the child protection requirements for people working or volunteering with children in the UK.

ANNUAL CHILD PROTECTION AWARENESS

Enquire for pricing

<p><strong>Course Objectives</strong></p><p>At the end of this course you will be able to:</p><ul><li>Identify the components of the Microsoft Project environment</li><li>Create a new project plan</li><li>Create the project schedule</li><li>Use different views to analyse the project plan</li><li>Create, allocate and manage resources in a project plan</li><li>Finalise a project plan</li><li>Track progress</li><li>View and report project plan information</li></ul><p>' 1 year email support service</p><p><em><strong>Customer Feedback</strong></em></p><ul><li><p><strong>Very good course. Learnt a lot. Looking forward to the next level.</strong></p></li><li>Alexandra - CIAL</li></ul><p>'</p><p>1 year email support service</p><p>Take a closer look at the <strong>consistent excellent feedback from our growing corporate clients</strong> visiting our site <em><strong>ms-officetraining co uk</strong></em></p><p>With more than 20 years experience, we deliver courses on all levels of the Desktop version of <strong>Microsoft Office and Office 365</strong>; ranging from Beginner, Intermediate, Advanced to the VBA level.</p><p>Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering<strong> public, one to one, tailored and bespoke courses.</strong></p><ul><li><strong>Our competitive rates <strong>start from £550.00 per day of training</strong></strong></li></ul><p><strong><strong>Tailored training courses:</strong></strong></p><p>You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs.</p><p><strong>Introduction to Microsoft Project</strong></p><ul><li>Recap on project management concepts</li><li>Project environment overview</li><li>The 3 databases: Tasks, Resources and Assignments</li><li>Different ways of displaying the Project Plan</li><li>Access Help</li></ul><p><strong>Creating a Project Plan</strong></p><ul><li>Create a New Project Plan</li><li>Project Information</li><li>Create and apply the project calendar</li><li>Defining recurring exceptions to the calendar</li><li>Defining the calendar's work weeks</li><li>Create the Summary tasks</li><li>Create the Work Breakdown Structure</li></ul><p><strong>Task creation and scheduling</strong></p><ul><li>Exploring the Entry Table and its fields</li><li>Task editing and the Task Information window</li><li>Task Durations</li><li>Defining Milestones</li><li>Manual Scheduling vs Automatic Scheduling</li><li>Changing the Task's Calendar</li><li>Create a split in a Task</li><li>Create Task Relationships</li><li>Adding Lag or Lead to a Relationship</li><li>Identifying the Critical Path</li><li>Adding Constraints and Deadlines to Tasks</li><li>Create Recurring Activities</li><li>Adding Notes and links to Tasks</li></ul><p><strong>Managing Resources</strong></p><ul><li>Exploring the Entry Table and its fields</li><li>Resource editing and the Resource Information window</li><li>Resource Types</li><li>Fixed Costs vs Variable Costs</li><li>Adding Resource Costs</li><li>Defining when costs accrue</li><li>Changing the Resource Calendar and Availability</li><li>Project calendar vs Resource and Task Calendar</li><li>Assigning Resources to Tasks</li><li>Effort Driven Scheduling</li><li>Resolving Resource Overallocation</li></ul><p><strong>Tracking the Project Progress</strong></p><ul><li>Setting a Project Baseline</li><li>Entering Actuals</li><li>Different ways of viewing the Progress</li><li>Checking if the Project is on track</li></ul><p><strong>Viewing and Reporting Project Detail</strong></p><ul><li>Adding Tasks to the Timeline and sharing it</li><li>Modifying the Timescale and Zoom level</li><li>Formatting the Gantt View</li><li>Filtering and Grouping Tasks</li><li>Print and Troubleshoot the Gantt View</li><li>Using built-in Reports in Microsoft Project</li></ul><h2>
        
            Who is this course for?
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                            <p>This course is designed for a person who has an understanding of project management concepts, who is responsible for creating and modifying project plans, and who needs a tool to manage these project plans.</p>
                        </div><h2>
        
            Requirements
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>General knowledge of the Windows OS</p>
                        </div><h2>
        
            Career path
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <p>Microsoft Office know-how can instantly increase your job prospects as well as your salary.</p><p>80 percent of job openings require spreadsheet and word-processing software skills</p>
                        </div><h2>
        
            Certificates
        
        <div>Certificates</div>
    </h2>

                        <div id="optional_extras">
                                    <h4>Certificate of completion</h4>
        <p>
            Digital certificate -
            Included
        </p>

                        </div>

Microsoft Office Training

Microsoft Project Introduction - In-company

<p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span fr-original-style="" style="box-sizing: border-box;">Course Overview:</span></strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span fr-original-style="" style="box-sizing: border-box;">The "Clinical Safe Holding Techniques" course is designed to provide healthcare professionals with the knowledge and skills required for safe and effective patient "restrictive" holding during various clinical procedures. Holding patients securely and comfortably is crucial for ensuring procedural success, minimising patient discomfort, and preventing injuries to both patients and healthcare providers. This course offers comprehensive training in techniques for holding patients safely during medical examinations, procedures, and interventions.</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course Duration:</strong>&nbsp;</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">1 day (6 hours)</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course Content:</strong></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span fr-original-style="" style="box-sizing: border-box;">By the end of this course, participants will be able to:</span></p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span fr-original-style="" style="box-sizing: border-box;">1. Importance of communication, de-escalation and positive behavioural support</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span fr-original-style="" style="box-sizing: border-box;">2. Risk assessment and least restrictive options</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span fr-original-style="" style="box-sizing: border-box;">3. Teamwork including having a &ldquo;communicator&rdquo; and a &ldquo;monitor&rdquo;&nbsp;</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span fr-original-style="" style="box-sizing: border-box;">4. Preventing risk of injury and harm including positional asphyxia</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span fr-original-style="" style="box-sizing: border-box;">5. Low level restrictive holds including double wrist hold, straight arm immobilisation, seating to rest position, managing kicking and the safe use of equipment including wedge, pod, beanbags all for use during clinical interventions</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span fr-original-style="" style="box-sizing: border-box;">6. Debrief and record keeping</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course Objectives:</strong></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span fr-original-style="" style="box-sizing: border-box;">1. Understand Safe Holding Fundamentals: Comprehend the importance of safe holding techniques in managing challenging behaviours and ensuring the safety of all parties involved.</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span fr-original-style="" style="box-sizing: border-box;">2. Master Safe Holding Techniques: Develop proficiency in performing safe holding techniques that prioritise the physical and emotional well-being of the individual and the healthcare team.</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span fr-original-style="" style="box-sizing: border-box;">3. Prioritise Communication and De-Escalation: Learn effective communication skills and de-escalation strategies to prevent challenging situations from escalating further.</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span fr-original-style="" style="box-sizing: border-box;">4. Implement Ethical and Legal Considerations: Understand the ethical and legal aspects of safe holding, including informed consent, documentation, and reporting.</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span fr-original-style="" style="box-sizing: border-box;">5. Promote a Therapeutic Environment: Develop techniques to maintain a therapeutic and supportive environment while addressing aggressive or challenging behaviours.</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Assessment and Certification:</strong></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span fr-original-style="" style="box-sizing: border-box;">Participants will undergo practical skills assessments to evaluate their ability to safely and effectively hold patients during various clinical procedures. Successful completion will lead to a certification of achievement in "Clinical Safe Holding Techniques."</span></p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span fr-original-style="" style="box-sizing: border-box;">Note: This course overview is a general guideline and can be customised to suit specific local requirements and preferences, therefore, we recommend that you contact us to discuss your requirements prior to making a booking.&nbsp;<strong id="isPasted" fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Please note the price quoted is based on a one-day duration and will therefore increase as your needs increase. &nbsp;</strong></span></strong></p>

Guardian Angels Training

Gain comprehensive training in safe holding techniques for medical procedures with our "Clinical Safe Holding Techniques" course. Ensure procedural success and prevent injuries to patients and healthcare providers.

Clinical Safe Holding

<div fr-original-style="" style="box-sizing: border-box;">
</div>
<section fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<h2 fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">About this Training Course</strong><em fr-original-style="" style="box-sizing: border-box;">&nbsp;</em></h2>
<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This 3 full-day training course will introduce participants to the Microsoft Power BI<sup fr-original-style="" style="box-sizing: border-box;">&reg;</sup>&nbsp;software solution for extracting, manipulating, visualising and analysing data. This is a very practical, hands-on course that takes participants through a series of exercises which help users understand the Power BI<sup fr-original-style="" style="box-sizing: border-box;">&reg;</sup>&nbsp;environment, how to use the key areas of functionality, and how to apply the tools it contains to design and produce analyses of their own data.</p>
<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The first two days focus on learning the key concepts and practising these using clean, simple datasets.&nbsp;The third day provides participants with the opportunity to apply what they&#39;ve learned to their own data. This makes the course far more relevant and meaningful for them, it allows our facilitator to help them structure their data models, queries and DAX formulas correctly, and it allows our facilitator to help them solve any additional problems that may arise but which were not covered as part of the standard the course. In addition, at the end of the day, each participant walks away with something of real, practical use for their job role. Many previous participants have remarked that they obtained the most value from the course during the third day because otherwise, they wouldn&#39;t be able to do what they need to do.</p>
<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This is an introductory course and although it does not assume any prior experience with Power BI<sup fr-original-style="" style="box-sizing: border-box;">&reg;</sup>, participants will gain much more from the course if they have at least used Power BI<sup fr-original-style="" style="box-sizing: border-box;">&reg;</sup>&nbsp;a little prior to attending. Participants who have taught themselves Power BI<sup fr-original-style="" style="box-sizing: border-box;">&reg;</sup>&nbsp;will also benefit from attending as the course will fill-in a number of gaps in their knowledge and will also extend what they know. A general understanding of databases, Excel formulas, and Excel Pivot Tables is useful though not essential. Comprehensive course notes, exercises and completed solutions are included.</p>
<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;">Microsoft&reg;&nbsp;PowerBI&reg; is a&nbsp;trademark&nbsp;of Microsoft Corporation in the United States and/or other countries.</em></strong></p>
</div>
</section>
<section fr-original-style="" style="box-sizing: border-box;">
<div id="accordion" fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">

Training Objectives 

</div>
<div id="collapseOne" fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Upon completion of this training course, participants will be able to:</p>
<ul fr-original-style="" style="box-sizing: border-box;">
<li fr-original-style="" style="box-sizing: border-box;">Confidently use the Power BI<sup fr-original-style="" style="box-sizing: border-box;">&reg;</sup>&nbsp;solution, including Power BI<sup fr-original-style="" style="box-sizing: border-box;">&reg;</sup>&nbsp;Desktop, PowerBI<sup fr-original-style="" style="box-sizing: border-box;">&reg;</sup>.com and the Power BI<sup fr-original-style="" style="box-sizing: border-box;">&reg;</sup>&nbsp;Gateway</li>
<li fr-original-style="" style="box-sizing: border-box;">Extract data from a variety of data sources and manipulate the data extracted so it is ready for analysis</li>
<li fr-original-style="" style="box-sizing: border-box;">Combine data sources together and gain an introductory understanding of the M language</li>
<li fr-original-style="" style="box-sizing: border-box;">Write formulas using the DAX language for generating custom columns, measures and tables</li>
<li fr-original-style="" style="box-sizing: border-box;">Design reports and dashboards using a wide range of both built-in and custom visuals</li>
<li fr-original-style="" style="box-sizing: border-box;">Publish reports and dashboards to PowerBI<sup fr-original-style="" style="box-sizing: border-box;">&reg;</sup>.com</li>
<li fr-original-style="" style="box-sizing: border-box;">Share reports and dashboards with others using PowerBI<sup fr-original-style="" style="box-sizing: border-box;">&reg;</sup>.com</li>
<li fr-original-style="" style="box-sizing: border-box;">Customize reports and dashboards so that different user groups automatically see their own personalized views</li>
</ul>
</div>
</div>
</div>
<div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">

Target Audience 

</div>
<div id="collapseTwo" fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This training course is intended for:</p>
<ul fr-original-style="" style="box-sizing: border-box;">
<li fr-original-style="" style="box-sizing: border-box;">Financial Analysts</li>
<li fr-original-style="" style="box-sizing: border-box;">Accountants</li>
<li fr-original-style="" style="box-sizing: border-box;">Budgeting and planning specialists</li>
<li fr-original-style="" style="box-sizing: border-box;">Treasury</li>
<li fr-original-style="" style="box-sizing: border-box;">Risk Managers</li>
<li fr-original-style="" style="box-sizing: border-box;">Strategic Planners</li>
</ul>
<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This is an introductory course and although it does not assume any prior experience with Power BI<sup fr-original-style="" style="box-sizing: border-box;">&reg;</sup>, participants will gain much more from the course if they have at least used Power BI<sup fr-original-style="" style="box-sizing: border-box;">&reg;</sup>&nbsp;a little prior to attending. Participants who have taught themselves Power BI<sup fr-original-style="" style="box-sizing: border-box;">&reg;</sup>&nbsp;will also benefit from attending as the course will fill-in a number of gaps in their knowledge and will also extend what they know. A general understanding of databases, Excel formulas, and Excel Pivot Tables is useful though not essential. Comprehensive course notes, exercises and completed solutions are included.</p>
</div>
</div>
</div>
<div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">

Course Level 

</div>
<div id="collapsecl" fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<ul fr-original-style="" style="box-sizing: border-box;">
<li fr-original-style="" style="box-sizing: border-box;">Basic or Foundation</li>
</ul>
</div>
</div>
</div>
<div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">

Trainer

</div>
<div id="collapseFive" fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Your expert course leader has a Masters (Applied Finance &amp; Investment), B.Comm (Accounting &amp; Information Systems), CISA, FAIM, F Fin and is a Microsoft Certified Excel Expert. He has over 20 years&#39; experience in financial modelling, forecasting, valuation, model auditing, and management reporting for clients throughout the world. He is skilled in the development and maintenance of analytical tools and financial models for middle-market companies to large corporates, at all levels of complexity, in both domestic and international settings.</p>
<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">He has trained delegates from a wide variety of Oil &amp; Gas companies including Chevron, Woodside, BHP Billiton, Petronas, Carigali, Shell, Nippon, Eni, Pertamina, Inpex, and many more. He provides training in financial modelling for companies throughout the Asia, Oceania, Middle East and African regions.</p>
<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Before his current role, he spent 6 years working in the Corporate and IT Consulting divisions of a large, multinational Chartered Accounting firm.</p>
<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">He is the author of a number of white papers on financial modelling on subjects such as Financial Modelling Best Practices and Financial Model Auditing.</p>
<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Highlights from his oil and gas experience include:</strong></p>
<ul fr-original-style="" style="box-sizing: border-box;">
<li fr-original-style="" style="box-sizing: border-box;">Development of economic models to assist Decision Analysts modelling for a wide range of scenarios for multinational oil &amp; gas assets.</li>
<li fr-original-style="" style="box-sizing: border-box;">Auditing and further development of life of project models for Chevron&#39;s Strategic Planning Division analysing their North West Shelf assets.</li>
<li fr-original-style="" style="box-sizing: border-box;">Development of business plan and budgeting models for multinational oil &amp; gas assets.</li>
<li fr-original-style="" style="box-sizing: border-box;">Development of cash flow and taxation models for a variety of oil gas companies.</li>
<li fr-original-style="" style="box-sizing: border-box;">Consulting on Sarbanes Oxley spreadsheet remediation and risk assessment.</li>
</ul>
</div>
</div>
</div>
<div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">

POST TRAINING COACHING SUPPORT (OPTIONAL)

</div>
<div id="collapseCS" fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">To further optimise your learning experience from our courses, we also offer individualized &#39;One to One&#39; 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.<br fr-original-style="" style="box-sizing: border-box;">
Request for further information post training support and fees applicable</p>
</div>
</div>
</div>
<div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">

Accreditions And Affliations

</div>
<div id="collapseSeven" fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
               </div>
</div>
</div>
</div>
</section>

Power BI® - Business Data Analytics

<p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course Overview:</strong></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span fr-original-style="" style="box-sizing: border-box;">The Level 3 Endorsed Award in Delivering Health and Social Care Training (Healthcare Train the Trainer) is a comprehensive program designed to equip individuals with the knowledge and skills required to become proficient trainers in the healthcare sector. This endorsed course provides a structured pathway for professionals seeking to enhance their ability to train others effectively in the delivery of health and social care services.</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course Duration:</strong></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span fr-original-style="" style="box-sizing: border-box;">This course is designed around the needs of organisation and individuals. &nbsp;</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span fr-original-style="" style="box-sizing: border-box;">Typically delivered over a 2 days - 4 weeks depending upon how many optional units are selected.&nbsp;</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span fr-original-style="" style="box-sizing: border-box;">Participants are encouraged to engage in self-directed study to complement their in-classroom learning.<br fr-original-style="" style="box-sizing: border-box;"></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></strong></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course Content:</strong></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span fr-original-style="" style="box-sizing: border-box;">Upon successful completion of this course, participants will:</span></p><ol fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Understand the principles of adult learning and its application within the healthcare context.</li><li fr-original-style="" style="box-sizing: border-box;">Develop effective communication and presentation skills to engage and instruct healthcare professionals.</li><li fr-original-style="" style="box-sizing: border-box;">Gain insights into the key legal and ethical considerations within the healthcare training environment.</li><li fr-original-style="" style="box-sizing: border-box;">Create and deliver tailored training programs that align with healthcare best practices.</li><li fr-original-style="" style="box-sizing: border-box;">Assess the learning needs of healthcare staff and adapt training approaches accordingly.</li><li fr-original-style="" style="box-sizing: border-box;">Evaluate training outcomes and continually improve the quality of healthcare training delivery.</li><li fr-original-style="" style="box-sizing: border-box;">Comprehend the importance of safeguarding and promoting the welfare of individuals within healthcare settings.</li></ol><div fr-original-style="" style="box-sizing: border-box;"><span fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></span></div><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course Objectives:</strong></span></p><ol fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Understanding the Principles of Adult Learning and Its Application within the Healthcare Context:</p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Develop an understanding of the theories and concepts related to adult learning, enabling participants to tailor their teaching methods to suit the unique needs of healthcare professionals, ensuring that training is effective and engaging.</li></ul></li><li fr-original-style="" style="box-sizing: border-box;"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Developing Effective Communication and Presentation Skills to Engage and Instruct Healthcare Professionals:</p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Cultivate effective communication skills that are clear, concise, and empathetic, essential for healthcare trainers. Additionally, acquire the ability to structure and deliver compelling presentations that resonate with healthcare professionals, thereby enhancing the engagement and impact of training.</li></ul></li><li fr-original-style="" style="box-sizing: border-box;"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Gaining Insights into the Key Legal and Ethical Considerations within the Healthcare Training Environment:</p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Explore the intricate legal and ethical aspects relevant to healthcare trainers, including compliance with healthcare regulations, maintaining patient confidentiality, and addressing ethical dilemmas that may arise during training sessions.</li></ul></li><li fr-original-style="" style="box-sizing: border-box;"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Creating and Delivering Tailored Training Programmes that Align with Healthcare Best Practices:</p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Develop the capacity to design and deliver training programmes that are not only relevant but also aligned with current best practices in healthcare. This includes addressing specific healthcare challenges and incorporating the latest evidence-based practices.</li></ul></li><li fr-original-style="" style="box-sizing: border-box;"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Assessing the Learning Needs of Healthcare Staff and Adapting Training Approaches Accordingly:</p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Recognise the diversity in learning needs among healthcare professionals and gain proficiency in accurately assessing these needs. Participants will learn to adapt their training methods and content to cater to different learning styles and levels of expertise.</li></ul></li><li fr-original-style="" style="box-sizing: border-box;"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Evaluating Training Outcomes and Continually Improving the Quality of Healthcare Training Delivery:</p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Understand the importance of continuous improvement in healthcare training. Participants will acquire the ability to evaluate the effectiveness of their training programmes, collect feedback from participants, and make necessary adjustments to enhance the quality and impact of their training initiatives.</li></ul></li><li fr-original-style="" style="box-sizing: border-box;"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Comprehending the Importance of Safeguarding and Promoting the Welfare of Individuals within Healthcare Settings:</p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Recognise the paramount importance of ensuring the safety and well-being of patients and healthcare staff. Trainers will learn to identify signs of abuse and neglect, understand reporting procedures, and actively promote a safe and supportive healthcare environment during their training sessions.</li></ul></li></ol><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Units:</strong><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></strong></span></p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span fr-original-style="" style="box-sizing: border-box;">The mandatory unit is: "Delivering Inclusive Learning Sessions in Health and Social Care" and is delivered over 12 hours.&nbsp;</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span fr-original-style="" style="box-sizing: border-box;">Optional "subject-matter" units include:</span></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;"><span fr-original-style="" style="box-sizing: border-box;">basic life support trainer</span></li><li id="isPasted" fr-original-style="" style="box-sizing: border-box;"><span fr-original-style="" style="box-sizing: border-box;">medication trainer<br fr-original-style="" style="box-sizing: border-box;"></span></li><li fr-original-style="" style="box-sizing: border-box;"><span fr-original-style="" style="box-sizing: border-box;">people handling trainer</span></li><li fr-original-style="" style="box-sizing: border-box;"><span fr-original-style="" style="box-sizing: border-box;">infection control trainer</span></li><li fr-original-style="" style="box-sizing: border-box;">dementia care trainer</li><li fr-original-style="" style="box-sizing: border-box;">stoma care trainer</li><li fr-original-style="" style="box-sizing: border-box;">catheter care trainer</li><li fr-original-style="" style="box-sizing: border-box;">wound care trainer</li><li fr-original-style="" style="box-sizing: border-box;">epilepsy care trainer</li><li fr-original-style="" style="box-sizing: border-box;">clinical skills trainer (urinary catheterisation, venepuncture, nasogastric tube etc.)</li><li fr-original-style="" style="box-sizing: border-box;">this list is not exhaustive, other optional units can be bolted on to meet the needs of the organisation and individual trainers.&nbsp;</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></strong></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Assessment:</strong></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span fr-original-style="" style="box-sizing: border-box;">Assessment for this course includes a combination of written assignments, practical assessments, and a final project. Participants must successfully complete all assessments to achieve the Level 3 Endorsed Award in Delivering Health and Social Care Training.</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong id="isPasted" fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span fr-original-style="" style="box-sizing: border-box;">Note: This course overview is a general guideline and can be customised to suit specific local requirements and preferences, therefore, we recommend that you contact us to discuss your requirements prior to making a booking.&nbsp; Please note the price quoted is based on a two-day duration and will therefore increase as your needs increase.&nbsp;&nbsp;</span></strong></p>

Gain expertise in healthcare training with our Level 3 Endorsed Award in Delivering Health and Social Care Training. Our comprehensive program equips you with the skills and knowledge to become a proficient trainer in the healthcare sector.

Level 3 Endorsed Award in Delivering Health and Social Care Training (Healthcare Train the Trainer)

<div id="course-pills-1">Duration<p>2 Days</p><p>12 CPD hours</p>This course is intended for<p>The primary audience for this course are persons who are new to reporting with MicrosoftÂ© SQL ServerÂ© Report Builder and SSRS, persons who are transitioning from another reporting software application, and persons who are existing Report Builder and SSRS report authors. The secondary audience for this course are persons who are using Report Designer (SSRS). Course participants may be business analysts, programmer analysts, data analysts, database administrators, or IT professionals and may or may not have experience with MicrosoftÂ© SQL ServerÂ© Report Builder and SSRS, programming (Visual Basic), and/or Transact-Structured Query Language (T-SQL) experience.</p>Overview<p>After completing this course, students will be able to: Create parameter reports. Create list reports. Format reports with complex expressions. Add images and subreports. Add drilldown and drillthrough functionality. Add sparklines, data bars, and indicators.</p><p>In this course, students will continue their learning on the foundations of report writing with MicrosoftÂ© SQL ServerÂ© Report Builder and SSRS. The focus will be on report creation by connecting to a database and manipulating the data.</p></div><div id="course-pills-2"><h3>1 - Parameter Reports</h3> <ul> <li>Parameterized Reporting</li> <li>Create Report Parameters</li> <li>Modify Report Parameters</li> <li>Provide Default Parameter Values</li> <li>Provide Available Values for Parameters</li> <li>Lab: Creating Parameterized Reports</li> </ul> <h3>2 - List Data Regions</h3> <ul> <li>Introducing the List Data Region</li> <li>Create Reports Using List Data Regions</li> <li>Modify Reports Which Use List Data Regions</li> <li>Lab: Creating List Reports</li> </ul> <h3>3 - Enhancing Reports with Complex Expressions</h3> <ul> <li>Formatting Reports</li> <li>Top N Reports</li> <li>Running Values</li> <li>Lab: Enhancing Reports with Complex Expressions</li> </ul> <h3>4 - Enhance Reports with Images and Subreports</h3> <ul> <li>Add Images to Reports</li> <li>Retrieve Images from a Database</li> <li>Introducing SSRS (SQL Server Reporting Services) Report Server</li> <li>Add Subreports to Reports</li> <li>Lab: Working With Images and Subreports</li> </ul> <h3>5 - Drilldown and Drillthrough Reports</h3> <ul> <li>Add and Configure Drilldown Reporting</li> <li>Add and Configure Drillthrough Reporting</li> <li>Lab: Add Drilldown and Drillthrough Functionality to Reports</li> </ul> <h3>6 - Sparklines, Data Bars, and Indicators</h3> <ul> <li>Sparklines</li> <li>Data Bars</li> <li>Indicators</li> <li>Lab: Adding Sparklines, Data Bars, and Indicators to Reports</li> </ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans 55128 Writing Reports with Report Builder and SSRS Level 2 training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. </p><p></p> This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. <p></p>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.  <p></p>While we feel this is the best course for the 55128 Writing Reports with Report Builder and SSRS Level 2 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.  <p></p>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.<p></p></div>

Nexus Human

SSRS

Service Design Courses (SDC)

Report Writing

Manager Training

Trainers Course

Teaching & Training

55128 Writing Reports with Report Builder and SSRS Level 2

<span dir="ltr" id="isPasted" fr-original-style="" style="box-sizing: border-box;"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Power BI is a suite of business analytics tools that deliver insights throughout your organization. Connect to hundreds of data sources, simplify data prep, and drive ad-hoc analysis.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span dir="ltr" fr-original-style="" style="box-sizing: border-box;">The course will introduce all the Power BI technologies including Power Query, DAX, Data Modelling (Power Pivot), M. We will go through a methodology for automating all your reporting needs and teach you how to create beautiful reports and dashboards giving you a 360-degree view of your business.</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This instructor-led course includes:</p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">2 weeks of self-paced essential learning content that you are to complete before the instructor-led live virtual sessions begin</li><li fr-original-style="" style="box-sizing: border-box;">6 instructor-led liver-virtual sessions of 2 hours each. Each Session will have a 15-minute break.</li><li fr-original-style="" style="box-sizing: border-box;">Intersession Assignments that you are expected to complete and discuss in your preassigned groups during the session.</li><li fr-original-style="" style="box-sizing: border-box;">Capstone Project</li><li fr-original-style="" style="box-sizing: border-box;">Access to our community of life-long learners.</li><li fr-original-style="" style="box-sizing: border-box;">Downloadable Certificate you can link to your LinkedIn Page</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">For more details about this course, visit bit.ly/dbrownPBItraining&nbsp;</p></span>

dbrownconsulting

Powerbi

Microsoft Power BI

Data Analysis

Data Analyst

Business Data Analysis

Supercharge your skills and career and learn in-demand knowledge needed to build business intelligence dashboards. This beginner to intermediate level course will introduce you to all the Power BI technologies i.e. Power Query, DAX, Data Modelling (Power Pivot), M, types of visualizations, etc.

Reporting and Analytics with Power BI

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>This course is for experienced information technology (IT) professionals, typically described as Enterprise Desktop Administrators (EDAs). These EDAs deploy, manage, and maintain PCs, devices, and applications across medium, large, and enterprise organizations. A significant portion of this audience uses, or intends to use, the latest release of Configuration Manager to manage and deploy PCs, devices, and applications.</p>Overview<p>Describe the features Configuration Manager and Intune include, and explain how you can use these features to manage PCs and mobile devices in an enterprise environment. Analyze data by using queries and reports. Prepare a management infrastructure, including configuring boundaries, boundary groups, and resource discovery, and integrating mobile-device management with Intune. Deploy and manage the Configuration Manager client. Configure, manage, and monitor hardware and software inventory, and use Asset Intelligence and software metering. Identify and configure the most appropriate method to distribute and manage content used for deployments. Distribute, deploy, and monitor applications for managed users and systems. Maintain software updates for PCs that Configuration Manager manages. Implement Endpoint Protection for managed PCs. Configure an operating-system deployment strategy by using Configuration Manager. Manage and maintain a Configuration Manager site.</p><p>This five-day course describes how to use Configuration Manager and its associated site systems to efficiently manage network resources. In this five-day course, you will learn day-to-day management tasks, including how to manage applications, client health, hardware and software inventory, operating system deployment, and software updates by using Configuration Manager. You also will learn how to optimize Endpoint Protection, manage compliance, and create management queries and reports.  Although this course and the associated labs are written for Microsoft Endpoint Configuration Manager and Windows 11, the skills taught will also be backwards compatible with previous editions of System Center Configuration Manager and Windows 10.</p>Prerequisites<p></p><li>Networking fundamentals, including common networking protocols, topologies, hardware, media, routing, switching, and addressing.</li>  <li>Active Directory Domain Services (AD DS) principles and fundamentals of AD DS management.</li>  <li>Installation, configuration, and troubleshooting for Windows-based personal computers.</li>  <li>Basic concepts of public key infrastructure (PKI) security.</li>  <li>Basic understanding of scripting and Windows PowerShell syntax.</li>  <li>Basic understanding of Windows Server roles and services.</li>  <li>Basic understanding of the configuration options for iOS and Android Mobile device platforms.</li><p></p></div><div id="course-pills-2"><h3>1 - Managing computers and mobile devices in the enterprise</h3> <ul> <li>Overview of systems management by using enterprise management solutions</li> <li>Overview of the Configuration Manager architecture</li> <li>Overview of the Configuration Manager administrative tools</li> <li>Tools for monitoring and troubleshooting a Configuration Manager site</li> </ul> <h3>2 - Analyzing data using queries, reports, and CMPivot</h3> <ul> <li>Introduction to queries</li> <li>Configuring SQL Server Reporting Services</li> <li>Analyzing the real-time state of a device by using CMPivot</li> </ul> <h3>3 - Preparing the Configuration Manager management infrastructure</h3> <ul> <li>Configuring site boundaries and boundary groups</li> <li>Configuring resource discovery</li> <li>Organizing resources using device and user collections</li> </ul> <h3>4 - Deploying and managing the Configuration Manager client</h3> <ul> <li>Overview of the Configuration Manager client</li> <li>Deploying the Configuration Manager client</li> <li>Configuring and monitoring client status</li> <li>Managing client settings and performing management operations</li> </ul> <h3>5 - Managing inventory for PCs and applications</h3> <ul> <li>Overview of inventory collection</li> <li>Configuring hardware and software inventory</li> <li>Managing inventory collection</li> <li>Configuring software metering</li> <li>Configuring and managing Asset Intelligence</li> </ul> <h3>6 - Distributing and managing content used for deployments</h3> <ul> <li>Preparing the infrastructure for content management</li> <li>Distributing and managing content on distribution points</li> </ul> <h3>7 - Deploying and managing applications</h3> <ul> <li>Overview of application management</li> <li>Creating applications</li> <li>Deploying applications</li> <li>Managing applications</li> <li>Deploying and managing Windows apps</li> </ul> <h3>8 - Maintaining software updates for managed PCs</h3> <ul> <li>The software updates process</li> <li>Preparing a Configuration Manager site for software updates</li> <li>Managing software updates</li> <li>Configuring automatic deployment rules</li> <li>Monitoring and troubleshooting software updates</li> <li>Enabling third-party updates</li> </ul> <h3>9 - Implementing Defender Protection for managed PCs</h3> <ul> <li>Overview of Endpoint Protection in Configuration Manager</li> <li>Configuring, deploying, and monitoring Endpoint Protection policies</li> <li>Configuring and deploying advanced threat policies</li> <h3>10 - Managing compliance and secure data access</h3> <ul> <li>Overview of Compliance Settings</li> <li>Configuring compliance settings</li> <li>Viewing compliance results</li> <li>Managing resource and data access</li> <h3>11 - Managing operating system deployment</h3> <ul> <li>An overview of operating system deployment</li> <li>Preparing a site for operating system deployment</li> <li>Deploying an operating system</li> <li>Managing Windows as a service</li> <h3>12 - Managing and maintaining a Configuration Manager site</h3> <ul> <li>Configuring role-based administration</li> <li>Configuring Remote Tools</li> <li>Overview of Configuration Manager site maintenance and Management Insights</li> <li>Backing up and recovering a Configuration Manager site</li> <li>Updating the Configuration Manager infrastructure</li> <h3>13 - What?s new in Microsoft Endpoint Configuration Manager</h3> <ul> <li>Whats new in Microsoft Endpoint Manager covering each semi annual release</li> </ul></ul></ul></ul></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans 55348: Administering Microsoft Endpoint Configuration Manager training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. </p><p></p> This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. <p></p>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.  <p></p>While we feel this is the best course for the 55348: Administering Microsoft Endpoint Configuration Manager 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.  <p></p>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.<p></p></div>

Microsoft Certification

Sccm

Microsoft Certified Technology Specialist (MCTS)

Commercial & Contract Management Certification Program (CCM)

IT Manager

Microsoft Certified Trainer (MCT)

55348 Administering Microsoft Endpoint Configuration Manager

<div id="course-pills-1">Duration<p>4 Days</p><p>24 CPD hours</p>This course is intended for<p></p><p>The Microsoft Security Operations Analyst collaborates with organizational stakeholders to secure information technology systems for the organization. Their goal is to reduce organizational risk by rapidly remediating active attacks in the environment, advising on improvements to threat protection practices, and referring violations of organizational policies to appropriate stakeholders. Responsibilities include threat management, monitoring, and response by using a variety of security solutions across their environment. The role primarily investigates, responds to, and hunts for threats using Microsoft Sentinel, Microsoft Defender for Cloud, Microsoft 365 Defender, and third-party security products. Since the Security Operations Analyst consumes the operational output of these tools, they are also a critical stakeholder in the configuration and deployment of these technologies.</p><p></p><p></p><p>Learn how to investigate, respond to, and hunt for threats using Microsoft Sentinel, Microsoft Defender for Cloud, and Microsoft 365 Defender. In this course you will learn how to mitigate cyberthreats using these technologies. Specifically, you will configure and use Microsoft Sentinel as well as utilize Kusto Query Language (KQL) to perform detection, analysis, and reporting. The course was designed for people who work in a Security Operations job role and helps learners prepare for the exam SC-200: Microsoft Security Operations Analyst.</p><p></p>Prerequisites<p></p><li>Basic understanding of Microsoft 365</li>  <li>Fundamental understanding of Microsoft security, compliance, and identity products</li>   <li> Intermediate understanding of Windows 10</li>  <li> Familiarity with Azure services, specifically Azure SQL Database and Azure Storage</li>   <li> Familiarity with Azure virtual machines and virtual networking</li>   <li>Basic understanding of scripting concepts.</li><p></p></div><div id="course-pills-2"><h3>1 - Introduction to Microsoft 365 threat protection</h3> <ul> <li>Explore Extended Detection &amp; Response (XDR) response use cases</li> <li>Understand Microsoft Defender XDR in a Security Operations Center (SOC)</li> <li>Explore Microsoft Security Graph</li> <li>Investigate security incidents in Microsoft Defender XDR</li> </ul> <h3>2 - Mitigate incidents using Microsoft 365 Defender</h3> <ul> <li>Use the Microsoft Defender portal</li> <li>Manage incidents</li> <li>Investigate incidents</li> <li>Manage and investigate alerts</li> <li>Manage automated investigations</li> <li>Use the action center</li> <li>Explore advanced hunting</li> <li>Investigate Microsoft Entra sign-in logs</li> <li>Understand Microsoft Secure Score</li> <li>Analyze threat analytics</li> <li>Analyze reports</li> <li>Configure the Microsoft Defender portal</li> </ul> <h3>3 - Protect your identities with Microsoft Entra ID Protection</h3> <ul> <li>Microsoft Entra ID Protection overview</li> <li>Detect risks with Microsoft Entra ID Protection policies</li> <li>Investigate and remediate risks detected by Microsoft Entra ID Protection</li> </ul> <h3>4 - Remediate risks with Microsoft Defender for Office 365</h3> <ul> <li>Automate, investigate, and remediate</li> <li>Configure, protect, and detect</li> <li>Simulate attacks</li> </ul> <h3>5 - Safeguard your environment with Microsoft Defender for Identity</h3> <ul> <li>Configure Microsoft Defender for Identity sensors</li> <li>Review compromised accounts or data</li> <li>Integrate with other Microsoft tools</li> </ul> <h3>6 - Secure your cloud apps and services with Microsoft Defender for Cloud Apps</h3> <ul> <li>Understand the Defender for Cloud Apps Framework</li> <li>Explore your cloud apps with Cloud Discovery</li> <li>Protect your data and apps with Conditional Access App Control</li> <li>Walk through discovery and access control with Microsoft Defender for Cloud Apps</li> <li>Classify and protect sensitive information</li> <li>Detect Threats</li> </ul> <h3>7 - Respond to data loss prevention alerts using Microsoft 365</h3> <ul> <li>Describe data loss prevention alerts</li> <li>Investigate data loss prevention alerts in Microsoft Purview</li> <li>Investigate data loss prevention alerts in Microsoft Defender for Cloud Apps</li> </ul> <h3>8 - Manage insider risk in Microsoft Purview</h3> <ul> <li>Insider risk management overview</li> <li>Create and manage insider risk policies</li> <li>Investigate insider risk alerts</li> <li>Take action on insider risk alerts through cases</li> <li>Manage insider risk management forensic evidence</li> <li>Create insider risk management notice templates</li> </ul> <h3>9 - Investigate threats by using audit features in Microsoft Defender XDR and Microsoft Purview Standard</h3> <ul> <li>Explore Microsoft Purview Audit solutions</li> <li>Implement Microsoft Purview Audit (Standard)</li> <li>Start recording activity in the Unified Audit Log</li> <li>Search the Unified Audit Log (UAL)</li> <li>Export, configure, and view audit log records</li> <li>Use audit log searching to investigate common support issues</li> </ul> <h3>10 - Investigate threats using audit in Microsoft Defender XDR and Microsoft Purview (Premium)</h3> <ul> <li>Explore Microsoft Purview Audit (Premium)</li> <li>Implement Microsoft Purview Audit (Premium)</li> <li>Manage audit log retention policies</li> <li>Investigate compromised email accounts using Purview Audit (Premium)</li> </ul> <h3>11 - Investigate threats with Content search in Microsoft Purview</h3> <ul> <li>Explore Microsoft Purview eDiscovery solutions</li> <li>Create a content search</li> <li>View the search results and statistics</li> <li>Export the search results and search report</li> <li>Configure search permissions filtering</li> <li>Search for and delete email messages</li> </ul> <h3>12 - Protect against threats with Microsoft Defender for Endpoint</h3> <ul> <li>Practice security administration</li> <li>Hunt threats within your network</li> </ul> <h3>13 - Deploy the Microsoft Defender for Endpoint environment</h3> <ul> <li>Create your environment</li> <li>Understand operating systems compatibility and features</li> <li>Onboard devices</li> <li>Manage access</li> <li>Create and manage roles for role-based access control</li> <li>Configure device groups</li> <li>Configure environment advanced features</li> </ul> <h3>14 - Implement Windows security enhancements with Microsoft Defender for Endpoint</h3> <ul> <li>Understand attack surface reduction</li> <li>Enable attack surface reduction rules</li> </ul> <h3>15 - Perform device investigations in Microsoft Defender for Endpoint</h3> <ul> <li>Use the device inventory list</li> <li>Investigate the device</li> <li>Use behavioral blocking</li> <li>Detect devices with device discovery</li> </ul> <h3>16 - Perform actions on a device using Microsoft Defender for Endpoint</h3> <ul> <li>Explain device actions</li> <li>Run Microsoft Defender antivirus scan on devices</li> <li>Collect investigation package from devices</li> <li>Initiate live response session</li> </ul> <h3>17 - Perform evidence and entities investigations using Microsoft Defender for Endpoint</h3> <ul> <li>Investigate a file</li> <li>Investigate a user account</li> <li>Investigate an IP address</li> <li>Investigate a domain</li> </ul> <h3>18 - Configure and manage automation using Microsoft Defender for Endpoint</h3> <ul> <li>Configure advanced features</li> <li>Manage automation upload and folder settings</li> <li>Configure automated investigation and remediation capabilities</li> <li>Block at risk devices</li> </ul> <h3>19 - Configure for alerts and detections in Microsoft Defender for Endpoint</h3> <ul> <li>Configure advanced features</li> <li>Configure alert notifications</li> <li>Manage alert suppression</li> <li>Manage indicators</li> </ul> <h3>20 - Utilize Vulnerability Management in Microsoft Defender for Endpoint</h3> <ul> <li>Understand vulnerability management</li> <li>Explore vulnerabilities on your devices</li> <li>Manage remediation</li> </ul> <h3>21 - Plan for cloud workload protections using Microsoft Defender for Cloud</h3> <ul> <li>Explain Microsoft Defender for Cloud</li> <li>Describe Microsoft Defender for Cloud workload protections</li> <li>Enable Microsoft Defender for Cloud</li> </ul> <h3>22 - Connect Azure assets to Microsoft Defender for Cloud</h3> <ul> <li>Explore and manage your resources with asset inventory</li> <li>Configure auto provisioning</li> <li>Manual log analytics agent provisioning</li> </ul> <h3>23 - Connect non-Azure resources to Microsoft Defender for Cloud</h3> <ul> <li>Protect non-Azure resources</li> <li>Connect non-Azure machines</li> <li>Connect your AWS accounts</li> <li>Connect your GCP accounts</li> </ul> <h3>24 - Manage your cloud security posture management?</h3> <ul> <li>Explore Secure Score</li> <li>Explore Recommendations</li> <li>Measure and enforce regulatory compliance</li> <li>Understand Workbooks</li> </ul> <h3>25 - Explain cloud workload protections in Microsoft Defender for Cloud</h3> <ul> <li>Understand Microsoft Defender for servers</li> <li>Understand Microsoft Defender for App Service</li> <li>Understand Microsoft Defender for Storage</li> <li>Understand Microsoft Defender for SQL</li> <li>Understand Microsoft Defender for open-source databases</li> <li>Understand Microsoft Defender for Key Vault</li> <li>Understand Microsoft Defender for Resource Manager</li> <li>Understand Microsoft Defender for DNS</li> <li>Understand Microsoft Defender for Containers</li> <li>Understand Microsoft Defender additional protections</li> </ul> <h3>26 - Remediate security alerts using Microsoft Defender for Cloud</h3> <ul> <li>Understand security alerts</li> <li>Remediate alerts and automate responses</li> <li>Suppress alerts from Defender for Cloud</li> <li>Generate threat intelligence reports</li> <li>Respond to alerts from Azure resources</li> </ul> <h3>27 - Construct KQL statements for Microsoft Sentinel</h3> <ul> <li>Understand the Kusto Query Language statement structure</li> <li>Use the search operator</li> <li>Use the where operator</li> <li>Use the let statement</li> <li>Use the extend operator</li> <li>Use the order by operator</li> <li>Use the project operators</li> </ul> <h3>28 - Analyze query results using KQL</h3> <ul> <li>Use the summarize operator</li> <li>Use the summarize operator to filter results</li> <li>Use the summarize operator to prepare data</li> <li>Use the render operator to create visualizations</li> </ul> <h3>29 - Build multi-table statements using KQL</h3> <ul> <li>Use the union operator</li> <li>Use the join operator</li> </ul> <h3>30 - Work with data in Microsoft Sentinel using Kusto Query Language</h3> <ul> <li>Extract data from unstructured string fields</li> <li>Extract data from structured string data</li> <li>Integrate external data</li> <li>Create parsers with functions</li> </ul> <h3>31 - Introduction to Microsoft Sentinel</h3> <ul> <li>What is Microsoft Sentinel?</li> <li>How Microsoft Sentinel works</li> <li>When to use Microsoft Sentinel</li> </ul> <h3>32 - Create and manage Microsoft Sentinel workspaces</h3> <ul> <li>Plan for the Microsoft Sentinel workspace</li> <li>Create a Microsoft Sentinel workspace</li> <li>Manage workspaces across tenants using Azure Lighthouse</li> <li>Understand Microsoft Sentinel permissions and roles</li> <li>Manage Microsoft Sentinel settings</li> <li>Configure logs</li> </ul> <h3>33 - Query logs in Microsoft Sentinel</h3> <ul> <li>Query logs in the logs page</li> <li>Understand Microsoft Sentinel tables</li> <li>Understand common tables</li> <li>Understand Microsoft Defender XDR tables</li> </ul> <h3>34 - Use watchlists in Microsoft Sentinel</h3> <ul> <li>Plan for watchlists</li> <li>Create a watchlist</li> <li>Manage watchlists</li> </ul> <h3>35 - Utilize threat intelligence in Microsoft Sentinel</h3> <ul> <li>Define threat intelligence</li> <li>Manage your threat indicators</li> <li>View your threat indicators with KQL</li> </ul> <h3>36 - Connect data to Microsoft Sentinel using data connectors</h3> <ul> <li>Ingest log data with data connectors</li> <li>Understand data connector providers</li> <li>View connected hosts</li> </ul> <h3>37 - Connect Microsoft services to Microsoft Sentinel</h3> <ul> <li>Plan for Microsoft services connectors</li> <li>Connect the Microsoft Office 365 connector</li> <li>Connect the Microsoft Entra connector</li> <li>Connect the Microsoft Entra ID Protection connector</li> <li>Connect the Azure Activity connector</li> </ul> <h3>38 - Connect Microsoft Defender XDR to Microsoft Sentinel</h3> <ul> <li>Plan for Microsoft Defender XDR connectors</li> <li>Connect the Microsoft Defender XDR connector</li> <li>Connect Microsoft Defender for Cloud connector</li> <li>Connect Microsoft Defender for IoT</li> <li>Connect Microsoft Defender legacy connectors</li> </ul> <h3>39 - Connect Windows hosts to Microsoft Sentinel</h3> <ul> <li>Plan for Windows hosts security events connector</li> <li>Connect using the Windows Security Events via AMA Connector</li> <li>Connect using the Security Events via Legacy Agent Connector</li> <li>Collect Sysmon event logs</li> </ul> <h3>40 - Connect Common Event Format logs to Microsoft Sentinel</h3> <ul> <li>Plan for Common Event Format connector</li> <li>Connect your external solution using the Common Event Format connector</li> </ul> <h3>41 - Connect syslog data sources to Microsoft Sentinel</h3> <ul> <li>Plan for syslog data collection</li> <li>Collect data from Linux-based sources using syslog</li> <li>Configure the Data Collection Rule for Syslog Data Sources</li> <li>Parse syslog data with KQL</li> </ul> <h3>42 - Connect threat indicators to Microsoft Sentinel</h3> <ul> <li>Plan for threat intelligence connectors</li> <li>Connect the threat intelligence TAXII connector</li> <li>Connect the threat intelligence platforms connector</li> <li>View your threat indicators with KQL</li> </ul> <h3>43 - Threat detection with Microsoft Sentinel analytics</h3> <ul> <li>What is Microsoft Sentinel Analytics?</li> <li>Types of analytics rules</li> <li>Create an analytics rule from templates</li> <li>Create an analytics rule from wizard</li> <li>Manage analytics rules</li> </ul> <h3>44 - Automation in Microsoft Sentinel</h3> <ul> <li>Understand automation options</li> <li>Create automation rules</li> </ul> <h3>45 - Threat response with Microsoft Sentinel playbooks</h3> <ul> <li>What are Microsoft Sentinel playbooks?</li> <li>Trigger a playbook in real-time</li> <li>Run playbooks on demand</li> </ul> <h3>46 - Security incident management in Microsoft Sentinel</h3> <ul> <li>Understand incidents</li> <li>Incident evidence and entities</li> <li>Incident management</li> </ul> <h3>47 - Identify threats with Behavioral Analytics</h3> <ul> <li>Understand behavioral analytics</li> <li>Explore entities</li> <li>Display entity behavior information</li> <li>Use Anomaly detection analytical rule templates</li> </ul> <h3>48 - Data normalization in Microsoft Sentinel</h3> <ul> <li>Understand data normalization</li> <li>Use ASIM Parsers</li> <li>Understand parameterized KQL functions</li> <li>Create an ASIM Parser</li> <li>Configure Azure Monitor Data Collection Rules</li> </ul> <h3>49 - Query, visualize, and monitor data in Microsoft Sentinel</h3> <ul> <li>Monitor and visualize data</li> <li>Query data using Kusto Query Language</li> <li>Use default Microsoft Sentinel Workbooks</li> <li>Create a new Microsoft Sentinel Workbook</li> </ul> <h3>50 - Manage content in Microsoft Sentinel</h3> <ul> <li>Use solutions from the content hub</li> <li>Use repositories for deployment</li> </ul> <h3>51 - Explain threat hunting concepts in Microsoft Sentinel</h3> <ul> <li>Understand cybersecurity threat hunts</li> <li>Develop a hypothesis</li> <li>Explore MITRE ATT&amp;CK</li> </ul> <h3>52 - Threat hunting with Microsoft Sentinel</h3> <ul> <li>Explore creation and management of threat-hunting queries</li> <li>Save key findings with bookmarks</li> <li>Observe threats over time with livestream</li> </ul> <h3>53 - Use Search jobs in Microsoft Sentinel</h3> <ul> <li>Hunt with a Search Job</li> <li>Restore historical data</li> </ul> <h3>54 - Hunt for threats using notebooks in Microsoft Sentinel</h3> <ul> <li>Access Azure Sentinel data with external tools</li> <li>Hunt with notebooks</li> <li>Create a notebook</li> <li>Explore notebook code</li> </ul></div>

Microsoft AZ-900

Microsoft AZ-104

Microsoft SC-200

Microsoft AZ-303

Microsoft AZ-700

SC-200T00 Microsoft Security Operations Analyst

Most people now use the internet, on a computer or a mobile phone. They use social media to meet and stay in touch with people. Many people with a learning disability have not had any support or advice on how to use the internet and social media. We want to help people to manage their online relationships safely. 
This is course is for people with a learning disability ONLY 

The course will cover 
Making friends on social media
Online dating 
Sharing and receiving images
Grooming / Catfishing
Legal issues online 
Privacy and reporting abuse 

Join our free 2 part course each Thursday: 
04/11/24 & 11/11/24
11am- 1pm 
On Zoom



Supported Loving

Healthy Online Relationships

<div id="course-pills-1">Duration<p>3 Days</p><p>18 CPD hours</p>This course is intended for<p>The primary audience for this course is someone who works, or has ambition to work, in a leadership role in data center operations such as a data center facilities manager, data center operations manager, who has the responsibility to achieve and improve the high-availability and manageability of the data center operations.</p>Overview<p>After completion of the course the participant will be able to:<br />Perform the needs analysis translating business requirements to data center services<br />Set-up and manage the data center operations team<br />Implement and monitor safety- and security practices<br />Identify a suitable maintenance program for the data center facility and its equipment<br />Select the appropriate policies and procedures required for data center operations<br />Monitor the data center availability, capacity and capability<br />Manage and implement basic data center projects<br />Set-up and implement an environmental sustainability program<br />Select an appropriate back-up site to support organizational resilience<br />Identify and respond to risk in the data center<br />Manage and support the document life cycle<br />Create a basic budget proposal<br />Select and manage vendors and measure their performance<br />Manage data center assets</p><p>Managing the facilities of today?s high-end and high-availability data centers is an extremely demanding and complex task which is often underestimated. There is often very little appreciation and understanding of the complexities of managing today's mission-critical data centers where downtime is not an option, especially since many of the data centers are operating at, or near, their design limits. Operations management at the facilities layer makes all the difference. Even a data center designed to the highest redundancy level as per the ANSI/TIA-942 standard could still experience many unscheduled downtime events due to poor planning, operations, maintenance and management processes.</p></div><div id="course-pills-2"><h4>Service Level Management</h4><ul><li>Service Level Management</li><li>Needs analysis</li><li>Capability assessment</li><li>Service portfolio</li><li>Service catalogue</li><li>Service Level Agreements (SLAs)</li><li>Availability measurement</li><li>Data points in SLA</li><li>Service reporting</li><li>Complaint procedure</li><li>Customer satisfaction measurement</li><li>Service Improvement Process (SIP)</li><li>SLA content</li></ul><h4>The Data Center Organization</h4><ul><li>Operational issues</li><li>Organization chart</li><li>Roles and responsibilities</li><li>Skills matrix</li><li>Contingency / backup roles</li><li>Shift management</li><li>Performance management</li><li>Career development</li><li>Training and assessment</li><li>Job rotation</li><li>Succession planning</li><li>Disciplinary program</li></ul><h4>Managing Safety &amp; Statutory Requirements</h4><ul><li>Safety policies and regulations</li><li>Occupational Health and Safety (OH&amp;S)</li><li>Safety awareness training</li><li>Permit to Work (PTW)</li><li>Lock-out / Tag-out</li><li>Personal Protective Equipment (PPE)</li><li>Testing and tagging of equipment</li><li>Emergency preparedness and response</li><li>Reporting of safety issues</li><li>Reviews / internal audit / external audit</li></ul><h4>Managing Physical Security</h4><ul><li>Security policies and procedures</li><li>Security standards and guidelines</li><li>Security staff</li><li>Security awareness</li><li>Security incident management</li><li>Disciplinary program</li><li>Reviews, internal and external audits</li></ul><h4>Facilities Management</h4><ul><li>Maintenance policies and procedures</li><li>Various maintenance programs</li><li>Outsourcing of maintenance activities</li><li>Maintenance contract options</li><li>Warranty</li><li>Maintenance schedule</li><li>Service situations</li><li>Spart part management</li><li>Contamination control</li></ul><h4>Data Center Operations</h4><ul><li>Policies and procedures for data center operations</li><li>Service operations and the daily data center operations</li></ul><h4>Monitoring / Reporting / Control</h4><ul><li>Monitoring requirements</li><li>Escalation procedures</li><li>Reporting</li><li>Trend analysis</li><li>Reviews</li></ul><h4>Project Management</h4><ul><li>Project management</li><li>Project organization</li><li>Project manager</li><li>Project phases</li></ul><h4>Environment Sustainability</h4><ul><li>The importance of sustainability</li><li>Sustainability policies </li><li>Environmental management </li><li>Power efficiency indicators -</li><li>Waste management -</li><li>Water management</li><li>ICT utilisation management </li><li>Environmental performance measurements</li><li>Renewable energy factor (REF)</li></ul><h4>Organizational Resilience</h4><ul><li>Business continuity</li><li>Data center facility options</li><li>Business Impact Analysis</li><li>Type of facility</li><li>Human resources</li><li>Facility, equipment and consumables</li></ul><h4>Governance, Risk and Compliance</h4><ul><li>Management commitment</li><li>Coordination, collaboration and integration</li><li>Compliance</li><li>Risk management</li><li>Document management</li><li>Financial management</li><li>Vendor management</li><li>Asset management</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans Certified Data Center Facilities Operations Manager (CDFOM) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. </p><p></p> This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. <p></p>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.  <p></p>While we feel this is the best course for the Certified Data Center Facilities Operations Manager (CDFOM) 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.  <p></p>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.<p></p></div>

Operations Management

Certified Facility Manager (CFM)

Construction Design & Management (CDM)

Facility Management

Operations Manager

Certified Data Center Facilities Operations Manager (CDFOM)

<p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Are you doing sanction checks in your law firm?</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">In the intricate landscape of legal practice, understanding and adhering to the UK&#39;s sanctions regime is not just a recommendation; it is mandatory and it is imperative. This course aims to set clear expectations and offer practical support to firms, guiding them away from the pitfalls of breaching the UK&#39;s sanctions regime.</p><h2 fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Who is this for?</strong></h2><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This 90 minute course is for all legal firms, irrespective of the services you provide. Whether you are navigating the sanctions regime independently or operating under a license from the Office of Financial Sanctions Implementation (OFSI), this course is for you. &nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">The course will cover:</span></p><ul fr-original-style="" style="box-sizing: border-box;"><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">What are sanctions</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">What do you need to know about the sanctions for your firm</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">How is it different to the AML regime?</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">What controls to put in place?</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">If the firm offers services to sanction areas &ndash; what controls?</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">My client has been sanctioned &ndash; what do I do?</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Reporting obligations</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Using screening tools</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Licensing</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">How does this impact Legal Professional Privilege?</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Sanction Risk Assessment</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Red flags factors</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Enforcement actions</li></ul><h2 data-key="21" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Resources</h2><p data-key="28" style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><span data-key="29" fr-original-style="" style="box-sizing: border-box;"><span data-offset-key="29:0" fr-original-style="" style="box-sizing: border-box;">Comprehensive and up to date course notes will be provided to all delegates which may be useful for ongoing reference or cascade training.</span></span></p><p data-key="30" data-slate-fragment="JTdCJTIyb2JqZWN0JTIyJTNBJTIyZG9jdW1lbnQlMjIlMkMlMjJkYXRhJTIyJTNBJTdCJTdEJTJDJTIybm9kZXMlMjIlM0ElNUIlN0IlMjJvYmplY3QlMjIlM0ElMjJibG9jayUyMiUyQyUyMnR5cGUlMjIlM0ElMjJoZWFkaW5nLXRocmVlJTIyJTJDJTIyZGF0YSUyMiUzQSU3QiUyMmNsYXNzTmFtZSUyMiUzQW51bGwlN0QlMkMlMjJub2RlcyUyMiUzQSU1QiU3QiUyMm9iamVjdCUyMiUzQSUyMnRleHQlMjIlMkMlMjJsZWF2ZXMlMjIlM0ElNUIlN0IlMjJvYmplY3QlMjIlM0ElMjJsZWFmJTIyJTJDJTIydGV4dCUyMiUzQSUyMkNvdXJzZSUyME5vdGVzJTIyJTJDJTIybWFya3MlMjIlM0ElNUIlNUQlN0QlNUQlN0QlNUQlN0QlMkMlN0IlMjJvYmplY3QlMjIlM0ElMjJibG9jayUyMiUyQyUyMnR5cGUlMjIlM0ElMjJwYXJhZ3JhcGglMjIlMkMlMjJkYXRhJTIyJTNBJTdCJTIyY2xhc3NOYW1lJTIyJTNBbnVsbCU3RCUyQyUyMm5vZGVzJTIyJTNBJTVCJTdCJTIyb2JqZWN0JTIyJTNBJTIydGV4dCUyMiUyQyUyMmxlYXZlcyUyMiUzQSU1QiU3QiUyMm9iamVjdCUyMiUzQSUyMmxlYWYlMjIlMkMlMjJ0ZXh0JTIyJTNBJTIyQ29tcHJlaGVuc2l2ZSUyMGFuZCUyMHVwJTIwdG8lMjBkYXRlJTIwY291cnNlJTIwbm90ZXMlMjB3aWxsJTIwYmUlMjBwcm92aWRlZCUyMHRvJTIwYWxsJTIwZGVsZWdhdGVzJTIwd2hpY2glMjBtYXklMjBiZSUyMHVzZWZ1bCUyMGZvciUyMG9uZ29pbmclMjByZWZlcmVuY2UlMjBvciUyMGNhc2NhZGUlMjB0cmFpbmluZy4lMjIlMkMlMjJtYXJrcyUyMiUzQSU1QiU1RCU3RCU1RCU3RCU1RCU3RCUyQyU3QiUyMm9iamVjdCUyMiUzQSUyMmJsb2NrJTIyJTJDJTIydHlwZSUyMiUzQSUyMnBhcmFncmFwaCUyMiUyQyUyMmRhdGElMjIlM0ElN0IlMjJjbGFzc05hbWUlMjIlM0FudWxsJTdEJTJDJTIybm9kZXMlMjIlM0ElNUIlN0IlMjJvYmplY3QlMjIlM0ElMjJ0ZXh0JTIyJTJDJTIybGVhdmVzJTIyJTNBJTVCJTdCJTIyb2JqZWN0JTIyJTNBJTIybGVhZiUyMiUyQyUyMnRleHQlMjIlM0ElMjJQbGVhc2UlMjBub3RlJTIwYSUyMHJlY29yZGluZyUyMG9mJTIwdGhlJTIwY291cnNlJTIwd2lsbCUyMCUyMiUyQyUyMm1hcmtzJTIyJTNBJTVCJTVEJTdEJTJDJTdCJTIyb2JqZWN0JTIyJTNBJTIybGVhZiUyMiUyQyUyMnRleHQlMjIlM0ElMjJub3QlMjAlMjIlMkMlMjJtYXJrcyUyMiUzQSU1QiU3QiUyMm9iamVjdCUyMiUzQSUyMm1hcmslMjIlMkMlMjJ0eXBlJTIyJTNBJTIyYm9sZCUyMiUyQyUyMmRhdGElMjIlM0ElN0IlN0QlN0QlNUQlN0QlMkMlN0IlMjJvYmplY3QlMjIlM0ElMjJsZWFmJTIyJTJDJTIydGV4dCUyMiUzQSUyMmJlJTIwbWFkZSUyMGF2YWlsYWJsZS4lMjIlMkMlMjJtYXJrcyUyMiUzQSU1QiU1RCU3RCU1RCU3RCU1RCU3RCU1RCU3RA==" style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><span data-key="31" fr-original-style="" style="box-sizing: border-box;"><span data-offset-key="31:0" fr-original-style="" style="box-sizing: border-box;">Please note a recording of the course will&nbsp;</span><span data-offset-key="31:1" fr-original-style="" style="box-sizing: border-box;"><strong data-slate-leaf="true" fr-original-style="" style="font-weight: 700; box-sizing: border-box;">not&nbsp;</strong></span><span data-offset-key="31:2" fr-original-style="" style="box-sizing: border-box;">be made available.</span></span></p><h2 data-key="35" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><span data-key="36" fr-original-style="" style="box-sizing: border-box;"><span data-offset-key="36:0" fr-original-style="" style="box-sizing: border-box;">Speaker</span></span></h2><h3 style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);"><a href="https://dglegal.co.uk/the-team/helen-torresi/" target="_blank" rel="noopener noreferrer" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="color: rgb(0, 180, 205); box-sizing: border-box;" fr-original-style="color: rgb(0, 180, 205);">Helen Torresi, Consultant, DG Legal</span></strong></a></h3><p style="color: rgb(89, 89, 91); font-size: var(--font-size); box-sizing: border-box;" fr-original-style="color: rgb(89, 89, 91);"><span style="color: rgb(89, 89, 91); box-sizing: border-box;" fr-original-style="color: rgb(89, 89, 91);">Helen is a qualified solicitor with a diverse professional background spanning leadership roles in both the legal and tech/corporate sectors. Throughout her career, she has held key positions such as COLP, HOLP, MLCO, MLRO and DPO for law firms and various regulated businesses and services.</span></p><p style="color: rgb(89, 89, 91); font-size: var(--font-size); box-sizing: border-box;" fr-original-style="color: rgb(89, 89, 91);"><span style="color: rgb(89, 89, 91); box-sizing: border-box;" fr-original-style="color: rgb(89, 89, 91);">Helen&rsquo;s specialised areas encompass AML, complaint and firm negligence handling, DPA compliance, file review and auditing, law management, and operational effectiveness in law firms, particularly in conveyancing (CQS).</span></p>

Are you doing sanction checks in your law firm?
In the intricate landscape of legal practice, understanding and adhering to the UK's sanctions regime is not just a recommendation; it is mandatory and it is imperative. This course aims to set clear expectations and offer practical support to firms, guiding them away from the pitfalls of breaching the UK's sanctions regime.
Who is this for?
This 90 minute course is for all legal firms, irrespective of the services you provide. Whether you are navigating the sanctions regime independently or operating under a license from the Office of Financial Sanctions Implementation (OFSI), this course is for you. 
The course will cover:
What are sanctions
What do you need to know about the sanctions for your firm
How is it different to the AML regime?
What controls to put in place?
If the firm offers services to sanction areas – what controls?
My client has been sanctioned – what do I do?
Reporting obligations
Using screening tools
Licensing
How does this impact Legal Professional Privilege?
Sanction Risk Assessment
Red flags factors
Enforcement actions
Resources
Comprehensive and up to date course notes will be provided to all delegates which may be useful for ongoing reference or cascade training.
Please note a recording of the course will not be made available.
Speaker
Helen Torresi, Consultant, DG Legal
Helen is a qualified solicitor with a diverse professional background spanning leadership roles in both the legal and tech/corporate sectors. Throughout her career, she has held key positions such as COLP, HOLP, MLCO, MLRO and DPO for law firms and various regulated businesses and services.
Helen’s specialised areas encompass AML, complaint and firm negligence handling, DPA compliance, file review and auditing, law management, and operational effectiveness in law firms, particularly in conveyancing (CQS).

DG Legal

Navigating The UK Sanctions Compliance As A Law Firm Course

General Delegate

A discount is available for delegates attending from firms with a current retainer contract with DG Legal (please contact us by email to admin@dglegal.co.uk for confirmation of eligibility).   If you choose this option and are not eligible, you are still bound to pay the full rate and will be invoiced accordingly.

Retainer Delegate

<div id="course-pills-1">Duration<p>3 Days</p><p>18 CPD hours</p>This course is intended for<p>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.</p>Overview<p>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.</p><p>This course is about writing TSQL queries for the purpose of database reporting, analysis, and business intelligence.</p></div><div id="course-pills-2"><h3>1 - INTRODUCTION TO TSQL FOR BUSINESS INTELLIGENCE</h3> <ul> <li>Two Approaches to SQL Programming</li> <li>TSQL Data Retrieval in an Analytics / Business Intelligence Environment</li> <li>The Database Engine</li> <li>SQL Server Management Studio and the CarDeal Sample Database</li> <li>Identifying Variables in Tables</li> <li>SQL is a Declarative Language</li> <li>Introduction to the SELECT Query</li> <li>Lab 1: Introduction to TSQL for Business Intelligence</li> </ul> <h3>2 - TURNING TABLE COLUMNS INTO VARIABLES FOR ANALYSIS: SELECT LIST EXPRESSIONS, WHERE, AND ORDER BY</h3> <ul> <li>Turning Columns into Variables for Analysis</li> <li>Column Expressions, Data Types, and Built-in Functions</li> <li>Column aliases</li> <li>Data type conversions</li> <li>Built-in Scalar Functions</li> <li>Table Aliases</li> <li>The WHERE clause</li> <li>ORDER BY</li> <li>Lab 1: Write queries</li> </ul> <h3>3 - COMBINING COLUMNS FROM MULTIPLE TABLES INTO A SINGLE DATASET: THE JOIN OPERATORS</h3> <ul> <li>Primary Keys, Foreign Keys, and Joins</li> <li>Understanding Joins, Part 1: CROSS JOIN and the Full Cartesian Product</li> <li>Understanding Joins, Part 2: The INNER JOIN</li> <li>Understanding Joins, Part 3: The OUTER JOINS</li> <li>Understanding Joins, Part 4: Joining more than two tables</li> <li>Understanding Joins, Part 5: Combining INNER and OUTER JOINs</li> <li>Combining JOIN Operations with WHERE and ORDER BY</li> <li>Lab 1: Write SELECT queries</li> </ul> <h3>4 - CREATING AN APPROPRIATE AGGREGATION LEVEL USING GROUP BY</h3> <ul> <li>Identifying required aggregation level and granularity</li> <li>Aggregate Functions</li> <li>GROUP BY</li> <li>HAVING</li> <li>Order of operations in SELECT queries</li> <li>Lab 1: Write queries</li> </ul> <h3>5 - SUBQUERIES, DERIVED TABLES AND COMMON TABLE EXPRESSIONS</h3> <ul> <li>Non-correlated and correlated subqueries</li> <li>Derived tables</li> <li>Common table expressions</li> <li>Lab 1: Write queries</li> </ul> <h3>6 - ENCAPSULATING DATA RETRIEVAL LOGIC</h3> <ul> <li>Views</li> <li>Table-valued functions</li> <li>Stored procedures</li> <li>Creating objects for read-access users</li> <li>Creating database accounts for analytical client tools</li> <li>Lab 1: Encapsulating Data Retrieval Logic</li> </ul> <h3>7 - GETTING YOUR DATASET TO THE CLIENT</h3> <ul> <li>Connecting to SQL Server and Submitting Queries from Client Tools</li> <li>Connecting and running SELECT queries from:</li> <li>Excel</li> <li>PowerBI</li> <li>RStudio</li> <li>Exporting datasets to files using</li> <li>Results pane from SSMS</li> <li>The bcp utility</li> <li>The Import/Export Wizard</li> <li>Lab 1: Getting Your Dataset to the Client</li> </ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>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. </p><p></p> This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. <p></p>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.  <p></p>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.  <p></p>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.<p></p></div>

Business Analytics & Intelligence

Oracle Business Intelligence

Microsoft BI

Business Intelligence (BI)

Analytical Skills

55232 Writing Analytical Queries for Business Intelligence

<p style="color: rgb(var(--color_25)); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(var(--color_25));">This official BRCGS course enables participants with an in-depth understanding of the Standard in terms of the protocol, requirements and how to audit effectively. Participants will gain competency to assess compliance to the requirements of the Standard, including fundamental clauses, statements of intent, how to undertake a BRCGS audit, planning of the audit and reporting of the audit. Auditing fundamentals and techniques will be discussed including the auditor competency skills required of auditors auditing against Global Food Safety Initiative (GFSI) recognised certification programmes.</p><p style="color: rgb(var(--color_25)); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(var(--color_25));">Active learning will be used throughout the course utilising case study-based activities to encourage critical thinking and help explain how auditors with audit against the Standard. &nbsp;Participants must have a working knowledge of quality management systems and auditing within the relevant manufacturing sector, and have completed a hazard analysis and critical control points (HACCP) course of at least two days&#39; duration.</p><p style="color: rgb(var(--color_25)); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(var(--color_25));">In preparation for the course, participants must read and review a copy of the Standard including the glossary, which is available as a free download from the <a href="https://www.brcgs.com/store/" target="_blank" rel="noreferrer noopener" style="color: inherit; -webkit-user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: inherit;">BRCGS Store</a>, in addition to the pre-course materials provided.&nbsp;</p><p style="color: rgb(var(--color_25)); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(var(--color_25));">At the end of the course you will be assessed with an exam. Successful completion of this course, including the exam, forms part of the training necessary to become a BRCGS auditor. The steps necessary to complete your training must be arranged with a BRCGS-approved certification body.</p><p style="color: rgb(77, 77, 79); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(77, 77, 79);"><span style="color: rgb(77, 77, 79); box-sizing: border-box;" fr-original-style=" color: rgb(77, 77, 79);">This course is part of the</span><a href="http://demo-brcgs.wearesigma.com/training/brcgs-professional/about-the-programme/" style="color: rgb(234, 118, 0); -webkit-user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: rgb(234, 118, 0);">&nbsp;BRCGS Professional recognition programme</a><span style="color: rgb(77, 77, 79); box-sizing: border-box;" fr-original-style=" color: rgb(77, 77, 79);">.</span></p><p style="color: rgb(var(--color_25)); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(var(--color_25));">At the end of the course participants will be able to:&nbsp;</p><ul style="color: rgb(var(--color_25)); box-sizing: border-box;" fr-original-style=" color: rgb(var(--color_25));"><li fr-original-style="" style="box-sizing: border-box;"><p style="color: rgb(var(--color_25)); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(var(--color_25));">Explain the steps to managing an audit programme</p></li><li fr-original-style="" style="box-sizing: border-box;"><p style="color: rgb(var(--color_25)); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(var(--color_25));">Describe auditing fundamentals and techniques</p></li><li fr-original-style="" style="box-sizing: border-box;"><p style="color: rgb(var(--color_25)); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(var(--color_25));">Assess compliance to the requirements of the Standard and explain how compliance can be demonstrated to maintain food safety, quality, legality, and authenticity</p></li><li fr-original-style="" style="box-sizing: border-box;"><p style="color: rgb(var(--color_25)); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(var(--color_25));">Describe the scope of companies and products covered by the Standard</p></li><li fr-original-style="" style="box-sizing: border-box;"><p style="color: rgb(var(--color_25)); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(var(--color_25));">Describe steps to conduct a BRCGS audit including the preparation, planning, and reporting of the audit</p></li><li fr-original-style="" style="box-sizing: border-box;"><p style="color: rgb(var(--color_25)); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(var(--color_25));">Utilise and explain resource tools available for compliance and beneficial support from BRCGS</p></li></ul>

This official BRCGS course enables participants with an in-depth understanding of the Standard in terms of the protocol, requirements and how to audit effectively. Participants will gain competency to assess compliance to the requirements of the Standard, including fundamental clauses, statements of intent, how to undertake a BRCGS audit, planning of the audit and reporting of the audit. Auditing fundamentals and techniques will be discussed including the auditor competency skills required of auditors auditing against Global Food Safety Initiative (GFSI) recognised certification programmes.
Active learning will be used throughout the course utilising case study-based activities to encourage critical thinking and help explain how auditors with audit against the Standard. Participants must have a working knowledge of quality management systems and auditing within the relevant manufacturing sector, and have completed a hazard analysis and critical control points (HACCP) course of at least two days' duration.
In preparation for the course, participants must read and review a copy of the Standard including the glossary, which is available as a free download from the BRCGS Store, in addition to the pre-course materials provided. 
At the end of the course you will be assessed with an exam. Successful completion of this course, including the exam, forms part of the training necessary to become a BRCGS auditor. The steps necessary to complete your training must be arranged with a BRCGS-approved certification body.
This course is part of theBRCGS Professional recognition programme.
At the end of the course participants will be able to: 
Explain the steps to managing an audit programme
Describe auditing fundamentals and techniques
Assess compliance to the requirements of the Standard and explain how compliance can be demonstrated to maintain food safety, quality, legality, and authenticity
Describe the scope of companies and products covered by the Standard
Describe steps to conduct a BRCGS audit including the preparation, planning, and reporting of the audit
Utilise and explain resource tools available for compliance and beneficial support from BRCGS

Ask Sonia Limited

Food Safety

HACCP

Official BRCGS Food Safety Issue 9 Lead Auditor training course. 
Delivered online (Zoom) by a live BRCGS Approved Training Partner & Virtual Trainer.
Exam and Certificate fee included in the price.

BRCGS Food Safety Issue 9 - Lead Auditor (5 Days)

<p style="color: rgb(var(--color_25)); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(var(--color_25));">This official BRCGS course enables participants to develop a full understanding of the general principles of the requirements of the Standard and gain competency to assess compliance to the requirements of the Standard, including fundamental clauses, statements of intent, how to undertake a BRCGS audit, planning of the audit and reporting of the audit.</p><p style="color: rgb(var(--color_25)); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(var(--color_25));">Active learning will be used throughout the course utilising case study-based activities to encourage critical thinking and help explain how auditors will audit against the Standard. &nbsp;Participants must have a working knowledge of quality management systems and auditing within the relevant manufacturing sector, and have completed a hazard analysis and critical control points (HACCP) course of at least two days&#39; duration.</p><p style="color: rgb(var(--color_25)); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(var(--color_25));">In preparation for the course, participants must read and review a copy of the Standard including the glossary, which is available as a free download from the BRCGS Store, in addition to the pre-course materials provided.</p><p style="color: rgb(var(--color_25)); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(var(--color_25));">At the end of the course, participants will be assessed with an exam. For candidates who are already qualified as a Lead Auditor on another scheme (eg IRCA, SQF, IFS, etc) successful completion of this course, including the exam, is recognised as part of the training necessary to become a BRCGS auditor. The steps necessary to complete your training must be arranged with a BRCGS-approved certification body.</p><p style="color: rgb(77, 77, 79); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(77, 77, 79);"><span style="color: rgb(77, 77, 79); box-sizing: border-box;" fr-original-style=" color: rgb(77, 77, 79);">This course is part of the</span><a href="http://demo-brcgs.wearesigma.com/training/brcgs-professional/about-the-programme/" style="color: rgb(234, 118, 0); -webkit-user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: rgb(234, 118, 0);">&nbsp;BRCGS Professional recognition programme</a><span style="color: rgb(77, 77, 79); box-sizing: border-box;" fr-original-style=" color: rgb(77, 77, 79);">.</span></p><p style="color: rgb(var(--color_25)); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(var(--color_25));">At the end of the course participants will be able to:&nbsp;</p><ul style="color: rgb(var(--color_25)); box-sizing: border-box;" fr-original-style=" color: rgb(var(--color_25));"><li fr-original-style="" style="box-sizing: border-box;"><p style="color: rgb(var(--color_25)); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(var(--color_25));">Assess compliance to the requirements of the Standard and explain how compliance can be demonstrated to maintain food safety, quality, legality, and authenticity</p></li><li fr-original-style="" style="box-sizing: border-box;"><p style="color: rgb(var(--color_25)); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(var(--color_25));">Describe the scope of companies and products covered by the Standard</p></li><li fr-original-style="" style="box-sizing: border-box;"><p style="color: rgb(var(--color_25)); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(var(--color_25));">Describe steps to conduct a BRCGS audit including the preparation, planning, and reporting of the audit</p></li><li fr-original-style="" style="box-sizing: border-box;"><p style="color: rgb(var(--color_25)); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(var(--color_25));">Utilise and explain resource tools available for compliance and beneficial support from BRCGS</p></li></ul>

This official BRCGS course enables participants to develop a full understanding of the general principles of the requirements of the Standard and gain competency to assess compliance to the requirements of the Standard, including fundamental clauses, statements of intent, how to undertake a BRCGS audit, planning of the audit and reporting of the audit.
Active learning will be used throughout the course utilising case study-based activities to encourage critical thinking and help explain how auditors will audit against the Standard. Participants must have a working knowledge of quality management systems and auditing within the relevant manufacturing sector, and have completed a hazard analysis and critical control points (HACCP) course of at least two days' duration.
In preparation for the course, participants must read and review a copy of the Standard including the glossary, which is available as a free download from the BRCGS Store, in addition to the pre-course materials provided.
At the end of the course, participants will be assessed with an exam. For candidates who are already qualified as a Lead Auditor on another scheme (eg IRCA, SQF, IFS, etc) successful completion of this course, including the exam, is recognised as part of the training necessary to become a BRCGS auditor. The steps necessary to complete your training must be arranged with a BRCGS-approved certification body.
This course is part of theBRCGS Professional recognition programme.
At the end of the course participants will be able to: 
Assess compliance to the requirements of the Standard and explain how compliance can be demonstrated to maintain food safety, quality, legality, and authenticity
Describe the scope of companies and products covered by the Standard
Describe steps to conduct a BRCGS audit including the preparation, planning, and reporting of the audit
Utilise and explain resource tools available for compliance and beneficial support from BRCGS

Auditor

Official BRCGS Food Safety Issue 9 course. 
Delivered online (Zoom) by a live BRCGS Approved Training Partner.
Exam and Certificate fee included in the price.

134 Courses in Coventry

Accident Investigation

By Inovra Group

Management of Value (MoV) Foundation: In-House Training

By IIL Europe Ltd

Designated Safeguarding Lead Online Course

By Child Protection Training Uk

Well Integrity (Basic and Advanced)

By EnergyEdge - Training for a Sustainable Energy Future

EPCIC Contract Drafting and Management: With Essential Elements of International Contract Laws

By EnergyEdge - Training for a Sustainable Energy Future

ANNUAL CHILD PROTECTION AWARENESS

By Child Protection Training Uk

Microsoft Project Introduction - In-company

By Microsoft Office Training

Clinical Safe Holding

By Guardian Angels Training

Power BI® - Business Data Analytics

By EnergyEdge - Training for a Sustainable Energy Future

Level 3 Endorsed Award in Delivering Health and Social Care Training (Healthcare Train the Trainer)

By Guardian Angels Training

Search By Location