3925 Courses in Cardiff delivered Live Online

Duration 1 Days 6 CPD hours This course is intended for This course is designed for existing Microsoft SharePoint site users who will create and manage SharePoint team or communication sites in SharePoint Online or SharePoint 2019. Overview In this course, you will create a SharePoint team site and a communication site, perform basic content management tasks on SharePoint sites, and configure workflows with Forms and Flow. You will: Create and configure new SharePoint sites. Create and configure document libraries. Create and configure lists. Assign permissions and access rights. Create and configure a communication site. Implement workflows with Forms and Flow. This course will empower you to use Microsoft© SharePoint© online to facilitate collaboration and allow you to use familiar applications and web-based tools to create, access, store, and track documents and data in a central location. Enable and configure SharePoint?s many distinct features and discover the many content structures that can be selected, added, and configured. Learn how to create, configure, and manage SharePoint sites so that your team or organization can share information and collaborate effectively.SharePoint content structures and configuration options are complex. As a site owner, it is critical that you understand what features, options, and content structures are available in SharePoint online, and how to properly configure them. With SharePoint sites, features, and content structures properly implemented, you will be able to securely share files, collaborate on documents, and access the information you need to work with your colleagues more effectively. Creating and Configuring a New Site Topic A: Create a Site in SharePoint Topic B: Configure Site Look and Layout Creating and Configuring Document Libraries Topic A: Create Document Libraries Topic B: Configure File Versioning and Checkout Topic C: Configure Content Approval Creating and Configuring Lists Topic A: Add List Apps to a Site Topic B: Create Custom Lists Topic C: Create Calculated and Validated Columns Assigning Permissions and Access Rights Topic A: Secure Sites with Permissions Topic B: Secure Apps, Documents, and Files Creating and Configuring a Communication Site Topic A: Create a Communication Site Topic B: Configure a Communication Site Implementing Workflows with Forms and Flow Topic A: Capture Data with Forms Topic B: Store Form Data in SharePoint with Flow Topic C: Automate Business Processes with Forms, Flow, and SharePoint

Duration 5 Days 30 CPD hours This course is intended for The primary audience for this course are Application Consultants, Business Analysts, Business Process Owners/Team Leads/Power Users, Program/Project Managers, Technology Consultants, and Users. In this course, students will gain SAP Netweaver Business Warehouse knowledge necessary for successful implementation and administration within a heterogeneous SAP NetWeaver BW system landscape. Data Warehousing Describing Data Warehouse Systems Describing Data Warehouse Architecture Using the Data Warehousing Workbench Master Data Modeling in SAP BW Describing InfoObjects Creating Characteristic InfoObjects The Loading of Master Data from SAP Data Sources Describing Data Flow Modeling a Master Data Flow Loading a Master Data Flow Modeling with the Graphical Data Flow Tool Loading of Transaction Data from SAP DataSources Describing the Core InfoProviders Creating a Key Figure InfoObject Creating a DataStore Object (DSO) Loading Transaction Data into a Data Store Object Describing the Extended Star Schema of an InfoCube Creating InfoCubes Loading Transaction Data into an InfoCube Master Data Loading from Flat File Data Sources Loading Data From a Flat File Describing the Data Flow in Detail Describing the Data Loading Process in Detail InfoProviders in SAP BW Explaining the InfoProviders Used in SAP BW ? Introduction Creating MultiProviders Usage of SAP BI Content Using BI Content Query Performance Optimization Optimizing Query Performance Monitoring Performance Creating and Filling Aggregates The SAP BW Administration Describing Administrative Tasks and Tools Administrating the InfoCubes Administrating the DataStore Objects Creating Process Chains

Most people only use a fraction of Excel's capabilities. This workshop shows what you've been missing! This course will help participants: Nest formulas Get the most from pivot tables Use conditional formatting Write array formulas Explore the lookup functions Calculate by criteria Use 'goal seek' and 'scenario manager' for what-if analysis Record macros 1 Nesting formulas Principles of nesting formulas together Using IF with AND or OR to answer questions Nesting an AND function in an IF Nesting an OR function in an IF 2 Advanced pivot table reports Grouping dates, numerical and text items Running percentage analyse Running analyses to compare data Inserting Field calculations Finishing off with a user-friendly dashboard 3 Advanced conditional formatting Colour table rows based on criteria in it Applying colour to approaching dates Exploring the different rule types 4 Lookup functions Going beyond the VLOOKUP function Lookups that retrieve data from left or right The versatile INDEX and MATCH functions Retrieving data from columns with duplicates 5 Calculate by criteria Using SUMIFS to sum by criteria Finding an average by criteria with AVERAGEIFS Use SUMPRODUCT to multiply then add different values 6 What-if analysis Use Goal Seek to meet targets Forecast reports with the Scenario Manager 7 Recording Macros Macro security Understanding a Relative References macro Recording, running and editing macros Saving files as Macro Enabled Workbooks Introduction to VBA code Making macros available across workbooks Add a macro button to the Quick Access toolbar

Duration 5 Days 30 CPD hours This course is intended for This course is intended for Database Administrators, Database Developers, BI professionals, and Business reporting users. Overview Upon successful completion of this course, students will be able to run Queries and retrieve results, perform conditional searches, and retrieve data from multiple tables. Before starting this course, make sure you meet at least one of the following prerequisites: Basic knowledge of the Microsoft Windows operating system and its core functionality. Basic working knowledge of Relational Databases. In this course, students will gain a good understanding of the Transact-SQL language. They will be able to create queries, sort, filter the data, execute procedures with T-SQL. Course Outline 1.Introduction to Microsoft SQL Server 2.Introduction to T-SQL Querying 3.Writing SELECT Queries 4.Querying Multiple Tables 5.Sorting and Filtering Data 6.Working with SQL Server Data Types 7.Using DML to Modify Data 8.Using Built-In Functions 9.Grouping and Aggregating Data 10.Using Subqueries 11.Using Table Expressions 12.Using Set Operators 13.Using Windows Ranking, Offset, and Aggregate Functions 14.Pivoting and Grouping Sets 15.Executing Stored Procedures 16.Programming with T-SQL

Duration 2 Days 12 CPD hours This course is intended for Authors Overview Please refer to course overview This course teaches experienced authors advanced report building techniques to enhance, customize, manage, and distribute reports. Additionally, the student will learn how to create highly interactive and engaging reports that can be run offline by creating Active Reports. Create query models Build a query and connect it to a report Answer a business question by referencing data in a separate query Create reports based on query relationships Create join relationships between queries Combine data containers based on relationships from different queries Create a report comparing the percentage of change Introduction to dimensional reporting concepts Examine data sources and model types Describe the dimensional approach to queries Apply report authoring styles Introduction to dimensional data in reports Use members to create reports Identify sets and tuples in reports Use query calculations and set definitions Dimensional report context Examine dimensional report members Examine dimensional report measures Use the default measure to create a summarized column in a report Focus your dimensional data Focus your report by excluding members of a defined set Compare the use of the filter() function to a detail filter Filter dimensional data using slicers Calculations and dimensional functions Examine dimensional functions Show totals and exclude members Create a percent of base calculation Create advanced dynamic reports Use query macros Control report output using a query macro Create a dynamic growth report Create a report that displays summary data before detailed data and uses singletons to summarize information Design effective prompts Create a prompt that allows users to select conditional formatting values Create a prompt that provides users a choice between different filters Create a prompt to let users choose a column sort order Create a prompt to let users select a display type Examine the report specification Examine report specification flow Identify considerations when modifying report specifications Customize reporting objects Distribute reports Burst a report to email recipients by using a data item Burst a list report to the IBM Cognos Analytics portal by using a burst table Burst a crosstab report to the IBM Cognos Analytics portal by using a burst table and a master detail relationship Enhance user interaction with HTML Create interactive reports using HTML Include additional information with tooltips Send emails using links in a report Introduction to IBM Cognos Active Reports Examine Active Report controls and variables Create a simple Active Report using Static and Data-driven controls Change filtering and selection behavior in a report Create interaction between multiple controls and variables Active Report charts and decks Create an Active Report with a Deck Create an Active Report with 11.0 visualizations

Duration 1 Days 6 CPD hours This course is intended for This introductory-level course is great for experienced technical professionals working in a wide range of industries, such as software development, data science, marketing and advertising, finance, healthcare, and more, who are looking to use the latest AI and machine learning techniques in their day to day. The hands-on labs in this course use Python, so you should have some familiarity with Python scripting basics. Overview Working in an interactive learning environment, led by our engaging OpenAI expert you'll: Understand the capabilities and products offered by OpenAI and how to access them through the OpenAI API. set up an OpenAI environment on Azure, including creating an Azure virtual machine and configuring the environment to connect to Azure resources. Gain hands-on experience building a GPT-3 based chatbot on Azure and implement advanced natural language processing capabilities. Use the OpenAI API to access GPT-3 and generate high-quality text Learn how to use Whisper to improve the quality of text generation. Understand the capabilities of DALL-E and use it to generate images for unique and engaging visuals. Geared for technical professionals, Quick Start to Azure AI Basics for Technical Users is a fun, fast paced course designed to quickly get you up to speed with OpenAI?s powerful tools and functionality, and to provide hands-on experience in setting up an OpenAI environment on Azure. Guided by our AI expert, you?ll explore the capabilities of OpenAI's GPT-3, Whisper and DALL-E, and build a chatbot on Azure. It will provide you with the knowledge and resources to continue your journey in AI and machine learning and have a good understanding of the potential of OpenAI and Azure for your projects. First, you?ll dive into the world of OpenAI, learning about its products and the capabilities they offer. You'll also discover how Azure's offerings for AI and machine learning can complement OpenAI's tools and resources, providing you with a powerful combination for your projects. And don't worry if you're new to Azure, we'll walk you through the process of setting up an account and creating a resource group. As you progress through the course, you'll get the chance to work with OpenAI's GPT-3, one of the most advanced large language models available today. You'll learn how to use the OpenAI API to access GPT-3 and discover how to use it to generate high-quality text quickly and easily. And that's not all, you'll also learn how to build a GPT-3 based chatbot on Azure, giving you the opportunity to implement advanced natural language processing capabilities in your chatbot projects. The course will also cover OpenAI Whisper, an OpenAI tool that can improve the quality of text generation, allowing you to create more coherent and natural language content. And you will learn about OpenAI DALL-E, an OpenAI tool that can generate images, giving you the ability to create unique and engaging visuals to enhance your content and projects. Introduction to OpenAI and Azure Explore OpenAI and its products, as well as Azure's offerings for AI and Machine Learning, allowing you to understand the tools and resources available to you for your AI projects. Explore OpenAI and its products Explore Azure and its offerings for AI and Machine Learning Get Hands-On: Setting up an OpenAI environment on Azure Walk through the process of setting up an OpenAI environment on Azure, giving you the hands-on experience needed to start building your own projects using OpenAI and Azure. Create an Azure virtual machine and installing the OpenAI SDK Configure the OpenAI environment and connecting to Azure resources Explore OpenAI GPT-3 Learn about GPT-3, one of OpenAI's most powerful language models, and how to use it to generate high quality text, giving you the ability to create natural language content quickly and easily. Review GPT-3 and its capabilities Use the OpenAI API to access GPT-3 Get Hands-on: Building a GPT-3 based chatbot on Azure Learn how to build a GPT-3 based chatbot on Azure, giving you the opportunity to learn how to implement advanced natural language processing capabilities in your chatbot projects. Setup an Azure Function and creating a chatbot Integrate GPT-3 with the chatbot OpenAI Whisper Explore Whisper, an OpenAI tool that can improve the quality of text generation, allowing you to create more coherent and natural language content. Explore Whisper and its capabilities Use Whisper to improve the quality of text generation OpenAI DALL-E Explore DALL-E, an OpenAI tool that can generate images, giving you the ability to create unique and engaging visuals to enhance your content and projects. Explore DALL-E and its capabilities Use the OpenAI API to access DALL-E What?s Next: Keep Going! Other ways OpenAI can impact your day to day Explore great places to check for expanded tools and add-ons for Azure OpenAI Where to go for help and support Quick Look at Generative AI and its Business Implications Understanding Generative AI Generative AI in Business Ethical considerations of Generative AI

Duration 3 Days 18 CPD hours This course is intended for This advanced course is for Infrastructure Specialist, Senior Technical Specialist,Technical Specialist, Support Engineers, and System Architects. Overview Understand the MDM Architecture and how the Physical, Virtual and Hybrid MDM handles a service request Understand the core Workbench features available for the InfoSphere MDM Understand how MDM using OSGi for deploying customizations to the product Create a new Physical MDM Entity using the Workbench Wizard Extend an existing Physical MDM Entity using the Workbench Wizard Extend an existing Physical MDM Service using the Workbench Wizard Create a new Composite Service using a transiant object containing other existing business objects Customize and deploy a Virtual configuration Create a new Virtual Callout Handler Create a new Virtual Composite View Generate new Services based on the Virtual configuration (eSOA) Customize a Hybrid MDM implementation Understand the Adaptive Service Interface (ASI) This course is designed for anyone who wants to get an understanding of how to use and customize the InfoSphere Master Data Management using the InfoSphere MDM Workbench InfoSphere MDM Architecture . OSGi and MDM . Data Additions . Physical Data Extensions . MDM Physical Behavior Extensions . Composite Services . Adaptive Services Interface (ASI) . Virtual Data Model . Virtual Handlers . eSOA Toolkit . Hybrid MDM .

Person-centred approaches are a core skills framework that articulates what it means to be person-centred and how to develop and support the workforce to work in this way. Developed in partnership with Skills for Health and Skills for Care, the Framework aims to distil best practices and to set out core, transferable behaviours, knowledge and skills. It is applicable across services and sectors and across different types of organisations. Person-centred approaches underpins existing dementia, learning disabilities, mental health and end of life care core skills frameworks. This subject forms standard 5 in The Care Certificate.

The main subject areas of the course are: Good practice in asbestos removal or remediation Asbestos Removal Control Plans Air sampling for asbestos Enclosures, clearance air monitoring and reporting

Duration 1 Days 6 CPD hours This course is intended for The primary audience for this course is database developers who plan to migrate their MySQL or Postgres DB workloads to Azure SQL DB. The secondary audience for this course is MySQL/Postgres administrators to raise awareness of the features and benefits of Azure SQL DB. Overview At the end of this course, the students will have learned: Migrate on-premises MySQL to Azure SQL DB for MySQL Migrate on-premises PostgreSQL to Azure SQL DB for PostgreSQL This course will enable the students to understand Azure SQL Database, and educate the students on what is required to migrate MySQL and PostgreSQL workloads to Azure SQL Database. Migrate to Azure SQL DB for MySQL & PostgreSQL OSS databases overview Common OSS database workloads Customer challenges in migration Migrate on-premises MySQL to Azure SQL DB for MySQL Configure and Manage Azure SQL DB for MySQL Migrate on-premises MySQL to SQL DB for MySQL Application Migration Post-migration considerations Migrate on-premises PostgreSQL to Azure SQL DB for PostgreSQL Configure and Manage Azure SQL DB for PostgreSQL Migrate on-premises MySQL to SQL DB for PostgreSQL Application Migration Post-migration considerations