Sessions & Content

Tags
Search
Conference
28 Weeks later - How to scale-out your MS Business Intelligence environment
The SQL Server provides much functionality that increases the scalability and flexibility of your solution by distributing data and jobs among low-priced commodity servers.
Analysis Services Advanced Best Practices
This dense hour of presentation will cover design techniques to leverage cube features that also consider possible maintenance of the database structure over time.
Automating SSAS cube documentation using SSRS, DMV and Spatial Data
This session will show how to use DMVs (data management views) to query the OLAP cube structure, and then use SSRS to create a set of interactive reports including the BUS matrix, and using spatial data to generate automated star schemas.
BISM Introduction
Introduce the features of BISM (BI Semantic Model), the new engine that will be available in Analysis Services "Denali".
Building a dynamic OLAP environment
This session will present the tools and techniques used to create OLAP cubes and supporting data marts on-the-fly from a mere set of data files and configuration metadata.
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.
How DBAs can use PowerPivot for Performance Tuning / Troubleshooting
PowerPivot can be a great troubleshooting / performance tuning tool for a dba besides just loading all the data in a database and start querying. I'll show the pro's and cons of PowerPivot while trying work with waitstats, profiler data etc.
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>>