|
|
SQLBI is a blog dedicated to building Business Intelligence solutions with SQL Server.
You can follow me on Twitter: @marcorus
Browse by Tags
All Tags » BISM (RSS)
-
During the writing of The Definitive Guide to DAX I wanted a simple way to analyze the content and distribution of data compressed in the VertiPaq engine, used by Analysis Services Tabular, Power Pivot and Power BI models. I always relied on BISM Memory Read More...
|
-
A few days ago I published a new article on DAX Patterns web site describing how to implement Basket Analysis in DAX. This topic is a very classical one and is also covered in the many-to-many revolution white paper. It has been also discussed in several Read More...
|
-
In the last weeks the Microsoft BI buzzword has been Power BI for Office 365, which will be available soon in preview. I read a few comments about the fact that there is a constant discussion about the future but a lack of information and discussion about Read More...
|
-
If you think PowerPivot and Tabular are good tools but sometime the design tools are not fast/complete/flexible enough, please consider voting this suggestion on Connect to request a textual representation Tabular or PowerPivot Data Models . This is the Read More...
|
-
As I mentioned a couple of weeks ago, I and Alberto are starting to travel again, delivering SSAS Tabular Workshop and other free community events around Europe. This is the updated list of our next dates, including community events: Online – SSAS Tabular Read More...
|
-
I and Alberto Ferrari will speak at SQLBits XI (Nottingham, UK – May 2-4, 2013) and there are many good reasons to join us there, especially if you are interested to DAX! Here are our sessions: Thursday, 02 May 2013 – Training Day - From 0 to DAX The Read More...
|
-
During the last months I and Alberto worked in several projects using Analysis Services Tabular and we had to face real world issues, such as complex queries, large data volume, frequent data updates and so on. Sometime we faced the challenge of comparing Read More...
|
-
It has been a long wait, but finally our book about Analysis Services Tabular is available! Microsoft SQL Server 2012 Analysis Services: The BISM Tabular Model Amazon is already shipping it in US and it should be available soon also in Europe. However, Read More...
|
-
In June I participated to two TechEd editions ( North America and Europe ). I and Alberto delivered a Pre Conference and two sessions about Tabular. Both conferences provides recorded sessions freely available on Channel 9 so that you can compare which Read More...
|
-
We are still in the early days of DAX and even if I have been using it since 2 years ago, there is still a lot to learn on that. One of the topics that historically interests me (and many of the readers here, probably) is the many-to-many relationships Read More...
|
-
After the first two editions of the SSAS Tabular Workshop , I and Alberto had some time to flush some of the pending activities. We published two articles: Clever Hierarchy Handling in DAX : DAX is not a hierarchy-friendly language, especially if you Read More...
|
-
We finally have the registration website for the community event about Tabular in Analysis Services in Amsterdam on April 16 evening that I introduced in my previous post - don't miss it, the registration are open (and limited!) at: http://passnl-april2012.eventbrite.com/ Read More...
|
-
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 arrange some speeches Read More...
|
-
If you have a Slowly Changing Dimension (SCD) Type 2 for your customer and you want to calculate the number of distinct customers that bought a product, you cannot use the simple formula: Customers := DISTINCTCOUNT( FactTable[Customer Id] ) ) because Read More...
|
-
I, Alberto and Chris spent many months (many nights, holidays and also working days of the last months) writing the book we would have liked to read when we started working with Analysis Services Tabular. A book that explains how to use Tabular, how to Read More...
|
|
|
|
|