2025 Best Practice Guide
Raising Standards

Conferences

The Forum holds key conferences through out the year including our flagship Spring Customer Strategy and Planning, Summer Best Practice Showcase and Autumn #RaisingStandards conferences that offer a great opportunity to learn, share and network.

2025 Summer Best Practice Showcase (Virtual)

16th June - 22nd August 2025

Learn WHAT our award finalists are doing to continue “Raising Standards in Customer Operations”
This conference offers a unique chance for you to learn directly from our Awards winners. You will hear from the teams and individuals who are making a difference in their business, powerful partnerships whether that is with a technology provider or an outsource partnership. Finally, you can discover how large transformation projects have made massive changes in any business.

2025 Autumn: #RaisingStandards (Virtual)

13th - 17th October 2025

Learn HOW you can apply "Best Practice"
Designed specifically for Planning, Insight and Quality & Customer Experience Professionals. Learn first-hand from practitioners and business leaders who are delivering successful change whilst having the opportunity to collaborate with others. Bring new ideas and techniques back that will raise standards within your “Customer Operation”.

2025 Autumn Conference #RaisingStandards (In-Person)

Wednesday 5th November 2025, Coventry Building Society Arena

Learn HOW our community is applying “Best Practice”
This conference is designed specifically for Planning, Insight and Quality & Customer Experience Professionals. Learn first-hand from practitioners and business leaders who are delivering successful change whilst having the opportunity to collaborate with others. Bring new ideas and techniques back that will raise standards within your “Customer Operation”.

2026 Spring Customer Strategy & Planning Conference (In-person)

Tuesday 28th April 2026, Grand Hotel Gosforth Park, Newcastle

Learn WHY we need to keep “Raising Standards in Customer Operations" 
Our flagship Conference, this highly rated event is far more than just a conference. Designed specifically to focus on the hot topics within the industry and thought leadership whilst also delivering practical skills with new ways of thinking that will enhance you as a person. 

2026 Summer Best Practice Showcase (In-person)

Thursday 25th June 2026, Queens Hotel, Leeds

Learn WHAT our award finalists are doing to continue “Raising Standards in Customer Operations”
This conference offers a unique chance for you to learn directly from our Awards winners. You will hear from the teams and individuals who are making a difference in their business, powerful partnerships whether that is with a technology provider or an outsource partnership. Finally, you can discover how large transformation projects have made massive changes in any business.

On-Demand Conferences

Catch up on the presentations from our previous conferences.
Box Set: Power Query - Automating with Excel

Published on 05 August 2021

Box Set: Power Query - Automating with Excel

Watch at your own Pace


As analysts we can spend a lot of our time on repetitive tasks. Copying and pasting data from one file to another, cleaning and combining our data to produce regular reports. This is not only tedious and time consuming but it also can lead to errors.

Automating this work can free up our time to do more rewarding work and deliver extra value.

There are many systems out there that allow us to automate, but what if we don't have these. We can still do a great deal of automation using the power query functionality in excel.

In this box set we will cover    

1. Power Query Introduction

  • This module introduces the power query box set and covers:
  • An introduction to the concept of conditional probability and its role in interpreting and forecasting data.
  • The historical background and theoretical foundation of conditional probability, as established by Thomas Bayes.
  • The significance of considering underlying conditions in data analysis to avoid skewed conclusions across various practical scenarios.

2. Power Query - Data Structure
This module covers:

  • Structuring data in Power Query for clear, detailed reporting and to identify improvement opportunities.
  • Creating consolidated data sources for specific reporting needs, like agent dashboards, whilst considering data granularity and aggregation.
  • Utilising data management techniques, such as table formatting in Excel, to simplify report building and ensure accurate, dynamic data analysis.

3. Power Query - Importing Data
This module covers:

  • Importing various data types into Excel and consolidating them into a single workbook using Power Query to streamline analysis.
  • The advantages of using Power Query over manual data entry, including time-saving and error reduction.
  • Demonstrating the process of updating and refreshing imported data in Excel to ensure the analysis reflects the most current information.

4. Power Query - Cleaning Data
This module covers:

  • The challenges of working with data that is inconsistently formatted or incorrect due to manual entry errors or system capture inconsistencies.
  • Utilising Power Query in Excel to clean and standardise data, which involves transforming text entries, removing unwanted characters, and correcting errors to ensure uniformity.
  • The importance of data validation and consistency for analysis, demonstrating the process of cleaning data to align with the desired format and saving the cleaned results for efficient future analysis.

5. Power Query - Appending Data
This module covers:

  • Appending data from multiple Excel sheets into one to consolidate information.
  • Removing duplicates after merging to ensure data accuracy.
  • Renaming the query for clarity and easier future reference.

6. Power Query - Automating Formulae
This module covers:

  • Automating Excel formulas within queries to enhance data analysis, with a focus on formula integration for efficiency.
  • Step-by-step guidance on adding custom columns in Power Query for handling dates, and segmenting data into week, month, and year for simplified reporting.
  • Techniques for calculating metrics such as speed of answer and talk time from call data, along with instructions for adjusting data types and formatting in the query editor.

7. Power Query - Combining Data

  • This module covers:
  • Merging data from different sheets into one using Power Query.
  • Detailed instructions on combining data, with emphasis on correct matching and handling duplicates.
  • Guidelines for final sheet management, including data protection and refresh options to maintain data integrity and relevance.
     

The learning is in bite sized chunks that you can watch and we watch at your own speed. With practical exercises you can complete as you go.
Then become an accredited by sharing how you have applied this learning in your own role.

To find out more and see if you have a compatible version of excel, watch the introduction video below.


The cost of this mini series including accreditation is great value at £325 + VAT and free for students on our assisted learning pathway.

Comments (0)Number of views (11379)

Author:

Categories: Box Sets

Tags:

Print
As a member, you are not on your own but part of a community with others facing many similar challenges. We are here to help you to make a tangible impact in your organisation and show how developing the capability of each specialist professional function is fundamental to your business.
Book for one of our events to experience our exceptional community or get in touch to talk about how we can help you and your teams to be fully effective in adding value to your business. Email advice@theforum.social, call 0333 123 5960 or contact any of The Forum Team