43704 Courses in Cardiff delivered Online

This one hour evening workshop will help you to start the process of thinking about what you want to do (e.g: major repairs, improved access, reordering to create flexible space, installing toilets or a kitchenette) and the initial steps to take towards developing it into a viable project. We'll also look at the different types of funders you might want to consider applying to for a grant. Please note numbers are limited to allow everyone a chance to tak and share their ideas.

A four-hour workshop on how to retain your talented Neurodiverse colleagues and ensure equality in employment opportunities.

Duration 2 Days 12 CPD hours This course is intended for This course is intended for business users who have been using Power BI to build analytic solutions and are ready to take advantage of the power and flexibility that DAX provides. Learning DAX is a very common 'next step' for experienced Power BI users. Overview At course completion, you should be able to describe DAX syntax, data types, and errors use DAX to create calculated columns, measures, and tables explain how DAX calculations are evaluated, along with the differences between row context and filter context configure and use Time Intelligence to perform common time-based calculations, for example to-date calculations, year-over-year analysis, moving averages, etc. create calculated columns and measures that use data from multiple tables in the data model write measures that handle error conditions gracefully use DAX to enhance the Power BI user experience use DAX Studio to connect to a Power BI data model and execute simple queries Welcome to Introduction to DAX for Power BI. This two-day instructor-led course is intended for business users who have been using Power BI and want to use DAX to create custom calculations in their data models. In this class, you will be introduced to using Data Analysis Expressions (DAX), which is the expression language that is used to create custom calculations in the Power BI Data model. The course covers some of the theoretical underpinnings of the data model and the DAX language, but the emphasis is on using DAX to solve common business problems. You will learn how to write your own calculated columns, measures, and tables, how to visualize the way Power BI computes DAX calculations, and how to troubleshoot custom code. MODULE 1: GETTING STARTED WITH DAX INTRODUCTION TODAX CREATING OBJECTS WITHDAX CONTEXT AND RULES OF EVALUATION VARIABLES,COMMENTS,AND TESTING MODULE 2: PERFORMING BASIC CALCULATIONS GETTING STARTED IMPLICIT MEASURES ADDING QUICK MEASURES WORKING WITH DAX DATA TYPES . DOING BASIC MATH USING LOGIC IN YOUR CALCULATIONS USING THE IF() FUNCTION NESTED IF() USING THE SWITCH() FUNCTION ADVANCED SWITCH() LOGICAL OPERATORS & FUNCTIONS: ||, OR(), &&, AND(), NOT() AGGREGATING AND SUMMARIZING DATA THE SUM() FUNCTION MODULE 3: WORKING WITH CONTEXT IN THE DATA MODEL CONTEXT DEFINED DATA MODELING BASICS INTRODUCTION TO DIMENSIONAL MODELING RELATIONSHIPS AND THEIR EFFECT ON THE EVALUATION CONTEXT GETTING DATA FROM OTHER TABLES USING RELATED() AND RELATEDTABLE LOOKING UP DATA WITHOUT USING RELATIONSHIPS MODIFYING THE CONTEXT USING CALCULATE() MODULE 4: PERFORMING MORE ADVANCED CALCULATIONS THE DAX ITERATOR FUNCTIONS USING TABLE MANIPULATION FUNCTIONS MODULE 5: WORKING WITH TIME PERFORMING DATE CALCULATIONS WORKING WITH DATE TABLES GENERATING A DATE TABLE WITH THE CALENDAR() FUNCTION DEFINING CUSTOM OPERATING PERIODS YTD, QTD, AND MTD CALCULATIONS CUSTOM TO-DATE CALCULATIONS FINDING YEAR-OVER-YEAR CHANGE FINDING MOVING AVERAGES MODULE 6: ENHANCING THE USER EXPERIENCE CONTROLLING VISIBILITYOF YOUR MEASURES USING WHAT-IF PARAMETERS ADDING BANDING USING DAX TO PROVIDE ROW-LEVEL SECURITY

BGP training course description A study of BGP for non engineers working in the Internet. The course starts with a review of the basics of routers and routing tables and then moves on to a simple overview of how BPG works with a focus on BGP metrics influencing the route traffic takes through the Internet. Hands on with routers follow the major sessions to reinforce the theory. Note these hands on sessions are more demonstrations by the trainer but some can be followed along and done by delegates (e.g. looking at Internet routing tables.) What will you learn Explain how routing tables influence Internet traffic. Describe how BGP works. Explain the methods BGP can use to influence Internet traffic. Use traceroute, peeringdb, route collectors and looking glasses to analyse traffic flows. Explain the difference between bi lateral and multilateral peering using a route server. BGP training course details Who will benefit: Non technical staff wishing to know more about BGP. Prerequisites: None. Duration 1 day BGP training course contents Networks, routers and routing tables What is a network, what is a router, routing tables, static routes, routing protocols. When an ISP uses static routes and when they use BGP. IP addresses, subnet masks, groups of IP addresses. IPv6. Hands on: Showing a full routing table. Seeing traceroute being used. Basic BGP What's BGP? BGP versus other routing protocols, ASs, AS numbers. RIPE database, peeringdb. Hands on: Finding AS numbers. Showing simple BGP configuration and routing tables in an EVENG example. How BGP works Simple walk through of BGP incremental updates and how routes change when links go down. Hands on: Showing packets and route changes when a link goes down/comes up. BGP path selection Transit, peering, routing policy and route filtering. Longest matching rule in routing tables, route selection order, Local preference, AS prepend, MEDs. Hands on: Seeing BGP influencing traffic. Looking at peering policies in RIPE and peeringdb. Route servers What are route servers? LINX route servers, route server policy control and communities, What are route collectors, Looking glasses. Hands on: Seeing the LINX route server details in peeringdb, using a looking glass.

Our professional spray tan training teaches you everything you need to deliver flawless, streak-free tans with confidence. You'll master skin assessment, product selection, and expert application techniques, ensuring a natural, even finish every time. With a strong focus on health & safety, client consultation, and troubleshooting, our training gives you the skills to provide a premium tanning experience. Learn from industry experts and take your tanning skills to the next level!

Relationship coaching Talk through emotions and needs Address fears and emotions Ascertain your fears and address them Teaching better relationship strategies Personal dating coaching for 2 months 1 hour per week Dating advice for singles https://relationshipsmdd.com/product/how-do-i-know-partner-is-the-one-package/

Couples therapy assessment calls Gottman method Insight gaining therapy Communication counselling Positive psychology couples therapy Couples therapy effective communication exercises Homework and couples therapy implementation tasks Attachment therapy Resolve serious conflicts Improve trust and honesty Address core issues Dating advice and relationship advice Couples therapy near me https://relationshipsmdd.com/product/m-d-d-couples-therapy-8-session-package/

The purpose of this course is to describe the principles and procedures of Hazard and Operability (HAZOP) Studies. HAZOP is a structured and systematic technique for examining a defined system, with the objective of: Identifying potential hazards in the system. The hazards involved may include both those essentially relevant only to the immediate area of the system and those with a much wider sphere of influence, e.g. some environmental hazards; Identifying potential operability problems with the system and in particular identifying causes of operational disturbances and production deviations likely to lead to nonconforming products. An important benefit of HAZOP studies is that the resulting knowledge, obtained by identifying potential hazards and operability problems in a structured and systematic manner, is of great assistance in determining appropriate remedial measures. The course is designed using the tools and techniques identified by IEC 61882:2016. LEARNING OUTCOMES By the end of this course you will understand how to: prepare for a HAZOP study meeting and programme – including defining the scope of the study and choosing the team choose nodes (parts of the drawings or operation for HAZOP study) estimate the programme requirements for the successful completion of a study use facilitation techniques to motivate the team and keep them on task avoid common problems encountered during study meetings, including challenging behaviours formulate the HAZOP study report fulfil the team leader’s role in implementing recommendations and managing the process FOR WHOM Anyone with experience of the HAZOP technique who is required to lead HAZOP studies Process safety engineers, loss prevention specialists, production engineers, process design engineers, project engineers, process programmers and instrument control engineers Risk Managers COURSE CONTENT Introduction to HAZOPWhat is a HAZOP?What are Hazards and Risk?Limitations of HAZOPsEssential Features of HAZOP Principles of examination Design representation Design requirements and design intent Applications of HAZOP Relation to other analysis toolsFailure Mode Effect AnalysisAs Low As Reasonably Practicable (ALARP)Fail Tree AnalysisEvent Tree Analysis HAZOP study limitations Risk identification studies during different system life cycle stagesConcept stageDevelopment stageRealization stageUtilization stageEnhancement stageRetirement stage The HAZOP study procedure Initiate the study Define scope and objectives Define roles and responsibilities Preparation Plan the study Collect data and documentation Establish guide words and deviations Examination Structure the examination Guidewords and Deviations Causes, Consequences and Safeguards Perform the examination Risk Ranking Documentation and follow up Establish method of recording Output of the study Record information Sign off the documentation Follow-up and responsibilities Case Study and practical application TRAINING METHODOLOGIES Presentation Case Study Individual Exercises Group Exercises DURATION: 4 Days (Examination on day 4)

Join the Scrum.org accredited Live Virtual Class - Professional Scrum Master 2 (PSM II). This is an advanced scrum master training course - designed for experienced Scrum Masters seeking professional growth. Course Description This advanced Professional Scrum Master (PSM II) qualification is designed to elevate you to a level of total Scrum mastery. Deepen your understanding of the Scrum framework and Agile practices while transforming your team into an Agile powerhouse. Gain the skills to teach Agile and support your organisation, regardless of your role. Whether you aim to lead Agile transformation within your organisation or progress your Agile career, this advanced Scrum mastery course is your ideal opportunity. Our Scrum.org certified advanced professional scrum master training course is delivered by industry experts with unrivalled interactivity. We combine real world experience with industry leading practicals that embed key principles. The PSM 2 course if focussed on developing practical skillsets and best practice implementation to achieve tangible results. Through these tried and tested learning techniques, Fractal Systems delivers a 98% first-time pass rate. Learn how to become an advanced Scrum Master: Understand how Scrum principles and values guide decision-making. Enhance servant-leadership abilities. Support Development Teams and Product Owners to improve effectiveness. Foster a conducive environment for successful Scrum Teams with greater agility. Gain tips and techniques for collaboration with the organisation. Improve overall organisational impact as a successful Scrum Master. Address team conflict and remove impediments. Communicate the significance of a "Done" Increment. Grasp how to support the Scrum Team and navigate middle management challenges. Why Train With Us? This immersive two day PSM II course prioritises your growth and success in the industry. We believe in hands-on learning experiences that deliver practical applications that are specific to your individual workplace challenges. This not only helps to frame key principles of an advanced Scrum Master but also enables you to have a more immediate impact in your role. The PSM II training course is led by our Scrum Trainers, all of which have real world industry experience. Gain a deep understanding of advanced Scrum theory, empower your Scrum teams with best practices and be supported by industry professionals throughout - from passing test to implementing learnings into your role. Who Should Attend This Course? The Professional Scrum Master II course is an advanced program tailored for experienced Scrum Masters with a deep understanding of the Scrum framework. We recommend this to individuals with at least one year of Scrum Master experience. Your Professional Scrum Trainer Meet Jay, the founder of Fractal Systems and an experienced Professional Scrum Trainer. With over 20 years in leadership and team roles, Jay excels in delivering practical value. He adopts an interactive teaching style, avoiding PowerPoint in favour of engaging, experience-based learning, using techniques from Liberating Structures and Neuro-Linguistic Programming. Jay specialises in business transformations, providing training, mentoring, coaching, and consulting to drive success through teamwork. For those pursuing the Professional Scrum Master II (PSM II) certification, Jay and the Fractal team are committed to supporting your learning journey with a range of valuable resources: Complimentary Scrum Resource Bundle Access to a PSM Exam Simulator Free PSM II Exam Coaching Sessions Personalised 1:1 Coaching At Fractal Systems, our goal is to ensure you have the support and resources needed for a successful PSM II learning experience. Our Clients Our Testimonials

Duration 3 Days 18 CPD hours This course is intended for This course is primarily designed for students who want to gain the skills necessary to use VBA to automate tasks in Excel such as collecting data from external sources, cleaning, and manipulating data. The target student may also want to learn how to create custom worksheet functions to streamline worksheet formulas and make complex worksheets easier to support, maintain, and understand. Overview In this course, you will develop and deploy VBA modules to solve business problems. You will: Identify general components of VBA and their appropriate use in solving business solutions. Record VBA macros to automate repetitive tasks. Use reference tools built into Excel to get help on VBA programming language and objects used in the Excel VBA environment. Write VBA code to create a custom worksheet function. Eliminate, avoid, or handle errors in VBA code, and optimize its performance. Control how and when macros run. Develop UserForm objects to create custom dialog boxes and windows. Use VBA to read and write data from local files and cloud services. Use VBA to clean and transform data. Run programs and commands outside of Excel and share VBA projects with other users VBA (Visual Basic for Applications) enables you to enhance and extend the capabilities of Microsoft© Excel© and other applications in the Microsoft© Office application suite. You can use VBA to perform tasks that would be difficult or impossible to do using only worksheet functions, and you can automate a wide range of tasks involving the collection, processing, analysis, and visualization of data. This course will give you a good foundation for understanding, creating, and using VBA in your own Excel workbooks, show you how to work with data across different applications, and how to package the macros and functions you create so you can back them up, move them to other computers, and share them with other users Prerequisites To ensure your success in this course, you should be an experienced Excel user who is comfortable creating and working with Excel workbooks, including tasks such as entering worksheet formulas, using absolute and relative addressing, formatting cells, and creating pivot tables and charts. This level of skill could be acquired by taking the Microsoft Excel for Office 365? (Desktop or Online) courses, Parts 1, 2, and 3 1 - Using VBA to Solve Business Problems Topic A: Use Macros to Automate Tasks in Excel Topic B: Identify Components of Macro-Enabled Workbooks Topic C: Configure the Excel VBA Environment 2 - Automating Repetitive Tasks Topic A: Use the Macro Recorder to Create a VBA Macro Topic B: Record a Macro with Relative Addressing Topic C: Delete Macros and Modules Topic D: Identify Strategies for Using the Macro Recorder 3 - Getting Help on VBA Topic A: Use VBA Help Topic B: Use the Object Browser to Discover Objects You Can Use in VBA Topic C: Use the Immediate Window to Explore Object Properties and Methods 4 - Creating Custom Worksheet Functions Topic A: Create a Custom Function Topic B: Make Decisions in Code Topic C: Work with Variables Topic D: Perform Repetitive Tasks 5 - Improving Your VBA Code Topic A: Debug VBA Errors Topic B: Deal with Errors Topic C: Improve Macro Performance 6 - Controlling How and When Macros Run Topic A: Prompt the User for Information Topic B: Configure Macros to Run Automatically 7 - Developing Custom Forms Topic A: Display a Custom Dialog Box Topic B: Program Form Events 8 - Using VBA to Work with Files Topic A: Use VBA to Get File and Directory Structure Topic B: Use VBA to Read Text Files Topic C: Use VBA to Write Text Files 9 - Using VBA to Clean and Transform Data Topic A: Automate Power Query Topic B: Transform Data Using VBA and Workbook Functions Topic C: Use Regular Expressions Topic D: Manage Errors in Data 10 - Extending the Programming Environment Beyond the Workbook Topic A: Run Other Programs and Commands Topic B: Share Your VBA Projects