Sessions & Content

Search
Content Type
Conference
Tags
Build your next BI solution in Azure Alexander Klein
Azure offers a wide range of services that can be combined into a BI solution in the cloud.
Deeper Integration and New Transformation for SSIS in ADF Sandy Winarko
This session focuses on the deeper integration of SQL Server Integration Services (SSIS) in Azure Data Factory (ADF) and the broad extensibility of Azure-SSIS Integration Runtime (IR).
Design patterns for metadata-first ETL process control Richard Swinbank
In this session we'll look at ETL metadata, use it to drive process execution, and see benefits quickly emerge. I'll show how a metadata-first approach reduces complexity, enhances resilience and allows ETL processing to become self-organising.
The video is not available to view online.
ETL with Azure Databricks, The Complete Introduction Andre Kamman
We’ll take a look at how to approach making an Azure Databricks based ETL solution from start to finish. Along the way it will become clear how Azure Databricks works and we will use our SSIS knowledge to see if it can handle common use-cases
The video is not available to view online.
Inside SQL Server 2019 Polybase Bob Ward
SQL Server 2019 expands on the Polybase feature from SQL Server 2019 by providing a robust data virtualization solution to reduce the need for ETL and data movement. Come learn how new data connectors work with sources like Oracle, MongoDB, CosmosDB, Terradata, and HDFS.
Patterns and Best Practices in SSIS Richard Munn
Getting better performance from your ETL
The video is not available to view online.
Profiling Your Data Angela Henry
What data profiling is & why you should do it.
Some transformations that can save your ETL in Power BI Ana Maria Bisbe York
To build analytical models, we need to start by extracting, transforming, cleaning, preparing and loading the data. This session analyzes a set of scenarios that may happen during the ETL step using the Power Query in Power BI.
The Self-Tuning SSIS Package Ben Weissman (he/him)
This session is about using the Business Intelligence Markup Language (Biml) to monitor and control your orchestration patterns. By automatically analyzing the results in ETL logs, we’ll be able to automate our staging orchestration!
Using Change Tracking to build a Live Data Warehouse Andrea Besozzi
How to build a Live Data Warehouse using Change Tracking capabilities
Deep Dive into SSIS 2017 and Beyond Jimmy Wong
We will showcase the latest feature of SSIS 2017 such as connectors for Azure Data Lake Store (ADLS), Azure SQL Data Warehouse (SQL DW), SSIS Scale-Out at package level for the box product as well as the SSIS package execution on Azure Data Factory
Solving ETL bottlenecks with SSIS Scale Out Steph Martin
Do you have large-scale SSIS platforms which experience bottlenecks due to the number of packages or volumes of data that need to be processed? Yes! Then you need to explore SSIS scale out.
Deep Dive into SSIDB Catalog Prathy Kamasani
A session to understand the available functionality of SSISDB Catalog
Get Near Realtime ETL with Service Broker Allen White
Using SQL Server Service Broker you can create near real-time data in your data warehouse for more timely analysis and reporting.
Automate Your ETL with SSIS and PowerShell Allen White
ETL Development takes time. Allen will show how PowerShell and BIML combine to make the development process seamless, consistent and reduces costly development time dramatically.
The video is not available to view online.
Azure Data Factory vs SSIS Reza Rad
Azure Data Factory and SSIS are both data movement tools, but built for different purposes. In this session you will learn pros and cons of using each technology, and best practices of using each in real world scenarios.
The video is not available to view online.
SQL Server 2016 Business Intelligence New Features Chris Testa-O'Neill
Do you get involved in the creation of Business Intelligence solutions within your organisation? This session will show you the new features of SQL Server 2016 Business Intelligence components.
The video is not available to view online.
Building a meta-driven near realtime ETL solution with BIML Rasmus Reinholdt Nielsen
This all demo session build around a real life case study from one of the largest organizations in the world. will take you through a case of how to build a completely meta-driven SSIS solution relaying on BIML and MDS to do the hard-work for you.
Building A Reporting Solution Using Power Query Chris Webb
See how to use Power Query to build a detail-level reporting solution
Metadata Driven Automation: A Primer James Skipwith
Need to automate a process in your database? Create audit tables, generate stored procedures, or any other type of manually repeatable process? In this session we'll look at how to start and the thought processes and design considerations involved.
<<12>>