Category Archives: 14648

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