3134 Development courses in Glasgow delivered Live Online

Portfolio Management Skills: In-House Training The main purpose of this workshop is to equip and enable people in a portfolio management office and PMO to effectively and efficiently support the Executive Leadership and Operational Management to plan, implement, manage, and evolve portfolio management in their organization. There is a deliberate focus on preparing you to become a strong and effective change advocate for meaningful portfolio management that delivers objective measurements of benefit contribution towards the strategic objectives to lead, manage, and continuously improve portfolio management governance, processes, and frameworks with and through the direction of a portfolio practice, principles, and delivery boards. What you Will Learn At the end of this program, you will be able to: Articulate the benefits of portfolio management Link the initiatives in an organization with its strategic objectives Participate in the introduction of portfolio management in an organization Create or improve the portfolio governance structure Lead the inventory of ongoing and new initiatives Assist the executives in the prioritization of initiatives through the use of Multi-criteria Analysis and other selection tools Support the executives in balancing the portfolio based on the optimal use of resources and priorities Create a portfolio delivery plan Define thresholds and variance reporting criteria Assist the executives and the financial team in the definition of Stage Gate Funding Lead the Stage Gate reviews Analyze the benefits that are being realized by the initiatives Foundation Concepts Definitions Benefits of Portfolio Management Objectives of Portfolio Management Portfolio Life Cycles Governing the Portfolio Portfolio Governance structure Roles and responsibilities Initial activities when starting portfolio management Prioritizing Initiatives Prioritize purpose Multi-Criteria Analysis Analytical Hierarchy Process (AHP) Strategic alignment Balancing the Portfolio Allocating resources and budgets Communicating decisions of initiatives status Planning the Portfolio Planning review cycles Using Stage Gate Funding Setting thresholds and variance reporting Tool examples Managing the Portfolio Delivery Project and Program Life Cycles Stage Gate Reviews Loop back to Prioritize, Balance and Plan Interaction with the Portfolio Delivery Board Project, Program and Functional Managers' roles and responsibilities

This UI (User Interface) course is for designers, front-end developers and everyone who would like to start a career in UI design. During the course you will learn how to design mobile and web applications, as well as how to work with colours, fonts, and imagery. Every week each student will get personal feedback.

Duration 2 Days 12 CPD hours This course is intended for Team leaders, managers, executives and other business professionals, as well as those who would benefit by being able to assert themselves more effectively in a professional environment will benefit from this course. Overview Develop the necessary skills to communicate with confidence Apply communication styles that maximize benefits Augment your listening and hearing skills to increase engagement Utilize that art of asking questions to elicit more from others Leverage your body language for full communication Make the best first impressions by looking, sounding and being confident In this course, students will discover the best techniques to be properly assertive, and what are the ideal approaches in differing situations. Private classes on this topic are available. We can address your organization?s issues, time constraints, and save you money, too. Contact us to find out how. 1. What is Assertiveness? Differentiating Self-confidence from Assertiveness Understanding the Four Styles of Communication What Separates Assertiveness from Passiveness, Aggressiveness, and Passive-Aggressiveness 2. Dimensions of Communication Differentiating Listening from Hearing Developing Emphatic Listening Skills Utilizing Question Types - Open, Clarifying, and Closed Converting Negative Thinking into Positive Thinking 3. Body Language Says It All Managing Your Appearance Understanding Non-verbal Communication Making the Right First Impression Speaking with Confidence Relaxing and Reducing Anxiety 4. Dealing with Difficult Situations Dealing with Difficult People Building Rapport and Trust Appreciating the Different Ways that People Send and Receive Information Breaking Down Barriers and Building Consensus Applying PEGASUS Utilizing a Tactical Approach Choosing the Proper Form of Communication

This online course trains you as a Youth Mental Health First Aider (MHFAider®), giving you: An in-depth understanding of young people’s mental health and factors that affect wellbeing Practical skills to spot the triggers and signs of mental health issues Confidence to reassure and support a young person in distress Enhanced interpersonal skills such as non-judgemental listening Knowledge to help a young person recover their health by guiding them to further support – whether that’s through self-help sites, their place of learning, the NHS, or a mix – engaging with parents, carers and external agencies where appropriate Ability to support a young person with a long term mental health issue or disability to thrive Tools to look after your own mental wellbeing Format This is an online course delivered through the MHFA England Online Learning Hub Learning takes place through four live training sessions spread across one to two weeks, with self-learning activities in between. See course structure section below for more detail Each session is built around a Youth Mental Health First Aid action plan We limit numbers to 16 people per course so that the instructor can keep people safe and supported while they learn Course StructureSession 1: Introduction Individual learning (1 hour 15 minutes): Introduction to the Online Youth Mental Health First Aid course and the Online Learning Hub Activity 1: Why Youth Mental Health First Aid? Activity 2: What is ALGEE? Activity 3: What is mental health? Activity 4: Mental health and stigma Activity 5: Mental health quiz: Impact of mental health Activity 6: Risk and protective factors for mental health Activity 7: The Stress Container Live session (2 hours 35 minutes): Introduction to the course Outline of live session 1, the value of Youth Mental Health First Aid Introduce ALGEE Recap what mental health is Recap the Mental Health Continuum Stigma Recap why Youth Mental Health First Aid is important Recap risk and protective factors The Stress Container The Frame of Reference Session 2: Depression, Anxiety & Self-Care Individual learning (1 hour 15 minutes): Activity 8: Your Stress Container Activity 9: Your Frame of Reference Activity 10: What is depression? Activity 11: What is anxiety? Live session (2 hours 10 minutes): Introduction to live session 2 Recap of homework after live session 1 Recap depression Signs and symptoms of depression in a young person Recap anxiety Signs and symptoms of anxiety in a young person ALGEE for depression and anxiety in a young person ALGEE for depression and anxiety, action 1 ALGEE for depression and anxiety, action 2-5 Self-care and close Session 3: Suicide & PsychosisIndividual learning (1 hour 20 minutes) Activity 12: Adolescent brain development Activity 13: About suicide Activity 14: Suicide risk factors Activity 15: What is psychosis? Activity 16: Lived experience of psychosis Activity 17: ALGEE for psychosis Live session (2 hours 5 minutes) Introduction to live session 3 Recap suicide Explore the impact of suicidal feelings ALGEE for suicidal crisis Practice non-judgemental listening skills Recap psychosis Recap warning signs and symptoms of psychosis Recap ALGEE for psychosis Session 4: Self-harm, Recovery & Action PlanningIndividual learning (1 hour 35 minutes) Activity 18: What is self-harm? Activity 19: What are eating disorders? Activity 20: Resilience Workbook activity 7: My action plan for using Youth Mental Health First Aid (completed after live session) Live session (2 hours 25 minutes) Introduction to live session 4 Recap self-harm, the self-harm continuum Warning signs of self-harm in young people ALGEE for self-harm Recap eating disorders ALGEE for eating disorders Applying MHFA to family and carers; the Recovery Tree Evaluation forms and close

Duration 3 Days 18 CPD hours This course is intended for CxO?s IT Managers/ Directors Senior Project Officers Project & Program Coordinator/Managers Operations Managers Quality Managers Business Analysts Engineering Managers IT Infrastructure Managers Internal Consultants Professional Consultants Overview Change and the individual Change and the organization Communication and stakeholder engagement Change practice Dealing with change and more importantly, the impact of change is a high priority for all organisations. The Change Management Certification has been developed by APMG in partnership with the Change Management Institute (CMI), an independent, global professional association of change managers. Together they have developed a professional ?body of knowledge? for the discipline of change management. This body of knowledge now provides an independent benchmark for the professional knowledge expected of an effective change manager. APMG?s refreshed Change Management certification is fully aligned with the change management body of knowledge. Prerequisites There is no prerequisite to attending this foundation course, although it is recommended that candidates should have a good understanding of business practices. 1 - Change and the Organization Drivers for change Developing a vision Culture and climate Emergent change and lifecycle Organizational metaphors Models of change Roles required for change 2 - Stakeholders Principles Identification Analysis Influencing and listening Emotion and demonstration Communications Cognitive biases Remaining people focused Improving Communications Communications channels Collaboration Communications Planning Larger workshops 2 - Change Impact Assessing impact McKinsey 7 S Stakeholder impact assessment Assessing change readiness Large change ? how to staff Building a change team Preparing for resistance Building team effectiveness 4 - Individual Change Learning theory Motivation Change Curve Personality differences

Unconscious bias from a fresh new perspective for anyone who interacts with, or makes decisions about, people; whether you work with customers, supervise staff or work in collaboration, this session will enhance your insight and interactions.

CPD Accredited, Interactive Short Course 2 hr session This training session gives a good introduction to epilepsy How can you best understand and help those affected with different types of seizures Great for those who have contact with people with epilepsy, such as family and friends, those working in education and afterschool clubs, sports and good CPD for nurses Course Contents: What is Epilepsy The different types of seizures Keeping someone safe while they're having a seizure Understand how having epilepsy affects someone's life Great for teachers and TAs in schools, for those working in care or community events, and those close to people with epilepsy Benefits of this Short Course: Epilepsy is one of the most common neurological conditions In the UK, there are over 600,000 people with a diagnosis of epilepsy That is about 1 in 103 people, or 1 child or young person in every 3 classrooms Every year, 1000 people in the UK die due to their epilepsy Help avoid unnecessary suffering or even death by knowing what to do to help while they're having an epileptic seizure, and keep them safe

Arm yourself with a robust research toolkit that will help you uncover deep behavioural insights on user needs and motivations so you can design better experiences.

Tea 'N Chat free event - Talk with Textile Artist Nicky Simpson

Duration 3 Days 18 CPD hours This course is intended for This course is intended for information workers and data science professionals who seek to use database reporting and analysis tools such as Microsoft SQL Server Reporting Services, Excel, Power BI, R, SAS and other business intelligence tools, and wish to use TSQL queries to efficiently retrieve data sets from Microsoft SQL Server relational databases for use with these tools. Overview After completing this course, students will be able to: - Identify independent and dependent variables and measurement levels in their own analytical work scenarios. - Identify variables of interest in relational database tables. - Choose a data aggregation level and data set design appropriate for the intended analysis and tool. - Use TSQL SELECT queries to produce ready-to-use data sets for analysis in tools such as PowerBI, SQL Server Reporting Services, Excel, R, SAS, SPSS, and others. - Create stored procedures, views, and functions to modularize data retrieval code. This course is about writing TSQL queries for the purpose of database reporting, analysis, and business intelligence. 1 - INTRODUCTION TO TSQL FOR BUSINESS INTELLIGENCE Two Approaches to SQL Programming TSQL Data Retrieval in an Analytics / Business Intelligence Environment The Database Engine SQL Server Management Studio and the CarDeal Sample Database Identifying Variables in Tables SQL is a Declarative Language Introduction to the SELECT Query Lab 1: Introduction to TSQL for Business Intelligence 2 - TURNING TABLE COLUMNS INTO VARIABLES FOR ANALYSIS: SELECT LIST EXPRESSIONS, WHERE, AND ORDER BY Turning Columns into Variables for Analysis Column Expressions, Data Types, and Built-in Functions Column aliases Data type conversions Built-in Scalar Functions Table Aliases The WHERE clause ORDER BY Lab 1: Write queries 3 - COMBINING COLUMNS FROM MULTIPLE TABLES INTO A SINGLE DATASET: THE JOIN OPERATORS Primary Keys, Foreign Keys, and Joins Understanding Joins, Part 1: CROSS JOIN and the Full Cartesian Product Understanding Joins, Part 2: The INNER JOIN Understanding Joins, Part 3: The OUTER JOINS Understanding Joins, Part 4: Joining more than two tables Understanding Joins, Part 5: Combining INNER and OUTER JOINs Combining JOIN Operations with WHERE and ORDER BY Lab 1: Write SELECT queries 4 - CREATING AN APPROPRIATE AGGREGATION LEVEL USING GROUP BY Identifying required aggregation level and granularity Aggregate Functions GROUP BY HAVING Order of operations in SELECT queries Lab 1: Write queries 5 - SUBQUERIES, DERIVED TABLES AND COMMON TABLE EXPRESSIONS Non-correlated and correlated subqueries Derived tables Common table expressions Lab 1: Write queries 6 - ENCAPSULATING DATA RETRIEVAL LOGIC Views Table-valued functions Stored procedures Creating objects for read-access users Creating database accounts for analytical client tools Lab 1: Encapsulating Data Retrieval Logic 7 - GETTING YOUR DATASET TO THE CLIENT Connecting to SQL Server and Submitting Queries from Client Tools Connecting and running SELECT queries from: Excel PowerBI RStudio Exporting datasets to files using Results pane from SSMS The bcp utility The Import/Export Wizard Lab 1: Getting Your Dataset to the Client Additional course details: Nexus Humans 55232 Writing Analytical Queries for Business Intelligence training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the 55232 Writing Analytical Queries for Business Intelligence course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.