£125 – £150

Business Intelligence in Azure - The Lambda Architecture with Alex Whittles...

Event Information

Share this event

Date and Time

Location

Location

Manchester Metropolitan University Business School

All Saints Campus

Oxford Road

Manchester

M15 6BH

United Kingdom

View Map

Friends Who Are Going
Event description

Description

Overview

The lambda architecture is here! In this full day of training learn how to architect hybrid business intelligent solutions using Microsoft Azure offerings. Understand the roles of these cloud services and how to make them work for you in this complete overview of BI developed on the Microsoft data platform.

Module 1 – An Overview of BI in Azure

What’s available for the business intelligence architect in the cloud and how might these services relate to traditional on premises ETL and cube data flows. Is ETL enough for our big unstructured data sources or do we need to mix things up and add some more letters to the acronym in the cloud?

Module 2 – Azure SQL DB and DW

It’s SQL Server Jim, but not as we know it. Check out the PaaS flavours of our long term on premises friends. Can we trade the agent and an operating system for that sliding bar of scalable compute? DTU and DWU are here to stay.

Module 3 – The Azure Machines are here to Learn

Data scientist or developer? Azure Machine Learning was designed for applied machine learning. Use best-in-class algorithms and a simple drag-and-drop interface. We’ll go from idea to deployment in a matter of clicks. Without a terminator in sight!

Module 4 – Diving into the Azure Data Lake with USQL

Let’s understand the role of this hyper-scale two tier big data technology and how to harness its power with U-SQL, the offspring of T-SQL and C#. We’ll cover everything you need to know to get started developing solutions with Azure Data Lake.

Module 5 – IoT, Event Hubs and Azure Stream Analytics

Real-time data is everywhere. We need to use it and unlock it as a rich source of information that can be channelled to react to events, produce alerts from sensor values or in 9000 other scenarios. In this module we’ll learn how, using Azure messaging hubs and Azure Stream Analytics.

Module 6 – Bringing it Together for Consumption in Power BI

Combining all our data sources in one place with rich visuals and a flexible data modelling tool. Power BI takes it all, small data, big data, streaming data, website content and even supports gateways back to our office. Here we’ll consume everything created in the previous modules and more.

Module 7 – Orchestrate Your Services with Azure Data Factory

Create the perfect dependency driven pipeline with Azure Data Factory. What’s an activity and how do you work with time slices? We’ll invoke what’s been created in previous modules to bring the end to end solution together in a controllable way. Plus, how to work with the Azure Batch Service should you need that extensibility.

All content is subject to change dependant on timings.

BIO

Alex is a Data Platform MVP and is the owner and lead consultant at Purple Frog, a SQL Server Business Intelligence consultancy in the UK. He specialises in dimensional data modelling, data warehouse design, ETL systems, OLAP cubes, MDX and DAX using the SQL Server stack.

Alex has an MSc in Business Intelligence, runs the Midlands SQL Server User Group and the Birmingham SQL Relay conferences, and is on the SQL Bits committee.

As well as speaking at SQLBits, he is also a regular speaker at other events including SQL Saturday, SQL Relay, PASS Summit, 24 HOP and SQL Server user groups around Europe.

Paul has 10+ years’ experience working with the complete on premises SQL Server stack in a variety of roles and industries. Now as the senior developer at Purple Frog Systems has turned his keyboard to business intelligence solutions in the Microsoft cloud. Specialising in real-time data streaming with the internet of things (IoT), Azure Data Lake Analytics and Data Factory orchestration for big data platforms.

Paul is also a STEM Ambassador for the networking education in schools’ programme, SQL Midlands PASS chapter leader, SQL Relay/SQL Saturday speaker as well as very active member of the technical community.

Share with friends

Date and Time

Location

Manchester Metropolitan University Business School

All Saints Campus

Oxford Road

Manchester

M15 6BH

United Kingdom

View Map

Save This Event

Event Saved