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.

Tags:   Excel | PowerPivot    |    PowerPivot 2010 | DAX

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.

Tags:   Excel | PowerPivot    |    PowerPivot 2010 | General

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.

Tags:   PowerPivot 2010 | DAX

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.

Tags:   PowerPivot 2010 | DAX

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.

Tags:   Excel | PowerPivot    |    PowerPivot 2010 | General

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.

Tags:   Excel | PowerPivot    |    PowerPivot 2010 | Calendar

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.

Tags:   Excel | PowerPivot    |    PowerPivot 2010 | Calendar    |    SQL Server 2012 | SSAS 2012
This page has 0 threads Add post