Data Engineering & Data Analytics

Patreon and Discord

Please, make sure to join my Patreon site to support my work and become a member of my community of data enthusiasts! Also, see exclusive videos and articles relating to my work. VIP and higher members get access to my Discord server. I can't wait to see you there!

CLICK HERE to check it out!

Sean
MacKenzie

Sean MacKenzie, MSc. (Data Engineering) is a data science & engineering consultant, with 25 years of experience in most aspects of data and its usage in small and large organizations. This includes extensive experience in data engineering, data application development, data modeling & architecture, analytics, and data science methods. He modeled, designed, and programmed mission-critical systems for province-wide and nation-wide usage in organizations like BC Emergency Health Services, Vancouver Coastal Health, Toronto East Health Network, and others. He has experience in the manufacturing, aerospace, health, transportation, insurance, finance, logistics, and retail industries.

Sean has been serving up superior data solutions across Canada since 2000. He advised and built mission-critical solutions for over 35 government and private companies across Canada and the United States. These include 7 hospitals, 6 health authorities, 6 manufacturers including 3 aerospace manufacturers, 3 insurance companies, and 2 crown corporations. He is known for highly innovative process and technical designs, some of which qualified him for national research and development programs.

He also has a YouTube channel and several products on this site, including BZ Time Entry and SmackoCrypt Pro for MS Access (soon to be released).

One Million Views

This month, my YouTube channel passed one million views! This journey has been amazing, I met so many wonderful people, and am looking at this as the beginning of a great journey. Let's get to it!

SEP

2023

Application Domain Intelligence

This month marks the start of a new series in Microsoft Access, centered around the combination of dynamic programming with decision models to facilitate real intelligence in applications that can be used together with knowledge harvesting, so that the expertise of your most experienced and knowledgeable users can be encapsulated in application logic.. ..and these superusers can program their knowledge into your system without any "programming" at all! I call my solution in this area ADI, or Application Domain Intelligence. Stay tuned as we explore this topic, which eventually leads to integrated machine learning for better outcomes. Get started with Part 1 by clicking HERE.

MAY

2023

Data Engineering Scholarship Announced

Sean is pleased to announce a scholarship with Edinburgh Napier University. This scholarship is created with the aim of enabling and enhancing one student's experience in the discipline of Data Engineering. To view information about the scholarship, CLICK HERE. Best of luck to all applicants.

MAY

2023

Challenging ChatGPT

This episode was my first run at challenging ChatGPT with a simple data engineering task. I asked the limited, free version to create a simple database application in Python, with a few fields, a database, and everything in between. The results were surpising: Click here to view.

MAR

2023

Big Data with Snowpark for Snowflake

This week's episode continues our exploration of Snowflake technologies, exploring the differences in Delete methodologies between Snowflake and traditional RDBMS systems. Click here to watch. Also, we'll be continuing our exploration of Snowpark, where we can write Python stored procedures and execute them in Snowflake instead of on our computer. Click here to get started with Snowpark for Python.

FEB

2023

WebForms for MS Access Devs

This month, we're launching a new playlist on WebForms, one of my favorite technologies for people to get started on their own data-driven web apps. Many of my viewers are MS Access developers who often struggle with an easy way to get all or part of their apps online in a way that makes sense to them. Click here to watch an intro on how WebForms dev happens, and here to start your very own cloud-based app in WebForms for free!

DEC

2022

Happy Holidays!

Many thanks to all of my customers, viewers, and supporters in this successful and very eventful year. All the best to you, your families, and loved ones.

DEC

2022

Join Patreon and Get a Mug

Not on my Patreon yet? Get articles, insight, and behind-the-scenes action when you join.. ..plus get a bonus free mug! The Sean MacKenzie Data Engineering on YouTube mug will be available for a limited time! Already a patron? Ping me in Patreon chat and I'll send one to you too! Join by clicking HERE. VIP level membership also gets access to my Discord server! Expires 2023-02-28

DEC

2022

Building a CNN for Computer Vision

In this episode, we explore how to get started with a Computer Vision script in Python using 60,000 images from CIFAR-10.

NOV

2022

Replication in Microsoft Access

Let's check out an example application using replication in this retro episode on MS Access

SEP

2022

Machine Learning

Over the past week, we created our first machine learning model, to add some artificial intelligence to our apps!

AUG

2022

Snowpark

This week, our Python on Snowflake playlist is diving into Snowpark!

JUN

2022

Office Move

My office is moving to Victoria, BC, Canada. Very excited to move to this beautiful city! Please note the new address below.

JUN

2022

Most widely used database engine?

Do YOU know which database engine is most widely used in the world? You might be surprised.

MacKenzie & MacKenzie Consulting Inc.

Address:
Suite 301
1321 Blanshard Street
Victoria, BC V8W 0B6

Social

MacKenzie & MacKenzie Consulting Inc.

Twitter

Please message me using the Facebook link under Social to the left, or email me using the email at the top of this page. Please follow my Facebook page, or follow me on Linked In.