Accessible from your Account page after purchase. Requires the free QuickTime Player software.
Videos can be viewed on: Windows 8, Windows XP, Vista, 7, and all versions of Macintosh OS X including the iPad, and other platforms that support the industry standard h.264 video codec.
Additional sample videos, individual lessons and other formats are available here.
Register your product to gain access to bonus material or receive a coupon.
Data Analysis Expressions! DAX is a new function language that's used with PowerPivot, PowerView, and GeoFlow. It makes Calculated Fields in PivotTables look sophomoric., The problem is, it's hard to learn. It's like going to the dentist. Everyone knows they have to do it, they just dont want to do it. Well, in these lessons, Bill Jelen gives you enough sample calculated fields, called Measures, to get you started.
DAX Measures
Use DAX Measures to Calculate a Range
Use DAX Measures to un-apply a Filter
Using a Calendar Table for Time Intelligence
Time Intelligence Functions
Disconnected Parameter Tables with FILTER()
Actuals vs Budget
Using IF(VALUES in a Measure
Build Slicers on Lookup Tables
First Initial Slicer (and turning off cross-slicer filtering)
Convert the Pivot Table to Cube Formulas