665 Courses in Cardiff delivered Live Online

Duration 2 Days 12 CPD hours Overview Identify and configure basic functions of Tableau. Connect to data sources, import data into Tableau, and save Tableau files Create views and customize data in visualizations. Manage, sort, and group data. Save and share data sources and workbooks. Filter data in views. Customize visualizations with annotations, highlights, and advanced features. Create and enhance dashboards in Tableau. Create and enhance stories in Tableau As technology progresses and becomes more interwoven with our businesses and lives, more and more data is collected about business and personal activities. This era of "big data" has exploded due to the rise of cloud computing, which provides an abundance of computational power and storage, allowing organizations of all sorts to capture and store data. Leveraging that data effectively can provide timely insights and competitive advantage. The creation of data-backed visualizations is a key way data scientists, or any professional, can explore, analyze, and report insights and trends from data. Tableau© software is designed for this purpose. Tableau was built to connect to a wide range of data sources and allows users to quickly create visualizations of connected data to gain insights, show trends, and create reports. Tableau's data connection capabilities and visualization features go far beyond those that can be found in spreadsheets, allowing users to create compelling and interactive worksheets, dashboards, and stories that bring data to life and turn data into thoughtful action. Prerequisites To ensure your success in this course, you should have experience managing data with Microsoft© Excel© or Google Sheets?. Lesson 1: Tableau Fundamentals Topic A: Overview of Tableau Topic B: Navigate and Configure Tableau Lesson 2: Connecting to and Preparing Data Topic A: Connect to Data Topic B: Build a Data Model Topic C: Save Workbook Files Topic D: Prepare Data for Analysis Lesson 3: Exploring Data Topic A: Create Views Topic B: Customize Data in Visualizations Lesson 4: Managing, Sorting, and Grouping Data Topic A: Adjust Fields Topic B: Sort Data Topic C: Group Data Lesson 5: Saving, Publishing, and Sharing Data Topic A: Save Data Sources Topic B: Publish Data Sources and Visualizations Topic C: Share Workbooks for Collaboration Lesson 6: Filtering Data Topic A: Configure Worksheet Filters Topic B: Apply Advanced Filter Options Topic C: Create Interactive Filters Lesson 7: Customizing Visualizations Topic A: Format and Annotate Views Topic B: Emphasize Data in Visualizations Topic C: Create Animated Workbooks Topic D: Best Practices for Visual Design Lesson 8: Creating Dashboards in Tableau Topic A: Create Dashboards Topic B: Enhance Dashboards with Actions Topic C: Create Mobile Dashboards Lesson 9: Creating Stories in Tableau Topic A: Create Stories Topic B: Enhance Stories with Tooltips

This one-day workshop is designed to build upon skills already acquired using Microsoft Word, whether participants are self-taught or have previously attended a course. It gives participants a good understanding of managing different types of paragraph indents, and managing automated numbered paragraph lists. This course will help participants: Create and manage the layout of paragraphs Create and manage multi-level numbered paragraphs Effectively insert, use and manage section breaks Create and manage columns Find, create and apply styles Create and update a table of contents from styles Work with styles to manage formatting Work with sums in tables and use table headings Input and edit text using AutoText Work with SmartArt graphics Link to other files using paste special 1 Managing paragraph layout Controlling paragraph layouts with indents Creating and managing paragraph hanging indents 2 Numbering paragraphs Creating a new multi-level numbered paragraph Managing existing multi-level numbered paragraphs 3 Inserting columns Creating columns from existing paragraphs Setting up columns Managing columns 4 Document section breaks Controlling document layout using section breaks Managing page orientation using section breaks Managing page numbering using section breaks 5 Using styles Applying quick styles Finding existing styles Creating and saving styles Modifying styles Creating a table of contents from styles Updating a table of contents 6 Using quick parts Saving content to quick parts Modifying saved quick parts Inserting content using AutoText Editing AutoText entries Inputting text using AutoCorrect 7 Advanced table features Sorting table columns Running sums in tables Repeating table headings at top of page Importing Excel content in tables Using table properties 8 Creating a mail merge Creating letters, labels and emails Merging addresses from external files Using Outlook's address book to merge Merging to email 9 SmartArt graphic Visually communicate content with SmartArt Choosing a SmartArt graphic Inputting into SmartArt Modifying and formatting SmartArt graphics 10 Linking to other files Linking to files using paste special Linking an Excel chart to a document Managing linked content from Word

Enhance your expertise in compressor and pump selection, operation, troubleshooting, and maintenance with EnergyEdge's comprehensive classroom training. Elevate your skills today!

Duration 3 Days 18 CPD hours This course is intended for Anyone starting to write SAS programs Overview Use SAS Studio and SAS Enterprise Guide to write and submit SAS programs. Access SAS, Microsoft Excel, and text data. Explore and validate data. Prepare data by subsetting rows and computing new columns. Analyze and report on data. Export data and results to Excel, PDF, and other formats. Use SQL in SAS to query and join tables. This course is for users who want to learn how to write SAS programs to access, explore, prepare, and analyze data. It is the entry point to learning SAS programming for data science, machine learning, and artificial intelligence. Essentials The SAS programming process. Using SAS programming tools. Understanding SAS syntax. Accessing Data Understanding SAS data. Accessing data through libraries. Importing data into SAS. Exploring and Validating Data Exploring data. Filtering rows. Formatting columns. Sorting data and removing duplicates. Preparing Data Reading and filtering data. Computing new columns. Conditional processing. Analyzing and Reporting on Data Enhancing reports with titles, footnotes, and labels. Creating frequency reports. Creating summary statistics reports. Exporting Results Exporting data. Exporting reports. Using SQL in SAS Using Structured Query Language in SAS. Joining tables using SQL in SAS. Additional course details: Nexus Humans SAS Programming 1 - 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 SAS Programming 1 - 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.

Certified Business Relationship Manager (CBRM®): Virtual In-House Training The CBRM® Practitioner Qualification is intended for the intermediate-to-advanced Business Relationship Manager, as it focuses on advancing to the role of Strategic Business Relationship Manager. As such, the primary focus is on strategic business relationship management, leveraged to optimize business value to the enterprise. The purpose of the Practitioner qualification is to confirm whether the candidate has achieved sufficient understanding and competence to perform the role of Strategic Business Relationship Manager. To pursue the CBRM® certification, a candidate must be a certified Business Relationship Management Professional (BRMP®). What You Will Learn The successful candidate will demonstrate deep understanding and ability to perform the Strategic BRM role. Specifically, the candidate will: Effectively communicate the purpose and objectives of the Strategic BRM role and how to optimally position that role for maximum effectiveness within the enterprise Understand how to use their personal power and influence to build business relationships and foster a culture that excels at business value results Apply the Strategic Relationship Management processes and techniques to build and sustain trust relationships spanning Business Partner and Provider networks Be able to assess Business Demand Maturity and Business Relationship Maturity and how these might evolve over time Be able to assess Provider Capability Maturity and BRM Competencies and identify key areas needing improvement Be able to apply cross-organization communication techniques to clearly articulate real Provider / business value delivered to the organization Be able to influence executive leaders in their use of Provider Capabilities and Assets based upon potential business value and convergence with business strategy Promote and catalyze business innovation in the Provider's sphere of influence Be able to use the Business Value Management process, techniques, and metrics to define, realize, and optimize the value of Provider capabilities and assets Apply Business Partner Experience Management so as to foster a positive Business Partner perception of Provider capabilities as an essential element of building and sustaining trust relationships Shape strategic agendas for optimum business value, with due consideration of external compliance requirements and potential risks to the business Understand the implications of Lean / Agile methods for the BRM role and capability Influence the development and deployment of available Provider capabilities based upon business need and potential to enable or create business value. Apply Business Capability Management to determine and acquire enabling capabilities pursuant to strategic outcomes Apply Business Capability Management to determine and acquire enabling capabilities pursuant to strategic outcomes Contribute to Business Transition Management in order to foster organizational understanding, support, adoption, and business value results of investments in new business capabilities Course Introduction Explain the House of BRM, recalling the BRM Core Disciplines, competencies required for the BRM role, and necessary conditions for protecting the integrity of the role Recall the key BRM concepts, processes, and techniques Understand the Business Relationship Maturity Model and the Five Relationship Maturity Levels Understanding Business Relationship Maturity and Value The Strategic BRM Role and Capability BRM Impact on Business Value Introduction to the ACME Leisurewear Case Scenario that is used through the course Assessing BRM Context Clarifying Issues Conducting a Business Demand Maturity Assessment Conducting a Business Relationship Maturity Assessment Conducting a Provider Capability Maturity Assessment Shaping the Business Partner's experience with the Provider The BRM role in Service Management Developing Strategic Relationships How to assess Strategic Relationships and plan for their improvement How to achieve business impact through influence and persuasion How to plan and execute BRM formal communications Organizational considerations for BRM deployment How to determine appropriate BRM performance measurement Optimizing Business Value Formulating and Clarifying Business Strategy Catalyzing Business Innovation Business Capability Management Value Management Planning Portfolio Management Business Transition Planning Business Value Optimization Summary and CBRM Exam Preparation Course Summary CBRM Syllabus Review Format and structure of the CBRM® Practitioner Exam Exam hints and tips Sample Exam

Duration 3 Days 18 CPD hours This course is intended for IT Professionals who expect to or who have recently transitioned into a management role will benefit from this course. Overview Make a smooth transition into management Develop your authentic leadership style Engage and empower staff to achieve excellence Build high-performing, collaborative teams Apply delegation best practices Attract and retain great staff From developing an inspiring vision and empowering members to reach it, to meeting deadlines, and evaluating results. This course will teach students the skills and behaviors needed to successfully transition into an IT manager role. Private classes on this topic are available. We can address your organization?s issues, time constraints, and save you money, too. Contact us to find out how. 1. Making the Transition into Leadership Defining Success Developing Leadership Competencies Acting as Leader, Liaison, Figurehead. Monitor, Disseminator, and Spokesperson Allocating Resources Acting Entrepreneurially Negotiating and Handling Disturbances 2. Building Trust, Engagement and Involvement Applying SCARF Leading by Example with the 5 Components of Emotional Intelligence - Self-Awareness, Self-Regulation, Motivation, Empathy, and Social Skill Engaging, Involving, and Motivating Others The 4 Disciplines of Motivation - Behavioral, Cognitive, Psychodynamic, and Humanistic Working with Differing Personality Styles Developing Your Leadership Psychological Toolkit Discovering and Meeting Stakeholder Expectations 3. Collaboration & Teams Creating, Facilitating, and Maintaining Teams Building a Team through Culture, Human to Human Relationships, Effective Communication, and Setting and Meeting Goals & Objectives Modern, Autonomous, Self-Organizing, and Cross-Functional Teams 4. Building People with Challenging Work Willingness to Delegate Delegating Successfully - Preparing and Researching, Clarifying the Intent of the Task, Planning Your Delegation, Delegating Responsibility and Empowering Your Staff to Take Action, and Providing Ongoing Support and Oversight 5. Attracting and Keeping Great People Managing Performance Knowing Your Staff Checking Assumptions Engaging Your Team Leading and Coaching for Success Managing Disruption

This course starts with the basics then moves seamlessly to an intermediate level. It includes a comprehensive yet balanced look at the four main components that make up Power BI Desktop: Report view, Data view, Model view, and the Power Query Editor. It also demonstrates how to use the online Power BI service. It looks at authoring tools that enables you to connect to and transform data from a variety of sources, allowing you to produce dynamic reports using a library of visualisations. Once you have those reports, the course looks at the seamless process of sharing those with your colleagues by publishing to the online Power BI service. The aim of this course is to provide a strong understanding of the Power BI analysis process, by working with real-world examples that will equip you with the necessary skills to start applying your knowledge straight away. 1 Getting started The Power BI process Launching Power BI Desktop The four views of Power BI Dashboard visuals 2 Connecting to files Connect to data sources Connect to an Excel file Connect to a CSV file Connect to a database Import vs. DirectQuery Connect to a web source Create a data table 3 Transforming data The process of cleaning data Column data types Remove rows with filters Add a custom column Append data to a table Fix error issues Basic maths operations 4 Build a data model Table relationships Manage table relationships 5 Merge queries Table join kinds Merging tables 6 Create report visualisations Creating map visuals Formatting maps Creating chart visuals Formatting chart Tables, matrixes, and cards Control formatting with themes Filter reports with slicers Reports for mobile devices Custom online visuals Export report data to Excel 7 The power query editor Fill data up and down Split columns by delimiter Add conditional columns Merging columns 8 The M formula Creating M functions Create an IF function Create a query group 9 Pivot and unpivot tables Pivot tables in the query editor Pivot and append tables Pivot but don't summarise Unpivot tables Append mismatched headers 10 Data modelling revisited Data model relationships Mark a calendar as a date table 11 Introduction to calculated columns New columns vs. measures Creating a new column calculation The SWITCH function 12 Introduction to DAX measures Common measure categories The SUM measure Adding measures to visuals COUNTROWS and DISINCTCOUNT functions DAX rules 13 The CALCULATE measure The syntax of CALCULATE Things of note about CALCULATE 14 The SUMX measure The SUMX measure X iterator functions Anatomy of SUMX 15 Introduction to time intelligence Importance of a calendar table A special lookup table The TOTALYTD measure Change year end in TOTALYTD 16 Hierarchy, groups and formatting Create a hierarchy to drill data Compare data in groups Add conditional formatting 17 Share reports on the web Publish to the BI online service Get quick insights Upload reports from BI service Exporting report data What is Q&A? Sharing your reports 18 Apply your learning Post training recap lesson

SAFe® Lean Portfolio Management: In-House Training Create a culture of innovation, flexibility, and speed where all people in the portfolio can effectively execute as one unified team. In this course, you will gain the practical tools and techniques necessary to implement the Lean Portfolio Management functions of Strategy and Investment Funding, Agile Portfolio Operations, and Lean Governance. You will have the opportunity to capture the current and future state of the portfolio with the Portfolio Canvas tool and identify important business initiatives for achieving the future state. You'll be able to establish portfolio flow with the Portfolio Kanban and prioritize initiatives for maximum economic benefit. The course also provides insights on how to establish Value Stream Budgets and Lean Budget Guardrails and measure the Lean portfolio performance. What you will Learn Describe the importance of LPM Connect the portfolio to enterprise strategy Implement Lean budgeting and guardrails Establish portfolio flow with the Portfolio Kanban Support operational excellence with APMO and CoPs Coordinate Value Streams Measure the LPM performance Build a plan for LPM implementation Introducing Lean Portfolio Management (LPM) Establishing Strategy and Investment Funding Applying Agile Portfolio Operations Applying Lean Governance Implementing the LPM function

SAFe® Lean Portfolio Management: Virtual In-House Training Create a culture of innovation, flexibility, and speed where all people in the portfolio can effectively execute as one unified team. In this course, you will gain the practical tools and techniques necessary to implement the Lean Portfolio Management functions of Strategy and Investment Funding, Agile Portfolio Operations, and Lean Governance. You will have the opportunity to capture the current and future state of the portfolio with the Portfolio Canvas tool and identify important business initiatives for achieving the future state. You'll be able to establish portfolio flow with the Portfolio Kanban and prioritize initiatives for maximum economic benefit. The course also provides insights on how to establish Value Stream Budgets and Lean Budget Guardrails and measure the Lean portfolio performance. What you will Learn Describe the importance of LPM Connect the portfolio to enterprise strategy Implement Lean budgeting and guardrails Establish portfolio flow with the Portfolio Kanban Support operational excellence with APMO and CoPs Coordinate Value Streams Measure the LPM performance Build a plan for LPM implementation Introducing Lean Portfolio Management (LPM) Establishing Strategy and Investment Funding Applying Agile Portfolio Operations Applying Lean Governance Implementing the LPM function