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