Session room

The Agenda

Agenda Home

SQLBits encompasses everything from in-depth technical immersions to the enhancement of valuable soft skills. The full agenda will be announced in the spring; in the meantime check out the timetable and content we cover below.

2024 Training Days

Presenting 2024’s selection of training days, encompassing a deep dive into a range of subjects with some of the best data trainers in the world.

  • 08:00 Registration opens and breakfast served.

  • All training days run simultaneously across the venue from 09:00 – 17:00 with co-ordinated breaks.
  • All training days include regular refreshment breaks and a lunch stop to rest, recharge, and chat to fellow delegates.
  • No evening events planned, but if you’re staying over the night beforehand, why not join us in the Aviator on Monday night to meet the training day speakers for an informal drinks reception.

BI in the cloud on the menu - Select your dish of the day

Description

You are already using a BI solution and are interested in moving into the cloud? Or a BI solution is on your roadmap and you are not sure if cloud or on-prem is the right strategy for you? Then choose this session to gather new ideas and real-life experiences.

We will cover possibilities and challenges of the following topics:

  • Overview of the current services in azure and why you have to rethink about your solution
  • ETL in azure with Azure Data Factory, Logic Apps, Stream Analytics and Data Gateway for on-prem data sources
  • Data Warehouse in Azure MPP, Polybase and the Analysis Services
  • Data Mining / AI with Cognitive Services and Azure ML
  • Reporting in Azure with Power BI + Reporting Services
  • Look into possibilities for maintenance and automation

Pre-requisites
Basic knowledge in databases, analysis service (tabular model), ETL process
Laptop Required:Yes

  • Software: - SQL Management Studio - Visual Studio 2015 or 2017
  • Subscriptions: An Azure subscription is advantageous but not necessary.

Learning Objectives

Things I will need

Tech Covered

Cloud, Azure, data warehousing, BI, ETL, Analytics, roadmap, SQL, Cognitive Services, AI, Power BI