October 2010
11 posts
“With this announcement, the SQL Server team has released an updated version of...”
– Announcing an updated version of PowerPivot for Excel - SQL Server Team Blog - Site Home - TechNet Blogs
Dropbox - Home - Online backup, file sync and... →
2 Gig of memory in the cloud… for free. This is nice for sharing files, and keeping some stuff available when you are travelling. It has a nice interface on Android phones as well.
Chandoo.org - Learn Microsoft Excel Online - Excel... →
Just to show that I don’t hate Excel for modelling: 169 pages of badass Ecel tipps.
1 tag
The dangers of Excel, and some proper way of...
Some weeks ago I did a little paper for some customer about the dangers of using Excel in critical business processes. I don’t want to repeat everything here, but basically it comes down to this: there is not enough security. For instance, unlike a proper management of processes like, e.g., in a business rule management system, you have not enough control over who changes what and not...
Time Intelligence Functions in DAX - PowerPivot... →
“PowerPivot can also use as a data source any Excel spreadsheet region formatted...”
– Microsoft PowerPivot: Making Excel Analytics Work — Visual Studio Magazine
I did not look into this feature of PowerPivot the last week when I played around. Parameters of an analytical model (like, e.g., price elasticities or target turnovers) can be kept in a normal Excel table, while...
Excellent sets of data for testing PowerPivot
List of suggested datasets to test PowerPivot
There is a lot of stuff here that might come handy, such as international cost of living.
“Many analysts seem to believe that they can declare victory and pat themselves...”
– It’s time to industrialize analytics | Smart Data Collective 