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

MacKenzie & MacKenzie Consulting Inc.

Specializing in data architecture, applications, and business intelligence since 2000. (dba. BillZone Systems)

MicrosoftPartner

Consulting

With over 20 years of experience in database and warehouse design, you can be sure of success.

Coaching

Managing a software project and need another set of eyes to help guide your success? Book a few sessions of executive-level coaching from an expert with wide experience across multiple industries.

YouTube Channel

Take a look at our YouTube channel on data analytics and data transformation that shows many of the techniques that I teach in our workshops.

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

Edit

Latest News

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.

03

SEP

2021

How to Migrate Data from Azure SQL to Snowflake

In this episode, we’ll look at how to use Python with pd_writer to migrate data to Snowflake.

31

AUG

2021

How to Open Excel from Access Using VBA

In this episode, we’ll look at how to open Excel sheets from MS Access using VBA.

27

AUG

2021

How to Use Python on Azure SQL Databases

In this episode, we’ll look at how to use Python with ODBC on Azure SQL databases.

24

AUG

2021

Why Use MS Access?

In this episode, we discuss the reasons why Access should be in your toolkit.

19

AUG

2021

How to Use Variables in SQL Server

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

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: