5061 Courses

This course starts with data transformation strategies, exploring capabilities in the Power Query Editor, and data-cleansing practices. It looks at the Advanced Query Editor to view the M language code. This course focuses on advanced DAX measures that include filtering conditions, with a deep dive into time intelligence measures. Like the M query language, DAX is a rich functional language that supports variables and expression references. This course also looks at the creation of dynamic dashboards and incorporates a range of visualisations available in Power BI Desktop and online in the AppSource. The course finishes with a look at setting up end user level security in tables. 1 The query editor Split by row delimiter AddDays to determine deadlines Advanced query editor 2 Fuzzy matching joins Matching inconsistencies by percentage Matching with transformation table 3 Logical column functions Logical functions IF, AND, OR Using multiple conditions Including FIND in functions 4 Editing DAX measures Make DAX easier to read Add comments to a measure Using quick measures 5 The anatomy of CALCULATE Understanding CALCULATE context filters Adding context to CALCULATE with FILTER Using CALCULATE with a threshold 6 The ALL measure Anatomy of ALL Create an ALL measure Using ALL as a filter Use ALL for percentage 7 DAX iterators Anatomy of iterators A closer look at SUMX Using RELATED in SUMX Create a RANKX RANKX with ALL 8 Date and time functions Overview of functions Create a DATEDIFF function 9 Time intelligent measures Compare historical monthly data Create a DATEADD measure Creating cumulative totals Creating cumulative measures Visualising cumulative totals 10 Visualisations in-depth Utilising report themes Create a heatmap Comparing proportions View trends with sparklines Group numbers using bins Setting up a histogram 11 Comparing variables Visualising trendlines as KPI Forecasting with trendlines Creating a scatter plot Creating dynamic labels Customised visualisation tooltips Export reports to SharePoint 12 User level security Setting up row level security Testing user security

There is a lot to learn in Power BI, this course takes a comprehensive look at the fundamentals of analysing data and includes a 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 utilise the online Power BI service. It looks at authoring tools that enable you to connect to and transform data from a variety of sources, allowing you to produce detailed reports through a range of visualisations, in an interactive and dynamic way. It also includes a detailed look at formulas by writing both M functions in Power Query, and DAX functions in Desktop view. This knowledge will allow you to take your reports to the next level. The aim of this course is to provide a complete introduction to understanding the Power BI analysis process, by working hands-on with examples that will equip you with the necessary skills to start applying your learning straight away. 1 Getting Started The Power BI ecosystem Opening Power BI Desktop Power BI's four views Introduction to Dashboards 2 Importing Files Importing data sources Importing an Excel file Importing a CSV file Importing a database Connect to an SQL Server Database Import vs. Direct Query Importing from the web Importing a folder of files Managing file connections 3 Shape Data in the Query Editor The process of shaping data Managing data types Keeping and removing rows Add a custom column Appending tables together Hiding queries in reports Fixing error issues Basic maths operations 4 The Data Model Table relationships Relationship properties 5 Merge Queries Table join kinds Merging tables 6 Inserting Dashboard Visuals Things to keep in mind Inserting maps Formatting Maps Inserting charts Formatting Charts Inserting a tree map Inserting a table, matrix, and card Controlling number formats About report themes Highlighting key points Filter reports with slicers Sync slicers across dashboards Custom web visuals 7 Publish and share Reports Publishing to Power BI service Editing online reports Pinning visuals to a dashboard What is Q&A? Sharing dashboards Exporting reports to PowerPoint Exporting reports as PDF files 8 The Power Query Editor Fill data up and down Split column by delimiter Add a conditional column More custom columns Merging columns 9 The M Functions Inserting text functions Insert an IF function Create a query group 10 Pivoting Tables Pivot a table Pivot and append tables Pivot but don't aggregate Unpivot tables Append mismatched headers 11 Data Modelling Expanded Understanding relationships Mark a date table 12 DAX New Columns New columns and measures New column calculations Insert a SWITCH function 13 Introduction to DAX Measures Common measure functions Insert a SUM function Insert a COUNTROWS function Insert a DISTINCTCOUNT function Insert a DIVIDE function DAX rules 14 The CALCULATE Measure The syntax of CALCULATE Insert a CALCULATE function Control field summarisation Things of note 15 The SUMX measure X iterator functions Anatomy of SUMX Insert a SUMX function When to use X functions 16 Time Intelligence Measures Importance of a calendar table Insert a TOTALYTD function Change financial year end date Comparing historical data Insert a DATEADD function 17 Hierarchies and Groups Mine data using hierarchies Compare data in groups

Belonging & Connection

To give you a good understanding of the long medical journeys a trans person undergoes, together with an understanding of the reference terms in common use, including language and terminology, cis-gender, non-binary, intersex, the pathways from M to F and F to M with the key stages in each pathway, the lived experiences of the facilitators plus a short life story video, LGBT facts, gender clinics, how to support a trans child, equality in the workplace, the laws surrounding gender and equality and how they affect you, and so much more…… Who is this course for? Everyone is the simple answer. Everyone and particularly those in a public-facing role, be that the police or other emergency services, to business managers, ship captains and shop floor workers. What will it cost? Both face to face and Teams presentations are charged at the same rates, which are very competitive. Face to face would incur travel and accommodation etc, as applicable How large are the groups? We will only normally accept a maximum of 20 people in each presentation, as this allows everyone the opportunity for questions, and allows us to keep to the 4 hour duration. We can, however, work with larger groups by negotiation, typically up to a total of 50 people. How will I benefit from this course? You will learn about the full pathways to allow you to be more understanding, and you will understand how to address a trans person without causing offence Do we get handouts? All participants receive a comprehensive workbook either in person or electronically. What is the course content? Language & terminology, intersex, non-binary, use of pronouns, pathways from male to female & female to male, key stages in each pathway, supporting trans children, facts and figures, personal life stories of the facilitators together with a video presentation, equality in the workplace, important legislation and how it affects you and more How are the courses delivered? This presentation is delivered as a face to face session for businesses and organisations around the UK. Alternatively it can be delivered using Teams. There is a lot of hatred towards the trans community, will I get harangued? Yes, there is hatred but by educating people on this subject we aim to achieve a more inclusive society, not just in the UK, but around the world also. I want to book a complete session for my staff, is there a group discount available? Yes, for any large group booking we are negotiable. Is this course recognised? Yes, it is a fully accredited CPD course for which you will receive a certificate upon completion Upcoming public/open courses These are arranged according to demand.

Some people naturally possess an ability to sell and others over time develop their own style. We have created a highly practical course to give you the confidence and ability to sell over the phone or face to face. We focus the exercises, theory and discussion on your own job role and experiences to ensure you can return to the workplace to deliver tangible results. This 2-day course is designed for individuals who are new to selling, those in a sales role but have not received any formal training, or professionals who would like to brush up and enhance their current selling skills and learn some new techniques. Course Syllabus The syllabus of the Essential Selling Skills course is comprised of seven modules, covering the following: Module One Understanding the Customer The importance of good customer care Selling vs. selling attitude The reasons people buy Adopting a positive approach Module Two Self-Awareness Understanding your selling style Adapting your selling style to your customer Understanding your customers buying style Module Three Effective Communication and Rapport Building Why does communication need to be effective? Actively listening to your customers' needs Right question at the right time The impact of positive and emotive language Module Four Taking a Consultative Approach Different styles of selling Taking a consultative approach to selling Preparation techniques Buyer behaviour and motivation A selling approach to match the buyers mind Module Five Presenting the Solution Selling the benefits Sales tool kit Unique sales points Advanced questioning techniques Module Six Gaining Commitment Recognising and acting upon buying signals Dealing with customers concerns No means no? How to cope in stressful situations Module Seven Confirming the Sale Confirming or closing? Effective confirming techniques Going the extra mile Benefits For you as an individual This course will increase your confidence and ability to sell, having provided you with tools and techniques to achieve maximum results. Delegates always leave with fresh ideas, energy and motivation to succeed. For an employer The attitude of the delegates and the results they deliver will speak for themselves. All techniques are easy to apply back into the workplace for an immediate impact. What will I learn? By the end of the course, participants will be able to: Appreciate the need for preparation before a sales appointment Effectively identify and meet needs with advanced questioning techniques Identify verbal and non-verbal buying signals Construct professional answers to questions and possible objections Present your products and/or services with the buyer in mind Identify and use a selling style appropriate to capture the buyer's attention Recognise and overcome major objection types How to apply effective confirmation techniques with the buyer in mind Real Play Option We offer an innovative solution to engage the learners and bring real negotiation and closing scenarios to life. We use actors who improvise scenarios which have been specified by the group. The group is split the group into 2 sub-groups, one with the actor, the other with the trainer. Each group has a brief and has to instruct their trainer/actor on how to approach the scenario supplied. The actor and trainer perform the role play(s) as instructed by their respective teams; however during the action they can be paused for further recommendations or direction. The outcome is the responsibility of the team(s) - not the performers. Scheduled Courses This course is not one that is currently scheduled as an open course, and is only available on an in-house basis. For more information please contact us.

RSPH level 2 Identifying and Controlling Food Allergy Risks Training Course Do you need an allergy trainer to come to your food business and teach your staff face to face about food and drink allergens, their dangers and how to control them? Our allergy trainer can come to your business and deliver this course at your business premises. Although we are based in London, we are happy to travel and deliver this course at your business location. (Trainer travel fees may be applicable depending on your location). Staff will receive interactive training and coaching on allergens and intolerances with an experienced trainer. We can also tweak the training to include issues you would like to cover. See our website for more details. Special offer for on-site allergy training. £250 plus £20pp includes RSPH exam fees (usually £350 plus £30pp) This course is suitable for any catering business such as restaurants, pubs, hotels, cafes, catering companies, cooks, self employed, artisans, event caterers and more. This course is also important for staff who are Front of House, who take customer orders and relay the orders to cooks and chefs and other people who are preparing food for customers who have allergies and or intolerances. This is a short one day training course, typically 9am-3pm. Topics covered include- Allergens, Allergen Identification, Cross contact, Cross Contamination, Allergic Reactions, Food Intolerances, Coeliac, Anaphylaxis, Natasha's Law, UK Food Safety Regulations, Allergy Controls, Substituting ingredients, Customer Communication and what to do in an Emergency. Contact us to book training.

Learn the key skills to become a Manager in an organisation. How can you get the best from your new team. Course overview Duration: 2 days (13 hours)  This workshop is suitable for those who have recently started their first direct line management role. This is a practical workshop and focusses on understanding the role of a people manager in managing workloads amongst the team, the individuals within their team and getting the best out of the team. Objectives  State the key roles and responsibilities of a people manager Use your time effectively to plan and prioritise your own and the work of others for expedient results Set objectives that engage those reporting to you Delegate tasks effectively that motivate the individuals you delegate to Appreciate how to deal with both good and under-performance Adopt the most appropriate leadership style Manage the team through its natural development and through times of change Add value to meetings you attend and chair Content Roles and Responsibilities Understanding your roles and responsibilities for people management Management vs Leadership Action Centred Leadership Managing Workloads How to prioritise the management of tasks, the individuals and the team Objective setting – how to set objectives and how to engage individuals in their objectives Practical application on prioritisation and objective setting Managing Individuals Delegating tasks and work effectively Understanding motivation and how best to motivate individuals Managing performance – the Skill/Will matrix How to manage good performers Dealing with under-performance Goleman’s 6 Leadership styles Choosing the appropriate leadership style for the right person and situation Managing the Team Understanding team roles and dynamics How to manage the team as it develops Team learning and development Managing teams through times of change Tips and techniques for focused meetings

Adolescence: What have we learnt? In March 2025, the Netflix series Adolescence sparked widespread conversation about the hidden lives of young people, raising important questions about the support we provide to the youth in our care. Three months later, what have we learned? Regardless of how we engage with young people, there's valuable insight to be gained from this powerful story. We’d like to share the key takeaways and reflect on how we can better support the next generation. How the day will go Join us at 9.30 for coffee and pastries, before we hear from a guest speaker on the impact Adolescence has had on their context. Following a short coffee break we will then have time to explore how we can each respond, using the Open Space Technology conference tool to create opportunities for the conversations that will help us to move forward appropriately. We will end with lunch at 12.30pm. Key Information We will be gathering at Youthscape in Luton, which is conveniently located next to Luton Train station, for those traveling by train. For those driving, please note that the car park directly outside Youthscape is no longer available, the closest car park can be located on Power Court, just a 5 minute walk from the venue.

Overview The objective of this course is to equip professionals with comprehensive knowledge and practical skills in WEB 3 technologies and crypto assets. Participants will gain a deep understanding of the underlying principles of blockchain, the operational mechanics of cryptocurrencies, the potential impact of these technologies on the banking sector and the latest trends. Who the course is for Consultants Analysts Managers C-Level executives People in need of knowledge to develop a blockchain strategy People working with blockchain projects Regulators 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

Successful Teams