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