457 Courses delivered Live Online

Duration 2 Days 12 CPD hours This course is intended for The course is designed for individuals who want to gain in-depth knowledge and practice in the discipline of Business Analysis (Business Analysts, Requirements Engineers, Product manager, Product Owner, Chief Product Owner, Service Manager, Service Owner, Project manager, Consultants) Overview Students should be able to demonstrate knowledge and understanding and application of Business Analysis principles and techniques. Key areas are: The breath of the role of a Business Analyst The processes and techniques of strategy analysis Investigation of an organization's business systems Techniques used within stakeholder analysis and the need for analyzing perspectives Conceptual modelling and business activity models Business improvements through gap analysis The Business case within the business change lifecycle The Business Analyst role analyzes, understands and manages the requirements in a customer-supplier relationship and ensures that the right products are delivered.The course provides in-depth knowledge and practice in Business Analysis Course Introduction Let?s Get to Know Each Other Course Overview Course Learning Objectives Course Structure Course Agenda Introduction to Business Analysis Practice Exam Details Business Analysis Certification Scheme Rationale for Business Analysis The role of the BA throughout the stages of the Business change lifecycle The scope of the BA role within the context of the range of analysis activities Three areas of competencies Understanding the Strategic Context Techniques in practice: MOST Resource audit PESTLE Porter's Five Forces SWOT analysis CSF, KPI and Performance target Balanced Business Score Card Understanding the Current Situation Identification of stakeholder categories Identification of relevant investigation techniques The rationale for taking a holistic view Rich pictures, Mind Maps and Fishbone diagrams Stakeholder Analysis and Management Power/interest and level of interest Appropriate stakeholder management strategy Stakeholder perspectives and CATWOE technique Analysing and Modelling Business Activities Conceptual models of a business situation Five types of high level activity Planning activities Enabling activities Doing activities Monitoring and control activities Three types of business events The consensus business activity model Identifying Potential Solutions Different categories of business rules Gap analysis (through conceptual business activity model and as-is business situation) Components of a new business model Building the Business Case Rationale for the development of a business case Contents of a business case Identification of tangible/intangible costs and benefits, risks and impacts Rationale for the financial case and appraisal techniques Business case review in the business change lifecycle Additional course details: Nexus Humans Business Analysis - Practice training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Business Analysis - Practice course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Duration 2 Days 12 CPD hours This course is intended for There is no specific prerequisite for the CDRP© course. However, participants who have at least three years' experience in a data centre and/or IT infrastructures will be best suited. Overview After completion of the course, the participant will be able to: 1. Understand the different standards and methodologies for risk management and assessment 2. Establish the required project team for risk management 3. Perform the risk assessment, identifying current threats, vulnerabilities and the potential impact based on customised threat catalogues 4. Report on the current risk level of the data centre both quantitative and qualitative 5. Anticipate and minimise potential financial impacts 6. Understand the options for handling risk 7. Continuously monitor and review the status of risk present in the data centre 8. Reduce the frequency and magnitude of incidents 9. Detect and respond to events when they occur 10. Meet regulatory and compliance requirements 11. Support certification processes such as ISO/IEC 27001 12. Support overall corporate and IT governance Introduction to Risk Management Risk management concepts Senior management and risk Enterprise Risk Management (ERM) Benefits of risk management Data Centre Risk and Impact Risk in facility, power, cooling, fire suppression, infrastructure and IT services Impact of data centre downtime Main causes of downtime Cost factors in downtime Standards, Guidelines and Methodologies ISO/IEC 27001:2013, ISO/IEC 27005:2011, ISO/IEC 27002:2013 NIST SP 800-30 ISO/IEC 31000:2009 SS507:2008 ANSI/TIA-942 Other methodologies (CRAMM, EBIOS, OCTAVE, etc.) Risk Management Definitions Asset Availability/Confidentiality/Integrity Control Information processing facility Information security Policy Risk Risk analysis/Risk assessment/Risk evaluation/ Risk treatment Threat/Vulnerability Types of risk Risk Assessment Software The need for software Automation Considerations Risk Management Process The risk management process Establishing the context Identification Analysis Evaluation Treatment Communication and consultation Monitoring and review Project Approach Project management principles Project management methods Scope Time Cost Cost estimate methods Context Establishment General considerations Risk evaluation, impact and acceptance criteria Severity rating of impact Occurrence rating of probability Scope and boundaries Scope constraints Roles & responsibilities Training, awareness and competence Risk Assessment - Identification The risk assessment process Identification of assets Identification of threats Identification of existing controls Identification of vulnerabilities Identification of consequences Hands-on exercise: Identification of assets, threats, existing controls, vulnerabilities and consequences Risk Assessment - Analysis and Evaluation Risk estimation Risk estimation methodologies Assessment of consequences Assessment of incident likelihood Level of risk estimation Risk evaluation Hands-on exercise: Assessment of consequences, probability and estimating level of risk Risk Treatment The risk treatment process steps Risk Treatment Plan (RTP) Risk modification Risk retention Risk avoidance Risk sharing Constraints in risk modification Control categories Control examples Cost-benefit analysis Control implementation Residual risk Communication Effective communication of risk management activities Benefits and concerns of communication Risk Monitoring and Review Ongoing monitoring and review Criteria for review Risk scenarios Risk assessment approach Data centre site selection Data centre facility Cloud computing UPS scenarios Force majeure Organisational shortcomings Human failure Technical failure Deliberate acts Exam: Certified Data Centre Risk Professional Actual course outline may vary depending on offering center. Contact your sales representative for more information.

Excel: Top 50 Microsoft Excel Formulas in 50 Minutes! Course Overview "Excel: Top 50 Microsoft Excel Formulas in 50 Minutes!" is designed for learners who want to enhance their Excel skills in a short period. This course covers the essential formulas that are frequently used in both everyday tasks and professional settings. It provides quick, easy-to-follow insights on the most common Excel functions, enabling you to work more efficiently with data, improve productivity, and gain confidence in using Excel’s powerful features. By the end of this course, you will have a comprehensive understanding of 50 key Excel formulas and be able to apply them confidently across various tasks and scenarios. Course Description In this course, learners will be introduced to 50 of the most widely used Microsoft Excel formulas, including basic functions like SUM and AVERAGE, as well as more advanced formulas such as VLOOKUP, IF statements, and pivot table formulas. Each formula is explained with clear examples, offering learners a straightforward approach to improving their Excel proficiency. Whether you are managing data, performing financial analysis, or generating reports, these formulas will significantly enhance your ability to complete tasks faster and more effectively. With a focus on learning key formulas, this course provides an excellent foundation for anyone looking to optimise their Excel skills in a time-efficient way. Excel: Top 50 Microsoft Excel Formulas in 50 Minutes! Curriculum Module 01: Introduction to Excel Formulas Module 02: Basic Mathematical Formulas Module 03: Logical Functions and Conditions Module 04: Lookup and Reference Functions Module 05: Text and Date Functions Module 06: Statistical Functions and Analysis Module 07: Advanced Excel Formulas Module 08: Using Formulas for Data Validation and Error Checking Module 09: Formulas for Financial Modelling Module 10: Troubleshooting and Optimising Formulas (See full curriculum) Who is this course for? Individuals seeking to enhance their Excel capabilities. Professionals aiming to improve data management and analysis skills. Beginners with an interest in improving their productivity with Excel. Anyone wanting to quickly learn the key Excel formulas used in daily tasks. Career Path Data Analyst Financial Analyst Project Manager Business Analyst Office Administrator Operations Manager IT Support Specialist

There is a lot to learn in Power BI, this course takes a comprehensive look at the fundamentals of analysing data and includes a balanced look at the four main components that make up Power BI Desktop: Report view, Data view, Model view, and the Power Query Editor. It also demonstrates how to utilise the online Power BI service. It looks at authoring tools that enable you to connect to and transform data from a variety of sources, allowing you to produce detailed reports through a range of visualisations, in an interactive and dynamic way. It also includes a detailed look at formulas by writing both M functions in Power Query, and DAX functions in Desktop view. This knowledge will allow you to take your reports to the next level. The aim of this course is to provide a complete introduction to understanding the Power BI analysis process, by working hands-on with examples that will equip you with the necessary skills to start applying your learning straight away. 1 Getting Started The Power BI ecosystem Opening Power BI Desktop Power BI's four views Introduction to Dashboards 2 Importing Files Importing data sources Importing an Excel file Importing a CSV file Importing a database Connect to an SQL Server Database Import vs. Direct Query Importing from the web Importing a folder of files Managing file connections 3 Shape Data in the Query Editor The process of shaping data Managing data types Keeping and removing rows Add a custom column Appending tables together Hiding queries in reports Fixing error issues Basic maths operations 4 The Data Model Table relationships Relationship properties 5 Merge Queries Table join kinds Merging tables 6 Inserting Dashboard Visuals Things to keep in mind Inserting maps Formatting Maps Inserting charts Formatting Charts Inserting a tree map Inserting a table, matrix, and card Controlling number formats About report themes Highlighting key points Filter reports with slicers Sync slicers across dashboards Custom web visuals 7 Publish and share Reports Publishing to Power BI service Editing online reports Pinning visuals to a dashboard What is Q&A? Sharing dashboards Exporting reports to PowerPoint Exporting reports as PDF files 8 The Power Query Editor Fill data up and down Split column by delimiter Add a conditional column More custom columns Merging columns 9 The M Functions Inserting text functions Insert an IF function Create a query group 10 Pivoting Tables Pivot a table Pivot and append tables Pivot but don't aggregate Unpivot tables Append mismatched headers 11 Data Modelling Expanded Understanding relationships Mark a date table 12 DAX New Columns New columns and measures New column calculations Insert a SWITCH function 13 Introduction to DAX Measures Common measure functions Insert a SUM function Insert a COUNTROWS function Insert a DISTINCTCOUNT function Insert a DIVIDE function DAX rules 14 The CALCULATE Measure The syntax of CALCULATE Insert a CALCULATE function Control field summarisation Things of note 15 The SUMX measure X iterator functions Anatomy of SUMX Insert a SUMX function When to use X functions 16 Time Intelligence Measures Importance of a calendar table Insert a TOTALYTD function Change financial year end date Comparing historical data Insert a DATEADD function 17 Hierarchies and Groups Mine data using hierarchies Compare data in groups

Duration 2 Days 12 CPD hours This course is intended for This is an intermediate and beyond level SQL course geared for experienced end users, data scientists, business analysts, application developers and database administrators. Students should have recently attended a basic SQL class or have equivalent experience. Overview This course is approximately 50% hands-on, combining expert lecture, real-world demonstrations and group discussions with machine-based practical labs and exercises. Our engaging instructors and mentors are highly experienced practitioners who bring years of current 'on-the-job' experience into every classroom. Working in a hands-on learning environment led by our expert practitioner, attendees will learn advanced skills needed to: Advanced Query Techniques Manipulating Table Data Using SQL's Data Manipulation Language (DML) User-Defined Functions Stored Procedures Triggers A company?s success hinges on responsible, accurate database management. Organizations rely on highly available data to complete all sorts of tasks, from creating marketing reports and invoicing customers to setting financial goals. Data professionals like analysts, developers and architects are tasked with creating, optimizing, managing and analyzing data from databases ? with little room for error. When databases aren?t built or maintained correctly, it?s easy to mishandle or lose valuable data. Our SQL Programming and Database Training Series provides students with the skills they require to develop, analyze and maintain data and in correctly structured, modern and secure databases. Next Level SQL explores how to identify and use advanced querying techniques to manipulate and index tables. All hands-on work in this course is ANSI SQL compliant and should work with most SQL databases such as Oracle, SQL Server, MySQL, MS Access, Informix, Sybase, or any other ANSI SQL compliant database. Advanced Query Techniques Join inner outer (Left, Right, Full) Subqueries Simple Correlated Using the Exists Operator Tips for Developing Complex Queries Performing Set Operations Aggregating Results Using Group by Creating Temporary Tables Manipulating Table Data Using SQL's Data Manipulation Language (DML) Inserting Data into Tables Updating Existing Data Deleting Records Truncating Tables Implementing Data Integrity with Transactions Beginning Explicit Transactions Committing Transactions Rolling Back Transactions User-Defined Functions Definition and Benefits of Use CREATE FUNCTION Syntax RETURN Clause and the RETURNS Statement Scalar vs. Table Functions Comparison with Stored Procedures Returning Scalar Values and Tables ALTER and DROP FUNCTION Stored Procedures Definition and Benefits of Use CREATE PROCEDURE Syntax Variables and Parameters Control of Program Flow ALTER and DROP PROCEDURE Implementation Differences Triggers Definition and Benefits of Use Alternatives (e.g., Constraints) CREATE TRIGGER Syntax Trigger Types 'Inserted' (or 'NEW') and 'Deleted' (or 'OLD') Tables Event Handling and Trigger Execution ALTER and DROP TRIGGER Additional course details: Nexus Humans Advanced SQL Programming (TTSQL005) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Advanced SQL Programming (TTSQL005) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

This 3 Days programme will equip you to use, price, manage and evaluate interest rate and cross-currency derivatives. The course starts with the building blocks of money markets and futures, through yield curve building to interest-rate and cross-currency swaps, and applications. The approach is hands-on and learning is enhanced through many practical exercises covering hedging, valuation, and risk management. This course also includes sections on XVA, documentation and settlement. The programme includes extensive practical exercises using Excel spreadsheets for valuation and risk-management, which participants can take away for immediate implementation.

Virtual course for parents of adult children at risk/pre manifest. We are pleased to invite you to our virtual course for parents of adult children at risk/pre manifest. This is an opportunity to improve your knowledge of the issues surrounding your adult child at risk, share your experiences and gain ideas of support available for yourself and your adult child. This is a 5 week course running from Thursday 22 February 2024 10am -11.30am until Thursday 21 March, with the final session being an extended session narrative therapy session facilitated by Riverbank Psychology. There will be the opportunity to join a follow up support group. Week 1 – Thursday 22 February 2024 10am Welcome and overview of support available from the Huntington Disease Association. Speaker: James O’Connor – Team Leader HDYES – Huntington’s Disease Association Week 2 – Thursday 29 February 2024 10am Genetics: How to access testing, the process and family planning options Speaker: Chris Platt – SHDA – Huntington’s Disease Association Week 3 – Thursday 7 March 2024 10am Research update and what next Speaker: Nataile Saad - Research Sister - Welcome Trust Southampton University Hospital Week 4 – Thursday 14 March 2024 10am Finances planning ahead Speaker: Lisa Pearson - Financial Advisor - Asset management Week 5 – Thursday 21 March 2024 9.30 -12.30pm (note longer session)* Narrative Therapy: Coping with Feelings, supporting a loved one and self-care. Mariangels Ferrer – Clinical Psychologist – Riverbank Psychology * We will invite previous course participants to this part of the course but can only accommodate a maximum of 12/14 people on the day. The focus of Narrative Therapy in this group is to participate in a creative activity that explores identity through values, beliefs, and support systems, enabling us to make connections to our external lives which will be sustainable in our everyday lives. Mariangels Ferrer Duch is a Clinical Psychologist trained in Narrative Therapy who will be facilitating a three-hour Narrative Therapy session. The focus of the session will be upon the many small things that are important to us in life which can often be overlooked in times of stress. We hope the conversation will help to mutually inspire us all! We take your privacy seriously and promise to never sell your data. You can find out more about your rights, how we use your personal information and how we keep your details safe and secure by reading our privacy policy here. For more information email info@hda.org.uk or call 0151 331 5444.

Confidence training Eradication of materialism thoughts Learning more about your needs Dating advice Dating coaching Discuss goals and aspirations Dating assistance 5 x 30 mins sessions Per day https://relationshipsmdd.com/product/m-d-d-i-want-a-girlfriend-but-i-dont-feel-financially-stable-package/

Course Overview This course provides a comprehensive exploration of cryptocurrency, covering essential topics such as wallets, investing, and trading. Designed for both beginners and those looking to refine their knowledge, it equips learners with a solid understanding of how to navigate the cryptocurrency market. The course will cover how to purchase cryptocurrency, set up and secure digital wallets, and explore strategies for investing and trading. By the end of the course, learners will have the knowledge and confidence to engage with cryptocurrency effectively, whether for investment purposes or trading. Course Description In this course, learners will delve into the fundamentals of cryptocurrency, including how to purchase digital assets and store them securely in wallets. The course covers a variety of investment strategies tailored to the crypto market, alongside technical trading methods such as candlestick chart analysis. A special bonus section is included to introduce learners to Steemit, a blockchain-based social media platform. Throughout the course, participants will gain a deeper understanding of how cryptocurrencies function, key storage options, and the risks and rewards associated with investing and trading in this rapidly evolving market. Course Modules Module 01: Welcome to the Course! Module 02: Introduction to Cryptocurrency Module 03: Purchase Cryptocurrency | How to Purchase Any Cryptocurrency Module 04: Cryptocurrency Wallets & Storage | How to Setup & Add Cryptocurrency to Wallets Module 05: Cryptocurrency Investing | Investing Strategies & Tips for Cryptocurrency Module 06: Cryptocurrency Trading | Technical Analysis, Candlestick Charts & Strategies Module 07: BONUS SECTION: Steemit | How to Get Started on Steemit (See full curriculum) Who is this course for? Individuals seeking to understand cryptocurrency and how to manage digital assets. Professionals aiming to expand their financial portfolio with cryptocurrency investments. Beginners with an interest in blockchain technology and digital currencies. Anyone looking to explore cryptocurrency as a potential new career path or investment opportunity. Career Path Cryptocurrency Trader Digital Asset Manager Blockchain Consultant Financial Analyst in Crypto Markets Investment Specialist in Emerging Technologies

Why Study AAT Want a new direction for your career? Think Accountancy, according to statistics, the average salary for Accountants is £50,000, it is the sector where the employability rate is higher than any other sector. Whether you're a school leaver, already employed or simply looking for a career change a career in accountancy could be a real option for you. What is AAT? The AAT is an internationally recognised accounting qualification and over 100,000 people are currently benefiting from gaining an AAT qualification and full AAT membership. Gaining the qualification will help you support yourself throughout your accountancy career. What are the benefits after I finish AAT Courses? A newly qualified AAT member can expect to earn an average of £21,600. Moreover, the AAT member will have been earning throughout their training and will have avoided student debt. Accounting technicians work at all levels of finance and accounting, depending on the level of their career. Some accounting technicians work as accounts clerks, others go on to become managing directors or finance directors of well-known companies. Some go to work as a self employed accountant as AAT allows the student to become Accredited. AAT Qualification AAT provides a range of accounting and bookkeeping qualification. If you prefer to pursue your career as an accountant you may choose to go for AAT Accounting qualification. However, if you prefer to build your career as a bookkeeper, you may choose to go for AAT Bookkeeping qualification. Osborne Training is an AAT Approved Training Provider with centres in London , Watford, Birmingham and various other locations. In taking the Association of Accounting Technicians qualification with our Institute, you will make one of the greatest decision of your career. AAT Accounting Courses First of all, the AAT qualification consists of four progressive qualification levels (1, 2, 3 & 4) which will cover the key areas of Financial Accounting, Management Accounting, Taxation, Audit and Report Writing. Although you can start from Level 1, you may start from Level 2 if you have basic math and numeracy skills. In order to complete the full AAT Accounting qualification and gain full membership of the AAT, you will need to complete Level 3 and Level 4. Level 2 is recommended as an entry-level if you have no experience or knowledge of accounting and bookkeeping. The AAT qualification for accounting is broken down into three levels: AAT Level 2 Foundation Certificate in Accounting (5 Papers/Subjects) AAT Level 3 Advanced Diploma in Accounting (6 Papers/Subjects) Finally AAT Level 4 Professional Diploma in Accounting (6 Papers/Subjects) Hence, the AAT Accounting Qualification gives you practical, internationally recognised finance and accountancy skills that can open doors for you in any industry across the world. Finally, AAT offers a range of benefits for student members (including study support, career advice to help find the perfect job and exclusive discounts), as well as a route to progress into chartered accountancy. Moreover, if you choose to further your studies with any of the leading chartered accountancy professional bodies like ACCA, CIMA, CIPFA etc. your AAT qualification could make you eligible for generous exemptions.