917.848.7284Data for Finance and Accounting

Top

Infor SunSystems

You’ve undoubtedly heard of data marts and data warehouses. And perhaps you’ve wondered about building one or both for your own company. But you haven’t looked into it yet because you have no idea how much they would cost. In this post, I’ll walk you through a project we recently completed for a client, where we built a simple data mart. At the end, I’ll include estimates of what you could expect to pay for a similar data mart project. Data Mart vs. Data Warehouse Before we start, let’s clarify the difference between a data mart and a data warehouse: You build a data warehouse when you need a place to put neat, clean and centralized data. For example, you have multiple ERPs, all using multiple customer lists, in multiple countries, with multiple currencies. A data warehouse provides a place where all your data about sales can be found. (Note that sometimes you can...