Platinum Sponsor

Content

Speakers

Travel & Accommodation

SQLBits X UK SQL Server 2012 Technical Launch

SQLBits 9 Query across the mersey

SQLBits 8 Beside the seaside

SQLBits 7 Wonders of SQL

SQLBits The 6th Sets (VI)

SQLBits Goes West (V)

SQLBits goes Forth (IV)

Premium Sponsor

Gold Sponsors

Silver Sponsors

Bronze Sponsors

It appears that your browser does not support JavaScript, or you have it disabled. This site is best viewed with JavaScript enabled. If JavaScript is disabled in your browser, please turn it back on then reload this page. If your browser does not support JavaScript, click here for a page that doesn't require javascript.

Marco Russo

Marco Russo is a consultant and trainer in Business Intelligence and software development, recently certified as SSAS Maestro. He has particular competence and experience of BI solutions in sectors like financial services (including complex OLAP designs in banking area), manufacturing and commercial distribution. Marco wrote "The many-to-many revolution" about multidimensional modeling, is one of the authors of the SQLBI Methodology and of the books "Microsoft SQL Server 2012 Analysis Services: The BISM Tabular Model", "Microsoft PowerPivot for Excel 2010: Give Your Data Meaning", Expert Cube Development with Microsoft SQL Server 2008 Analysis Services" and "Programming Microsoft LINQ in .NET 4". He has been a speaker at previously editions of SQLBits, SQLRally Nordic, PASS Summit and Microsoft TechEd.

Analysis Services Advanced Best Practices Slide deck available

This dense hour of presentation will cover design techniques to leverage cube features that also consider possible maintenance of the database structure over time.

BISM Introduction Slide deck available

Introduce the features of BISM (BI Semantic Model), the new engine that will be available in Analysis Services "Denali".

Vertipaq vs OLAP: Change Your Data Modeling Approach Slide deck available

In this session we will introduce the new modeling capabilities of Vertipaq, showing how the same scenarios can be modeled in both Multidimensional (MOLAP) and Tabular (Vertipaq), looking at how to enable your data warehouse to support both.

Create a Data Model in BISM Tabular Slide deck available

In this session you will see how to create a BISM Tabular data model from scratch, providing the required metadata in order to improve user experience navigating the data model by using client tools like Excel PivotTable and Power View.

Modern Data Warehousing Strategy Samples available

This session will discuss what a modern strategy for data warehousing can be in this era, considering how the use of technologies like PowerPivot or Analysis Services Tabular affect the way you should model your data.

Blog posts

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

03 Jun 2013

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 simplest way to improve the Productivity of ...

Not selected as a speaker at PASS Summit 2013 #sqlpass #sqlfamily

22 May 2013

I received the communication from the PASS Program Committee that none of my proposals have been accepted at PASS Summit 2013. Probably this year there was too many proposals and I made a mistake not using all the possible proposals available per speaker. In fact, I just proposed one pre-conference ...

How Far Can You Push Tabular? Birds of a Feather at TechEd 2013–North America #msteched #ssas #tabular

20 May 2013

I and Alberto Ferrari will moderate the following Birds of a Feather session at TechEd North America 2013: CODE: BOF-ITP21 TITLE: How Far Can You Push Tabular? SPEAKER: A. Ferrari; M. Russo TIMESLOT: June 5, 2013 at 1:30 pm ROOM: 263 Abstract: Tabular is the new engine in SQL Server ...

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

07 May 2013

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 you that missed one of ...

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

06 May 2013

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 specific case is useful also to recycle the ...