This article, discusses about PowerPivot and explains how you can enable PowerPivot in Excel 2016 or later, via a step by step guide. PowerPivot is an add-in for Excel that enables you to import and process millions of records from various sources right into Excel very fast. For old versions of Excel (i.e. version 2010) … Read more…
It’s been a while since my last post but I’ve changed job a few weeks ago and I was in the process of adapting to the new environment 🙂 OK! It is time to sit back, relax a bit, have a cold beer, put some music on, and start writing! A few weeks ago the … Read more…
This post is a follow-up to one of my previous posts, titled: “Using PowerPivot’s Copy-Paste Support for Importing Data from Word” and this time, we will be discussing about building data relationships in PowerPivot. To this end, in this post we will see how we can import data from Microsoft Word using PowerPivot’s copy-paste feature, … Read more…
In this article, we will be discussing about using PowerPivot’s copy-paste support for importing data from MS Word. Importing Data into PowerPivot 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 … Read more…
Hello and Happy New Year 2010! Wishing you all the best, a new year full of health, happiness, success and even more SQL Server knowledge!!! 🙂 As this is my first blog post in 2010, I thought that it should focus on a really hot topic! I hope you will enjoy it! I called this … Read more…
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…