114 Courses in London

What is Reggaeton? It is a blend of Jamaican music with Dancehall & Hip Hop, and the lyrics are mainly in Spanish. Reggaeton became popular in the early 90s within the Latin American you and spread to North America, Europe & Asia. The dancing is very engaging, smooth and versatile. You will experience a real workout, especially in your hips, shoulders and legs toning, it is the real deal!

First Aid at Work - Annual Refresher

This Health & Safety in the Care Sector Course works alongside, and helps, learners understand Standard 13 of the Care Certificate. This Standard touches on the legislation, policies & responsibilities relating to Health & Safety in the care sector, as well as looking at accidents and sudden illnesses.

The 2-hour Baby & Child First Aid class covers CPR, Choking, Bumps, Burns, Breaks, Bleeding, Febrile Seizures and Meningitis & Sepsis Awareness and will give everyone who attends the peace of mind they deserve.

Our *NEW* Mini First Aid Baby Proofing class is our second class, designed for parents and carers of babies and children over 3 months. It can be taken after our 2 hour Baby and Child First Aid class, or in isolation for those parents who are starting their weaning journey, or have a baby on the move!

This 2 - 2-5 hour course is designed is designed to provide parents and carers with the opportunity to: Develop the basic skills and knowledge needed to deal with a wide range of emergency paediatric First Aid situations, which could arise when looking after babies and children. The course can take place in in a community group or in the comfort of your home, with family and friends who maybe caring for your child or they may have children of their own. The course can be booked during the week, week nights or weekends, with or without children present. The idea is to bring the skills and knowledge to you, in your normal routine.

Are you ready to explore the depths of your EGO? Join us at Lekdanling - Tibetan Cultural Centre for a FREE course & meditation workshop on 12th of March to learn how to expand your heart and gain insight into the ways of the EGO. Don't miss out - sign up now! #WaysOfTheEGO #Meditation #ExpandYourHeart

Open to the presence of your heart and together we will journey beyond to the ancient worlds of uncover the hidden depths and ancient wisdom that lie within the heart of Ixcacao.

CORPORATE TRAINING There are currently 13 million women going through menopause in the UK. 4.3 million of them are aged between 45-55 years old, which is the fastest growing demographic in the workforce SB Wellbeing provides training for companies who are serious about providing support for their female staff going through menopause. Also, up-skilling managers and leaders on what they need to know.  Manager training includes what menopause is, how it can affect the individual at work, as well as the bigger picture of how it can impact the business, and how best to support them.    Colleague training is for anyone going through menopause or supporting someone who is. It's fully inclusive and highly interactive.  The two programmes can be run back to back or separately and be delivered via webinar or in-person. For more information and to book your training please get in touch. Here's what people are saying... " Thank you Sally for an amazing presentation yesterday – I had lots of the team say how good it was and how much they had learnt." - Leonard Design Architects, Nottingham "Just to say everyone absolutely loved training session 1!! The feedback from the second session was ace!! - Co-op Academy, Failsworth   "Open & frank conversation. Very factual and a great all round guide" - tp bennett, London   "The more staff that have this training the better, especially principle/director level." - tp bennett, London

This course starts with the basics then moves seamlessly to an intermediate level. It includes a comprehensive yet 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 use the online Power BI service. It looks at authoring tools that enables you to connect to and transform data from a variety of sources, allowing you to produce dynamic reports using a library of visualisations. Once you have those reports, the course looks at the seamless process of sharing those with your colleagues by publishing to the online Power BI service. The aim of this course is to provide a strong understanding of the Power BI analysis process, by working with real-world examples that will equip you with the necessary skills to start applying your knowledge straight away. 1 Getting started The Power BI process Launching Power BI Desktop The four views of Power BI Dashboard visuals 2 Connecting to files Connect to data sources Connect to an Excel file Connect to a CSV file Connect to a database Import vs. DirectQuery Connect to a web source Create a data table 3 Transforming data The process of cleaning data Column data types Remove rows with filters Add a custom column Append data to a table Fix error issues Basic maths operations 4 Build a data model Table relationships Manage table relationships 5 Merge queries Table join kinds Merging tables 6 Create report visualisations Creating map visuals Formatting maps Creating chart visuals Formatting chart Tables, matrixes, and cards Control formatting with themes Filter reports with slicers Reports for mobile devices Custom online visuals Export report data to Excel 7 The power query editor Fill data up and down Split columns by delimiter Add conditional columns Merging columns 8 The M formula Creating M functions Create an IF function Create a query group 9 Pivot and unpivot tables Pivot tables in the query editor Pivot and append tables Pivot but don't summarise Unpivot tables Append mismatched headers 10 Data modelling revisited Data model relationships Mark a calendar as a date table 11 Introduction to calculated columns New columns vs. measures Creating a new column calculation The SWITCH function 12 Introduction to DAX measures Common measure categories The SUM measure Adding measures to visuals COUNTROWS and DISINCTCOUNT functions DAX rules 13 The CALCULATE measure The syntax of CALCULATE Things of note about CALCULATE 14 The SUMX measure The SUMX measure X iterator functions Anatomy of SUMX 15 Introduction to time intelligence Importance of a calendar table A special lookup table The TOTALYTD measure Change year end in TOTALYTD 16 Hierarchy, groups and formatting Create a hierarchy to drill data Compare data in groups Add conditional formatting 17 Share reports on the web Publish to the BI online service Get quick insights Upload reports from BI service Exporting report data What is Q&A? Sharing your reports 18 Apply your learning Post training recap lesson