1984 Courses in Glasgow

The fundamental tool to identify waste, create effective process flow, reduce process cycle times, and implement process improvement.

If you are a Mental Health First Aider or MHFA Champion you have skills for life that support you and the people around you. We believe that mental health should be treated equally to physical health - and just like physical first aid, Mental Health First Aid training should be kept up to date. The four-hour MHFA Refresher course will empower you to: Keep your awareness of mental health supports current Update your knowledge of mental health and what influences it Practice applying the Mental Health First Aid action plan Outline About mental health Stress and factors that influence mental health Mental health continuum and stigma Frame of reference and non-judgement Reintroducing ALGEE Warning signs of mental ill-health Depression and anxiety Suicide and first aid for suicidal crisis Psychosis and first aid for severe psychotic episodes Practising our MHFA sills Self-care, wellbeing and recovery

If you're looking for a short, sharp high-impact intervention that will help motivate and inspire your sales team then a 'bite-sized' session could be just what you're looking for. We have a range of sessions that can be delivered on an 'off-the-shelf' basis, or they can be tailored to your specific requirements or, of course, we can develop something specifically for you on an entirely bespoke basis. And the length of the session is entirely up to you - 45-minutes, an hour, a half-day - whatever you prefer. Sessions can be run for small groups as part of your regular team meetings or they can be delivered for larger audiences, conference-style - the choice is yours. The session outlines below are just to give you an idea of the possibilities. If one of them whets your appetite please just give us a call on 01582 463463 to talk through what we can do for you - we're here to help!

This course provides exceptional training on the principles and processes required to successfully operate a warehouse. PARTICIPANTS WILL LEARN HOW TO: • Learn about the characteristics of a warehouse and its function • Understand the basic principles of effective layout design and product storage prioritization • Gain an understanding of modern practices in warehouse operations, such as Kanban and 5S • Understand the importance of packaging and data inputs to improve the performance of pick and pack operations • Understand the role of KPIs in warehouse and supply chain management COURSE TOPICS INCLUDE: Material storage as part of supply chain management Evaluation of outsourcing issues Challenges of codification and traceability Performance management Automated and mechanized systems Different storage methodologies Use of Warehouse management systems Optimum cube utilization and labour productivity Picking and packing management systems Goods receipt and dispatch

This course will move a manager’s focus away from simply reviewing last year’s financial performance, toward the development of an interactive approach, designed to really understand financial performance and the consequence of inaction. PARTICIPANTS WILL LEARN HOW TO: • The confidence to use budgeting tools and techniques • An understanding of the demands of financial management • The ability to analyse and challenge financial and accounting • Information • An understanding of fixed and variable costs and how these affect the sales price and profitability • Understanding the challenges of overhead allocation • Understanding the P&L • Developing awareness of fundamental investment appraisal techniques COURSE TOPICS INCLUDE: • Budget Definitions & Planning • Designing and developing a budget • Performance reporting systems & cost control • Zero-based budgeting systems • Understanding business costs (FC & VC) • Understanding variance analysis • Profit and Loss & Balance Sheet

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/8331/7 COURSE LEVEL NVQ Level 3 THIS COURSE IS AVAILABLE IN Course Overview This qualification is aimed at those who are involved in installing Rainscreen wall cladding systems and/or roof sheeting and cladding systems that involve curved and complex roof and wall formations in the workplace, 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 the qualification has been developed to make it as widely available as possible by having 2 distinct pathways. 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 relevant mandatory pathway units of installation of the relevant system (roof and wall sheeting and cladding or rainscreen wall cladding systems) , 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. The standards cover the most important aspects of the job. This qualification is at Level 3, although some units may be at different levels, qualifications at this level are primarily aimed at those who are fully trained and experienced in a wide range of roles that may involve decision making, quality checks, work planning and dealing with non-routine or complex installations. The qualification consists of 3 mandatory units and 2 pathways, Wall sheeting and cladding and Rainscreen Wall Systems. Candidates must achieve the 3 qualification mandatory units plus the required credits from the selected pathway. The minimum credit value of the Wall sheeting and cladding qualification is 132 credits, the minimum credit value of the Rainscreen wall systems qualification is 104 credits.

What are the aims of this course? Define mental health Identify and explain mental health facts and fiction Understand key legislation relating to mental health Explain how mental health care has evolved over time Identify common signs and symptoms Understand common mental health disorders Recognise common attitudes towards mental ill-health and the impacts these can have Explain the concept of parity of esteem Know how to support people and offer advice

This course will provide the key to successful inventory management, by combining practical inventory control techniques with sound procurement practice, to produce a solid foundation to enable your supply chain to meet customer expectations at the lowest possible cost. PARTICIPANTS WILL LEARN HOW TO: • Understand the role of inventory in an effective supply chain. • Understand categories of stock and how to tailor stockholdings. • Learn how to utilize key concepts, variables and metrics that allow for effective management of inventory. • Understand how product demand and product lifecycle are connected to inventory management. COURSE TOPICS INCLUDE: • Demand Characteristics and the Product Life Cycle • Push and pull systems • Demand forecasting • Categorisation of stock • ABC Analysis • Economic order quantity and minimum order quantity • Safety stock and stock cover • Materials requirements planning (MRP) • Stock replenishment systems • The cost of managing stock

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