DataMarket Revisited: The Truth is Out There
Yeah, I love quoting movies. And tv shows. And song lyrics. But it’s not the quoting that I enjoy – it’s the connection.
Category: Importing Data
Using Query Editor to Create a Time Table
The first thing I ever do when I create a new PowerPivot workbook is create the date tables that I need.
SQL UNPIVOT Makes My Data Skinny
If you’re anything like me, you will have eagerly sucked data into PowerPivot, keen to get cracking with solving all of your reporting needs.
The Ultimate Date Table
I get a lot of questions from people who are struggling with the time intelligence functions in DAX.
Date and Date/Time – Sneaky Data Types!
These Two Columns Both Contain Dates, Right? Sure They Do! Relationships that should work, but aren’t? Here’s a quick tip, one that I think we’ll all need sooner or later. […]
PowerPivot Accelerators: The Story (And Announcing: the Private Beta)
We’ve received a lot of exciting interest and have identified about 15 great
A few tips on maintainability
Eat This Not That, PowerPivot Edition! Just like normal Excel, PowerPivot requires little or no premeditation – you can just jump right in and build something quite impressive. But if […]
Welcome Query designers!
-Guest Post by the one and only Dany Hoter! We Excel geeks aren’t spoiled with fancy query builders. We have had MSQuery for the last what? 15 years? Suffice to […]
- 1
- 2