1715 Office courses in Cardiff delivered Live Online

Microsoft Project Blue Belt® 2016: In-House Training This course introduces Project Server 2016 features that expedite scheduling projects and simplify managing tasks within an enterprise environment. Learn different aspects of Project Server and their benefits to varying roles in the enterprise, and gain hands-on experience and insights on best practices from SMEs around the world. This course introduces Project Server 2016 features that expedite scheduling projects and simplify managing tasks within an enterprise environment. Learn different aspects of Project Server and their benefits to varying roles in the enterprise, and gain hands-on experience and insights on best practices from SMEs around the world. Users in Project online will get the same benefits of this program. What you Will Learn You'll learn how to: Describe the Enterprise Project Management (EPM) environment Apply the basic project management principles of, initiating, planning, executing, monitoring and controlling, and closing your project schedules Discuss new features Explain PWA views project sites Meet deadlines and budget restrictions Keep the workloads of your resources within their available limits Explain tracking methods and manage task assignments Update the schedule Differentiate between updating tasks and timesheets Use standard reports, custom views, and visual reports for your projects Recognize the potential of the Business Intelligence features Getting Started with Microsoft® Project Server 2016 Describing the EPM context Discovering Project Web App Differentiating the users of PWA Working with Project Professional and PWA Initiating Projects New projects with Project Professional, SharePoint lists, Enterprise Projects Importing schedules and managing project owner and permissions Customize the ribbon with enterprise commands Planning Projects - Scope and Schedule Management Scheduling in PWA Using the Deliverables feature Developing components of the risk management plan and issues tracking Linking planning documents Planning Projects - Staffing Management Plan Building a project team Managing resource availability Reviewing the assignment cycle Managing resource engagements Resolving resource overallocation Executing, Monitoring and Controlling Baselines Working with timesheets Reporting administrative time Tracking methods (% work, actual work, single entry mode) Assignment progress and updates in PWA Task progress and updates in Project Professional and PWA Monitor and Control Projects - Measuring Performance and Reporting Progress Reviewing performance metrics and progress reports Using the preloaded reports at the Business Intelligence Center Considerations for defining custom reports Closing Projects Reviewing the closing processes and closing tasks to updates Supporting the closing process

Performance and efficiency-enhancing Excel skills for everyday users.

Learn Excel tricks of the trade and some quick easy wins, to make time spent on spreadsheets efficient, effective and painless!

Duration 2 Days 12 CPD hours This course is intended for This course can be valuable for anyone who needs to write basic SQL or Transact-SQL queries. This includes anyone working with data as a data analyst, a data engineer, a data scientist, a database administrator or a database developer. It can also be useful for others peripherally involved with data, or wanting to learn more about working with data such as solution architects, students and technology managers. This course will teach the basics of Microsoft's dialect of the standard SQL language: Transact-SQL. Topics include both querying and modifying data in relational databases that are hosted in Microsoft SQL Server-based database systems, including: Microsoft SQL Server, Azure SQL Database and, Azure Synapse Analytics. 1 - Introduction to Transact-SQL Work with schemas Explore the structure of SQL statements Examine the SELECT statement Work with data types Handle NULLs 2 - Sort and filter results in T-SQL Sort your results Limit the sorted results Page results Remove duplicates Filter data with predicates 3 - Combine multiple tables with JOINs in T-SQL Understand joins concepts and syntax Use inner joins Use outer joins Use cross joins Use self joins 4 - Write Subqueries in T-SQL Understand subqueries Use scalar or multi-valued subqueries Use self-contained or correlated subqueries 5 - Use built-in functions and GROUP BY in Transact-SQL Categorize built-in functions Use scalar functions Use ranking and rowset functions Use aggregate functions Summarize data with GROUP BY Filter groups with HAVING 6 - Modify data with T-SQL Insert data Generate automatic values Update data Delete data Merge data based on multiple tables Additional course details: Nexus Humans DP-080T00 Querying Data with Microsoft Transact-SQL 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 DP-080T00 Querying Data with Microsoft Transact-SQL 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.

Business Intelligence: In-House Training Business Intelligence (BI) refers to a set of technology-based techniques, applications, and practices used to aggregate, analyze, and present business data. BI practices provide historical and current views of vast amounts of data and generate predictions for business operations. The purpose of Business Intelligence is the support of better business decision making. This course provides an overview of the technology and application of BI and how it can be used to improve corporate performance. What you will Learn You will learn how to: Specify a data warehouse schema Identify the data and visualization to be used for data mining and Business Intelligence Design a Business Intelligence user interface Getting Started Introductions Agenda Expectations Foundation Concepts The challenge of decision making What is Business Intelligence? The Business Intelligence value proposition Business Intelligence taxonomy Business Intelligence management issues Sources of Business Intelligence Data warehousing Data and information Information architecture Defining the data warehouse and its relationships Facts and dimensions Modeling, meta-modeling, and schemas Alternate architectures Building the data warehouse Extracting Transforming Loading Setting up the data and relationships Dimensions and the Fact Table Implementing many-to-many relationships in data warehouse Data marts Online Analytical Processing (OLAP) What is OLAP? OLAP and OLTP OLAP functionality Multi-dimensions Thinking in more than two dimensions What are the possibilities? OLAP architecture Cubism Tools OLAP variations - MOLAP, ROLAP, HOLAP BI using SOA Applications of Business Intelligence Applying BI through OLAP Enterprise Resource Planning and CRM Business Intelligence and financial information Business Intelligence User Interfaces and Presentations Data access Push-pull data access Types of decision support systems Designing the front end Presentation formats Dashboards Types of dashboards Common dashboard features Briefing books and scorecards Querying and Reporting Reporting emphasis Retrofitting Talking back Key Performance Indicators Report Definition and Visualization Typical reporting environment Forms of visualization Unconstrained views Data mining What is in the mine? Applications for data mining Data mining architecture Cross Industry Standard Process for Data Mining (CISP-DM) Data mining techniques Validation The Business Intelligence User Experience The business analyst role Business analysis and data analysis Five-step approach Cultural impact Identifying questions Gathering information Understand the goals The strategic Business Intelligence cycle Focus of Business Intelligence Design for the user Iterate the access Iterative solution development process Review and validation questions Basic approaches Building ad-hoc queries Building on-demand self-service reports Closed loop Business Intelligence Coming attractions - future of Business Intelligence Best practices in Business Intelligence

Duration 4 Days 24 CPD hours This course is intended for Software engineers concerned with building, managing and deploying AI solutions that leverage Azure AI Services, Azure AI Search, and Azure OpenAI. They are familiar with C# or Python and have knowledge on using REST-based APIs to build computer vision, language analysis, knowledge mining, intelligent search, and generative AI solutions on Azure. AI-102 Designing and Implementing an Azure AI Solution is intended for software developers wanting to build AI infused applications that leverage?Azure AI Services,?Azure AI Search, and?Azure OpenAI. The course will use C# or Python as the programming language. Prerequisites Before attending this course, students must have: Knowledge of Microsoft Azure and ability to navigate the Azure portal Knowledge of either C# or Python Familiarity with JSON and REST programming semantics Recommended course prerequisites AI-900T00: Microsoft Azure AI Fundamentals course 1 - Prepare to develop AI solutions on Azure Define artificial intelligence Understand AI-related terms Understand considerations for AI Engineers Understand considerations for responsible AI Understand capabilities of Azure Machine Learning Understand capabilities of Azure AI Services Understand capabilities of the Azure Bot Service Understand capabilities of Azure Cognitive Search 2 - Create and consume Azure AI services Provision an Azure AI services resource Identify endpoints and keys Use a REST API Use an SDK 3 - Secure Azure AI services Consider authentication Implement network security 4 - Monitor Azure AI services Monitor cost Create alerts View metrics Manage diagnostic logging 5 - Deploy Azure AI services in containers Understand containers Use Azure AI services containers 6 - Analyze images Provision an Azure AI Vision resource Analyze an image Generate a smart-cropped thumbnail 7 - Classify images Provision Azure resources for Azure AI Custom Vision Understand image classification Train an image classifier 8 - Detect, analyze, and recognize faces Identify options for face detection analysis and identification Understand considerations for face analysis Detect faces with the Azure AI Vision service Understand capabilities of the face service Compare and match detected faces Implement facial recognition 9 - Read Text in images and documents with the Azure AI Vision Service Explore Azure AI Vision options for reading text Use the Read API 10 - Analyze video Understand Azure Video Indexer capabilities Extract custom insights Use Video Analyzer widgets and APIs 11 - Analyze text with Azure AI Language Provision an Azure AI Language resource Detect language Extract key phrases Analyze sentiment Extract entities Extract linked entities 12 - Build a question answering solution Understand question answering Compare question answering to Azure AI Language understanding Create a knowledge base Implement multi-turn conversation Test and publish a knowledge base Use a knowledge base Improve question answering performance 13 - Build a conversational language understanding model Understand prebuilt capabilities of the Azure AI Language service Understand resources for building a conversational language understanding model Define intents, utterances, and entities Use patterns to differentiate similar utterances Use pre-built entity components Train, test, publish, and review a conversational language understanding model 14 - Create a custom text classification solution Understand types of classification projects Understand how to build text classification projects 15 - Create a custom named entity extraction solution Understand custom named entity recognition Label your data Train and evaluate your model 16 - Translate text with Azure AI Translator service Provision an Azure AI Translator resource Specify translation options Define custom translations 17 - Create speech-enabled apps with Azure AI services Provision an Azure resource for speech Use the Azure AI Speech to Text API Use the text to speech API Configure audio format and voices Use Speech Synthesis Markup Language 18 - Translate speech with the Azure AI Speech service Provision an Azure resource for speech translation Translate speech to text Synthesize translations 19 - Create an Azure AI Search solution Manage capacity Understand search components Understand the indexing process Search an index Apply filtering and sorting Enhance the index 20 - Create a custom skill for Azure AI Search Create a custom skill Add a custom skill to a skillset 21 - Create a knowledge store with Azure AI Search Define projections Define a knowledge store 22 - Plan an Azure AI Document Intelligence solution Understand AI Document Intelligence Plan Azure AI Document Intelligence resources Choose a model type 23 - Use prebuilt Azure AI Document Intelligence models Understand prebuilt models Use the General Document, Read, and Layout models Use financial, ID, and tax models 24 - Extract data from forms with Azure Document Intelligence What is Azure Document Intelligence? Get started with Azure Document Intelligence Train custom models Use Azure Document Intelligence models Use the Azure Document Intelligence Studio 25 - Get started with Azure OpenAI Service Access Azure OpenAI Service Use Azure OpenAI Studio Explore types of generative AI models Deploy generative AI models Use prompts to get completions from models Test models in Azure OpenAI Studio's playgrounds 26 - Build natural language solutions with Azure OpenAI Service Integrate Azure OpenAI into your app Use Azure OpenAI REST API Use Azure OpenAI SDK 27 - Apply prompt engineering with Azure OpenAI Service Understand prompt engineering Write more effective prompts Provide context to improve accuracy 28 - Generate code with Azure OpenAI Service Construct code from natural language Complete code and assist the development process Fix bugs and improve your code 29 - Generate images with Azure OpenAI Service What is DALL-E? Explore DALL-E in Azure OpenAI Studio Use the Azure OpenAI REST API to consume DALL-E models 30 - Use your own data with Azure OpenAI Service Understand how to use your own data Add your own data source Chat with your model using your own data 31 - Fundamentals of Responsible Generative AI Plan a responsible generative AI solution Identify potential harms Measure potential harms Mitigate potential harms Operate a responsible generative AI solution

An in depth look at Pivot Tables and their powerful features to summarise and visualize your data. Course overview Duration: 1 day (6.5 hours) Our Excel – Pivot Table Specialist course is a comprehensive guide to working with Pivot Tables for those who need to learn more about the use of Pivot Tables to summarise and analyse information. This course is designed for existing experienced users of Excel. You should be a confident Excel user and be able to create and edit worksheets and write basic formulas. Objectives By the end of the course you will be able to: Build and customise Pivot Tables Group and sort information Filter information Use slicers and the timeline filter Add different summary calculations Create Pivot Charts Add calculated fields and items Content The anatomy of a Pivot Table Using a Pivot Cache Building a Pivot Table The Pivot Table interface Refreshing the Pivot Table Adding column, row, page and data fields Changing data orientation Showing data fields in columns or rows Drilling down to underlying data Setting Pivot Table options Format options Totals and filters options Display and printing options Data options Customising Pivot Tables Modifying field names Data formatting Changing field layout options Changing summary calculations Working with subtotals Filtering and sorting Filtering items Sorting data Value and label filters Creating top 10 reports Using the Search filter Using the Slicer tool Use the Timeline filter Grouping Grouping date fields Grouping numeric fields Adding your own groups Summary calculations Running totals Differences year on year, month on month % Differences year on year, month on month % of Row, Column, Total and other fields Pivot charts Pivot Chart rules Creating a Pivot Chart Working with your Pivot Chart Creating calculations Adding calculated fields Adding calculated items

Learn how to use Macros in Excel to automate your work and start to see the power these can give you. Course overview Duration: 1 day (6.5 hours) Our Excel – Working with Macros course aims to show how macros can be used to automate commonly used commands and processes. This course is designed for existing experienced users of Excel. You should be confident creating and manipulating Excel spreadsheets and creating formulas before attending this course. Objectives By the end of the course you will be able to: Record and run macros Navigate within the Visual Basic Environment Edit pre-recorded macros Create your own functions Content Recording macros Accessing the Developer Tab Naming conventions and storage locations Recording macros Absolute and relative cell addressing Running macros Assigning macros to the Quick Access Toolbar Assigning macros to objects Creating new tabs Workbook macros Recording macros in a specific workbook Saving the workbook as an Excel Macro-Enabled Workbook Creating quick access items specific to workbooks Importing and manipulating data Importing Delimited Text Files Importing Fixed Width Text Files The Visual Basic environment Project explorer Code window Properties window Renaming modules Deleting modules Working with code Code structure Adding comments Navigating within your code Editing macro code Getting help with syntax Debugging Errors Using debug Function procedures Creating function macros

The course will be delivered through 9 online virtual classroom sessions. The 10th and last session will involve the additional practical work for the course as well as the written examination (multiple choice for City & Guilds and written for Hi-Tech Training) which will take place at our training centre at 43 North Great Georges Street, Dublin 1 (completed online for non ROI learners). During the virtual classroom sessions, trainees will have a live video feed with their instructor talking to them, doing practical live demonstrations on equipment being involved actively in the learning. We will send out a practical kit so that trainees can complete assignments and practical work at home. The kit is the property of Hi-Tech Training and will be returned to Hi-Tech Training on the last day of the course. (The kits may also be purchased by the learner….see the Kits Page Link for more details). The kit consists of power supply unit breadboard, multimeter, cables, The kit consists of breadboard, multimeter, oscilloscope, battery and connectors, components including resistors, LEDs and ICs (AND, NAND, OR, NOR, X-OR, X-NOR, Inverter, Buffer, Latches, Flip-Flops, Timers, etc). Trainees will build various projects as part of the course. The kit forms an integral part of the course, so full course fees need to be paid at least 7 days prior to course commencement to allow time to ship the kit in time for the course.