Wind farms offer clean, renewable electricity. Operating and maintaining wind turbines profitably is another matter. This article provides a brief … More
Category: Data Warehouse
Using PowerShell for ETL
The Microsoft world offers BCP, .NET, and SSIS for moving data. BCP is fast and efficient, but is limited. Bespoke … More
Start with a Minimum Viable Solution
Borrowing from Eric Reis’s book Lean Startup, start your data warehousing project simply. Often, we envision a comprehensive, elaborate solution, … More
Alternative Data Warehouse Key Design
I was once on a project where the users waited on the data warehouse load to complete before going home. … More
Choosing a Reporting Solution
Reporting solutions vary depending on many factors including the size of the business (or department), security and auditability requirements, and … More
Getting Requirements Right
Gathering Data Warehouse Requirements Designing a data warehouse begins with knowing the what and the why of the project. Note … More
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 … More