10 Courses in Sheffield

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

This course enables you to comply with Health and Safety Legislation by training your staff to...

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

About this Virtual Instructor Led Training (VILT)  Accredited by the United Kingdom Lubricants Association (UKLA), this 4 half-day Virtual Instructor Led Training (VILT) course will provide an in-depth understanding of the principles, economics and flexibility of lubricant blending plants and how to operate a lubricants blending plant efficiently and economically. The latest developments and trends in lubricant blending and the advantages and disadvantages of lubricant blending equipment, facilities and operations will be discussed. The importance of testing components and products for each blend, lubricant blend quality control and product quality management will also be explained. The VILT course will also clarify the importance of lubricant product filling, packaging and warehouse storage, strategies for optimising existing lubricant blending plant facilities and how to avoid or minimise problems with lubricant blending and product quality. The VILT course is recognised under the UKLA Continuing Professional Development (CPD) scheme for Registered Lubricant Professional. *There will be an examination for this VILT.   Training Objectives This VILT course will enable you to: Learn about Mineral Oil Base Oils; API Groups I, II and III: Properties and Characteristics Acquire the knowledge about Synthetic Base Oils; API Groups IV and V: Properties and Characteristics Learn about Lubricant Additives: Properties and Characteristics Know the Lubricant Formulation and Ease of Blending Explore the Blending Plant Design: Grassroots Plants and Upgrading Existing Plants Learn about Blending Plant Equipment and Facilities and Their Operation Understand the Lubricant Blending Issues: Avoiding Problems Test and Analyse Base Oils and Additives Test and Analyse Blended Lubricants Explore the importance of Product Quality Control Understand the process of Lubricant Packaging and Filling Understand the process of Lubricant Storage Learn about Product Quality Management Target Audience This VILT course will be useful and applicable for: Middle and Senior managers to understand how and why to design and operate an efficient and profitable lubricant blending plant. Blending plant operators and specialists to improve and optimise current blending plant operations. Manufacturers of lubricants will understand how and why high quality components and effective testing during the entire blending process are important to final lubricant product quality and performance. Lubricant formulators will understand the importance of close communication and co-operation with blending plant managers and operators to minimise blending costs and to thereby maximise product profitability. Course Level Intermediate Training Methods The VILT course will be delivered online in 4 half-day sessions comprising 4 hours per day, with 2 breaks of 10 minutes per day. Course Duration: 4 half-day sessions, 4 hours per session (16 hours in total). Trainer Your expert course leader (CChem, MRC) has worked as Sales, Technical Marketing Manager and Company Director with over 50 years of broad experience in the lubricants, fuels, petroleum additives, with four leading companies Chevron, Ethyl Petroleum Additives Ltd, Texaco Limited and Kuwait Petroleum (GB) Ltd. His major recent responsibilities have been concerned with leading the Oil Industry Association United Kingdom Lubricants Association, and acting in an advisory capacity as Technical Director to the Association. He has acquired a wide experience in technical, marketing and sales within the oil industry. The related experience gained with the oil additives industry has provided him with special additional insights. He has also led the Certificate of Lubricant Competence course for the United Kingdom Lubricants Association (UKLA) for 11 years. He is a Chartered Chemist and a Member of the Royal Society of Chemistry. POST TRAINING COACHING SUPPORT (OPTIONAL) To further optimise your learning experience from our courses, we also offer individualized 'One to One' coaching support for 2 hours post training. We can help improve your competence in your chosen area of interest, based on your learning needs and available hours. This is a great opportunity to improve your capability and confidence in a particular area of expertise. It will be delivered over a secure video conference call by one of our senior trainers. They will work with you to create a tailor-made coaching program that will help you achieve your goals faster. Request for further information about post training coaching support and fees applicable for this. Accreditions And Affliations

QA Level 2 Award In Principles Of Manual Handling (RQF) Half day course (face to face), 2 sessions (virtual) Gives learners a good understanding of why manual handling is so important Gives learners the knowledge of safe manual handling principles Our full day course, Safe Moving and Handling, will also give learners sound practice in manual handling Course Contents: Common manual handling injuries Manual handling laws Responsibilities of employers and employees Manual handling risk assessments Safe movement principles associated with manual handling, including the body’s: Recognising a range of mental health conditions:Musculoskeletal systemCentre of gravityLever system Manual handling equipment:Types of manual handling aids and equipmentMaintenance and requirements for testing Theory of safe manual handling principles, including: Preparing for a lift Solo lifting, carrying and lowering an object Team manual handling Benefits of this course: 498,000 people people suffered from musculoskeletal disorders due to work related activities in 2018/2019 Of those, 138,000 were from people who had not suffered this before 6.9 million working days, or 26,436 working years, were lost due to work-related musculoskeletal disorders that year On average, each of those people had to take 16 days off work, with many never fully recovering from those injuries This course is there to help people avoid getting injured in the first place, saving both human suffering and cost to the employer and employee both Accredited, Ofqual regulated qualification Our Principles of Manual Handling Course is a nationally recognised, Ofqual regulated qualification accredited by Qualsafe Awards. This means that you can be rest assured that your Principles of Manual Handling Course fulfills the legal requirements and is a very good way to make sure you and your employees are trained in the principles of Manual Handling. The Ofqual Register number for this course is 603/2720/0

QA Level 2 Award In Safe Moving And Handling (RQF) Full day course (classroom) Provides a good understanding of the principles of safe manual handling Gives learners the ability to apply the principles of safe manual handling Benefits of this course: 470,000 people people suffered from musculoskeletal disorders due to work related activities in 2020/2021 Of those, 162,000 were from people who had not suffered this before 8.9 million working days, or 37,083 working years, were lost due to work-related musculoskeletal disorders in 2019/2020 This course is here to help people avoid getting injured in the first place, saving both human suffering and cost to the employer and employee both Course Contents: Common manual handling injuries Manual handling laws Responsibilities of employers and employees Manual handling risk assessments Safe movement principles associated with manual handling, including the body’s:Musculoskeletal systemCentre of gravityLever system Manual handling equipment:Types of manual handling aids and equipmentMaintenance and requirements for testing Manual handling practical sessions: Preparing for a lift Solo lifting, carrying and lowering an object Team manual handling Accredited, Ofqual regulated qualification: Our Safe Moving and Handling Course is a nationally recognised, Ofqual regulated qualification accredited by Qualsafe Awards. This means that you can be rest assured that your Manual Handling Certificate fulfills the legal requirements and is a very good way to make sure you and your employees are trained appropriately in Manual Handling. The Ofqual Register number for this course is 603/2744/3

full-time General English in the UK for 4 weeks MINIMUM, and covers the areas of listening, speaking, reading, writing, and grammar. It also includes 4x weeks MAXIMUM of work for a charity. study and volunteer in the UK

This course looks at the key processes in supply chains and how they interact; the most common supply chain terms and how they are utilised to describe supply chain activities. It will cover the definitions of transport modes and how to select the most appropriate one; the role of logistics partners in the extended supply chain and the definition and use of Incoterms. PARTICIPANTS WILL LEARN HOW TO: Explain the term “Supply Chain” Define main activities in Transport & Freight Management Describe the key principles of Warehousing Interpret INCOTERMS COURSE TOPICS INCLUDE: Freight terminology & global trade terminology Warehouse, logistics and transport operations Transport modes Parties involved in international shipments INCOTERMS Freight calculations

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

This comprehensive one-day programme has been designed to provide participants with an overview of basic supply chain principles and concepts and to identify potential opportunities for reducing costs, minimising risks and adding value across the supply chain. This could include reducing inventory, procurement, transport and storage costs. Fundamentally, the object of the programme is to empower participants to be able to collaborate with all key stakeholders across the supply chain. This course will help participants: Appreciate the importance of the supply chain as a source of competitive advantage Understand the tools and techniques available to improve supply chain performance Analyse and mitigate risks across the supply chain Identify opportunities for improvements in their respective supply chains Demonstrate competence in the pro-active management of the supply chain