4396 Courses in Cardiff delivered Live Online

Duration 1 Days 6 CPD hours This course is intended for This course is for employees of Sun Life who want to learn how to use HUE when working with SQL databases. Overview Upon successful completion of this course, students will be able to operate HUE when interacting with SQL databases. In this course, students will learn how to operate HUE when interacting with SQL databases. Executing a Simple Query Connect to the SQL Database Query a Database Save a Query Modify and Execute a Saved Query Performing a Conditional Search Search Using One or More Conditions Search for a Range of Values and NULL Values Search Data Based on Patterns Working with Functions Perform Date Calculations Calculate Data Using Aggregate Functions Manipulate String Values Organizing Data Sort Data Rank Data Group Data Filter Grouped Data Summarize Grouped Data Use PIVOT and UNPIVOT Operators Retrieving Data from Multiple Tables Combine the Results of Two Queries Compare the Results of Two Queries Retrieve Data by Joining Tables Exporting Query Results Generate a Text File Generate an XML File Additional course details: Nexus Humans SQL Querying Fundamentals with HUE - Part 1 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 SQL Querying Fundamentals with HUE - Part 1 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 2 Days 12 CPD hours This course is intended for System administrators Overview Prepare you to perform key administrative tasks in SAP BusinessObjects Business Intelligence platform to manage users, groups, and objects, and to distribute contents to users. In this course, students perform key administrative tasks in SAP BusinessObjects Business Intelligence platform to manage users, groups, and objects, and to distribute contents to users. SAP BusinessObjects Business Intelligence (BI) Platform Identifying the Components of the SAP BusinessObjects Business Intelligence BI Platform Content and Objects in the SAP BusinessObjects Business Intelligence (BI) Platform Viewing and Modifying Objects in the BI Platform Organizing Objects in the BI Platform Searching for Content in the BI Platform User and User Group Security in the SAP BusinessObjects Business Intelligence (BI) Platform Setting Up Users and Groups Administering Rights Application Security in the SAP BusinessObjects Business Intelligence (BI) Platform Managing Access to Applications Securing Applications Content Distribution Using Scheduling and Alerting Scheduling Objects Managing Instances Managing Calendars Managing Events Configuring Alerts and Alerting Publications and Publishing Designing Publications Additional course details: Nexus Humans BOE310 SAP BusinessObjects Business Intelligence Platform - Administration and Security 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 BOE310 SAP BusinessObjects Business Intelligence Platform - Administration and Security 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.

This intensive one-day IACCM-approved programme helps participants develop the skills, knowledge and competencies required to plan for and carry out effective negotiations in a range of different environments. By the end of the programme participants will be able to: Understand the basic concepts of negotiation and how it adds value to the organisation Recognise the stages of negotiation and the skills required at each stage Make use of tried-and-tested negotiation planning tools Apply a range of negotiation tools and techniques to support the organisation in obtaining value for money, quality and fit-for-purpose outcomes Set negotiation objectives Appreciate the importance of interpersonal skills in maximising the opportunities for reaching win/win agreements 1 Welcome Introductions Aims and objectives Plan for the day 2 Why negotiate? Understanding the negotiation context Negotiating with suppliers Negotiating with stakeholders 3 Understanding the process The phases of negotiation and what to do in each phase Before During After 4 Planning Appreciating the importance of planning Different approaches Identifying the key variables Setting objectives for each of them Practical negotiation planning exercise 5 Doing The key skills required, Communication Numeracy empathy Applying these skills in a role play: practical exercise 6 Close Review of key learning points Personal action planning

Microsoft Excel training | Excel Courses for Accountants: Excel Courses Overview Microsoft Excel is the world's most popular spreadsheet program, learning how to use the software with Osborne Training shows that you've taken one of the best Excel training courses available. Comprehensive excel courses come with up to date material to practice at home and during your class. Excel courses for accountants This course is a highly recognised excel course for accountants. We will also provide a step by step manual of all the tricks you can do using Excel spreadsheets to gain better management reporting and budgeting skills. It is a fundamental program for professional Accountants. Excel spreadsheets are the most powerful tool, extensively used for reporting and analysis. Having advanced skills in excel can excel your career and help you to stand ahead of the competitive job market. Advanced skills in Excel is a must for any potential professional accountants and who are already running a practice or considering opening a practice. Certificate of Attendance Excel Course Content Creating worksheets, formatting text Simple and complex formulas Handling rows and columns Average, max and min functions and using charts. Use of IF Formula Summing Techniques Cell References Formula Linking Tables and Bordering Look up References (Vlookup, Hlookup, etc) Data Validation Conditional Formatting Date & Time Formulas Charts & Graphs Protection & Security Creating Pivot Table Pivot Table Analysis

Success = Value + People + Process With innovation happening more than ever, the new agile project economy requires more and more people across organisations to manage projects successfully, leading to many of us quietly slipping into the role of the unofficial project manager! The problem is very few people receive formal training on how to do it. Stakeholders, scope creep, limited training, and a lack of process all combine to raise the probability of project failure costing organisations time, money, and employee morale Is it any wonder 65% of all projects fail* each year! The good news is—unofficial project managers can build confidence to lead high-value projects and engage teams in a way that inspires them to volunteer their best efforts. Source: *Nieto-Rodriguez, A. (2021). “The Project Economy Has Arrived.” Harvard Business Review; Nov/Dec 21. Outcomes Project Management for the Unofficial Project Manager™ combines best practices from agile and waterfall project management to equip learners with the mindset, skillset, and toolset to engage and inspire team members. Success starts with the core agile principle of value—a project must deliver value to Noble! Once value is established, it is people who make projects successful through a consistent process. Project management isn’t just about managing logistics and hoping the project team is ready to play to win. The skills of “informal authority” are more important than ever before, so team members are inspired to contribute to project success! This course will help learners: Build strong informal authority that inspires project teams to consistently volunteer their best efforts. Utilise a consistent process to start and finish high-value projects on time and with quality. Influence and engage others to define a clear project scope, including clear deliverables and risk strategies. Model openness and agility to apply proactive change management and deliver high-value projects. Project Management Framework The Project Management Framework guides you through five distinct elements in the life of any project. Coupled with the foundational behaviours taught in the programme, this framework can help you deliver highly successful projects again and again. Who Should Attend? This programme is for anyone who finds themselves leading projects at work, regardless of whether or not their job title says, Project Manager! It is NOT a deep dive into project management processes, nor is it a qualification based programme. Whilst it would be helpful to either be involved in or to be leading a project, during the programme, this is clearly not essential. However, it is advisable that the participants have had some experience, whether as a project member or as the person who is leading the project (officially or not)! Project Management Institute (PMI) FranklinCovey is a member of the Project Management Institute (PMI) Authorised Training Partners (ATP) Programme and this course has been designed to satisfy the project management education requirement for PMI Certifications as well as Professional Development Education units (PDUs) needed by PMI credential holders.

Duration 2 Days 12 CPD hours This course is intended for Managers of software development Software team leads Specialists in software development processes and quality assurance Overview An understanding of how to maintain a regular cadence when delivering working software during each iterationGaining a practical appreciation on how to follow the team approach; start as a team, finish as a teamKnowledge and understanding of Agile principles with context on why they are so important for each teamEmbracing planning from Vision down to Daily activities, recognizing the value of continuous planning over following a planBuilding a backlog of prioritized stories that provide emergent requirements for analysis that also fosters customer engagement and understandingAn engaging technique for more effective estimating (planning poker) and become more accurate by being less preciseKnowledge of pulling together Agile release plans that connect you back to business expectations ? including hard date commitments and fixed price models This boot camp-style workshop prepares you to manage, lead, or participate on Scrum projects by learning how to apply the practices of Scrum on an actual project. This boot camp-style workshop prepares you to manage, lead, or participate on Scrum projects by learning how to apply the practices of Scrum on an actual project. Additional course details: Nexus Humans BA16 - Managing Software Projects Using Scrum 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 BA16 - Managing Software Projects Using Scrum 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 5 Days 30 CPD hours This course is intended for Customers: Administrators, developers, web developers, and managers who are managing the Asset Manager 9.x product- Channel Partners and HP C&I Personnel: Consultants, system architects, integrators, and planners who help customers with Asset Manager 9.x implementations- HP Engineers: HP personnel who provide pre-sales and post-sales support for Asset Manager 9.x Overview At the end of the course, you should be able to:? Describe an evolutionary approach to assetmanagement? Explain the capabilities provided by AssetManager's core modules? Use the clients to navigate within Asset Manager'score tables? Create a database? Create and manage portfolio items? Reconcile software installations with softwarelicenses? Write scripts to extend Asset Manager'sfunctionality? Create queries and views to filter data? Configure Asset Manager security and controldatabase access? Import and export data using Asset Manager? Schedule automatic processes This five-day instructor-led training course is designed to provide the essential skills and knowledge needed to configure, deploy, and use Asset Manager 9.40 to successfully implement an asset management solution. This five-day instructor-led training course is designed to provide the essential skills and knowledge needed to configure, deploy, and use Asset Manager 9.40 to successfully implement an asset management solution. Additional course details: Nexus Humans AM120 - Asset Manager 9.x Software - 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 AM120 - Asset Manager 9.x Software - 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.

Duration 1 Days 6 CPD hours This course is intended for To ensure success, students will need to be familiar with using personal computers and should have experience using a keyboard and mouse. Students should also be comfortable working in the Windows 10 environment and be able to manage information on their computers. Overview Upon successful completion of this course, you will be able to understand Office 365 and leverage its tools to increase productivity and collaboration within your organization. This course is intended for students who wish to gain the foundational understanding of Office 365. This course aims to provide an introduction to 365, its applications and tools. Getting Started with Office 365 An Introduction to Office 365 Navigate the Online User Interface Your Account, Personal Profile, Apps Use Help Personal Communications Outlook, Calendar and People Outlook Online Essentials Online location of Outlook features, signatures etc. Online Calendar Essentials Shared and Sharing Calendars People Online Essentials Searching, Groups and Lists Information and File Sharing OneDrive for Business File Management and File Sharing SharePoint Online Sites, Libraries and Lists Team Communications Skype for Business Yammer Collaboration Creating and Co-authoring Online Online vs Desktop Excel Online Word Online PowerPoint Online OneNote Online Other Apps Additional course details: Nexus Humans Office 365 - 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 Office 365 - 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.

Duration 2 Days 12 CPD hours This course is intended for This course is intended for individuals who want to gain basic and intermediate knowledge of working on AutoCAD Overview Upon successful completion of this course, students will be able to create basic and intermediate drawings utilizing the AutoCAD software In this course, you will learn to navigate the AutoCAD user interfaces and use the fundamental features of AutoCAD. You will learn to use the precision drafting tools in AutoCAD to develop accurate technical drawings. Utilizing the AutoCAD Software Startup Screen The Application Menu The AutoCAD User Interface AutoCAD Options [OP] Saving the Drawing ?Places? for Quicker Access of Drawings Wheel Mouse Tidbits The Governing Body of Workspaces Ribbon Management Layer Properties Manager Assigning a Linetype to a New Layer Off vs. Freeze Practical Features of Layer Walk Creating a Layer State Freezing Individual Layers with Layer Freeze Layer Lock Creating Drawings with AutoCAD Accuracy Measuring a Distance Measuring an Area Creating Basic Objects Object Selection Options Basic Editing Commands Polar Tracking Editing Polylines Variable Width Polyline Command Aliases Move and Copy with ?CTRL? Customizing Rollover Tooltips Cycle Through Stacked Objects Additional Selection Options Stretch Midpoint Between Two Points [M2P] Snap From Hatch Stuff Additional course details: Nexus Humans AutoCAD 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 AutoCAD 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.

Duration 2 Days 12 CPD hours This course is intended for This course is intended for SQL professionals, Microsoft Analysis Services cube and report developers, and business intelligence professionals. Overview ?Understand common Analysis Services solutions.?Understand version changes of SSAS from 2008-2014.?Understand Analysis Services installation and architecture.?Understand how to choose the right model.?Understand the Analysis Services tools available.?Understand the multidimensional model.?Utilize data sources and data source views.?Create a cube.?Understand and utilize dimensions.?Understand and utilize attributes.?Understand and utilize relationships.?Understand and utilize hierarchies.?Understand and utilize measures and measure groups.?Understand and utilize calculated members.?Understand and utilize perspectives.?Understand and utilize translations.?Browse perspectives and translations.?Understand and utilize deployment options.?Understand and utilize processing strategies.?Understand and utilize security.?Deploy a multidimensional model.?Understand the tabular model.?Create a tabular project.?Analyze the data using Microsoft Excel.?Create and configure calculated measures and calculated fields.?Backup and Restore. This course is intended for IT professionals who are interested in quickly learning how to utilize an Analysis Services multidimensional or tabular solution. Course Overview Introduction Course Materials Facilities Prerequisites What We'll Be Discussing Lab 1: Course Overview Introduction to Microsoft SQL Server Analysis Services Common Analysis Services Solutions Version Changes of SSAS from 2008-2014 Analysis Services Installation and Architecture: One Product, Two Models Choosing the Right Model Analysis Services Tools Lab 1: Introduction to Microsoft SQL Server Analysis Services The Multidimensional Solution Understanding the Multidimensional Model Utilizing Data Sources and Data Source Views Creating a Cube Lab 1: The Multidimensional Solution Dissecting with Dimensions Developing Dimensions Utilizing Attributes Relating with Relationships Handling Hierarchies Lab 1: Dissecting with Dimensions Managing Measures Measures and Measure Groups Calculated Members Lab 1: Managing Measures Configuring Cube Options Understanding Perspectives Utilizing Translations Browsing Perspectives and Translations Lab 1: Configuring Cube Options Deploying Examining Deployment Options Processing Strategies Exploring Security Lab 1: Deploying The Tabular Solution Understanding the Tabular Model Creating a Tabular Project Deploying Browsing the Model Querying the Solution and Understanding DAX Maintaining and Optimizing Lab 1: The Tabular Solution