Tom on the web ...

Master Datasmith?

Well, I could style myself a data analyst/systems integrator/reporting analyst/DBA/business analyst/programmer but I'd end up all /'d out. I hope the term datasmith conveys the craft nature of my work with data, for it is a craft that I'm particularly good at (hence the master adjective) and also take great pride in. Read more ...

Gobán Saor

The (or more correctly An) Gobán Saor was a stone mason (or sometimes a black smith) who according to Irish mythology by virtue of his craft (building castles, moving mountains, that sort of thing) was able to live a free life moving from commission to commission and from royal court to royal court.

My father who came from a long line of stone masons and master builders, told me many of these stories and also used to take me to a magical island in our local bogland that he called the Gobán Saor’s island. (Now better known as the discovery place of the Derrynaflan Chalice ). Continuing in the tradition of freelance craftsman (data mason rather than stone mason) I’ve used gobansaor as my nom de plume in forums, online apps etc. over the years, partially to keep a tradition alive but to be honest usually because I’m sure nobody else will have taken the name already :-)

Data Cleansing and Transformation Service

Many businesses waste the time of some of their most expensive workers (accountants, managers) manually converting data from one format to another when a professional, like me, can achieve the same result at a fraction of the cost. For a small once-off task the cost of these lost hours may not be significant, but when repeated day after day, month after month, the benefits of using a professional service or having the process automated becomes more pronounced.

Examples:
  • One table to many or many to one.
  • Data take-on for new systems and managing the cross-over period (i.e. tracking delta changes).
  • Prepare data for analysis using OLAP tools such as Excel PivotTables, PowerPivot or Palo OLAP
  • Import/Export to/from Excel.
  • Import data from a Web Service.
  • Web scraping (fetch data from HTML web pages).
  • Export data to a Web Service.
  • XML to CSV/SQL/JSON/Excel or the reverse
  • CSV  to  SQL/XML/JSON/Excel  or the reverse.
  • EXCEL to SQL/XML/JSON/CSV or the reverse.
  • JSON to SQL/XML/CSV/Excel or the reverse.
  • Transforming or managing very large XML datasets.
  • List transformations & validations.
  • Transforming  or managing  hierarchies.
  • Cross-join hierarchies for activities such as budgeting and planning.
  • Data extraction from, or import to,  MS SQL Server,Oracle, Postgres,SQLite or MySQL databases.
  • Recovering data from legacy data sources.
  • Data validation and profiling (e.g. remove duplicates, validate data formats etc.)
  • Summarising or breaking down large datasets to smaller sets.
  • De-duplication and cross-matching of large datasets
  • Fuzzy joining (incomplete or variations on key fields) of large datasets.
  • General dirty-data laundering and anything else data related ...
Delivered either as a:
  • Bureau Service, you send me the data I'll return the finished dataset.  Fixed Price : €150 (US$ 200) + VAT if applies
  • Or DIY, you send me the specification/examples of the input/output datasets and I''ll send you the "code" - usually an Excel VBA workbook or Add-in - which you can then apply locally to transform your data. For my development rates see  http://www.gobansaor.com/rates.



Contact Tom ...