Browse by Tags

• Analysis Services
• BIDS
• BISM
• Book
• Business Intelligence
• Communities
• Conference
• CTP3
• DAX
• Denali
• Excel
• M2M
• MDX
• PASS
• Power View
• PowerPivot
• SSAS
• Tabular
• UDM

• From 0 to DAX at TechEd Pre-Conference Seminar #dax #msteched #tee13

  In June I and Alberto will deliver a pre-conference seminar at both TechEd North America (New Orleans, LA) and TechEd Europe (Madrid, Spain). This day is a very good quickstart for those of you that still didn't complete one of our books , or those of Read More... Posted Tuesday, May 07, 2013 3:54 PM by Marco Russo (SQLBI) | 0 Comments Filed under: SSAS, DAX, PowePivot, Tabular

• Advanced DAX course in May - unique date in 1H 2013 #dax #tabular #ssas #powerpivot

  One year after the release of SQL Server 2012 I see the growing demand for DAX. There are two reasons for that: an higher number of PowerPivot users started to build more complex data models, and SSAS Tabular is starting to be adopted by a larger number Read More... Posted Monday, April 22, 2013 11:55 AM by Marco Russo (SQLBI) | 3 Comments Filed under: SSAS, Analysis Services, DAX, PowePivot, Tabular

• Interviewed in SQL Down Under podcast #sqlserver #ssas #powerpivot

  I’ve been interviewed by Greg Low in SQL Down Under show 58, and this is *not* an April fool! We talked for one hour about Tabular, Multidimensional, Data Warehouse and just a little bit about music (you can discover which music genre I’m used to listen…). Read More... Posted Monday, April 01, 2013 9:03 PM by Marco Russo (SQLBI) | 0 Comments Filed under: Communities, SSAS, Analysis Services, PowePivot, Tabular

• Querying with DAX video available on Project Botticelli #dax #ssas #powerpivot

  I recently published a video session on Project Botticelli web site regarding querying in DAX. You can write DAX queries to extract data from both PowerPivot and SSAS Tabular models. This could be particularly useful in three scenarios: Reports in Reporting Read More... Posted Monday, February 25, 2013 3:39 PM by Marco Russo (SQLBI) | 0 Comments Filed under: DAX, PowePivot, Tabular

• End of 2012 and news in 2013 for #PowerPivot, #ssas #tabular and BI

  This year is going to end, Maya failed their predictions and while this is bad for predictive industry, it’s also good for all of us! We’ve seen many news in Microsoft BI stack: Excel 2013 has been RTM’d – its General Availability is expected in early Read More... Posted Thursday, December 27, 2012 8:26 PM by Marco Russo (SQLBI) | 2 Comments Filed under: SSAS, Analysis Services, DAX, PowePivot, Power View, Tabular

• DATE function does not support all the dates in DAX by design #powerpivot #tabular #dax

  The DATE function in DAX has this simple syntax: DATE( <year>, <month>, <day> ) If you are like me, you never read the BOL notes that says in a clear way that it supports dates beginning with March 1, 1900. In fact, I was wrongly assuming Read More... Posted Monday, November 05, 2012 2:52 PM by Marco Russo (SQLBI) | 2 Comments Filed under: Excel, DAX, PowePivot, Tabular

• CUBEMEMBER and CUBEVALUE stop working after #PowerPivot upgrade to #Excel 2013

  I found an issue upgrading an Excel workbook containing PowerPivot data from Excel 2010 to Excel 2013. All CUBEMEMBER and CUBEVALUE functions point to a cube name that has been changed between the two version – you have to no longer reference the PowerPivot Read More... Posted Wednesday, October 31, 2012 11:38 AM by Marco Russo (SQLBI) | 0 Comments Filed under: Excel, PowePivot

• A proposal for #DAX Code Formatting #ssas #powerpivot #tabular

  I recently published a set of rules for DAX code formatting . The following is an example of what I obtain: CALCULATE ( SUMX ( Orders, Orders[Amount] ), FILTER ( ALL ( Customers ), CALCULATE ( COUNTROWS ( Sales ), ALL ( Calendar[Date] ) ) > 42 + 8 Read More... Posted Monday, October 22, 2012 3:10 PM by Marco Russo (SQLBI) | 0 Comments Filed under: SSAS, DAX, PowePivot, Tabular

• Optimize SUMMARIZE with ADDCOLUMNS in Dax #ssas #tabular #dax #powerpivot

  If you started using DAX as a query language, you might have encountered some performance issues by using SUMMARIZE. The problem is related to the calculation you put in the SUMMARIZE, by adding what are called extension columns , which compute their Read More... Posted Tuesday, September 04, 2012 11:23 AM by Marco Russo (SQLBI) | 0 Comments Filed under: Analysis Services, DAX, PowePivot, Tabular

• New videos available #dax #ssas #powerpivot

  The collaboration I and Alberto started with Project Botticelli is starting producing content. At this point we have three videos available: DAX in Action shows the power of DAX in PowerPivot solving common patterns not so easy or fast to solve in other Read More... Posted Friday, August 24, 2012 4:21 PM by Marco Russo (SQLBI) | 1 Comments Filed under: Analysis Services, DAX, PowePivot

• DAX Studio 1.0 beta available #dax #tabular #powerpivot

  Are you waiting for a usable and interactive DAX editor? Are you tired of using the MDX editor provided by SSMS as a temporary solution to write and execute a DAX query? The wait is over! DAX Studio is a free Excel add-in that enables you to write a DAX Read More... Posted Monday, July 30, 2012 11:10 AM by Marco Russo (SQLBI) | 1 Comments Filed under: Analysis Services, DAX, PowePivot, Tabular

• Analysis Services Tabular books #ssas #tabular

  Many people are looking for books about Analysis Services Tabular. Today there are two books available and they complement each other: Microsoft SQL Server 2012 Analysis Services: The BISM Tabular Model by Marco Russo, Alberto Ferrari and Chris Webb Applied Read More... Posted Monday, July 09, 2012 3:10 PM by Marco Russo (SQLBI) | 3 Comments Filed under: Analysis Services, Book, PowePivot, Power View, Tabular

• 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

• A new SQL, a new Analysis Services, a new Workshop! #ssas #sql2012

  One week ago Microsoft SQL Server 2012 finally debuted with a virtual launch event and you can find many intro sessions there (20 minutes each). There is a lot of new content available if you want to learn more about SQL 2012 and in this blog post I’d Read More... Posted Wednesday, March 14, 2012 9:03 PM by Marco Russo (SQLBI) | 2 Comments Filed under: SSAS, PowePivot, BISM, Tabular

• String Comparison in #DAX

  In DAX you don’t have the LIKE operator and you have to use SEARCH instead. However, performance are not very good and it is better to use LEFT and RIGHT if you just need to compare the initial (or ending) match of a string. I just wrote an article about Read More... Posted Friday, December 30, 2011 11:57 AM by Marco Russo (SQLBI) | 9 Comments Filed under: DAX, PowePivot, Tabular