Susan Walsh - The Classification Guru

The Classification Guru Ltd

I love improving the quality of procurement spend data, giving teams clarity so they can make better business decisions and cost savings.

Why not let me take the pain out of laborious data issues and make your life easier?

Whether it's a small or large data set, the accuracy can be improved by identifying classification errors, conflicts or gaps. I can provide a data verification service to efficiently find and correct these in a fraction of the time it would take you or a team member.

And a crucial part of having accurate data is also working with a comprehensive taxonomy, something that can be easily overlooked. I can provide a taxonomy development service to ensure you have all the vital areas covered for the greatest visibility - job done!

If you struggle with the time, resources or willingness to tackle your data, why not get in touch to see how I can make your life easier.

Founder/MD (Mistress of Data)

I love improving the quality of procurement spend data, giving teams clarity so they can make better business decisions and cost savings.

Why not let me take the pain out of laborious data issues and make your life easier?

Whether it's a small or large data set, the accuracy can be improved by identifying classification errors, conflicts or gaps.  I can provide a data verification service to efficiently find and correct these in a fraction of the time it would take you or a team member.

And a crucial part of having accurate data is also working with a comprehensive taxonomy, something that can be easily overlooked.  I can provide a taxonomy development service to ensure you have all the vital areas covered for the greatest visibility - job done!

If you struggle with the time, resources or willingness to tackle your data, why not get in touch to see how I can make your life easier.

Founder

Data Collaboration Alliance

I am a member of the Advisory Committee at the Data Collaboration Alliance, a nonprofit organization that’s dedicated to establishing CONTROL as the basis for meaningful Data Ownership and global Collaborative Intelligence. Our approach of eliminating data silos and copy-based data integration is similar to how societies already protect the value of their currency, identities, and intellectual property - and it works for data, too. My fellow advisors include the Executive Director of the Mozilla Foundation and the ex-CIO of Dropbox. I'm also a contributor to the Data Collaboration Community which offers open datasets, free tools, and free training in the data-centric skills of the future. Visit: https://www.datacollaboration.org/community

Advisory Committee / Instructor

Facet Publishing

Dirty data is a problem that costs businesses thousands, if not millions, every year. In organisations large and small across the globe you will hear talk of data quality issues. What you will rarely hear about is the consequences or how to fix it.

Between the Spreadsheets: Classifying and Fixing Dirty Data draws on classification expert Susan Walsh's decade of experience in data classification to present a fool-proof method for cleaning and classifying your data. The book covers everything from the very basics of data classification to normalisation, taxonomies and presents the author's proven COAT methodology, helping ensure an organisation's data is Consistent, Organised, Accurate and Trustworthy. A series of data horror stories outlines what can go wrong in managing data, and if it does, how it can be fixed.

After reading this book, regardless of your level of experience, not only will you be able to work with your data more efficiently, but you will also understand the impact the work you do with it has, and how it affects the rest of the organisation.

Written in an engaging and highly practical manner, Between the Spreadsheets gives readers of all levels a deep understanding of the dangers of dirty data and the confidence and skills to work more efficiently and effectively with it.

Author - Between the Spreadsheets

CONSTELLIA LIMITED

Connecting Professional Services Procurement people to the Consultancy Procurement Council

Membership Manager

Simfoni

+ Lead spend analytics project delivery across Europe & Middle East
+ Project Implementation​
+ Delivery of product demos
+ Development and delivery of training for Analytics team
+ Product development support
+ Spend analytics
+ Taxonomy development​

Senior Analytics Project Lead - Europe & Middle East

Highways England

Project Support Officer

Philips

Data Verification

+	Administration of product database
+	Working with cross functional teams to resolve issues
+	Develop and deliver training for business hubs to improve processes

Data Product Researcher

Coupa Software

+	Project managing multiple projects simultaneously ensuring all were delivered within time and on budget
+	Management of a team of 14 QA staff
+	Developed and implemented training plan and best practice documents
+	Recruit and train new staff
+	Ensuring consistent quality of work  produced by team

QA Manager

Spend360

+	QA, classification and review of data
+	Excellent attention to detail
+	Managing workload to tight deadlines

Data Services -QA

Fixer of dirty data ★ Spend data classification, supplier normalisation, and taxonomies ★ DataIQ100 x 2 ★DataIQ Data Champion 2022★ Author "Between the Spreadsheets" ★ Creator of COAT ★ TEDx - say NO to NO ★ DataVenger

Are you struggling to get reliable insights from your data?  Do you have duplicates, multiple versions of the same supplier or customer, and multiple date and address formats?  And is it saved in multiple different systems?

The Classification Guru can help.

If you’re in procurement, do you find it hard to see how much you are really spending with one supplier, and on what?  Have you got free text descriptions which mean you have multiple versions of the same item, often misspelt and not against the correct GL or categorisation? How can you make the best negotiations with your suppliers, the biggest cost savings, or manage your supplier list if you don’t have the correct information?

Or if you work in sales or marketing, is your CRM full of junk data, poorly formatted and even missing information, and maybe saved in multiple different systems?  Your team could be wasting time contacting redundant leads, or worse you could be sending out expensive print out to the same address twice, or addresses that don’t even exist.

We bring clarity and accuracy to data and help teams work more effectively and efficiently, finding cost savings through spend and time management, supporting better, more informed business decisions, delivering a strong ROI and delivering back to your organisation faster and more cost-effectively than using large consultancies or spend analytics providers.

While most people dread having to classify or cleanse data, my team and I love it! We are hugely passionate about providing clients with accurate and meaningful data, and because I have been doing this for a decade, I can do this much faster and more accurately than people who might look at their data infrequently.

We can help prevent costly mistakes from happening.

There are many solutions available to automate data classification, but these are never 100% accurate. I've developed a method that my team use to efficiently and accurately classify, cleanse and verify data to minimise the errors in the same amount of time.

When working with large volumes of data it's hard to spot these errors even if you know what you're looking for and especially in Excel, let alone if you don't. With my team and I’s knowledge, experience and tools we can do this for you, freeing up your internal resources.

Fix your dirty data now - www.theclassificationguru.com

Entrust

To compile, report and deliver key information and trends from large and varied sets of data. The role will report to the Policy and Regulations Manager, becoming an essential resource for decision making, providing an evidence base for all proposals, reports and developments.

Data Officer

Capita

The role sits within the Performance Management and Forecast Team which is part of a wider multi-disciplinary Support Services team that covers Performance Management, Capacity and Forecasting, MI and Analysis, Scheduling & Contractor Management.

•	Creating a Database for Departments to view Employee Data and Linking it to SharePoint for easily viewing by the Management. Adding Pro-active Queries to identify Employee Attrition, Churn, and Turnover.

•	Created Macros that from one Sheet sends 200 Emails on a loop to Staff with up to 50 Task Reference Codes. Then depending on length of time outstanding Auto copies in the Manager or the Regional Manager to escalate tasks.

•	A Macro to validate Quarterly and Monthly Bonus payments to Staff for the Finance Team. To ensure accurate and timely payments.

•	Producing Power BI Report for a Rolling 7 Days and uploading them onto Microsoft Teams for the management to view performance. To see if they have achieved daily targets and view trends.

•	Data Mining from CRM Dynamics 365. Looking at the end-to-end process. Producing Innovative reports based on key audience objectives.

•	Training colleagues on complex reports. By documenting the process and recording on Video then uploaded onto MS Teams. Shadowing, providing assistance and support where necessary.

Business Data Analyst

Utility Team

Reporting directly to Director Level. Looking at current Processes for Consumption Data. Developing VBA Macros to highlight Spike, Overlaps in Consumption Data for our Clients.
Looking for Sale Opportunities in Company Data. 
Created VBA Macro to forecast & view Contract Performance Revenue for Accounts Dept & Directors. Important for Covid-19 impact on Supplier Claw Backs
Read and analyse HH data and has worked extensively with data aggregators. 
The role will be to overcome dataflow queries and issues particularly related to change of supply. 
The Data Analyst will be responsible for all operational dataflow processes and will be working closely with Data Collector/Aggregators and MOP providers.   

•	All dataflow management
•	Created VBA Macro to Monitor Contract Performance in Covid 19 times. 
•	Change of supplier issues and resolution
•	Working with HH data, MOP’s DC/DA’s
•	Auditing and review of operational processes
•	Quality management of processes
•	Generating adhoc reports for clients
•	Working with clients to help them understand their usage to look for reduction measures

Data Analyst

Providor

General Duties/Key Responsibilities: 

•	Produce Daily SAIF file to Process Dataflows for Smart Meter Exchanges for BMSL  Providor MOP 
•	Develop VBA Model to Process Dataflows from Jobwatch Application to AMOP
•	Process D0135 Dataflows Informing the DNO of Meter Faults to protect Customer Safety
•	Process Daily MOP Workflows D0001, D0005, D0134, D0142, D0194 
•	Report back to Providor Operation of Resolved DNO Call Outs on D0126 Flows
•	Investigating and Resolving data exceptions falling out of the interface between work 
•       management   systems and data flow management capabilities
•       Production of MAM/MOA billing files
•	Bill Validation were required
•	Ad hoc report production, manipulating data in Excel formats
•	Investigate And Resolve ECOES Rejections of D312 Flows
•	Produce MI Reports for my area of the Business
•	Analyse industry data and interpret unusual patterns and possible causes
•       GDPR Certified
•       Build and Maintain the Portfolio Database
•       Data Visualisation Skils with Power BI and Tableau

Industry Data Analyst

E.ON

•	Create Customers New Accounts from Developer Information in Eon’s  ICE Application.
•	Investigate and Problem solve any Migration issues such as Industry Dataflows both Power and Gas. 
•	Solve ICE Application issues in a timely manner.
•	Support Team Training for Department Migration from Leicester to Coventry Office 2017 to 2018
•	Manage MI Reports from the Team to Management at Leicester. Breakdown Reports for each Category so continuous improves to service can be made. 
•	Monitor Team Performance by Key Performance Indicators.
•	Improve MI Reporting with VBA to reduce reporting time
•	Manage Team Move within Coventry with internal stakeholders

Developer New Connections Analyst

•	Maintain industry SLA of 99% with Actual Meter reads
•	Investigate and raise D1 Data flows to the MOP (Meter Operator) to resolve meter communication line failures; keeping  supplier and customer informed, as required, to ensure timely fault resolution
•	Investigate validation failures to identity and resolve root cause. This includes errors Alarms, Overlap, Gap etc.
•	Export valid Meter Reads from Mv90 to MDR and Trigger Dataflows to the Supplier, HHDA and Distributor in a timely fashion. 
•	Use EON Applications including HHDC Query to check if Meter Read is within the Date Window.
•	Combine files in Mv90 to remove invalid status on meter reads
•	Re-Pole Meters by the Remote interrogation Tool to see if we can obtain meter reads without the Spike Errors
•	If there has been a Meter Exchange and we do not support the new meter type like ‘IP’ to email the supplier to De- appoint ourselves as the Data Collector.
•	Respond to D170 Dataflow requests to provide 14 Months (426 Days) of Data to the New DC by sending a D0036 flows.
•	Investigate the DC errors on all Gateways  PGEN, EMEB, OXPO and CNRG. These include P272 errors.

HHDC (Half Hourly Data Collector) Analyst 

First Utility

•	I work closely with internal departments to assist with any system errors and look for permeant fixes
•	Working through a variety of problem accounts to identify and then apply a fix which provides a satisfactory resolution for the customer
•	Identify and analysis trends that occur to aid in fixing the issue within a fixed SLA
•	Manage my own caseload of work through to resolution, ensuring they are completed within agreed timescales 
•	Make recommendations on improving processes and procedures to increase the productivity
•	Resolution of technical data errors to ensure customers are billed accurately and timely
•	Management and resolution of customer queries and complaints generated throughout the joining process

Technical Team Advisor

npower

•	Pricing Customers with New Acquisition and Renewal Products  
•	Producing Both Small Medium Enterprise (SME) Power and Gas Costs on a Daily Basis
•	Updating Price Models each day with Latest Costs.
•	Maintaining and Supporting with Visual Basic (VBA) code the Price Models for our Internal Sales Channels
•	Providing SPM data to the Internal Sales Channels
•	Billing Power Configuration at Admin Level, Entering Monthly and Quarterly Cycle Dates, Peel Off Dates for Group Billing, Updating Both VAT and Climate Change Levy (CCL).
•	Market Domain Data (MDD) Support, Updating Top-lines each Month with Meters which are valid and supported in our SME systems.
•	CMA Collation and Reporting

SME Price Analyst

•	Working in the Beryl Project Team to help Build and Test the New Billing System
•	Adding New Data for Setting up of the New SME Billing system.
•	Liaise with the rest of Business to support their Billing requirements.
•	Add Price Products and Billing Cycles

Beryl Billing Configurator

•	Bill Checking for Errors and then intercepted before been sent to the customer.
•	Making Sure the Correct Independent Energy Tariff had been applied to the customer’s Account.
•	Making sure the correct consumption had been applied. Fixing any Deductive Metering errors. Also Checking the Customers Max Demand, Reactive Power and Capacity Charges were correct.

Tariff and Bill Check Analyst

Data Analyst at Capita

I am a Data Analyst with Software experience, I have Worked for three Energy Suppliers, An HH Data Collector and a SME/Domestic Smart MOP.  Working in Customer Service, SME Billing, SME Pricing,  Data Flows for MOP for Smart Meters and now Energy Consultants.  I am always looking at ways of improving internal systems, for advanced efficiency and remove human error by Automating processes by VBA Macros & Python code. I have programming experience using Python 3 ( Including Jupiter Notebook, Numpy, Pandas, Matplotlib, Pyautogui. ) and MySQL and MSSQL. I have Data Visualisation Skills with Power BI and Tableau. I can create Company Databases and Automate them. MS Power BI experience in Visualising Data .  Salesforce Lighting Admin User in last current role.

taplio

The Battle

Susan Walsh - The Classification Guru

Gary Lines

Followers

Posts

Engagements

Likes

Ready to grow your LinkedIn presence?