Craig Porteous

Information & Communications Technology

Business Intelligence PowerShell power bi SQL Server Reporting Services T-SQL Data Platform automation Big Data Azure

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

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.


DIY ETL with Power Automate, Azure Functions and more

How do we handle the edge cases, the unique or temporary solutions to get data from emails, file shares, FTP, someone's desktop etc?
We need DIY ETL when the easy data sources don't exist, and the usual methods won't work.
In this session, we'll take 3 scenarios, solve them and make them reliable, and repeatable, with tools like Power Automate, Azure functions and more.


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

Data.Toboggan - Cool Runnings

11 Jun 2021

DataMinutes #1

11 Jun 2021

DATA:Scotland's Scottish Summer

16 May - 27 May 2021

#DataWeekender #TheSQL

16 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

1 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

6 Oct - 7 Oct 2019
Mechelen, Flanders, Belgium

DATA:Scotland 2019

12 Sep 2019
Glasgow, Scotland, United Kingdom

DataGrillen 2019

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

Scottish Power BI User Group

3 May 2019
Edinburgh, Scotland, United Kingdom

Data in Devon 2019

26 Apr 2019
Exeter, England, United Kingdom

SQLBits 2019

Power BI and PowerShell - A Match Made in Heaven
1 Mar - 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

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