DAX, The Dark Knight

Excel Is Superman, DAX Is The Dark Knight Excel Formulas Are easy, So Why Is DAX So Hard? Recently, Rob Collie, aka PowerPivotPro, posted a blog entry entitled ‘The Ballad of Ken Puls, DAX Convert’. Whilst it was an interestiung post, this is not to specifically offer any comment on that blog, or to stroke Ken’s ego <g>, I was intrigued by the part where Rob mentioned that Ken had said, and I quote,   “I firmly believe that PowerPivot is the future of Excel.  No question in my mind.  It’s insanely easy to get some killer BI in your … Continue reading DAX, The Dark Knight

PowerPivot BlogRoll – 13th January 2013

Microsoft sneaked a couple of ne PowerPivot activity announced on Twitter for the week ending 13th January 2013.   The New Internal Data Model in Excel 2013 – bit.ly/VFumXvk New Customers Per Day Generalized to “New Customers per Month,” etc. – bit.ly/RP7EeK PowerPivot User Experience Survey – t.co/aGlhdPu7 New Customers per Day – bit.ly/VJtD7j Getting the active products between a date range using DAX – bit.ly/VDT7AH [Update] What is using all that memory on my Analysis server instance? – bit.ly/T51Hsc Parameterising PowerPivot Connection Strings in Excel 2013 – bit.ly/XKBOTH Technitrain 2013 Course Schedule: SSAS, PowerPivot, MDX, SSIS, TSQL and SQL … Continue reading PowerPivot BlogRoll – 13th January 2013

CUBEs For Dessert

Microsoft sneaked a couple of ne Introduction A few weeks ago I showed how to create a fully dynamic table using CUBE formulae against a PowerPivot model in Cooking With Cubes.This example presented data from the AdventureWorks database of sales of product categories over years, all integrated with a Fiscal Year slicer. I recently had a similar need, but with the further challenge of presenting two levels in a hierarchy (actually, this was related tables in a snowflake schema). I needed to show all of the items in the first level, and for each of these items, all of the … Continue reading CUBEs For Dessert

PowerPivot BlogRoll – 6th January 2013

Microsoft sneaked a couple of ne PowerPivot activity announced on Twitter for the week ending 6th January 2013.   Time To Name This Year’s Book! – bit.ly/TyZ5nX Database Pros in Demand – bit.ly/UXN78m [Commercial Webinar] Deep Dive into Business Intelligence in Excel 2013’s PowerPivot and Power View – bit.ly/115ls8J Creating Linked Tables in PowerPivot for Excel – bit.ly/TyZ5nX Excel 2013, Power View, Top 10 “long tail” and how DAX helpsbit.ly/YJTMkd

PowerPivot BlogRoll – 30th December 2012

Microsoft sneaked a couple of ne PowerPivot activity announced on Twitter for the week ending 30th December 2012.   Templated Excel workbooks with PowerPivot and Macro’s – bit.ly/12VdWwP Importing SQL Server Data from Multiple Data Sources into PowerPivot for Excel – bit.ly/UAX22u PowerPivot – Importing Data from Different Data Sources into PowerPivot for Excel – bit.ly/131Qi0v End of 2012 and news in 2013 for #PowerPivot, #ssas #tabular and BI – bit.ly/VpwWxI Refreshing PowerPivot Data in SharePoint 2013 – bit.ly/131Q3Ti [Video] Using PowerPivot with DataMarket Section of Windows Azure Marketplace – bit.ly/12Vd23e

PowerPivot BlogRoll – 23rd December 2012

PowerPivot activity announced on Twitter for the week ending 23rd December 2012.   Using HASONEVALUE in a DAX IF statement – bit.ly/TVMwA7 Create a memory-efficient Data Model using Excel 2013 and the PowerPivot add-in – bit.ly/ZfaRsf Introduction to MDX for PowerPivot Users, Part 5: MDX Queries – bit.ly/12wLGQI [Update] What is using all that memory on my Analysis server instance? – bit.ly/T51Hsc Running Product in DAX: Calculating Portfolio Returns – bit.ly/XOobxz The CALCULATE Function—New DAX Video Tutoria – bit.ly/XTTirq. Note that this is a subscription site. Dynamic CUBE Formulae In Excel – bit.ly/R6Fnjs The Ballad of Ken Puls, DAX Convert … Continue reading PowerPivot BlogRoll – 23rd December 2012

PowerPivot BlogRoll – 16th December 2012

PowerPivot in Excel 2013 – bit.ly/V1jN01 How PowerPivot can help financial reporting –bit.ly/T0o1Dj Importing your SalesForce data directly into PowerPivot – bit.ly/T0nRMi Set Up a VM Test Server for PowerView and PowerPivot – bit.ly/R0QY3s Hide Calculated Items With Zero Totals In PowerPivot PivotTables – bit.ly/12tBW8W Book Review: DAX Formulas For PowerPivot – bit.ly/12hDDXR Creating a Spacer Column in a PowerPivot PivotTable – bit.ly/T2bMHu