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:

Edit

Latest News

15

JAN

2021

Build a Data Pipeline in .Net Between Oracle and SQL Server

In this episode, we’ll learn how to build a data pipeline between Oracle and SQL Server, using ADO.Net, ODBC, and SqlClient.

08

JAN

2021

How to Launch and Filter Reports from a Form in MS Access

In this episode, we’ll learn how to launch a filtered report from a form with user selections in MS Access.

05

JAN

2021

How to Add Rows to Combo Boxes Using VBA

In this episode, we’ll learn how to add a function to let users add selections to a combo box in MS Access.

01

JAN

2021

How to Create a Line Graph in Python Using Matplotlib

In this episode, we’ll learn how to create a line graph in matplotlib, using climate change data from the World Bank.

25

DEC

2020

How to Use Left, Mid, Right, and Split to Slice and Dice Strings in vb.Net

In this episode, we’ll learn how to slice and dice strings, using four handy functions: Left, Mid, Right, Split

18

DEC

2020

How to Use Functions in MS Access Queries

In this episode, we’ll learn how to implement and use functions in your Access queries.

11

DEC

2020

How to use def to create functions in Python

In this episode, we’ll learn how to create functions in Python.

04

DEC

2020

How to use Recursive SQL - A Simple Example

In this episode, we’ll explore a simple example of recursion in SQL queries.

27

NOV

2020

How to Use Option Groups with Radio Buttons in MS Access

This week, we learn how to use option groups in MS Access.

20

NOV

2020

How to Use List/Array Methods in Python

We’ll find out how to use array methods in Python in this episode.

13

NOV

2020

How to Compare Lists in SQL Server

Find out how to compare lists in SQL Server in this week’s episode.

07

NOV

2020

How to Simulate Lag and Lead Window Functions in MS Access

In this episode, we’ll show how to simulate the Lag and Lead Window functions in MS Access.

01

NOV

2020

Use ggplot and plotnine to Make Scatter Plots in Python

In this episode, we’ll take a look at how to make cool charts in Python using ggplot and plotnine. Our example is a scatter plot.

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.

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: