Selected Tags:

design

Available Tags: article, basket, date, dax, drillthrough, excel, hierarchy, kpi, load, many-to-many, mdx, mobile, model, parent-child, performance, perspective, relationship, sample, sap, security, sharepoint, time, tip, v2, video, 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
Working with PowerPivot: Roll Your Own Hierarchies Tim Knight 09/01/2010
1,300 Measures – Nightmare or Utopia? Rob Collie 09/07/2010
Create chained relationships in PowerPivot Marco Russo 09/10/2010
PowerPivot and Many to Many Relationships Alberto Ferrari 10/20/2010
Simple Basket Analysis in DAX Chris Webb 10/21/2010
PowerPivot Tips and Tricks - First Findings webadmin 11/22/2010
Ordering Dimensions in PowerPivot webadmin 11/22/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
The Single Table Model in PowerPivot Boyan Penev 02/13/2011
Many-To-Many Relationship Modelling in PowerPivot: Workaround Boyan Penev 02/13/2011
PowerPivot and Parent/Child hierarchies Alberto Ferrari 02/15/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
PowerPivot Show Details Goban Saor 03/22/2011
Are you making daiquiris or blenders? Rob Collie 03/23/2011
Merging Tables with Different Columns and Layouts in PowerPivot Alan Whitehouse 03/26/2011
Ordering Months in PowerPivot Pivot table Gopal G 04/19/2011
Business Intelligence Prototyping with PowerPivot Javier Guillen 04/28/2011
PowerPivot on the iPad: Best Practices Russell Christopher 05/09/2011
Developing Custom PowerPivot Apps Roger Doherty 06/05/2011
The problem of power users, DAX and difficult calculations Chris Webb 06/06/2011
The Great Precedence Project (Filter Rules for DAX) Rob Collie 06/14/2011
Analyzing Performance Data in PowerPivot Kay Unkroth 06/14/2011
Running Totals Without a Traditional Calendar Table Rob Collie 07/05/2011
Quartile, Percentile and Median in PowerPivot Javier Guillen 07/12/2011
PowerPivot V2 CTP3! Rob Collie 07/12/2011
DAX Queries, Part 1 Chris Webb 07/15/2011
DAX Queries, Part 2 Chris Webb 07/15/2011
PowerPivot Denali: Working with multiple relationships between two tables Kasper de Jonge 07/15/2011
Adding Values to Rows and Columns Julie Strauss 07/15/2011
PowerPivot Denali: Parent child using DAX Kasper de Jonge 07/18/2011
The Diagram is here. Julie Strauss 07/25/2011
PowerPivot - Diagram View Devin Knight 07/25/2011
PowerPivot Denali - Upgrading from SQL Server 2008 R2 and KPIs Jen Stirrup 07/25/2011
Tips and Tricks: Mapping Data to the World in a PowerPivot Workbook Kay Unkroth 08/16/2011
PowerPivot - Perspectives Devin Knight 08/16/2011
PowerPivot - Creating KPIs Devin Knight 08/16/2011
PowerPivot - Creating Hierarchies Devin Knight 08/16/2011
PowerPivot DAX: Find and Search in Denali Kasper de Jonge 08/16/2011
PowerPivot DAX PARALLELPERIOD vs DATEADD Kasper de Jonge 08/16/2011
PowerPivot in Denali: User Feedback and the Fourth Golden Rule of Interface Design Jen Stirrup 08/16/2011
Separate date and time in #powerpivot (and #bism tabular) Marco Russo 09/01/2011
Sorting Months from PowerPivot models in Excel Filters and Slicers Jen Stirrup 09/07/2011
Video - Many-to-Many Relationships in DAX Alberto Ferrari 11/21/2011
SQL UNPIVOT Makes My Data Skinny David Churchward 11/29/2011
The Greatest Formula in the World Rob Collie 12/06/2011
Prepayments and Deferred Revenue David Churchward 01/24/2012
PowerPivot and Linked Table Names Paul te Braak 01/29/2012
 

Varigence Vivid