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)

Consulting

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

Workshops and training

Get customized training for employees, or individuals in 1-on-1 sessions Learn from a certified, seasoned pro with over 20 years of direct experience in data analytics and transformation.

CLICK HERE to contact us and get started!

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:

Latest News

26

OCT/p>

2020

How to Use SQL Server Transactions with Rollback

In this episode, we’ll explore how to use database transactions to protect data integrity when we run a block of dependent statements.

10

OCT

2020

Implement If - Then - Else in Python

In this episode, we’ll learn how to do program flow-control with if, elsif, and else statements in Python.

10

OCT

2020

Date Formats in MS Access

In this episode, we learn how to show many different date formats in Microsoft Access.

05

OCT

2020

Parameterized Queries in .Net

Today we’re going to learn about how to use parameterized queries in .Net.

25

SEP

2020

Database Careers: What skills do you need to have a career in data?

In this episode I’m talking about career in Database and giving you a tour through Database jobs, skills, salary and more!

18

SEP

2020

Use Python on Oracle Databases

In this episode, we learn how to use Python on Oracle databases by demonstrating the four CRUD operations via pyodbc.

11

SEP

2020

VBA Mod Function with DoEvents: Prevent Not Responding Messages and Provide Feedback on Access Forms

In this episode, we’ll learn how to use the VBA Mod function with DoEvents to stop Access from “Not Responding” and to allow changing progress feedback to users on a form.

03

SEP

2020

How to Use percentile_cont in TSQL to Group Data by Upper, Middle, and Lower Thirds

How to Use percentile_cont in TSQL to Group Data by Upper, Middle, and Lower Thirds

28

AUG

2020

Excel to Access Using Python - Migrate Data Using Pandas, SQLalchemy python, and sqlalchemy-access

Today we migrate data from Excel to Access using Python.

22

AUG

2020

Coding for Kids 3: String Variables in Python

Check out the third video in our new playlist called Coding for Kids!

15

AUG

2020

Iif, If Then Else, and Select Case in MS Access

Iif, If Then Else, and Select Case in MS Access

10

AUG

2020

Pandas with Matplotlib - How to Create an Animated Scatter Diagram in Python

Animated Visualizations in Python

31

JUL

2020

How to Use DataViews to Filter and Sort ADO.Net DataTables

Use DataViews to Filter and Sort DataTables in ADO.Net

27

JUL

2020

How to Make Cascading Combo Boxes in MS Access

Let’s make some cascading combo box / drop down lists in MS Access.

09

JUL

2020

How to Query the Last Row in a Series in Microsoft Access

This week, we create a query in MS Access that will give the last row for each customer or status in your table.

03

JUL

2020

World's #1 Dreaded Programming Language

This week, we look at VBA, the voted the world’s most dreaded language on the annual stackoverflow developer survey.

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!
No Links Please
I want to: