‎‏‎‎‎‎‎‎‎‏‎‎‎‎‏‎‎‎‏‎‎‏‎‎‎‏‏‏‏‏‏‎‏‎‏‎‏‎‎‏‎‎‏‏‎‏‎‎‎‎‎‏‏‏‏‎‏‎‎‏‏‎‏‏‎‎‎‏‏‎‏‏‏‏‎‎‏‎‏‎‏‏‏‎‏‏Navigation‏

Tom Gleeson - Virtual Data Analyst

You have data that needs to be analysed and/or cleaned and/or transferred.

You
don't have the time and/or the expertise and/or the technology to do so.

You need a data analyst, somebody who lives, breathes and revels in raw data, the messier the better.

I'm that data analyst. A master datasmith, someone who can model, automate and animate any data resource. With over 30 years experience hewing and hauling data across BI, CRM, ERP systems and of course Excel.


My Datasmithing "Toolbox"


Excel,
because it's the best end-user focused data manipulation tool out there. Combined with...
SQLite, because a SQL powered database engine is essential for fast and accurate data crunching. Combined with ..
Python, a modern data friendly scripting language to go where VBA fears to tread. All packaged up in my own open source project...
xLite, I built the xLite code-base to combine the above three best in class products in a single integrated tool.


My Datasmithing "Heavy Plant"


Palo OLAP
, an open source, Excel focused, BI suite.
Amazon EC2, pay-as-you-go Linux and Windows 2K3
Amazon S3, for secure data transfer and storage.
Talend ETL, an open source ETL tool.


What I specialise in:

Business Intelligence initiatives, especially those centred around Sales & Marketing, CRM, budgeting & financial control.
Business re-orgs, mergers & acquisitions, need help remodeling making sense of and consolidating merged datasets.
CRM sales targeting and campaign planning.
Master Data (Customer, Product etc.) &
Data Quality
initiatives.
Data Conversions. be that
systems commissioning, de-commissioning or integration.
Excel VBA consultancy.
Excel report automation.
Excel based barely-repeatable process automation.
ETL programming; VBA,Python,Oracle PL/SQL or Talend ETL.
SAP to Excel or other desktop environments.
SQLite virtual table and user defined functions development.
Datasmithing mentor, want to take more control of your data assets, want to use tools such as xLite, Palo, Amazon AWS? I'll be your guide, a datasmith's datasmith