Based in Milton Keynes and set up for remote working
CV / Resume available on request
Cost Effective Data Solutions
From sorting out a spreadsheet to helping to develop solutions
Data Cleansing, Analysis, Visualisation, Modelling
Avoid Excess Development costs
I am my own recruitment agency in Milton Keynes
Book your slot for a chat
Office-365.png
Spreadsheets

​Making life simpler. 

Even the simplest spreadsheet can prove challenging and small tweaks can improve productivity.

Excel is one of the most adaptable programs at your disposal. It can be used:

  • as a simple calculator

  • as a form template

  • as a single use ready-reckoner, fact finder or questionnaire

  • to interrogate data extracts

  • as a primary data extraction, translation and output tool using Power BI or Power Pivot

Book a call now to see if we can identify simple fixes that could make life simpler for you and your staff:

  • Avoiding Cut & Paste fatigue

  • Data formatting

  • Dashboards

Learn more in the video below...

  • LinkedIn
030 Dashboard 1.JPG
Data Management

When Spreadsheets can no longer cope...

When:

  • data increases,

  • functions get more complex, 

  • your user base increases,

spreadsheet may no longer be able to cope.

Locally / internally, you could leverage the added functionality in Access Database and/or central storage solutions like OneDrive or SharePoint. These and more are readily available in your Microsoft 365 accounts.

You could buy an off-the-peg solution, or hire a developer, but

this is where it gets expensive, especially if you get it wrong.

This is where robust data modelling comes into its own.

 

Learn more in the video below...

ComTut gov and flow.jpg
Governance

When complexity increases

who does what, when and how?

The graphic above summarises:

  • Data Flow - source to end user

  • Who does what?

  • Continuous Improvement loop

----------

Cost of Poor Quality

In system development terms Cost of Poor Quality refers to the ongoing costs developers charge to make corrections to a poorly specified systems, AND the cost of ongoing support for the stuff you can’t afford to have fixed. 

The poorer the design, the higher the support cost

A robustly modelled solution means your specification can be more detailed, saving 10's, maybe 100's of thousands of pounds.

Learn more in the video below...

Whether you just want help sorting out a spreadsheet,

your ready to move onto a more robust local solution,

or you need help building a test model

----------

Get In Touch