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

04

JUN

2021

How to Use Lead and Lag Functions in SQL Server

In this episode, we’ll show how to use Lead and Lag functions in SQL Server to get values from the next and previous rows in your query.

01

JUN

2021

How to Run Code Before a Report Opens in MS Access

In this episode, we’ll look at how to execute code before a report opens in Access.

28

MAY

2021

How to Merge Pandas Dataframes in Python

In this episode, we’ll look at how to merge pandas dataframes using the Merge method.

25

MAY

2021

How to Do Grouping and Sorting in MS Access Reports

In this episode, we’ll look at how to group and sort your reports in MS Access.

18

MAY

2021

How to Use Sleep to Pause VBA in MS Access

In this episode, we’ll look at how to pause your VBA execution in MS Access by using the Sleep function.

14

MAY

2021

How to Use Stored Procedures in SQL Server

In this episode, we’ll show how to use stored procedures in SQL Server to use many SQL statements at one time.

11

MAY

2021

How to Create Command Buttons in MS Access

In this episode, we’ll look at how to create and use command buttons on your Access forms.

07

MAY

2021

How to Use Append in Python Pandas

In this episode, we’ll look at how to append pandas dataframes onto each other using the Append method.

04

MAY

2021

How to Handle VBA Errors in MS Access

In this episode, we’ll look at how to handle VBA errors in MS Access.

30

APR

2021

How to Generate Random Numbers in VB.Net and C#

In this episode, we’ll show how to use the Random function to generate random numbers in .Net.

27

APR

2021

How to Use Pass Through Queries in MS Access

In this episode, we’ll look at how to create and use a Pass Through query in MS Access.

23

APR

2021

How to Do Error Handling in Python

In this episode, we’ll look at how to handle errors in Python using try.. except.. finally blocks.

20

APR

2021

How to Use Union Queries in MS Access

How to Use Union Queries in MS Access

16

APR

2021

How to Format Numbers, Time, and Date Using the Format Function in VB.Net and C#

In this episode, we’ll show how to use the Format function to format numbers and dates in VB, (C# has the same function).

13

APR

2021

How to Use Delete Queries in MS Access

In this episode, we’ll look at how to create and use a Delete query in MS Access to delete rows from our table.

09

APR

2021

How to Query Snowflake Data into Pandas Dataframes Using fetch_pandas_all

In this episode, we’ll look at how to read Snowflake data into pandas dataframes by using fetch_pandas_all.

06

APR

2021

How to Use Make Table Queries in MS Access

In this episode, we’ll look at how to create and use a Make Table query in MS Access to create a new table from your query.

02

APR

2021

How to Do Multiple Inserts in a Single SQL Statement

In this episode, we’ll look at how to do multiple inserts in a table while only using a single SQL statement.

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: