SQL Server 2008 R2 Update for Developers Training Kit – June 2010 Update

  • Article

Today I’m pleased to announce the availability of the SQL Server 2008 R2 Update for Developers Training Kit June 2010 update.  This update includes two additional units of new content covering SQL Server 2008 R2 related improvements in Excel 2010 and SharePoint 2010, as well as many updates to address changes in the final RTM release of SQL Server 2008 R2. 

Excel is the most popular data analysis tool in the world, and Excel 2010 offers a range of powerful data analysis and visualization improvements that makes it the ideal self-service analysis client. Slicers are new visual controls that provide quick, easy and interactive filtering. Sparklines are intense, simple word-sized graphics that make it easy to visualize data in-line with numbers. PivotTables support powerful new capabilities like named sets, what-if analysis (write-back), and pre-built calculations like percent of total, running totals and ranks. Charting has also been improved with an easier user interface, faster performance and expanded limits. SQL Server 2008 R2 introduces PowerPivot for Excel, a free Excel add-in that makes it possible for information workers to create their own powerful analytic models by combining and relating data from a wide variety of data sources.

SharePoint 2010 is the most popular business collaboration platform in the world for organizations of all sizes, and SharePoint 2010 Insights lets everyone access the business information they need to make good decisions. SharePoint 2010 Insights uses well-known applications and interfaces, people are comfortable from the start, and they know how to get the data they need. Excel Services makes it easy for anyone to publish their Excel workbooks in SharePoint 2010, including workbooks that use data from SQL Server 2008 R2 Analysis Services. From there, an entire team can access and analyze the same data from their web browser and rest assured that everyone has the right information. PerformancePoint Services is a new integrated capability in SharePoint 2010 Enterprise Edition that makes it easy to build flexible, highly interactive scorecards and dashboards using data from SQL Server 2008 R2 Analysis Services. SQL Server 2008 R2 PowerPivot for SharePoint makes it easy to publish analytic models created with SQL Server PowerPivot for Excel to SharePoint 2010 and share them with other users with Excel Services. SQL Server 2008 R2 Reporting Services supports SharePoint 2010 integration, making it easy to publish and access reports using familiar SharePoint paradigms.

Download this new release today at the following URL:

https://go.microsoft.com/?linkid=9710868 

Here’s a quick overview of what’s new in this release:

New Presentations (10):

  • What's New in the Excel 2010 Client
  • Loading and Preparing Data for Analysis in SQL Server PowerPivot for Excel 2010
  • Creating Reports with SQL Server PowerPivot for Excel 2010
  • Defining DAX Calculations with PowerPivot for Excel 2010
  • Introducing SharePoint 2010 Insights
  • What's New in SharePoint 2010 Excel Services
  • What's New in SharePoint 2010 PerformancePoint Services
  • Developing KPI's and Scorecards with SharePoint 2010 PerformancePoint Services
  • Developing Reports and Dashboards with SharePoint 2010 PerformancePoint Services
  • Managing PowerPivot for Excel 2010 Solutions in SharePoint 2010

New Demos (10):

  • What's New in the Excel 2010 Client
  • Loading and Preparing Data for Analysis in SQL Server PowerPivot for Excel 2010
  • Creating Reports with SQL Server PowerPivot for Excel 2010
  • Defining DAX Calculations with SQL Server PowerPivot for Excel 2010
  • Introducing SharePoint 2010 Insights
  • What's New in SharePoint 2010 Excel Services
  • What's New in SharePoint 2010 PerformancePoint Services
  • Developing KPI's and Scorecards with SharePoint 2010 PerformancePoint Services
  • Developing Reports and Dashboards with SharePoint 2010 PerformancePoint Services
  • Managing Excel 2010 PowerPivot Solutions in SharePoint 2010

New Hands-on Labs (6):

  • Loading and Preparing Data for Analysis in SQL Server PowerPivot for Excel 2010
  • Creating Reports with SQL Server PowerPivot for Excel 2010
  • Defining DAX Calculations with Excel 2010 PowerPivot
  • Developing KPI's and Scorecards with SharePoint 2010 PerformancePoint Services
  • Developing Reports and Dashboards with SharePoint 2010 PerformancePoint Services
  • Managing Excel 2010 PowerPivot Solutions in SharePoint 2010

New Videos (20):

  • Presentation: What's New in the Excel 2010 Client
  • Demo: What's New in the Excel 2010 Client
  • Presentation: Loading and Preparing Data for Analysis in SQL Server PowerPivot for Excel 2010
  • Demo: Loading and Preparing Data for Analysis in SQL Server PowerPivot for Excel 2010
  • Presentation: Creating Reports with SQL Server PowerPivot for Excel 2010
  • Demo: Creating Reports with SQL Server PowerPivot for Excel 2010
  • Presentation: Defining DAX Calculations with PowerPivot for Excel 2010
  • Demo: Defining DAX Calculations with SQL Server PowerPivot for Excel 2010
  • Presentation: Introducing SharePoint 2010 Insights
  • Demo: Introducing SharePoint 2010 Insights
  • Presentation: What's New in SharePoint 2010 Excel Services
  • Demo: What's New in SharePoint 2010 Excel Services
  • Presentation: What's New in SharePoint 2010 PerformancePoint Services
  • Demo: What's New in SharePoint 2010 PerformancePoint Services
  • Presentation: Developing KPI's and Scorecards with SharePoint 2010 PerformancePoint Services
  • Demo: Developing KPI's and Scorecards with SharePoint 2010 PerformancePoint Services
  • Presentation: Developing Reports and Dashboards with SharePoint 2010 PerformancePoint Services
  • Demo: Developing Reports and Dashboards with SharePoint 2010 PerformancePoint Services
  • Presentation: Managing Excel 2010 PowerPivot Solutions in SharePoint 2010
  • Demo: Managing Excel 2010 PowerPivot Solutions in SharePoint 2010

This is the final update for this training kit.  We hope you find this content useful in understanding how to take advantage of these important improvements in your solutions.

Technorati Tags: SQL Server 2008 R2,Excel 2010,SharePoint 2010,PowerPivot,PerformancePoint Services