Have you heard of the new Microsoft SQL Server 2012 version and the new features that it contains? This version of SQL Server was formerly named “Denali”. The exciting new features include Power View, an updated version of Power Pivot, affectionately known as Power Pivot 2, the new BI Semantic Model, SharePoint integration and even updated data mining tools. Of course you would like to try out all these new features if you have not done so already. Ah, but where to start? Use this little guide to begin downloading and installing the pieces of the puzzle should you be starting from scratch as I recently did.
Step 1: Install Microsoft SQL Server 2012. http://www.microsoft.com/sqlserver/en/us/get-sql-server/try-it.aspx Here an evaluation version is available that is good for 180 days or the express version which is good for longer.
Step 2: Install Power Pivot 2. http://www.microsoft.com/en-us/download/details.aspx?id=29074
Step 3: Install Power Pivot for SharePoint 2010 on your SharePoint 2010 server. Download from Microsoft Business Intelligence using the Download Datasheet button onto your existing SharePoint 2010 server.
Step 4: If you are interested in the new data mining add-ins install http://www.microsoft.com/en-us/download/details.aspx?id=29061 then check out this introductory video to the tools: http://msdn.microsoft.com/en-us/library/dd299412(v=SQL.100).aspx
Step 5: Now that you have the products and tools, you may need some data to try them out on. The Adventure Works sample data is handy for this purpose. Download the 2012 version of the data from codeplex. http://sqlserversamples.codeplex.com/
Step 6: Now that you have the products and the data, you may need some training and that is where the Sql Server 2012 Developer training kit kicks in. http://www.microsoft.com/en-us/download/details.aspx?id=27721
Step 7: For further training resources, videos and articles check out Project Botticelli http://projectbotticelli.com/ I heard this guy speak at an event and he reminds me of a cross between Mr. Bean and Tintin. I especially enjoyed the introductory video on Sql Server 2012 BI.