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

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:

• A laptop.
• An Azure subscription with available credit. https://azure.microsoft.com/en-gb/offers/ms-azr-0044p/
• A modern internet browser.

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

• Docker for your OS – https://www.docker.com/
• Python (Anaconda preferred) – https://www.anaconda.com/download/
• Azure CLI – https://docs.microsoft.com/en-us/cli/azure/install-azure-cli?view=azure-cli-latest
• Kubectl – https://docs.microsoft.com/en-us/cli/azure/acs/kubernetes?view=azure-cli-latest

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

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