Data Integration

Data Warehousing, Part VI: Nonprofit BI

Here are some links I drudged up tonight just for anyone who has a few moments of spare time. Which...comes rarely these days for me. I'd love to chat about any of them if the mood swings that way.

1. NetSquared Interview from last year with a major BI vendor.

http://www.netsquared.org/blog/britt-bravo/business-intelligence-nonprof...

2. Blackbaud white paper on "Business intelligence for nonprofits." Perhaps defunct now. I couldn't find a straight link like I could last year. But the marketing material is still useful I think.

More

Data Warehousing, Part V: Small and Agile

(This was originally posted to the NTEN Data Warehousing group list, by Nate Wilbert. Nate has kindly allowed us to publish his work here.)

I received an email today about an NTEN webinar with the headline "Bust Those Silos: Reporting Across Multiple Systems." This was interesting to me because I thought, great! Someone is going to talk about data warehousing! Well, not quite I think.

More

Data Warehousing, Part IV: Tools

(This was originally posted to the NTEN Data Warehousing group list, by Nate Wilbert. Nate has kindly allowed us to publish his work here.)

I've actually been working with a particular set of tools in the Business Intelligence / Data Warehousing space the past 7 or 8 months. I've worked in the past with many different BI reporting tools like MicroStrategy (a ROLAP tool), Oracle's Hyperion Interactive Reporting and Oracle's BI Enterprise Edition (the old Siebel Analytics ROLAP tool). I've also briefly worked with others like Business Objects and Oracle Discoverer.

More

Data Warehousing, Part III: Why?

(This was originally posted to the NTEN Data Warehousing group list, by Nate Wilbert. Nate has kindly allowed us to publish his work here.)

In the first two posts I've discussed how data warehousing is similar to a large puzzle with many pieces, and how that puzzle is different from typical database "puzzles" created within an organization.

I think that perhaps I should back up and provide some reasons for even thinking about a data warehouse.

1. One version of the truth

More

Data Warehousing, Part II: Database Designs

(This was originally posted to the NTEN Data Warehousing group list, by Nate Wilbert. Nate has kindly allowed us to publish his work here.)

More

Data Warehousing, Part I: What Is It?

(This was originally posted to the NTEN Data Warehousing group list, by Nate Wilbert. Nate has kindly allowed us to publish his work here.)

I'm not really sure how many in this group have worked with data warehouses so I'm going to start this first post off with an analogy. In the group description you heard me liken data warehousing to putting a jigsaw puzzle together. Let's work that out just a bit.

More