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

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 »

Oct 18, 2012

Rules for DAX Code Formatting

Marco Russo

With the modern editors that have automatic code formatting features, each one has its own code formatting style. Usually there… Read More »

All articles »

Topics

Archives by Month