PowerPivot & DAX & Data Explorer BlogRoll – 31st March 2013

Microsoft sneaked a couple of ne PowerPivot & DAX & Data Explorer activity announced on Twitter for the week ending 31st March 2013.   SQLBI Checklist for Memory Optimizations in PowerPivot and Tabular Models – bit.ly/17aAaNr Beyond Rational MS BI # 85 – PowerPivot #2 – Download , Install , Connect to SQL Server and Getting Started – bit.ly/14BHhyJ Bacon Bits Use Data Explorer to Hack into Very Hidden Sheets – bit.ly/ZIcNqk readwrite enterprise Microsoft’s Data Explorer: Picking Up Where Bing Leaves Off – bit.ly/16XQXDd Matt Masson Consuming CANSIM Datasets using Data Explorer – bit.ly/10llbL8 PowerPivotPro Always Show Yesterday, Today, … Continue reading PowerPivot & DAX & Data Explorer BlogRoll – 31st March 2013

PowerPivot & DAX & Data Explorer BlogRoll – 24th March 2013

Microsoft sneaked a couple of ne PowerPivot & DAX & Data Explorer activity announced on Twitter for the week ending 24th March 2013.   Romi’s Stream Data Explorer for Excel: An experiment with Sachin Tendulkar – bit.ly/1188Lrc Kasper de Jonge PowerPivot Blog NBA team spending and their results with Excel, PowerPivot and Data Explorer – bit.ly/10sJuJo SQLServerCentral.com Stairway to PowerPivot and DAX – Level 4: The DAX BLANK() Function – bit.ly/Zllw1a BaconBits 5 Cool Things You Can Do With Data Explorer – bit.ly/Ydiorz LessThanDot How I used Data Explorer to create a demo – < a href=”http://bit.ly/10hIYhi”>bit.ly/10hIYhi PowerPivotPro ISFILTERED: A … Continue reading PowerPivot & DAX & Data Explorer BlogRoll – 24th March 2013

PowerPivot & DAX & Data Explorer BlogRoll – 17th March 2013

Microsoft sneaked a couple of ne PowerPivot & DAX & Data Explorer activity announced on Twitter for the week ending 17th March 2013.   MS Office Blog Learn about Data Explorer Formulas – bit.ly/118wr2d Javier Guillén Pervasive Business Intelligence PivotStream and Mariner join forces to deliver PowerPivot solutions – bit.ly/118uzqc Chris Webb’s BI Blog Finding Shakespeare’s Favourite Words With Data Explorer – bit.ly/133FUcz Erik Svensen How to use Data Explorer for Excel to extract data from Statistics Denmark – bit.ly/YKjCag MSDN Blog A new build of Data Explorer, and an Auto Update feature – bit.ly/WwuR7P SSIS Junkie M Lives! – … Continue reading PowerPivot & DAX & Data Explorer BlogRoll – 17th March 2013

PowerPivot & DAX & Data Explorer BlogRoll – 10th March 2013

Microsoft sneaked a couple of ne PowerPivot & DAX & Data Explorer activity announced on Twitter for the week ending 10th March 2013.   Extended Results Calendar Analytics – bit.ly/VYvfLU PowerPivotPro PowerPivot Discovers a New Form of Communication in the Animal World, Makes Headlines in Science! – bit.ly/YhOPhN Matt Masson Using Data Explorer with Power View – bit.ly/XYGt2H Customer Feedback SQL Server Content Samples Data Explorer: An introduction to table relationships and the Expand operation – bit.ly/XWWtlN PowerPivotPro “Introducing” Data Explorer – bit.ly/Z4BSdv Chris Webb’s BI Blog Data Explorer–Where Does The Real Work Get Done? – bit.ly/VOkkVc Dynamics NAV Financials … Continue reading PowerPivot & DAX & Data Explorer BlogRoll – 10th March 2013

PowerPivot & DAX & Data Explorer BlogRoll – 3rd March 2013

Microsoft sneaked a couple of ne PowerPivot & DAX & Data Explorer activity announced on Twitter for the week ending 3rd March 2013.   Chris Webb’s BI Blog Importing Data From Multiple Log Files Using Data Explorer – bit.ly/YWPTvA SSISJunkie Traversing the Facebook Graph using Data Explorer – bit.ly/VWYY6J Matt Masson Access the Windows Azure Marketplace from Data Explorer – bit.ly/YHwRFq Altius Consulting Best Oscar winning Film? My first Data Explorer adventure… – bit.ly/VWYC01 Ian’s SharePoint Blog SharePoint OData and the Excel Data Explorer – bit.ly/160EaiL Chris Webb’s BI Blog Public Preview of Data Explorer – bit.ly/XPmXlK Microsoft Microsoft “Data … Continue reading PowerPivot & DAX & Data Explorer BlogRoll – 3rd March 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

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