Pilot-View on Microsoft Gemini 1


I’ll take in somehow big series about Microsoft Gemini and its features, I found it great very fast while loading big dataset and also I submit bug once it occurs.

I’ll talk in this post about Load & Prepare Data (From Database) in Microsoft Gemini…

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/

First, let’s install Gemini as it’s not by default installed on Excel 2010

Gemini2If you download it from Microsoft Connect, it comes with two client versions, x64 and x86 choose which fits your processor architecture.

Gemini1Then it shows on your Excel ribbon menu

Gemini3

Let’s explore it…

Gemini4

Let’s go through loading and preparing data in Gemini

Gemini5

When we press on Load & Prepare Data a new Book of Gemini Client opens to get the data from its sources to be analyzed.

Gemini6

As you see you can load data from database or RSS (Yes!!!) or from Report…. (just a note you can load data from heterogeneous data sources and set\remove the relationships in Gemini and it’s not required to be added before loading) I’ll press on From Database,

Gemini7

and as you see there lots of data sources Gemini can connect to (I don’t install Oracle\Teradata\DB2\Sybase or even Informix) then select Microsoft SQL Server

Gemini8

For demonstration we use AdventureWorksDW

Gemini9

Gemini10

And we select some tables and views to load data from

Gemini11

Don’t search for related tables Gemini gets related tables like SSAS, and it’s the summary…

Gemini12

It loads it quickly about 2 seconds

Gemini13
Gemini14

Those the tables we have selected and ready to be analyzed.

I recommend you to use Gemini and tell your organization about it. It provides Excel users rich functionalities to do analysis with simple clicks in short time.

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: