Author Archives: Zaim Raza

About Zaim Raza

7 Years of professional experience in Business intelligence using SQL Server and Microsoft SharePoint/.net Technologies. Experience in Data warehousing, Data Modeling, Data profiling, Data Integration, Data cleansing, consultations and enterprise reporting. I want to work for organization where I am able to utilize my skills, experience and knowledge to transform the technology into business value.

POWER BI For Excel & Office 365

It’s easier than ever to transform complex data into meaningful insights and share them with your team. Power BI is a powerful new way to visualize and interact with data in Excel and Office 365. Search, discover, and with just … Continue reading

Image | Posted on | Leave a comment

Populate your dimensions with Unknown Members

Normally in every dimension load my first task is to insert the unknown value in the dimension table. This is tedious and time consuming task if dimension has many columns with different data types. And to make the script and … Continue reading

Posted in SSIS, T-SQL | Tagged | Leave a comment

PowerPivot Capacity Specification

PowerPivot for Excel is an add-in that you can use to perform powerful data analysis in Excel 2010, bringing self-service business intelligence to your desktop. PowerPivot for Excel includes a window for adding and preparing data, and a PowerPivot tab on the Excel … Continue reading

Posted in PowerPivot | Leave a comment

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 | 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