This past week I presented on Microsoft Business Intelligence at the Huntsville SharePoint User Group, now officially known as the Rocket City SharePoint user Group.
In the presentation I went over the three main SQL Server Components (SSIS, SSAS, SSRS) and PerformancePoint. Then we went through a live demo of importing some data into SQL Server with SSIS, building a data cube on it with SSAS, and making reports in SSRS and PerformancePoint.
The entire presentation lasted about an hour, and luckily didnt have any major hiccups.
Click here for the presentation (8 MB)
It looks like I will be presenting about the options of Business Intelligence in SharePoint at the Birmingham SharePoint User’s Group on March 9th.
This will be a similar presentation to what I gave a couple of months back here in Huntsville but I will go into more detail and add a couple of demos. It will be 2007 focused but I will highlight some of the changes coming in 2010 and maybe throw a demo or two in there on 2010 if I have the time to get a suitable environment set up.
Below is information on the session and hopefully someone will feel like showing up to listen to me 
Microsoft SharePoint Business Intelligence Solutions for Everyone
Steve McDonnell
Senior SharePoint Consultant, IE-Dynetics
With Microsoft SharePoint, Business Intelligence does not have to be reserved for executives or companies with multimillion dollar IT budgets. Whether you have Windows SharePoint Services or Enterprise MOSS, there are several options for Business Intelligence that we will dive into. If you want to see a detailed overview of what Microsoft BI has to offer filled with real time examples of dashboards and reports, then this is a presentation for you.
Specific topics to be covered in this presentation:
- WSS 3.0 BI Capabilities
- The Data View Web Part
- Custom Web Parts and Dashboard Solutions
- SQL Server Capabilities (SSIS, SSAS, SSRS)
- Enterprise MOSS 2007 Capabilities (Excel Services, KPIs, BDC)
- PerformancePoint Server 2007
- The Future of BI With SharePoint Server 2010
We have a monthly users group at IE-Dynetics, and this week I will be the lucky one presenting. The topic is Microsoft Business Intelligence, and in about an hour I will demonstrate how the various Microsoft BI Products work together. If anyone is local to the Huntsville AL area and would like to attend (or just wants a free lunch), it will take place at 10am, Friday October 2nd, at 4900 Bradford Dr. in Huntsville. Lunch will be provided and served around 12.
I plan to demonstrate the following technologies and explain where each one fits into the big picture:
- SQL Server (Including SSAS, SSIS and SSRS)
- SharePoint Server 2007
- SQL Server Reporting Services Integration with SharePoint
- Excel Services and Key Performance Indicators (KPIs)
- PerformancePoint Server 2007
Here is a link to a description of the event.
I’m looking forward to it and hope that they order in Pizza this time… I’m not a sandwich person.
Comments (2) 
