Building Data Relationships in PowerPivot

This post is a follow-up to the previous post titled: “Using PowerPivot’s Copy-Paste Support for Importing Data from Word”. In this post we will see how we can import data from Microsoft Word using PowerPivot’s copy-paste feature, create relationships on the data and perform aggregations that is BI! 🙂 For example, consider the two following … Read more…

Using PowerPivot’s Copy-Paste Support for Importing Data from Word

One of the great features of SQL Server PowerPivot is that it supports importing data directly from the clipboard. This is quite handy in cases you want to import and analyze data fast. An example of using the above feature is importing data from Microsoft Word. Let’s say you have a Word document containing the … Read more…

Introduction to SQL Server PowerPivot – MS Momentum 2009 Session Review

This article, is an introduction to SQL Server PowerPivot and also a review of my session on the MS Momentum 2009 event, that took place in Cyprus.   About the MS Momentum 2009 Event in Cyprus On November 26th 2009, Microsoft-Cyprus launched Momentum 2009; a New Efficiency Community Launch event. The event took place in Nicosia, … Read more…