Toggle navigation
FAQ
Venue & Travel
Sponsorship
Session Submission
Sessions
Login or Join
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
.
Home
Sessions & Content
Sessions & Content
Tags
SSAS
(15)
Content Type
OtherSample
15
Search
Conference
SQLBits I
0
SQLBits II
0
SQLBits III
0
SQLBits IV
1
SQLBits V
2
SQLBits VI
1
SQLBits VII
1
SQLBits VIII
3
SQLBits IX
1
SQLBits X
4
SQLBits XI
1
SQLBits XII
0
SQLBits XIV
0
SQLBits XV
1
SQLBits XVI
0
Advanced MDX Tips And Tricks
Think you know MDX? This session will show you some advanced, little-known but nonetheless practical tips and tricks for writing complex calculations and making your queries run faster.
Modern Data Warehousing Strategy
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.
A Deep Dive in SQL Server 2012 Data Warehousing
In this session, we are going to explain and test different DW features in SQL Server 2012, including star join optimization through bitmap filters, table partitioning, window functions, columnstore indices and more.
Advanced Security with Analysis Services Multidimensional
This session will cover advanced security topics in the Analysis Services Multidimensional model.
Business Intelligence with Excel 2010
Most of us use Excel in our Daily work, but are you familiar with the Business Intelligence features in Excel? In this session we'll look at some of the most common and useful BI features in Excel 2010 and discuss limitations and best practices.
Temporal Snapshot Fact Table
Snapshots without snapshots...is that possible? Take a "Classic" snapshot fact table, add some temporal data theory and you'll get a new fact table than can store snapshot data without doing snapshots. A life saver when you have a lot of data.
Many-to-Many Relationships in DAX
Deep dive into the handling of many to many relationships in DAX. How to make them work and how to optimize their speed thorugh many patterns and live examples of M2M usage.
Data Modelling for a flexible cube
Learn how to leverage the data model to create flexible behaviour in a cube without the overhead of calculated members
Fun with Scoped Assignments in MDX
This session will introduce the concept of scoped assignments in MDX and show how they can be used to solve various calculation problems.
Performance Tuning Large Analysis Services Cubes
Cube tuning is a key part of any BI project and it gets more so as cubes get bigger. Here are a series of tuning procedures to follow for cubes large and small.
1
to
10
of
15
first
1
2
last
Show
10
25
50
100
sessions per page