Information, tips, news and announcements about SQL Server Analysis Services and PowerPivot directly from the product team.
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 it with their coworkers in an environment that is managed and secured by IT. See SQL Server 2008 R2 | Self-Service Business Intelligence for more information.
Following is a sneak preview of Gemini that Donald Farmer (from our team) presented at TechEd 2009 this summer.
The Gemini team is proud to announce our first preview release as part of the SQL Server 2008 R2 August CTP (Community Technology Preview). See the Data Platform Insider Blog for more information on the August CTP. To download the Gemini CTP, visit http://www.microsoft.com/officebusiness/office2010/Default.aspx?vid=Gemini. Gemini requires Office 2010, so you must be a member of the Office 2010 Tech Preview.
In the days, weeks and months to come, folks from the Gemini product team will be blogging here and sharing information about the product.
I know that the best way to test Gemini is to use our own data. However, it would be good to have way to download the data that you used in the demo. I specially want to test the 100 million + rows in Gemini with your data, before be able to test it with real data.
Sorry, the 100 million row dataset cannot be shared publicly. Like you said, it is best to try your own data. You will however get access to tutorials and samples along with the CTP.
In Most of the data analysis tool displaying Rank 3-10 (top & bottom) in a single page easily available through one click.
Is this function available without writing the rank function in raw data?
Incase yes kindly guide