Craig Porteous

Information & Communications Technology

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

Glasgow, Scotland, United Kingdom

Craig Porteous

Husband, Dad | Data Platform MVP | Senior Data Engineer | STEM Ambassador | 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

Power BI and PowerShell - A Match Made in Heaven

Power BI is the shiny new tech for processing and visualizing data in the Microsoft Data Platform. However, the plumbing in the background does need managing (even if it is cloud-based and supposedly automagic).

In this session we will take a look at how to manage your datasets, security, monitor licensing and more, all through the ultimate administration interface: PowerShell!

You'll leave the session with an overview of the management capabilities of Power BI and couple that knowledge with the awesome power (and automation possibilities) of PowerShell


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


3 ways to bring Power BI under Source Control

People love creating content in Power BI but how do we track changes or backup all these new reports? We’ll look at 3 different ways to bring your reports under source control and how to automate the process using Microsoft Flow and PowerShell.


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.


Extending the Data Platform with PowerShell, an introduction

If you're not using PowerShell to make your job easier, this session is for you. DBA, BI developer, data engineer or anything in between, this is an introduction to how PowerShell can make your life easier.

In this session, we’ll explore what you need to get started, the tools for each role and situation and cover some best practices with tips to make your life easier.


Data Maturity: The foundation of digital transformation

What is Data Maturity and why should you care? In this session, I cover the importance of understanding your organisation's data maturity and how it can be broken down into component parts that can both drive and hinder digital transformation within businesses. We'll look at multipliers that can accelerate data maturity and how to target these with tactical projects.

You will leave this session with an understanding of what data maturity means for you and your organisation and what you can do to improve it in both the short and long term to de-risk projects and empower digital transformation.


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.


Past and future events

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 2019 - 7 Oct 2019
Mechelen, Flanders, Belgium

DATA:Scotland 2019

12 Sep 2019
Glasgow, Scotland, United Kingdom

DataGrillen 2019

19 Jun 2019 - 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 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

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