PowerPivot BlogRoll – 27th January 2013

Microsoft sneaked a couple of ne PowerPivot activity announced on Twitter for the week ending 27th January 2013.   Chandoo.org Introduction to DAX Formulas & Measures for PowerPivot – bit.ly/126dmx9 Kasper de Jonge PowerPivot Blog Filtering results to only show top x results in Power View chart – bit.ly/UzkC0n PowerPivotPro Modeling Viral and Marketing Growth, Part 3 of 3 – bit.ly/114srjB Chris Webb’s BI Blog Building Relative Date Reports in PowerPivot – bit.ly/XOEXw8 Stefan Johansson Create Time Dimension- bit.ly/126aWyJ PowerPivotPro Modeling Viral and Marketing Growth, Part Two – bit.ly/XOEBpl Brent Greenwood’s BI blogA Time dimension specifically for PowerPivot & AS … Continue reading PowerPivot BlogRoll – 27th January 2013

PowerPivot BlogRoll – 20th January 2013

Microsoft sneaked a couple of ne PowerPivot activity announced on Twitter for the week ending 20th January 2013.   PowerPivotPro Modeling Viral Growth vs. Traditional Advertising in PowerPivot – bit.ly/10EOrS3 Javier Guillén Pervasive Business Intelligence Grouping by an Aggregation in DAX – bit.ly/SeC22c PowerPivotPro Calendar Tables: Not Just for Formulas. Use Them on Your Pivots Too! – bit.ly/W6YrMa Javier Guillén Pervasive Business Intelligence Leveraging DAX query tables for staging Data Transformations – bit.ly/13Awule Some Random Thoughts Row Selection Using Slicers in PowerPivot – Part 1 – bit.ly/108bp2H Chris Webb’s BI Blog A Different Approach To Last-Ever Non-Empty in DAX – … Continue reading PowerPivot BlogRoll – 20th January 2013

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