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

MacKenzie & MacKenzie has been serving up superior data solutions across Canada since 2000. It is now primarily run by Sean MacKenzie, who advised and built mission-critical solutions for over 35 government and private companies across Canada and the United States. These include hospitals (7), health authorities (6), manufacturers & ERP (6), aerospace manufacturers (3), insurance companies (3) crown corporations (2). He is known for highly innovative process and technical designs, some of which qualified him for national research and development programs. Over the years the company undertook several internal projects, including the BillZone project.

This week's video:

Workshop: The Power Professional

Introduction

This hands-on workshop is an introduction to the power of data transformation, aimed at professionals in any industry who work with large amounts of data on a regular basis. It is a full-day course that runs from 9:00AM until 4:30PM, at one of our locations in downtown Vancouver.


The course allows participants to work with a seasoned expert to understand how they can leverage some basic data collection and transformation processes. These techniques can save huge amounts of time for those who know them. People who take the course typically discover the massive benefit of "low hanging fruit" that they never knew they could utilize.

They are empowered to get the right data, faster and more accurately than ever before.

To inquire about available times and how to enroll, please use the contact form below. For the contact form, Make sure to put a check mark in the "I'm not a robot" check box! CLICK HERE

Who Should Take This Course?

You often work with a lot of data, on spreadsheets, CSV files, or Access database files.

Engineers waiting on data extracts for analysis, then discovering that the extracts needed data-cleaning or transformation, then losing time getting spreadsheets to do the work.

Managers & Executive doing financial or operational analysis, discovering that the data was not what they expected, and realizing their reporting is flawed.

Researchers in university settings need to collect and transform large amounts of data for analysis. Often they are overwhelmed when the data they receive is not clean, or needs transformation.

Professionals in any discipline can take this course to improve their skills in data transformation and analysis.

What Will I Get by Taking This Course?

After taking this course, you will have real knowledge of what tools and techniques can be used to clean and transform data to support things like reporting, visualizations, and analysis.

1. You will learn how to examine "extract" or other data that has been provided to you.

2. You will learn how to compare and integrate data from many sources.

3. You will learn about data cleaning & transformation, using hands-on examples.

4. Participants will receive a follow up call after the course is completed.

5. Participants will receive two follow up emails.

6. Participants will get a preview of the power of automation and using code to do things like "walking a recordset", using tools like Python, Access, and VBA.

Latest News

25

MAR

2020

How to Split One Column into Two in Access Using the Split Function

Ever wondered how to split one column into two in Access? Check out my latest video on how to do it.

19

MAR

2020

Extracting Data From Oracle Using vb.Net

In our first video for the advanced playlist, we learn how to use vb.Net, ODBC, and ConfigurationManager to extract data from Oracle databases.

10

MAR

2020

Power BI Introduction

This week, we introduced Power BI using British railway data from the Office of Rail and Road in Great Britain.

29

FEB

2020

RDBMS Relationships

An introduction to relationships in RDBMS databases, and why you need to learn them if you want to do data analytics.

28

FEB

2020

The Power Professional

Scheduled date for the Power Professional workshop in downtown Vancouver. Maximum: 8 participants. Spots still available. Please use the contact form below to request a spot.

20

FEB

2020

SQL Inner Joins and Left Joins

You'll need to master these two joins as you get started in your journey in data analytics and data transformation.

13

FEB

2020

Simple Queries in Access

Watch as we start our analytics journey by linking some tables and making some simple queries in Access.

Contact Us

MacKenzie & MacKenzie Consulting Inc.

Address:
Suite 1500
701 West Georgia Street
Vancouver, BC V7Y 1C6

E-mail:
info@mackenziemackenzie.com


Social

MacKenzie & MacKenzie Consulting Inc.

Twitter

Contact Form
Be sure to click "I'm not a Robot" below!