BY TOPIC▼
ARCHIVED BLOGS▼
POWERPIVOT 2010 BLOGS▼
BLOGS BY AUTHOR▼
BLOGS BY YEAR▼
Wise Owl Training - PowerPivot 2010 blogs
Showing blogs 1-7 (out of 7)
Using DAX Studio to edit calculated fields or measures in Excel
Posted by Andy Brown on 20 February 2015
The editor for calculated fields in Excel (aka measures) isn't the greatest; this blog shows you how to install and use DAX Studio as a substitute editor.
A review of Power View, including examples of use
Posted by Andy Brown on 09 January 2014
Power View is an Excel or SharePoint add-in which allows you to create quick and interactive dashboard reports, with built-in drill-down. This blog considers whether you're missing a trick if you don't know how to use Power View.
Using the RANKX function in PowerPivot DAX measures
Posted by Andy Brown on 04 November 2013
The RANKX function works out where a measure lies in order for any dimension, but it has a couple of gotchas to watch out for, as this blog explains.
How to use the RANKX function in PowerPivot
Posted by Andy Brown on 20 March 2013
This blog shows how to use each of the 5 arguments of the RANKX function to rank rows in PowerPivot.
An overview of PowerPivot for Excel 2010
Posted by Andy Brown on 31 January 2013
PowerPivot is a superb addition to Excel: it allows you to create pivot tables based on multiple tables taken from a variety of data sources, and its DAX language lets you report any statistic you want. This overview summarises how to get started with PowerPivot, and what it does.
Creating a PowerPivot calendar in Access or Excel
Posted by Andy Brown on 16 January 2013
This blog shows you how to create a calendar of dates for use in PowerPivot. Instructions are included for Excel and Access.
Create a calendar table for PowerPivot or Analysis Services in SQL Server
Posted by Andy Brown on 04 January 2013
This blog includes the SQL script to generate a table of calendar dates for linking to from within PowerPivot or an Analysis Services tabular model.