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

30

JUL

2021

How to Migrate CSV Data to MS Access with Python

In this episode, we’ll look at how to migrate CSV data to MS Access databases using Python with SqlAlchemy and pyodbc.

28

JUL

2021

How to Use DateAdd, DateDiff, and DatePart in MS Access

In this episode, we’ll look at how to calculate dates in MS Access.

23

JUL

2021

How to Read Excel Files using VB.Net with NPOI - no Office or OLEDB or ODBC required

In this episode, we’ll look at how to read and manipulate Excel files when you don’t have access to a MS Office installation (libraries), OLEDB, or ODBC drivers.

20

JUL

2021

How to Use Left, Right, Mid, Instr, and Trim in MS Access

In this episode, we’ll look at how to slice and dice strings in MS Access.

16

JUL

2021

How to Execute Many SQL Statements on Snowflake with execute_stream

In this episode, we’ll look at how to execute many SQL statements on a Snowflake database using Python and execute_stream.

13

JUL

2021

How to Use Import Specifications in MS Access

In this episode, we’ll look at how to use import specifications in MS Access.

09

JUL

2021

How to Make a Bar Chart in Python Using ggplot and plotnine

SHORT DESCRIPTION GOES HERE

06

JUN

2021

How to Use Calculated Columns in MS Access

In this episode, we’ll look at how to use calculated columns in MS Access.

02

JUL

2021

How to Format Dates in SQL Server

In this episode, we’ll show how to format dates in SQL Server by using the Convert and Format functions.

29

JUN

2021

How to Use Crosstab Queries in MS Access

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

25

JUN

2021

How to Use Parameters with Python Connector for Snowflake

SHORT DESCRIPTION GOES HERE

22

JUN

2021

How to Use the Tab Control in MS Access

In this episode, we’ll look at how to use the tab control on Access forms.

18

JUN

2021

How to Use Multithreading in Python

In this episode, we’ll look at how to use multithreading in Python.

15

JUNE

2021

How to Create a Subform in MS Access

In this episode, we’ll look at how to create a subform in Access.

11

JUN

2021

How to Use execute_stream to Execute Many SQL Statements with Python Connector for Snowflake

In this episode, I’ll show how you can execute many SQL statements from a local file directly against your Snowflake database.

8

JUN

2021

How to Create a Search Form in MS Access

In this episode, we’ll look at how to create a search form in Access.

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.

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: