January 2011 - Posts

• Stock Analysis and Moving Average with PowerPivot

  One week ago Alberto Ferrari wrote a post about how to do working days calculation in PowerPivot . You might think this is necessary only for accounting department or something like that… but in reality the same techniques are really useful to implement Read More... Posted Thursday, January 27, 2011 7:09 PM by Marco Russo (SQLBI) | 2 Comments Filed under: Excel, PowerPivot, DAX

• PowerPivot Workshop: Last Days for London and Early Bird in Frankfurt

  Short post about PowerPivot Workshop : there are still a few days to register for the London date (7-8 February 2011). If you are interested in the Frankfurt date (21-22 February 2011), the next week will be the last one to get the discounted Early Bird Read More... Posted Thursday, January 27, 2011 5:38 PM by Marco Russo (SQLBI) | 0 Comments Filed under: PowerPivot

• BonaVista Dimensions used as a report service

  Recently I have seen a long demo of BonaVista Dimensions . It is a product that is able to create reports and, most important dashboards. You can use it also without SQL Server and Analysis Services, just by importing data in a local cube file that you Read More... Posted Wednesday, January 26, 2011 10:13 AM by Marco Russo (SQLBI) | 1 Comments Filed under: MDX, Excel, Reporting Services

• Training Center interested to PowerPivot Workshop

  As you probably read so often in this blog, we are arranging a roadshow of out PowerPivot Workshop . If you are a trainer or works in a training center to select products to offer to your customer, you might be interested in delivering the same course Read More... Posted Monday, January 24, 2011 4:10 PM by Marco Russo (SQLBI) | 0 Comments Filed under: PowerPivot

• Working days calculation with PowerPivot

  Whenever you have to calculate the distance between two dates, you can simply subtract two dates and DAX in PowerPivot will give you the answer. However, in case you want to calculate the difference in terms of working days you have to instruct your data Read More... Posted Thursday, January 20, 2011 7:58 PM by Marco Russo (SQLBI) | 1 Comments Filed under: PowerPivot, DAX

• What is PowerPivot? Start learning PowerPivot

  We just added a page in the PowerPivot Workshop web site containing an introduction to PowerPivot. There are already several web sites with a general description of PowerPivot and we adapted parts of the first chapter of the book PowerPivot for Excel Read More... Posted Thursday, January 20, 2011 6:29 PM by Marco Russo (SQLBI) | 0 Comments Filed under: PowerPivot

• PowerPivot appliance announced from HP

  HP and Microsoft announced an appliance for PowerPivot . This is very interesting and might solve the issue of PowerPivot adoption in certain companies (where the problem is the support required for installing and maintaining SharePoint 2010). You can Read More... Posted Thursday, January 20, 2011 11:49 AM by Marco Russo (SQLBI) | 8 Comments Filed under: PowerPivot

• SQLBI Methodology at SQLBits in Brighton

  I lost the count of how many SQLBits I lost for one reason or another, but now it’s the time! I and Alberto will present a full day training on April 7 at SQLBits 8 in Brighton. Our seminar will be dedicated to the SQLBI Methodology and is based on the Read More... Posted Wednesday, January 19, 2011 12:06 AM by Marco Russo (SQLBI) | 0 Comments

• Inside DAX Time Intelligence functions

  Jeffrey Wang wrote a new post about DAX Time Intelligence functions. This is an “under the cover” description that explains the rationale behind these functions, which need to be used following particular guidelines (described at the beginning of the Read More... Posted Tuesday, January 18, 2011 11:03 AM by Marco Russo (SQLBI) | 0 Comments Filed under: PowerPivot, DAX

• PowerPivot Workshop in Frankfurt (and London early-bird expiring soon) #ppws

  One week ago I described the PowerPivot Workshop Roadshow that we are planning in several European countries. The news today is that the Workshop will be in Frankfurt (Germany) on February 21-22, 2011 ! The registrations are open on www.powerpivotworkshop.com Read More... Posted Thursday, January 13, 2011 5:19 PM by Marco Russo (SQLBI) | 1 Comments Filed under: PowerPivot, DAX

• Ranking with PowerPivot – a different approach

  Alberto Ferrari wrote an interesting post about a “different approach” in creating a ranking measure with PowerPivot . If you know DAX or you read our book , you will find that a DAX expression can solve the issue. However, such a formula is more complex Read More... Posted Wednesday, January 12, 2011 7:45 PM by Marco Russo (SQLBI) | 0 Comments Filed under: PowerPivot, DAX

• PivotViewer demo for photographers

  I have a friend (Sandro Rizzetto) that is also a photographer. A good one, but his job is in IT. For these reasons, after reading some posts of mines, he built a PivotViewer page to navigate its photo database. You can drilldown by category, date, lens, Read More... Posted Wednesday, January 12, 2011 4:28 PM by Marco Russo (SQLBI) | 2 Comments

• Donald Farmer left Microsoft for QlikView

  As many of you probably already know, Donald Farmer left Microsoft to join QlikView . There are no doubts that Donald have been “the face of Microsoft BI” in the last years. This news has been initially perceived (me included, I admit) as a possible lack Read More... Posted Saturday, January 08, 2011 11:30 AM by Marco Russo (SQLBI) | 7 Comments

• PowerPivot Course European Roadshow – first stop London #ppws

  After the successful first edition in Amsterdam of the PowerPivot Workshop in December, we are planning to repeat this 2-day intensive course on PowerPivot in several other European countries (we are also evaluating one or two possible dates in US – please Read More... Posted Wednesday, January 05, 2011 5:26 PM by Marco Russo (SQLBI) | 2 Comments Filed under: Conference, DAX, PowePivot