1924 Courses in Cardiff delivered Live Online

Duration 1 Days 6 CPD hours This course is intended for This course is designed for professionals in a variety of job roles who receive Tableau data visualizations from data analysts or from data visualization engineers. These data report recipients want to take advantage of the many Tableau features and capabilities that enable them to explore the data behind the initial analysis, perform additional analysis to ask next-level questions of the data, and to customize visualizations and dashboards to share new insights and create compelling reports. Overview Explore Tableau reports. Analyze data to get answers and insights. Sort and group data for analysis and reporting. Filter views. Prepare reports. Troubleshoot, collaborate, and share views and analysis As data acquisition, access, analysis, and reporting are interwoven with our businesses and lives, more and more data is collected about business and personal activities. This abundance of data and the computing power to analyze it has increased the use of data analysis and data visualization across a broad range of job roles. Decision makers of all types, including managers and executives, must interact with, interpret, and develop reports based on data and analysis provided to them. Tableau© software is designed for data analysis and the creation of visualizations. Data analysts prepare data, perform initial analysis, and create visualizations that are then passed on to business data-driven decision makers. These decision makers can use Tableau's tools to explore the data, perform further analysis to find new insights, make decisions, and create customized reports to share their findings. Prerequisites To ensure your success in this course, you should have experience managing data with Microsoft© Excel© or Google Sheets? Lesson 1: Exploring Tableau Reports Topic A: Data Analysis Workflow with Tableau Topic B: Explore Views Topic C: Edit Workbooks Lesson 2: Analyzing Data to Get Answers and Insights Topic A: Configure Marks with the Marks Card Topic B: Ask New Questions by Changing Aggregation Topic C: Find Answers with Calculations Topic D: Answer Questions with Table Calculations Lesson 3: Sorting and Grouping Data for Analysis and Reporting Topic A: Sort Data Topic B: Group Data Lesson 4: Filtering Views Topic A: Filter Data to Refine Analysis Topic B: Create Interactive Filters for Reports Lesson 5: Preparing Reports Topic A: Format and Annotate Views to Tell Your Story Topic B: Emphasize Data in Reports Topic C: Animate Visualizations for Clarity Lesson 6: Troubleshooting, Sharing, and Collaborating Topic A: Troubleshoot Data Issues Topic B: Collaborate in Tableau Online Topic C: Collaborate with Non-Tableau Users

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

Duration 1 Days 6 CPD hours This course is intended for The Power BI in a Day course is designed for beginners and intermediate users of Power BI. Overview #NAME? Students will discover the full capabilities of Power BI in a one-day, hands-on workshop. Please Note: This workshop is primarily self-directed and students will work at their own pace while having access to an instructor for questions. 1 - Accessing & Preparing data Data Set Power BI Desktop Power BI Desktop ? Accessing Data Power BI Desktop ? Data Preparation 2 - Data Modeling and Exploration Power BI Desktop ? Data Modeling and Exploration Power BI Desktop ? Data Exploration Continued References 3 - Data Visualization Power BI Desktop Power BI Desktop ? Data Visualization References 4 - Publishing & Accessing Reports Power BI Desktop ? Creating Mobile View Power BI Service Power BI Service ? Publishing Report Power BI Mobile ? Accessing Report on Mobile Device Power BI Service ? Collaboration and Distribution References 5 - Dashboard and Collaboration Power BI Service Building Dashboard References Additional course details: Nexus Humans Power BI: Dashboard in a Day 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 Power BI: Dashboard in a Day 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.

ADVANCED 8 CPD POINTS 1 DAY INTENSIVE COURSE  ONLINE or IN-CLINIC NOTE! After booking we will contact you for scheduling the exact course date! Courses dates are subject to change due to mentors availability. We will inform you via email if a date becomes available! This course theory will help you to understand: We will cover all you need to know in order for you to treat your patients confidently and safely. The Theory will cover; Anatomy and physiology Ageing Characteristic of the ideal skin booster Product Introduction Treatment Method Contraindication Complication management Pre & Post-treatment advices Using Products like Toskani, Skinecos, Jalupro etc. Using Products , PROFHILO, recommended for midd and low part of the face as well as other delicate areas of skin such as the neck, décolletage, hands or knees. Practice will enable you to learn in 1-day ONE-TO-ONE Training We will cover pertinent information including mechanism of action, safety and efficacy issues, management and treatment of complications, dilution guidelines, and more. A certification of hands-on training will be provided upon completion of the course. You will perform this procedure on live models injecting superficially and administrating the product (skinbooster) into the subcutaneous layer. This will happen under the supervision and guidance of highly experienced aesthetic practitioners. You will practice injectables with needle on; Face, Neck, Decolatege & Hands You need to be medically qualified as a doctor, dentist, nurse, pharmacist or paramedic with full governing body registration and have completed a Foundation Filler Course and to have administered a number of cases. Additional information ATTENDANCE ONLINE (Theory), IN CLINIC (Practice) COURSE LEVEL INTERMEDIATE | Advanced Course

Duration 1 Days 6 CPD hours This course is intended for Individuals responsible for articulating the technical benefits of AWS services Individuals interested in learning how to get started with using AWS SysOps Administrators, Solution Architects and Developers interested in using AWS services Overview Recognize terminology and concepts as they relate to the AWS platform and navigate the AWS Management Console. Understand the foundational services, including Amazon Elastic Compute Cloud (EC2), Amazon Virtual Private Cloud (VPC), Amazon Simple Storage Service (S3), and Amazon Elastic Block Store (EBS). Understand the security measures AWS provides and key concepts of AWS Identity and Access Management (IAM). Understand AWS database services, including Amazon DynamoDB and Amazon Relational Database Service (RDS). Understand AWS management tools, including Auto Scaling, Amazon CloudWatch, Elastic Load Balancing (ELB), and AWS Trusted Advisor. AWS Technical Essentials introduces you to AWS services, and common solutions. It provides you with fundamental knowledge to become more proficient in identifying AWS services. It helps you make informed decisions about IT solutions based on your business requirements and get started working on AWS. Prerequisites Working knowledge of distributed systems Familiarity with general networking concepts Working knowledge of multi-tier architectures Familiarity with cloud computing concepts 1 - AWS introduction and history AWS Global Infrastructure Demonstration: AWS Management Console 2 - AWS Storage Identify key AWS storage options Describe Amazon EBS Create an Amazon S3 bucket and manage associated objects 3 - Compute, network and storage services Amazon Elastic Compute Cloud (EC2) Amazon Virtual Private Cloud (VPC) Amazon Simple Storage Service (S3) Amazon Elastic Block Store (EBS) Demonstration: Amazon Simple Storage Service (S3) Hands-on lab: Build your VPC and launch a web server 4 - AWS Security, AWS Identity and Access Management (IAM) AWS Identity and Access Management (IAM) Demonstration: AWS Identity and Access Management (IAM) 5 - Compute Services & Networking Identify the different AWS compute and networking options Describe an Amazon Virtual Private Cloud (VPC) Create an Amazon EC2 instance Use Amazon EBS with Amazon EC2 6 - Managed Services & Database Describe Amazon DynamoDB Understand key aspects of Amazon RDS Launch an Amazon RDS instance 7 - Databases (RDS, DynamoDB) SQL and NoSQL databases Data storage considerations Hands-on lab: Build your database server and connect to it 8 - AWS elasticity and management tools Auto scaling Load balancing Cloud Watch Trusted Advisor Hands-on lab: Scale and load balance your architecture 9 - Deployment and Management Identify what is CloudFormation Describe Amazon CloudWatch metrics and alarms Describe Amazon Identity and Access Management (IAM)

Working with Groups for Counsellors. 3 Day CPD.

Duration 1 Days 6 CPD hours This course is intended for Security IT business-level professionals interested in cloud security practices Security professionals with minimal to no working knowledge of AWS Overview Assimilate Identify security benefits and responsibilities of using the AWS Cloud Describe the access control and management features of AWS Explain the available methods for providing encryption of data in transit and data at rest when storing your data in AWS. Describe how to secure network access to your AWS resources Determine which AWS services can be used for monitoring and incident response This course covers fundamental AWS cloud security concepts, including AWS access control, data encryption methods, and how network access to your AWS infrastructure can be secured. Based on the AWS Shared Security Model, you learn where you are responsible for implementing security in the AWS Cloud and what security-oriented services are available to you and why and how the security services can help meet the security needs of your organization. Prerequisites Working knowledge of IT security practices and infrastructure concepts, familiarity with cloud computing concepts 1 - Security on AWS Security design principles in the AWS Cloud AWS Shared Responsibility Model 2 - Security OF the Cloud AWS Global Infrastructure Data center security Compliance and governance 3 - Security IN the Cloud ? Part 1 Identity and access management Data protection essentials Lab 01 ? Introduction to security policies 4 - Security IN the Cloud ? Part 2 Securing your infrastructure Monitoring and detective controls Lab 02 ? Securing VPC resources with Security Groups 5 - Security IN the Cloud ? Part 3 DDoS mitigation Incident response essentials Lab 03 ? Remediating issues with AWS Config Conformance Packs 6 - Course Wrap Up AWS Well-Architected tool overview Next Steps Additional course details: Nexus Humans AWS Security Essentials 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 AWS Security Essentials 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.

Course Information Join our comprehensive three-day programme designed as an invaluable external training opportunity for auditors, audit programme managers, and individuals subject to audits. This course is tailored to foster a deep understanding and cultivate essential skills for auditing the validation of computer systems intended for GxP environments (GLP, GCP, GMP, GDP, GPvP). Commencing with an overview of regulatory prerequisites and the system life cycle, the course swiftly transitions to focus on the pragmatic aspects of auditing computer system validation. Experience a blend of presentations, interactive discussions, and immersive practical workshops throughout the duration of the course. Delegates will benefit from practical examples of how to understand the framework of applicable regulations and guidance. Apply risk management techniques to audit planning Plan and conduct computerised system audits Assess system validation documentation to verify compliance Evaluate data integrity and security issues Prepare for regulatory inspection. The course is structured to encourage delegates to: Discuss and develop ideas Solve specific problems Understand the vulnerabilities of computerised systems Learn how to create a compliance checklist Link system development with good business practice. Is this course for you? Auditors Audit programme managers Individuals subject to audits. Tutors Tutors will be comprised of (click the photos for biographies): Nichola Stevens Director and Principal Consultant, Nuncius Compliance Solutions Ltd Barry McManus Consultancy Partner, Empowerment Quality Engineering Ltd Programme Please note timings may be subject to alteration. Day 1 09:00 Welcome and Introductions 09:45 Why We Validate and Regulatory Trends 10:30 Break 10:45 Audit Overview, High Level Process and Scheduling 11:30 System Lifecycle 12:30 Lunch 13:15 Exercise 1 - Audit Scheduling 14:45 Exercise 1 - Feedback 15:15 Break 15:30 Validation Deliverables 16:30 Risk Assessments 17:30 Close of Day 1 Day 2 09:00 Supplier Assessment 10:30 Break 10:45 Exercise 2 - Planning a Supplier Audit 12:00 Exercise 2 - Feedback 12:30 Lunch 13:15 Exercise 3 - Auditing a Computerised System Validation Package 15:30 Break 15:45 Exercise 3 - Feedback 16:30 Change Control 17:15 Close of Day Day 3 09:00 Infrastructure Qualification 09:45 Maintaining a Validated State - Operational Processes 11:00 Break 11:15 Exercise 4 - Auditing Systems in Operational Use 12:45 Lunch 13:30 Exercise 4 - Feedback 14:15 Exercise 5 - Auditing Trail Review 15:30 Break 15:45 Exercise 5 - Feedback 16:15 Course Objectives Summary and Any Additional Questions 16:45 Close of Course Extra Information Face-to-face course Course Material Course material will be available in PDF format for delegates attending this course. The advantages of this include: Ability for delegates to keep material on a mobile device Ability to review material at any time pre and post course Environmental benefits – less paper being used per course. The material will be emailed in advance of the course and RQA will not be providing any printed copies of the course notes during the training itself. Delegates wishing to have a hard copy of the notes should print these in advance to bring with them. Alternatively delegates are welcome to bring along their own portable devices to view the material during the training sessions. Remote course Course Material This course will be run completely online. You will receive an email with a link to our online system, which will house your licensed course materials and access to the remote event. Please note this course will run in UK timezone. The advantages of this include: Ability for delegates to keep material on a mobile device Ability to review material at any time pre and post course Environmental benefits – less paper being used per course Access to an online course group to enhance networking. You will need a stable internet connection, a microphone and a webcam. CPD Points 19 Points Development Level Develop

Duration 1 Days 6 CPD hours This course is intended for The audience for this course is individuals who want to learn the fundamentals of database concepts in a cloud environment, get basic skilling in cloud data services, and build their foundational knowledge of cloud data services within Microsoft Azure. Overview Describe core data concepts Identify considerations for relational data on Azure Describe considerations for working with non-relational data on Azure Describe an analytics workload on Azure In this course, students will gain foundational knowledge of core data concepts and related Microsoft Azure data services. Students will learn about core data concepts such as relational, non-relational, big data, and analytics, and build their foundational knowledge of cloud data services within Microsoft Azure. Students will explore fundamental relational data concepts and relational database services in Azure. They will explore Azure storage for non-relational data and the fundamentals of Azure Cosmos DB. Students will learn about large-scale data warehousing, real-time analytics, and data visualization. 1 - Explore core data concepts Identify data formats Explore file storage Explore databases Explore transactional data processing Explore analytical data processing 2 - Explore data roles and services Explore job roles in the world of data Identify data services 3 - Explore fundamental relational data concepts Understand relational data Understand normalization Explore SQL Describe database objects 4 - Explore relational database services in Azure Describe Azure SQL services and capabilities Describe Azure services for open-source databases 5 - Explore Azure Storage for non-relational data Explore Azure blob storage Explore Azure DataLake Storage Gen2 Explore Azure Files Explore Azure Tables 6 - Explore fundamentals of Azure Cosmos DB Describe Azure Cosmos DB Identify Azure Cosmos DB APIs 7 - Explore fundamentals of large-scale data warehousing Describe data warehousing architecture Explore data ingestion pipelines Explore analytical data stores 8 - Explore fundamentals of real-time analytics Understand batch and stream processing Explore common elements of stream processing architecture Explore Azure Stream Analytics Explore Apache Spark on Microsoft Azure 9 - Explore fundamentals of data visualization Describe Power BI tools and workflow Describe core concepts of data modeling Describe considerations for data visualization

Duration 1 Days 6 CPD hours This course is intended for This course is intended for individuals who want to become more rational and disciplined thinkers. Overview Upon successful completion of this course, students will boost their performance with an increase in their decision-making ability. In this course, students will learn develop their ability to analyze and evaluate information. 1 - GETTING STARTED Icebreaker Housekeeping Items The Parking Lot Workshop Objectives 2 - COMPONENTS OF CRITICAL THINKING Applying Reason Open Mindedness Analysis Logic Case Study 3 - NON-LINEAR THINKING Step Out of Your Comfort Zone Don't Jump to Conclusions Expect and Initiate Change Being Ready to Adapt Case Study 4 - LOGICAL THINKING Ask the Right Questions Organize the Data Evaluate the Information Draw Conclusions Case Study 5 - CRITICAL THINKERS (I) Active Listening Be Curious Be Disciplined Be Humble Case Study 6 - CRITICAL THINKERS (II) Seeing the Big Picture Objectivity Using Your Emotions Being Self-Aware Case Study 7 - EVALUATE INFORMATION Making Assumptions Watch out for Bias Ask Clarifying Questions SWOT Analysis Case Study 8 - BENEFITS OF CRITICAL THINKING Being More Persuasive Better Communication Better Problem Solving Increased Emotional Intelligence Case Study 9 - CHANGING YOUR PERSPECTIVE Limitations of Your Point of View Considering Others Viewpoint Influences on Bias When New Information Arrives Case Study 10 - PROBLEM SOLVING Identify Inconsistencies Trust Your Instincts Asking Why? Evaluate the Solution(s) Case Study 11 - PUTTING IT ALL TOGETHER Retaining Your New Skills Reflect and Learn From Mistakes Always Ask Questions Practicing Critical Thinking Case Study 12 - WRAPPING UP Words from the Wise Review of Parking Lot Lessons Learned Completion of Action Plans and Evaluations