Business Intelligence

Business Intelligence: Leveraging SharePoint to drive business results Presentation

I was invited to do a presentation on Business Intelligence and Self Service BI at an internal Summit for a Health organization in Indianapolis.

Here is the slide deck.

Tidbits on Installing the SQL Server 2012 BI Tools for VS 2012

As I was installing the newly released tools, and catching up on updates for a new system, I ran into the following situation. When it came to going through the dialog screens to install the new tools, under Installation Type, it came down to two options. Perform a new installation of SQL Server 2012 was one, the other, Add features to an existing instance of SQL Server 2012. I decided to select to Add features (why? well, instinct I guess). And I went forward with that choice through the rest of ......

Installing the AdventureWorks OLAP Sample Database

Once the installer for the AdventureWorks Community Sample Database has finished, we then need to complete the process (not mandatory, but nice to do to play with the OLAP content). The first thing we need to do is make sure we note the location of the script files and samples. The path if you are working with SQL Server 2008 R2 is as follows: “C:\Program Files\Microsoft SQL Server\100\Tools\Samples\Ad... 2008R2 Analysis Services Project\enterprise” I am working with the developer edition, ......

Great finds: SharePoint 2010 Reference and Business Intelligence documents

In browsing around and following people on twitter, I have come across valuable documentation. First, the SharePoint Technical Reference http://www.microsoft.com/do... Second, Getting Started with Business Intelligence in SharePoint 2010 http://www.microsoft.com/do... ......

Microsoft BI Indexing Connector Announced

Wait? More awesome stuff released. With Microsoft’s acquisition of FAST, the options for content being indexed increased. That’s not all that happens, but for the purpose of this post, since we focus on Business Intelligence content … that is where we see that benefit at this time. Here is the link to the SharePoint Insights: BI In Action blog. You will find guidance and components to download ......

What is PowerPivot?

Let’s start with it is a great way to be able to visualize data and transform to information. It is intended to be a self-service business intelligence tool provided as an add-in for a tool we already know … Microsoft Excel ... 2010. If you have been wondering where to go? what to do? and how do I? I am including links that will help you be on your way to better understanding of the topic and tool. (Links to TechNet documentation) Introduction to PowerPivot Walkthrough: Create your first PowerPivot ......