11 Analytical Skills courses delivered Live Online

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.

Clinical supervision is the term used to describe a formal process of professional support and provides an opportunity for staff to: reflect on and review their practice, develop their analytical skills and change or modify their practice.

OVERVIEW -------------------------------------------------------------------------------- Financial analysis gives you a wide understanding of a company's financial information which further helps you to analyse risks in the future and improve business prospects. It plays a vital role in calculating business profit. Professionals with the necessary skills help you to know how your business and forecast the future of the business. It helps to analyse financial statements and also to appraise the present and future prospects of the business. This course is specially designed to enhance the skills of financial professionals, in financial analytics by having in-depth knowledge of fundamentals of financial statement analysis thereby empowering their analytical skills in measuring the risk business investors are dealing with and also asking the appropriate questions. It will enhance the skills of the participant and will boost their confidence uplifting their ability to comment on business activities and analyse financial health for management. These skills and the required technical knowledge will be put into practice throughout the course using interactive examples and case studies. 

Learning Outcomes for 'Minor Illness Update' Day for Experienced Registered Healthcare Professionals   By catering to experienced registered healthcare professionals already practicing in the area of minor illness, this 'Minor Illness Update' Day equips participants to elevate their existing skills, apply the latest insights, and enhance patient care through informed, compassionate, and effective practices. Agenda: 09.15Coffee and registration 09.30Introduction and course objectives 09.40Perspective on changes and safe practice within primary care 10.00Respiratory Tract infections 10.45Coffee 11.00Ears, Nose and Throat 13.00Lunch 14.00Abdominal pain and UTIs 14.30Head, Neck and Back Pain 14.30Eye infections 15.00Skin Rashes 15.30Injuries 15.45Evaluations and Close Learning Outcomes: Upon completion of the 'Minor Illness Update' Day, aimed at registered and experienced healthcare professionals already practicing in the field of minor illness, participants will be able to: 1. Stay Current in Minor Illness Management:   - Demonstrate an updated and well-informed understanding of the latest developments in minor illness management within the primary care context.   - Stay informed about current prescribing guidelines and adjustments in the field of minor illness treatment. 2. Critical Analysis of Consultation Dynamics:   - Exhibit a critical comprehension of the significant dynamics at play during patient consultations related to minor illness cases.   - Apply analytical skills to assess the complexities of patient presentations and prioritize appropriate diagnostic and treatment strategies. 3. Effective Problem-Solving in Practice:   - Discuss and analyse practical challenges that arise during minor illness consultations, and propose effective solutions tailored to individual patient needs.   - Employ problem-solving abilities to navigate diverse patient scenarios, enhancing overall patient care. 4. Integration of Attitudes and Values:   - Develop an understanding of how personal attitudes and values may influence patient interactions and treatment decisions.   - Apply self-awareness to ensure professional conduct aligns with ethical and patient-centred principles. 5. Awareness of Professional Growth:   - Recognize the ongoing nature of professional development and the importance of staying updated in the rapidly evolving field of minor illness management.   - Acknowledge the responsibility for continuous growth, embracing opportunities for learning and improvement. 6. CPD Contribution and Revalidation:   - Identify the applicability of these study days as part of Continuing Professional Development (CPD) requirements for experienced registered healthcare professionals already practicing in minor illness.   - Understand how participation contributes to professional revalidation, ensuring compliance with professional standards. 7. Virtual Engagement for Learning:   - Leverage virtual learning environments effectively to enhance knowledge and skills related to minor illness management.   - Demonstrate adaptability in engaging with virtual platforms for professional development and learning. 8. Holistic Patient Care Approach:   - Integrate the acquired knowledge to provide holistic care to patients presenting with minor illness, recognizing the interconnectedness of physical and psychosocial aspects.   - Foster a patient-centred approach by considering patients' needs, preferences, and well-being.  

Duration 1 Days 6 CPD hours This course is intended for This course is intended for individuals who want to become more rational and disciplined thinkers. Overview Upon successful completion of this course, students will boost their performance with an increase in their decision-making ability. In this course, students will learn develop their ability to analyze and evaluate information. 1 - GETTING STARTED * Icebreaker * Housekeeping Items * The Parking Lot * Workshop Objectives 2 - COMPONENTS OF CRITICAL THINKING * Applying Reason * Open Mindedness * Analysis * Logic * Case Study 3 - NON-LINEAR THINKING * Step Out of Your Comfort Zone * Don't Jump to Conclusions * Expect and Initiate Change * Being Ready to Adapt * Case Study 4 - LOGICAL THINKING * Ask the Right Questions * Organize the Data * Evaluate the Information * Draw Conclusions * Case Study 5 - CRITICAL THINKERS (I) * Active Listening * Be Curious * Be Disciplined * Be Humble * Case Study 6 - CRITICAL THINKERS (II) * Seeing the Big Picture * Objectivity * Using Your Emotions * Being Self-Aware * Case Study 7 - EVALUATE INFORMATION * Making Assumptions * Watch out for Bias * Ask Clarifying Questions * SWOT Analysis * Case Study 8 - BENEFITS OF CRITICAL THINKING * Being More Persuasive * Better Communication * Better Problem Solving * Increased Emotional Intelligence * Case Study 9 - CHANGING YOUR PERSPECTIVE * Limitations of Your Point of View * Considering Others Viewpoint * Influences on Bias * When New Information Arrives * Case Study 10 - PROBLEM SOLVING * Identify Inconsistencies * Trust Your Instincts * Asking Why? * Evaluate the Solution(s) * Case Study 11 - PUTTING IT ALL TOGETHER * Retaining Your New Skills * Reflect and Learn From Mistakes * Always Ask Questions * Practicing Critical Thinking * Case Study 12 - WRAPPING UP * Words from the Wise * Review of Parking Lot * Lessons Learned * Completion of Action Plans and Evaluations

Duration 1 Days 6 CPD hours This course is intended for Those who need to understand the financial implications of their day-to-day decisions to increase the profitability and performance of their business. This course is suitable for managers with little or no financial knowledge. Overview Understanding of financial accounts and reports The ability to use and understanding of financial concepts Analytical skills to interpret financial results using ratios This course shows how to interpret key financial statements highlighting the questions and areas that matter. It identifies warning signals that managers need to be aware of and shows how to understand key performance indicators to drive profitability. COURSE OUTLINE * The Business Cycle: understand how money flows in a business * Business objectives: use financial data to achieve business targets * The income statement, the cash flow statement and the balance sheet * Accrual and cash accounting * Operational & Financial Gearing * Profit vs Cash and other key financial ratios, how to use them effectively * Working capital management * Cash flow management * EBIT, EBITDA, Free & Operating Cash Flow & other measures of profit / cash * Understanding Return on Investment & asset valuations ADDITIONAL COURSE DETAILS: Nexus Humans Finance for Non Finance Managers (1 Day) 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 Finance for Non Finance Managers (1 Day) 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.

Duration 2 Days 12 CPD hours This course is intended for Those who need to understand the financial implications of their day-to-day decisions to increase the profitability and performance of their business. This course is suitable for managers with little or no financial knowledge. Overview Understanding of financial accounts and reports The ability to use and understanding of financial concepts Analytical skills to interpret financial results using ratios Ability to manage budgets more effectively This course shows how to interpret key financial statements highlighting the questions and areas that matter. It identifies warning signals that managers need to be aware of and shows how to understand key performance indicators to drive profitability. The course will also cover the essentials of budgeting and forecasting as well as addressing key financial terms such as goodwill and accruals & prepayments. Delegates will learn how to appraise capital projects with confidence, allowing them to make the best decisions for their business. COURSE OUTLINE * The basics of finance: * How companies are financially structured * Accrual v cash accounting * The Business Cycle: understand how money flows in a business * How businesses are financed: debt and equity * Business objectives: using financial data to achieve business targets * Key Financial Statements: * Income Statement * Balance Sheet * Cash Flow Statement * Key Financial Analysis Ratios * Profitability: profit margins, EBIT & EBITDA, operational gearing * Return on Investment: ROCE, ROA * Leverage: financial gearing & interest cover * Liquidity: current & quick ratios * Cash Flow: working capital requirement * Working capital management * Cash flow management * Key financial terms ? goodwill, accruals & prepayments, depreciation and amortization * Cost analysis, control and reduction * Capex v Opex * Effective Budgeting and Forecasting to control the business * Management Accounts and undertaking variance analysis * Improving margins and sales in your business * Break even analysis * Capital Investment techniques ? NPV, IRR and discounted cash flows * Asset Valuation ADDITIONAL COURSE DETAILS: Nexus Humans Finance for Non-Finance Managers (2 Day) 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 Finance for Non-Finance Managers (2 Day) 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.

Identifying learning and training needs, designing and sourcing training and learning solutions, delivering and evaluating training.

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 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 three-day instructor-led course is about writing TSQL queries for the purpose of database reporting, analysis, and business intelligence. Specifically, this course presents TSQL within the context of data analysis in other words, making meaning from the data rather than transaction-oriented data-tier application development. The course starts with a brief discussion of levels of measurement and quantitative research methodogy, and integrates these concepts into each TSQL topic presented. The goal is to provide a consistent, direct, and purposeful learning path from RDBMS data retrieval through analytical tools such as SQL Server Reporting Services, PowerBI, Excel, R, SAS, and SPSS. MODULE 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 MODULE 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 MODULE 3: COMBINING COLUMNS FROM MULTIPLE TABLES INTO A SINGLE DATASET: THE JOIN OPERATORS * Primary Keys, Foreign Keys, and Joins * Understanding Joins, Part 1: CROSSJOIN and the Full Cartesian Product * Understanding Joins, Part 2: The INNERJOIN * Understanding Joins, Part 3: The OUTERJOINS * Understanding Joins, Part 4: Joining more than two tables * Understanding Joins, Part 5: Combining INNER and OUTERJOINs * Combining JOIN Operations with WHERE and ORDER BY MODULE 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 MODULE 5: SUBQUERIES, DERIVED TABLES AND COMMON TABLE EXPRESSIONS * Non-correlated and correlated subqueries * Derived tables * Common table expressions * MODULE 6: ENCAPSULATING DATA RETRIEVAL LOGIC * Views * Table-valued functions * Stored procedures * Creating objects for read-access users * Creating database accounts for analytical client tools MODULE 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 ADDITIONAL COURSE DETAILS: Nexus Humans 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 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.

Duration 2 Days 12 CPD hours This course is intended for Executives, Project Managers, Business Analysts, Business and IT stakeholders working with analysts, Quality and process engineers, technicians, corrective action coordinators or managers; supervisors, team leaders, and process operators; anyone who wants to improve their ability to solve recurring problems. Overview At the completion of this course, you should be able to:Identify the different types of tools and techniques availableApply change management successfullyReview what to look for when applying business case thinking to Root Cause AnalysisDevelop a process to systematically approach problems Problem determination skills cannot be acquired by reading a book. They mostly come from experience. After this course, you will have a general understanding of a structured problem determination approach, which you can then apply in your daily work. RCA FOUNDATION CONCEPTS AND OBJECTIVES * Section Learning Objectives * Discuss Definitions ? IT Perspective * Discuss What is a problem and why do they exist? * Exercise 1a: Why is RCA important * What is Root Cause? * RCA Benefits and Approaches * Exercise 1b: Why are multiple approaches important? * Event and Casual Analysis * Exercise 1c: Apply Event and Causal Analysis * Event and Causal Analysis: Exercise 1c Worksheet * RCA Tools for each approach * Exercise 1D: Prepare for Case Study * Section Summary and Conclusions ENHANCE USE OF RCA TOOLS * Why use a Particular Method * Tool: Change Analysis * Change Analysis Examples * Exercise 2a: Apply Change Analysis * Exercise 2b: Change Analysis Worksheet * Tool: How to Resolve Conflict * Tool: 5 Why?s * Example Learning Management Problem * Exercise 2b: Apply 5 Why?s Sequence-of-Events * Exercise 2b: Worksheet * Tool: Cause and Effect * Exercise 2c: Apply Cause and Effect * Exercise 2c: Cause and Effect Worksheet * Tool: Fault Tree Analysis * Why do we use Fault Tree Analysis? * How does it work? * Fault Tree Diagram Symbols * Example #1 of FTA: Car Hits Object * Exercise 2D: Apply Fault Tree Analysis * Tool: Failure Modes and Effects Analysis (FMEA) * Example: Failure Modes and Effects Analysis * Exercise 2E: Apply FMEA * Tool: Design / Application Review * Exercise 2d: Apply Design/Application Review * Section summary & conclusions PROBLEM RESOLUTION & PREVENTION * Section Objectives * The Secret of Solving Problems * A Note about Statistical Control * A Note about Fire Fighting * Technique: Business Process Mapping * Example: IGOE * Exercise 3A: Problem as IGOE * Exercise 3A: IGOE Template * Technique: Lean Six Sigma and DMAIC * Lean Six Sigma Benefits * Exercise 3B: Apply Lean Six Sigma * Importance of Understanding the Business Process * The Business Process Mandate * Technique: Process Modeling * Graphical Notation Standard (BPMN) * What is Business Process Modeling Notation (BPMN)? * Benefits of BPMN * Basic Components of BPMN * Exercise 3C: Use BPMN to Document a Current State * Technique: Business Process Maturity Model * Five Levels of Maturity * Exercise 3D: Appraise Business Process Maturity Level * Section Summary and Conclusions CAPABILITY IMPROVEMENT FOR RCA * Section Learning Objectives * Steps in Disciplined Problem Solving * RCA as a RCA Process * Key RCA Role Considerations * Exercise 4A: Apply RCA to RCA Process * Sustainable RCA Improvement * Organizational Units * Process Area Goals, Practices * Specific and General Practices * Specific Practice Examples * Software Maturity Survey * Exercise 4B: Apply Strengths, Weakness, Opportunities and Threats (SWOT) to RCA * SWOT Analysis Worksheet * Recognize the importance of the Change Management component in your RCA implementation * Using the ADKAR Model to Communicate Change * Review ADKAR© Model ? * Awareness of the need for change * Desire to participate and support the change * Knowledge on how to change * Ability to implement required skills and behaviors * Reinforcement to sustain the change * Exercise 4C: Create an Ability Checklist * The ADKAR Model: Reinforcement * Exercise 4D: Find two examples of how ADKAR will be different * Section Summary and Conclusions COURSE SUMMARY & CONCLUSIONS * Plan the Proposal and Business Case * Example: 1 Page Business Case * Exercise 5A: Creating Action Plans * Resource Guide * Questions ADDITIONAL COURSE DETAILS: Nexus Humans BA17 - Advanced Root Cause Analysis 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 BA17 - Advanced Root Cause Analysis 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.