Browse by Tags

• Analysis Services
• BIDS
• BISM
• Book
• Business Intelligence
• Communities
• Conference
• Conference Communities
• DAX
• Excel
• Excel 2013
• M2M
• MDX
• Methodology
• PASS
• PowePivot
• Power View
• PowerPivot
• SSAS
• TechEd

• 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

• Group Sales by Age of Customers #dax #powerpivot #tabular

  I published an article describing how to implement the grouping of sales transactions by age of customer at the moment of the transaction by using PowerPivot or Analysis Services. The same pattern can be used also for any kind of banding operation, this Read More... Posted Monday, May 06, 2013 3:16 PM by Marco Russo (SQLBI) | 0 Comments Filed under: PowerPivot, DAX, Tabular

• DAX Studio for Excel 2013 finally available! #dax #excel #powerpivot #ssas #tabular

  I'm so happy that DAX Studio finally supports Excel 2013! As Darren Gosbell described in his blog , this release has a few internal changes that will better support future enhancements. I will port the code to capture the query plan for a query in this Read More... Posted Saturday, May 04, 2013 8:49 AM by Marco Russo (SQLBI) | 2 Comments Filed under: SSAS, Excel, PowerPivot, DAX, Tabular, Excel 2013

• 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

• LASTNONBLANK and FIRSTNONBLANK functions work with any column #dax #powerpivot #ssas #tabular

  During a PowerPivot Workshop course we received an interesting question from a student: “Can I use LASTNONBLANK (and FIRSTNONBLANK) with a column which is not a date column?” The reason is that we introduce LASTNONBLANK in the Advanced Time Intelligence Read More... Posted Friday, April 19, 2013 1:28 PM by Marco Russo (SQLBI) | 0 Comments Filed under: SSAS, Excel, PowerPivot, DAX, Tabular

• SQLLunch on April 23 in London and Cardiff #sqlpass #dax #sqllunch

  On April 23 I will present DAX in Action in London and Cardiff at SQLLunch event. How is it possible I will be in two places at the same time? This will be a remote presentation delivered in two locations, where you can have lunch while watching the session. Read More... Posted Monday, April 15, 2013 11:52 AM by Marco Russo (SQLBI) | 0 Comments Filed under: Communities, MDX, DAX, Tabular

• Optimize memory in #powerpivot and #ssas #tabular

  Microsoft published an interesting article about how to optimize memory consumption of a PowerPivot Data Model in Excel 2013 . All these suggestions are also valid for SSAS Tabular. I also wrote an article Checklist for Memory Optimizations in PowerPivot Read More... Posted Wednesday, April 03, 2013 1:55 PM by Marco Russo (SQLBI) | 1 Comments Filed under: SSAS, PowerPivot, 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

• Cost of Process Defrag in Analysis Services Tabular #ssas #tabular

  I recently received a question about the memory required to run a Process Defrag on a Tabular model in Analysis Services. The Process Defrag is useful when you run incremental processing of a table frequently, or when some of the values in the dictionary Read More... Posted Wednesday, March 13, 2013 3:17 PM by Marco Russo (SQLBI) | 0 Comments Filed under: Analysis Services, 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

• 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

• DAX Time Intelligence for 4-4-5 Calendar, ISO Calendar and other custom ones #dax #powerpivot

  DAX offers a set of Time Intelligence functions that simplify writing DAX expressions such as YTD, YOY and other time-related calculations. However, these functions only works when some assumptions are valid: your periods should be “natural” months and Read More... Posted Tuesday, February 19, 2013 4:21 PM by Marco Russo (SQLBI) | 5 Comments Filed under: Analysis Services, PowerPivot, DAX, Tabular

• Hardware Sizing Guide for #ssas #tabular

  A common question I receive is about how to correctly size a server for an Analysis Services Tabular instance. I always answer that an analytical evaluation is partly an empiric process, because there are many variables involved and the simplest approach Read More... Posted Tuesday, February 12, 2013 4:10 PM by Marco Russo (SQLBI) | 0 Comments Filed under: Analysis Services, Tabular

• First spring conference: PASS Business Analytics Conference and SQL Bits #passbac #sqlbits #sqlpass

  Spring is a conferences’ season and the upcoming one is no exception. I will be speaking at PASS Business Analytics Conference 2013, which will be the first event this year, so I’d like to spend a few words about my sessions. PASS Business Analytics Conference Read More... Posted Friday, February 08, 2013 5:50 PM by Marco Russo (SQLBI) | 3 Comments Filed under: Business Intelligence, Conference Communities, Conference, SSAS, Analysis Services, Methodology, Tabular