Detangling: Excel Detective

Here’s where I don my deerstalker and dig out my spyglass to act as an Excel Detective.

Many, many companies have Excel spreadsheets, macros and data processes which they have inherited. Perhaps they were set up by a member of staff who has now left, or maybe they were built by a consultant who you’re no longer working with. Either way the spreadsheet doesn’t quite fit your current business requirements or staff don’t have the knowledge of Excel to fully understand how the formulas or macros works, often causing frustration, wasted time (money!) and inaccuracies.

Working primarily in Shropshire, Staffordshire, Herefordshire and Worcestershire I can help you by examining your data, business processes and existing tools and talking with you and your staff to understand what and how you want your business to work. Together we can unpick these legacy spreadsheets and rebuild them for your current business needs, leaving staff fully understanding how they work and back in control of your data.

Contact me for a chat, and I can come and investigate with the aim of leaving your business tools doing the job they’re meant to do.

Imagine Shropshire Profile

I was delighted to have been asked by the Imagine Shropshire site if they could feature me for the “Jelly Profile” after going along to the last Shrewsbury Jelly.   Imagine Shropshire is a community driven site whose aim is to spread the word about Shropshire and celebrate its people, places and events.  Or as Kirsty Burgoine, the web developer behind it says: “It is a ‘grass roots’ project showcasing all those hidden gems Shropshire has to offer.” Not sure I’d quite class myself as a gem but my short profile has just been updated on their website, see me here.


Next post: Excel Detective. What’s that all about then? Well I’ll tell you next week.

Detailing: Management Information Analyst

“Knowledge is power” – Francis Bacon

Knowledge is power, but sometimes accessing that knowledge can be overwhelming, and let’s face it for many people data is nothing more than a cumbersome burden. As a Data Analyst and Management Information Expert I’ve over 15 years experience in helping companies to understand more about their business through sifting their data. But what sort of data, what is business intelligence and what sort of help can it be to your company?

Well variety is the spice of life and I’ve a number of transferrable skills and expertise which I can bring to any kind of data. For example I’ve:

  • worked with finance teams to review the costs of third party suppliers and identified errors and anomalies – this on two dozen archive boxes of invoices
  • looked at the fuel consumption of a fleet of vehicles, analysing patterns in consumption and helped to identify problems as well as showing where efficiences could be made and putting together a tool to forecast future consumption – on a vehicle fleet of thousands of vehicles
  • analysed attendance records of participants at activities – covering a dozen centres and looking back over 6 years to build profiles of users and centres.
  • analysed non payment records to help inform future decision making around client’s behaviour
  • forecast energy consumption and built tools to enable drill down access to client’s individual records

By using my skills in data manipulation (Excel, VBA, Access and SQL) I can help you pull out facts from your data and design management information systems to monitor and track your key performance measures. I use a variety of tools and depending on the amount of data involved can work with you to identify what data tools best suit your business. For example is Excel the right place for your data? Should you be converting to Access or an SQL database?

As well as working on one-off data mining projects I’ve built a number of reporting tools to collate data and present it in meaningful ways on a regular basis. I’m passionate about helping people understand their data and hope that this passion translates into userfriendly and understandable reports and dashboards that can be used to monitor key pieces of management information and key performance indicators.

I’ll expand more over the coming weeks but in the meantime if you’re based in Shropshire, Staffordshire, Hereford, Worcestershire or the surrounding counties then do drop me a line if you’d like to discuss how I can help you then get in touch or leave me a comment below.

My next post will be around my work on breaking down existing spreadsheets and processes as an Excel detective but tell me, what do you want to know about me and about Deaconsulting?


Oscar speech time

A quick post to say thank you for all the feedback that I’ve had on the website since it launched this week.  If you’ve any feedback please do post a comment below or use the contact form to get in touch.

Setting up your own business is a roller coaster of emotions, but even in its embryonic stages of development I’ve had some fabulous support to get this far.  Too many people to thank individually: real life supporters (I can’t list you all) advice and support from Jan, Claire and Fay, virtual friends on twitter and a host of others wishing me well. I thank you all. In particular thanks to attendees of the recent Coalport and Shrewsbury Jellies (such as Nick, Kirsty, Ben, Hollie and Helen) who’ve helped inspire me to take the plunge and supported me with a few practicalities. To find out more about a Jelly see the comprehensive UK Jelly site and I’ll be blogging about my experience in future weeks.

Enough with the Oscars, next week I’ll post a little more about my services and how I can help make a difference to your business. Check back on Monday for information about my background working with Management Information. Have a great weekend.