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

If One Is Not Enough, …

Microsoft sneaked a couple of ne It is generally accepted that it is a good programming practice to not use monolithic code, but to break functional units of code into separate subs or functions and call these from a control procedure. Functions are very useful for passing values back to the calling procedure, but functions return a single value so what if you want to get more than one value returned to you calling procedure? I have often seen this topic raised in the Excel forums, a statement that a function cannot return multiple values, or a question on how … Continue reading If One Is Not Enough, …

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

PowerPivot (& DAX) BlogRoll – 24th February 2013

Microsoft sneaked a couple of ne PowerPivot & DAX activity announced on Twitter for the week ending 24th February 2013.   InfoWorld More Office 2013 bait-and-switch revelations – bit.ly/XWHF5d RAMBLES.IO A Response To Where Did My PowerPivot Go? – bit.ly/W5RRep Erik Svensen Create a dynamic table from PowerPivot data in Excel 2013 without VBA – bit.ly/11Uwsre SQLBI – Marco Russo DAX Time Intelligence for 4-4-5 Calendar, ISO Calendar and other custom ones – bit.ly/UDm1nM PowerPivotPro Revolutionaries in Redmond! PowerPivotPro Readers Quoted in ZDNet! – bit.ly/YvMxxd DynamicAccounting.Net Microsoft peed on my PowerPivot – bit.ly/152Km8G ZDNet Can Microsoft bring BI to the … Continue reading PowerPivot (& DAX) BlogRoll – 24th February 2013

PowerPivot (& DAX) BlogRoll – 17th February 2013

Microsoft sneaked a couple of ne PowerPivot & DAX activity announced on Twitter for the week ending 17th February 2013.   The Data Specialist Equivalent of VLOOKUP in DAX–Part I – bit.ly/Xk0FKL PowerPivot Pro Hey, Who Moved My (PowerPivot 2013) Cheese? – bit.ly/11OZdWp PowerPivot Pro New Beginning – bit.ly/15fNsXV PowerPivot Pro Tomorrow is the Last Day for Chandoo Sign-Up! – bit.ly/VUlOOD The Data Specialist Bug in PowerPivot 2012 for Excel 2010 – bit.ly/WLhoIh PowerPivotPro “Announcing” the Business Analytics Conference – bit.ly/XPDerQ BaconBits PowerPivot and PowerView Confusion in Office 2013 – bit.ly/Vpfqws Technitrain [Course]Advanced DAX – bit.ly/Vpfqws Gerhard Brueckl’s BI Blog … Continue reading PowerPivot (& DAX) BlogRoll – 17th February 2013

PowerPivot (& DAX) BlogRoll – 10th February 2013

Microsoft sneaked a couple of ne PowerPivot & DAX activity announced on Twitter for the week ending 10th February 2013.   PowerPivotPro Guest Post from Ken Puls: Determine Effective Tax Rate – bit.ly/U2vdlc PowerPivotPro When to Use Measures vs. Calc Columns – bit.ly/VQSm8E SQLBI First DAX Advanced Workshop in London, May 2013 DAX Tabular SSAS – bit.ly/Y3sx4Y Excel Hero Blog Master Excel PowerPivot Now – bit.ly/X0vnXa Javier Guillén Pervasive Business Intelligence Developing child-aware KPIs in PowerPivot and BISM Tabular – bit.ly/VDtCyI Some Random Thoughts UNION Operation in DAX Queries – bit.ly/XTZa33 ProLogika Forums PowerPivot Data Refresh in Excel 2013 – … Continue reading PowerPivot (& DAX) BlogRoll – 10th February 2013

PowerPivot (& DAX) BlogRoll – 3rd February 2013

Microsoft sneaked a couple of ne PowerPivot & DAX activity announced on Twitter for the week ending 3rd February 2013.   Chandoo.org Introduction to DAX Formulas & Measures for PowerPivot – bit.ly/126dmx9 Cindy Gross Hurricane Sandy Mash-Up: Hive, SQL Server, PowerPivot & Power View – bit.ly/WLYQan Chris Webb’s BI Blog Office 2013, Office 365 Editions and BI Features – bit.ly/14zvxdt MSSQLTips PowerPivot with Excel 2013 – bit.ly/XenvCk PowerPivotPro Stars and Snowflakes and Bears, Oh My! – bit.ly/WrDNdG SQLBI Execute a DAX Query on SSAS Tabular in Excel – bit.ly/Y7zHDP SQLBI Import Data from Tabular Model in Excel Using a DAX … Continue reading PowerPivot (& DAX) BlogRoll – 3rd February 2013