1227 Model courses in Cardiff delivered Live Online

Duration 2 Days 12 CPD hours This course is intended for Administrators Overview Please refer to course overview This offering covers the fundamental concepts of installing and configuring IBM Cognos Analytics, and administering servers and content, in a distributed environment. In the course, participants will identify requirements for the installation and configuration of a distributed IBM Cognos Analytics software environment, implement security in the environment, and manage the server components. Students will also monitor and schedule tasks, create data sources, and manage and deploy content in the portal and IBM Cognos Administration. Introduction to IBM Cognos Analytics administration IBM Cognos Analytics components Administration workflow IBM Cognos Administration IBM Cognos Configuration Identify IBM Cognos Analytics architecture Features of the IBM Cognos Analytics architecture Examine the multi-tiered architecture, and identify logging types and files Examine IBM Cognos Analytics servlets Performance and installation planning Balance the request load Configure IBM Cognos Analytics Secure the IBM Cognos Analytics environment Identify the IBM Cognos Analytics security model Define authentication in IBM Cognos Analytics Define authorization in IBM Cognos Analytics Identify security policies Secure the IBM Cognos Analytics environment Administer the IBM Cognos Analytics server environment Administer IBM Cognos Analytics servers Monitor system performance Manage dispatchers and services Tune system performance, and troubleshoot the server Audit logging Dynamic cube data source administration workflow Manage run activities View current, past, and upcoming activities Manage schedules Manage content in IBM Cognos Administration Data sources and packages Manage visualizations in the library Deployment Other content management tasks Examine departmental administration capabilities Create and manage team members Manage activities Create and manage content and data Manage system settings Manage Themes, Extensions, and Views Share services with multiple tenants

Overview This is particularly important for PPP projects where long-term commitments are made now based on bankability, value for money and risk allocation. During the course, participants will gain knowledge and skills on the frameworks, tools, and methodologies necessary to build quantitative models for financial decision-making in order to improve the financial viability and bankability of PPP projects. Participants will master modelling frameworks on capital budgeting, risk measurement, regression analysis and Monte Carlo Simulation among others.

This programme has been specifically designed to help experienced trainers, facilitators and coaches use Everything DiSC and the Five Behaviours assessments, and deliver workshops, with their own clients and in-house teams.

Overview The development of effective and realistic business/financial models is a critical tool in today's value-driven organization. As shareholders are increasingly concerned with the value of their investments, organizations are continually driven to ensure the optimum use of resources. Using Excel®, the Business & Financial Modelling process provides an effective tool with which the potential outcomes of various strategic and tactical initiatives can be projected. This comprehensive five-day programme takes you through the modelling process from start to finish. It provides practical examples and applications of modelling for both strategic and tactical executives.

Learn how to work with and connect multiple data sets to effectively analyse and report on data. Course overview Duration: 1 day (6.5 hours) Within Excel you have some powerful features to enable you to connect and analyse multiple data sources. Power Query enables you to import and manipulate your data, Power Pivot enables you to connect multiple data sources and create pivot tables and pivot charts from them. This course is an introduction to Power Query and Power Pivot in Excel to get you started on creating a powerful reporting capability. Knowledge of working with Excel workbooks and relational databases would be an advantage. Objectives By the end of the course you will be able to: Import data from multiple data sources Edit and transform data before importing Add extra columns of data Append data Merge data from other tables Create data models Build data relationships Build Pivot Tables Build Pivot Charts Use Slicers and Timeline Filters Content Importing data Data sources Importing data Transforming data Editing your data Setting data types Removing columns/rows Choosing columns to keep Setting header rows Splitting columns Appending queries Appending data from other tables Adding text Columns from example Custom columns Conditional columns Merge queries Setting up and using merge queries Merging in columns of data Creating a data model The data model Multiple data tables Connecting tables Building relationships Relationship types Building visuals from multiple tables Analysing information using pivot tables Creating and modifying a Pivot Table Recalculating the Pivot Table Filtering the Pivot Table Searching the Pivot Table Drilling down to underlying data Customising field names Changing field formatting Pivot charts, slices and timelines Creating Pivot Charts Adding and using Slicers

Duration 1 Days 6 CPD hours This course is intended for This class is designed for administrators preparing to take the Salesforce Marketing Cloud Administrator exam who are able to configure Marketing Cloud products using industry and product best practices. You should be generally familiar with data structure in subscriber data management. You should also be able to thoroughly navigate Setup, troubleshoot account configuration, and manage user requests. Overview When you complete this course, you will be able to: Recall exam objectives. Discuss product features and functionality covered on the exam. Assess your exam readiness by answering practice questions. Familiarize yourself with additional resources necessary to prepare for the exam. Take the next step in your career and become a Salesforce Certified Marketing Cloud Administrator. In this 1-day, expert-led certification prep class, boost your exam readiness with a detailed exam overview, exam resources, and practice exam questions to test your knowledge. This course includes a voucher to sit for the Salesforce Marketing Cloud Administrator exam. Course Outline Exam Overview Digital Marketing Proficiency Review Governance and Compliance in Relation to Digital Marketing Review Security Best Practices for Date, Permissions, and PII Review Marketing Cloud Product Inventory and Offerings Subscriber Data Management Review the Contact Model Review Data Quality Evaluation Review Preference and Profile Center Setup Review Business Units, Users, and Security Configuration Review Integrations Configuration Review Features in Setup Home Review Marketing Cloud Extension Products Channel Management Review Mobile Studio Configuration Review Email Studio Configuration Review Social Studio and Advertising Configuration Review Journey Builder Concepts and Use Cases Maintenance Review Data Extraction and Report Generation Solutions Review Monitoring and System Availability Review Additional Marketing Cloud Product Benefits Practice Exam and Wrap-up Complete a Practice Exam Review Next Steps

SAP Training: Overview What is SAP? SAP is one of the largest ERP(Enterprise Resource Planning) software in the world. It provides end to end solution for Financials, Manufacturing, Logistics, Distributions etc. SAP applications, built around their latest R/3 system, provide the capability to manage financial, asset, and cost accounting, production operations and materials, personnel, plants, and archived documents. The R/3 system runs on a number of platforms including Windows and MAC and uses the client/server model. SAP Business Cases/ Live Project Our SAP training courses are designed in a way which gives the students maximum exposure of real-life scenario through no of business cases and guidance on implementation by professional SAP Consultants. You receive a certificate once you finish the course from Osborne Training. SAP Certification During the training, you get access to Sap sandbox which continues even after training finishes until the completion of the Internship. You can also do an external exam to receive certification from SAP (Optional), for details on exam booking you may visit the SAP website. SAP Training Modules Available Financial & Controlling (FICO) High-Performance Analytic Appliance (HANA) Supply Relationship Management (SRM) Customer Relationship Management (CRM)

Duration 3 Days 18 CPD hours This course is intended for This is an introductory level SQL course, appropriate for anyone needing to interface with an Oracle database or those needing a general understanding of Oracle database functionality. That would include end users, business analysts, application developers and database administrators. Overview Working in a hands on learning environment led by our expert practitioner, attendees will explore: Basic RDBMS Principles The SQL Language and Tools Using SQL Developer SQL Query Basics WHERE and ORDER BY Functions ANSI 92 Joins ANSI 99 Joins Subqueries Regular Expressions Analytics 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. A full presentation of the basics of relational databases and their use are also covered. Basic RDBMS Principles Relational design principles Accessing data through a structured query language Entity relationship diagrams Data Domains Null values Indexes Views Denormalization Data Model Review The SQL Language and Tools Using SQL*Plus Why Use SQL*Plus When Other Tools Are Available? Starting SQL*Plus EZConnect SQL Commands PL/SQL Commands SQL*Plus Commands The COLUMN Command The HEADING Clause The FORMAT Clause The NOPRINT Clause The NULL Clause The CLEAR Clause Predefined define variables LOGIN.SQL Command history Copy and paste in SQL*Plus Entering SQL commands Entering PL/SQL commands Entering SQL*Plus commands Default output from SQL*Plus Entering Queries What about PL/SQL? Using SQL Developer Choosing a SQL Developer version Configuring connections Creating A Basic Connection Creating A TNS Connection Connecting Configuring preferences Using SQL Developer The Columns Tab The Data Tab The Constraints Tab The Grants Tab The Statistics Tab Other Tabs Queries In SQL Developer Query Builder Accessing Objects Owned By Other Users The Actions Pulldown Menu Differences between SQL Developer and SQL*Plus Reporting Commands Missing In SQL Developer General Commands Missing In SQL Developer Data Dictionary report User Defined reports Using scripts in SQL Developer WHERE and ORDER BY WHERE clause basics Comparison operators Literals and Constants in SQL Simple pattern matching Logical operations The DUAL table Arithmetic operations Expressions in SQL Character operators Pseudo columns Order by clause basics Ordering Nulls Accent and case sensitive sorts Sampling data WHERE and ORDER BY in SQL Developer All, Any, Some Functions The basics of Oracle functions Number functions Character functions Date functions Conversion functions Other functions Large object functions Error functions The RR format mode; Leveraging your knowledge ANSI 92 JOINS Basics of ANSI 92 Joins Using Query Builder with multiple tables Table Aliases Outer joins Outer Joins In Query Builder Set operators Self-referential joins Non-Equijoins ANSI 99 Joins Changes with ANSI99 CROSS Join NATURAL Join JOIN USING JOIN ON LEFT / RIGHT OUTER JOIN FULL OUTER JOIN Subqueries Why use subqueries? WHERE clause subqueries FROM clause subqueries HAVING clause subqueries CORRELATED subqueries SCALAR subqueries DML and subqueries EXISTS subqueries Hierarchical queries TOP N AND BOTTOM N queries Creating subqueries using Query Builder Regular Expressions Available Regular Expressions Regular Expression Operators Character Classes Pattern matching options REGEX_LIKE REGEXP_SUBSTR REGEXP_INSTR REGEXP_REPLACE REGEXP_COUNT Analytics The WITH clause Reporting aggregate functions Analytical functions User-Defined bucket histograms The MODEL clause PIVOT and UNPIVOT Temporal validity More Analytics RANKING functions RANK DENSE_RANK CUME_DIST PERCENT_RANK ROW_NUMBER Windowing aggregate functions RATIO_TO_REPORT LAG / LEAD Linear Regression functions Inverse Percentile functions Hypothetical ranking functions Pattern Matching Additional course details: Nexus Humans Introduction to SQL Programming Basics (TTSQL002) 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 Introduction to SQL Programming Basics (TTSQL002) 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 3 Days 18 CPD hours This course is intended for The course will likely be attended by SQL Server report creators who are interested in alternative methods of presenting data. Overview After completing this course, students will be able to: ? Perform Power BI desktop data transformation. ? Describe Power BI desktop modelling. ? Create a Power BI desktop visualization. ? Implement the Power BI service. ? Describe how to connect to Excel data. ? Describe how to collaborate with Power BI data. ? Connect directly to data stores. ? Describe the Power BI developer API. ? Describe the Power BI mobile app. The main purpose of the course is to give students a good understanding of data analysis with Power BI. The course includes creating visualizations, the Power BI Service, and the Power BI Mobile App. Introduction to Self-Service BI Solutions Introduction to business intelligence Introduction to data analysis Introduction to data visualization Overview of self-service BI Considerations for self-service BI Microsoft tools for self-service BI Lab : Exploring an Enterprise BI solution Introducing Power BI Power BI The Power BI service Lab : Creating a Power BI dashboard Power BI Using Excel as a data source for Power BI The Power BI data model Using databases as a data source for Power BI The Power BI service Lab : Importing data into Power BI Shaping and Combining Data Power BI desktop queries Shaping data Combining data Lab : Shaping and combining data Modelling data Relationships DAX queries Calculations and measures Lab : Modelling Data Interactive Data Visualizations Creating Power BI reports Managing a Power BI solution Lab : Creating a Power BI report Direct Connectivity Cloud data Connecting to analysis services Lab : Direct Connectivity Developer API The developer API Custom visuals Lab : Using the developer API Power BI mobile app The Power BI mobile app Using the Power BI mobile app Power BI embedded

– the practical steps you need to know This live online suicide intervention training covers a wealth of essential information and strategies to help you help anyone you suspect may be thinking about or planning suicide, or who has survived a previous attempt… Accredited CPD Certificate: 6 hours Length: 1 day (9.15am - 4.00pm GMT) You never know when you may need these skills… Brilliant! I’ve been on previous suicide intervention courses over the years, but this is by far the best – great pace, very knowledgeable trainer...who brings real experience into the learning...SUE HASWELL Join Malcolm Hanson LIVE ONLINE on Tuesday 12th March for his essential suicide intervention training, delivered via Zoom. Book your place and we’ll send you the Zoom link the day before the event. BONUS Recording – the training is recorded, in case anyone experiences technical difficulties, so you also get a recording for a limited time afterwards to maximise your learning. Why take this suicide prevention course Suicide can be a difficult subject to broach and a daunting one to deal with – anyone working with distressed or depressed people wants to keep them safe, to give them the hope they need that circumstances can change for the better, and to provide the skills for coping until that comes about. When people can’t envisage an end to their difficulties, particularly in highly challenging times, a slump into depression can all too quickly spiral down into suicidal thoughts, plans and suicide attempts. The negative trance state of depression itself can beguile people into thinking that there is no other way out of their hopelessness. Thankfully, there is much we can do to help – as this indepth suicide intervention course shows. Tutor Malcolm Hanson has a wealth of experience at helping seriously distressed people get through difficulties which he draws upon as he takes you clearly through the steps to take when faced with anyone who feels suicidal. (He worked for 9 years as a psychotherapist in NHS primary care in an area of extreme deprivation, and for many more years since has seen patients referred by GPs, social workers, psychiatrists, police and probation officers for complex issues.) He has successfully helped clients experiencing multiple trauma (including veterans), chronic pain and terminal illness, clients struggling with uncertain asylum status or facing deportation, and also victims of human trafficking – a tragic range of circumstances in which even the most resilient may sometimes sink into despair. His compassion and understanding shine through this course as he shares with you what he has learnt, along with the latest psychiatric research and risk assessment strategies, to give you the knowledge and assurance you need to work confidently and respectfully with clients struggling to find reasons to stay alive. You will learn how to build in expectation of positive change from the start, have plenty of time to benefit from group discussions and will work through case scenarios with other attendees to help embed your learning. Suicide affects countless people, not only those directly involved, and is now the most common cause of death in men aged 17 to 34. The highest suicide rate is in men aged 45–49; in women, it is highest in those aged between 50–54.1 Join us for this practical online suicide prevention training to learn how you can help reverse this state of affairs… Book your place So much helpful and insightful information delivered in a way that was easy to listen to and take on board...STEVEN TESSEYMAN What will you learn Deeper insight into when and why different people consider suicide Crucial elements needed to build rapport with suicidal people Why most suicidal crises are surprisingly temporary How to normalise circumstances safely A model for running therapeutic sessions that best manages suicide risk Ways to use your own demeanour to instil confidence in the person who is feeling suicidal Effective information gathering to challenge unhelpful beliefs What to look for in their answers to your questions How to broach the subject of suicidal thoughts A structure for difficult conversations The ability to reframe unhelpful beliefs Methods of risk assessment that do not risk losing rapport Advances in psychiatric research on suicide risk management and the implications of this for psychotherapy and counselling How to use language of influence Effective means to address beliefs about being a burden How to set realistic and empowering goals How to make best use of the client’s own resources The importance of addressing emotional needs How to create a safety plan Strategies for client safe self-management between sessions The power of guided imagery for working with suicidal clients Powerful insights and hope from real case histories How to take care of yourself – and more… Malcolm is a wonderful communicator: so clear, measured and thoughtful ... it was a pleasure and privilege to learn from himMATTHEW HOPKINS Course Programme The ‘How To Reduce Suicide Risk’ live online course starts at 9.15am and runs until 4.00pm. 9.15am Join the Zoom meeting 9.30am The important first steps for suicide risk management 11.00am Comfort break and discussion 11.30am Working with what the client brings 1.00pm Lunch break 1.45pm Rehearsing the safety plan 2.45pm Comfort break and discussion 3.00pm Putting what you have learned into practice 4.00pm Day ends Who is this suicide awareness and prevention course for? Psychotherapists and counsellors All mental health and welfare professionals – including GPs, social workers, the emergency services, pastoral care and outreach workers – and anyone else working with people with suicidal ideation Anyone concerned for personal or HR reasons – the training contains a lot of key, helpful information which is presented in a clear, easy to understand way, even though it is primarily geared towards carrying out therapy effectively with suicidal clients Anyone working with young people, such as teachers and youth workers, will benefit from this live online suicide intervention course Anyone who may come into contact with people who are very distressed, whether through their paid or volunteer work, will also learn essential live-saving information. Please Note This course is not a substitute for therapy. Reference 1. www.ons.gov.uk/peoplepopulationandcommunity/birthsdeathsandmarriages/deaths/bulletins/suicidesintheunitedkingdom/2019registrations The one certainty in life is that circumstances ALWAYS change... This online suicide awareness and prevention course has been independently accredited by the internationally recognised CPD Standards Office for 6 hours of CPD training. On completion of this training you’ll receive CPD certificates from the College and the CPD Standards Office.