• 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

6 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
6 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
kseniia_gravus
10/31/2023 09:38:13 am

One of the main advantages of Business Intelligence tools is that they make it possible to represent data in a simple way, allowing the organization to redirect undesired situations and detect growth opportunities, among other objectives. In this article:https://www.cleveroad.com/blog/business-intelligence-implementation/ we will see what Business Intelligence is and the main benefits of implementing it in your organization.

Reply
Tori R link
11/11/2023 08:57:57 pm

Great reading your blog postt

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