680 Model courses in London

This course is designed for students who already have foundational knowledge and skills in Excel and who wish to perform robust and advanced data and statistical analysis with Microsoft Excel using PivotTables, use tools such as Power Pivot and the Data Analysis ToolPak to analyze data and visualize data and insights using advanced visualizations in charts and dashboards in Excel.

The psychological insights and skills you need Knowing how to resolve conflict constructively is an essential life skill – improving personal and professional relationships, mental health, productivity and more… Accredited CPD Certificate : 6 hours Length 1 day (9.30am - 4.00pm) > Counts towards the Diploma – from 2024, this course will be a requirement of Part 1 of the HG Diploma. A fantastic approach that helps you unpack the issues, respond positively and find an effective solution that moves everyone forward... This course will: deepen your understanding of why conflicts develop and escalate, the psychological factors involved and the cultural and contextual influences on our perceptions, experience and responses to conflict build your confidence and comfort around being in situations that involve conflict give you a range of skills and techniques that you can use with both individuals and groups, in therapy or the workplace – or with your friends and family – to resolve conflict constructively It will also enable you to: help clients recognise conflict and understand their own responses to it help clients develop the skills to engage with conflict productively, so they are more likely to reach positive outcomes provide clients with a framework and structure for addressing conflict in a healthy way help clients become less fearful of conflict, so they don’t avoid it in ways that are unhelpful and to recognise the role of conflict in healthy relationships provide psychoeducation, explaining how barriers to needs can cause conflict and how this can be different in different cultural contexts The course is interactive and experiential, with a focus on developing practical and transferable conflict resolution skills. It combines trainer input, discussion, small group activities and role-play to build your confidence when helping to resolve conflict at all levels, whether one-to-one or in organisations. Why take this course Conflict isn’t always destructive. Properly handled it can be creative and productive, leading to better outcomes and possibilities for all. Although conflict is a normal, ever-present possibility in our lives – between family, friends, colleagues, neighbours, and in our interactions with organisations – when it becomes entrenched it can cause immense individual distress, and waste time and money. Addressing interpersonal conflict using the psychological insights, concepts and proven techniques you will learn on the day, helps us to solve problems creatively and improve the health and wellbeing of those involved. To lead a healthy life we don’t need to avoid all conflict, but we do need to know how to approach it in ways which can help everyone involved meet their emotional needs, a win/win for all. Learning the human givens approach to conflict resolution helps to reduce the potential damaging consequences of destructive conflict and embrace the benefits of constructive conflict. Throughout the day, Rupinder will draw on her own considerable practical experience of successful conflict resolution and mediation in a wide range of settings as she provides expert guidance and training in the psychological insights and skills you need to be able to constructively resolve conflict between individuals and/or groups. Addressing conflict in the right way helps us solve problems and improves the health and wellbeing of everyone involved... What the course covers The common causes of interpersonal conflict The negative impacts and potential benefits in conflict situations How to consider intentions and outcomes when engaging in conflict The different methods used to influence the outcome of conflict, and how the method influences the outcome What a resolution really is The cultural and contextual influences on perceptions, experience, and responses to conflict The role our innate needs and resources play in conflict situations Identifying our influence on the process of conflict Effective skills to engage people who are in conflict A practical, sequenced model for effective mediation and conflict resolution An effective framework for facilitating constructive conversations How to structure a session/s to: facilitate resolution, increase engagement, understanding and define the needs of all parties Effective skills to facilitate negotiations Techniques and diffusing strategies to reduce potential barriers How to access resources to build agreements that last The effective skills needed to facilitate negotiations How to implement opportunities in organisations to address conflict effectively Ways to develop your leadership ability to respond to conflict and/or support others who are enduring it How to use this to support the process of resolution by improving how individuals relate to one another and addressing the contentious issues constructively And much more… Course Programme The ‘Conflict Resolution’ course starts at 9.30am and runs until 4.00pm. From 8.30am Registration (Tea and coffee served until 9.25am) 9.30am Approaches to conflict 11.00am Discussion over tea/coffee 11.30am Understanding Causes and Impact 1.00pm Lunch (included) 1.45pm Increasing engagement 3.00pm Discussion over tea/coffee 3.15pm Reaching Resolution 4.00pm Day ends Who is this course suitable for? This course is for anyone wishing to understand more about the different ways conflict can affect us, or to feel more confident in a facilitation or leadership role when helping conflicted people It is also very relevant to anyone working in a supportive role – such as counsellors, psychotherapists, managers, HR staff, life coaches, Mindset Coaches, social workers etc. – as well as employees, customer service personnel and anyone working in schools and education. This course has been independently accredited by the internationally recognised CPD Standards Office for 6 hours of CPD training. On completion of this training you’ll receive CPD certificates from the College and the CPD Standards Office.

The BB Glow Facial is one of the newer facial treatments to reach the beauty market and is becoming an increasingly popular choice for many clients. A BB Glow Foundation Facial is a highly effective micro-needling treatment with immediate, lasting effects. This safe and intensive skin treatment can improve the facial tone and smooth out imperfections, freckles, and wrinkles. The treatment goal of using the micro-needle therapy system is to lighten and smooth the face's skin tone. In this course, you will learn how to create a semi-permanent foundation lasting for months, which hides facial imperfections. Learn the newest mesotherapy treatment loved by the world, which can also be available in your beauty salon. Course Entry Requirements:  This course is available for those that meet at least one of the following: Minimum 18 years NVQ Level 2 Beauty or equivalent desirable Good command of English Needling accredited training Course Pre-Study/Practical & Length: 20 hours of pre-study E-learning and 1 practical day Course Agenda This courses theory knowledge is delivered through our interactive e-learning training portal and completed with either: One day onsite training One day Zoom based training All courses are kept to a reduced size, with a maximum of six attendees per course. Areas covered in this course: Anatomy and physiology of face and skin The choice of colour for the type of skin Written documentation (treatment card) Photographic documentation The principles of hygiene Purpose of the treatment and the obtained effect Assessment of customer expectations Contraindications for BB Glow treatments Preparation of clients and positions for the procedure Application rules for anaesthesia Possible complications after treatments Types of pigments Insurance Practice: Practice on models Demonstration of the procedure on the model Enrolling in our BB Glow Foundation Training Course offers numerous benefits for students, as well as significant advantages for clients and potential earning potential. Let's explore these benefits in detail: Benefits for Students: Expertise in BB Glow Foundation: Our training course equips students with the knowledge and skills to master the BB Glow Foundation technique. You will learn the latest application techniques, colour theory, product selection, and client consultation. This specialised training will set you apart as a skilled BB Glow artist. Practical Hands-on Experience: We prioritise practical learning by providing extensive hands-on training opportunities. Under the guidance of experienced instructors, you will have the chance to practice the BB Glow Foundation technique on models. This practical experience will enhance your confidence and proficiency in delivering excellent results. Professional Advancement: By enrolling in our BB Glow Foundation Training Course, you are investing in your professional advancement. You will expand your skill set, stay updated with industry standards, and gain expertise in the popular BB Glow technique. This will enhance your professional reputation and open doors to new career opportunities. Benefits for Clients: Flawless and Radiant Skin: BB Glow Foundation is a popular semi-permanent makeup technique that creates the appearance of flawless, radiant skin. By enrolling in our training course, you will be able to offer this highly sought-after treatment to your clients. They will benefit from a semi-permanent foundation that evens out skin tone, hides imperfections, and provides a natural-looking glow. Time-saving Solution: Clients who opt for BB Glow Foundation can save time in their daily makeup routine. The semi-permanent nature of the treatment eliminates the need for daily foundation application, saving clients valuable time and effort. They can wake up with a fresh-faced look and feel confident throughout the day. Customised Results: As a trained BB Glow artist, you will have the expertise to customise the treatment to suit each client's skin tone and preferences. By selecting the appropriate pigments and adjusting the intensity, you can achieve personalised results that enhance the client's natural beauty. Clients will appreciate the tailored approach and individualized outcomes. Earning Potential: By offering BB Glow Foundation as part of your services, you can significantly increase your earning potential. The popularity of BB Glow treatments has been growing, and clients are willing to invest in achieving flawless, long-lasting skin. As a skilled BB Glow artist, you can attract a larger clientele and set competitive pricing for your services. Satisfied clients are more likely to become repeat customers and refer others, further boosting your earning potential. Enrolling in our BB Glow Foundation Training Course will not only benefit you as a student but also provide valuable advantages for your clients and potential earning potential in the beauty industry. Begin your journey toward professional excellence and financial success by enrolling today. Frequently Asked Questions (FAQ) about our BB Glow Foundation Training Course: Is this course suitable for beginners or those with prior experience? Our BB Glow Foundation Training Course is designed for both beginners and experienced professionals in the beauty industry. Whether you are new to semi-permanent makeup or already have a background in the field, our course will provide you with the necessary knowledge and skills to master the BB Glow Foundation technique. What qualifications or prerequisites do I need to enrol in the course? No specific qualifications are required to enrol in our BB Glow Foundation Training Course. However, a passion for the beauty industry and a desire to learn and improve your skills are highly recommended. Our course is open to anyone who wants to gain expertise in the BB Glow technique. Will I receive a certification upon completion? Yes, upon successfully completing our training course, you will receive a certification in BB Glow Foundation. This certification recognises your skills and expertise in performing the BB Glow technique. It can enhance your professional credibility and assist you in building your career in the beauty industry. What topics are covered in the course curriculum? Our course curriculum covers a wide range of topics related to BB Glow Foundation, including skin anatomy and physiology, product knowledge, colour theory, sanitation and hygiene, consultation and client assessment, application techniques, aftercare, and touch-up procedures. The curriculum is designed to provide a comprehensive understanding of the technique and its application. Are there any hands-on training opportunities? Absolutely! Our BB Glow Foundation Training Course includes extensive hands-on training sessions. You will have the opportunity to practice the BB Glow technique on models under the guidance of experienced instructors. This practical experience is essential to develop your skills and confidence in performing the treatment effectively. Will I have access to ongoing support after completing the course? Yes, we provide ongoing support to our students even after they complete the training course. Our instructors and support staff are available to answer any questions, provide guidance, and offer assistance as you embark on your career in BB Glow Foundation. We aim to support your continued growth and success. Are there financing options available for the course? We offer flexible payment options and financing plans to make our BB Glow Foundation Training Course more accessible. Please reach out to our admissions team for detailed information on available payment options and financing plans. If you have any additional questions or require further clarification, please feel free to contact us. We are here to assist you throughout your training journey and beyond. Course Benefits Benefits for Students Expertise in BB Glow Foundation: Our training course equips students with the knowledge and skills to master the BB Glow Foundation technique. You will learn the latest application techniques, colour theory, product selection, and client consultation. This specialised training will set you apart as a skilled BB Glow artist. Practical Hands-on Experience: We prioritise practical learning by providing extensive hands-on training opportunities. Under the guidance of experienced instructors, you will have the chance to practice the BB Glow Foundation technique on models. This practical experience will enhance your confidence and proficiency in delivering excellent results. Professional Advancement: By enrolling in our BB Glow Foundation Training Course, you are investing in your professional advancement. You will expand your skill set, stay updated with industry standards, and gain expertise in the popular BB Glow technique. This will enhance your professional reputation and open doors to new career opportunities. Benefits for Clients Flawless and Radiant Skin: BB Glow Foundation is a popular semi-permanent makeup technique that creates the appearance of flawless, radiant skin. By enrolling in our training course, you will be able to offer this highly sought-after treatment to your clients. They will benefit from a semi-permanent foundation that evens out skin tone, hides imperfections, and provides a natural-looking glow. Time-saving Solution: Clients who opt for BB Glow Foundation can save time in their daily makeup routine. The semi-permanent nature of the treatment eliminates the need for daily foundation application, saving clients valuable time and effort. They can wake up with a fresh-faced look and feel confident throughout the day. Customised Results: As a trained BB Glow artist, you will have the expertise to customise the treatment to suit each client's skin tone and preferences. By selecting the appropriate pigments and adjusting the intensity, you can achieve personalised results that enhance the client's natural beauty. Clients will appreciate the tailored approach and individualised outcomes. Earning Potential By offering BB Glow Foundation as part of your services, you can significantly increase your earning potential. The popularity of BB Glow treatments has been growing, and clients are willing to invest in achieving flawless, long-lasting skin. As a skilled BB Glow artist, you can attract a larger clientele and set competitive pricing for your services. Satisfied clients are more likely to become repeat customers and refer others, further boosting your earning potential. Enrolling in our BB Glow Foundation Training Course will not only benefit you as a student but also provide valuable advantages for your clients and potential earning potential in the beauty industry. Begin your journey toward professional excellence and financial success by enrolling today. Frequently Asked Questions Where is the Cosmetic College The Cosmetic College is located at: 3 Locks Court, 429 Crofton Road, Orpington, BR6 8NL How can I book? We have a few options for you to book. You can book by selecting an available training date above here on our website, by contacting us through email at hello@cosmetic.college or by contacting us on 0333 015 5117. Is a deposit required to book? All enrolments are charged an administration fee which is non-refundable. When you enrol you can elect to pay a deposit of 10% plus the administration fee or pay the total training course in full. We have full details of the terms and conditions of training course enrolments here Is this course suitable for beginners or those with prior experience? Our BB Glow Foundation Training Course is designed for both beginners and experienced professionals in the beauty industry. Whether you are new to semi-permanent makeup or already have a background in the field, our course will provide you with the necessary knowledge and skills to master the BB Glow Foundation technique. Will I receive a certification upon completion? Yes, upon successfully completing our training course, you will receive a certification in BB Glow Foundation. This certification recognises your skills and expertise in performing the BB Glow technique. It can enhance your professional credibility and assist you in building your career in the beauty industry. What topics are covered in the course curriculum? Our course curriculum covers a wide range of topics related to BB Glow Foundation, including skin anatomy and physiology, product knowledge, colour theory, sanitation and hygiene, consultation and client assessment, application techniques, aftercare, and touch-up procedures. The curriculum is designed to provide a comprehensive understanding of the technique and its application. Are there any hands-on training opportunities? Absolutely! Our BB Glow Foundation Training Course includes extensive hands-on training sessions. You will have the opportunity to practice the BB Glow technique on models under the guidance of experienced instructors. This practical experience is essential to develop your skills and confidence in performing the treatment effectively.  Will I have access to ongoing support after completing the course? Yes, we provide ongoing support to our students even after they complete the training course. Our instructors and support staff are available to answer any questions, provide guidance, and offer assistance as you embark on your career in BB Glow Foundation. We aim to support your continued growth and success.  Are there financing options available for the course? We offer flexible payment options and financing plans to make our BB Glow Foundation Training Course more accessible. Please reach out to our admissions team for detailed information on available payment options and financing plans. If you have any additional questions or require further clarification, please feel free to contact us. We are here to assist you throughout your training journey and beyond.

Customers are astute and well-practised in researching and seeking information, solutions and added value in the minimum number of clicks online. There's only so much time they're willing to spend carrying on clicking. This mentality isn't just restricted to the world of B2C. In our increasingly hectic world, where information is expected to be available instantly, it applies just as much to B2B. In this workshop, we look at how putting yourself in the shoes of your customer and mapping their decision-making and buying journey is critical to ensuring that you provide what they perceive as fast solutions and added value. You will learn all about the three pillars for creating competitive brand experiences: Customer engagement planning puts you firmly in the shoes of your customer, helping you to build meaningful marketing communications delivered through the right resources at the right time to inspire your customers to engage with you. This programme will help participants to: Understand the evolution of the customer buying journey Map a customer buying journey for your brand or solutions Understand the customer micro-moments and signals indicating interest and buying intent, both online and offline Apply the psychology of branding to build marketing communications with impact Develop sales and marketing content that differentiates your brand(s) from the competition by demonstrating unique value and how you can meet your customer's needs 1 The evolution of the customer journey Understand how the use of mobile has had an impact on the customer buying journey where today's customers can research and compare products and solutions whenever and wherever they like, making the purchase journey even less linear Explore how marketers are adapting to this new customer behaviour and drawing upon various strategies to win the hearts and minds of their audiences 2 The See-Think-Do-Care framework Explore the many different frameworks used to track the customer journey Understand and apply the modern marketing model, where the internet has enabled the customer to hop between multiple touchpoints before making a purchase decision 3 Customer micro-moments and signals in their buying journey Understand the online and offline moments when customers seek information to research and make buying decisions Apply this understanding to build a marketing communication plan to reach customers at all stages of their buying journey 4 The role of branding in the customer journey Explore the psychology of branding Learn how to ensure your branding is relevant to your target customer needs Bring together your brand value and story to achieve brand loyalty 5 The Why-How-What framework Apply a systematic approach to build a successful and compelling brand Understand how starting with 'why' will help build your brand purpose Apply the content marketing matrix to communicate your brand's value Apply the hero-help-hub model to build engaging content marketing Actionable outcomes We will use your brand examples to provide opportunities for practice: You will learn and reflect on best practice examples of customer engagement You will discover your brand value, purpose and the 'sweet spot' to drive engagement with your customers You will create a customer engagement plan that can be implemented immediately within your business You will receive immediate feedback on your customer engagement plan You will have the opportunity to share common issues and solutions with your colleagues in the group

The latest mind body research gives us profound insights into the effects on mental health of 'physical' factors, including breathwork and time in Nature, new ways to improve mental and physical health, and more… This wide-ranging day will deepen your knowledge of the mind-body system and the impact ‘physical factors’ can have on our emotions, state of mind and memory – with additional ways to help people quickly and effectively… Accredited CPD: 6 hours Length: 1 day (9.30am - 4.00pm) A brilliant framework to understand the neurobiology of our needs and how to manage stressDR ALLY JAFFEE, NHS DOCTOR Why take this course Having a deeper understanding of the latest research into the effects on mental health of ‘physical’ factors – such as movement and exercise, time in Nature, ‘breathwork’ and real-time connection with others – enables us to tailor powerful therapeutic interventions and deliver more informed psycho-education. This jam-packed day also covers the physiology of responses such as ‘freeze, fight or flight’, the effects of physical activity on emotional, mental, memory and brain health, why stress can become chronic, the many ways we can activate our innate capacity to restore calm through our breath and attention, why these relaxation techniques work and what they do for us physically. The findings you will explore on the workshop have implications for many areas of mental health, even addiction, and give us additional ways to help people resolve many difficulties quickly and effectively, as well as improve overall health. The HG approach recognises that meeting our emotional needs and using our resources well are key to good mental health – yet the impact of ‘physical’ factors on our emotions and state of mind can be just as profound. Even though our physical needs may appear obvious – a healthy diet, regular physical exercise etc – we know that most of the chronic diseases sweeping through the Western World are linked to “lifestyle”, indicating that many people are not actually meeting their physical needs in healthy balanced ways – despite the vast array of information available to them. Finding clarity about how best to meet our own physical needs can also help us maintain our capacity to help others. Throughout the day, Dr Andrew Morrice, a practising GP, draws on both the latest research and his decades of experience managing the complex combination of mental and physical health problems in General Practice (20 of those years using the Human Givens model). We will sift the sense from the nonsense, and see the fundamentals behind the buzzwords and trends, making it easier to think clearly about our own health as well as that of our patients or clients… Really insightful course with an amazing way into practical applications of the HG concepts...ALIYA DRAKE, HG THERAPIST What will you learn How the now well-known human ‘needs and resources’ relate to our evolutionary past, and physical lives The many ways physical movement affects the functioning of the mind and our emotions A deeper look into the physiology of emotional responses, such as ‘fight, flight, freeze’ and their impact on health Greater knowledge of the fundamentals of how we can find calm – and the very many ways these can be used to help people New information from the latest mind/body research that has implications for therapeutic lifestyle changes Also covered: What is ‘health’? And how do we get it? Key practices to support your own health, as well as your clients’ How to avoid the unhelpful psychology and aversive ‘pattern match’ that many of us have when it comes to ‘exercise’ Whether we can really be addicted to exercise and if so why? A deeper understanding about the role of “Green Space” in mental health Increased knowledge of the ways in which physical changes in the body contribute to emotional distress The many ways in which movement and physical activity are connected with mental health How thinking and moving, memory and place are inextricably linked Why stress becomes chronic (long-lasting) Greater clarity about the role some emotions play in creating physical ill health – and the powerful ways in which other emotional states promote health (including the key role of oxytocin) The science of the relaxation and oxytocin responses, and how these relate to many types of addiction, including smoking Organising ideas to understand how 6 different types of relaxation practice relate to each other A practical exploration of the many ways the relaxation response can be activated through breath and attention – including a new technique for dealing with panic Why some people may have come to believe that ‘the breathing’ can’t or won’t help them Summaries of the role of diet and sleep on our health – along with the factors considered today in ‘Therapeutic Lifestyle Change’ Time to ask our expert tutor questions and benefit from group discussions Course Programme The ‘The Mind-Body Connection in depth: Movement, Emotion and Calm’ course starts at 9.30am and runs until 4.00pm. From 8.30am Registration (Tea and coffee served until 9.25am) 9.30am What is health and how do we 'get it'? 10.45am Discussion over tea/coffee 11.15am The physiology of fear and calm 12.45pm Lunch (included) 1.30pm The physiology of rapport (and other topics) 2.45pm Discussion over tea/coffee 3.00pm Physical domains of mental health 4.00pm Day ends Who is this course suitable for? This course is open to anyone interested in mental and/or physical health If you enjoyed the original 1-day Mind-Body Connection course and would like time to explore in more detail the themes covered in the first half of that course, this new course is for you Please note:  you don’t need to have attended the previous Mind-Body Connection course to come on this one, or its sister course ‘Food, Mood and Sleep’. This course has been independently accredited by the internationally recognised CPD Standards Office for 6 hours of CPD training. On completion of this training you’ll receive CPD certificates from the College and the CPD Standards Office.

This 2-day workshop is offered with an internal and external focus. Day 1 will focus on building your internal network and relationships by focusing on your personal network, your brand, influencing skills and perceptions. Day 2 focuses on your external relationships with suppliers, patient groups etc. This will focus on assertiveness, outcome rather than relationship focus, and influencing and negotiating skills. DAY ONE 1 Can you succeed by yourself? 2 Relationship awareness theory 3 The Strengths Deployment Inventory / Your FACET5 profile 4 Building rapport 5 Influencing power bases 6 Active listening 7 Building your personal internal network 8 Perceptions 9 Your brand DAY TWO 3 Preparing for conflict 2 The negotiation conversation 1 Your stakeholders and what they want from you 4 Influencing others 5 Your communication approaches for success 6 Emotional Intelligence 7 The trust model 8 Knowing your outcomes

The 2-day Coaching and Mentoring for Managers course is designed for organisations that want their managers and team leaders to apply practical coaching and mentoring skills in everyday work situations in order to develop the performance of those they are responsible for, as well as improving communication within the business. Previous attendees have included chief executives, general managers, and HR managers, right through to production line supervisors and office staff. In fact, anybody that has to work as part of a team and relies on other people's efforts will benefit from this programme. Course Syllabus The syllabus of the Coaching and Mentoring for Managers course is comprised of four modules, covering the following: Module One Introduction to Coaching and Mentoring Exploding the myths surrounding coaching Benefits of coaching and mentoring The role of a coach and mentor How to avoid everyday interference that takes your time away from coaching people to achieve results How motivation works The difference between mentoring, coaching, directing, supporting & delegating, and learning when it is necessary to apply them Why coaching is an action orientated partnership purely focused on measurable results Coaching and mentoring outcomes Module Two Managing a Coaching Session The most important skills of a business coach The key characteristics of a good coach How to ask powerful coaching questions Opportunity to role-play using the STAR/GROW model Module Three Mentoring in Action Mentoring suggestions The first meeting Between first and second meetings The second meeting The Experiential learning cycle Model discussions Frequent questions asked by Mentors Duration of mentoring End of relationships Module Four Putting Learning into Practice Building a bank of great coaching questions Demonstration of what has been taught in a live coaching/mentoring meeting Individual feedback from a professional coach Creating SMART action plans Getting started as a work coach/mentor Group review and feedback on new learning Action steps for new coaches Scheduled Courses Unfortunately this course is not one that is currently scheduled as an open course, and is only available on an in-house basis. Please contact us for more information.

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

High quality specifications are of paramount importance in achieving the right technical performance and value for money. This long-established training programme has been developed to help those involved in producing specifications to create high quality documents in an organised and effective way. It provides a sound foundation for those new to the topic whilst at the same time offering new insights to those with more experience. The programme emphasises the need for a clear definition of requirements combined with the ability to communicate those requirements effectively to third parties. A structured method of preparing specifications is provided, and a range of practical techniques is presented, to enable participants to put the principles into practice. The commercial and contractual role of specifications is also addressed. The objectives of the workshop are to: Provide a clear understanding of the role and purpose of specifications Present a framework for organising and producing specifications Define the key steps involved in creating effective specifications Demonstrate methods for assisting in defining requirements Provide tools and techniques for scoping and structuring specifications Show the role of specifications in managing variations and changes to scope Present methods to assist the writing and editing of specifications Review how specifications should be issued and controlled DAY ONE 1 Introduction Review of course objectives Review of participants' needs and objectives 2 Creating effective specifications The role of specifications in communicating requirements The costs, benefits and qualities of effective specifications Understanding the differences between verbal and written communication The five key steps of 'POWER' writing: prepare-organise-write-edit-release Exercise: qualities of an effective specification 3 Step 1: Preparing to write - defining readership and purpose; the specification and the contract Designing the specifications required; applying BS 7373 Defining the purpose, readership and title of each document Effective procedures for writing, issuing and controlling specifications The roles and responsibilities of the key players Understanding contracts; the contractual role of the specification Integrating and balancing the technical and commercial requirements Writing specifications to achieve the appropriate contract risk strategy Deciding how to specify: when to use functional and technical specifications The role of specifications in managing variations and changes to scope 4 Case study 1 Teams review a typical project scenario and identify the implications for the specification Feedback and discussion 5 Step 2: Organising the specification content Defining the need and establishing user requirements Deciding what issues the specification should cover Scoping techniques: scope maps, check lists, structured brainstorming Clarifying priorities: separating needs and desires Dealing with requirements that are difficult to quantify Useful techniques: cost benefit analysis, QFD, Pareto analysis 6 Case study 2 Teams apply the scoping techniques to develop the outline contents for a specification Feedback and discussion DAY TWO 7 Step 2: Organising the specification content (cont) Deciding what goes where; typical contents and layout for a specification The three main segments: introductory, key and supporting Creating and using model forms: the sections and sub-sections Detailed contents of each sub-section Tools and techniques for outlining and structuring specifications 8 Case study 3 Teams develop the detailed specification contents using a model form Feedback and discussion 9 Step 3: Writing the specification The challenges of written communication Identifying and understanding the readers needs Choosing and using the right words; dealing with jargon Problem words; will, shall, must, etc; building a glossary Using sentence structure and punctuation to best effect Understanding the impact of style, format and appearance Avoiding common causes of ambiguity Being concise and ensuring clarity Choosing and using graphics to best effect Exercises and examples 10 Step 4: Editing the specification Why editing is difficult; how to develop a personal editing strategy Key areas to review: structure, content, accuracy, clarity, style and grammar Editing tools and techniques 11 Step 5: Releasing and controlling the specification Key requirements for document issue and control Final formatting and publication issues; document approval Requirements management: managing revisions and changes 12 Course review and action planning What actions should be implemented to improve specifications? Conclusion

Database Design and Data Normalization Course Summary Relational Databases & Data Normalisation Overview Training Courses London. Learn how to decide which tables and columns are required for a database, plan relationships, how to decide on data types and how to relate tables. Database Design and Data Normalization Course Description Session 1: Introduction to Relational Databases The Database Approach Database Management Systems The function of a Database Management System The Processing Architecture The Schema Architecture The Storage Architecture An overview of Database System Development An overview of general database principles Session 2: Conceptual Data Models Overview of Entity Models Entities and how to identify them Attributes and how to identify them Relationships and their qualities Building an Entity Relationship Diagram Resolving many-to-many relationships Sub-type and Super-type Relationships Arc Relationships Recursive Relationships Constraints and Assumptions Normalization to the First Normal Form (1NF) Normalization to the Second Normal Form (2NF) Normalization to the Third Normal Form (3NF) Exercises: Analyzing a specification Creating an Entity Relationship Diagram from it Session 3: The Relational Model Relational Structure Relational Terminology Domains A Relational schema Candidate keys and Primary Keys Foreign Keys Key Constraints Attribute Constraints Implementing Sub-type/Super-type Relationships Views Denormalization using Pre-joined Tables Denormalization using Derived Data An Introduction to Structured Query Language (SQL) Simple Queries Simple Updates of the Data Included in the Database Design and Data Normalization Courses: Database Design and Data Normalization Course Certificate on completion Database Design and Data Normalization Course Manual Practical Database Design and Data Normalization Course exercises, Database Course Homework / Database Course Revision work After the course, 1 free session for questions online Database Course via Gotomeeting.com. Max group size, online and in classroom, on this Database Course is 4.