sqlsathistory

Nr: 754

Back to Main list

SQLSaturday #754 - Auckland 2018

Start Time (24h) Speaker Track Title
09:30:00 Sergio Reginaldo Zenatti Filho Advanced Analysis Techniques Harness the power of big data using Azure Data Lake
09:30:00 Martin Catherall Strategy and Architecture Data Privacy and the Data Professional.
09:30:00 Simon Peck BI Platform Architecture, Development Administration Orchestration and data movement with Azure Data Factory v2
09:30:00 Manjot Kaur BI Platform Architecture, Development Administration The Massively Parallel Processing Azure SQL Data Warehouse
09:30:00 Jim McLeod BI Information Delivery Creating Custom Visualisations with Power BI
10:50:00 Phillip Seamark BI Platform Architecture, Development Administration Advanced DAX : Tic Tac Toe in Power BI
10:50:00 Brian Bradley BI Platform Architecture, Development Administration Introduction to Data Vault
10:50:00 Hamish Watson Enterprise Database Administration Deployment Virtualisation and DevOps can help make your SQL Server perform!!
10:50:00 Anupama Natarajan Cloud Application Development Deployment Modern Data Warehouse using Lambda Architecture and Azure
10:50:00 Mohammad Hafizullah Strategy and Architecture Dive into Graph Databases
12:50:00 Manohar Punna Advanced Analysis Techniques Data Science for DBA - Get Started Now
12:50:00 Sergio Reginaldo Zenatti Filho BI Platform Architecture, Development Administration Building a Modern Analytics Solution in the Cloud
12:50:00 Leila Etaati Advanced Analysis Techniques Machine Learning Revolution with Azure Databricks
12:50:00 Owen Auger Advanced Analysis Techniques DAX for Business Analytics - My Favourite Examples
14:10:00 David Alzamendi BI Platform Architecture, Development Administration Displaying Real Time Information with Power BI
14:10:00 Dave Dustin Strategy and Architecture Back to Basics – An overview of the internals of SQL Server
14:10:00 Indira Bandari Advanced Analysis Techniques Google Forms meet Power BI via Reporting Services (SSRS)
14:10:00 Greg Low Strategy and Architecture Database on a diet (taming a large database)
14:10:00 Heidi Hasting BI Platform Architecture, Development Administration Bringing source control to BI world!
15:30:00 John Bowker Professional Development Joining Solved Problems: Data Product Management
15:30:00 Reza Rad BI Platform Architecture, Development Administration Ultimate Guide to Sharing Architecture for Power BI
15:30:00 Daniel Marsh-Patrick Analytics and Visualization Doing it Yourself: Creating and Publishing A Power BI Custom Visual to AppSource

SessionID: 75817

Harness the power of big data using Azure Data Lake

Back to calendar

Event Date: 01-09-2018 - Session time: 09:30:00 - Track: Advanced Analysis Techniques

Speaker: Sergio Reginaldo Zenatti Filho

Title: Harness the power of big data using Azure Data Lake

Abstract:

Azure Data Lake includes all of the capabilities required to make it easy for developers, data scientists and analysts to store data of any size and shape and at any speed, and do all types of processing and analytics across platforms and languages. In this session, you will discover how easy it is to harness the power of big data using Azure Data Lake Store and Azure Data Lake Analytics.

SessionID: 80897

Data Privacy and the Data Professional.

Back to calendar

Event Date: 01-09-2018 - Session time: 09:30:00 - Track: Strategy and Architecture

Speaker: Martin Catherall

Title: Data Privacy and the Data Professional.

Abstract:

It’s almost a daily occurrence to hear about some sort of data breach.

But what are the consequences of a data breach – for both the victims and companies involved – and what does that mean for you as a data professional. As governments start to legislate more in an effort to protect the privacy of its citizens the entire concept of data storage become more complex. Exactly what is legislation like the General Data Protection Regulation (GDPR) and how will it affect around the world. We’re seen Microsoft give us tools over the years – like Transparent Data Encryption and Dynamic Data masking - to help with this sort of thing – but is there a better answer? Come along to this session and hear how you and your team can lessen your chances of being the ones responsible for the next data breach.

SessionID: 83035

Orchestration and data movement with Azure Data Factory v2

Back to calendar

Event Date: 01-09-2018 - Session time: 09:30:00 - Track: BI Platform Architecture, Development Administration

Speaker: Simon Peck

Title: Orchestration and data movement with Azure Data Factory v2

Abstract:

As more and more businesses are looking to leverage cloud services to move and store their data we’ll take a look at how we can achieve that with ADF v2 and other Azure storage services.

For the SSIS developer, we’ll translate some ADF terminology to help get you started as well as demonstrate some real-life examples from our customer engagements. And of course, being automation experts with Biml, we’ll demonstrate how we can automate the creation of ADF v2 assets.

SessionID: 84092

The Massively Parallel Processing Azure SQL Data Warehouse

Back to calendar

Event Date: 01-09-2018 - Session time: 09:30:00 - Track: BI Platform Architecture, Development Administration

Speaker: Manjot Kaur

Title: The Massively Parallel Processing Azure SQL Data Warehouse

Abstract:

Azure SQL Data Warehouse is a flexible data warehouse-as-a-service product. It is an enterprise level big data solution as it is massively parallel processing as compared to traditional Symmetric Multi-Processing system. In this session, we will look at implementing Azure SQL DW, its architecture and also the collaboration with other hybrid solutions.

SessionID: 84290

Creating Custom Visualisations with Power BI

Back to calendar

Event Date: 01-09-2018 - Session time: 09:30:00 - Track: BI Information Delivery

Speaker: Jim McLeod

Title: Creating Custom Visualisations with Power BI

Abstract:

While Power BI comes with a lot of useful visualisations out of the box, and third-party visuals and R gives you a lot more choice, sometimes you need full control over what is being displayed. This is not for the faint hearted, as you will require Typescript and JavaScript skills and an understanding of the D3 JavaScript libraries, but there is a lot of sample code to smooth the way. This session introduces you to writing your own fully interactive custom visualisations in NodeJS, how to troubleshoot and debug, culminating in deployment of the Visual to your Power BI environment, giving you the ability to display exactly what you want in your Power BI reports.

SessionID: 74268

Advanced DAX : Tic Tac Toe in Power BI

Back to calendar

Event Date: 01-09-2018 - Session time: 10:50:00 - Track: BI Platform Architecture, Development Administration

Speaker: Phillip Seamark

Title: Advanced DAX : Tic Tac Toe in Power BI

Abstract:

This session will dissect a data model designed to push the boundaries of DAX beyond simple COUNT and SUM calculations. Come and see how to build a working Tic Tac Toe game using just DAX inside of Power BI. This session will cover a wide variety of advanced tips and tricks that will reset your understanding of what is possible using DAX. Time permitting we may also look at Sudoku, Blackjack, Hangman and more....

SessionID: 82488

Introduction to Data Vault

Back to calendar

Event Date: 01-09-2018 - Session time: 10:50:00 - Track: BI Platform Architecture, Development Administration

Speaker: Brian Bradley

Title: Introduction to Data Vault

Abstract:

Over the last 10 years, Data Vault has become a common concept in the Data world.

What is it? Why is it interesting? Where can it be used? How is it implemented in SQL Server? This presentation will give you a flavour of Data Vault. It will introduce: The concepts which make up Data Vault; The common tools used for building Data Vaults; How it works in SQL Server; The importance of Data Modelling and how it is structured; Interaction with modern Analytic Tools; Where to go for more information.

SessionID: 83057

Virtualisation and DevOps can help make your SQL Server perform!!

Back to calendar

Event Date: 01-09-2018 - Session time: 10:50:00 - Track: Enterprise Database Administration Deployment

Speaker: Hamish Watson

Title: Virtualisation and DevOps can help make your SQL Server perform!!

Abstract:

Over the years, running SQL Server inside a virtual machine has changed from being a bit of a strange and risky idea to being commonplace and offering a range of benefits: more effective distribution of load, more flexible provisioning, and allowing additional tiers of redundancy to be put in place.

Though these factors are compelling, running your database inside a virtual machine introduces an additional set of variables to worry about.

This session will discuss industry tools that allows for configuration and optimisation of virtual servers.

It will also show how using common DevOps principles - such as automation, monitoring and Infrastructure as Code can mitigate some of the variability in running SQL Server on a virtual host.

We'll also go over some of the things that you should be looking at within your virtual environment to ensure that you are getting the best performance out of it.

SessionID: 83967

Modern Data Warehouse using Lambda Architecture and Azure

Back to calendar

Event Date: 01-09-2018 - Session time: 10:50:00 - Track: Cloud Application Development Deployment

Speaker: Anupama Natarajan

Title: Modern Data Warehouse using Lambda Architecture and Azure

Abstract:

Organisations capture huge volumes of data and they need actionable information to act on them proactively in real-time to stay competitive. This requires a different thinking from the conventional Data Warehouse Architecture to more Cloud based Data Processing Architecture where high volume batch and real-time processing can be achieved using optimal cost.

In this session you will learn about

  1. Overview of Lambda Architecture
  2. How Azure Services implement Lambda Architecture
  3. Advantages of leveraging Azure for Lambda Architecture
  4. Business Scenarios to consider Lambda Architecture

SessionID: 84107

Dive into Graph Databases

Back to calendar

Event Date: 01-09-2018 - Session time: 10:50:00 - Track: Strategy and Architecture

Speaker: Mohammad Hafizullah

Title: Dive into Graph Databases

Abstract:

Graph databases are being talked about quite a lot lately. Its a special feature for special use cases. This session would focus on what, why and how of SQL Server Graph Database feature. And also, whats there in Cloud (Azure and AWS) for Graph Databases?

SessionID: 73892

Data Science for DBA - Get Started Now

Back to calendar

Event Date: 01-09-2018 - Session time: 12:50:00 - Track: Advanced Analysis Techniques

Speaker: Manohar Punna

Title: Data Science for DBA - Get Started Now

Abstract:

If you are a DBA and want to get started with Data Science, then this session is for you. This demo-packed session will show you few components and technologies needed for a Data Science project in Microsoft Data + AI stack. You will learn the basics of R programming language, Machine Learning and visualisations that businesses need today. In this session you will get a head start about few component in Microsoft Data + AI stack and the possibilities that can be achieved with them.

SessionID: 83360

Building a Modern Analytics Solution in the Cloud

Back to calendar

Event Date: 01-09-2018 - Session time: 12:50:00 - Track: BI Platform Architecture, Development Administration

Speaker: Sergio Reginaldo Zenatti Filho

Title: Building a Modern Analytics Solution in the Cloud

Abstract:

Do you want to build a modern analytics solution in the cloud using the latest technologies and go 100% PaaS/SaaS. If so, in this session, I will show and demonstrate how to use a several Azure Technologies. I will demonstrate how to ingest a large dataset, how to process/transform, how to build a data model and how to visualize. Some of the technologies covered in this session are: Azure Data Factory, Azure Analysis Services, Power BI, Azure SQL Database, Machine Learning, Azure Data Lake Store and Azure Data Lake Analytics.

SessionID: 84263

Machine Learning Revolution with Azure Databricks

Back to calendar

Event Date: 01-09-2018 - Session time: 12:50:00 - Track: Advanced Analysis Techniques

Speaker: Leila Etaati

Title: Machine Learning Revolution with Azure Databricks

Abstract:

Azure Databricks is an Apache Spark-based platform designed for the Microsoft Azure cloud services platform and easy to set up with one-click. It has an interactive workspace that enables collaboration between data scientists, data engineers, and business analysts. Azure Databricks notebook unify all the process from data gathering, model creation, deployment. It easy to connect to spark environment and access to the variety of data stores and services in Azure such as Azure SQL Data Warehouse, Azure Cosmos DB, Azure Data Lake Store, Azure Blob storage and Azure Event Hub. Moreover, the possibility to add advanced analytics capabilities will be available instantly and developer able to share their insights via Power BI. A brief introduction and demonstration on how to work with Azure Databricks will be presented. A demo of doing machine learning project with the help of Databricks on Azure, from getting data from data stores and modeling, deploying algorithm will be presented.

SessionID: 84266

DAX for Business Analytics - My Favourite Examples

Back to calendar

Event Date: 01-09-2018 - Session time: 12:50:00 - Track: Advanced Analysis Techniques

Speaker: Owen Auger

Title: DAX for Business Analytics - My Favourite Examples

Abstract:

The DAX language, at the core of Power BI, puts advanced analytical techniques in the hands of a wide range of business users.

In this session I will share a smorgasbord of my favourite analytical techniques using the DAX language that I have developed and encountered in a business environment. Examples include scenario variance analysis, advanced date and time-based calculations, "Top N Other", detecting runs of outcomes, inverting filters, and finding your greatest ally or nemesis.

This session is for anyone who loves problem-solving with Power BI in a business environment, whether you are already using DAX or keen to learn.

SessionID: 78811

Displaying Real Time Information with Power BI

Back to calendar

Event Date: 01-09-2018 - Session time: 14:10:00 - Track: BI Platform Architecture, Development Administration

Speaker: David Alzamendi

Title: Displaying Real Time Information with Power BI

Abstract:

Have you been asked about displaying real time information in your Power BI reports dashboards? Have you had performance problems delivering a real time solution? Have you found the correct tools for delivering real time solutions?

Through this session, you will learn how to deliver Power BI solutions streaming real time information. I will go over the different tools that we can use to approach as close as possible to a real time solution as well as combining real time information with batch processed information.

SessionID: 80908

Back to Basics – An overview of the internals of SQL Server

Back to calendar

Event Date: 01-09-2018 - Session time: 14:10:00 - Track: Strategy and Architecture

Speaker: Dave Dustin

Title: Back to Basics – An overview of the internals of SQL Server

Abstract:

What actually happens when you execute a query.

This session drills down into how SQL Server and other relational database systems work behind the scenes. We’ll look at the interpreter, optimizer, estimator, storage, memory, locking, blocking, indexes, statistics and everything else that makes it all work.

SessionID: 80937

Google Forms meet Power BI via Reporting Services (SSRS)

Back to calendar

Event Date: 01-09-2018 - Session time: 14:10:00 - Track: Advanced Analysis Techniques

Speaker: Indira Bandari

Title: Google Forms meet Power BI via Reporting Services (SSRS)

Abstract:

Are you interested in getting to know what your customers are thinking about your services? Empower your business with this end to end solution of creating feedback survey, sending and receving the responses and then finally analysing the same.

In this session I will show you how to • Initiate customer feedback surveys using Google Forms. • Send the survey emails to the database contacts through data driven subscriptions of Reporting Services (SSRS) • And finally analyse the customer feedback using Power BI

SessionID: 82755

Database on a diet (taming a large database)

Back to calendar

Event Date: 01-09-2018 - Session time: 14:10:00 - Track: Strategy and Architecture

Speaker: Greg Low

Title: Database on a diet (taming a large database)

Abstract:

Greg regularly works with tier-one financial organisations and they all struggle with the size of their databases. It's easy for the size to get out of control. In this session, Greg will describe the techniques he used to reduce an operating 3.6TB database to just over 500GB, while increasing its performance. The session will include a deep dive into compression techniques within SQL Server.

SessionID: 83220

Bringing source control to BI world!

Back to calendar

Event Date: 01-09-2018 - Session time: 14:10:00 - Track: BI Platform Architecture, Development Administration

Speaker: Heidi Hasting

Title: Bringing source control to BI world!

Abstract:

- Do you ever have trouble finding the latest version of a report?

If you answered yes to any of these questions then this session is for you! We will go through

  1. Why source control is important.
  2. The different Visual Studio project types (Databases, Analysis Services, Integration Services, and Reporting Services)
  3. How to bring an existing business intelligence environment into Source Control
  4. How to facilitate parallel development

Let's bring order to your chaos!

SessionID: 73934

Joining Solved Problems: Data Product Management

Back to calendar

Event Date: 01-09-2018 - Session time: 15:30:00 - Track: Professional Development

Speaker: John Bowker

Title: Joining Solved Problems: Data Product Management

Abstract:

Managing a team of data specialists in today's cloud based environment brings with it many issues. Tech is all about big ideas at speed and this often collides with the pet nature of databases as opposed to cattle application servers.

This session will go through the real life challenges and successes of taking a team of DBA's and Engineers from a traditional data center to working fully in the public cloud:

SessionID: 84262

Ultimate Guide to Sharing Architecture for Power BI

Back to calendar

Event Date: 01-09-2018 - Session time: 15:30:00 - Track: BI Platform Architecture, Development Administration

Speaker: Reza Rad

Title: Ultimate Guide to Sharing Architecture for Power BI

Abstract:

In this session, Reza will cover different sharing methods (basic sharing, workspaces, apps, publish to web, embedded), and their pros and cons. He will also cover Row Level Security. You will learn how to secure the content of Power BI based on roles. Reza will demonstrate different implementations of row level security such as through SSAS live query, RLS in Power Bi, regardless of data source. Finally, in this session, you will learn best practices and architecture advise for both Sharing and Security.

SessionID: 85260

Doing it Yourself: Creating and Publishing A Power BI Custom Visual to AppSource

Back to calendar

Event Date: 01-09-2018 - Session time: 15:30:00 - Track: Analytics and Visualization

Speaker: Daniel Marsh-Patrick

Title: Doing it Yourself: Creating and Publishing A Power BI Custom Visual to AppSource

Abstract:

Power BI offers an incredibly extensive custom visualisation framework and the world is (almost) your oyster when it comes to what you can do. There's plenty of great visuals out there already, but what happens when you really want something that just doesn't seem to be out there and... why hasn't someone else built it yet? It can't be that hard to do... right? Can I really do it myself?

This session covers the journey of the conception and development of the Small Multiple Line Chart custom visual, some of the challenges and lessons learned along the way, and the process of self-publishing visuals through the AppSource platform for general availability in the marketplace.