21312 Courses

OVERVIEW Prerequisites—DIAD training or equivalent working experience This one-day course will cover using Power BI Desktop to import and shape data from a variety of sources. It will also walk through Power BI capabilities you can use to enhance the data model for your business users. The course covers key aspects of how to create a great data model to meet your business needs, various features in Power BI used to enhance data models so you can build great reports, and an introduction to DAX to create calculations. After completing this training, the attendees should be able to import data from a variety of data sources into Power BI, shape the data, create the data model, and write DAX functions to the Power BI model. COURSE BENEFITS: * Understand the Power BI Desktop data model, its components and most effective schemas * Describe concepts of calculated columns and measures * Create queries using M * Create calculations with DAX * Understand the use of functions * Create and optimize a data model * Understand the consequences of data model design decisions WHO IS THE COURSE FOR? * Power BI report developers who wish to improve the structure of their data models * Power BI report developers who wish to use advanced features like parameters and M coding in Power Query * Power BI practitioners who wish to optimise their models more effectively * Attendees wishing to prepare thoroughly for the DAX In A Day course COURSE OUTLINE Module 1 Getting And Shaping The Data * Understand what is meant by data model in the context of Power BI * Understand the consequences of data model design decisions * Understand consequences of Power BI’s data type handling * Understand data connection options Module 2 Basic Data Modelling * Understand basic data modelling * Understand basic data model types * Explore dimension tables and fact tables * Explore data connections Module 3 Getting Started With M (Power Query Language) * Get introduced to M * Understand key components and syntax Module 4 Understanding Logic Operators * Understand Transformations * Understand Join operation Module 5 Introduction To DAX * Get introduced to DAX and how can it be used * Understand working with parameters and DAX (lab combining the previous module) Module 6 Working With Functions - DAX CALCULATE And More * Understand working with functions * Understand the basics of the CALCULATE formula Module 7 Modelling With Power BI & DAX Best Practice * Gain familiarity with basic data modelling for business scenarios * Learn some best practices for working with Power BI

Learn all you need to know during this intensive half day’s training course for qualified facialist & beauty therapists only in small-scale classes. You must be qualified in Level 2 Facial or equivalent to be able to take part in this course. A great and very popular facial treatment to add to your treatment list that your clients will love. This treatment provides a deep exfoliation of the skin, with the added bonus of removing all that dreaded ‘peach fuzz’

City & Guilds 18th edition course with 2382-22 final exam only £234.00. Exams available every week across the UK, same day results, quick certificate, best prices..

City & Guilds 18th edition course with 2382-22 final exam only £234.00. Exams available every week across the UK, same day results, quick certificate, best prices..

Learning how to create handmade fans for your eyelash extension sets. Suitable for:  Those who hold a classic lash extension certificate  Extra's: TIME: 10am - 3pm Models: Doll training head What's Covered: * Introduction to Russian eyelash extensions  * Health & safety & hygiene  * How to create fans * Check list  * Styles of lashes  * What effects lashes * Pre/post treatment advice *  Equipment and products  * Consultation  * Application  * Removal Trouble shooting  * And so much more! Extra's * Basic business start up support  * Social media tips  * Ongoing support * Small Groups (Max 6) 

During this 12 week course you will have the opportunity to work on your own project ideas to explore your different media choices.

City & Guilds 18th edition course with 2382-22 final exam only £234.00. Exams available every week across the UK, same day results, quick certificate, best prices..

City & Guilds 18th edition course with 2382-22 final exam only £234.00. Exams available every week across the UK, same day results, quick certificate, best prices..

The one day stone carving class enables the general public to experience the art of hand carving stone. The class is designed for the beginner and every one will take home a hand carved Yorkshire rose. This class is held in a well-equipped workshop.

Birmingham Settlement are running a programme of training sessions between April and July 2024. All sessions are half-a-day and are an excellent opportunity to learn about important topics, starting with Adult Safeguarding on the 18th April.  If you are interested in any of the courses or would like more information, contact our Trainer David Coombes via email david.coombes@bsettlement.org.uk [david.coombes@bsettlement.org.uk] or by phone 07399 560 766. Training Sessions: Adult Safeguarding April 18th 9.15am – 12.30pm (Sports & Community Centre, Kingstanding) Training will include: What is Adult Safeguarding? What is abuse? Categories of abuse. Those most at risk of abuse. Identifying the signs of abuse. Taking safeguarding action. The issue of client consent. Mental Health Awareness April 23rd 9.30am – 12.45pm (Nature & Wellbeing Centre, Ladywood) Training will include: Defining mental health and mental illness. Signs and symptoms of the most common mental health conditions. Identifying and responding to a mental health crisis. Maintaining positive mental wellbeing. How best to support mental health recovery. Trauma Informed Practice May 14th 9.30am – 12.45pm (Nature & Wellbeing Centre, Ladywood) Training will include: What is trauma? Symptoms of trauma. Impact of trauma on children. Understanding the impact of Adverse Childhood experiences. Key principles of trauma informed practice. Managing work stress and undertaking self-care. Professional Boundaries May 23rd 9.15am – 12.30pm (Sports & Community Centre, Kingstanding) Training will include: What are professional boundaries and why are they important? Professional vs Personal boundaries and how they differ. How trauma impacts personal power and the ability to establish boundaries. Signs of boundary violations. How boundaries support wellbeing. Conflict Resolution June 6th 9.15am – 12.30pm (Sports & Community Centre, Kingstanding) Training will include: Defining conflict and exploring the risks vs the benefits of conflict. Looking at anger and aggression. Understanding how the brain responds to threat and danger. Exploring the practical communication strategies effective in the prevention and de-escalation of conflict. Learning to respond rather than react. Equality, Diversity & Inclusion June 11th 9.30am – 12.45pm (Nature & Wellbeing Centre, Ladywood) Training will include: The Equality Act and protected characteristics. Different forms of discrimination. How ‘membership’ of specific groups might bring advantage or disadvantage. Understanding the ‘multi layered’ nature of discrimination. Understanding how diversity and inclusion can positively impact and change what we do. Dementia Awareness July 9th 9.30am – 12.45pm (Nature & Wellbeing Centre, Ladywood) Training will include: What is dementia? The different types of dementia. The signs and symptoms of dementia. Risk reduction strategies. Benefits of early diagnosis. Barriers to diagnosis, treatment, and support. How we can help. Disability Awareness July 18th 9.15 – 12.30pm (Sports & Community Centre, Kingstanding) Training will include: Defining disability, disability as a social construct, non-visible disabilities. Barriers facing those with disabilities and the positive actions and reasonable adjustments we all can make to create more inclusive and less discriminatory environments.