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 :-)

Excel in Data

Excel automation, reporting, and general data fetching and cleansing (ETL) services.

Excel Automation

Excel Add-in development


Need an add-in developed or an Excel process automated. Fixed price development service.

I can save you time & money by building user defined functions, VBA add-ins,.NET add-ins, reporting & process automation routines, data transformation scripts, in fact any problem you come up with.


PowerPivot




Excel-based Business Intelligence 

using


Microsoft's free data-analysis add-in for Excel 2010, which revolutionises the provision of affordable, quick-to-build BI & Decision Support solutio
ns. It combines the best of BI theory and practice with ease of use of Excel PivotTables.

I have both the technical know-how and business analysis background to build, or help you build, affordable, useful and timely PowerPivot models. In fact, combined with my own micro ETL toolkit I can build you a complete Excel-based automated BI platform. Such a solution might be all the data warehouse a small business requires, or simply a data mart for a department within a larger company, or just a prototype/proof-of-concept delivery for others.



Data Cleansing
Data conversions and cleansing.

I can generally provide the necessary transformation using my own Excel based microETL & HAMMER tools, but if need be can call on other opensource tools such as Talend and Python.

MicroETL & HAMMER being Excel based, are particularly suited as an ETL (the technical name for data cleansing and transformation) backends to Excel based Business Intelligence (BI) such as PowerPivot.



Sign in  |  Recent Site Activity  |  Terms  |  Report Abuse  |  Print page  |  Powered by Google Sites