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!

  • 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

    *START OF 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.

    *END OF RANT*
  • Admin Stuff

Archive for the ‘PowerPivot’ Category

Creating a Microsoft BI Demo Environment

Posted by Alan on October 26, 2011

One of the big struggles I have had over the past few years is the ability to do a comprehensive sales, proof of concept or training demo that covers the entire Microsoft BI Stack and always being able to present practically anything in any combination without the luxury of a huge lead time.  Why has this been a problem?  Well it is all due to the fact that the robustness of the Microsoft BI stack is really a double-edged sword.  On the positive side, I have a ton of great functionality to choose from that can be molded to fit the unique needs of the client.  On the downside side, staying on top of all the potential moving parts has become more and more difficult over time as the product line has grown.

So up to this point I have been pretty much been relying upon the virtual images that Microsoft creates, albeit it with tweaks and modifications of my own.  Over the course of time I have worked with many versions of the Microsoft All-Up BI demo.  The 7.1 version was a great start and the first one with which I ever worked.  I am not sure if a 8.x image was ever produced, but if it was I don’t believe it was ever made available to the general public.  The 9.2 image sucked big time and that is an understatement.  And the latest image entitled “X” (for 10 I assume) is fantastic and really shows the potential of the products and has a great deal of “eye candy” as well.  In fact, you can visit the Microsoft Online Demo Solutions site and check out 9.5 and X and judge for yourself.

Now I know Microsoft puts in a lot of effort into these and for the most part does a great job, but all these images share one fatal flaw.  Read the rest of this entry »

Advertisements

Posted in Business Intelligence, Excel, Microsoft, Office, PerformancePoint, PowerPivot, SharePoint, SQL Server | Tagged: , , , | 4 Comments »

Office 365 and Business Intelligence

Posted by Alan on August 5, 2011

So yesterday I spent the afternoon at Microsoft learning more about the new Office 365 offering.  All in all, I am very impressed by what you get with Office 365 for the cost.  When you looking at the pricing the Exchange, Lync, SharePoint and Office Professional offerings the decision to go that route should be a no-brainer for most organizations — especially those who are running older software releases or have hardware refreshes in their near future.  So what is my problem with the Office 365?  It all comes down to the SharePoint component, or more specifically, what is missing from the SharePoint 365 offering.

As far as SharePoint is concerned, in the current Office 365 release there is no support for the following items — PerformancePoint Services, Business Connectivity Services, FAST search or fully-trusted code.  Without PerformancePoint Services and BCS the ability to provide BI in the Microsoft public cloud is extremely limited.  It all comes down to the fact that none of these components is designed to be multi-tenant and although Microsoft is working on solutions the word I keep hearing is that we won’t see any changes until the wave 15 release of Office or beyond.   It is the “or beyond” that scares me and makes me worry how much of a priority any of these items truly have, if at all.  And when Denali is release, I really doubt we will see any sort of support for SSRS or Project Crescent within SharePoint 365 for quite a while.

Read the rest of this entry »

Posted in Excel, Microsoft, Office, PerformancePoint, PowerPivot, SharePoint | Tagged: , , , | 6 Comments »

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:

Read the rest of this entry »

Posted in Excel, Microsoft, Office, PerformancePoint, PowerPivot, SharePoint, SQL Server | Tagged: , , | 25 Comments »

Merging Tables with Different Date Formats in PowerPivot

Posted by Alan on March 25, 2011

So in my prior post I detailed what it took to merge different data sources with different layouts and columns into a single table within PowerPivot.  While I was doing this one of the problems I ran into was the fact that there was no consistency within my data sources in regards to the date format.  Some of the date formats I found were:

  • MM/DD/YYYY
  • DD/MM/YYYY
  • MM/DD/YY
  • DD/MM/YY

On top of that I also had:

  • Empty Date Fields
  • Date Fields with Invalid Dates (i.e., 00 for the Month or Day)
  • Date Fields with Impossible Dates (i.e., 2601 for the Year)

Read the rest of this entry »

Posted in Excel, Microsoft, PowerPivot | Tagged: , , | Leave a Comment »