Training Day schedule

We have a great selection of Deep Dive Training sessions available for our training day on Friday April 26th. Please take your time to read through them all and then click the link to reserve your place on the one that you want.

Have you registered for our free Saturday sessions too? If not then you need to do that here to reserve your place.

BI in Azure

Alex Whittles MVP

Infrastructure as Code with Terraform

John Martin MVP

Machine Learning: From model to production using the cloud, containers and Dev Ops 

 Terry Mccann MVP

Performance Pain Reduction for Data Platform Projects

 William Durkin MVP

Getting up to speed with PowerShell

 Rob Sewell MVP

Pricing

BI in Azure with Alex Whittles

Session content
All you need to know to start developing business intelligence and analytics projects in Azure.

In this session we’ll take each section from basic principles and look at how they can work together to create a full solution. Using tools including:

  • Azure Data Factory
  • Azure Data Lake
  • Azure SQL DB
  • Azure Data Warehouse
  • Integration Services, hosted in Azure
  • Azure Analysis Services
  • Power BI
  • Azure ML Studio
  • On-prem Data Gateway

We’ll cover what each service does, how they fit together, and the pros and cons of each.
This session will be equal measures of theory and practical demos.

What will I learn
An understanding of how to architect and implement a cloud hosted BI project, find out what services are available and how to use them.

What do I need to know / bring with me
An understanding of business intelligence principles. For example what ETL is, and the concept of data warehousing at a high level.

Book onto this session using this form

Infrastructure as Code with Terraform with John Martin

Session content

Building reliable and repeatable infrastructure deployments thatcan be transitioned through Development, Test, and into production is becoming increasingly essential. There are many options including PowerShell, ARM, Cloud Formation and many more that you can use depending on your cloud of choice. But what if you want vendor lock in? Enter Terraform. An open source Infrastructure as code platform that works with Azure, AWS, and others as well as on-premises environments.

Together we will work through the what, why, and how of infrastructure automation with Terraform for building solutions. We will build a data platform solution and look at how we can transition through environments with VSTS and integrate this into development and operations processes that will let you concentrate on delivering more value to your users.

What will I learn
Learn how to build cloud infrastructure with declarative scripting that can span cloud and on-premises systems.

How to become more efficient by leveraging automation technology.

What do I need to know / bring with me
Skills: No prerequisites, working from a position of novice.
Laptop: Yes, needs to run Azure CLI, VS Code and Terraform (less spec than VS Code). Dual core CPU and 4 GB of RAM should be fine. I will provide Azure subscription details.

Book onto this session using this form

Machine Learning: From model to production using the cloud, containers and Dev Ops – Terry Mccann

Session content
Pick up a book on Machine learning and it will explain the process for machine learning, many citing CRISP-DM as the ideal process. CRISP-DM is an iterative approach to Data Mining. It starts with business understanding the flows to data understanding, data preparation, modelling, evaluation, then either loops back around or is deployed.

How it is deployed, well no one ever tells you that! Well, I want to talk about it!

In this full-day session we will build a series of basic models and promote them into production. This will be an interactive session, make sure you have your laptop with you. As we go through the day we will talk about the following:

Developing a Machine Learning Engineering environment Develop multiple basic machine learning models Deploy multiple basic machine learning models Develop an architecture capable of supporting and deploying any machine learning language Sounds awesome right? My intention is to show you a method for deploying machine learning models.

We will do this by looking at the following tech stack:

Microsoft Azure – A Cloud environment to deploy to. (All the tech we are using will work on a platform of your choice)

  • Python – To build our models
  • Docker – A container to run our models
  • Kubernetes – A Container runtime environment to handle the load balancing of our models.
  • Azure Service Bus – A stream service for our models
  • PowerBI – A reporting tool to visualise the usage of our models.
  • We will use a composition of other languages as we go.

All the scripts we will use will be available to GitHub for you to follow along.

What will I learn

At the end of the day we will have built a simple model and deployed it. You will take away a tried and tested architecture for deploying a model in to production. I will demo a method for deploying changes to your model using DevOps.

An Understanding of Machine Learning is preferred.

What do I need to know / bring with me
As a minimum delegates should have:

For delegates to get the most out of the day and get involved in advanced areas, we also recommend having the following tools installed:

All other material that will be delivered will be made available to delegates in advance of the training day

Book onto this session using this form

Performance Pain Reduction for Data Platform Projects with William Durkin MVP

Session Content
Designing and building a database solution is just the start of a database’s life. As soon as a system enters production the theories and
expectations made during the development phase meet reality. Often reality can be brutal and a “perfectly designed” system can come grinding
to a halt. The finger pointing and second-guessing that then ensues is counterproductive and blindly googling for a fast fix rarely solves
issues permanently.

In this workshop we will take a measured approach at identifying and solving performance problems inside data platform projects. We will start
the day with a look at implementing a solid foundation, using best practices and guidance so that our projects are set up for success. The day
will continue by investigating what is causing performance problems and what tools we have available to us, both natively within SQL Server and
with external tooling. Once we understand what is causing the performance problems, we will look into identifying solutions. Many times the
solutions are less complex and/or expensive to implement as may be expected. We will round out the day with a discussion around how performance
issues can be proactively identified and solved before they become painful.

This workshop is aimed at database developers and administrators. The topics covered are valid for both on-premises SQL Server as well as
cloud-hosted solutions (Azure SQL Database, Azure SQL Managed Instance) and are valid in all versions of the product from 2005 onwards.

What do I need to know / bring with me

Nothing special for the attendees

Book onto this session using this form

Getting up to speed with PowerShell with Rob Sewell MVP

Session Content

PowerShell is cross-platform, it works exactly the same on Windows, on Linux and Mac. It is awesome for automation and amazing for administration.

Come and join Cloud and Data Center MVP Rob Sewell and spend a day getting yourself up to speed with PowerShell.

We will cover

  • the basics about PowerShell, PowerShell security
  • how to open it, how to install it.
  • 4 vital commands to enable you to be able to help yourself
  • The PowerShell Gallery and how to find, install and use additional modules
  • Reading the language
  • Working with output
  • We will even delve into scripting with PowerShell and how to validate your environment

There will also be the opportunity to learn about any areas of PowerShell, Automation, CI/CD that you have questions about.

What do I need to know / bring with me

Attendees wanting to follow along should bring a laptop.

Book onto this session using this form

Pricing

At Data in Devon we would like to thank those who book early, so the first 10 people that register (and pay within 14 days) the cost of attending a training day is only £150.  The next 20 people to register will pay £175 and the cost will be £200 until 1st April, when the cost goes up to £250.

If an organisation wishes to send 5 people they will pay the standard rate of £200 for 4 people and the get the 5th free, as long they register before 1st April, after the 1st April they will pay £250 for 4 people and still get the 5th free.

We have just launched so the current price for any training day session is £150.

Book onto any of these sessions using this form

Advertisements