We are excited to announce the Online version of the Step by Step Course. It will include live demonstrations of the process that you will then follow. Unique opportunity to be guided step by step and experience meditative practice of icon painting.
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
Immerse yourself in a comprehensive one-day virtual update course dedicated to diabetes, tailored for healthcare professionals already actively engaged in this field. This engaging program is open to all registered healthcare practitioners, encompassing General Practitioners, Pharmacists, Paramedics, Practice Nurses, Nurse Practitioners, Advanced Nurse Practitioners, and Nursing Assistants. Upon completion of this enlightening day, participants will emerge with heightened confidence in their ability to practice with up-to-the-minute proficiency in managing diabetes. This course covers the latest trends in diabetes management, encompassing a thorough understanding of cutting-edge pharmacological interventions utilised in diabetes care. Agenda (Please note that this outline provides a general overview and may experience minor adjustments.) 09:15 - Coffee and Registration 09:30 - Introduction and Course Objectives 09:45 - Comprehensive Update on Diabetes Classifications 10:00 - Key Statistical Insights 10:15 - Unraveling Metabolic Syndrome 11:00 - Coffee Break 11:20 - Navigating Diabetes Prevention 12:00 - Unpacking Diagnostic Criteria 12:45 - Lunch Break 13:30 - Guideline Refinements in Diabetes Management 14:15 - Effective Support for Lifestyle Modifications 14:30 - Exploring Pharmacological Approaches 15:30 - In-depth Study of Insulin and Continuous Glucose Monitoring (CGM) 16:00 - A Holistic View of Hypoglycemia and its Management 16:15 - Real-world Case Studies 16:30 - Session Conclusion Anticipated Learning Outcomes · Revitalize and reinforce your comprehension of diabetes. · Scrutinize novel and ongoing trends in diabetes management. · Stay current with the latest pharmacological advances in diabetes care. · Foster open dialogues addressing practical challenges and their remedies. · Recognize the significance of continuous professional development and the apt handling of concerns. Elevate your expertise and proficiency in diabetes management with this immersive update course, designed to empower healthcare professionals in the realm of primary care.
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
Course Overview - Target Audience: General practice clinicians, including nurses and allied healthcare professionals. - Cost: £150 per place + VAT. - Duration: 1 days, with one day dedicated to issues surrounding men's health - Delivery Format: Virtual via Zoom This day is most suited to Nurse Associates, Practice Nurses, NP's, ENP's, Paramedics and Pharmacists. Dr Tamara Cunningham is an experienced GP Trainer and will be teaching these interactive, online days. Men's Health Update Day Learning Objectives: 1. Understand the Latest Guidelines and Best Practices in Erectile Dysfunction (ED) Management: Participants will gain an in-depth understanding of the current guidelines and effective treatment strategies for ED, including pharmacological and non-pharmacological options. 2. Expertise in Diagnosing and Treating Premature Ejaculation and Sexual Health Issues: This outcome focuses on equipping attendees with the skills to diagnose premature ejaculation accurately, understand its psychological impact, and explore various treatment methods. 3. Interpretation and Application of NICE Guidelines for Prostate Health: Participants will learn how to interpret and apply the latest NICE guidelines for the management of prostate-related conditions, emphasizing evidence-based practices. 4. Comprehensive Understanding of Lower Urinary Tract Symptoms (LUTS) in Men: The training will provide knowledge about the etiology, diagnosis, and management of LUTS, including differentiating between various underlying causes. 5. Integrating Mental Health in Men's Health Care: This outcome focuses on understanding the intersection of mental health and men's physical health, recognizing common mental health issues in men, and integrating mental health assessment and referral pathways in primary care settings. 6. Effective Communication Skills for Discussing Sensitive Men's Health Issues: Enhance communication skills for healthcare professionals to engage effectively and sensitively with male patients about their health concerns, particularly in areas of sexual health and mental well-being. 7. Case Studies and Real-world Application: Through interactive case studies, participants will apply their knowledge in real-world scenarios, enhancing their practical skills in managing men's health issues. 8. Updates on Research and Emerging Trends in Men's Health: Attendees will be briefed on the latest research developments and emerging trends in men's health, preparing them to stay informed about future advancements. 9. Network and Share Best Practices: An opportunity for attendees to network with peers, share best practices, and discuss challenges and solutions in men's health care. 10. Reflective Practice and Continuous Professional Development: Encourage participants to reflect on their current practice, identify areas for improvement, and understand the role of continuous learning in providing high-quality men's health care.
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.
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.
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.