PASS SQLRally 2011 www.sqlpass.org Twitter Facebook

Business Intelligence (BI)

The following sessions were chosen to be presented at PASS SQLRally Nordic 2012.
Scroll down to see them all: 


Selected Sessions

Title:

Zero to Cube

Speaker:

Adam Jorgensen

Abstract:

This session focuses on showing the attendees how easy it is to lower the barrier to analytics using Analysis Services. We will discuss and demonstrate the best practices for preparing your data for analysis, building a cube and consuming that cube with presentation layer components. This is all done live with full audience participation. It's an exciting and fun time for all. This session was a top 10 at two previous Summits in the US and was a pakced house at SQL Rally US and SQL Saturdays.

Level 300

 


Title: Querying and optimizing DAX
Speaker:

Alberto Ferrari 

Abstract:

In SQL 2012 DAX became a query language and, when it comes to performance, the xVelocity in-memory engine is second to none. Scanning fact tables and performing leaf-level computation happens in a matter of milliseconds. Nevertheless, as with any other language, you can write good DAX or bad DAX, depending on your understanding of the engine internals. In this session we are going to introduce DAX as a query language, showing the different ways of querying with DAX using real-world data. Some queries will be fast, others will need optimizations and a better understanding of query plans, which we will show, in order to give a complete understanding of how to get the best out of DAX.

Level 300


Title: The Best Microsoft BI Tools You’ve Never Heard Of
Speaker: Chris webb
Abstract: Think you know all about the Microsoft BI stack? Think again! This session will cover experimental and obscure Microsoft BI tools that you might not have seen before, including: - Data Explorer from SQL Azure Labs, for self-service ETL in the cloud and in Excel - NodeXL, for graph analysis in Excel - Layerscape, for visualising data on maps using Excel and Microsoft World Wide Telescope - The Excel Data Mining addin …plus how to use them alongside more mainstream tools such as PowerPivot and Analysis Services.

Level 200


Title:

Big Data Customer Solution Architectures

Speaker:

Peter Kejser

Abstract:

Big Data solutions can be as simple as the acquisition and storage of large volumes of data, or as complex as a system that processes 135 Billion+ events/month. In today's SQLCAT Big Data session, we will be reviewing customer solution architectures such as those involving Big Data to BI, Distributed Querying, Near Real Time Processing, and Event Messaging. We will also be talking about the lessons learned from working with customers on Microsoft's Big Data Solutions. 

Level 200


Title: SQL Server Parallel Data Warehouse
Speaker: Henk Van der Valk
Abstract: Understand the basic SQL PDW Massive Parallel Processing (MPP) architecture and see why spreading data and workload over multiple sql servers make sense to scale your DWH.

Level 200


Title: Excel Services and Publishing Excel sheets via SharePoint
Speaker:

Just Blindbæk

Abstract: Quick overview of publish options with focus on the “Items in the workbook” option which is especially handy when you will embed in SharePoint without it resembles Excel too much. Second item on the agenda is the integration in SharePoint with a demonstration of three possibilities: - Full page - The lazy solution - PerformancePoint Services Dashboard - The smart solution - WebPart page - The customizable solution Last but not least the session will include “Tips & Tricks” including how to remove the Excel look. How to control the layout with “Named Items” and the "Name Manager" and how you can burst the limits from PivotTables with the of use "Cube Functions" and "Names Sets".

Level 300


Title: xVelocity under the hood 
Speaker: Marco Russo
Abstract: You run a DAX query, you get the result amazingly fast. But how did this happen? How does the xVelocity in-memory engine works, under the hood, to run queries so fast? In this session we will analyze the internals of the xVelocity engine, understanding the roles of Formula Engine and Storage Engine, how they interact and how queries are executed, with a particular interest on filter context and how it propagates through relationships. This knowledge can be important to understand how to get the best from the xVelocity engine by using the proper data model and DAX expressions.

Level 400


Title:

ETL Frameworks with Dynamic SSIS Packages

Speaker:

Niko Neugebauer

Abstract:

In the ideal world, all information and structures are static, but in the real world almost everything is dynamic, and so many tables are affected by the changes of multiple applications and developers. If you have just a couple of objects to take care off, then it is all fine and easy to handle, but if you are working with 100's or 1000's of tables, will you try to edit all your SSIS packages manually? Join me to discover some ways to develop some simple ETL frameworks which can help handling some real world challenges, and learn how you can do some simple running without that much work. The only existing constant in the nature is the change, so we better be ready to face it.

Level 300


Title:

Power View: A Peek Behind the Curtain

Speaker: Stacia misneR
Abstract: Power View is the new data visualization and self-service BI tool that will debut in SQL Server 2012. To successfully roll-out this technology to your user community, you need to understand its architecture and data dependencies. Come to this session to get past the razzle dazzle that most Power View sessions offer, and peek behind the curtain to learn how to properly configure your environment to support Power View and how to prepare data for user consumption within Power View.

Level 100

 


Title: A dive into Data Quality Services
Speaker: Steve Simon
Abstract: Data quality and data cleansing have always been major challenges to any enterprise that deals with data. For those of us who have dealt with Data Profiler Tasks in SQL Server 2008, we were shocked yet pleasantly surprised with the great advances that Microsoft has made with the advent of Data Quality Services, in the SQL Server 2012 release. In this hands-on presentation we shall be looking at how to set up a new knowledge base, based upon an existing one, set up rules, do knowledge discovery within the new knowledge base and finally cleanse the data through a data quality project. The end results being more effective data, guaranteed to keep end users and management happy.

Level 200
 


PRIMARY  SPONSOR


ENTERPRISE  SPONSOR
 

   
 
 
 
 
 
 
 

STANDARD