Selected Tags:

design, excel
Available Tags: date, dax, hierarchy, model, parent-child, performance, relationship, sap, security, sharepoint, time, writeback
Title Author Date
Table Denormalization Study in PowerPivot Marco Russo 02/05/2010
Building Data Relationships in PowerPivot Artemakis Artemiou 03/12/2010
Combine two files (or fact tables) in PowerPivot using relationships, relationships explained Kasper de Jonge 04/11/2010
Creating a measure in PowerPivot that excludes values that are in a second table (like SQL Not in) Kasper de Jonge 04/16/2010
Create IPhone BI using RoamBI and data from PowerPivot Kasper de Jonge 04/18/2010
Sorting month by natural sort order Julie Strauss 04/22/2010
Hierarchies, Oh Hierarchies…where are thou? (in PowerPivot) Denny Lee 05/13/2010
Hierarchies in PowerPivot Dan English 05/19/2010
Sorting PowerPivot Labels Manually Dan English 06/24/2010
The single version of the truth in PowerPivot Thomas Ivarsson 08/29/2010
1,300 Measures – Nightmare or Utopia? Rob Collie 09/07/2010
Create chained relationships in PowerPivot Marco Russo 09/10/2010
PowerPivot Time Calculations Teo Lachev 01/18/2011
Campaign Analysis: Seasonally-Adjusted Measures Rob Collie 01/19/2011
Working days computation in PowerPivot Alberto Ferrari 01/19/2011
Exploring PowerPivot for Excel and SharePoint: Blue Yonder Charters Microsoft 01/24/2011
Using SQL Server PowerPivot for Excel to Analyze SAP Data Microsoft 01/26/2011
PowerPivot Data Modelling for Performance Boyan Penev 01/30/2011
PowerPivot and the Slowly Changing Dimensions Alberto Ferrari 02/09/2011
Date and Date/Time - Sneaky Data Types! Rob Collie 02/27/2011
PowerPivot, Parent/Child and Unary Operators Alberto Ferrari 03/01/2011
Write-back Using PowerPivot Ken Puls 03/11/2011
PowerPivot Nested Set Measures Goban Saor 03/11/2011
Ordering Months in PowerPivot Pivot table Gopal G 04/19/2011
Sorting Months from PowerPivot models in Excel Filters and Slicers Jen Stirrup 09/07/2011
 

Varigence Vivid