1977 Courses in Cardiff

This foundational course will help all managers better understand what a procurement function does, including the processes, tools and techniques it employs to reach its goals and how it measures its business performance. PARTICIPANTS WILL LEARN HOW TO: Explain the contribution of procurement to the overall business objectives. Explain the added value that can be obtained by a business when it manages its procurement activities efficiently and effectively. Understand the complex activity of procurement and the challenges it presents for risk management. Develop good quality procurement practices that will manage the expectations of all stakeholders Identify methods by which a procurement function can be measured and performance monitored. Perform contract management activities. Understand ways in which improvements might be identified and implemented. COURSE TOPICS INCLUDE: Procurement and business objectives Stakeholder Management Commercial Specifications Whole Life Costing Targeted procurement Procurement planning Supplier Appraisal and selection RFQ & ITT & Evaluation Contract Management

REFERENCE CODE 601/2998/0 COURSE LEVEL NVQ Level 2 THIS COURSE IS AVAILABLE IN Course Overview This qualification is aimed at those who have responsibility for carrying out Building Maintenance work in the workplace. Because of the wide range of Construction related maintenance work it is not expected that all candidates will carry out the same activities; the qualification is structured to ensure that there is a high degree of flexibility within the units available. There are 6 pathways to cover a range of maintenance tasks that come under the following broad headings; Carpentry and Joinery, Painting and Decorating, , Tiling, Plastering, Roofing and Trowel Operations. Candidates must complete at least 2 of these pathways. All work must be completed following Industry recognised Safe Working Practices and in accordance with relevant legislation. This qualification is at Level 2, although some units may be at different levels and should be taken by those who are fully trained to deal with routine assignments. Candidates should require minimum supervision in undertaking the job. The qualification has been developed in a way to allow employees from companies of all sizes and specialisms equal opportunity to complete.

REFERENCE CODE 610/0116/X COURSE LEVEL NVQ Level 2 THIS COURSE IS AVAILABLE IN

The core principles gained from this course will help delegates have a better understanding of how to manage the relationships between sales and marketing stakeholders on the demand side and the manufacturing and other operational stakeholders on the supply side. PARTICIPANTS WILL LEARN HOW TO: • Take a different perspective on traditional data such as sales history and forecasts, as well as time-phased inventory projections and production capacity. • Recognise how their forecasts impact manufacturing schedules and inventory levels. • Assess whether they are producing enough products to meet sales demand. • Recognise how production is tied to finance and see the financial impact of production decisions, so appropriate adjustments may be then undertaken. COURSE TOPICS INCLUDE: What is S&OP? – Introduction – Definition and benefits S&OP processes – What information is required? – The stages of the S&OP process (including inputs & outputs) The integration of S&OP into a business – Critical success factors for an effective implementation – Typical roles and responsibility matrix

This foundational course will help all managers to better understand what a supply chain is and how their roles impact and interact with, their end-to-end supply chain process. PARTICIPANTS WILL LEARN HOW TO: • Understand the role of the supply chain within the wider business context • Become aware of the fundamental trade-offs in the supply chain (e.g. supply chain cost vs service level, efficiency vs flexibility etc.) • Understand the importance of supply chain planning and be able to identify its key components • Develop awareness of the key challenges in modern inventory management and distribution; become familiar with tested practices that allow responding to these challenges • Understand the meaning of essential supply chain terminology • Understand how supply chain performance affects company financial results COURSE TOPICS INCLUDE: • What is supply chain management? Why is it important? • The importance of cost versus service • Purchasing and procurement • Manufacturing processes • Demand management • Warehouse and inventory management • Logistics and transport • Risk management

There is a lot to learn in Power BI, this course takes a comprehensive look at the fundamentals of analysing data and includes a 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 utilise the online Power BI service. It looks at authoring tools that enable you to connect to and transform data from a variety of sources, allowing you to produce detailed reports through a range of visualisations, in an interactive and dynamic way. It also includes a detailed look at formulas by writing both M functions in Power Query, and DAX functions in Desktop view. This knowledge will allow you to take your reports to the next level. The aim of this course is to provide a complete introduction to understanding the Power BI analysis process, by working hands-on with examples that will equip you with the necessary skills to start applying your learning straight away. 1 Getting Started The Power BI ecosystem Opening Power BI Desktop Power BI's four views Introduction to Dashboards 2 Importing Files Importing data sources Importing an Excel file Importing a CSV file Importing a database Connect to an SQL Server Database Import vs. Direct Query Importing from the web Importing a folder of files Managing file connections 3 Shape Data in the Query Editor The process of shaping data Managing data types Keeping and removing rows Add a custom column Appending tables together Hiding queries in reports Fixing error issues Basic maths operations 4 The Data Model Table relationships Relationship properties 5 Merge Queries Table join kinds Merging tables 6 Inserting Dashboard Visuals Things to keep in mind Inserting maps Formatting Maps Inserting charts Formatting Charts Inserting a tree map Inserting a table, matrix, and card Controlling number formats About report themes Highlighting key points Filter reports with slicers Sync slicers across dashboards Custom web visuals 7 Publish and share Reports Publishing to Power BI service Editing online reports Pinning visuals to a dashboard What is Q&A? Sharing dashboards Exporting reports to PowerPoint Exporting reports as PDF files 8 The Power Query Editor Fill data up and down Split column by delimiter Add a conditional column More custom columns Merging columns 9 The M Functions Inserting text functions Insert an IF function Create a query group 10 Pivoting Tables Pivot a table Pivot and append tables Pivot but don't aggregate Unpivot tables Append mismatched headers 11 Data Modelling Expanded Understanding relationships Mark a date table 12 DAX New Columns New columns and measures New column calculations Insert a SWITCH function 13 Introduction to DAX Measures Common measure functions Insert a SUM function Insert a COUNTROWS function Insert a DISTINCTCOUNT function Insert a DIVIDE function DAX rules 14 The CALCULATE Measure The syntax of CALCULATE Insert a CALCULATE function Control field summarisation Things of note 15 The SUMX measure X iterator functions Anatomy of SUMX Insert a SUMX function When to use X functions 16 Time Intelligence Measures Importance of a calendar table Insert a TOTALYTD function Change financial year end date Comparing historical data Insert a DATEADD function 17 Hierarchies and Groups Mine data using hierarchies Compare data in groups

REFERENCE CODE 601/8330/5 COURSE LEVEL NVQ Level 2 THIS COURSE IS AVAILABLE IN Course Overview This qualification is aimed at those who are involved in installing roof sheeting and cladding systems and associated tasks on site working from drawings and specifications. It is not expected that candidates working in this industry all do the same activities or use the same equipment and machinery so there is a group of optional units to cover these matters, however all candidates will need to prove competence in preparing the resources required, installation of sheeting and cladding systems and rainwater goods (gutters, pipes, downpipes and angles (swan necks, off sets), brackets and supports, sumps, overflows and outlets). All work completed must be carried out in accordance with Building Regulations and Industry recognised safe working practices, including the disposal of waste. The qualification is structured to ensure that there is a high degree of flexibility within the units available and will allow employees from companies of all sizes and specialisms equal opportunity to complete. To provide this opportunity in addition to the core skills above, candidates will also be able to select optional units recognising skills including, repair and/or refurbishment of roof sheeting/cladding/rainscreen systems, working with boom and/or scissor type mobile elevating platforms (MEWPs), installing solar collectors, use of ergonomic manipulating machines or slinging/signalling the movement of loads.

To increase your awareness and understanding of what safeguarding children means, in order to increase your confidence to enable you to make a positive contribution towards the process.

REFERENCE CODE 600/6511/4 COURSE LEVEL NVQ Level 2 THIS COURSE IS AVAILABLE IN Course Overview This qualification is aimed at those who are involved in plastering activities in the workplace. It is not expected that candidates working in this industry all do the same activities so the qualification has been developed to allow opportunities for those carrying out work in any one of the following broad categories: solid basic plastering, solid full plastering, basic fibrous plastering and full fibrous plastering. Those taking the qualification must also prove knowledge and competence in working at heights, calculating quantities and wastage and the use of powered and hand tools and equipment. All work completed must be done in accordance with building regulations and industry recognised safe working practices, including the disposal of waste. The qualification is structured to ensure that there is a high degree of flexibility within the units available and will allow employees from companies of all sizes and specialisms equal opportunity to complete. To provide this opportunity in addition to the core skills above, candidates will also be able to select optional units recognising skills including, working with direct bond dry linings, laying sand and cement screeds, installing mechanically fixed plasterboard and carrying out repair work. The standards cover the most important aspects of the job. This qualification is at Level 2, although some units may be at different levels and should be taken by those who are fully trained to deal with routine assignments. Candidates should require minimum supervision in undertaking the job

This very practical session is designed to enable participants to improve the impact, clarity and accuracy of their reports. It focuses equally on the two key areas - structure and writing technique. This course will help participants: Scope reports based on objective and intended readership Write a structured report Use the Fog Index to ensure readability Write grammatically correct and well-punctuated text Review and edit their work. 1 Introduction Objectives and overview Introductions and personal aims 2 What makes a good report? Practical activity and feedback 3 Before you start The planning process and scoping a report Organising information Key report headings What goes where? Writing practice and review 4 Writing tips and techniques Clear English and use of language Grammar and sentence structure Refresher in punctuation Writing in the third person The Fog Index - and how to measure readability 5 Pulling it all together Reviewing and proofing 6 Review Summary of key learning points Action planning