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 is a certified & university educated data analytics consultant, with 20 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

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.

05

OCT

2021

How to Use Message Boxes to Give Users Feedback in MS Access

In this episode, we’ll look at how to use message boxes in MS Access.

01

OCT

2021

What’s the Difference Between Data Analyst and Data Scientist?

In this episode, we’ll explore the difference between the data analyst and data scientist roles.

26

SEP

2021

How to Use Recursive VBA Functions in MS Access

In this episode, we’ll look at how to use recursive VBA functions to traverse trees in Access.

25

SEP

2021

How to Create a Heatmap Using ggplot and plotnine in Python

In this episode, we’ll be using the ggplot standard to plot charts in Python using plotnine!

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.