Business Intelligence Senior Consultant
Areas of Expertise:
- PowerPivot
- Analysis Services
- SQL Server
- MDX
- Integration Services
- SSIS
- SSAS
- LINQ
- C#
- .NET Framework
- consulting
- speaking
- programming
- training
|
|
|
|
|
|
Marco blogs at:
http://sqlblog.com/blogs/marco_russo/
Memory Settings in #Tabular #ssas (and Prepare for #msteched!)
February 06 2012
We are going very close to the release of SQL Server 2012 and after using Analysis Services 2012 for almost one year in a relatively small number of scenarios, I’m really curios to see the questions and the issues that will emerge when its adoption will go mainstream. I expect… read moreOptimize Table and Column Size in #PowerPivot and #BISM #Tabular #SSAS #VertiPaq
January 26 2012
When you create a PowerPivot workbook or a BISM Tabular model (new in Analysis Services 2012), you store data by using the VertiPaq engine, which is an in-memory columnar database. Instead of considering the row of a table as the main unit of storage, it considers every column as a… read moreFree online session at PASS DW/BI Virtual Chapter #sqlpass – Wed Jan 18th, 2012
January 16 2012
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 of many to many dimension relationships in SSAS (since… read moreUsing SQL to query Multidimensional and Tabular models #dax #sql #mdx #ssas
January 12 2012
Analysis Services answers to query in MDX, in DAX (by now just for Tabular models) and has a limited capability to answer SQL queries. It is not useful for any development or client tool, but I wanted to write a blog post on it in order to be able to… read moreFact Tables with Different Granularities in #PowerPivot and #BISM #Tabular
January 11 2012
A few weeks ago I received a question that inspired me in writing this article about how to handle data at different granularities in PowerPivot and BISM Tabular. I think this is a common pattern when you have a budget table that contains data at an aggregated level (like month… read morePre-Conference Seminar at #TechEdEurope: #ssas #bism #tabular
January 10 2012
The Microsoft TechEd Europe 2012 will be in Amsterdam this year on June 26-29. The day before (25 June 2012) there are several pre-conference seminars and I’m glad to announce that I and Alberto Ferrari will deliver this one: Using BISM Tabular in Microsoft SQL Server Analysis Services 2012 […]… read moreFree online session at PASS DW/BI Virtual Chapter #sqlpass – Tues Jan 10th, 2012
January 09 2012
Tomorrow January 10th, 2012 at 3pm Eastern Time (which is 8pm GMT) I will deliver a free online session for the PASS DW/BI Virtual Chapter . This is the official description of the session. Vertipaq vs OLAP: Change Your Data Modeling Approach While in classical OLAP cubes the clear winner… read moreUse parameters in your #DAX queries
January 05 2012
The DAX query syntax allows you to insert a parameter by using the @ symbol. EVALUATE CALCULATETABLE ( 'Product Subcategory' , 'Product Category' [Product Category Name] = @Category ) Depending on the client and on the driver you are using to execute your DAX query, this syntax may… read moreAnalyze #DAX query plan with Profiler
January 01 2012
Jeffrey Wang started the 2012 (or finished the 2011, depending on your time zone) by publishing the first article dedicated to DAX Query plan . While I look forward to reading next articles, it is interesting the explanation of what is the relationship between MDX and DAX in Analysis Services… read moreDecember 30 2011
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 moreDecember 29 2011
I wrote a short article about query projection in DAX. To make the story short, you should always use SUMMARIZE in order to remove columns from a table in a query. Thus, if you just want three columns from a table, instead of writing this in SQL: SELECT Col1, Col2,… read moreRatio Calculation Differences between #MDX and #DAX in #BISM #Tabular
December 27 2011
You should have already read that DAX is simpler than MDX. It’s true, and sometime you have to pay a price for simplicity. I am used to say that DAX is somewhere between SQL and MDX. In fact, SQL requires you to put any relationship in the query (using JOIN… read moreBest session in BI Platform Track at PASS Summit 2011 #sqlpass
December 19 2011
Last week the final session evaluations from PASS Summit 2011 have been communicated to speakers and best scores have been made public. My session was not particularly good: it had very good feedback (overall average 4.32) and some average one, mostly because the title (Vertipaq vs OLAP: Change Your Data… read moreVote desired sessions at #SQLBits 10
December 12 2011
Just a breaking news: you can vote the sessions you'd like to attend at the next SQLbits in London! I already did my job and I have to say that it's very hard to use your 10 sesssions - there are too many sessions that I'd like to watch!...(read more) read moreSorting Dates Columns in #PowerPivot and #BISM #Tabular
December 08 2011
I just published an article about Sorting Dates Columns in PowerPivot v2 and BISM Tabular on SQLBI website. In reality, the article is about sorting columns by other columns in a Tabular model, but the common scenario in which you need that is in a Calendar table where you can… read morePublish Your Data on Windows Azure MarketPlace
December 07 2011
If you missed this, it is finally possible to publish your data on Windows Azure Marketplace . The name DataMarket is no longer present here also because the marketplace also include applications and not only data, but the news introduced by the last service update is that you can finally… read more#SQLBits video (of my session) finally available
December 05 2011
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. Last week we also submitted some proposals for SQLBits 10… read moreAlso find Marco on:
Recent Twitter posts:
Buy Now and Save
Use discount code: OPC10
All orders over $29.95 qualify for free shipping within the US. See details.
