1464 Model courses

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

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 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.

Dive deep into trap, fault, and seal analysis modeling for oil, gas, and CO2 with EnergyEdge course. Enroll in our classroom training today!

Learn how to use coaching techniques to support your learners to progress in their qualifcations or onto their next step in life.

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

Dive into the realm of Solar PV Systems Modelling and Analysis through EnergyEdge's course. Stay ahead in the field of renewable energy with expert training.

Learn the skills, knowledge and have the confidence to tackle difficult conversations in a productive way. Course overview Duration: 1 day (6.5 hours) Do you worry about how to give negative feedback or deal with performance issues? Are you concerned about giving bad news? This workshop is designed to give you the skills, knowledge and confidence to tackle these scenarios in a productive way. If you are a people manager, team leader or supervisor looking to make those challenging conversations less stressful and more effective, this workshop is for you. Lots of practical sessions will ensure you have the opportunity to relate your learning to your real life work situations. The one day session will use professional actors in the afternoon so that you can practice handling real-life challenging conversations. Objectives By the end of the course you will be able to: Deal with a wide range of challenging conversations Describe the preferred behavioural style for giving feedback State the most appropriate influencing technique to use in your situations Explain how to give successful constructive feedback Content What are challenging conversations What type of challenging conversations occur? Why do we find them challenging? Communication Practical exercise to demonstrate and act as a refresher of the fundamentals of communication Barriers to communication especially in a difficult discussion Choosing the right behavioural style Refresher of assertiveness and why it is important in this context Practical exercise demonstrating how behaviour breeds behaviour, and the impact of choosing an inappropriate style Steps to using assertive behaviour Influencing Cialdini’s model for influence How to use influencing techniques in handling challenging conversations Practical application Feedback Understanding feedback – positive vs. negative Using the ABCBC model for feedback Using the basics of emotional intelligence to give effective feedback Practical application Practical Activities Professional actors will work with you in small groups in the afternoon to practice real-life challenging conversations.

Overview Business modelling requires analysts to produce the quantitative models that top management uses to support their decision-making, but top management must also understand the strengths and weaknesses of the models if they are to use them effectively to support their decisions and robustly navigate the strategic negotiation landscape. This is particularly important for PPP projects where long-term commitments are made now based on bankability, value for money and risk allocation. During the course, participants will gain knowledge and skills on the frameworks, tools, and methodologies necessary to build quantitative models for financial decision-making in order to improve the financial viability and bankability of PPP projects. Participants will master modelling frameworks on capital budgeting, risk measurement, regression analysis and Monte Carlo Simulation among others.

Are you looking for something that will help you understand yourself and how to interact with others more effectively? Would you like something that uses a simple four colour model to quickly allow you to understand your personality type and how you can use this knowledge to enhance your relationships and reach your goals, whatever they are? We think that Insights Discovery might be just the thing for you! What's even better is that our Discovery bundle includes both a copy of your unique profile and a 90 minute personal session with our executive coach, Cami Rose, to chat it all through and set you up for success using your new knowledge for the future. Just request a session and we'll be in touch with the link that will allow you to complete the Insights evaluator and arrange your personal coaching session at a time to suit you. Want Discovery for your team? We can do that too. Leave us your name and details and we'll be in touch to chat through your needs and objectives.