| Working with Gemini (PowerPivot) and Excel 2010 to make a pivot table |
| Written by Kasper de Jonge |
| Monday, 17 August 2009 21:31 |
|
Even though it’s my holiday i couldn’t resist to download and install SQL Server 2008 R2 and play around with Gemini. I forgot you have to have access to Excel 2010 to do so, luckily some co-workers have access to the Technical Preview so i could get it there. After installing SQL Server 2008 R2 and Office 2010 i still didn’t have a Gemini tab, it appears you have to download the Gemini add-in separately, you can do so here: https://sharepoint.connect.microsoft.com/SQLServer/Gemini. You do have to get access from Microsoft before you can download the plug-in. Ok on to Gemini. |
Author articles
- Use PowerPivot DAX to automatically report on the last month that has data
- Using the excel function SEARCH in PowerPivot DAX
- Tune your PowerPivot DAX query, don’t use the entire table in a FILTER and replace SUMX if possible
- What is that PowerPivot pivottable context they keep talking about?
- Use Time intelligence functions to do a running sum of the last 6 months with PowerPivot
Most Popular
- Step by step guide on installing PowerPivot for SharePoint on a single machine
- List of suggested datasets to test PowerPivot
- List of PowerPivot DAX functions with description
- How to install PowerPivot for Excel and list of know issues
- Microsoft Virtual Lab: PowerPivot for Excel 2010 Introduction
- List of PowerPivot DAX functions (short)
- PowerPivot's impact on BI pros?
- Recorded webcast - A Preview to PowerPivot Server Best Practices
