Excel 2010

In part one of this two-part series, Larry Waldman, Excel Program Manager, discusses how to think about designing Excel solutions for the Web. As the Program Manager for Excel Services extensibility, Larry talks through the power of solutions built on Excel Services and what's now available in…

In part two of this two-part series, Larry Waldman, Excel Program Manager, talks in detail about how to execute the migration of Excel client solutions to web-based Excel Services solutions. Larry walks through the migration of a sample Excel client application to its new incarnation as a Web-based…

Join Roger as he covers database and BI development on the SQL Server Information Platform. You can follow and interact with the show @SQLServer. In the DataBound premier, Roger is joined by Aaron and Chris from Extended Results to discuss a custom PowerPivot application they developed for…

This presentation covers the use of Excel 2010 as an Analysis Services client.  Presenter: Peter Myers, Mentor, Solid Quality Mentors.

This demo shows how to develop a simple SQL Server 2008 R2 Reporting Services report using Analysis Services cube. The demo will show how to develop an MDX query with the graphical designer, and how to incorporate formatting properties from the cube in a report. Presenter: Peter Myers, Mentor,…

This demo shows how a user can create an in-memory cube with SQL Server 2008 R2 PowerPivot and Excel 2010.  Presenter: Peter Myers, Mentor, Solid Quality Mentors.

This demo shows a complete BI solution end-to-end that delivers information to decision makers using SQL Server 2008 R2 and Office 2010.  Presenter: Peter Myers, Mentor, Solid Quality Mentors.

This presentation introduces the concept of self-service analysis and the business scenarios it addresses, and discussions how SQL Server 2008 R2 can be used to meet these requirements.  An architectural overview of SQL Server 2008 R2 self-service analysis components is also provided including…

A high level synopsis of Microsoft's Technical Computing offerings is presented by Ryan Waite, General Manager for High Performance Computing.  The sheer size of generated data is a key driver in today's computational ecosphere.  By the end of 2010, over 1.2 zetabyte of data will have…

Microsoft Excel has become an indispensible calculation, prototyping, and simulation tool that handles complex multi-variable models.  A fictitious case study is described where the customer, an insurance underwriter, explores over one trillion scenarios to optimize investments that hedge its…