-
Next week I will finally start the roadshow of the SSAS Tabular Workshop, a 2-day seminar about the new BISM Tabular model for Analysis Services that has been introduced in SQL Server 2012. During these roadshows, we always try to… Read more
-
On January 18th, 2012 at 12pm Eastern Time (which is 5pm GM) Alberto Ferrari will deliver a free online session for the PASS DW/BI Virtual Chapter. This is the official description of the session. Many-to-Many Relationships in DAX The introduction… Read more
-
The video of the session Vertipaq vs OLAP: Change Your Data Modeling Approach that I delivered at SQLBits 9 is finally available! You can find here the video of sessions I and Alberto Ferrari delivered at the last two SQLBits.… Read more
-
I’ve been at SQL Pass and it has been a really great conference. I will write soon more technical content, there are a few notes about the good and the bad of the overall experience that I’d like to share.… Read more
-
If you are looking to create many-to-many relationships based models in PowerPivot and in BISM Tabular, probably one day you will be interested in using them with Power View (formerly codename “Crescent”). There is a very bad news for you:… Read more
-
VertiPaq is the internal column-based database engine used by PowerPivot and BISM Tabular models. High cardinality columns might be the more expensive parts of a table. If you cannot remove a high cardinality column from a table, by using the… Read more
-
During the PowerPivot Workshop in London we received many interesting questions and Alberto had the inspiration to write this nice post about Slowly Changing Dimensions handling in PowerPivot. It is interesting the consideration about SCD Type I attributes in a… Read more
-
The next Monday, March 21st, I will join a special event organized by the Danish SQL Server User Group, Excelbi.dk and the Swedish SQL Server User Group. The meeting will start at 18:00 at the Radisson Royal Blu in Copenhagen,… Read more
-
Last week Alberto published an interesting post about Counting Products in the Current Status with PowerPivot. Starting from a question raised from a reader, Alberto described how to solve a common issue (let me know the “current status” of each… Read more
-
These are the last days to register for the PowerPivot Workshop in Zurich on April 4-5, 2011. If you are willing to attend, hurry up!Moreover, on Thursday evening there will be also a Swiss PASS Chapter meeting in Zurich and… Read more