• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

Data Analysis and Visualization with Microsoft Excel

By Mpi Learning - Professional Learning And Development Provider

This course is designed for students who already have foundational knowledge and skills in Excel and who wish to perform robust and advanced data and statistical analysis with Microsoft Excel using PivotTables, use tools such as Power Pivot and the Data Analysis ToolPak to analyze data and visualize data and insights using advanced visualizations in charts and dashboards in Excel.

Data Analysis and Visualization with Microsoft Excel
Delivered in Loughborough or UK Wide or OnlineFlexible Dates
£55

Data Ethics for Business Professionals

By Mpi Learning - Professional Learning And Development Provider

Data Ethics for Business Professionals is designed for individuals who are seeking to demonstrate an understanding of the ethical uses of data in business settings.

Data Ethics for Business Professionals
Delivered in Loughborough or UK Wide or OnlineFlexible Dates
£45

How to Conduct and Write Systematic Literature Reviews

By Research'Kraft Consulting

Workshop objectives 1-Introduction to Systematic Reviews 2- Formulating the Research Question 3- Developing a Protocol 4- Literature Search 5- Study Selection 6- Data Extraction 7- Quality Assessment: 8- Data Synthesis 9- Reporting and Publication: 10- How to write a scoping review A certificate from Research'Kraft will be given after successful completion.

How to Conduct and Write Systematic Literature Reviews
Delivered in person or OnlineFlexible Dates
£40

CS3 - Introduction to Working as a Member of a Confined Space Rescue Team

By Vp ESS Training

This course is designed to provide delegates that intend to work as part of a confined space rescue team with an introduction to planning and executing casualty rescue procedures and the equipment which may be required. This is intended for delegates who already hold a high risk (full Breathing apparatus) qualification such as our CS2. Note: A pre-requisite qualification is required to complete this course. The ESS CS2 course (https://www.vp-ess.com/training/confined-spaces/cs2-(high-risk)-confined-space-entry-full-breathing-apparatus,-self-rescue-and-ba-control/) must have been completed within 6 months as a pre-requisite for this CS3 course. Book via our website @ https://www.vp-ess.com/training/confined-spaces/cs3-introduction-to-working-as-a-member-of-a-confined-space-rescue-team/ or via email at: esstrainingsales@vpplc.com or phone on: 0800 000 346

CS3 - Introduction to Working as a Member of a Confined Space Rescue Team
Delivered In-Person in Aberdeen + 9 more or UK WideFlexible Dates
FREE

Motivational Interviewing: Introductory & Refresher 2-day In-person CPD training workshop

By MI Cardiff Workshops

Motivational Interviewing Introductory & Refresher 2-day In-person CPD training workshop Thursday 13th and Friday 14th February 2025 his 2-day workshop will be of interest to people in diverse settings and circumstances where conversations about change are an everyday reality. A wide range of learning methods are used to create an enjoyable atmosphere for learning and sharing ideas. These will include demonstration, video observation, brief content lectures, discussion, and focused practice. It is an introduction to Motivational Interviewing for some participants and a refresher for those people who have attended MI training previously.

Motivational Interviewing: Introductory & Refresher
2-day In-person CPD training workshop
Delivered In-PersonFlexible Dates
FREE

Power BI - introduction to intermediate (2 days) (In-House)

By The In House Training Company

This course starts with the basics then moves seamlessly to an intermediate level. It includes a comprehensive yet 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 use the online Power BI service. It looks at authoring tools that enables you to connect to and transform data from a variety of sources, allowing you to produce dynamic reports using a library of visualisations. Once you have those reports, the course looks at the seamless process of sharing those with your colleagues by publishing to the online Power BI service. The aim of this course is to provide a strong understanding of the Power BI analysis process, by working with real-world examples that will equip you with the necessary skills to start applying your knowledge straight away. 1 Getting started The Power BI process Launching Power BI Desktop The four views of Power BI Dashboard visuals 2 Connecting to files Connect to data sources Connect to an Excel file Connect to a CSV file Connect to a database Import vs. DirectQuery Connect to a web source Create a data table 3 Transforming data The process of cleaning data Column data types Remove rows with filters Add a custom column Append data to a table Fix error issues Basic maths operations 4 Build a data model Table relationships Manage table relationships 5 Merge queries Table join kinds Merging tables 6 Create report visualisations Creating map visuals Formatting maps Creating chart visuals Formatting chart Tables, matrixes, and cards Control formatting with themes Filter reports with slicers Reports for mobile devices Custom online visuals Export report data to Excel 7 The power query editor Fill data up and down Split columns by delimiter Add conditional columns Merging columns 8 The M formula Creating M functions Create an IF function Create a query group 9 Pivot and unpivot tables Pivot tables in the query editor Pivot and append tables Pivot but don't summarise Unpivot tables Append mismatched headers 10 Data modelling revisited Data model relationships Mark a calendar as a date table 11 Introduction to calculated columns New columns vs. measures Creating a new column calculation The SWITCH function 12 Introduction to DAX measures Common measure categories The SUM measure Adding measures to visuals COUNTROWS and DISINCTCOUNT functions DAX rules 13 The CALCULATE measure The syntax of CALCULATE Things of note about CALCULATE 14 The SUMX measure The SUMX measure X iterator functions Anatomy of SUMX 15 Introduction to time intelligence Importance of a calendar table A special lookup table The TOTALYTD measure Change year end in TOTALYTD 16 Hierarchy, groups and formatting Create a hierarchy to drill data Compare data in groups Add conditional formatting 17 Share reports on the web Publish to the BI online service Get quick insights Upload reports from BI service Exporting report data What is Q&A? Sharing your reports 18 Apply your learning Post training recap lesson

Power BI - introduction to intermediate (2 days) (In-House)
Delivered in Harpenden or UK Wide or OnlineFlexible Dates
Price on Enquiry

Introduction to contract management (In-House)

By The In House Training Company

This very practical one-day IACCM-approved programme enables participants to manage the process of commercial contracting and contract management effectively and efficiently to ensure value for money, improved service, and appropriate relationships. It covers a wide range of contract types in terms of risk and value. The programme empowers participants with the tools and techniques needed to collaborate with all key stakeholders. By the end of the programme participants will be able to: Understand the total process of managing contracts Exploit opportunities to extract even more added value Develop appropriate relationships with contractors Understand and use a range of contracting strategies and options Measure and improve contract performance Understand the impact of legislation on contract performance 1 Welcome Introductions Aims and objectives Plan for the day 2 Contract management An overview of the contracting process, mapping the 'territory' 3 Contract managers Skills Knowledge Attributes Responsibilities 4 Critical success factors Defining successful outcomes Effective stakeholder engagement Creating a shared vision of the outcomes 5 Placing contracts How to develop an effective specification and scope of work documents How to develop a robust contracting strategy Appropriate types of contract 6 Customers and stakeholders Customer and stakeholder analysis Managing expectations and the 'shared vision' concept to ensure customer co-operation, satisfaction, and delight 7 Working with suppliers Creating and developing commercial relationships Types of relationship How to manage difficult relationships Contractor motivational issues How to use incentives 8 Negotiation and related skills Introduction to key negotiation skills Persuading and influencing skills to work with stakeholders to improve outcomes for all 9 Dealing with change Claims and variations How to challenge contractor claims and requests for variations by making use of contractual terms Specifications to prevent false claims 10 Performance improvement How to measure and improve contractor performance Developing KPI systems Using contractual terms and conditions and basic legal principles 11 Contract close The importance of effective contract close processes 12 Close Review of key learning points Personal action planning

Introduction to contract management (In-House)
Delivered in Harpenden or UK Wide or OnlineFlexible Dates
Price on Enquiry

Legionella/Water Quality Risk Management – General Awareness

By HYDROP E.C.S.

Our Legionella/Water Quality Risk Management – General Awareness course offers a basic introduction to Legionnaires' disease Management and Control.

Legionella/Water Quality Risk Management – General Awareness
Delivered in Sutton Coldfield or UK Wide or OnlineFlexible Dates
Price on Enquiry

Introduction to Data Science - free for Medway residents

By futureCoders SE

Learn the basics of Data Science, combining a supported #CISCO Skills for All online course with practical learning and a project to help consolidate the learning.

Introduction to Data Science - free for Medway residents
Delivered in Medway or UK Wide or OnlineFlexible Dates
FREE

Motivational Interviewing: Advancing Practice 2-day In-person CPD training workshop

By MI Cardiff Workshops

Motivational Interviewing Advancing Practice 2-day In-person CPD training workshop Thursday 7th & Friday 8th November 2024 his 2-day workshop will be of interest to people in diverse settings and circumstances where conversations about change are an everyday reality. A wide range of learning methods are used to create an enjoyable atmosphere for learning and sharing ideas. These will include demonstration, video observation, brief content lectures, discussion, and focused practice. It is an introduction to Motivational Interviewing for some participants and a refresher for those people who have attended MI training previously.

Motivational Interviewing: Advancing Practice 2-day In-person CPD training workshop
Delivered In-PersonFlexible Dates
FREE