Archive for the ‘Excel’ Category
What you need to know about – “PowerPivot”
Hi All, Today i would like to talk about a booming technical feature by Microsoft i.e. “PowerPivot“. What is PowerPivot? PowerPivot (which is also known as Project “Gemini“) is Microsoft’s hottest business intelligence (BI) innovation. By integrating PowerPivot technology with Microsoft Excel, Excel has gradually becoming most wanted & preferred BI tool (client) in the [...]
February 24, 2012
· 
Khilitchandra Prajapati · 
3 Comments
Tags: Excel 2010, PowerPivot, SharePoint 2010, SQL Server 2008 R2 · Posted in: Excel, Pivot Table, SharePoint, SQL Server
Browse an SSAS Cube using Excel – Automatic Setup done by SQL Server Data Tools
Hi All, Most of us; who are working on SQL BI solutions are aware of connecting SSAS Cube using Excel (as client) for browsing. Because we know that how much the clients/financial users likes to work with Excel In SQL 2012 RC0, there is one handy-dandy quick-link which enables us to make this whole functionality [...]
February 12, 2012
· Khilitchandra Prajapati · 2 Comments
Tags: Excel, Pivot Table, SQL Server 2012, SSAS · Posted in: Excel, New Features, Pivot Table, Quick Tips, SQL Server, SSAS
