What you need to know about Gemini


What is Microsoft’s Gemini?
Gemini is essentially an add-in to Excel that allows very large sets of data to be manipulated. Why Excel? Simply because it’s a familiar environment for most people and the place where they expect to perform analysis.
But there’s more. Not only can Gemini handle very large sets of data, but it can also allow data from disparate sources to be cross analyzed. So, for instance, you might pull in some data from your data warehouse and cross-correlate it with data from the Internet or with data you already hold in Excel.
Let’s face it — Excel doesn’t have a great track record of being able to handle big sets of data. So Microsoft has added a new in-memory column store to handle the data. Can Gemini? Well, the demo I watched was run on a desktop with 8 GB RAM and a quad processor, and costs just less than $1,000. It was handling 100 million rows of data effectively instantaneously. So, I’d take that as a yes.

Clearly, Gemini is not aimed at the professional database (relational or multidimensional) developer — it is aimed at the business user who needs to perform analysis. So there are no tools for explicitly allowing you to create, for example, a star schema. Instead, Gemini is built for end users and it will, for example, automatically infer relationships between the sets and join them behind the scenes (it also has mechanisms to help deal with nonmatching data).
So it’s a fascinating technology — but what is it for, how will it be used? The honest answer is that nobody currently knows and in five years’ time it will either be a forgotten idea or in common usage. But the possibilities are intriguing.
Source: http://searchdatamanagement.techtarget.com/news/column/0,294698,sid91_gci1334112,00.html

Busines Intelligence Keynote: Self Service Analysis
http://www.youtube.com/watch?v=RLSMGxbwfjg

Self Service Analysis Demo
http://www.youtube.com/watch?v=MzgMMO-P9F0&feature=related

Sharing Self Service Analysis Demo
http://www.youtube.com/watch?v=y_sBgjOHvRk

Source:http://blogs.msdn.com/bi/archive/2009/05/04/preview-of-project-gemini.aspx

6 Responses to What you need to know about Gemini

  1. […] What’s Gemini? Project code-name “Gemini” for Excel 2010 provides ground-breaking technology, such as fast manipulation on large data sets (often in millions of rows), streamlined integration of data, and the ability to effortlessly share your analysis through SharePoint 2010. […]

  2. […] First, you should have Microsoft Excel 2010 Technical Preview (until now 12-9-2009) which in Microsoft Office 2010 Technical Preview, don’t you know what’s Gemini check this https://ramymahrous.wordpress.com/2009/05/06/what-you-need-to-know-about-gemini/ […]

  3. […] First, you should have Microsoft Excel 2010 Technical Preview (until now 12-9-2009) which in Microsoft Office 2010 Technical Preview, don’t you know what’s Gemini check this https://ramymahrous.wordpress.com/2009/05/06/what-you-need-to-know-about-gemini/ […]

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: