Craig Porteous

Information & Communications Technology

Business Intelligence PowerShell SQL Server Reporting Services T-SQL Data Platform automation Big Data Azure Azure Data Azure Data Lake Azure Data Factory Azure Databricks

Glasgow, Scotland, United Kingdom

Craig Porteous

Husband, Dad | Data Platform MVP | Principal Advanced Analytics Consultant | DATA:Scotland event founder | Glasgow Data UG organiser | He/Him.

I bring data and automation together. I love to learn and share what I learn with the technical community. I enjoy running and live for my family. He/Him

Current sessions

Designing Data Architectures that InfoSec will actually approve

Building your data platform in the cloud is easy, but as soon as that dreaded word "security" becomes involved it suddenly becomes incredibly painful. How do you go about integrating it with your existing networking, how do you manage user security, what on earth is a private endpoint? Over the past year, a lot of these tools have evolved and we now have a set of mature patterns we can apply to actually make a modern data platform secure.

In this session I'll guide you from through a secure reference architecture with Data Factory, Databricks, Data Lake, and Azure Synapse, working together as a secure, fully productionised platform. Each has their own idiosyncrasies, but this session will teach you the options available and the pitfalls to avoid.


Accessibility for hard of hearing & deaf people

This session gives you an insight on what you can do in order to be more accessible to people that are hard of hearing or deaf. Accessibility does matter because it means that you are able to broad your audience and believe it or not it also supports people without disabilities.


"Cultivating the Catalogue" - Growing Data Governance with Azure Purview

Providing a business with an organized and propagated data catalogue is essential with ever growing demands and questions about your data platform. How are your data assets organised and how can you track lineage?

In this session we will help you sew the seeds of good data governance and show how Azure Purview fits into your pathway. We will demonstrate how processes, business terminology, and ownership drive data governance forward. To close out this introductory session we'll dig deep into ways to extend Purview's capability with the Atlas API


Chocolatey for Data People

The Why and How of using chocolatey to save you time setting up your machine

Lightning talk


Build a perfectly governed Data Lake with Azure Purview

How do you stop a data lake turning into a data swamp? How do you make the data usable and accessible? I'll explore the foundations for good data lake architecture and how Azure Purview is the key to adoption and governance


Surveying your estate: Managing a sprawling data landscape with Azure Purview

In this session I will discuss the importance of data governance in a modern analytics organisation, and how Azure Purview fits into that journey. You will leave this session with an understanding of what Azure Purview is, and what is important for good data governance.


The PowerShell Standards Agency – Write better code for Everybody

There’s the quick way or there’s the right way. In this session we will look at good practices and standards to follow when writing PowerShell to make it easier for you and others to trust and reuse your code
By the end of this session you’ll have a guide to being a better PowerShell citizen, following best practices and sharing your code with others.
Become a member of the PowerShell Standards Agency* (Not a real thing) and write better code for Everybody


Supercharge your Reporting Services: An essential toolkit

Get the most out of your Reporting Services (SSRS) environments with this arsenal of PowerShell, SQL and admin tools. You'll leave this session knowing and controlling more about your SSRS environments than you thought possible.

Get the most out of your Reporting Services (SSRS) environments with this arsenal of PowerShell, SQL and admin tools. You'll leave this session knowing and controlling more about your SSRS environments than you thought possible covering monitoring, security, administration and deployment.


Adventures in CICD with Azure Synapse

In this session we'll look at the pitfalls, prerequisites, and process of setting up a continuous deployment pipeline for your Azure Synapse workspace. In this demo-heavy session we'll set up a YAML pipeline using Azure DevOps to deploy an Azure Synapse workspace resources through a development lifecycle.


Past and future events

DataGrillen 2022

2 Jun 2022 - 3 Jun 2022
Lingen, Lower Saxony, Germany

SQLBits

8 Mar 2022 - 12 Mar 2022
London, England, United Kingdom

PASS Data Community Summit 2021

8 Nov 2021 - 12 Nov 2021

South Coast Summit 2021

16 Oct 2021
Southampton, England, United Kingdom

Data Saturday Oslo - Virtual

4 Sep 2021

Data.Toboggan - Cool Runnings

12 Jun 2021

DataMinutes #1

11 Jun 2021

DATA:Scotland's Scottish Summer

17 May 2021 - 28 May 2021

#DataWeekender #TheSQL

17 Oct 2020

Birmingham Data Platform - JUNE ONLINE EVENT - SSRS, PowerApps and PowerBI

Supercharge your Reporting Services: An essential toolkit
4 Jun 2020
Birmingham, England, United Kingdom

Swedish Power BI User Group May meetup

Power BI Under Source Control
6 May 2020

Data Community Weekender Europe

2 May 2020

Guildford - Surrey Data Platform Group

3 ways to bring Power BI under Source Control
9 Mar 2020
Guildford, England, United Kingdom

Scottish Summit

29 Feb 2020
Glasgow, Scotland, United Kingdom

dataMinds Connect 2019

7 Oct 2019 - 8 Oct 2019
Mechelen, Flanders, Belgium

DATA:Scotland 2019

13 Sep 2019
Glasgow, Scotland, United Kingdom

DataGrillen 2019

20 Jun 2019 - 21 Jun 2019
Lingen, Lower Saxony, Germany

Scottish Power BI User Group

3 May 2019
Edinburgh, Scotland, United Kingdom

Data in Devon 2019

27 Apr 2019
Exeter, England, United Kingdom

SQLBits 2019

Power BI and PowerShell - A Match Made in Heaven
1 Mar 2019 - 2 Mar 2019
Manchester, England, United Kingdom

PowerShell Southampton

The PowerShell Standards Agency – Write better code for Everybody
20 Nov 2018
Southampton, England, United Kingdom

Scottish Power BI User Group

2 Nov 2018
Edinburgh, Scotland, United Kingdom

SQL Relay 2018

Power BI and PowerShell - A Match Made in Heaven
9 Oct 2018
Leeds, England, United Kingdom

SQL Relay 2018

Power BI and PowerShell - A Match Made in Heaven
8 Oct 2018
Newcastle, Northern Ireland, United Kingdom

Dev Ops North East

The PowerShell Standards Agency – Write better code for Everybody
20 Sep 2018
Newcastle, Northern Ireland, United Kingdom

Austin PowerShell User Group

Remote Session: The PowerShell Standards Agency – Write better code for Everybody
23 Aug 2018
Austin, Texas, United States

Cardiff MSFT Stack User Group

The PowerShell Standards Agency – Write better code for Everybody
Power BI and PowerShell - A Match Made in Heaven
25 Jul 2018
Cardiff, Wales, United Kingdom

SQLGrillen 2018

21 Jun 2018 - 22 Jun 2018
Lingen, Lower Saxony, Germany