October 2013 archive

The logic of Power Pivot

Working with Power Pivot it isn’t hard. In fact it’s easier than Excel but the logic is totally different. But if you respect the next 3 rules, you will be able to build measures for your model Rule 1: Structure of the data When you want to create a measure, your data must be stored …

Continue reading

Presentation of Power Pivot

Power Pivot is a new tool of Excel 2013 that allows you to perform calculations on an unlimited number of rows. The calculation can be done with calculated columns, like in Excel, or with measures. It all starts with SQL Server Before to explain how to use Power Pivot, it is important to know that …

Continue reading