CONTACT US: 778-373-4422 | info@mackenziemackenzie.com

MacKenzie & MacKenzie Consulting Inc.

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

MicrosoftPartner

Consulting

Over 20 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

23

FEB

2022

Relink your Access front-end file using vbScript and a table of links

In this episode, we’ll look at how to use vbScript to manage table links in MS Access.

18

FEB

2022

Execute concurrent select statements on Snowflake using Python

Find out how to kick off many select statements against Snowflake using Python, have them run concurrently, and then pick up the results as they complete.

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!

22

SEP

2021

How to Use Wildcards in MS Access Queries

In this episode, we’ll look at how to use wildcards in your MS Access queries.

15

SEP

2021

How to Send Email from Access Using VBA

In this episode, we’ll look at how to send email from Access using VBA.

10

SEP

2021

How to Show a Part Map in SQL Server Using Recursion

In this episode, we’ll look at how to create a manufacturing part map for a part, showing its hierarchy.

10

SEP

2021

How to Use a Do While Loop in Access VBA

In this episode, we’ll look at how to use a Do While.. Loop in VBA.

Contact Us

MacKenzie & MacKenzie Consulting Inc.

Address:
Suite 1500
701 West Georgia Street
Vancouver, BC V7Y 1C6


Social

MacKenzie & MacKenzie Consulting Inc.

Twitter

Contact Form
Be sure to click "I'm not a Robot" below!
I want to: