592 Courses in Liverpool

This course will allow you to explore the potential of self-service business intelligence using Power BI Desktop to analyse and connect to different sources of data, creating Relationships between those different datasets, Query the data using Shaping and data Modelling, to create Visualizations, and publish Reports to different platforms . Course Objectives At the end of this course you will be able to: Connect to data from different sources. Use the Query Editor Perform Power BI desktop data Shaping and Transformation. Create Power BI desktop Modelling. Create Power BI desktop Visualizations and Reports. ' 1 year email support service Take a closer look at the consistent excellent feedback from our growing corporate clients visiting our site ms-officetraining co uk With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level and Business Intelligence. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses. Our competitive rates start from £550.00 per day of training Tailored training courses: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Please visit our site (ms-officetraining co uk) to get a feel of the excellent feedback our courses have had and look at other courses you might be interested in. Introduction to Power BI Power BI Jargon explained A quick look at Power BI Desktop A quick look at the Power BI service Helpful resources Power BI and Excel Introduction to using Excel data in Power BI Upload Excel data to Power BI Import Power View and Power Pivot to Power BI Getting started with Power BI Desktop Overview of Power BI Desktop Accessing Help and Helpful resources Connect to data sources in Power BI Desktop Shaping and Transforming Data with Query Editor Introduction to the Query Editor Data Sources Power BI Desktop can Connect to Introduction to Steps and M code Combining Data Using Merge and Append Queries Data Type Properties Working with Delimiters Clean and transform your data with the Query Editor Text Specific Transformation Tools Number Specific Transformation Tools Date Specific Transformation Tools Split and Merge columns Creating an Index Column Adding Conditional Columns Columns From Examples Grouping and Aggregating data Pivoting and Unpivoting Using filters Modeling the data Introduction to modeling your data How to manage your data relationships Create calculated columns Optimizing data models Create calculated measures Show Values As and Quick Measures Create calculated tables Explore your time-based data Introduction to DAX DAX calculation types DAX functions Visualizations Introduction to visuals in Power BI Create and customize simple visualizations Modify colors in charts and visuals Shapes, text boxes, and images Page layout and formatting Group interactions among visualizations Visual hierarchies and drill-down Using custom visualizations Create a KPI Visualization Geo-Data and Maps Reports, Publishing and Sharing Introduction to the Power BI service Quick insights in Power BI Create and configure a dashboard Ask questions of your data with natural language Create custom Q&A suggestions Share dashboards with your organization Introduction to content packs, security, and groups Publish Power BI Desktop reports Print and export dashboards and reports Create groups in Power BI Use content packs Update content packs Publish to web Who is this course for? Who is this course for? This course facilitates you with knowledge on the potential for Power BI Desktop to analyse and connect to different sources of data, creating Relationships between those different datasets, Query the data using Shaping and data Modelling, and to create Visualizations, and publish Reports to different platforms. Requirements Requirements Before attending this course, delegates should have: - A general knowledge of database concepts (fields, records and relationships) - Familiarity with Excel. Career path Career path Business Intelligence Data Analysis ETL & Data Warehousing

IPAF training is the most widely recognised standard for Mobile Elevated Work Platform operators. These are commonly known as MEWP’s or Scissor Lifts and Cherry Pickers. MHA Training is a fully approved and registered IPAF member and we can deliver a wide range of courses. This can be done at our training centre in Warrington or On-Site at customer premises Nationwide. The International Powered Access Federation (IPAF) promotes the safe and effective use of powered access worldwide. Set up in 1983, IPAF is a non-profit organisation that represents the interests of member training companies. Over the years, IPAF has played a key role in promoting many of the design safety and testing procedures that are now established in the powered access industry. Companies such as MHA Training in Warrington are responsible for training for over 90,000 operators each year. Those who successfully complete their training at our centre in Warrington, or out On-Site nationwide are awarded the PAL Smart card. The (Powered Access Licence) is the most widely held and recognised qualification for mobile platform operators. The PAL Smart card is valid for five years and shows the machine categories that an operator has been trained on. It also features the holders photo and signature, and can be verified on their website. IPAF itself does not provide any training, it is provided by approved quality training centres like MHA Training. Approved training centres are regularly audited by IPAF, which ensures the highest standards are consistently met. Class sizes are kept small and courses generally last 1-2 days and are a mixture of theory and practical. To ensure success candidates must then undergo a 30 question multiple choice paper and a practical test. Course material is available in many languages and training centre’s receive regular updates. MHA Training was established in 2008 based at our training centre in Warrington, Cheshire. We provide an array of services On-Site also for clients around the North West in areas such as Manchester, Liverpool, Widnes, St. Helens, Runcorn, Wigan, Preston and Leeds. Over the years we have expanded and have instructors available Nationwide. IPAF E-Learning. IPAF’s new E-learning module is part of its full training programme for mobile elevating work platforms (MEWPs). The E-learning module delivers flexibility and interactive tools, with the same emphasis on practical training. Together with supervised written and practical testing of operator skills. E-learning can lead to a PAL Card (Powered Access Licence) which proves that the operator has successfully completed the training and is able to operate MEWP’s safely. Benefits: Flexible. Trainees complete the theory part anytime, anywhere, on any device, at their own pace. Interactive. Engages trainees with games, quizzes, videos and simulations. Operator E-learning does not replace practical training. Trainees who complete the online session must still pass a supervised theory test with an IPAF centre like MHA training. Also must successfully complete a minimum half-day of practical training and testing before being issued a PAL Card as proof of successfully completed operator training. Training Courses Available: Operators. Demonstrators. Static Boom (1b). Mobile Vertical (3a). Mobile Boom (3b). Push Around Vertical (PAV). Other courses: Harness Use and Inspection (H).

Behavioural Foundation Course. The foundation course is a great opportunity to learn about your dog’s needs.

RSPH level 2 Identifying and Controlling Food Allergy Risks Training Course Do you need an allergy trainer to come to your food business and teach your staff face to face about food and drink allergens, their dangers and how to control them? Our allergy trainer can come to your business and deliver this course at your business premises. Although we are based in London, we are happy to travel and deliver this course at your business location. (Trainer travel fees may be applicable depending on your location). Staff will receive interactive training and coaching on allergens and intolerances with an experienced trainer. We can also tweak the training to include issues you would like to cover. See our website for more details. Special offer for on-site allergy training. £250 plus £20pp includes RSPH exam fees (usually £350 plus £30pp) This course is suitable for any catering business such as restaurants, pubs, hotels, cafes, catering companies, cooks, self employed, artisans, event caterers and more. This course is also important for staff who are Front of House, who take customer orders and relay the orders to cooks and chefs and other people who are preparing food for customers who have allergies and or intolerances. This is a short one day training course, typically 9am-3pm. Topics covered include- Allergens, Allergen Identification, Cross contact, Cross Contamination, Allergic Reactions, Food Intolerances, Coeliac, Anaphylaxis, Natasha's Law, UK Food Safety Regulations, Allergy Controls, Substituting ingredients, Customer Communication and what to do in an Emergency. Contact us to book training.

About this Virtual Instructor Led Certificate Training Course (VILT) Asset maintenance and equipment reliability teams play a significant role to ensure that there is no room for downtime and losses in production. They are often recognised for their contribution and ability to keep assets running productively in today's organisations. The Certificate in Asset Management Virtual Instructor Led Training (VILT) course will provide those involved in Asset Management with a full explanation of the key processes to manage assets across their lifecycle. This recognised VILT course has been designed to equip participants with practical skills to take back to work. This VILT course enables participants to ensure their organisation's assets are realising their full value in support of the organisation's objectives. Accredited by the Institute of Asset Management (IAM), this VILT course will prepare participants to sit for the IAM Asset Management Certificate qualification. The IAM exam is offered as an option for participants of this VILT course. Training Objectives By the end of this VILT course, participants will be able to: Understand the key principles, tools and terminology of Asset Management, and demonstrate how it will benefit your organisation Gain familiarity in the application of ISO 55000 in practice Access a range of models that will support the implementation of asset management in your organisation Assess your understanding of the current tools and concepts applied in Asset Management Capture new ideas and skills that will enhance performance and be better prepared for the Institute of Asset Management (IAM) Certificate Examination Target Audience This VILT course will benefit maintenance managers, operations managers, asset managers and reliability professionals, planners and functional specialists. It will also be useful for facilities engineers, supervisors/managers and structural engineers/supervisors/ and managers. IAM Qualifications Syllabi This document details the scope of the individual topics which comprise the examination modules, and how the exams are assessed. It is important that prospective candidates understand the scope of the modules to determine the preparation required. Download here IAM Qualifications Candidate Handbook This handbook provides more detailed information on registering as a candidate, learning resources, training courses, booking an exam, exam regulations and what happens after an exam - whether you are successful or unsuccessful. Download here Course Level Basic or Foundation Training Methods The VILT course will be delivered online in 5 half-day sessions comprising 4 hours per day, with 2 breaks of 15 minutes per day. Course Duration: 5 half-day sessions, 4 hours per session (20 hours in total) Other than world-class visuals and slides, this VILT course will include a high level of interaction between the facilitator and participants and group discussion among the participants themselves. There will be a number of exercises & quizzes to demonstrate key points and to give participants the chance to apply learning and appreciate key aspects of best practice. Participants will also have the chance to share examples from their own experience, discuss real problems they are facing and develop actions for improvement when they return to work. Examples of the exercises that are used in this VILT course are as follows: Exercises: Aligning Assets to Business Objectives, Planning for Contingencies, Understanding Function and Failure. Group exercises: Asset Management Decision Making, Incident Review & Operations Optimisation. The workshop content will be adjusted based on the discussions, interests and needs of the participants on the course. Trainer Your expert course leader is a is a highly experienced in maintenance and turnaround specialist. He is a Chartered Mechanical Engineer, having spent 19 years working for BP in engineering, maintenance and turnaround management roles. During this time, he worked on plants at all ages in the lifecycle, from construction, commissioning and operating new assets to maintaining aging assets and decommissioning. He has taken roles in Projects, Human Resources and Integrity Management which give real breadth to his approach. He also specialized in Continuous Improvement, gaining the award of International Petrochemical Coach of the year. He stays up to date with the latest industrial developments through his consulting support for major clients. He is also the Asset Management lead and a VILT specialist, having delivered over 70 days of VILT training in the last year. He has an engaging style and will bring his current industrial experience, proficiency of VILT techniques and diverse content, gathered from a comprehensive training portfolio, to deliver a distinctive training experience. 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

Diabetes is serious. It can be life-threatening, however, people with diabetes can live long, healthy lives if their condition is kept well-controlled. In this training course, we explain what diabetes is and what to look out for. We cover how it is diagnosed and how to provide care and support to a person living with diabetes.

Mental capacity Act Dols training course

This is a specialist training course for senior managers or newly appointed safeguarding leads who are responsible for safeguarding adults from neglect and harm

Our Equality and Diversity Training course covers the Equality Act 2010 and discusses the details relating to discrimination as well as unfair treatment within a professional environment.

This confidentially & effective record keeping training course is aimed at assisting staff to understand what is expected of them regarding confidentiality, maintaining accurate up to date records and documents.