Chris Webb's BI Blog

Analysis Services, MDX, PowerPivot, DAX and anything BI-related

New Gemini Demos Dissected

with 5 comments

On the BI Blog on Monday a new set of Gemini demos were posted; they’re also available on YouTube. They look like the same demos I saw at PASS Europe a few weeks ago and while they don’t show much in the way of different functionality compared to what was shown late last year, I think there are a few interesting points to note. Unfortunately the quality of the picture is so poor you can’t make out much detail on the screen, so I can only really comment on what Donald Farmer (who’s presenting) specifically points out.

Let’s step through each demo and I’ll give you a running commentary on them…

  • 0:11 Note that Gemini isn’t built into Excel, it’s an Excel addin. I’m not sure whether it will work in Excel 2007 or only Excel 2010 (or whatever it’s called) but this is significant for another reason: it means that Gemini release cycles are not tied to Office release cycles, so potentially new releases of Gemini can appear reasonably regularly.
  • 0:35 We start off with sourcing data from a data warehouse – probably intentionally, to forestall some of the hostility that was seen when Gemini was first announced, when Gemini was seen as being yet another “you don’t need a data warehouse” type tool.
  • 1:05 Arggh, why can’t I see the buttons on the Data-Cleaning ribbon? It looks like there’s a lot of stuff there, although it might not be all working properly yet.
  • 1:45 The obligatory boast about how much data you can work with – in this case 20 million rows – on a regular desktop machine. In my experience that’s the average number of rows I see in a fact table underneath SSAS (though of course it can handle way more than that), so the number was probably deliberately chosen for that reason, as well of course to get the Excel users out there salivating. Suddenly posts like this seem less funny, more like a chilling prediction of things to come…
  • 2:48 You can copy data into Gemini from the clipboard. Note that you don’t seem to be able to link to the data directly in Excel, at least not yet. Donald also mentions that ‘other data sources’ will be supported – it’ll be interesting to see which ones.
  • 3:18 Creating a pivot table. We seem to be back in regular Excel here and out of the Gemini addin, although Donald says that ‘in Gemini we have some cool pivot tables we can handle’. Perhaps what we’re seeing here are Excel 2010 pivot tables.
  • 3:50 Pointing out the inferred relationship between tables. I suspect this relationship was inferred well before this point; we already know you are going to be able to set these relationships up manually.
  • 4:26 Showing data as a percentage of total. There seems to be a big button to do this; are there going to be any other easy calculations available? Where are the calculations taking place, and how are they expressed – in Excel or the underlying Gemini cube?
  • 4:50 New slicer bars – mentioned as a ‘new feature in Excel’, specifically for Gemini but also available for other Excel users. So this must be new generic Excel pivot table, rather than Gemini functionality. This looks really good; I like the way they are aware of each other too, and aware of what data is available, though I wonder how exactly they know whether data is available and how this would work with cubes containing calculations etc.
  • 0:20 Set theme – whoa, so you can apply a theme to an Excel spreadsheet? Hmm, turns out you can already do this. But it is a powerful feature when you want to create a report.
  • 0:30 Publishing to Sharepoint, but notice how Donald mentions that publishing a model containing 20 million rows would take a bit of time. How long exactly? Minutes? Hours?
  • 0:40 The Sharepoint report centre. OK, so we can rate reports with stars, yeah that’s going to be useful… but other ‘social tools for collaboration’ might be interesting.
  • 1:03 Setting a refresh rate. Basically how often the local cube underneath Gemini gets processed, I suppose. How long will a refresh take though?
  • 1:21 Seeing the report in a thin client. This is Excel Services, I think…? This will only make it harder to choose between Excel/Excel Services/Gemini on one hand and SSRS on the other. It would be nice if there was some kind of story linking the two.
  • 2:57 The operations dashboard – again, I wish I could see more detail of what’s on screen. I can see some of the stuff you’d expect, like metrics on CPU usage and query response times. It’s all done in Excel Services again – I wonder if there’s a cube behind it all storing the performance data?
  • 3:46 Upgrading and formalising a popular app. But notice that the option is ‘upgrade to PerformancePoint’…? The focus is on upgrading for better maintenance and management rather than performance; I guess in PerformancePoint you’ve got IT control over the report design. Possibly, when server-side SSAS gets the Gemini storage engine, you’ll be able to push the Gemini cube into an instance of SSAS. But when you’ve done this will you still be able to use the performance metrics dashboard we’ve just seen?

Written by Chris Webb

May 6, 2009 at 6:11 pm

Posted in Gemini

5 Responses

Subscribe to comments with RSS.

  1. Nice job on the commentary Chris. Thought the CTPs for this would be coming out shortly… I believe they are supposed to be out prior to PPS SP3.

    Dan

    May 7, 2009 at 2:33 am

  2. When Donald did the demo at the BI Conference last year I also spotted the Data Cleansing in the Ribbon and was hoping for a demo or to be able to view some of the capabilites and options. Unfortunately with the low quality of the video in YouTube you can\’t make any of this out and he doesn\’t zoom in on the Ribbon at all to see the components. This is the exact same demo he did at the conference that was available to watch with the keynote videos they made available. I would have liked to have seen what the promote to PPS option does too and how gemini items translate into PPS items or what that even means. How is this going to be different for performance if it is already deployed to SharePoint.I was also wondering why they didn\’t put these on Soapbox (MSN Video)…but this morning that site is not even available or working and I see that the videos that I have on my blog that reference Soapbox are not working and are just spinning their wheels. I thought it was interesting if you click on the video link and go to the YouTube site for the first Gemini demo that the first related video is QlikView.

    Dan

    May 7, 2009 at 12:38 pm

  3. I\’ve added a few new Gemini demos and some other new and interesting MS BI demos to the Microsoft BI Blog, check them out here: http://blogs.msdn.com/bi/archive/2009/05/20/microsoft-bi-power-hour-demos.aspx I\’d love to hear your comments and dissections on these as well. Thanks for watching.

    Nic

    May 21, 2009 at 2:15 am

  4. For more MS BI updates on futures, demos, and other cool things we are up to stay tunned to the BI blog and follow me on Twitter. http://twitter.com/nicfish

    Nic

    May 21, 2009 at 2:16 am

  5. can\’t visit youtube now

    laptopchina.com

    August 6, 2009 at 2:05 am


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

Follow

Get every new post delivered to your Inbox.

Join 3,083 other followers

%d bloggers like this: