CONTACT US: On Facebook | info@mackenziemackenzie.com

MacKenzie & MacKenzie Consulting Inc.

Specializing in data engineering, analytics, and applications since 2000. (dba. BillZone Systems)

MicrosoftPartner

Consulting

Over 25 years of experience in data engineering, data science and analytics, mission-critical systems design, research, education, big data solutions, ERP and MRP integrations, and more.

Patreon

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. I can't wait to see you there!

CLICK HERE to check it out!

YouTube

Take a look at my YouTube channel on data engineering that shows many of the techniques that I use on a regular basis.

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 . This week's video:

Latest News

06

SEP

2022

Machine Learning

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

12

AUG

2022

Snowpark

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

30

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.

15

JUN

2022

Most widely used database engine?

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

20

MAY

2022

Six kinds of data engineer - which one are you?

In this episode, we check out six kinds of data engineers seen in tech today.

15

APR

2022

Woohoo! Passed my thesis defence this week.

Feeling pretty great this week, as I passed my thesis defence at Edinburgh Napier University. MSc. Data Engineering

08

DEC

2021

Access on Azure

How to make an online Access database that your users can open from anywhere.

30

OCT

2021

How to Use Select Top in SQL Server

In this episode, we’ll look at how to use Select Top in SQL Server.

26

OCT

2021

How to Open An Access File while Using Another

In this episode, we’ll look at how to open one access database while you’re using another one.

23

OCT

2021

How to Use execute_async to Start Queries without Waiting for Results

In this episode, we’ll look at how to use execute queries asynchronously on our Snowflake databases by using Python and the python connector.

19

OCT

2021

How to Use For Next Loops in MS Access

In this episode, we’ll look at how to use a For Next Loop in MS Access

16

OCT

2021

How to Use Group By in SQL to Get Summary Data

In this episode, we’ll look at how to use Group By in SQL.

12

OCT

2021

How to Use a Do Until Loop in MS Access

In this episode, we’ll look at how to use a Do Until Loop in MS Access.

08

SEP

2021

How to Use Java with JDBC on Azure SQL databases.

In this episode, we’ll look at how to use Java on Azure SQL.

Contact Us

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.