Page 89 of 1211 results
  • In a previous post , I have used a stock exchange scenario to speak about how to compute moving averages in a complex scenario. Playing with the same scenario, I felt the need to compare two stocks on the same chart, choosing the stock names with a slicer.  Read more

  • 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

  • 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

  • In this post I want to analyze a data model that perform some basic computations over stocks and uses one of the most commonly needed formula there (and in many other business scenarios): a moving average over a specified period in time. Moving averages  Read more

  • 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

  • I spend most of my time developing complex BI solutions and, doing that, I always talk with DBA, developers, CEO, data analysts and the many kind of people that work around a BI solution. Nevertheless, in these last months, publishing posts about PowerPivot  Read more

  • 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

  • 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

  • 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

Show more