Linked Tables

In our previous blog post, we discussed how easy it is to use the Copy/Paste feature of the PowerPivot [aka Gemini] add-in to bring in data from virtually any external source that cannot otherwise be accessed by means of an ODBC, OLEDB or Managed .NET provider. In these scenarios, business users are free to copy… Read more

Introducing PowerPivot

At the Microsoft SharePoint Conference yesterday in Las Vegas, we announced the official name for Gemini – “Microsoft SQL Server PowerPivot” or “PowerPivot” for short. PowerPivot consists of two components – PowerPivot for Excel 2010 and PowerPivot for SharePoint 2010. PowerPivot for Excel is a data analysis tool that delivers unmatched computational power directly within… Read more


One of the core tenets of Gemini is that the user should be able to import data from virtually any source. The blog post Importing data into Gemini talks about the steps involved in importing data from a typical relational source. Gemini supports all of the popular relational databases – SQL Server, Access, Oracle, Sybase,… Read more

Introduction to Data Analysis Expressions (DAX) in Gemini

Gemini and DAX Extend the Power of PivotTables Excel PivotTables are not new, but Excel PivotTables that are based on multiple tables of data are new with the Gemini add-in for Excel 2010. This new capability in Gemini is a very powerful tool for data analysis when combined with our new DAX expression language. Looking… Read more

Data Feeds

One of the keys to self-service BI is that people need the highest quality, up-to-date data for their analysis. Many people don’t have direct access to query the databases underlying the applications that they use on a day to day basis, both because of the complexity of the data and also the need for adding… Read more

Importing data into Gemini

This time around we will take a closer look at ways of getting your data into Gemini model. In particular we will into importing data using “conventional” ways. Using variety of OLEDB/ODBC/.Net client libraries. Choosing Data Source To import your data click on the “From Database ” in the Gemini Client Window and enter Import… Read more

Gemini Blogs & Videos

It’s been almost a month since we released the first CTP of Gemini and there has been a lot of activity on the newsgroups and in the blogosphere. Here are some interesting blog links… Kasper de Jonge ( Working with Gemini and Excel 2010 to make a pivot table Publish Gemini App to SharePoint and… Read more

Overview of PowerPivot features

Note: this post refered to PowerPivot by its codename, Gemini. The content, however, is still a good overview of the functionality available in PowerPivot. You can download PowerPivot here. The key question behind Gemini is: how much value can an Excel user derive from Microsoft’s BI stack without having to pick up a book on… Read more

Getting Access to the Gemini CTP

As indicated in the previous blog post, you can get access to the Gemini CTP if you are a member of the Office 2010 Tech Preview by visiting If you are not a member of the Office Tech Preview, you can still apply for the Gemini CTP. We have a limited number of seats… Read more

Welcome to the Gemini Team Blog!

Gemini is the code name for the new breakthrough Self-Service Business Intelligence (BI) capabilities being delivered in the SQL Server 2008 R2 release. Gemini enables end users to build BI applications by integrating data from a variety of sources, modeling, refining and analyzing the data, adding business logic, building reports and visualizations and ultimately sharing… Read more