• Home
  • Modeling for BI
  • DBA
  • Azure
  • SSIS
  • SSAS
  • SSRS - Reporting
  • PBI - Analytics
  • Consulting
  • About
Microsoft Data & AI

Modeling for BI

Your BI Blueprint: Road to a Successful BI Implementation

11/6/2015

4 Comments

 
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?
  1. Avoid common mistakes, like jumping from pipe #1 to pipe #9 (that is the roadmap for operational reporting).
  2. 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.
  3. Provide adequate timelines to administration because you haven't missed planning a critical step.
  4. See the need and plan for hardware for each pipeline.
  5. 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.
​
Picture
4 Comments
BV
12/18/2018 01:32:59 pm

It seems above model doesn't discuss about Data Marts, in your perspective what is the use case for Data Marts ?

Reply
Isabel Rodriguez
5/9/2019 05:15:03 pm

VERY important information

Reply
Agatha Pace link
11/26/2020 06:07:13 pm

Lovely blog you have heere

Reply
Agatha Pace link
11/29/2020 05:48:24 pm

This is a greaat blog

Reply



Leave a Reply.

    Categories

    All
    Analytics
    Architecture
    BI Blueprint
    Denormalization
    Dimensions
    Mesaures
    Modeling

    RSS Feed

    View my profile on LinkedIn
    Tweets by @SqlServerSME
Powered by Create your own unique website with customizable templates.
  • Home
  • Modeling for BI
  • DBA
  • Azure
  • SSIS
  • SSAS
  • SSRS - Reporting
  • PBI - Analytics
  • Consulting
  • About