Monthly Archives: February 2013

Setting up a Construction Data Warehouse – it isn’t one big database anymore

We talk to construction IT managers every day about construction data warehouses and business intelligence. Many people think that building a data warehouse means that you have to transform data and transfer or push it from several databases into one data warehouse. In the last few years data warehouse technology has evolved so you can leave data in it’s native location and include it in reports across systems. You can even combine traditional data warehouses where you move or synchronize data with data from other systems to create a broader data warehouse.

For example our clients that use Sage Timberline Office deploy our anterraDataCenter™ product to synchronize data from Pervasive databases (one per data folder) into a single Microsoft SQL database. This effectively gives them a Sage Timberline SQL database. This SQL database then becomes PART of another data warehouse when we write reports for our construction BI software that spans other systems like a CRM to get sales information to prepare work backlog forecasts.

By |February 15th, 2013|Blog Post, Construction|0 Comments

TechRepublic is a great resource for Construction and Real Estate IT Managers to keep up with technology

We work with construction and real estate companies every day to improve their reporting and provide an over-arching reporting system.   I’ve talked to many IT managers about their technology and what resources they use to stay on top of ever changing technology.  Several of them mention TechRepublic.  It’s a site I scan every day and often find reviews of new hardware and software along with IT trends and best practices.

As an example here are some topics from today’s home page that would help construction and real estate IT managers and directors keep up with technology changes: