-

Estimating a Data Project
Software estimation has had a lot of attention. Yet, it is still a challenge. Much has been written about metrics and methodologies to predict project completion. Software estimation is especially challenging because every piece of useful software is unique. This article steps through one method of creating an estimate. Read the article Software Project Estimation….
-

The Solution Architect
I’ve been a software architect for over 20 years, worked on a wide range of projects. I write this not as one who has mastered the role, but rather one who has had a few successes interspersed among many mediocre outcomes and one or two abject failures. The skills and behaviors listed below are things…
-

Choosing a Reporting Solution
Reporting solutions vary depending on many factors including the size of the business (or department), security and auditability requirements, and scalability. This article highlights common reporting patterns and examine the suitability of . Report Servers Operational Data Stores Data Marts Data Warehouses Data Virtualization Data Lakes Read more in Choosing a Reporting Solution Questions: What…
-

Getting Requirements Right
Gathering Data Warehouse Requirements Designing a data warehouse begins with knowing the what and the why of the project. Note that using the term “data warehouse” at this juncture is premature as the solution is yet to be defined. This document goes through a requirements-gathering exercise for a hypothetical reporting project. It is fuel for…
-

Critical Success Factors for Data Projects
I’ve been fortunate to have been part of some successful data warehouse projects, and some not so-successful ones. As you build out your reporting solution plan, allow for time for the unexpected, testing, performance tuning, and the like. Recognize that the longer the project lasts, the more the business will move away from the…








