i-nth - A case study on data quality: Find & clean skunk data with Power Query

8 July 2018

This video shows a case study where data quality issues needed to be dealt with before the results could be trusted.

The essence of the message is "...look at our data and investigate the quality of it before we start building models and complex formulas and queries ...".

Full article: A case study on data quality: Find & clean skunk data with Power Query

Essential reading

Twenty principles for good spreadsheet practice

The twenty principles for good spreadsheet practice aims to reduce the amount of time wasted and the number of errors.

Latest articles

Spreadsheets as a source of analytical and accounting problems
Self-checks in spreadsheets: A survey of current practice
The development of a structured methodology for the construction and integrity control of spreadsheet models
Refactoring meets spreadsheet formulas
Simple spreadsheet test case application to test spreadsheet formula in end-user software engineering
Proper VBA error handling
VBA Like operator – using wildcards in conditional statements
Count cells with text and formula – Excel stats
VBA: The VBA array
Excel Tables
An innovative spreadsheet authoring environment

Consulting

We can help you make better spreadsheets:

Reviewing your spreadsheets for errors.
Advice about improving your spreadsheets.
Training in spreadsheet good practice.