Browse by Tags

• Analysis Services
• BIDS
• Book
• Business Intelligence
• Communities
• Conference
• Conference Communities
• CTP3
• DAX
• Denali
• Excel
• M2M
• MDX
• PASS
• PowePivot
• Power View
• PowerPivot
• Reporting Services
• SQL Server 2012
• SSAS
• Tabular
• TechEd
• UDM

• Basket Analysis with #dax in #powerpivot and #ssas #tabular

  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... Posted Thursday, June 12, 2014 10:25 AM by Marco Russo (SQLBI) | 0 Comments Filed under: SSAS, Analysis Services, PowerPivot, DAX, BISM, Tabular

• Performance Tuning of #tabular models in Analysis Services 2012 #ssas

  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... Posted Monday, August 05, 2013 3:37 PM by Marco Russo (SQLBI) | 0 Comments Filed under: SSAS, Analysis Services, PowerPivot, BISM, Tabular

• Campaign for #PowerPivot and #Tabular textual modeling language #msbi #ssas

  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... Posted Tuesday, June 04, 2013 1:14 AM by Marco Russo (SQLBI) | 4 Comments Filed under: SSAS, Analysis Services, PowerPivot, BISM, Tabular

• Workshop and Events in Europe next month #ssas #tabular #powerpivot

  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... Posted Thursday, February 21, 2013 11:41 AM by Marco Russo (SQLBI) | 0 Comments Filed under: Analysis Services, BISM, Tabular

• SQLBits XI in May 2013 – many reasons to attend! #sqlbits #dax #tabular

  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... Posted Wednesday, February 20, 2013 11:33 AM by Marco Russo (SQLBI) | 0 Comments Filed under: Conference Communities, Conference, Communities, Analysis Services, DAX, BISM, Tabular

• xVelocity engines compared: VertiPaq vs ColumnStore #ssas #vertipaq #xvelocity #sql #tabular

  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... Posted Wednesday, August 22, 2012 2:56 PM by Marco Russo (SQLBI) | 4 Comments Filed under: SSAS, Analysis Services, BISM, Tabular

• Finally in stock: Microsoft SQL Server 2012 Analysis Services: The BISM Tabular Model #ssas #tabular

  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... Posted Thursday, July 26, 2012 1:32 PM by Marco Russo (SQLBI) | 6 Comments Filed under: SSAS, Book, BISM, Tabular

• Watch @marcorus and @ferrarialberto sessions online #teched #msteched #tee2012

  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... Posted Saturday, July 07, 2012 8:41 AM by Marco Russo (SQLBI) | 0 Comments Filed under: Analysis Services, BISM, Tabular, TechEd

• Optimize Many-to-Many with SUMMARIZE and Other Techniques

  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... Posted Friday, June 01, 2012 3:12 PM by Marco Russo (SQLBI) | 0 Comments Filed under: M2M, Analysis Services, PowePivot, BISM, Tabular

• Order of Evaluation in CALCULATE and Clever Hierarchy Handling in #dax

  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... Posted Wednesday, May 02, 2012 7:36 AM by Marco Russo (SQLBI) | 0 Comments Filed under: DAX, BISM, Tabular

• Last minute update #ssas #tabular community event in Amsterdam on April 16

  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... Posted Saturday, April 14, 2012 2:45 AM by Marco Russo (SQLBI) | 0 Comments Filed under: SSAS, Analysis Services, BISM, Tabular

• #SSAS #Tabular Workshop and Community Events in Netherlands and Denmark

  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... Posted Thursday, April 12, 2012 2:04 PM by Marco Russo (SQLBI) | 1 Comments Filed under: Communities, Analysis Services, BISM, Tabular

• Distinct Count of Customers in a SCD Type 2 in #DAX

  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... Posted Monday, April 09, 2012 11:55 PM by Marco Russo (SQLBI) | 3 Comments Filed under: Analysis Services, DAX, BISM, Tabular

• Microsoft SQL Server 2012 Analysis Services – The BISM Tabular Model #ssas #tabular #bism

  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... Posted Wednesday, March 28, 2012 11:26 AM by Marco Russo (SQLBI) | 0 Comments Filed under: Analysis Services, Book, BISM, Tabular

• Investigating on xVelocity (VertiPaq) column size

  In January I published an article about how to optimize high cardinality columns in VertiPaq . In the meantime, VertiPaq has been rebranded to xVelocity: the official name is now “xVelocity in-memory analytics engine (VertiPaq)” but using xVelocity Read More... Posted Monday, March 19, 2012 2:15 PM by Marco Russo (SQLBI) | 2 Comments Filed under: BISM, Tabular