Articles | SQLBI

VertiPaq vs ColumnStore Comparison

Alberto Ferrari

SQL 2012 gives you two different xVelocity engines, with different capabilities and different scenarios of implementation, the paper will help… Read More »

The Many-to-Many Revolution 2.0

Marco Russo + Alberto Ferrari

SQL Server Analysis Services introduced modeling many-to-many relationships between dimensions in version 2005. At a first glance, we may tend… Read More »

SQLBI Methodology

Marco Russo + Alberto Ferrari

The SQLBI Methodology defines architecture and implementation of advanced BI solutions using Microsoft SQL Server, SQL Server Analysis Services and… Read More »

Recent Articles

May 24, 2013

Organizing Measures and Attributes in Folders with Tabular

Marco Russo

When you create a Tabular model in Microsoft SQL Server Analysis Services (SSAS), you have to define all of the… Read More »

Apr 22, 2013

Grouping Transactions by Age of Customers in DAX

Marco Russo

Grouping transactions by customers’ age requires a computation made row by row at transaction level. DAX offers an elegant solution… Read More »

Mar 31, 2013

Checklist for Memory Optimizations in PowerPivot and Tabular Models

Marco Russo

This article contains a short checklist of what you have to do in order to optimize the memory used by… Read More »

Feb 12, 2013

Week-Based Time Intelligence in DAX

Marco Russo

The DAX language provides several Time Intelligence functions that simplify writing calculations such as year-to-date (YTD), year-over-year (YOY) and so… Read More »

Jan 29, 2013

Import Data from Tabular Model in Excel Using a DAX Query

Marco Russo

When you use Excel to connect to a Tabular database in Analysis Services, you get a PivotTable as a result.… Read More »

Jan 14, 2013

Linkback Tables in PowerPivot for Excel 2013

Marco Russo

In PowerPivot for Excel 2010 it is possible to import an Excel table in a PowerPivot data model by using… Read More »

Oct 29, 2012

Upgrading PowerPivot from Excel 2010 to Excel 2013

Marco Russo

If you have a PowerPivot workbook created with Excel 2010, in order to navigate and/or update the data model with… Read More »

All articles »

Topics

Archives by Month