32807 Courses

OVERVIEW This official Microsoft Power BI training course will teach you how to connect to data from many sources, clean and transform it using Power Query, create a data model consisting of multiple tables connected with relationships and build visualisations and reports to show the patterns in the data. The course will explore formulas created using the DAX language, including the use of advanced date intelligence calculations. Additional visualisation features including interactivity between the elements of a report page are covered as well as parameters and row-level security, which allows a report to be tailored according to who is viewing it. The course will also show how to publish reports and dashboards to a workspace on the Power BI Service. COURSE BENEFITS: Learn how to clean, transform, and load data from many sources Use database queries in Power Query to combine tables using append and merge Create and manage a data model in Power BI consisting of multiple tables connected with relationships Build Measures and other calculations in the DAX language to plot in reports Manage advanced time calculations using date tables Optimise report calculations using the Performance Analyzer Manage and share report assets to the Power BI Service Prepare for the official Microsoft PL-300 exam using Microsoft Official Courseware WHO IS THE COURSE FOR? Data Analysts with little or no experience of Power BI who wish to upgrade their knowledge to include Business Intelligence Management Consultants who need to conduct rapid analysis of their clients’ data to answer specific business questions Analysts who need to upgrade their organisation from a simple Excel or SQL-based management reporting system to a dynamic BI system Data Analysts who wish to develop organisation-wide reporting in the form of web reports or phone apps Marketers in data-intensive organisations who wish to build visually appealing, dynamic charts for their stakeholders to use COURSE OUTLINE Module 1 Getting Started With Microsoft Data Analytics Data analytics and Microsoft Getting Started with Power BI Module 2 Get Data In Power BI Get data from various data sources Optimize performance Resolve data errors Lab: Prepare Data in Power BI Desktop Module 3 Clean, Transform And Load Data In Power BI Data shaping Data profiling Enhance the data structure Lab: Load Data in Power BI Desktop Module 4 Design A Data Model In Power BI Introduction to data modelling Working with Tables Dimensions and Hierarchies Lab: Model Data in Power BI Desktop Module 5 Create Model Calculations Using DAX In Power BI Introduction to DAX Real-time Dashboards Advanced DAX Lab 1: Create DAX Calculations in Power BI Desktop, Part 1 Lab 2: Create DAX Calculations in Power BI Desktop, Part 2 Module 6 Optimize Model Performance Optimize the data model for performance Optimize DirectQuery models Module 7 Create Reports Design a Report Enhance the Report Lab 1: Design a Report in Power BI Desktop, Part 1 Lab 2: Design a Report in Power BI Desktop, Part 2 Module 8 Create Dashboards Create a Dashboard Real-time Dashboards Enhance a Dashboard Lab: Create a Power BI Dashboard Module 9 Perform Advanced Analytics Advanced analytics Data Insights through AI Visuals Lab: Perform Data Analysis in Power BI Desktop Module 10 Create And Manage Workspaces Creating Workspaces Sharing and managing assets Module 11 Manage Datasets In Power BI Parameters Datasets Module 12 Row-Level Security Security in Power BI Lab: Enforce Row-Level Security

Prepare to amaze yourself, and your friends, with the beautiful canoe you will build here.. and Yes! You do take your canoe home with you when you leave. First Day The first stage in the process is to cut out the marine ply panels, and sew these together using cable ties as seen here. This is a fun stage, and you quickly see your canoe coming together. Children often opt to be involved at this stage. Not all children decide to be with us for the slower paced sections of the build. Second Day The second day is mainly taken up with cutting, planing, sanding and fitting the seats ( the Thwarts). At the end of the second day we aim to apply the first coat of resin, to the inside of your canoe, along with glassfibre tape ro reinforce the seams.  Third Day  Most of the third day is taken up with preparing the outside of your canoe for the resin and tape. This involves a lot of patient planing and sanding, The whole boat gets two coats of resin inside and out, and all the seams are reinforced with glassfibre tape on the outside too. If the weather is nice, we like to apply the resin outdoors, as seen here. View the full process here.

Bring your jewellery making to the next level with our Silver Clay Workshop! We're offering an indulgent, one-to-one workshop that will allow you to really get your hands dirty. You'll learn how to set stones in silver clay, as well as how to create filigree and patina your pieces. You've been playing with silver clay for a while now, and you're feeling confident in your current skills. You have a vision in your head of what you want to create, but you don't know how to make it come to life. This is a great opportunity for intermediate jewellery makers who want to take their skills to the next level—or for those who are just starting out and want some guidance from an expert.

Gain the knowledge and skills to manage ear wax buildup with our "Management of Ear Wax Training" course. Ideal for healthcare professionals.

THE NVQ HAS NO SET DATES. ONCE REGISTERED YOU WILL BE ENROLLED ON THE SYSTEM WITH COMPLETION TIMES BELOW What is an NVQ? An NVQ is a competence-based qualification. The qualification is an International recognised work-based qualification. Once qualified, it will demonstrate to employers that you are skilled and able to perform well in your role at work. This is where you will be able to demonstrate your ability at work and complete a list of job knowledge questions regarding the units in your qualification. It is the candidate’s responsibility to engage with the Assessor and gather the evidence that will match the assessment criteria in your NVQ.   How can the candidate gather the onsite/work evidence and job knowledge questions? Risk Assessment Method Statement Drawings Materials Measuring, Cutting, Positioning, and securing in place what you are installing.   Methods of ways of gathering evidence - Videos – this will be the candidate setting up their video and then demonstrating their skills and ability on site and then upload to the candidate’s portfolio. On site assessment - where your assessor will come out to you and observe you demonstrating your skills. This will depend on the site location and assessors’ location. If the site location is too far for the assessment to take place, it will be solely video evidence. Your Assessor will instruct you on how to complete your videos. Witness testimony - your Assessor will hold a recorded discussion with your manager/supervisor to confirm where, when and how you have completed the work to the specifications. Photos – They can be used as part of an assessment. They will not be accepted if the candidate isn’t in the photo. Photos cannot be used to build up a portfolio but can be used as part of the videos showing the full completed job and also in the Assessors on site assessment observation report.   Job Knowledge Questions account for 65% of the NVQ qualification. These can be saved to your computer and typed as this will be the quickest and easiest route or you can print them out and hand write them. They are very important, and they are written to see if you have the knowledge behind what you are doing on site or at work. The questions are all relevant to the work that you do.   What is the process? Speak to sales - billy@citytraining.com or 0300 373 3337 Complete the City Training Group Registration Form A copy of your photographic ID (Passport or Driving Licence) Once enrolled on the NVQ, your Online portfolio (Quals Direct) and certificate of registration will be set up. You will receive an email from the online platform with your username (your email address) and password. Arrange with your Assessor to complete your Induction. Complete your knowledge questions. Arrange with your Assessor your site assessment. Assessor will contact your Manager/Supervisor for a testimony. Recorded Professional Discussion with you to confirm your ability and authenticate your portfolio. Cost – Level 2 - £750 + Vat. If you would like to add an additional pathway, they would be £300 each added pathway. Level 3 - £950 + Vat. If you would like to add an additional pathway, they would be £300 each added pathway. Time Scale of the NVQ? The NVQ is candidate led. This will depend on how committed the candidate is and how much work the candidate has lined up. Your Assessor cannot complete you without the evidence. For a level 2, we aim to have the candidate completed in 4 – 8 weeks, Level 3 from 4 – 12/16 weeks

Come and enjoy a fun day baking in celebration of St Patrick's day with internationally renowned baker & author, Emmanuel Hadjiandreou.  

Barbering

About This VILT This 3 half-day course is designed to give a clear businessperson’s summary of the technological, market and economic/competitive issues around the key commodities which can be decarbonised through the use of clean hydrogen in their production. It will examine direct derivatives such as ammonia, methanol and synfuels, along with the impact clean hydrogen may have on the production and trading of other products such as green steel. Clear explanations will be given on technological pathways and key terminologies, in language accessible to non-engineers and commercial businesspeople. The positioning of these hydrogen derivatives in both current and potential future markets will be presented, framed with discussion around the economic and competitive factors which will determine market growth As well as explaining key concepts, the presented content will draw on current market examples, published models, scenarios and forecasts, and on fundamental physical and chemical constraints (for example illustrated by utilising simple calculations and quantifications). Download your brochure Email me the brochure TRAINING OBJECTIVES Upon completion of this VILT course, the participants will be able to: Review the key derivatives of hydrogen, with their market drivers Understand common terminology and technologies within the sector Quantify essential metrics and constraints to the production and trade of hydrogen derivatives Assess the role of clean ammonia in the future hydrogen supply chain Analyse the pathways to combine clean hydrogen with captured CO2 Understand how different policy mechanisms and end-use drivers will influence the growth and competition between different hydrogen derivatives Examine market and project examples, both current and planned Assess the impact of decarbonisation in key sectors such as shipping, aviation and power TARGET AUDIENCE This VILT course has been specifically designed for: Business developers Company strategy developers Investors Product and project management executives Policymakers and regulators Other commercial roles (e.g. marketing, regulatory etc.) Engineers or technical people entering new roles / new to the subject COURSE LEVEL Intermediate TRAINING METHODS The VILT will be delivered online in 3 half-day sessions comprising 4 hours per day, including time for lectures, discussion, quizzes and short classroom exercises. Additionally, some self-study will be requested. Participants are invited but not obliged to bring a short presentation (10 mins max) on a practical problem they encountered in their work. This will then be explained and discussed during the VILT. A short test or quiz will be held at the end the course. TRAINER Your Expert Course Instructor is an internationally renowned energy communicator and business educator, focused on the interconnected clean energy transition topics of renewable power, energy storage, energy system electrification and hydrogen. His own independent technology tracking, market assessment and opportunity/risk analysis is delivered to clients through a mix of business advisory work, commissioned content, small-group training (online & in-person), and one-to-one executive coaching (online). In the hydrogen sector, he is currently lead consultant and trainer to the World Hydrogen Leaders network, and writer of their ‘This Week in Hydrogen’ news column. He is also co-presenter of the ‘New Energy Chinwag’ podcast, which regularly covers hydrogen-related issues. During more than 15 years as an independent energy expert, he has helped companies from large multinationals to innovative start-ups – totalling assignments in over 30 countries across 5 continents. Most recently, he has presented clean energy training in locations as diverse as Singapore, the UK, South Africa, The Philippines, the USA, Mexico, Spain and Dubai – and, in recent times of course, online to international audiences from across the world. Prior to this, he was Research Director for over 10 years at Informa, a $9 billion business intelligence provider; where he drove new market identification, analysis and project deployment work, and managed teams in the UK and US. He has a strong science background, holding a 1st Class Honours degree in Natural Sciences from the University of Cambridge, a PhD in Earth Sciences and a further Diploma in Economics & Sustainability from the UK’s Open University. Download your brochure Email me the brochure 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

Elevate your expertise in clean hydrogen derivatives - ammonia, methanol, and synthetic hydrocarbon with EnergyEdge's course. Enroll now for virtual instructor-led training!

Aimed for GP reception staff and HCAs, who work face to face booking patients in or HCAs doing the initial triage/observations. Receptionists and HCAs working in the urgent care setting or walk in centres may also find this beneficial as they also book patients in and monitor the waiting room.