146 Courses in London

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

The course concentrates on management skills and techniques for creating an effective supervisory relationship and process. Emphasis is placed on interpersonal skills. Course Aims: • To provide participants with the skills necessary, knowledge and values that underpin effective supervision • Understand what supervision is • Describe the role of the supervisor • Describe how to develop other supervisors • Plan for effective supervision • Identify techniques to use during supervision sessions

About this Virtual Instructor Led Training (VILT) This 4 half-day Virtual Instructor Led Training (VILT) course presents the principles and best practices of portfolio management in the upstream (E&P) oil and gas industry. The VILT course is equally valuable for small independents, large integrated international companies and national oil companies. The VILT course consists of presentations, case studies, illustrative practical exercises and syndicate discussions. Particular emphasis is given to pragmatic portfolio management approaches and solutions which can be implemented swiftly without recourse to major investments in planning and portfolio management software. The VILT course will draw on examples from your expert course leader's 35+ years' experience in the oil and gas industry as an explorationist, upstream vice-president and management consultant. The VILT course handout will comprise softcopy slides used in the presentation and a softcopy workbook for the exercises. Participants will gain proficiency in portfolio management techniques, understand how and why to undertake this activity and be able to apply key concepts directly in the business of their teams / divisions. The VILT course will be presented over 4 half-days, using Microsoft Teams or Zoom and a proprietary set of VILT tools. Participants will be asked to complete a pre course questionnaire (PCQ) addressing their objectives and experience, and attend a session to familiarise themselves with VILT tools before course commencement.     Training Objectives To present the tools, concepts and principles of portfolio management To define the quantitative metrics which are used to describe projects in a portfolio To understand the benefits of portfolio management at different stages of the upstream business: in strategy development, opportunity screening, business development, drilling prospects, conducting appraisal of discoveries and developing fields To put portfolio management in the organisational context by describing the role of the portfolio management team and examining how value assurance (quality control) is best conducted on portfolio data for projects and assets To demonstrate how portfolio management contributes to improved business performance By the end of the VILT course, participants will understand: Key concepts and principles of portfolio management How to design a simple portfolio database and describe complex projects in a small number of objective metrics How to segment the portfolio into meaningful units How to use portfolio data in making business choices and decisions at the strategic and tactical levels The extent to which it is meaningful and reasonable to make comparisons across different portfolio segments How the portfolio management team can support the wider business in decision-making Target Audience This VILT course is specially designed for exploration and development geoscientists, E&P economists and finance staff, and E&P managers. Both technical and non-technical staff will benefit from the concepts presented. Companies are encouraged to send participants from different functions and seniority levels to gain great benefits especially those which would like to implement the concepts presented in this VILT course. Course Level Basic or Foundation 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. The VILT course will be presented in an interactive workshop format that allows for discussion. Course Duration: 4 half-day sessions, 4 hours per session (16 hours in total). Trainer Your expert course leader draws on more than 35 years of experience managing, reviewing and directing projects in all aspects of the exploration business: from exploration business development (new ventures), through prospect maturation and drilling, to the appraisal of discoveries. He has more than 30 years' experience with Shell International, followed by 10 years consulting to NOCs in Asia Pacific, Africa and South America and independent oil companies in the United Kingdom, continental Europe and North America. Other than delivering industry training, he has worked on projects for oil & gas companies of all sizes, including independents, national oil companies and (super)-majors, private equity firms, hedge funds and investment banks, and leading management consulting firms. He is an alumnus of Cambridge University. He has M.A and Ph.D. degrees in geology and is a Fellow of the Geological Society of London as well as a respected speaker on management panels at international conferences. Professional Experience Management consultancy & executive education: Advice to investment banks, businesses and major consulting firms. Specialist expertise in upstream oil & gas, with in depth experience in exploration strategy, portfolio valuation and risk assessment. Leadership: Managed and led teams and departments ranging from 3 - 60 in size. Provided technical leadership to a cadre of 800 explorationists in Shell worldwide. Member of the 12-person VP team leading global exploration in Shell, a $3 bln p.a. business and recognised as the most effective and successful among its industry peers. Accountability & decision-making: Accountable for bottom-line results: in a range of successful exploration ventures with budgets ranging from $10's million to $100's million. Made, or contributed to, complex business decisions / investments, taking into account strategic, technical, commercial, organisational and political considerations. Corporate governance: Served as non-executive director on the Boards of the South Rub al Khali Company (oversight of gas exploration studies and drilling in Saudi Arabia) and SEAPOS B.V. (exploration deep-water drilling and facilities management). Technical & operations: Skilled in exploration opportunity evaluation, the technical de risking of prospects, portfolio analysis and managing the interface between exploration and well engineering activities. Unparalleled knowledge of the oil and gas basins of the world, and of different operating regimes and contractual structures, ranging from Alaska, Gulf of Mexico and Brazil, through to the Middle East, former Soviet Union, Far East and Australia. Safety: Following an unsatisfactory audit, became accountable for safety performance in Shell's exploration new ventures. Through personal advocacy and leadership of a small team, delivered pragmatic and effective HSE systems, tools and staff training / engagement and a dramatically improved safety record. R&D: Experience in the 3 key roles in R&D: scientific researcher, research manager, and 'customer' for R&D products. After re-defining Shell's exploration R&D strategy, led the re-structuring of the R&D organization, its interface with 'the business' and approaches to deployment and commercialization. Strategy: Accomplished at formulating competitive strategies in business, R&D and technology deployment, translating them into actionable tactics and results. Defined the exploration strategy of PDO (a Shell subsidiary in Oman) and latterly of Shell's global exploration programme. Professional education, behavioural/motivational coaching: Experienced in organisational re-design, change management, leadership education and talent development. Commercial skills: Personally negotiated drilling compensation claims, educational contracts and E&P contracts, with values of $5 million to $100+ million. 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

Dashboards will summarize and present the key indications of large data in an attractive visual display, hightlighting the most important trends so the most imporatnf aspects of data could could be seen in a snap second by glancing at attractive, colourful charts. PowerPivot helps analyze the data and brings new capabilities to business users to analyse, explore and gain new insight into business and marketing data. Power Pivot help analyze and understand the growing quantities of data that are created on a daily basis.

About this training course This 5 full-day course provides a comprehensive understanding of all the commissioning and start-up activities of all electrical equipment including transformers, switchgear, induction and synchronous motors, generators and auxiliaries. All commissioning activities are covered in detail in this course. This includes all the commissioning procedures and documents, purpose of commissioning, responsibilities, system description, documentation, testing and commissioning schedules, test reports, safety, certification, and plant completion report. The course provides also a thorough understanding of all the commissioning requirements for transformers, switchgear, induction and synchronous motors and, generator and auxiliaries including its switchgear equipment, switchgear, and transformers. All the stages of the commissioning procedure are covered in-depth in this course. This includes preparation - planning various activities, pre-commissioning checks and tests, typical commissioning schedule, detailed tests and commissioning procedures for every type of transformers, switchgear, induction and synchronous motors, and generators and auxiliary systems, instrumentation, trial run of the equipment, safety and precautions, commissioning of electrical systems, Safety Rules Clearance Certificates, procedure for the control and handling of defects, Commissioning Reports. This course is a MUST for anyone who is involved in the pre-commissioning or commissioning of any electrical equipment because it provides detailed pre-commissioning checks and tests and detailed tests and commissioning procedures for every electrical equipment. In addition, the course provides in-depth coverage of all preparation, planning activities, commissioning schedules, trial run of each electrical equipment, safety and precautions, Safety Rules Clearance Certificates, Procedures for handling defects, and Commissioning Reports. Training Objectives Pre-Commissioning Checks and Tests, Detailed Tests and Commissioning Procedures and Instructions for all Electrical Equipment: Gain a thorough understanding of all pre-commissioning checks and tests, and all commissioning procedures and instructions for all electrical equipment Commissioning Procedures, Documents, and Certification of Electrical Equipment: Discover the benefits of the Commissioning Management System of electrical equipment including all commissioning procedures and documents, purpose of commissioning, responsibilities, system description, documentation, testing and commissioning schedules, test reports, safety, equipment certification, and commissioning completion report Commissioning Procedures for Transformers: Learn about the commissioning procedures for transformers including functional checks, pre-commissioning tests, commissioning tests, and records. Commissioning Procedures for Switchgear Assemblies: Gain a thorough understanding of all the commissioning procedures for switchgear assemblies including substation commissioning, electrical testing, code requirements, safety rules, grounding and shorting, high power testing, NETA acceptance testing procedures, test values analysis, and commissioning forms Commissioning Procedures for Generator and Auxiliaries: Discover all the commissioning procedures for generator and auxiliaries including generator, seal oil system, hydrogen gas system, stator water system, rolling and payment of generator Commissioning Procedures and Instructions for Generator Electrical Equipment: Learn about all the commissioning procedures and instructions for generator electrical equipment including switchyard equipment, switchgear, transformers, and motors Code Requirements for Commissioning Electrical Equipment and Systems: Learn about the code requirements for commissioning transformers, switchgear, inductions and synchronous motors, and generators and auxiliaries Target Audience Engineers of all disciplines Managers Technicians Maintenance personnel Other technical individuals Course Level Basic or Foundation Training Methods Your specialist course leader relies on a highly interactive training method to enhance the learning process. This method ensures that all participants gain a complete understanding of all topics covered. The training environment is highly stimulating, challenging, and effective because the participants will learn by case studies which will allow them to apply the material taught to their own organization. Each delegate will receive a copy of the following materials written by the instructor: 'ELECTRICAL EQUIPMENT HANDBOOK' published by McGraw-Hill in 2003 (600 pages) ELECTRICAL EQUIPMENT COMMISSIONING MANUAL (includes practical information about all pre-commissioning checks and tests, typical commissioning schedule, detailed tests and commissioning procedures and instructions for all electrical equipment - 500 pages) Trainer Your specialist course leader has more than 32 years of practical engineering experience with Ontario Power Generation (OPG), one of the largest electric utility in North America. He was previously involved in research on power generation equipment with Atomic Energy of Canada Limited at their Chalk River and Whiteshell Nuclear Research Laboratories. While working at OPG, he acted as a Training Manager, Engineering Supervisor, System Responsible Engineer and Design Engineer. During the period of time, he worked as a Field Engineer and Design Engineer, he was responsible for the operation, maintenance, diagnostics, and testing of gas turbines, steam turbines, generators, motors, transformers, inverters, valves, pumps, compressors, instrumentation and control systems. Further, his responsibilities included designing, engineering, diagnosing equipment problems and recommending solutions to repair deficiencies and improve system performance, supervising engineers, setting up preventive maintenance programs, writing Operating and Design Manuals, and commissioning new equipment. Later, he worked as the manager of a section dedicated to providing training for the staff at the power stations. The training provided by him covered in detail the various equipment and systems used in power stations. In addition, he has taught courses and seminars to more than four thousand working engineers and professionals around the world, specifically Europe and North America. He has been consistently ranked as 'Excellent' or 'Very Good' by the delegates who attended his seminars and lectures. He written 5 books for working engineers from which 3 have been published by McGraw-Hill, New York. Below is a list of the books authored by him; Power Generation Handbook: Gas Turbines, Steam Power Plants, Co-generation, and Combined Cycles, second edition, (800 pages), McGraw-Hill, New York, October 2011. Electrical Equipment Handbook (600 pages), McGraw-Hill, New York, March 2003. Power Plant Equipment Operation and Maintenance Guide (800 pages), McGraw-Hill, New York, January 2012. Industrial Instrumentation and Modern Control Systems (400 pages), Custom Publishing, University of Toronto, University of Toronto Custom Publishing (1999). Industrial Equipment (600 pages), Custom Publishing, University of Toronto, University of Toronto, University of Toronto Custom Publishing (1999). Furthermore, he has received the following awards: The first 'Excellence in Teaching' award offered by PowerEdge, Singapore, in December 2016 The first 'Excellence in Teaching' award offered by the Professional Development Center at University of Toronto (May, 1996). The 'Excellence in Teaching Award' in April 2007 offered by TUV Akademie (TUV Akademie is one of the largest Professional Development centre in world, it is based in Germany and the United Arab Emirates, and provides engineering training to engineers and managers across Europe and the Middle East). Awarded graduation 'With Distinction' from Dalhousie University when completed Bachelor of Engineering degree (1983). Lastly, he was awarded his Bachelor of Engineering Degree 'with distinction' from Dalhousie University, Halifax, Nova Scotia, Canada. He also received a Master of Applied Science in Engineering (M.A.Sc.) from the University of Ottawa, Canada. He is also a member of the Association of Professional Engineers in the province of Ontario, Canada. 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 post training support and fees applicable Accreditions And Affliations

Python Course, code the Hangman. Basic Python Course covers in one hour the coding of an interesting app. Any one very welcome. Our Style: Hands-on, Practical Location: Online, Instructor-led Download: anaconda.com Duration: 1 Hour Times: arrange a time for your time zone

Airline Cabin Crew also known as: Air Hostess, Flight Attendant and Stewardess. This intensive class based – 10 weeks, part-time (lessons once a week) course will give you all information and tools you will need to succeed. Enter the world of possibilities, adventure and travel with leading Airline Cabin Crew course Provider in the UK. Flight Attendant, Cabin Crew, Stewardess, Air Hostess – Regardless of what this career is called in your part of the world, we have the training program for you. Join the elite team of flight attendants and experience the thrill of flying while making a difference in people’s journey. Fly the world and get paid for it! Join our Airline Cabin Crew course and take the first step towards an exciting career in the skies. Our Airline Cabin Crew course is designed to make you ready for the job. This intensive class based 10 weeks (part time) Airline Cabin Crew course will give you all information and tools you will need to become successful job candidate. You will have one class per week for ten consecutive weeks. Our Aviation Team provide full support to each candidate who wish to become Airline Cabin Crew or start a career in Aviation. We provide A-Z guidance starting from before and after the course. Our graduates are flying around the globe and we are confident that we can help to make your dream a reality! 98% Employment rate after completion of the course. Who is a Flight Attendant? Flight attendant/Airline Cabin Crew/Stewardess/Air Hostess are the most visible, glamorous jobs of all airline employees. A Flight Attendant is someone whose primary duty is to ensure the safety and comfort of passengers during a flight. They are members of an aircrew team , who operate a commercial, business or even military aircraft while travelling domestically or internationally. Flight Attendant benefits: Getting paid for travelling the world Lifestyle Flexible Work Schedules Meeting Interesting People Free Food & Accommodation Excellent Compensation The uniforms Working Environment How to become Flight Attendant?Airline companies look for individuals who share their values and can act as ambassadors for the company’s brand. Airline Cabin Crew are the face of the airline company which means they deliver a fantastic service that makes airline world famous. Airline companies prefer candidates with knowledge of Cabin Crew role. Airline companies have selection day or online tests as a first stage of recruitment, after which, they will take a closer look at applicants CV, skills and experience. If you completed Airline Cabin Crew course at least 70 hours (we offer 90 hour training), your application will stand out and you can get an offer from the first round. You will be able to pass all tasks during interview process as you will have knowledge about Cabin Crew role. Student – Cabin Crew Flying Support Group As a market leading Airline Cabin Crew Training Company with a wealth of experience in Aviation, we constantly upgrading our course and going extra nautical mile to guide and support all our students to ensure they can reach their goals. Graduates who are already flying, offer their full support to us and new students. They share an insight of the airline they already fly with, and help new students through the process of joining them at that airline. It gives a flying start to a career to new learners. Why London Waterloo Academy? Top Airline Cabin Crew course provider in London 98% Employment rate after completion of the course Individual support on the journey from the course to a job placement With years of experience in Airline Cabin Crew industry, London Waterloo Academy has been recognised by major TV, radio channels who have invited our Aviation Team for expert advice or interview. We are recognised by major airline companies in Europe and overseas who have approached London Waterloo Academy to deliver internal cabin crew training, corporate training and to recruit our graduates as a result of their high qualification standards and knowledge. Our graduates are now flying with Etihad, Saudi Air, Hainan Airlines, Small Planet, British Airways, Qatar, EasyJet, Thomas Cook, Ryanair, Cubana de Aviación, Air France,Titan, Norwegian B737 Short Haul and many more. You will become a qualified Cabin Crew, meet the standards and requirements by employers globally On successful completion you will hold: Airline Cabin Crew certificate in Current Airline Training Standards and Equipment, TUI, British Airways or Virgin Atlantic certificates for the SEP (Safety Equipment & Procedures) training Exclusive class visit by Leading Airline Representatives (questions and answers sessions) Exclusive practical training with TUI, Virgin Atlantic or British Airways We will enhance your CV Successful students will get an exclusive VIP hangar tour and a private aircraft recognition certificate of attendance Guidance through the job application process (free of charge) Gain an insight into the airline selection process and final one-to-one interview The vast global experience of our instructors Great working relationship with Corporate Crew Solution This course has been developed in accordance with EASA PART-CC We have a community feel atmosphere where each individual values and respects one another. This may be the reason why our graduates, even those who have completed the course many years ago, continue to come back not only for a chat and a cuppa, but also to share personal issues, tell us of their experience and give us invitations, among many other reasons. Working together – Starting a new career isn’t easy and often it can seem like a lonely and impossible process. Our Aviation Department stays behind each learner, supporting every step of the way. We give you tools, skills and assistance you need to succeed. Our success, built on the success of our students and a long list of graduates with successful stories. How will you learn? The course based on theory and external practical classes with British Airways, Virgin Atlantic or TUI Aviation includes: Aircraft door operations and Passenger Evacuation drills from the crew seat. A320 slide decent, Fire and Smoke drills. Pilot Incapacitation and Immediate Care drills including CPR and Defibrillator training. Course Entry Requirements: English Language at B2 (CEFR) level or above. We accept a huge range of international qualifications so don’t worry. Pop in for a chat with us if you’re unsure (or drop us a line – info@waterlooacademy.co.uk; or, if you prefer speaking to a human voice, +44(0)7484 014980). This is quite important because, for better or for worse, English is the international language. Therefore, your future fly-mates and customers would expect you to speak English. What if I speak broken English or have a strong accent? What can I do? Frantic mode ON. Don’t panic! As a multi-disciplinary Academy, we have a huge range of English language coursesclick here. Our English Language Department is one of the best in London. We are here to help. We won’t let you be deterred simply because of language issues. Courses can be combined, it will also boost your confidence when applying for the job or having an interview. What else do I need? Nothing! Our cabin crew course, as we’ve alluded before, is really good. We teach you everything you need to know from scratch. Since aviation is so different from other fields, we think, as long as you have the passion and determination, we are absolutely honoured to have you on board (pun most certainly intended)! Course dates (please choose one for your course): 15 May 2024 – 17 July 2024, Wednesday classes 18 September 2024 – 20 November 2024, Wednesday classes 14 November 2024 – 16 January 2025, Thursday classes Course duration – 10 weeks, once a week classes. Available Study mode – class based, Virtual (via Zoom) and hybrid Time – 10am to 5pm Registration fee for UK/EU candidates– £300 (includes: examination, Airline Cabin Crew certificate in Current Airline Training Standards and Equipment, participation certificate by TUI/British Airways or Virgin Atlantic in Introduction to SEP (Safety Equipment & Procedures, please note this is not a Cabin Crew attestation)) Tuition fee – £829 (we offer flexible payment plan and accept weekly instalments) International Candidates – Check if you need a UK visa here – £1,729 must be paid in full on registration. In case of visa refusal only £300 will be refunded.

High Performing Teams. Moccasin Approach, Moccasin Manager,

Powerful 1-hour Python workshop course understand Python Basics. Practical. Instructor-led. Online. Learn to code a Password Validator in 1 hour. 

Emotional Intelligence, EQ, EI, Moccasin Approach, Moccasin Manager,