Modeling for BI

Inserted below is a slide I use when talking about data modeling for MS BI. (If you have brought me into your company for MS BI mentoring or training, you already have a version. :-) ). I am posting it here because if you are planning a BI project, you need your own version of one of these! Why?

Avoid common mistakes, like jumping from pipe #1 to pipe #9 (that is the roadmap for operational reporting).

Make a conscious decision to possibly skip certain pipes vs an oversight that might require you to backtrack and redo later on in your project.

Provide adequate timelines to administration because you haven't missed planning a critical step.

See the need and plan for hardware for each pipeline.

Provide a non-technical explanation of BI steps to Administration.

Please allow me to encourage you -- open Visio and get blueprinting!! For a deeper dive into a BI blueprint for your company, drop me a note under the About section of this site.​