Alan Whitehouse's Ramblings

Continuing to work until my heavy investment in lottery tickets finally pays off….

  • Categories

  • Archives

  • Deep Thought

    Historically speaking, all true change in the world has come thanks to leaders emerging, them taking charge and giving the masses someone to rally around. Can an intentionally "leaderless" movement survive or will it just slowly fade away?

  • Subscribe

  • Enter your email address to subscribe to this blog and receive notifications of new posts by email.

    Join 18 other followers

  • Me!

  • Advertisements
  • Disclaimer

    The views expressed in this blog, while intelligent and always right, are strictly my own, and do not necessarily reflect the views of anyone else with which I am in any way affiliated. And don't forget, I own the rights to all information on this blog (except for the stuff I stole from other people).
  • Current Rant


    You want change, then get involved. Vote, run for office, go to shareholder meetings and contact advertisers or investors. Sitting around banging drums, singing kumbaya, smoking weed and having a camp out under the stars is not going to get you the change you want.

  • Admin Stuff

The Microsoft Business Intelligence Stack Cheat Sheet

Posted by Alan on April 7, 2011

Two questions I tend to get asked over and over again are:

  1. Exactly what products are you talking about when you refer to the Microsoft BI stack?
  2. Where do I get more information on a particular product in the stack?

So being the lazy and generally unsociable person I am, I decided to bite the bullet and create a post that I could just point people to rather than having to retype my answers over and over again.  So below are the components that I consider part of the Microsoft BI solution offering, as well as some links to more information on those products.  If I have missed anything or if you have some suggestions for some additional/better links drop me a line and I will add it to the list.  I am also going to pin this to my main navigation bar so people can find it easily.  So without further adieu here is the list:

Product Group Component Item Description/Usage Link
Office Excel Used for spreadsheets, pivot tables, charts/graphs and general crunching of numbers.  Excel is probably the most widely used BI tool in the world.  As organizations get more sophisticated, they outgrow Excel, but continue to use it as it is all they know.  The upcoming release of Excel 2013 will add significant additional BI capabilities. Link
PowerPivot for Excel A free add-in available for Excel that allows processing and analyzing of massive amounts of data within the Excel environment with easy linking to numerous different data sources.  The power and manageability of PowerPivot for Excel can be expanded by utilizing PowerPivot for SharePoint. Link
Data Mining Add-In for Excel A free add-in available for Excel that adds data mining capabilities to Excel to aid in predictive analysis.  Usage requires the ability to link to an Analysis Services database within SQL Server. Link
Visio A great tool for doing data visualization using shapes and process flows.  Key component for producing Strategy Maps via PerformancePoint Services within SharePoint. Link
SharePoint Server Excel Services A native component of SharePoint Server that provides the ability to publish Excel documents to a SharePoint website to allow interaction and viewing without the need launch Excel. Link
Visio Services A native component of SharePoint Server that provides the ability to publish Visio documents to a SharePoint website to allow interaction and viewing without the need launch Visio. Link
PerformancePoint Services A native component of SharePoint Server that provides the ability to create and deploy dashboards, scorecards, strategy maps, charts/graphs and decomposition trees within the SharePoint environment. Link
SharePoint Chart Web Part A web part that allows the user to present a chart/graph within SharePoint linked to various data sources.  Limited in its ability to drill down or pivot the data but good for simple presentation of data. Link
SharePoint Status Indicators A special SharePoint web part that is designed to display Key Performance Indicators.  It can draw upon data found in other SharePoint lists, Excel, Analysis Services or data that has manually been entered. Link
PowerPivot for SharePoint Allows for the publishing of PowerPivot documents created in PowerPivot for Excel to be deployed through the SharePoint environment.  Also provides central management and scheduling capabilities as well as the capability to harness the power of the server when doing analysis rather than the user’s desktop. Link
Power View (Project Crescent) Formerly known as Project Crescent. A data visualization component using Silverlight and reading data from PowerPivot or a Business Intelligence Semantic Model database. Currently require SharePoint 2010 to utilize but will be natively integrated with Excel 2013. Link
SQL Server Database Services What most people think of when they hear SQL Server.  This is the engine that stores data in a relational manner and in the BI world will be used mostly for hosting source data or a data warehouse. Link
Analysis Services The heart of many business intelligence solutions is an OLAP cube.  Analysis Services is the engine within the SQL Server product line that processes and serves up cube data.  If you are going to do BI, then you best understand cubes. Link
Integration Services Within SQL Server, Integration Services is the tool used to perform the ETL (Extract, Transform, Load) process that moves data from different host system to a central store that your business intelligence solution can draw upon. Link
Reporting Services Reporting Services is used to generate reports based on data found within the relational or cube components of SQL Server.  Basic design of reports can be accomplished through the use of Report Builder while more complicated reports may require the use of Visual Studio or BIDS. Link
Master Data Services Most organizations have multiple systems that they rely upon.  Over time the shared master data within these system gets harder and harder to manage.  Master Data Services provides functionality to help organizations manage their master records. Link
SQL Server 2012 The current release of Microsoft SQL Server. Formerly known by the project name Denali. Link
Business Intelligence Semantic Model (BISM) A new technology to be released with SQL Server 2012 (Denali). It is a relational based model relying on in-memory processing to replicate the functionality of a traditional UDM analysis cube. It will be good for some situations but not a complete replacement for a UDM cube. Link
Vertipaq Model A SQL Server Analysis Services deployment utilizing in-memory processing RAM to simulate traditional disk based UDM cubes. Utilized by PowerPivot for SharePoint and the Business Intelligence Semantic Model and Power View in SQL Server 2012. With the release of SQL 2012 models utilizing Vertipaq are now refered to as Relational models. Link
Unified Dimensional Model (UDM) A SQL Server Analysis Services deployment utilizing traditional disk based cubes. With the release of SQL 2012 models utilizing UDM are refered to as Multidimensional models. Link
Other Bing Maps Although best known for providing driving directions, the Bing Map platform can integrate with data to provide geospatial visualizations of the data. Certain types of trends in data are easier to spot if they are overlaid on geographic maps. Link
PivotViewer A Silverlight-based data visualization tool designed to allow the user to navigate through large volumes of data (thousands at a time) and group them visually based on filter parameters the user controls. Link
Hadoop Apache Hadoop is an open source project for processing large data sets across clusters of computers. Also known as “Big Data”. Link
Column Store Relational databases traditionally store data in rows on a data page. In a column store, values from a single column, coming from multiple rows are stored together in a compressed form providing better performance. Often used for large data warehouses. Link
Development Languages Transact SQL The language of writing SQL Server Relational based queries. Often referred to as T-SQL or TSQL. Link
Multidimensional Expressions Language (MDX) The language of writing SQL Server Analysis Services UDM/Multidimensional based queries. Referred to as the language of cubes. Link
Data Analysis Expressions Language (DAX) The language of writing SQL Server Analysis Services Vertipaq/Relational based queries. Used heavily with PowerPivot for Excel and PowerPivot for SharePoint. Link

Lasted Updated: August 28, 2012


25 Responses to “The Microsoft Business Intelligence Stack Cheat Sheet”

  1. Wendy said

    This is awesome…keep updating please!!!

  2. tuneup utilities 2012 keygen…

    […]The Microsoft Business Intelligence Stack Cheat Sheet « Alan Whitehouse's Ramblings[…]…

  3. Notify your home insurance company that a new installation has
    been performed . In terms of choosing which kind of door
    handle you pick for your kids’ bedrooms, you will find several options available.

  4. Hi there it’s me, I am also visiting this site on a regular basis, this web site is truly fastidious and the people are actually sharing fastidious thoughts.

  5. Margret said

    Hello! I’ve been following your weblog for some time now and finally got the bravery to go ahead and give you a shout out from Dallas Texas! Just wanted to say keep up the great work!

  6. […] Link […]

  7. Reggie said

    It’s awesome for me to have a site, which is valuable in favor of my know-how. thanks admin

  8. I enjoy what you guys tend to be up too. Such clever
    work and coverage! Keep up the wonderful works guys I’ve incorporated you guys to our blogroll.

  9. Hello to every one, it’s truly a nice for me to visit this website, it consists of precious Information.

  10. Appreciation to my father who told me about this website,
    this webpage is actually awesome.

  11. Maxwell said

    Excellent post. Keep writing such kind of info on your page.
    Im really impressed by it.
    Hi there, You have performed a great job. I’ll certainly digg it and for my part recommend to my friends. I’m sure they will be benefited
    from this site.

  12. This is really interesting, You are a very skilled blogger.
    I’ve joined your feed and look forward to seeking more of your excellent post. Also, I have shared your web site in my social networks!

  13. Gerry Smith said

    Does MicroSoft Access have a place in the BI Stack?

  14. It’s going to be finish of mine day, but before finish I am reading this great piece of writing to increase my know-how.

  15. 8 pounds) with the vast majority of extra weight sitting inside my belly.
    Even when it was taken off the shelves, Phentermine was restricted and might just be prescribed by a GP,
    and was often given only to those with the most serious sorts of obesity.
    Looking up Phen375 reviews could enable you to get a good plan of what works for
    most people, and the way to make the most out of taking a drug such
    as Phen375.

  16. He then reports you for offensive language as part of his troll.
    Janna’s shield is not just modest-time protection possibly, it scales quite nicely with AP and can safeguard nearly a one,000 hurt late in the gaming, and even far better, it can give mass quantities of injury to the guarded consumer as well. So now you know the basic skills of how to effectively farm, last hit and.

  17. fat burner said

    Wow, amazing blog layout! How long have you been blogging for?
    you made blogging look easy. The overall look of your site is magnificent,
    let alone the content!

  18. Thanks for every other informative blog. Where else may just I
    get that type of information written in such an ideal way?
    I have a challenge that I am just now working on, and I’ve been on the
    look out for such info.

  19. 2014 said

    I’ll right away clutch your rss feed as I can not in finding your e-mail subscription link or newsletter service.
    Do you’ve any? Please let me recognise so that I may subscribe.


  20. website said

    Does your website have a contact page? I’m having problems locating it
    but, I’d like to shoot you an e-mail. I’ve got some ideas for your blog you might be interested in hearing.
    Either way, great website and I look forward to seeing it expand over time.

  21. I like it whenever people get together and share views. Great
    site, continue the good work!

  22. I know this if off topic but I’m looking into starting my own weblog and was curious what all is required to get set up?
    I’m assuming having a blog like yours would cost a pretty penny?
    I’m not very web smart so I’m not 100% positive. Any tips or advice would be greatly appreciated.


  23. […] The microsoft business intelligence stack cheat sheet […]

  24. F*ckin’ tremendous issues here. I am very glad to look your post. Thank you so much and i’m having a look forward to touch you. Will you kindly drop me a mail?

  25. I’m gone to inform my little brother, that he should also pay a
    visit this weblog on regular basis to obtain updated
    from most up-to-date news update.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: