Excel 2010

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.

Lessons

Hands On Lab: Loading and Preparing Data for Analysis in SQL Server PowerPivot for Excel 2010
This lab introduces the PowerPivot for Excel add-in and produces a PowerPivot model. Tasks include loading and preparing data from a variety of data sources including SQL Server tables, Excel workbooks and a Reporting Services feed.
Hands On Lab: Creating Reports with SQL Server PowerPivot for Excel 2010
This lab uses Microsoft Excel 2010 to produce PivotTable reports based on the PowerPivot model produced in Exercise 2.
Hands On Lab: Defining DAX Calculations with Excel 2010 PowerPivot
This lab extends the PowerPivot model and reports created in Exercises 2 and 3 with DAX calculated columns and measures.
Demo: What's New in the Excel 2010 Client
This demo covers the new analysis and reporting capabilities in the Excel 2010 Client, including new PivotTable and PivotChart functionality and PowerPivot.
Demo: Loading and Preparing Data for Analysis in SQL Server PowerPivot for Excel 2010
This demo covers how to load and prepare data in the PowerPivot client for analysis in Excel 2010.
Demo: Creating Reports with SQL Server PowerPivot for Excel 2010
This demo covers how to create reports using Excel 2010 PivotTable and PivotChart features with data from PowerPivot.
Demo: Defining DAX Calculations with SQL Server PowerPivot for Excel 2010
This demo covers how to use data analysis expressions (DAX) to create calculated columns and multi-dimensional calculations using Excel 2010 PowerPivot.
Presentation: What's New in the Excel 2010 Client
This presentation introduces the new analysis and reporting capabilities in the Excel 2010 Client, including new PivotTable and PivotChart functionality and self-service analysis with PowerPivot.
Presentation: Loading and Preparing Data for Analysis in SQL Server PowerPivot for Excel 2010
This presentation introduces PowerPivot for Excel 2010 and explores how to use it to load and prepare data for self-service analysis.
Presentation: Creating Reports with SQL Server PowerPivot for Excel 2010
This presentation covers how to design and format PivotTable and PivotChart reports using PowerPivot for Excel 2010 and how to use slicers to filter results.
Presentation: Defining DAX Calculations with PowerPivot for Excel 2010
This presentation introduces the DAX (data analysis expressions) syntax in PowerPivot for Excel 2010, and describes how to use it to define calculated columns and measures.
Presentation: What's New in the Excel 2010 Client
This presentation introduces the new analysis and reporting capabilities in the Excel 2010 client, including new PivotTable and PivotChart functionality and self-service analysis with SQL Server PowerPivot for Excel 2010. Presenter: Peter Myers, Mentor, Solid Quality Mentors.
Demo: What's New in the Excel 2010 Client
This demo covers the new analysis and reporting capabilities in the Excel 2010 client, including new PivotTable and PivotChart functionality. Presenter: Peter Myers, Mentor, Solid Quality Mentors.
Presentation: Loading and Preparing Data for Analysis in SQL Server PowerPivot for Excel 2010
This presentation introduces SQL Server PowerPivot for Excel 2010 and explores how to use it to load and prepare data for self-service analysis. Presenter: Peter Myers, Mentor, Solid Quality Mentors.
Demo: Loading and Preparing Data for Analysis in SQL Server PowerPivot for Excel 2010
This demo covers how to load and prepare data for analysis in SQL Server PowerPivot for Excel 2010. Presenter: Peter Myers, Mentor, Solid Quality Mentors.
Presentation: Creating Reports with SQL Server PowerPivot for Excel 2010
This presentation covers how to design and format PivotTable and PivotChart reports using SQL Server PowerPivot for Excel 2010 and how to use slicers to filter results. Presenter: Peter Myers, Mentor, Solid Quality Mentors.
Demo: Creating Reports with SQL Server PowerPivot for Excel 2010
This demo covers how to create PivotTable and PivotChart reports with SQL Server PowerPivot for Excel 2010. Presenter: Peter Myers, Mentor, Solid Quality Mentors.
Presentation: Defining DAX Calculations with PowerPivot for Excel 2010
This presentation introduces the DAX (data analysis expressions) syntax in SQL Server PowerPivot for Excel 2010, and describes how to use it to define calculated columns and measures. Presenter: Peter Myers, Mentor, Solid Quality Mentors.
Demo: Defining DAX Calculations with SQL Server PowerPivot for Excel 2010
This demo covers how to use data analysis expressions (DAX) to create calculated columns and multi-dimensional calculations using SQL Server PowerPivot for Excel 2010. Presenter: Peter Myers, Mentor, Solid Quality Mentors.

Excel 2010

Lessons

The Team