5239 AR courses in Cardiff delivered Live Online

Duration 2 Days 12 CPD hours This course is intended for This course is designed for people who need output from a database. In some cases, database programs have limited reporting tools, or tools that are not accessible. Learners may or may not have programming or SQL experience. Overview In this course, you will connect to a database to extract data and present it as a report. You will: Identify the elements of the Crystal Reports interface. Create and modify a basic report. Use formulas to calculate and filter data. Build a parameterized report. Group report data. Enhance a report. Create a report using data from an Excel workbook. Distribute data. In this course, students will create a basic report by connecting to a database and modifying the report's presentation. 1 - EXPLORING THE CRYSTAL REPORTS INTERFACE Topic A: Explore Crystal Reports Topic B: Use Crystal Reports Help Topic C: Customize Report Settings 2 - WORKING WITH REPORTS Topic A: Create a Report Topic B: Modify a Report Topic C: Display Specific Report Data Topic D: Work with Report Sections 3 - USING FORMULAS IN REPORTS Topic A: Create a Formula Topic B: Edit a Formula Topic C: Filter Data by Using a Formula Topic D: Work with Advanced Formulas and Functions Topic E: Handle Null Values 4 - BUILDING PARAMETERIZED REPORTS Topic A: Create a Parameter Field Topic B: Use a Range Parameter in a Report Topic C: Create a Prompt 5 - GROUPING REPORT DATA Topic A: Group Report Data Topic B: Modify a Group Report Topic C: Group by Using Parameters Topic D: Create a Parameterized Top N Report 6 - ENHANCING A REPORT Topic A: Format a Report Topic B: Insert Objects in a Report Topic C: Suppress Report Sections Topic D: Use Report Templates 7 - CREATING A REPORT FROM EXCEL DATA Topic A: Create a Report Based on Excel Data Topic B: Modify a Report Generated from Excel Data Topic C: Update Data in a Report Based on Excel Data 8 - DISTRIBUTING DATA Topic A: Export Data Topic B: Create Mailing Labels 9 - APPENDIX Appendix A: Setting Up and Configuring Data Sources Appendix B: Using Report Processing Techniques Appendix C: Using Functions in Formulas

Duration 2 Days 12 CPD hours This course is intended for This course is designed for people who know how to create basic list and group reports and need to create reports that include subreports, cross-tabs, advanced formulas, and charts based on more than one data series. They may also need to build tools that make it easier for other people to create reports. They may or may not have programming and/or SQL experience. Overview In this course, you will create complex reports using tools in Crystal Reports 2016. You will: Create automatic and manual running totals. Work with cross-tab reports. Add subreports. Create drill-downs in a report. Use SQL statements in report processing. Create complex formulas. Add charts to reports. Enhance report functionality. In this course, students will create complex reports & data sources using the tools in Crystal Reports 2016. Students will not only create more complex reports including sub-reports and cross-tabs, but will also increase their speed and efficiency. 1 - CREATING RUNNING TOTALS Topic A: Create a Running Total Field Topic B: Modify a Running Total Field Topic C: Create a Manual Running Total 2 - WORKING WITH CROSS-TABS Topic A: Create a Cross-Tab Report Topic B: Format a Cross-Tab Report Topic C: Create Groups in Cross-Tab Reports 3 - ADDING SUBREPORTS Topic A: Insert a Subreport Topic B: Edit a Subreport Topic C: Share Variables 4 - CREATING DRILL-DOWNS IN A REPORT Topic A: Create a Drill-Down Topic B: Create Headings for Drill-Down Data 5 - USING SQL STATEMENTS IN REPORT PROCESSING Topic A: Create a Report Using SQL Queries Topic B: Summarize Report Data Topic C: Create Joins Using SQL Topic D: Create Subqueries Topic E: Create an SQL Expression Field 6 - CREATING COMPLEX FORMULAS Topic A: Work with Loops Topic B: Work with Arrays 7 - ADDING CHARTS TO REPORTS Topic A: Create Charts Topic B: Create a Chart with Drill-Down Topic C: Create a Top N Chart Topic D: Create a Cross-Tab Chart Topic E: Create Charts for Grouped Data Topic F: Format a Chart Topic G: Create a Chart Template 8 - ENHANCING REPORT FUNCTIONALITY Topic A: Organize Data Based on a Hierarchy Topic B: Create a Dynamic Image Topic C: Create a Report Alert Topic D: Create a Geographic Map 9 - APPENDIX Appendix A: Managing Reports Appendix B: Processing Data on the Server Appendix C: Detecting and Fixing Problems

Become a certified UI designer Learn how to create beautiful, pixel-perfect user interfaces Accelerate your career with an in-demand skillset Get a professional qualification in just 12 weeks Manage your own schedule with our flexible, self-paced online course Expand your career options UI skills are needed worldwide, and demand is growing. With a globally recognised qualification, you’ll become a more valuable, sought-after professional. Design with confidence You’ll understand the ‘why’ of good UI design by knowing the principles behind it. You’ll be able to defend your decisions and design with confidence. Work in a creative, rewarding job UI designers add personality and visual appeal to user interfaces. It’s an enjoyable career that rewards creativity: the perfect entry into tech for visually-minded people. A flexible, university-backed curriculum Our curriculum is university credit-rated and approved by the industry. Over 12 weeks, you’ll learn the principles and skills you need to become a confident UI designer. Study method Online, self-paced Duration 12 weeks Access to content 12 months Qualification Professional Certificate in UI Design Awarded by Scottish Qualifications Authority trading as SQA Additional info Exam(s) / assessment(s) is included in price Tutor is available to students Description During this 12 week, online course you will learn: Introduction to UI Design Brand and Personality Layout Design Principles Interactivity Typography Colour, shapes and effects Iconography and imagery Design process Presenting ideas UI design tools You will also work on a project and your portfolio with access to weekly mentor sessions, an active student community, and support from our student success team. Who is this course for? Graphic designers and digital designers who want to upskill to UI design UI designers who want to strengthen their knowledge and craft UX professionals who want to become more rounded product designers Anybody with a design background looking for a creative job in tech Requirements You don’t need experience in design or technology to enrol in our courses, although having one or both is a definite bonus. Our students come from a diverse mix of backgrounds, including project management, development, graphic design, product management, business analysis and so on. You need to be motivated and committed. We set a high bar. Studying for one of our professional qualifications requires a certain amount of time, energy and focus. You need to be comfortable learning in English. All video lessons, course materials, webinars, correspondence and the final exam are delivered in English. Career path Students typically graduate into UI Designer jobs. The average UI Designer salary in the UK with 3-5 years experience is £62,500. This is based on data from Payscale, Totaljobs, Indeed, Talent, and Glassdoor

Exciting news! My popular 'Getting Started in Data Governance' course is making it's way across the pond! Due to numerous requests, I'm thrilled to announce that I will be hosting a U.S. edition of the course.

Achieving certification for Compliance Management Systems (ISO 37301:2021) through an external audit process to help you identify, prevent and address compliance risks within your organisation provides a range of benefits. What if you could gain the expertise to conduct internal audits in-house, to not only successfully complete ISO certification, but allow you to continue to monitor your adherence to that certification standard? 'Prove your competency to the wider compliance industry.' Created by UKAS accredited ISO certification experts, this wholly unique, internationally focussed, 2-day online internal auditor training course is a fantastic way to develop your in-house expertise and allow your team to attain the competence they need to maintain and continually improve your management system. A cost-effective route, negating the need to hire external consultants Avoid closing a business for what might be a lengthy audit Prove your ' culture of compliance', and in turn, strengthen your 2nd and 3rd lines of defence Add additional skills to your CV, demonstrating your commitment to best practice while gaining a competitive advantage for your organisation. 'Don't just tick the boxes, demonstrate a culture of compliance.' Ensure you are fully compliant with relevant legislation and regulation and give confidence to the regulators, your partners, and clients that you have processes in place to comply with the law. Developing knowledge of compliance management system standards/normative documents Developing knowledge of ICA Audit (certification body's) processes Developing knowledge of relevant business sectors Developing knowledge of business management practices and how they integrate into business activities Developing knowledge of audit principles, practices, and techniques Developing knowledge of client products, processes, and organization Developing language skills appropriate to all levels within the client organization Developing notetaking and report-writing skills Developing presentation skills Developing interviewing skills

Gain robust techniques for obtaining feedback from end users throughout product design, and learn how to identify new opportunities for design improvement.

Why Learn Revit and 3dsMax V-Ray Visualization Basic to Advance Training Course? Course info Master architectural visualization and photorealistic renderings. In-person or live online options available. Learn Revit and 3dsMax, V-Ray rendering, and advanced techniques. Hands-on projects for real-world experience. Duration: 40 hrs Method: 1-on-1 - Individual support. Schedule: Tailor your own schedule by pre-booking a convenient hour of your choice, available from Mon to Sat between 9 am and 7 pm. Comprehensive Training: Master Revit, 3dsMax, and advanced visualization techniques for exceptional results. V-Ray Rendering: Explore realistic rendering with V-Ray, including advanced techniques and materials. Real-World Projects: Work on industry-relevant projects for a professional portfolio. Flexible Learning: Choose in-person or live online sessions for an engaging experience. Lesson Recordings: Access recorded classes to reinforce your understanding. Lifetime Email Support: Get guidance and assistance from experienced instructors beyond the course duration. Autodesk Certified Instructors. Comprehensive Training: Master Revit, 3dsMax, and advanced visualization techniques for exceptional results. V-Ray Rendering: Explore realistic rendering with V-Ray, including advanced techniques and materials. Real-World Projects: Work on industry-relevant projects for a professional portfolio. Flexible Learning: Choose in-person or live online sessions for an engaging experience. Lesson Recordings: Access recorded classes to reinforce your understanding. Lifetime Email Support: Get guidance and assistance from experienced instructors beyond the course duration. Autodesk Certified Instructors. Part 1: Revit (16 hours) Module 1: Introduction to Revit Familiarizing with the Revit interface and workspace Embracing the Building Information Modeling (BIM) workflow Creating a fundamental building model as a starting point Module 2: Basic Modeling in Revit Working with essential elements such as walls, doors, and windows Constructing floors and roofs to complete the building structure Crafting functional and visually appealing stairs and railings Module 3: Advanced Modeling in Revit Delving into the creation and manipulation of families Utilizing parameters and constraints to enhance modeling efficiency Exploring intricate geometries for complex designs Module 4: Annotation and Documentation in Revit Enhancing project documentation by adding text and dimensions Generating informative schedules for better project management Mastering the printing and exporting processes for professional output Part 2: 3ds Max (16 hours) Module 1: Introduction to 3ds Max Navigating the 3ds Max interface and workspace Understanding the 3D modeling workflow for design visualization Initiating the creation of basic 3D models Module 2: Basic Modeling in 3ds Max Working with primitive shapes to build foundational models Creating and refining splines to form versatile shapes Advancing to complex 3D model development for intricate designs Module 3: Materials and Textures in 3ds Max Exploring the material editor and its functionalities Skillfully applying and adjusting materials for realistic renders Incorporating textures to add depth and detail to the models Module 4: Lighting and Cameras in 3ds Max Mastering the art of lighting creation and manipulation Utilizing the daylight system for enhanced realism Understanding cameras and perspectives for compelling visual storytelling Part 3: V-Ray (8 hours) Module 1: Introduction to V-Ray Getting acquainted with the V-Ray interface and workflow Exploring V-Ray materials and textures for high-quality renders Module 2: Lighting and Rendering in V-Ray Creating and refining lighting setups for stunning renders Utilizing global illumination to enhance the realism of scenes Implementing advanced rendering techniques for professional output Module 3: Materials and Textures in V-Ray Crafting and modifying V-Ray materials for realistic surfaces Applying V-Ray textures to add depth and realism to objects Utilizing V-Ray displacement maps for intricate details For 3ds Max free trial, visit: https://www.autodesk.co.uk/products/free-trial. To access the V-Ray free trial, visit: https://www.chaosgroup.com/. Start your journey to becoming a proficient designer and renderer in the world of 3D modeling and visualization. Download Revit Revit and 3dsMax V-Ray Visualization Basic to Advance Training Course: Proficient Software Skills: Acquire a strong command of Revit and 3dsMax, along with advanced techniques in V-Ray rendering. High-Quality Visualizations: Create realistic and visually stunning architectural visualizations using V-Ray. Architectural Modeling: Master the process of modeling architectural elements with precision and efficiency. Materials and Textures: Understand how to apply realistic materials and textures to enhance visualizations. Lighting Setup: Set up lighting environments to achieve optimal illumination and ambiance in renderings. Rendering Techniques: Explore advanced rendering techniques, including global illumination, caustics, and ambient occlusion. Real-World Projects: Complete industry-relevant projects to build a professional-grade portfolio. Problem-Solving Skills: Develop the ability to troubleshoot and resolve rendering challenges effectively. Efficient Workflows: Learn time-saving workflows and best practices for efficient visualization production. Portfolio Showcase: Showcase your newly acquired skills through a diverse range of visualizations.

MASTERCLASS 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! On this course, we aim to help you master a technique that will set you apart from most routine cosmetic treatment providers and enable you to step into the future of advanced cosmetic. Training THEORY will enable you to understand: Anatomy Vascular Supply, Nerves on the face Contraindications Patient consultation ONE-TO-ONE Training Nose Job Masterclass You will perform this procedure on live models under the supervision and guidance of highly experienced aesthetic practitioners. You will be trained under ENT specialist. We will give you all the knowledge you need for a safe technique in your practice. A certification of training will be provided upon completion of the course. 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 EXPERT | Masterclass Course

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

This course will help you and your employees gain the necessary vocabulary, grammar, and conversational abilities from our qualified instructors. Additionally, our interactive lessons and hands-on activities will improve your BSL proficiency and comprehension. This Course At A Glance Live Zoom classes with an expert BSL tutor, Adam Linsdell. Gain an extensive understanding of deaf awareness. Acquire knowledge of several commonly used vocabulary words. CPD Accredited certificates are recognized by employers and professional organisations. Enhance your communication skills through practical exercises. BSL Training Course Overview This BSL training course, CPD certified workplace oriented classes, is an immersive 18-hour duration (3 hours per week) course designed to enhance your communication skills with deaf colleagues and customers in a specific workplace setting. This comprehensive program will equip you with the necessary tools to establish effective interactions and bridge the communication gap. Throughout the course, you will learn essential vocabulary, grammar, and conversational skills in British Sign Language (BSL). Additionally, you will gain insights into deaf culture and develop a deeper understanding of the challenges faced by individuals with hearing impairments in the workplace. By the end of this course, you will be able to confidently communicate using BSL and contribute to a more inclusive and accessible work environment. BSL Training for Workplace, Autumn 2025 Please book your place in advance Weekly via Zoom Online Live Class. You can attend the class online from home/workplace. Total Duration: 18 Hours Class Starts: August 08, 2025-October 10, 2025 Day & Time: 10:00 am – 12:00 pm (Thursday, 2 hours per week) Venue: Zoom Online Teacher: Adam Linsdell Who should take this course? BSL for the Workplace is perfect for individuals, employees, large or small businesses. Those who are seeking to improve their communication with deaf colleagues and customers in their professional environment can opt for this course. Whether you work in health and healthcare, retail and shopping, hospitality, cultural settings, or public services, this course will provide you with the skills needed to connect and engage with the deaf community. Learning Outcomes: Upon completing the BSL for the Workplace course, participants will achieve the following learning outcomes: Learn fingerspelling alphabets and words with accuracy Develop simple conversations and confidently ask questions on a range of everyday topics Fostering meaningful interactions with deaf colleagues and customers. Demonstrate basic vocabulary related to various topics, allowing for effective expression of ideas and needs. Discover workplace-specific vocabularies relevant to their professional setting Help you engage in specialised conversations and enhance workplace communication. Invest in your communication skills and create an inclusive workplace environment. Enrol in a BSL training course CPD certified workplace oriented classes today and unlock new opportunities for effective communication with the deaf community. Course Curriculum Greetings Learn essential BSL greetings to initiate conversations and create a welcoming atmosphere. These greetings include basic phrases such as “hello,” “good morning,” “how are you?” and more which are essential for establishing rapport and building relationships with deaf individuals. The BSL Alphabet and Fingerspelling Master the BSL alphabet and develop the ability to fingerspell words accurately, enabling effective communication of names, technical terms, and unfamiliar vocabulary. This skill is particularly useful in situations where there may be unfamiliar vocabulary or technical terms that need to be spelled out. Meeting People / Questions Enhance your conversational skills by learning how to introduce yourself, engage in small talk, and ask questions in BSL. These skills will allow you to confidently interact with Deaf individuals and create meaningful connections. Additionally, understanding how to ask questions in BSL will enable you to gather information and participate actively in conversations. Numbers and Number Related Vocabulary Acquire the knowledge to express age, money, and dates accurately in BSL, enabling seamless interactions in various contexts. Mastering numbers and number-related vocabulary in BSL will also help you navigate everyday situations such as shopping, making appointments, and discussing schedules. Being able to accurately express age, money, and dates will enhance your ability to communicate effectively and independently in the Deaf community. Transport / Travel Explore BSL vocabulary related to transportation and travel, enabling you to provide clear directions and discuss travel arrangements. You will learn signs for different modes of transportation such as cars, buses, trains, and aeroplanes, as well as how to ask for and give directions. Additionally, you will be able to discuss travel plans, including booking tickets and discussing itineraries. Telling the Time / Calendar Develop proficiency in expressing time and discussing calendar events in BSL, ensuring effective scheduling and time management. You will also become familiar with discussing different calendar events such as birthdays, holidays, and appointments. This will enable you to effectively manage your schedule and plan your activities accordingly. Weather Expand your vocabulary to discuss weather conditions, enabling you to engage in casual conversations and make relevant inquiries. This skill will also allow you to understand weather forecasts and prepare for any upcoming changes in the weather. Colours Learn the BSL signs for various colours, facilitating discussions about visual elements and enhancing your ability to describe objects accurately. This knowledge will enable you to express yourself more effectively and engage in a wider range of conversations. Describing People Develop the skills to describe individuals’ appearance and characteristics in BSL, allowing you to effectively communicate observations and share information. This skill will not only enhance your ability to interact with deaf individuals but also improve your overall communication skills. Additionally, being able to describe people accurately in BSL can help you navigate social situations and build stronger connections with others. Directions Master directional vocabulary in BSL, empowering you to provide clear instructions and navigate through spaces confidently. This skill will also boost your confidence when navigating unfamiliar spaces, as you will have the ability to clearly communicate directions and understand them yourself. Workplace-Specific Vocabulary Discover workplace-specific vocabulary tailored to your professional setting, such as health and healthcare, retail and shopping, hospitality, cultural settings, and public services. Use this vocabulary to develop simple conversations and strengthen your workplace communication skills. Recognised Accreditation This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Many organisations look for employees with CPD requirements, which means, that by doing this course, you would be a potential candidate in your respective field. Certificate of Achievement Certificate of Achievement from Lead Academy After successfully completing the live training, you will be eligible to receive your certificate of achievement as proof of your new skill. The certificate of achievement is an official credential that confirms that you successfully finished a course with Lead Academy. Certificate can be obtained in PDF version as well as hardcopy version at a free of cost.