Accounting Tax Services | Bookkeeping Solutions Toronto

Category: Data Management

What is Datawarehouse and How to Build One

28 March, 2008 (11:46) | Data Management | By: Cecilia Leung

Simply put, it is a system that organizes and stores data in a way that can be efficiently retrieved in a format that helps make business decisions. I have heard one of the managing director from my client, say “If we use ReportNet, we cannot use Datawarehouse!”. He misunderstood what Datawarehouse really is. At that [...]

How to consolidate data from different data sources

4 February, 2008 (14:08) | Data Management | By: Cecilia Leung

As a data architect for years, I tends to take this for granted, until someone came to me and asking me some methodology (or just simply HOW to do it) on consolidating data from different databases into one database. For some unknown reason people tends to think different databases will have the same data structure. [...]