938 Courses in London

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

A course designed for occupational health nurses. Updating on latest immunisation advice. giving a complete understanding of vaccinations, agendas, schedules, vaccine ingredients, contraindications and side effects.

BAG AND ACCESSORY DESIGN COURSE: WHAT IS THIS COURSE ABOUT?This fashion design course for beginners and intermediates is a group class aimed to support aspiring designers or designers in need of guidance in designing viable and realistic bags and/or accessories.This course enables you to understand essential skills required to become a fashion bag designer ans well as guiding you through the steps necessary for designing, developing, prototyping and manufacturing your collection. WHY THIS IS NOT THE USUAL ‘ACCESSORY DESIGN’ COURSEThis course is designed by a team of designers, prototype makers and handbag manufacturers.It is both a theoretical and practical introductory course which will teach you what the industry requires from designers in order to be able to understand and correctly translate their ideas into finished products.This course is focused on giving you an overview on the complexity and extensiveness of the process that designing handbags requires.The course will assist you in understanding the prerequisites before and during the design of your styles. This knowledge will enable you to circumvent a lengthy, costly, and occasionally frustrating process when it comes time to prototype and manufacture your collection. WHY WE CREATED A FASHION DESIGN COURSEAfter years of experience in designing and developing collections for our customers, we realised that there was a substantial lack of clear information available about what designing a collection of handbags and fashion accessories truly requires and how it is achieved.We created this course with the aim of helping the new generation of designers, as well as designers which are still struggling, in developing their ideas and empower them to clearly and correctly communicate them to whoever is going to prototype their collection.We essentially have created this tuition based on the needs and problems of our customers, hoping to promote and facilitate creatives in the realisation of their projects. WHO IS THIS COURSE FOR?This course is designed for aspiring designers and professionals seeking expert advice from the industry. It caters to those in need of guidance to optimise their design process or understand the nuances of working as a fashion accessory designer.No previous experience is required. WHAT WILL BE TAUGHT?The designing classes cover various topics, including:Preliminary considerations before designing on the role and skills of a designerUnderstanding the concept and use of a moodboardAnatomy of a handbag, including lining and hardwearImportance of construction and finishing optionsDifferences and purposes of illustrations vs technical drawingsSketching techniques, including drawing in perspective and technical drawingsProduct development for a specific designUnderstanding what technical information the prototype maker requiresOverview of the prototyping process HOW WILL THE ABOVE BE TAUGHT:The class will take place in person at our London studio and the lesson will alternate between theoretical lessons and practical exercises. INCLUDED IN THE COURSE:You will also receive access to a collection of handouts providing relevant information, useful resources and support in continuing your designing process independently.The handouts will contain:– A glossary containing essential key words related to the topic of the lesson– An illustrated glossary containing information about type of bags and bags’ features– Documents about leather types, finishings, tanning processes– Information about perspective and guides to be used as reference to develop your drawings– A list of recommended suppliers for both leather and fittings (physically in London and online)– A glossary containing information about leather types and characteristicsWHAT ARE THE ENTRY REQUIREMENTS?You should be able to use measurements and understand verbal and written English instructions. ARE THERE ANY OTHER COSTS? IS THERE ANYTHING I NEED TO BRING?Materials to exercise with are included.Feel free to bring a notepad, if you would like to take some notes, we will provide the rest.HOW LONG IS THIS TUITION?:This tuition will require up to 7.5 hours to complete but depending on the number of attendees, the ability of participants and the group’s pace, the syllabus may be covered in a shorter time frame.We aim to provide customised and high-quality tuition services and by only allowing max 6 students at a time, we are able to focus on each person needs and interests.As every student has a different level of ability and previous experience, this course might lead some students to complete the core aspects of the lesson in a shorter time frame than others.Students who complete the course early will be welcome to stay and use the studio facilities to exercise on the topics of the lesson.

Leadership and Management development, Leadership training, management training, Leadership development

This Beginners Hairdressing Course is ideal for those looking to be work-ready upon completion and have an internationally recognised qualification as well as a complete understanding of both Ladies Hairdressing & Barbering. You’ll receive both Ladies Hairdressing and Barbering training on this course and will be cutting hair on day 2! You’ll to learn the 9 Alan d Foundation haircuts, colouring and perming, roller-setting, clipper work, moustache trimming, wet shaving and much more.

FOUR DAY ATTENDENCE AND TRAINING GUIDELINE: DAY ONE AND TWO - INTRODUCTION TO DERMAL FILLERS Day one Arrive and coffees (10.00) Registration, introduction and expectations (10.00-10.15) Structure of the training (10.15-10.30) Break (10.30-11.00) Lectures and interactive workshops / simulation (11.00 - 1230pm) Health and safety in the workplace Sharps injury and disposal The consultation process and prescriptions LUNCH (1300-1730) with a coffee break Basic life support Anaphylaxis - recognition and management Emergency kits - what it should contain and how to buy one Your doctors on call - how to contact our on call doctors for emergency advice How to use Hyalase safely - when to use it / recognise mechanism of action, how prescription in an emergency works and how to give the hyalase Practical and to include demonstration of Hyalase injection Our added benefits services for safety and convenience Day two Arrive and coffees (10.00) introduction and expectations (10.00-10.30) Structure of the training (10.30-11.00) Formal written examination covering key areas of THEORY for Dermal Filler injections: Anatomy, Physiology, Products and Complications. This will highlight early on if any important areas need to be covered in more detail for the students (11.00 - 1200) - Break for lunch - Practical session commences - (12.30 - 1800) - and in total on average we have scope for one model per 30 minutes on both of the Dermal filler days, so that’s a potential for 10 in total for a class size of maximum 4, which will give good hands on experience, as the way we train is to allow several people the opportunity to be involved with each patient - e.g. splitting into the phases of treatment, which allows the trainees to understand the concept of the treatment process. That would be - consultation, consent, marking up, readying equipment, performing the injection, providing advice and aftercare. DAY THREE AND FOUR BOTOX FOUNDATION COURSE Day three Arrive and coffees (10.00) introduction and expectations (10.00 – 10.30) Structure of the training (10.30 – 11.00) Formal written examination covering key areas of THEORY for Botox Application: Anatomy, Physiology, Products and Complications. This will highlight early on if any important areas need to be covered in more detail for the students (11.00 - 1200) - Break for lunch - Practical session commences - (12.30 - 1800) - and in total on average we have one model per 30 minutes on both the botox and days, so that’s a potential of 10 in total for a class size of 4, which will give good hands on experience, as the way we train is to allow several people the opportunity to be involved with each patient - e.g. splitting into the phases of treatment, which allows the trainees to understand the concept of the treatment process. That would be - consultation, consent, marking up, readying equipment, performing the injection, providing advice and aftercare. Day four Observed Treatment Process Examination The participants will be tested on the following key facets of safe practical care: Consultation process - rapport and understanding what the client wants Safe consent Marking and photographs Technical skill of injection Atercare provision and safety netting (eg if this happens do this / call me) 1 model will be provided for Botulinum (3 area) treatment and 1 - 2 clients for filler to ensure that each of the key anatomical areas covered are observed. Morning = Botulinum (0900 - 1230) Afternoon = Botulinum and Option Dermal fillers (1330 - 1630) Conclusion Candidates given session and refreshments and discussion regarding Case Studies and further support. (1700 - 1800)

This module focuses on developing leadership confidence through self-discovery, emphasising the importance of understanding one's unique leadership style and personal philosophy. Participants will explore their core identity as leaders and learn strategies to enhance their influence, credibility, and relationships within their organisation. Exploring the link between self-discovery and effective leadership, focusing on developing confidence to lead from within. Testimonial: “Without guidance, personal branding can quickly become an exercise in aspiration and competition; letting the carefully curated public personas of others dictate our own validity and definition of success. Clarity on who we truly are, what matters to us and therefore how we position ourselves in the world takes reflection and time. Rachael’s work in this area has inspired the nearly 100 delegates who have been part of our HR Leadership Academy over the past 8 years, and I have no doubt will continue to resonate with future cohorts.” MD, Nina Metson - Suffolk

Aimed at those wanting to be work-ready upon completion, this Beginners Hairdressing Course is the perfect way to start your new career. You’ll be cutting hair on day 2! You’ll also have training on roller-setting, long hair, colouring, perming, client care, shampooing, blow-drying and salon protocol.

HIGHLY SOUGHT-AFTER AND ALREADY AN EXTREMELY LUCRATIVE INDUSTRY, LASER TATTOO REMOVAL IS SET TO BE THE BIGGEST BEAUTY TREND OF 2023!

HIGHLY SOUGHT-AFTER AND ALREADY AN EXTREMELY LUCRATIVE INDUSTRY, LASER TATTOO REMOVAL IS SET TO BE THE BIGGEST BEAUTY TREND OF 2023!