Monthly Archives: March 2013

How to restore PowerPivot excel file as a SSAS Database.

Basically PowerPivot stores the data inside the In memory analysis services (Vertipaq). You can restore the inside database into the SSAS tabular or SharePoint instance. Following are the easy steps to get the inside database from the PowerPivot file: 1. … Continue reading

Posted in PowerPivot, SSAS | Leave a comment

What’s Inside an SSIS 2012 .ispac File?

If you’re curious, you can rename the .ispac file and give it a .zip extension, and extract. Voila, we see all the files that make up the ispac – a manifest, your DTSX files, and a .param file. Also note … Continue reading

Posted in SSIS | Tagged | 2 Comments

Small Businesses Adoping Tablets in a Big Way

Image | Posted on by | Tagged | Leave a comment

Self-Service BI using PowerPivot and Power View

A powerful solution that provides users of all levels with new insights through familiar Microsoft Office tools. Organizations can create compelling reports and analytical applications, easily share insights, and collaborate with colleagues. See following presentation for detail about products overview: … Continue reading

Posted in SQL Server features | Leave a comment

Best ETL Tool

Please volunter yourself for 1 minute survey: https://docs.google.com/spreadsheet/viewform?fromEmail=true&formkey=dElSZkwzLVZIREk2R3gwa2VZUHYtWWc6MQ and following are the poll results: https://docs.google.com/spreadsheet/ccc?key=0AkCj0lCS4PZ7dElSZkwzLVZIREk2R3gwa2VZUHYtWWc

Image | Posted on by | Leave a comment

Microsoft “Data Explorer” Preview for Excel ( Self-service ETL )

On February 27, Microsoft announced a future addition to self-service line-up with Microsoft Data Explorer Preview for Excel. “Data Explorer” is self-service ETL for the Excel power user. The integration between “Data Explorer” and the rest of the Self-Service BI … Continue reading

Posted in Microsoft Excel | Leave a comment