PRE-CONFERENCE

Pre Conference, 1. maj 2017

Tivoli Congress Center,  09.00 am –  17.00 pm

 

08.00 am – 09.00 am  
Registration & breakfast

10.30 am  
Refreshment break

12.00 am 
Lunch

Tracks with deep technical training from subject matter experts from around the world.

14.30 pm        
Refreshment break

Microsoft Western Europe Blackbelt (Technical Solution Processional)

Anders Lybecker, Microsoft IoT Global Black Belt

The all-day Internet of Things workshop will teach you to connect millions of sensors, analyze the data, find insights and act upon them. You will learn to design and build large scale (100 mio+) IoT solutions with Azure. How to gain insights from even the smallest devices (RTOS, Linux, Windows, whatever) spread throughout the globe or your manufacturing line. We will walk you through:

  • Why is IoT hot now when we have connected small devices for 20+ years?
  • Walkthrough of the Azure IoT reference architecture
  • The Azure IoT Ecosystem
  • Use cases
  • How to secure IoT devices and communication
  • Solving connectivity issues when Wi-Fi/GSM is not abundant or too expensive
  • Protocols
  • Using of gateways as an intermediary
  • Monitoring your solutions
  • Device management

In the hands-on labs, you could bring you own devices to connect (Arduino, ESP8266, Raspberry Pi. Prototypes etc.) or use a simulated device. You will learn:

  • Connect to Azure IoT Hub
  • Device provisioning
  • Operational monitoring
  • Bidirectional communication (C2D, D2C)
  • Routing for messages
  • Real-time hot path data analytics with Stream Analytics
  • Visualize data
  • Acting on data insights via Azure Functions And/or Logic Apps

Prerequisite:

  • An Azure subscription
  • PowerBI account
  • Basic programming skills in C#, NodeJS, C, Python or Java
  • Code editor like Visual Studio 2015/2017 or Visual Studio Code

Bring your toughest questions as this workshop is led by two IoT experts from Microsoft. Anders Lybecker from the Global Black Belt IoT team and Tayo Carvalhal, discrete manufacturing cloud solution architect and former Ericsson IoT lead.

The Complete Primer to SQL Server Virtualization

David KleeHeraflux Technologies / 200

Microsoft MVP and VMware vExpert David Klee leads this full-day introduction to enabling and managing a virtualized SQL Server environment. The focus of the course is to help those new to virtualization and/or infrastructure concepts to become familiar with the concept and purposes of virtualization and how it can benefit them as data professionals. Participants will gain exposure to all layers of virtualization underneath SQL Server, from storage to hypervisor to the SQL Server instance, and will learn how to construct the entire stack with a strong emphasis on SQL Server performance.

Intended Audience. The intended audience of this course is information workers (both business and IT-centric) involved with architecting a virtualization strategy for SQL Server, or managing business-critical SQL Servers that have already been virtualized.

Course Topics
The following topics will be addressed during the course:

  • The Physical Infrastructure Underneath the VM
  • Virtualization and Infrastructure Fundamentals
  • The SQL Server Virtual Machine
  • Networking, Support, and Licensing
  • Performance Investigation and Tuning of the Entire Stack

Course Objectives
Upon completion of this course, attendees will be able to:

  • Understand key virtualization and cloud concepts
  • Determine the optimal infrastructure configuration for best performance
  • Construct a SQL Server virtual machine template with best practices for agility and performance
  • Understand how and what stack metrics to benchmark and baseline to ensure proper objective performance measurement
  • Identify and remediate common virtualized SQL Server performance killers
  • Understand proper virtualized capacity management techniques for long term management

Prerequisites
Attendees with the following experiences will benefit the most from this course:

  • Basic familiarity with the core components of a server
  • SQL Server installation and configuration
  • Exposure to SQL Server performance metric measurement and identification

A working set of the screens and configuration settings referenced in the session, together with the reference slides and documentation, will be provided to attendees, for strategic reference in working with virtualized SQL Server in theirown environments.

Embrace R

Dejan Sarka, Dejan Sarka s.p. / 200

As being an open source development, R is the most popular analytical engine and programming language for data scientists worldwide. The number of libraries with new analytical functions is enormous and continuously growing. However, there are also some drawbacks. R is a programming language, so you have to learn it to use it. Open source development also means less control over code. Finally, the free R engine is not scalable.

Microsoft added support for R code in SQL Server 2016 and, Azure Machine Learning, or Azure ML, and in Power BI. A parallelized highly scalable execution engine is used to execute the R scripts. In addition, not every library is allowed in these two environments.

Attendees of this seminar learn to program with R from the scratch. Basic R code is introduced using the free R engine and RStudio IDE. Then the seminar shows some more advanced data manipulations, matrix calculations and statistical analysis together with graphing options. The mathematics behind is briefly explained as well. Then the seminar switches more advanced data mining and machine learning analyses. Attendees also learn how to use the R code in SQL Server, Azure ML, and create SQL Server Reporting Services (SSRS) reports that use R.

  • The seminar consists of the following modules:
  • Introduction to R
  • Data overview and manipulation
  • Basic and advanced visualizations
  • Data mining and machine learning methods
  • Scalable R in SQL Server
  • Using R in SSRS, Power BI, and Azure ML

Design & Implement SQL Server HA/DR Hybrid Solutions with Microsoft Azure

Edwin Sarmiento, 15C Inc / 300

In this full-day workshop, we will be focusing on designing & implementing cloud data platform solutions with the Microsoft Data Platform by using SQL Server on-premises, hybrid and cloud data platform solutions. We will look at how to provide hybrid high availability and disaster recovery (HA/DR) solutions to our SQL Server databases. The following topics will be covered

  • Design & implement a hybrid SQL Server HA/DR solution using the Microsoft Azure Infrastructure-as-a-Service (IaaS) offerings
  • Design & implement a business continuity solutions using the Microsoft Azure SQL Database Platform-as-a-Service (PaaS) offerings
  • How to avoid the networking pitfalls of a hybrid HA/DR solution
  • Exploring the new SQL Server 2016 features that enable hybrid HA/DR solutions

At the end of the workshop, you will be confident enough to design & implement a HA/DR solution for your SQL Server databases that leverages Microsoft Azure without all the marketing fluff.

Azure Machine Learning: From analytics to predictive artificial intelligence – Hands ON

Rafal Lukawiecki

Azure Machine Learning is a fully managed cloud service that enables you to easily build, deploy, and share predictive analytics solutions. It is part of Cortana Intelligence Suite, which supports the entire data science lifecycle, and also offers easy-to-integrate artificial intelligence APIs.

In this full day training led by Rafal Lukawiecki, a machine learning expert and a data scientist with a decade of practical experience, you will understand the potential that machine learning offers to businesses and their customers. You will see how easy it is to add intelligence and advanced analytics to data stored in SQL Azure and other cloud sources, and how to effectively use R when needed. Everything will be explained and demonstrated, and you will see a working example of how to build and deploy a model of customers’ lifetime value (LTV), and how to use that intelligence to make live predictions to better serve their needs while meeting your increased business objectives. You will see how easy it is to deploy such a service to production and how to embed it into your own app logic.

Throughout the day there will be hands-on exercises, so bring your laptop.

Enterprise Data Integration with Biml

Reeves Smith, Macer Consulting / 200

DOWNLOAD PRESENTATION

Have you ever needed to create dozens of similar SSIS packages? Do you find yourself updating a lot of packages when requirements changes? These are not uncommon scenarios faced by ETL developers, but historically there haven’t been any good tools to help with this. However, I’ll introduce you to one of the most useful tools you may ever use: Biml.

For ETL developers, Biml (Business Intelligence Markup Language) is a game changer. This is a great new tool for Microsoft business intelligence developers who want to make the most of their development efforts. In short, it’s an XML-based language that will allow you to programmatically create SSIS packages. Even better, it can be enhanced with VB.NET or C# scripting to create BimlScript, which allows you to dynamically build and modify a few, dozens, or even hundreds of packages with minimal effort. Best of all, you don’t need budget approval – if you already have Visual Studio, you can use Biml and BimlScript for free!

In this full-day presentation, I’ll introduce you to dynamic package generation with Biml and BimlScript. I will walk you through the essentials of Biml – getting started, syntax, and common uses – followed by design patterns to improve your efficiency as an ETL developer.

Among the topics that we’ll cover:

  • Introduction to Biml syntax
  • Biml in the Visual Studio environment
  • Introduction to BimlScript syntax
  • Dynamic package generation with BimlScript
  • Metadata management with Biml
  • Create a simple staging package project with dozens of packages in less than an hour
  • Package (re)generation
  • Common design patterns for Biml in the enterprise

 

Prerequisites:

  • A working knowledge of SSIS and ETL concepts
  • Basic knowledge of T-SQL programming
  • Basic knowledge of C# programming

Analyze and tune SQL Server like a BOSS

Uwe Ricken, db Berater GmbH / 300

SQL Server is a mission critical database platforrm but is sensitive to misconfigurations, bad practices, sub-optimal indexing strategies and poor coding mistakes. Even the fastest hardware can end up performing like a ZX-81 if you get things wrong.

If you are a Database Administrator or Consultant who is responsible for expert performance analysis, problem detection and tuning of the SQL engine then it is important you are able to analyze and tune SQL Server like a BOSS.

In this full training day I will explain how to identify and resolve serious real world performance problems using concrete examples, demonstrations, possible effects and answers. This workshop will provide over 40 scripts which can be used directly in the workshop on your own machines during the day and we shall simulate performance problems and look to resolve them using a top-down approach.

A selection of things you can look forward to learning and experiencing during the day are:

  • Waits and Queues methology
  • Instance and database level configuration
  • TempDB importance and optimization
  • Index Analysis and tuning
  • Humour (yes Germans can be funny too!)

Power BI from Rookie to Rock Star

Reza Rad, RADACAD / 300
In this training course you will learn Power BI from beginner to advance. You will learn how to use Power BI for simple data analysis situations as well as complex business intelligence scenarios. You will learn about Power BI Desktop, Power BI Website (Service), and components of Power BI which are; Get and Transform (or Power Query), Modeling (or Power Pivot), and Visualization. You will also learn about Power Query Formula Language (Called M informally), and DAX. This course designed to give you an end to end view of Power BI, so you be able to use Power BI straight away after this course in your everyday challenges for data analysis.

Module 1: Introduction to Power BI
Power BI is the newest Microsoft Business Intelligence and Data Analysis tool. In this module we will go through basics of this product, and introduce all five components of Power BI (Power Query, Power Pivot, Power View, Power Map, and Power Q&A). You will see some demos and introduction about Power BI desktop, Office 365 Power BI subscription, and Power BI website, and mobile apps. You will see some basic demos of how easy to use is Power BI in some scenarios.

  • Introduction to Power BI: What is Power BI?
  • Power BI Desktop; The First Experience
  • Power BI Website; You’ll Need Just a Web Browser
  • Introduction to Power BI Components: Power Query, Power Pivot, Power
  • View, Power BI Service, and Power Q&A.

Module 2: Getting Data
Getting Data is the first experience of working with Power BI. You can connect to many data sources on-premises or on cloud. For some data sources you can have a live or direct connection, for some connection works offline. For some connections you need a gateway or connector to be installed. In this module you will learn everything about get data experience of Power BI.

  • What is Power Query: Introduction to Data Mash-Up Engine of Power BI
  • Get Started with Power Query: Movies Data Mash-Up
  • Power BI Get Data From Excel: Everything You Need to Know
  • File Sources
  • Folder as a Source
  • Database Sources
  • Analysis Services Connection
  • Get Data From Azure SQL Database
  • Software as A Source
  • Web Source

Module 3: Power Query for Data Transformation
Data analysis and BI world starts from data extraction and transformation. Power Query is the data transformation engine of Power BI. Power Query comes as part of Excel 2016, or as an add-in for Excel 2013 and 2010. Power Query is also part of Power BI Desktop. In this module you will learn about all different version of Power Query, their similarities, and differences, as well as configuration and requirements of using them.

Power Query uses a graphical user interface to apply transformations on the dataset. However Power Query works with a functional scripting language behind the scenes. The key to learn Power Query is learning the functional language called M. There are many features in M that are not available in the Power Query GUI. In this module you will learn how to understand M, and how to write M scripts even from scratch. You will learn writing custom functions in M as well as many other useful features.

The content that you will learn in this module includes but not limited to;

  • Different versions of Power Query
  • Power Query Introduction
  • Query Editor
  • Transformation GUI
  • Row Transformations
  • Column Transformations
  • Data Type
  • Adding Column
  • Text Transformations
  • Number Column Calculations
  • Date and Time Calculations
  • Data types, Lists, Records, and tables in M
  • M built-in functions
  • Generators in M
  • Writing Custom Functions
  • Error handling
  • Advanced Data Transformations with M

Module 4: Data Modelling
Power Pivot is xVelocity in-memory data modelling engine of the Power BI. Modelling effectively is the key of high performance BI solution. In this module you will learn basics of Power Pivot such as creating relationships, and calculated members, as well as advanced best practices and DAX expressions. DAX is Data Analytical eXpression language. DAX has similar structure to excel functions, but it is different. In this module you will learn DAX from beginner to advance. You will learn basic functions as well as complex functions and scenarios of using them in real world challenges.

The content that you will learn in this module includes but not limited to;

  • Power Pivot xVelocity engine basics and concepts
  • Relationships in Power BI
  • Best practices
  • Introduction to DAX
  • Calculated Columns
  • Measures
  • Calculated Tables
  • Row Context vs Set Context
  • Advanced calculations using Calculate functions
  • Time Intelligence Functions
  • DAX Advanced

Module 5: Data Visualization
Data Visualization is the front end of any BI application, this is the user view point of your system. It is critical to visualize measures, and dimensions effectively so the BI system could tell the story of the data clearly. In this module you will learn conceptual best practices of data visualizations which is valid through all data visualization tools. You will learn about visual components in Power BI Desktop. You will learn how to create effective charts, and dashboards using these tools as well as best practices for working with these tools. You will learn about interactivity of charts, using visuals, formatting, filters and slicers, Analytics, special charts such as Scatter, Waterfall, and Custom Visuals.

The content that you will learn in this module includes but not limited to;

  • Power BI Desktop Visualization
  • Custom Visuals in Power BI Desktop
  • Formatting Visuals in Power BI Desktop
  • Waterfall Chart
  • Built-in Charts and Graphs in Power BI
  • Sorting, Filtering, and categorization
  • KPIs
  • Maps and Geo-Spatial Visualization
  • Scatter Chart

Module 6: Gateways
To access on-premises data source from Power BI you need to setup, install, and configure gateways. There are two types of gateways. In this section you will learn what are differences between different gateways, and what are use cases for using each. You will learn tips and techniques for configuring gateway. You will learn how to set up a gateway to connect to on-premises file data sources, SQL Server database, and Analysis Services live connection. at the end of this section Gateway won’t be a beast for you anymore, you can tackle it with confidence.

The content that you will learn in this module includes but not limited to;

  • Two Types of Gateway
  • Personal Gateway
  • On-Premises Gateway
  • Architecture of Gateway
  • Performance Considerations
  • on-premises file data source
  • on-premises SQL Server data source
  • DirectQuery vs ImportData vs LiveQuery
  • Live SSAS Tabular Connection

Module 7: Power BI Service, Administration & Security
Power BI components can be deployed into different environments such as Power BI website. In this module we will go through deployment options, Configurations and requirements for publishing reports. You will learn how to deploy your Power BI files into Power BI website. you will also learn how to build dashboards in the website, and how to work with Mobile Apps for Apple, Android and Windows Phone. You will also learn how to set up security for your data, You will learn sharing architecture for reports, and you will learn about Administration privileges on Power BI account.

The content that you will learn in this module includes but not limited to;

  • Power BI Service Features
  • Design best practices for Power Q&A
  • Admin Portal
  • Groups and Work Spaces
  • Content Packs
  • Sharing Architecture
  • Row Level Security
  • Schedule Refresh

Instructor: Reza Rad

Trainer is the world well-known name in the Microsoft BI field. Reza Rad is invited speaker in world’s best and biggest SQL Server and BI conferences such as PASS Summits, PASS Rallys, SQLBits, TechEds, Ignites, and so on. He is author of books on this topic, and he has more than 15 years’ experience in the Microsoft BI technologies. 10 years of his experience focused on training and consulting to the largest BI teams in the world. He is also Microsoft Certified Trainer for years. He is Microsoft SQL Server MVP (Most Valuable Professional) focused on BI and Data Analysis, He has been awarded MVP from Microsoft because of his dedication and expertise in Microsoft BI technologies. He is author of Power BI online book; from Rookie to Rock Star; www.radacad.com/online-book-power-bi-from-rookie-to-rockstar