This tutorial teaches the fundamental skills and concepts behind multidimensional modeling in SQL Server Data Tools (SSDT). When you are finished, you will have a cube database based on Adventure Works data that you can access from Excel, Reporting Services, or any other client application that connects to Analysis Services.
This link takes you to a PowerPivot for Excel tutorial that teaches you how to create and use PowerPivot data in an Excel 2010 workbook. This tutorial is based on sample data that you download and use in Office 2010 and PowerPivot for Excel. No database or server products are required.
Most of the SQL Server 2008 R2 tutorials work on a SQL Server 2012 server. If you are new to Data Mining, use this link to find the SQL Server 2008 R2 Data Mining Tutorials that also work with a SQL Server 2012instance of Analysis Services.