Sessions & Content

Search
Content Type
Conference
Tags
Biml Tips and Tricks: Not just for SSIS packages! Cathrine Wilhelmsen
Biml is not just for generating SSIS packages! Come and see how you can use Biml to save time and speed up other Data Warehouse development tasks like T-SQL development, test data creation, and dimension population.
Disposable Dev environments with Azure DevOps and AzureRM Gavin Campbell
Using Azure DevOps and Azure RM templates to created isolated environments for testing PaaS solutions.
Learn how to build a real-time analytics solution José Mendes
In this session we will learn which processes are required to build a real-time analytical model along with batch-based workloads, which are the foundation of a Lambda architecture.
Profiling Your Data Angela Henry
What data profiling is & why you should do it.
Using Change Tracking to build a Live Data Warehouse Andrea Besozzi
How to build a Live Data Warehouse using Change Tracking capabilities
Azure SQL Data Warehouse Optimizing and Maintaining Robin Lester
In this talk we will discuss best practices around how to design and maintain an Azure SQL Data Warehouse for best throughput and query performance.
What is the Azure SQL Datawarehouse? Vitor Fava
In this session we will discuss about the Azure SQLDW and how we can use it to help on our day to day.
Advanced Topics for Azure SQL Data Warehouse James Rowland-Jones
This session covers the more advanced aspects of development for Azure SQL Data Warehouse. Areas such as data movement, workload concurrency and resource management will all be covered during this intense 60 minute session.
The video is not available to view online.
Continuous Integration and the Data Warehouse Dr John Tunnicliffe
Continuous Integration is not normally associated with data warehouse projects due to the perceived complexity of implementation. John will be showing how modern tools make it simple to apply Continuous Integration techniques to data warehouse projects
The video is not available to view online.
Essential Architecture for Bi in a Virtual Environment Joey D'Antoni
Virtualization has had a major impact on computing. While data professionals have adjusted to this for database servers, many BI workloads have moved there as well. Learn about the impact of virtualization on BI.
The video is not available to view online.
The Modern Intelligent Application Lara Rubbelke
This session will examine how to successfully design a modern data architecture on the Microsoft Azure cloud platform. Focusing on design tenants for efficient, scalable and resilient data processing
The video is not available to view online.
Warehouse of the Future: Lakes Vs Marts Simon Whiteley
Data Warehouses are changing. This session will run through the architecture of the modern warehouse, from structured/unstructured Azure Data Lakes to platform as a service Azure Data Warehouse and bringing the two together.
The video is not available to view online.
Advanced Modeling with Analysis Services Tabular Alberto Ferrari
This session goes beyond the classical star schema modeling, exploring new techniques to model data with Power Pivot and SSAS Tabular. You will see how brute-force power in DAX allows different data models than those used in SSAS Multidimensional
T4 Templating within SSDT using SQL Server 2014 Geoff Clark
T4 templating will be a first class citizen in SSDT for SQL Server 2014. This session will show why you should use this technology for SQL code generation and how you can automate the process. The session will be demo rich.
Inside xVelocity InMemory Engine (VertiPaq) Alberto Ferrari
A deep dive in the internals of the database architecture, discovering how Vertipaq stores information, in order to gain better insights into the engine and understand the best way to model your data warehouse to leverage the features of VertiPaq.
The video is not available to view online.
A Deep Dive in SQL Server 2012 Data Warehousing Dejan Sarka
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.
Building an infrastructure to support real-time OLAP Dr John Tunnicliffe
Users love flexible analytics but hate to wait for the data to be loaded into a traditional data warehouse. John will describe how to build an infrastructure to support real-time loading of your OLAP cubes so your user's get exactly what they want
Loading Data Warehouse Dimensions in SSIS Alex Whittles
This session looks at some of the different methods available to load slowly changing dimension data into a data warehouse, and compares the relative performance given different data scenarios and traditional storage compared with FusionIO
Temporal Snapshot Fact Table Davide Mauri
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.
Deep Dive - HP EDW, Massive Scale, Low Cost Steve Tramack
Organizations risk being overwhelmed by data. How can you effectively provide a “single version of the truth”, while unlocking the key trends and insights that will allow your business to succeed? Come to this session to find out how.
Handling Advanced Data Warehouse Scenarios in SSIS John Welch
Do you have complex dimensions in your data warehouse? Parent-child, late arriving, type 3 or type 6? In this session, we'll cover some SSIS patterns for handling each of these, along with tips for making them perform well.
Implementing Real-Time Data Warehouse Sutha Thiru
Steps involved in implementing a near-real-time data warehousing solution.
Master Data Services in SQL Server Denali Jeremy Kashel
Master Data Services has been given an overhaul in Denali, including a new Excel add-in and modified web front-end. Come to this session to see how MDS can be used to give greater control and process to your BI/DW dimension management.
The Art of War-Fast Track Data Warehouse & Fragmentation James Rowland-Jones
When loading a Fast Track Data Warehouse it is important to ensure that your data is optimally laid out for Sequential I/O. Fragmentation is therefore the enemy. Know your enemy. Learn what it is, how it occurs and prevent it from happening to you!
Vertipaq vs OLAP: Change Your Data Modeling Approach Marco Russo
In this session we will introduce the new modeling capabilities of Vertipaq, showing how the same scenarios can be modeled in both Multidimensional (MOLAP) and Tabular (Vertipaq), looking at how to enable your data warehouse to support both.
Advanced Dimensional Modelling Vincent Rainardi
Many of us know what dimensions and fact tables are. But dimensional modelling is more than just dimensions and fact tables. This session is about advanced dimensional modelling topics, which are useful for anybody involved in the design of a DW.
Data Vault, An introduction to the new datawarehouse supermodel Martijn Evers
A new and fresh approach to datwarehousing that is agile, performant and easy to do. Data Vault is a new methodology that tries to overcome traditional problems that plagued traditional datawarehousing in the past.
Relational Modeling for Extreme DW scale Thomas Kejser
This session is taken from lessons learned in the field on being able to scale data models to handle multi-terabytes of data. Come to this session and understand the difficulties before you encounter them.
Building cubes from ODS or Operational Systems Vincent Rainardi
A step-by-step demo on BIDS of how to build an SSAS cube (DB) from an operational system (normalized database) such as Operational Data Store (ODS) or directly from the transactional business system, without building a star/snowflake schema Data Warehouse/Mart first.
Data warehousing features in SQL 2008 James Rowland-Jones
Data warehousing features in SQL 2008
Designing I/O systems for SQL Server Thomas Kejser
In this session we will take a deeper look at how SQL Server uses I/O and how you can design the I/O system to meet the requirements of your applications.
Introducing Project Madison Thomas Kejser
In this presentation, I will introduce the Madison architecture and provide a roadmap with major milestones for this product
Data Warehouse Data Modelling Vincent Rainardi
Designing dimensional and fact tables using a case study to understand data modelling
The video is not available to view online.
<<1>>