October 2010 - Posts

• DataMarket and PowerPivot

  Yesterday Microsoft released the Windows Azure Marketplace DataMarket (which everyone will simply call DataMarket, I hope). It was previously called Codename “Dallas”. This is an important step toward the empowerment of self-service BI tools. Microsoft Read More... Posted Friday, October 29, 2010 10:51 AM by Marco Russo (SQLBI) | 6 Comments

• A new release of Visio Forward Engineer

  A few days ago Alberto released the version 1.1 of the Visio Forward Engineer add-in for Microsoft Office Visio 2010. I think it should be a standard feature of Visio, but you know, Microsoft priorities are not always aligned with our ones, and the “do-it-yourself” Read More... Posted Friday, October 22, 2010 4:11 PM by Marco Russo (SQLBI) | 0 Comments

• Many-to-many relationships in PowerPivot – more samples!

  Alberto wrote a really fine post that should help you to better understand how many-to-many relationships can work in PowerPivot, using a lot of images that explain some concepts better than a thousand words. The example shown by Alberto is really interesting Read More... Posted Wednesday, October 20, 2010 7:55 PM by Marco Russo (SQLBI) | 0 Comments Filed under: PowerPivot, DAX, PASS

• PowerPivot book sample chapters available in PDF

  You can download these two sample chapters of the PowerPivot for Excel 2010: Give Your Data Meaning book: Chapter 2 - PowerPivot at Work This is introductive and suggested to read to anyone who is new to PowerPivot Chapter 7 – Date Calculations in DAX Read More... Posted Tuesday, October 19, 2010 7:12 PM by Marco Russo (SQLBI) | 0 Comments Filed under: Excel, Book, PowerPivot

• Inside DAX session at PASS

  I will be a speaker this year at PASS Summit 2010 in Seattle, and I will present two sessions. The one I’d like to talk about in this post is the Inside DAX one. I chose to do this session (instead of another one that was initially planned) because when Read More... Posted Friday, October 15, 2010 5:04 PM by Marco Russo (SQLBI) | 1 Comments Filed under: Conference Communities, Conference, PowerPivot, DAX

• Define groups of values using PowerPivot

  Alberto Ferrari posted an interesting article that show how you can use a continuous value in a group of values in PowerPivot. I think this is a feature that many users would like to get in a standard Analysis Services cube, but that unfortunately requires Read More... Posted Thursday, October 14, 2010 6:36 PM by Marco Russo (SQLBI) | 0 Comments Filed under: PowerPivot, DAX

• SQLBI Methodology session recording available

  If you lost the SQLBI Methodology session (or any other one) at 24 Hours of PASS in September, now you can watch the recordings on-line ! I just looked at the presentation and unfortunately there are 6 minutes missing from our presentation. Thus, if you Read More... Posted Tuesday, October 12, 2010 6:21 PM by Marco Russo (SQLBI) | 0 Comments Filed under: Methodology, PASS

• PowerPivot book in stock!

  My Microsoft® PowerPivot for Excel® 2010: Give Your Data Meaning book has been printed and is now in stock on many bookstores! This is another good news of the past week, who have been dense of good news. I and Alberto have been interviewed by Vidas Matelis Read More... Posted Sunday, October 10, 2010 6:28 PM by Marco Russo (SQLBI) | 2 Comments Filed under: Conference Communities, Book, PowerPivot, PASS

• PowerPivot Course in Europe

  A few days ago Kasper anticipated that I and Alberto will teach a 2-day PowerPivot course based on our PowerPivot book . The location will be next the Amsterdam airport, at Schiphol, Netherlands, and the dates are December 1st and 2nd, 2010. When we prepared Read More... Posted Tuesday, October 05, 2010 2:16 AM by Marco Russo (SQLBI) | 1 Comments