So you want to be a Microsoft DW/BI Pro

 

As a follow up to some recent feedback (actually a question) here is some more in depth information on becoming proficient in the Microsoft Data Warehousing/Business Intelligence stack.

Get the terms straight

Business Intelligence or BI is an umbrella term for various business processes, tools, and methodologies which support improved organizational decision making. Data Warehousing (and thus data warehouses) on the other hand are organizational repositories designed to facilitate highly scalable reporting & analytics. DW and BI go together like PB & J (ah the good ol' days). So is Data Warehousing synonymous with BI...NO! Data Warehousing is a common solution (due to its many advantages) implemented to enable BI in an organization....so when you see DW/BI you will now understand that a) DW/BI doesn’t mean they represent the same thing and b) that DW and BI merely complement each other very well thus the term's existence.

Now, understand before ever cracking open a BI book (or scouring the web all day for free information, who would do such a thing?) that REPORTING <> BI. The BI industry is plagued with terminology problems! So, DW <> BI and Reporting <> BI. And like DW, Reporting is merely one component of the larger field of BI.

Personal Microsoft Business Intelligence Professional Learning Plan

Understand before I dive into this that the words to follow are from a DW/BI architect/engineer and not a fulltime trainer. Actually, I wrote a seperate post on the pros/cons of fulltime trainers prior on this blog here. So with that disclaimer out of the way here are the topics in chronological order I would propose to anyone wishing to learn how to implement DW/BI systems on the Microsoft platform.

  • Foundations (some of these topics overlap to various degrees)
    • Data Warehousing (DW) Fundamentals (Normalized DW Vs Denormalized DW)
    • Extract, Transform, and Load (ETL) Fundamentals
    • Dimensional Modeling Fundamentals
    • OnLine Analytical Processing (OLAP) Fundamentals
    • Data Mining Fundamentals (I have more to learn here as well...in fact most do)
    • Brief History of DSS (decision support systems) *You could argue you don't need this knowledge and in so far as getting the "job done" you don't.
  • DW/BI Methodologies
    • Kimball (www.kimballgroup.com) is pretty much the defacto standard for HOW to build an enterprise data warehouse on the Microsoft Platform. I personally have not read others work but do know of them and by all means use what ever methodology fits you and your DW/BI projects best.
  • Microsoft DW/BI Tools (now to the technology)
    • SQL Server 2005 (including Analysis/Reporting/Integration Services)
    • Microsoft Office 2007 Suite (namely SharePoint, PerformancePoint & Excel)

Best "WWW Stops" (in no particular order)

What you see is what you get

So thats my list (and best "stops") for now. Those of you new to the Microsoft platform may laugh that there are only a handful of products to learn but be forewarned that both SQL Server and the Office products are VERY LARGE offerings. SharePoint & SQL Server in particular can (and often do) fill bookshelves worth of valuable content.

I hope that helps everyone out there who is considering learning more and/or making a career in the MSFT DW/BI space. There is a lot to learn, however you will find that having a solid background in databases (and a bit of programming) goes a long way in learning the actual tools. It also seems to be true according to the TDWI (www.tdwi.org) that most DW/BI Professionals in general (not just those using the Microsoft platform) have lived a "past life" in another part of IT (usually dev/dba). Most people do not go directly into the field of DW/BI (which I personally 100% support)!

Print | posted on Monday, July 07, 2008 9:25 PM

Feedback

# re: So you want to be a Microsoft DW/BI Pro

Left by karuna at 7/8/2008 1:50 PM
Gravatar That was a very good intro and lot of good links.

Thanks Derek.

# re: So you want to be a Microsoft DW/BI Pro

Left by Derek Comingore at 7/8/2008 1:53 PM
Gravatar My pleasure

# re: So you want to be a Microsoft DW/BI Pro

Left by Rich Meyer at 7/10/2008 8:37 AM
Gravatar I noticed that you site Kimball as the "defacto" standard on how to build an EDW. Are you familiar w/Inmon? What about the more recent methodologies that incorporate the two original schools of DW design? Citing the Kimball methodology as "defacto" does a grave disservice to the evolutionary history of DW design philosophy.

# re: So you want to be a Microsoft DW/BI Pro

Left by Derek Comingore at 7/10/2008 9:11 AM
Gravatar Hi Rich,

Point taken, however note that I do mention that other methodolgoies exist...but I will tell you that in the "real world" Microsoft DW Design/Methodology = Kimball.

Best Wishes
Derek

# re: So you want to be a Microsoft DW/BI Pro

Left by Steve at 7/17/2008 2:35 PM
Gravatar Thanks for the links, Derek! I'm very new to BI but have some experience with some of the tools (I've worked with SSIS and DTS before it, and I've passed the 70-431 exam). I have a goal of passing both the 70-445 and 70-446 exams this year, and have already ordered the Self-Paced Study Guide for the 445 exam. Do you have any recommendations for how best to prepare for them?

# re: So you want to be a Microsoft DW/BI Pro

Left by Derek Comingore at 7/17/2008 11:47 PM
Gravatar Hi Steve...everyone has their own methods of learning. Me personally have found that the Microsoft Press Training Kits are very good as well as the official preparation guides such as: http://www.microsoft.com/learning/en/us/exams/70-445.mspx

I will say that be sure you understand:
1) The various Data Mining Algorithms and the business purposes they are used for.
2) Understand the various SSAS dimension types (they is more than just the regular relationship type)
3) Understand transactions, package restarts, and checkpoints

# re: So you want to be a Microsoft DW/BI Pro

Left by Roger Miller at 7/23/2009 8:30 AM
Gravatar Derek,

I am inheriting a team of bi pros. Im on the sales side, and I need to learn how to speak intelligently enough about it to sell it and transfer info from the clients to the team. Where should I start?

# re: So you want to be a Microsoft DW/BI Pro

Left by Derek Comingore at 7/31/2009 11:46 PM
Gravatar Hi Roger

I would start by reviewing the content at these links I have provided below: http://www.microsoft.com/bi/

http://www.tdwi.org/research/display.aspx?ID=6838

http://www.cioupdate.com/reports/article.php/3531436/Understanding-Business-Intelligence.htm

Hope this Helps!
Derek

# re: So you want to be a Microsoft DW/BI Pro

Left by Lavanya at 5/22/2010 8:10 AM
Gravatar Hi ,

I am working as SQL DBA.i want to learn BI from where i need to start and how to start learning BI

# re: So you want to be a Microsoft DW/BI Pro

Left by columbia jackets at 10/21/2010 4:15 PM
Gravatar So with that disclaimer out of the way here are the topics in chronological order I would propose to anyone wishing to learn how to implement DW/BI systems on the Microsoft platform.


snow boots for women | columbia sportswear outlet | cheap mac makeup | the north face jackets

womens snow boots | columbia sportswear | cheap makeup | cheap north face jackets

# re: So you want to be a Microsoft DW/BI Pro

Left by Navid at 7/15/2011 8:59 AM
Gravatar At last, someone comes up with the "right" asenwr!

# OLAP

Left by Carlos Quijada at 11/14/2011 8:18 AM
Gravatar How to get the certifications in BI software..???
OLAP is a high-end business intelligence software that is now finding a great use in business industries to help analyse existing data and produce correspondingly results and predict future reports..OLAP.

# ddzec

Left by sqjvcmdf at 1/23/2012 5:51 PM
Gravatar JpuiLx qykezifysvel, [url=http://tpvgsymlixus.com/]tpvgsymlixus[/url], [link=http://vdljuobnnpge.com/]vdljuobnnpge[/link], http://jvgdknqstogd.com/

# qtobvcdsp

Left by Ylqkciqe at 1/31/2012 3:32 PM
Gravatar sita kostenlos jetztspielen - kostenlos jetztspielen

# plnlen

Left by dfsruyrowq at 2/6/2012 1:53 PM
Gravatar xDNS90 dftoeuwcpbcu, [url=http://tfrsngfnabbr.com/]tfrsngfnabbr[/url], [link=http://jcjbrzymkagj.com/]jcjbrzymkagj[/link], http://hophekgrmaze.com/

# poaxii

Left by Uohqavwj at 2/8/2012 8:34 PM
Gravatar saltaire male - male

# prrvjw

Left by Sivuwmse at 2/9/2012 12:28 AM
Gravatar luo payday - payday

# jwfpwg

Left by Ayfkymre at 2/26/2012 1:44 AM
Gravatar idg kopa arava - kopa arava

# apzkpxl

Left by Dcoqulad at 2/26/2012 8:33 AM
Gravatar woodcut acheter strattera - acheter strattera

# tykhrl

Left by Mlfkumlf at 2/26/2012 7:40 PM
Gravatar buffets comprar artane - comprar artane

# shafs

Left by Abhmnrso at 2/27/2012 2:19 AM
Gravatar hacking acquisto accupril - acquisto accupril

# gyzeqja

Left by Ctfzafod at 2/27/2012 9:01 AM
Gravatar rmu generic - generic
Comments have been closed on this topic.

Copyright © Derek Comingore

Design by Bartosz Brzezinski

Design by Phil Haack Based On A Design By Bartosz Brzezinski