768 Intelligence courses

This course is designed for those already using Power BI Desktop and are ready to work with more comprehensive elements of analysing and reporting in Power BI. The course maintains a balanced look at data analysis including the Power Query Editor, with a deep dive into writing DAX formulas, and enhanced dashboard visualisations. The aim of this course is to provide a more complete understanding of the whole Power BI analytics process, by working with business examples that will equip you with the necessary skills to output comprehensive reports and explore Power BI's analytical capabilities in more depth. 1 The Query Editor Grouping rows in a table Split row by delimiter Add days to determine deadlines The query editor 2 Fuzzy Matching Joins Matching inconsistencies by percentage Matching with transformation table 3 The Query Editor M Functions Adding custom columns Creating an IF function Nested AND logics in an IF function 4 DAX New Columns Functions Including TRUE with SWITCH Using multiple conditions The FIND DAX function The IF DAX function Logical functions IF, AND, OR 5 Editing DAX Measures Making DAX easier to read Add comments to a measure Using quick measures 6 The Anatomy of CALCULATE Understanding CALCULATE filters Add context to CALCULATE with FILTER Using CALCULATE with a threshold 7 The ALL Measure Anatomy of ALL Create an ALL measure Using ALL as a filter Use ALL for percentages 8 DAX Iterators Anatomy of iterators A closer look at SUMX Using RELATED with SUMX Create a RANKX RANKX with ALL 9 Date and Time Functions Overview of functions Create a DATEDIFF function 10 Time Intelligent Measures Compare historical monthly data Create a DATEADD measure Creating cumulative totals Creating cumulative measures Visualising cumulative totals 11 Visualisations In-Depth Utilising report themes Applying static filters Group data using lists Group numbers using bins Creating heatmaps Comparing proportions View trends with sparklines 12 Comparing Variables Visualising trendlines as KPI Forecasting with trendlines Creating a scatter plot Creating dynamic labels Customised visualisation tooltips Export reports to SharePoint

Course Duration: Half-day or full-day program (with virtual delivery options) Target Audience: Mid-to-senior level leaders, executives, managers, HR professionals, and leadership development coaches looking to enhance their leadership capabilities and create high-performing teams. Course Objectives By the end of this course, participants will be able to: Understand the role of coaching in leadership development and high-impact performance. Learn effective coaching strategies to inspire and elevate team performance. Develop skills in active listening, providing feedback, and fostering accountability. Enhance their ability to set clear goals, motivate teams, and create a culture of continuous improvement. Build an action plan for coaching their teams towards high-impact performance. Course Outline Module 1: The Role of Leadership in High-Impact Performance What defines high-impact leadership and performance? The difference between managing and coaching: leadership approaches that drive results The impact of leadership on organisational culture, productivity, and morale Essential leadership competencies for driving high performance Module 2: The Coaching Mindset Understanding the coaching mindset: shifting from directive leadership to empowering leadership Coaching as a tool for leadership development and team performance The benefits of a growth mindset in leadership and performance Key attributes of an effective coach: empathy, active listening, emotional intelligence Module 3: Key Coaching Skills for Leaders Active listening: asking the right questions, listening beyond the words Giving and receiving feedback: providing constructive feedback to motivate and improve performance Building rapport and trust with team members Coaching for growth: helping individuals unlock their potential and build confidence Challenging and supporting: knowing when to push for growth and when to provide support Module 4: Setting Clear, Achievable Goals The importance of goal-setting in coaching for high-performance Setting SMART goals (Specific, Measurable, Achievable, Relevant, Time-bound) Aligning team goals with organisational objectives and strategy Techniques for holding team members accountable to their goals Creating a culture of continuous feedback and improvement Module 5: Motivating and Inspiring Teams The psychology of motivation: intrinsic vs extrinsic motivation Leveraging strengths: identifying and utilising team members’ core strengths for high impact Building team ownership: fostering a sense of responsibility and autonomy Using recognition and reward systems to motivate performance Building resilience: coaching through setbacks and challenges Module 6: Coaching for Performance and Development Balancing short-term performance goals with long-term development needs Identifying potential and growth opportunities in your team Conducting effective one-on-one coaching sessions: structure and frameworks Using assessments and data to drive coaching decisions (e.g., 360-degree feedback, performance metrics) Encouraging self-reflection and self-coaching in team members Module 7: Leading through Change and Uncertainty Coaching leaders to navigate change: resilience in times of uncertainty The role of leadership in creating clarity and stability during change Helping teams embrace change and uncertainty with a growth mindset Leading with emotional intelligence during periods of transition Module 8: Action Planning for High-Impact Leadership Coaching Reflecting on your coaching style and leadership strengths Developing an action plan for coaching individual team members and leading high-performing teams Defining key coaching strategies and techniques for ongoing leadership development Creating a culture of feedback and continuous growth within your team Setting up regular check-ins and performance reviews to monitor progress Delivery Style Highly interactive with coaching demonstrations, role-playing, and peer-to-peer coaching exercises Real-world case studies and leadership scenarios to apply key concepts Practical tools, templates, and frameworks for implementing coaching in the workplace Personal action planning for leadership development and team performance Group discussions and reflection activities Course Materials Provided Leadership Coaching Framework and Templates SMART Goals Worksheet and Coaching Conversation Guide Feedback and Accountability Tools Leadership Development Action Plan Resource list: Books, podcasts, and articles on leadership coaching Optional Add-ons One-on-one leadership coaching sessions for personalised development Post-course check-ins and follow-up coaching to track progress Group coaching sessions for team leaders to share best practices and support one another Tailored modules focused on specific leadership challenges (e.g., change management, team dynamics)

Course Duration: Half-day or full-day program (with virtual delivery options) Target Audience: Mid-to-senior level leaders, executives, managers, HR professionals, and leadership development coaches looking to enhance their leadership capabilities and create high-performing teams. Course Objectives By the end of this course, participants will be able to: Understand the role of coaching in leadership development and high-impact performance. Learn effective coaching strategies to inspire and elevate team performance. Develop skills in active listening, providing feedback, and fostering accountability. Enhance their ability to set clear goals, motivate teams, and create a culture of continuous improvement. Build an action plan for coaching their teams towards high-impact performance. Course Outline Module 1: The Role of Leadership in High-Impact Performance What defines high-impact leadership and performance? The difference between managing and coaching: leadership approaches that drive results The impact of leadership on organisational culture, productivity, and morale Essential leadership competencies for driving high performance Module 2: The Coaching Mindset Understanding the coaching mindset: shifting from directive leadership to empowering leadership Coaching as a tool for leadership development and team performance The benefits of a growth mindset in leadership and performance Key attributes of an effective coach: empathy, active listening, emotional intelligence Module 3: Key Coaching Skills for Leaders Active listening: asking the right questions, listening beyond the words Giving and receiving feedback: providing constructive feedback to motivate and improve performance Building rapport and trust with team members Coaching for growth: helping individuals unlock their potential and build confidence Challenging and supporting: knowing when to push for growth and when to provide support Module 4: Setting Clear, Achievable Goals The importance of goal-setting in coaching for high-performance Setting SMART goals (Specific, Measurable, Achievable, Relevant, Time-bound) Aligning team goals with organisational objectives and strategy Techniques for holding team members accountable to their goals Creating a culture of continuous feedback and improvement Module 5: Motivating and Inspiring Teams The psychology of motivation: intrinsic vs extrinsic motivation Leveraging strengths: identifying and utilising team members’ core strengths for high impact Building team ownership: fostering a sense of responsibility and autonomy Using recognition and reward systems to motivate performance Building resilience: coaching through setbacks and challenges Module 6: Coaching for Performance and Development Balancing short-term performance goals with long-term development needs Identifying potential and growth opportunities in your team Conducting effective one-on-one coaching sessions: structure and frameworks Using assessments and data to drive coaching decisions (e.g., 360-degree feedback, performance metrics) Encouraging self-reflection and self-coaching in team members Module 7: Leading through Change and Uncertainty Coaching leaders to navigate change: resilience in times of uncertainty The role of leadership in creating clarity and stability during change Helping teams embrace change and uncertainty with a growth mindset Leading with emotional intelligence during periods of transition Module 8: Action Planning for High-Impact Leadership Coaching Reflecting on your coaching style and leadership strengths Developing an action plan for coaching individual team members and leading high-performing teams Defining key coaching strategies and techniques for ongoing leadership development Creating a culture of feedback and continuous growth within your team Setting up regular check-ins and performance reviews to monitor progress Delivery Style Highly interactive with coaching demonstrations, role-playing, and peer-to-peer coaching exercises Real-world case studies and leadership scenarios to apply key concepts Practical tools, templates, and frameworks for implementing coaching in the workplace Personal action planning for leadership development and team performance Group discussions and reflection activities Course Materials Provided Leadership Coaching Framework and Templates SMART Goals Worksheet and Coaching Conversation Guide Feedback and Accountability Tools Leadership Development Action Plan Resource list: Books, podcasts, and articles on leadership coaching Optional Add-ons One-on-one leadership coaching sessions for personalised development Post-course check-ins and follow-up coaching to track progress Group coaching sessions for team leaders to share best practices and support one another Tailored modules focused on specific leadership challenges (e.g., change management, team dynamics)

Course Objectives By the end of this course, participants will be able to: Differentiate between coaching and mentoring and understand their unique purposes. Apply effective communication and active listening skills in developmental conversations. Use coaching models to guide structured conversations. Build trust and psychological safety in coaching and mentoring relationships. Create actionable development plans and track progress. Understand ethical boundaries and confidentiality. Course Outline Day 1: Foundations of Coaching and Mentoring Session 1: Introduction and Context What is coaching? What is mentoring? Key differences and when to use each Benefits to individuals and organisations Session 2: Core Skills for Effective Coaching and Mentoring Active listening Powerful questioning Giving and receiving feedback Empathy and emotional intelligence Session 3: Building Trust and Creating Psychological Safety Establishing rapport Confidentiality and ethical guidelines Setting boundaries and expectations Session 4: Coaching Models and Frameworks GROW Model (Goal, Reality, Options, Will) OSKAR and CLEAR frameworks Practical application and role play Day 2: Practising and Embedding Coaching and Mentoring Session 5: The Coaching and Mentoring Conversation Structuring conversations Using real-life workplace examples Practice with feedback Session 6: Setting Goals and Development Plans SMART and CLEAR goal setting Creating growth-focused action plans Monitoring progress and accountability Session 7: Mentoring for Career and Leadership Development Mentor roles and responsibilities Supporting long-term growth and resilience Reverse mentoring and cross-generational partnerships Session 8: Embedding a Coaching and Mentoring Culture How to support coaching within your team or organisation Integrating into performance conversations Sustaining development through peer coaching and communities of practice Assessment and Evaluation Participation in discussions and practical activities Feedback on peer coaching/mentoring exercises Optional personal development plan submission Course Materials Provided Participant workbook Coaching and mentoring toolkit (templates, models, guides) Suggested reading and resource list

Course Objectives By the end of this course, participants will be able to: Differentiate between coaching and mentoring and understand their unique purposes. Apply effective communication and active listening skills in developmental conversations. Use coaching models to guide structured conversations. Build trust and psychological safety in coaching and mentoring relationships. Create actionable development plans and track progress. Understand ethical boundaries and confidentiality. Course Outline Day 1: Foundations of Coaching and Mentoring Session 1: Introduction and Context What is coaching? What is mentoring? Key differences and when to use each Benefits to individuals and organisations Session 2: Core Skills for Effective Coaching and Mentoring Active listening Powerful questioning Giving and receiving feedback Empathy and emotional intelligence Session 3: Building Trust and Creating Psychological Safety Establishing rapport Confidentiality and ethical guidelines Setting boundaries and expectations Session 4: Coaching Models and Frameworks GROW Model (Goal, Reality, Options, Will) OSKAR and CLEAR frameworks Practical application and role play Day 2: Practising and Embedding Coaching and Mentoring Session 5: The Coaching and Mentoring Conversation Structuring conversations Using real-life workplace examples Practice with feedback Session 6: Setting Goals and Development Plans SMART and CLEAR goal setting Creating growth-focused action plans Monitoring progress and accountability Session 7: Mentoring for Career and Leadership Development Mentor roles and responsibilities Supporting long-term growth and resilience Reverse mentoring and cross-generational partnerships Session 8: Embedding a Coaching and Mentoring Culture How to support coaching within your team or organisation Integrating into performance conversations Sustaining development through peer coaching and communities of practice Assessment and Evaluation Participation in discussions and practical activities Feedback on peer coaching/mentoring exercises Optional personal development plan submission Course Materials Provided Participant workbook Coaching and mentoring toolkit (templates, models, guides) Suggested reading and resource list

Learn how to use this powerful tool to import and clean data and create some amazing visuals. Course overview Duration: 2 days (13 hours) Power BI Desktop is a powerful tool for working with your data. It enables you to import multiple data sources and create effective visualisations and reports. This course is an introduction to Power BI to get you started on creating a powerful reporting capability. You should have a good working knowledge of Excel and managing data before attending. Objectives  By the end of the course you will be able to: Import data from multiple data sources Edit and transform data before importing Create reports Create different visualisations Create data models Build data relationships Use the drill down features Create measures Use the Power BI Service Build dashboards Use the mobile app Content Essentials Importing Data Power BI Overview Data sources Importing data Transforming Your Data Editing your data Setting data types Removing columns/rows Choosing columns to keep Setting header rows Splitting columns Creating Reports Creating and saving reports Adding pages Renaming pages Interactivity Refreshing your data Adding Columns Columns from example Custom columns Conditional columns Append Queries Importing folders Setting up and using append queries Creating Chart Visualisations Adding chart elements Choosing chart types Setting properties Setting values, axis and legends Using tooltips Visual filters Setting page and report filters Creating Tables, Cards, Gauges and Maps Adding table elements Adding maps Working with cards Working with matrices KPIs and Gauges Conditional Formatting Setting rules Removing conditional formatting   Working with Data Models Merge Queries Setting up and using merge queries Merging in columns of data Creating a Data Model The data model Multiple data tables Connecting tables Building relationships Relationship types Building visuals from multiple tables Unpivoting Data Working with summary data Unpivoting data Using Hierarchies Using built in hierarchies Drill down Drill up See next level Expand a hierarchy Create a new hierarchy Grouping Grouping text fields Grouping date and number fields Creating Measures DAX functions DAX syntax Creating a new measure Using quick measures Using the PowerBI Service Shared workspaces My workspace Dashboards Reports Datasets Drill down in dashboards Focus mode Using Q&A Refreshing data Using Quick Insights Power BI Mobile App Using the Power BI Mobile App

Expand your Power BI knowledge and take your reports to the next level. Course overview Duration: 1 day (6.5 hours) This course is aimed at existing users who want to expand their skills to use advanced reporting techniques and use DAX to create calculated columns and measures. Participants should have either attended our Power BI – Introduction course or have equivalent knowledge. You should be able to import and transform data and create simple reports. Objectives  By the end of the course you will be able to: Import and connect data tables Create and use date calendars Create calculated columns Create and use measures Use drill down and drill through Create Tooltip pages Add and customise slicers Add action buttons Streamline your report for use in the Power BI Service Content Review of importing and loading data Importing data Transforming data Adding custom columns Creating data models Building visuals Creating date calendars Building date tables Creating Financial Year information Including Month and Day information Creating calculated columns Power Query custom columns vs DAX columns Creating DAX calculated columns Creating measures Implicit vs Explicit Measures Building measures Using DAX Common DAX functions Drill Down vs Drill Through Review of drill down Creating drill through pages Using drill through Creating ToolTips Pages Adding pages to use for Tooltips Linking ToolTip pages to visuals Using action buttons Adding images Adding buttons Setting actions Working with slicers Adding slicers Changing slicer settings Syncing slicers between pages Showing what has been sliced Setting slicer interactions Techniques in the Power BI Service Hiding the navigation bar Stopping users manually filtering

Course Duration: Half-day, 1-day, or modular delivery over 2–3 sessions Target Audience: Managers, team leaders, HR professionals, and employees who want to foster trust, openness, and inclusivity within their teams or organisations. Course Objectives By the end of this course, participants will be able to: Understand the concept and importance of psychological safety. Recognise how psychological safety impacts team performance and wellbeing. Identify behaviours and practices that support or undermine psychological safety. Develop strategies to create inclusive, respectful, and open team cultures. Apply tools to encourage constructive feedback, innovation, and open dialogue. Course Outline Module 1: What is Psychological Safety? Definition and origin (Dr Amy Edmondson’s research) Why psychological safety matters: the business and human case Link between psychological safety, innovation, collaboration, and retention Misconceptions: It’s not about comfort or avoiding challenge Module 2: Assessing the Current Environment Signs of a psychologically safe vs unsafe environment Common team behaviours and leadership pitfalls Self-assessment: how psychologically safe is my team? Module 3: Building the Foundations The four stages of psychological safety: Inclusion safety Learner safety Contributor safety Challenger safety Role of trust, empathy, and emotional intelligence The leader’s role in creating safe environments Module 4: Practical Strategies to Foster Safety Encouraging open communication and constructive disagreement Creating space for risk-taking and vulnerability Responding to feedback and mistakes without blame Speaking up behaviours – how to model and support them Module 5: Embedding Psychological Safety into Team Culture Meeting practices that promote psychological safety How to give and receive feedback safely Inclusive decision-making and respectful challenge Recognising and rewarding candour and contribution Module 6: Leading with Psychological Safety Coaching conversations and active listening Managing difficult conversations and underperformance safely Supporting neurodiverse or marginalised voices Sustaining safety under pressure and during change Delivery Style Facilitated discussions and group work Role plays, reflection activities, and real-life scenarios Peer learning and action planning Optional pre-work or post-session surveys Course Materials Provided Participant workbook Psychological safety assessment toolkit Conversation starter guide Leadership checklist for building safety Personal and team action plan Optional Add-ons Team psychological safety assessments (anonymous survey) Post-course coaching or leadership debrief Co-delivery with DEI (Diversity, Equity & Inclusion) workshops Integration with feedback or team development programs

Course Duration: Half-day, 1-day, or modular delivery over 2–3 sessions Target Audience: Managers, team leaders, HR professionals, and employees who want to foster trust, openness, and inclusivity within their teams or organisations. Course Objectives By the end of this course, participants will be able to: Understand the concept and importance of psychological safety. Recognise how psychological safety impacts team performance and wellbeing. Identify behaviours and practices that support or undermine psychological safety. Develop strategies to create inclusive, respectful, and open team cultures. Apply tools to encourage constructive feedback, innovation, and open dialogue. Course Outline Module 1: What is Psychological Safety? Definition and origin (Dr Amy Edmondson’s research) Why psychological safety matters: the business and human case Link between psychological safety, innovation, collaboration, and retention Misconceptions: It’s not about comfort or avoiding challenge Module 2: Assessing the Current Environment Signs of a psychologically safe vs unsafe environment Common team behaviours and leadership pitfalls Self-assessment: how psychologically safe is my team? Module 3: Building the Foundations The four stages of psychological safety: Inclusion safety Learner safety Contributor safety Challenger safety Role of trust, empathy, and emotional intelligence The leader’s role in creating safe environments Module 4: Practical Strategies to Foster Safety Encouraging open communication and constructive disagreement Creating space for risk-taking and vulnerability Responding to feedback and mistakes without blame Speaking up behaviours – how to model and support them Module 5: Embedding Psychological Safety into Team Culture Meeting practices that promote psychological safety How to give and receive feedback safely Inclusive decision-making and respectful challenge Recognising and rewarding candour and contribution Module 6: Leading with Psychological Safety Coaching conversations and active listening Managing difficult conversations and underperformance safely Supporting neurodiverse or marginalised voices Sustaining safety under pressure and during change Delivery Style Facilitated discussions and group work Role plays, reflection activities, and real-life scenarios Peer learning and action planning Optional pre-work or post-session surveys Course Materials Provided Participant workbook Psychological safety assessment toolkit Conversation starter guide Leadership checklist for building safety Personal and team action plan Optional Add-ons Team psychological safety assessments (anonymous survey) Post-course coaching or leadership debrief Co-delivery with DEI (Diversity, Equity & Inclusion) workshops Integration with feedback or team development programs

Overview This is a 2 day applied course on XVA for anyone interested in going beyond merely a conceptual understanding of XVA and wants practical examples of Monte Carlo simulation of market risk factors to create exposure distributions and profiles for derivatives used for XVA pricing Learn how to do Monte Carlo simulation of key market risk factors across major asset classes to create exposure distributions and profiles (with and without collateral) for derivatives used for XVA pricing. Learn how to calculate each XVA. Learn sensitivities of each XVA and how XVA desks manage these. Learn regulatory capital treatment of counterparty credit risk (both for CCR and CVA volatility) and how to stress test this within ICAAP or system-wide external, supervisor-led capital stress test. Who the course is for Anyone involved in OTC derivatives XVA traders XVA quants Derivatives traders and salespeople Risk management Treasury staff Internal audit and finance Course Content To learn more about the day by day course content please click here To learn more about schedule, pricing & delivery options, book a meeting with a course specialist now