Business Intelligence Network

Blog: Dan E. Linstedt

Bill Inmon has given me this wonderful opportunity to blog on his behalf. I like to cover everything from DW2.0 to integration to data modeling, including ETL/ELT, SOA, Master Data Management, Unstructured Data, DW and BI. Currently I am working on ways to create dynamic data warehouses, push-button architectures, and automated generation of common data models. You can find me at Denver University where I participate on an academic advisory board for Masters Students in I.T. I can’t wait to hear from you in the comments of my blog entries. Thank-you, and all the best; Dan Linstedt http://www.COBICC.com, danL@danLinstedt.com

May 4, 2008

Operational Data Warehousing on the way...

Before we get to Dynamic Data Warehousing, we need to first reach Operational Data Warehousing. Now I realize that I'm not the first, nor will I be the last to use or even possibly abuse this term. In fact if you search on the term today you'll get tons and tons of hits. I do however believe that Data Warehousing and BI as an industry have gotten slow, and become somewhat of a laggard in terms of keeping up with technology. Just look at the adoption curve of DW2.0... It simply isn't there yet (wish it were). Anyhow, in this blog let's take another look at the ODW as Bill Inmon and I are beginning to discuss it.

Continue reading "Operational Data Warehousing on the way..." »

  Posted by Dan Linstedt at 9:30 PM | | Comments (0)

May 2, 2008

Unstructured Information Pushes Dynamic Restructuring

I've just completed Bill Inmon's brand new course on Unstructured Data using his new Unstructured Data ETL tool. It's been very eye opening. Every time I meet Bill I'm always learning something new. There was a discussion at the end of the class that asks the question: WHAT do you do if you FIND "structural definition elements" in unstructured data that AREN'T represented in the EDW??

Continue reading "Unstructured Information Pushes Dynamic Restructuring" »

  Posted by Dan Linstedt at 1:42 PM | | Comments (0)

April 26, 2008

Dynamic Data Models - Automorphic Changes

It seems people have taken the term "Dynamic Data Warehousing" and abused it. They've made it out to be about "Dynamic Data" and completely ignored "Dynamic Modeling", or dynamic restructuring as the case may be. Automorphic means self-changing, self-adapting. In this entry we'll talk about different capabilities of Dynamic Data Warehousing and the changes to data models as they grow.

Continue reading "Dynamic Data Models - Automorphic Changes" »

  Posted by Dan Linstedt at 7:56 AM | | Comments (1)

April 25, 2008

Part 6: Secrets of the Masters

To follow on with our series, we'll dive in now and explore some of the elements needed for a repeatable, consistent, and redundant project. These are components that make the project book completely usable - without these pieces, the project methodology usually sits on a shelf and gathers dust. What we are aiming at is: the hope of reducing overhead costs, reducing errors, increasing productivity, and increasing agility of I.T.

Continue reading "Part 6: Secrets of the Masters" »

  Posted by Dan Linstedt at 5:35 AM | | Comments (0)

March 18, 2008

New Skills Required - Interactive BI

Do you still think that knowing flash and actionscript is not a newly required skill? Have you seen the latest version of Crystal Reports from BO? It now contains a front-end product that used to be called Excelsius, which is a flash-based front-end BI dashboard library. You can drag and drop buttons, charts, pre-built reports, and other things on to the different scenes in the dashboard. No more flipping pages, and writing PHP code or Java code to exercise BI on the client side. It's a highly protected environment.

Continue reading "New Skills Required - Interactive BI" »

  Posted by Dan Linstedt at 5:06 AM | | Comments (2)

March 16, 2008

Part 5: Secrets of the Masters

As this series progresses, I've received some wonderful comments, thank-you to all who are replying. In this entry we'll talk about some of the additional skills that are helpful in managing and developing successful projects. We've touched on a few already, but I'm not convinced we gave enough credit to these items. Many people argue with standards, claiming they are over-burdening their development - claiming they can't get their job done with them, claiming they are too verbose or have too many pieces to work effectively. They revert to RAD, JAD, and extreme methodologies...

Continue reading "Part 5: Secrets of the Masters" »

  Posted by Dan Linstedt at 6:31 AM | | Comments (0)

March 2, 2008

New skills required for BI and Data Presentation going forward

So you've all seen Flash production movies? You've all heard of Pod-casts? How about web-interactivity without "changing pages"? I'm sure you've seen Flash produced web-sites, or played an animated game lately. This post is about the new skill sets needed by BI vendors, and Business Intelligence Analysts to survive the new upcoming wave. Those of you producing PowerPoints, or sitting in the background coding "BI Reports..." you've got a few things to learn.

Continue reading "New skills required for BI and Data Presentation going forward" »

  Posted by Dan Linstedt at 3:55 PM | | Comments (5)

February 25, 2008

The new evolution of Data Modeling

Bill Inmon and I sat down the other day to discuss a system that we are building. We didn't have a good "name" for it, but what it amounts to is: Operational Data Warehousing. If you can believe it, what we've done is taken the Operational specifics of systems capturing data - and placed it on top of the Data Warehouse as a single integrated historical and operational data store. We are currently using the Data Vault model for this componentry. Some folks have called this "Active Data Warehousing" in the past, but we feel that this is one step beyond, in that it actually IS the operational store at the same time as being the Data Warehouse. Convergence has arrived...

Continue reading "The new evolution of Data Modeling" »

  Posted by Dan Linstedt at 8:26 AM | | Comments (2)

 

Search