Tag Archives: Gemini
PowerPivot DAX, i love it!
Vidas Matelis has been twittering live from the DAX session at the SQLPass. I just wanted to share these great new function available in DAX: Data Analysis Expressions = DAX DAX lets user do multidimensional analysis without user knowing that this is multidimensional analysis sample DAX: =[Qty]*[Price] – syntax just like Excel. DAX is not [...]
Project BI bloggers – Analysis in PowerPivot (ex-Gemini)
Tomislav Piasevoli created a very cool PowerPivot demo where he using a csv file supplied by Vidas Matelis’ Analysis Services Blog to analyze the bloggers. Great sample of using PowerPivot! Read the entire blog post here.
Trying to solve a business problem with Powerpivot, Gemini CTP2
Today I tried to solve a much occurring, simple, ad hoc business problem with PowerPivot CTP2 based on a actual reporting services report i recently build on top op SSAS and reading PivotTable Named Sets in Excel 2010. I tried to solve the following scenario: I want to see the OrderQuantity of the current month compared to the monthly [...]
Introducing PowerPivot (Gemini), a more comprehensive look of what is inside
At the MS Excel team blog they have a great blog post where a member of the SQL Server Analysis Services team, Ashvini Sharma, will tell us about the PowerPivot. The post gives a comprehensive look at the entire PowerPivot product, from front to back and names all components. Read the entire article here: http://blogs.msdn.com/excel/archive/2009/10/22/introducing-powerpivot.aspx The [...]
Donald Farmer Discusses the Benefits of Managed Self-Service BI with PowerPivot
The SQL Server magazine has posted an interview with Microsofts Donald Farmer, a great interview. It explains how PowerPivot (called Gemini in the post) will affect the end users and what the reason for existence is for PowerPivot and how it will affect us BI consultants, even with some Real world samples. A great piece [...]
Gemini will ship as “SQL Server PowerPivot”
Microsoft just announced at the Microsoft SharePoint Conference 2009 in Las Vegas this morning that project codename Gemini will ship as “SQL Server PowerPivot for Excel” and “SQL Server PowerPivot for Sharepoint”. And immediately launched the new site http://www.powerpivot.com/. Loads of information at the IT pro’s at PowerPivot datasheet. “SQL Server PowerPivot for Excel” Is [...]
Gemini Does Cloud!
Andrew Brust made a great blogpost about opening a Azure database with gemini: http://www.brustblog.com/archive/2009/09/03/gemini-does-cloud.aspx
Channel 9: Donald Farmer and Julie Strauss: Inside Project Gemini
Great video about gemini where Donald Farmer and Julie Strauss talk about the inside of gemini: http://channel9.msdn.com/posts/Charles/Donald-Farmer-and-Julie-Strauss-Inside-Project-Gemini
Login