Watching multiple demos and analyzes of Microsoft Gemini Project.
Since a huge amount of corporate and product related data is still located in Excel and multiple local/legacy MS Access databases, this can be interesting and promising option for BI and PLM.
What is your opinion?
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.