Category Archives: 17545

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



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, or Tomorrow’s Data – bit.ly/14KrjCL


Lightswitch For The Enterprise
Self Reporting via PowerPivot In Highly Deferred Execution Mode – bit.ly/VtkjBj


Data Explorer
Data Explorer Online Search Overview – bit.ly/10eJLfx


PowerPivotPro
New Version of Data Explorer Released – bit.ly/16il19t


Katie & Emil Newsletter
Add-in Data Explorer and Excel tutorial – conta.cc/XDYIHw


SQL blog.com
BI Beginner: Data Explorer is a must have – bit.ly/YBl7bO


Gobán Saor
M’s back – Create a PowerPivot Time Dimension using Excel’s Data Explorerbit.ly/ZqJVmq


Gobán Saor
The Model of a very modern PowerPivot – without the add-in – bit.ly/YDgRFE

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



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 Explorerbit.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 Explorerbit.ly/Ydiorz


LessThanDot
How I used Data Explorer to create a demo – < a href=”http://bit.ly/10hIYhi”>bit.ly/10hIYhi


PowerPivotPro
ISFILTERED: A Better Way to Detect Totals – bit.ly/ZRvCon


Brent Greenwood’s BI Blog
Pareto Chart with PowerPivotbit.ly/14cfXXs


Gobán Saor
[Updated]Look’s like Star Schema is back on the menu! – bit.ly/YBcB8Z


Chris Webb’s BI Blog
UK/US Date Format Bug in PowerPivot and SSAS Tabular – bit.ly/WMd8Jy


Romi’s Stream
Data Explorer for Excel: An experiment with Sachin Tendulkar – bit.ly/1188Lrc


Machlis Musings
New Excel Data Explorer add-in bolsters data analysis – bit.ly/16Uah4g


MSSQLTips
Creating Hierarchies in PowerPivotbit.ly/X8uAZS

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



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 Explorerbit.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! – bit.ly/10JyB8r


Gobán Saor
DAX’s back – Create DAX Measures in Excel 2013 without PowerPivot Add-in – bit.ly/XjZZn4


Kasper de Jonge PowerPivot Blog
What is eating up my memory the PowerPivot / Excel edition – bit.ly/113zmpl


Some Random Thoughts
Unpivoting Data in Data Explorer- bit.ly/118xIGy


Javier Guillén Pervasive Business Intelligence
Configuring “drill to details” behavior in PowerPivot: Part 1 – bit.ly/YlDZbE


PowerPivotPro
PowerPivot on Airplanes and NBC – bit.ly/142RIen

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



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 Explorerbit.ly/Z4BSdv


Chris Webb’s BI Blog
Data Explorer–Where Does The Real Work Get Done? – bit.ly/VOkkVc


Dynamics NAV Financials
PowerPivot to the People – bit.ly/YtSzzK


PowerPivotPro
A funny thing happened in Redmond… – bit.ly/12rBmfH


Gerhard Brueckl’s BI Blog
Another Post about Calculating New and Returning Customers – Part 2 – bit.ly/YKRMHL


Chris Webb’s BI Blog
Calling A Web Service From Data Explorer, Part 2 – bit.ly/Y9gdi1


Vignesh C
Consume csv with Data Explorerbit.ly/14lWZcN


Matt Masson
Dynamic Lookups With Data Explorerbit.ly/Vw6Zkg


Some Random Thoughts
Introduction to Data Explorer Preview for Excel – bit.ly/ZaWrDt


Dan English’s BI Blog
Installing Data Explorer Preview & Demo with IMDB Data – bit.ly/W0vvJe


Chris Webb’s BI Blog
Calling A Web Service From Data Explorer, Part 1 – bit.ly/WErC9X

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



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 Explorerbit.ly/YWPTvA


SSISJunkie
Traversing the Facebook Graph using Data Explorerbit.ly/VWYY6J


Matt Masson
Access the Windows Azure Marketplace from Data Explorerbit.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 Explorerbit.ly/160EaiL


Chris Webb’s BI Blog
Public Preview of Data Explorerbit.ly/XPmXlK


Microsoft
Microsoft “Data Explorer” Preview for Excel – bit.ly/Y6WY8M


PowerPivotPro
Toggling Conditional Formatting On/Off via Slicer – bit.ly/XLISNW


SQLBI – Marco Russo
Update to the PowerPivot for Excel 2013 licensing – bit.ly/XLILlB


TechCrunch
Microsoft Launches Updated Office 365 For Business, Adds ProPlus With Full Office Apps And New Small And Medium Business Versions – http://tcrn.ch/YHyaEb


MSSQLTips
Importing SQL Server Data from Multiple Data Sources into PowerPivot for Excel – bit.ly/WAQ2kD


PowerPivotPro
How to buy PowerPivot 2013, and the $30 Volume Licensing Workaround – bit.ly/ZYLrzc


MSSQLTips
Combining Data from Multiple Relational Data Sources into One Table in PowerPivot for Excel – bit.ly/13dFUFY

PowerPivot (& DAX) BlogRoll – 24th February 2013



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 masses if the Excel 2013 masses can’t get BI? – zd.net/ZcFt9G


SQLBI – Marco Russo
The Right Version of Excel 2013 for using PowerPivotbit.ly/151oieu


Gobán Saor
Look’s like Star Schema is back on the menu! – bit.ly/Y931eM

PowerPivot (& DAX) BlogRoll – 17th February 2013



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
Fiscal Periods, Tabular Models and Time-Intelligence – bit.ly/W3SiAH


SQL Chick
Checklist for Knowing Your PowerPivot Model is Complete – bit.ly/YzWEQh

PowerPivot (& DAX) BlogRoll – 10th February 2013



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 – bit.ly/XU0wuK

PowerPivot (& DAX) BlogRoll – 3rd February 2013



PowerPivot & DAX activity announced on Twitter for the week ending 3rd February 2013.


 


Chandoo.org
Introduction to DAX Formulas & Measures for PowerPivotbit.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 Query – bit.ly/UsB0Sx


SQLServerCentral.com
Stairway to PowerPivot and DAX – Level 2: The DAX COUNTROWS() and FILTER() Functions – bit.ly/TQbVRb


Project Botticelli
[Pay Site]New Video Tutorial by Marco: Querying with DAX – bit.ly/11FJzLY


PowerPivotPro
Mini Post #3 of 3: Are You Using Excel 2013 Yet? – bit.ly/XelcPO


PowerPivotPro
Mini Post #2 of 3: Supporting/Example Files from the Book Available for Free Download – bit.ly/11FHPCz


PowerPivotPro
Mini Post #1 of 3: Interview at SoftwareAdvice.com – bit.ly/11OzlUX


Pyramid Analytics
Pyramid Analytics announces deeper Integration with PowerPivot and SQL Server Tabular Analysis- bit.ly/WXSbcV


Technet
Tutorial: Optimize a Sample PowerPivot Model for Power View Reports – bit.ly/UssbZ1


BurningSuit
What is PowerPivotconta.cc/VGpoMe


Salvo(z)
Currency Conversion in Tabular Model Using DAX – http://bit.ly/118W7LG


PowerPivot-info.com
PASS Business Analytics conference – Chicago, IL – April 10-12, 2013 – bit.ly/WpEGT8


Gerhard Brueckl’s BI Blog
Dynamic ABC Analysis in PowerPivot using DAX – bit.ly/T3PBSv

PowerPivot BlogRoll – 27th January 2013



PowerPivot activity announced on Twitter for the week ending 27th January 2013.


 


Chandoo.org
Introduction to DAX Formulas & Measures for PowerPivotbit.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 PowerPivotbit.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 blog
A Time dimension specifically for PowerPivot & AS Tabular – bit.ly/Wut3dK


MindSharp
Demystifying PowerPivot in SharePoint and Excel -http://bit.ly/VkwlNq