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
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...
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...​​
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