| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 09:00:00 | Ryan Casey | BI Platform Architecture, Development Administration | Create a Data Loading Strategy |
| 09:00:00 | Shawn Weisfeld | Cloud Application Development Deployment | Intro to Azure SQL Data Warehouse |
| 09:00:00 | Kevin Feasel | Analytics and Visualization | R For the SQL Server Developer |
| 10:30:00 | Chris Hyde | Advanced Analysis Techniques | SQL Server R Services in SQL 2016 |
| 10:30:00 | Peter Myers | Advanced Analysis Techniques | Azure Machine Learning: From Design to Integration |
| 10:30:00 | Mike Walsh | Cloud Application Development Deployment | Azure SQL Databases - There's room for Azure in your BI solutions |
| 10:30:00 | David Stein | BI Platform Architecture, Development Administration | Agile Data Warehouse and ETL Design with Biml |
| 12:15:00 | Diane Schuster | BI Platform Architecture, Development Administration | Dynamic Data Flows in SSIS without Programming |
| 13:45:00 | Russel Loski | Cloud Application Development Deployment | Querying Semistructured Data in Azure Data Lake with USQL |
| 13:45:00 | Greg Galloway | BI Platform Architecture, Development Administration | Rent-a-Cube: Azure Analysis Services |
| 13:45:00 | Tim Mitchell | BI Platform Architecture, Development Administration | Deep Dive into the SSIS Catalog |
| 15:15:00 | Roberto Cavalcanti | Cloud Application Development Deployment | Azure SQL Database - Lessons learned from the trenches |
| 15:15:00 | Jonathan Stewart | BI Information Delivery | From problem to Power BI: A journey in data visualization |
| 15:15:00 | Adam Saxton | BI Platform Architecture, Development Administration | Using a gateway to leverage on-premises data in Power BI |
Event Date: 04-03-2017 - Session time: 09:00:00 - Track: BI Platform Architecture, Development Administration
Create a strategy to optimize your massive data loading processes. • High Performance Data Loading (SCD Type II and Type I using checksums) • Minimal Logging and Bulk Loading • Indexing Considerations • Delayed Durability • Eager Write
This session uses a Virtual Sandbox to demonstrate “real” data loads using these techniques listed above. We will look at the T-SQL used in these data loads. We will briefly discuss how the different settings and configurations effect the data loads. Power Point slides and sample SQL will be provided.
Event Date: 04-03-2017 - Session time: 09:00:00 - Track: Cloud Application Development Deployment
Event Date: 04-03-2017 - Session time: 09:00:00 - Track: Analytics and Visualization
Event Date: 04-03-2017 - Session time: 10:30:00 - Track: Advanced Analysis Techniques
Event Date: 04-03-2017 - Session time: 10:30:00 - Track: Advanced Analysis Techniques
In this session, you will learn how an Azure Machine Learning solution comes to life: From the creation of a workspace, to the preparation of data, to experimentation with Machine Learning algorithms, and then finally to the integration and embedding of predictive insights into applications.
This session has been specifically designed to describe Machine Learning fundamentals, and to help enable and inspire existing data professionals taking their first steps to leverage cloud-based predictive models delivered with Azure Machine Learning. It is guaranteed to thrill you with potential, and excite you with the relative ease by which it can be accomplished.
Event Date: 04-03-2017 - Session time: 10:30:00 - Track: Cloud Application Development Deployment
Not really. As a BI person you know, it's about the data. More than anything else. As a DBA and DBA consultant for 17 years, I get that too, but if you aren't pausing to look at Azure SQL Databases and how they may fit into your data management structure you're missing out. If you aren't at least looking at things like Azure Data Factory and Azure Data Warehouses you're missing out.
This session will give you a gentle and guided intro. We'll have a few slides, but mostly we'll be in the Azure Portal and SSMS (talking to Azure). We'll talk about the what and why, migrate a database, run some queries and you can laugh at my ugly Power BI reports if there's enough time to build one. But don't laugh too hard, because in 90 minutes we'll have provisioned a database, migrated to it, queried it and built a simple report...
Event Date: 04-03-2017 - Session time: 10:30:00 - Track: BI Platform Architecture, Development Administration
Event Date: 04-03-2017 - Session time: 12:15:00 - Track: BI Platform Architecture, Development Administration
The standard SSIS Data Flow Task can only use static metadata which is defined when the package is initially designed. The mapping of columns is configured and remains unchanged until the package is re-opened and design changes are made, thus costing maintenance time and effort.
Data Flow Task Plus extends the capabilities of the standard Microsoft Data Flow task in that it allows you to set up dynamic data flows, thus eliminating maintenance time and effort. Changes to tables and columns are automatically incorporated at runtime without the need to change and redeploy the package. Columns and fields are mapped automatically at runtime.
Furthermore, the initial design time and effort may be greatly reduced when dealing with huge amounts of data in a large number of files and/or databases.
Event Date: 04-03-2017 - Session time: 13:45:00 - Track: Cloud Application Development Deployment
Event Date: 04-03-2017 - Session time: 13:45:00 - Track: BI Platform Architecture, Development Administration
This demo-heavy session will deep dive into the new cloud version of Analysis Services. Walking through development, deployment, data sources, processing, authentication, and client tools like Power BI you will see how Azure Analysis Services is similar and how it is different that your father’s Analysis Services.
Event Date: 04-03-2017 - Session time: 13:45:00 - Track: BI Platform Architecture, Development Administration
In this demo-heavy presentation, we will dive into the details of the SSIS catalog. We will start with a quick survey of catalog features, followed by an exploration of the moving parts (tables, views, and stored procedures) in the catalog database. We will also review the security capabilities in the catalog, and will discuss maintenance operations. Finally, we'll walk through the mechanics of deployment and execution, reviewing what happens under the covers during these operations.
Event Date: 04-03-2017 - Session time: 15:15:00 - Track: Cloud Application Development Deployment
Event Date: 04-03-2017 - Session time: 15:15:00 - Track: BI Information Delivery
Event Date: 04-03-2017 - Session time: 15:15:00 - Track: BI Platform Architecture, Development Administration