Excel Do, Dynamic Does : PowerPivot, SharePoint

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

Bob Phillips — Tue, 02 Apr 2013 10:35:00 GMT

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 Explorer - bit.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

Bob Phillips — Mon, 25 Mar 2013 21:29:00 GMT

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 Better Way to Detect Totals - bit.ly/ZRvCon

Brent Greenwood's BI Blog
Pareto Chart with PowerPivot - bit.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 PowerPivot - bit.ly/X8uAZS

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

Bob Phillips — Mon, 18 Mar 2013 09:24:00 GMT

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! - 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

Bob Phillips — Sun, 10 Mar 2013 23:57:00 GMT

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
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 Explorer - bit.ly/14lWZcN

Matt Masson
Dynamic Lookups With Data Explorer - bit.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

Bob Phillips — Sun, 03 Mar 2013 13:20:00 GMT

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 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

Bob Phillips — Tue, 26 Feb 2013 09:14:00 GMT

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 PowerPivot - bit.ly/151oieu

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

PowerPivot (& DAX) BlogRoll - 17th February 2013

Bob Phillips — Sun, 17 Feb 2013 20:55:00 GMT

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

Bob Phillips — Tue, 12 Feb 2013 00:30:00 GMT

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

Bob Phillips — Tue, 05 Feb 2013 13:11:00 GMT

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 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 PowerPivot - conta.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

Bob Phillips — Tue, 29 Jan 2013 09:39:00 GMT

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 blog
A Time dimension specifically for PowerPivot & AS Tabular - bit.ly/Wut3dK

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

PowerPivot BlogRoll - 6th January 2013

Bob Phillips — Sun, 06 Jan 2013 17:56:00 GMT

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

Bob Phillips — Tue, 01 Jan 2013 11:41:00 GMT

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