Microsoft Business Intelligence (BI) Resources

[tweetmeme source=”denglishbi” only_single=”false”]

UPDATE (10/20/2011): Added an updated link for the PowerPivot TechCenter – http://technet.microsoft.com/en-us/bi/ff604673.aspx.

Attended a session today on Power View and received a USB drive with some good resources on it. I thought I would share one that contained a bunch of links:

Microsoft BI Resources

PowerPivot Hands on Demo and Download: http://powerpivot.com

PowerPivot (Self-Service BI):

• PowerPivot TechCenter: http://technet.microsoft.com/en-us/bi/ff604673.aspx UPDATED LINK (10.20.2011)
• PowerPivot Tutorial: http://msdn.microsoft.com/en-us/library/ee210628.aspx
• PowerPivot Code Samples: http://www.codeplex.com/site/search?query=powerpivot&sortBy=Relevance&tagName=%2cPowerPivot%2c&licenses=|&refinedSearch=true
• Community hosted PowerPivot websites: http://powerpivotgeek.com; http://powerpivotpro.com; http://powerpivot-info.com
• PowerPivot Services Product Team Blog http://blogs.msdn.com/b/powerpivot/
• PowerPivot Architecture:
  • http://blogs.msdn.com/b/powerpivot/archive/2010/03/22/powerpivot-component-architecture.aspx
  • http://sqlcat.com/whitepapers/archive/2010/08/17/powerpivot-technical-diagram-powerpivot-security-architecture.aspx
  • http://sqlcat.com/whitepapers/archive/2010/04/23/powerpivot-technical-diagram-powerpivot-client-server-architecture.aspx

SSRS (Operational & Managed Reporting):

• SSRS TechCenter: http://msdn.microsoft.com/en-us/sqlserver/cc511478.aspx
• SQL Server Reporting Services Tutorials: http://technet.microsoft.com/en-us/library/bb510784(SQL.100).aspx
• SSRS Code Samples: http://msftrsprodsamples.codeplex.com/
• SQL Server Reporting Services Team Blog: http://blogs.msdn.com/b/sqlrsteamblog/

SSRS Report Builder (Ad Hoc Reporting):

• SSRS-RB TechCenter: http://blogs.msdn.com/b/sqlrsteamblog/archive/2010/07/18/report-builder-3-0-rtm.aspx
• download Report Builder 3.0 from http://www.microsoft.com/downloads/en/details.aspx?FamilyID=d3173a87-7c0d-40cc-a408-3d1a43ae4e33&displaylang=en

PerformancePoint Services (Dashboards, Scorecards, Advanced Analytic Charts & Grids):

• SharePoint Tech Center: http://msdn.microsoft.com/en-us/sharepoint/bb964529.aspx
• BI in SharePoint 2010 Tech Center: http://technet.microsoft.com/en-us/sharepoint/ee692578.aspx
• PerformancePoint Services Product Team Blog: http://blogs.msdn.com/performancepoint/default.aspx

Excel (Personal Productivity):

• Working with OLAP: http://social.technet.microsoft.com/Search/en-US/?query=excel%20olap&ac=3
• Working with PivotTables: http://social.technet.microsoft.com/Search/en-US/?query=excel%20pivottables&ac=3
• Excel Team Blogs: http://blogs.msdn.com/b/excel/; http://blogs.msdn.com/excel/archive/tags/PivotTables/default.aspx; http://blogs.msdn.com/excel/archive/tags/Analysis+Services/default.aspx
• Data Mining Add-in for Excel: http://www.sqlserverdatamining.com/ssdm/Default.aspx?tabid=102&Id=374

SSAS (OLAP):

• SSAS OLAP TechCenter: http://technet.microsoft.com/en-us/sqlserver/cc510300.aspx
• SQL Server Analysis Services Tutorial: http://technet.microsoft.com/en-us/library/ms170208.aspx
• SSAS Code Samples: http://www.codeplex.com/MSFTASProdSamples
• Community hosted SSAS website: http://www.ssas-info.com

SSAS (Data Mining):

• SSAS DM TechCenter: http://technet.microsoft.com/en-us/sqlserver/cc510301.aspx
• Community hosted SSAS website http://www.sqlserverdatamining.com
• Data Mining Add-in for Excel: http://www.sqlserverdatamining.com/ssdm/Default.aspx?tabid=102&Id=374

SSIS (ETL):

• SSIS TechCenter: http://msdn.microsoft.com/en-us/sqlserver/cc511477.aspx
• SQL Server Integration Services Tutorial: http://technet.microsoft.com/en-us/library/ms167031.aspx
• SSIS Code Samples: http://www.codeplex.com/MSFTISProdSamples ; http://ssisctc.codeplex.com/
• Community Hosted SSIS websites: http://www.ssistalk.com ; http://www.sqlis.com
• The Data Loading Performance Guide: http://msdn.microsoft.com/en-us/library/dd425070.aspx
• We Loaded 1TB in 30 Minutes with SSIS, and So Can You: http://msdn.microsoft.com/en-us/library/dd537533.aspx
• Links to additional On Demand content (webcasts, videos and podcasts): http://www.microsoft.com/events/series/bi.aspx

Forums to use for researching / posting questions

• http://social.msdn.microsoft.com/forums/en-US/sqlanalysisservices/threads/
• http://social.msdn.microsoft.com/Forums/en-US/sqldatamining/threads
• http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/threads
• http://social.technet.microsoft.com/forums/en-US/ppsmonitoringandanalytics/threads/
• http://social.msdn.microsoft.com/Forums/en-US/sqlkjpowerpivotforexcel/threads
• http://social.msdn.microsoft.com/Forums/en-US/sqlkjpowerpointforsharepoint/threads

I also have a list of the Microsoft BI portals, but I think most if not all are possibly listed above here already – Microsoft Business Intelligence Portal Page References.