FINALLY!!!! and updated for SQL Server 2012. http://www.microsoft.com/en-us/download/details.aspx?id=29061

This is truly excellent content. Kudos to the MS Team. Links to presos and videos below. http://social.technet.microsoft.com/wiki/contents/articles/6982.sql-server-2012-developer-training-kit-bom-en-us.aspx

I just put this together for a customer and thought I would share it. It goes through the entire install and configuration process screen by screen, to build a stand alone server with all the server side components of the Microsoft Business intelligence...

Just released a new SQL Server 2012 Product Guide ready to download.

Not very well documented on how to connect PowerPivot to an Oracle database. You need the Oracle client installed and the TNS names configured. In PowerPivot the server name to connect to the Oracle instance is host:port/service_name . If port number...

Alot of confusion on how to integrate the new SharePoint integrated mode of Reporting Services 2012 into your Performance Point Dashboards. If Reporting Services is configured to use Trusted Account authentication in SharePoint Server, then the server...

Microsoft has released new guidance on viewing reports and scorecards on Apple iPad devices, and a SharePoint Cumulative Update to enable it. http://technet.microsoft.com/en-us/library/hh697482.aspx

For those in Toronto, I will be presenting a session at the SharePoint Summit on May14-16th on Building Better Dashboards http://www.sharepointsummit.org/Toronto/conference-day2.htm#session_9_2 Hope to see you there!

BI semantic model connections from Excel require that you have Excel 2010 and the MSOLAP.5 OLE DB provider installed on your workstation For connections to succeed you must have Excel 2010 and the MSOLAP.5.dll installed on the client computer. You...

check this out for what is coming...btw, it is in CTP1 release now. http://projectbarcelona.cloudapp.net/

I am doing a session next week at our local techdays event. http://www.techdays.ca . I hope to see some folks there. here is what I am covering... In this session we dive into some of the new Business Intelligence capabilities that are being introduced...

Unlock business insights from all your structured and unstructured data, including large volumes of data not previously activated, with Microsoft’s Big Data solution. Microsoft’s end-to-end roadmap for Big Data embraces Apache Hadoop™...

It's like a help file on steroids. There are 2. IT configuration - how to configure Performance Point Services Dashboard creation - how to create Performance Point content: kpi, scorecards, reports, filters, dashboards, etc...

There are couple of post install manual configs you need to do in order to get the reporting services Sharepoint service to show up in your sharepoint farm. First of all, you NEED SharePoint 2010 SP1. In SharePoint PowerShell, as admin: Install...

latest and greatest denali bits. http://www.microsoft.com/betaexperience/pd/SQLDCTP3CTA/enus/default.aspx and you will need this too Microsoft® SQL Server® Code-Named 'Denali' PowerPivot for Microsoft® Excel Community Technology Preview...

Useful list of time calcs for powerpivot and soon to be tabular bi models. http://social.technet.microsoft.com/wiki/contents/articles/powerpivot-dax-time-intelligence-functions.aspx

here is a little known PPS feature add for SP1 for SharePoint 2010 http://technet.microsoft.com/en-us/library/hh272541.aspx

A new cool FREE tool to gain valuable insight into your tweets using PowerPivot. Download it here

i can think of a few cool BI scenarios with this new UI p92QfWOw88I

This walkthrough discusses how businesses can take business intelligence to the cloud with SQL Azure. The video covers the benefits of SQL Azure—including the ability to establish business intelligence without adding hardware costs or IT overhead—and...

New Project from MS Labs. Takes the fuzzy lookup functionality out of SSIS and puts into Excel 2010. Could be useful for cleansing PowerPivot models. More info here http://www.microsoft.com/bi/en-us/Community/BILabs/Pages/FuzzyLookupAddInforExcel.aspx...

Another cool project starting up at Microsoft. Looks interesting. Find out more here http://blogs.msdn.com/b/project_barcelona_team_blog/archive/2011/04/11/introduction-to-project-barcelona.aspx

Calendar Analytics is a FREE time management application that pulls information from Exchange and visualizes that data in a very easy to use Excel PowerPivot dashboard. http://www.microsoft.com/downloads/en/details.aspx?FamilyID=4c13a670-3356-4d4a...

The SharePoint Diagnostics Studio available in the SharePoint 2010 Administration Toolkit v2.0, presents server diagnostic information in a visual and structured way that enables Developers and IT Professionals to quickly diagnose and act upon intermittent...

Here are some free PPS training videos to get up to speed on how to build dashboards using PerformancePoint Services 2010 Video 1: Introducing Dashboard Designer (5:48) Video 2: Tour Dashboard Designer (11:17) Video 3: Creating a basic dashboard...