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