CONTACT US: 778-373-4422 | info@mackenziemackenzie.com

Blog

Thanks for visiting my blog! I hope that you will enjoy your experience here, and also learn some cool tools and techniques that you can use toward your goals. Most of these techniques I learned or developed in my years of designing and deploying all kinds of solutions in my work. Aside from that, I find my work to be a lot of fun! Someone once said that I was like a dog with a bone when solving a problem. If you're like that an enjoy problem-solving, you're in the right place!


My goal is to empower people to take control of their data! To that end, I started a blog with some articles on how business and professional people can take advantage of tools and techniques used by data specialists. In over 20 years of development and support across many industries, I found that regular people are starved for an idea on how to take their data experience to the next level. In a new world with the massive amount of data being generated every second, there is a great opportunity to learn how to use it effectively.

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.

Read article

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.

Read article

How to Merge Pandas Dataframes in Python

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

Read article

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.

Read article

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.

Read article

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.

Read article

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.

Read article

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.

Read article

How to Handle VBA Errors in MS Access

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

Read article

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.

Read article

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.

Read article

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.

Read article

How to Use Union Queries in MS Access

In this episode, we’ll look at how to create and use a Union query in MS Access to combine the output of two select statements together.

Read article

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).

Read article

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.

Read article

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.

Read article

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.

Read article

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.

Read article

How to Create an Append Query in MS Access

In this episode, we’ll look at how to create and use an append query in MS Access to move data from one table onto the end of another.

Read article

How to Write Pandas Dataframes into Snowflake Using write_pandas

In this episode, we’ll look at how to write dataframes into Snowflake using the Snowflake connector and write_pandas.

Read article

How to Make a Multi-Select Listbox in MS Access

In this episode, we’ll look at how to create a multi-select listbox in MS Access.

Read article

How to Make a Pie Chart in Python

In this episode, we’ll look at how to make a pie chart in Python, using matplotlib and pyplot.

Read article

How to Create a Single-select Listbox in MS Access

In this episode, we’ll look at how to create a listbox for single-selections in MS Access.

Read article

How to Use the Nz Function to Handle Null Values in MS Access

In this episode, we’ll look at how to use the handy Nz function to replace null values in MS Access.

Read article

How to Make a Stacked Bar Chart in Python

In this episode, we’ll look at how to make a stacked bar chart in Python, using matplotlib and pyplot.

Read article

How to Make Multi-Column Combo Boxes in MS Access

In this episode, we’ll look at how to make multi-column combo boxes that give more information to the user.

Read article

The Battle over Microsoft Access

In this episode, we’ll explore the interesting history behind Microsoft Access and the unique role it played and continues to play in tech.

Read article

Getting Started with Python on Snowflake: The Snowflake Connector for Python

In this episode, we’ll learn how to install snowflake-connector-python in order to perform our first query against the Snowflake Big Data platform.

Read article

Three Ways to Remove Duplicates in MS Access

In this episode, we’ll learn three ways on how to remove duplicates from your MS Access output.

Read article

Group Data for Calculations Using groupby in Python Pandas

In this episode, we’ll learn how to use the groupby method in Pandas to group records with the mean (average), sum, min, max, first, and last calculation shown.

Read article

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.

Read article

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.

Read article

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.

Read article

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.

Read article

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

Read article

How to Use Functions in MS Access Queries

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

Read article

How to use def to create functions in Python

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

Read article

How to use Recursive SQL - A Simple Example

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

Read article

How to Use Option Groups with Radio Buttons in MS Access

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

Read article

How to Use List/Array Methods in Python

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

Read article

How to Compare Lists in SQL Server

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

Read article

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.

Read article

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.

Read article

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.

Read article

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.

Read article

Date Formats in MS Access

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

Read article

Parameterized Queries in .Net

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

Read article

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!

Read article

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.

Read article

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.

Read article

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

Today we learn how to group data by upper, middle, and lower thirds using TSQL’s PERCENTILE_CONT function.

Read article

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

Today we migrate data from Excel to Access using Python.

Read article

Coding for Kids 3: String Variables in Python

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

Read article

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

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

Read article

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

Animated Visualizations in Python

Read article

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

Use DataViews to Filter and Sort DataTables in ADO.Net

Read article

How to Make Cascading Combo Boxes in MS Access

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

Read article

How to Create Summary Statistics Using Python Pandas

This week we use Python Pandas to create some summary statistics.

Read article

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.

Read article

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.

Read article

Coding for Kids Ep. 2 - Variables in Python Part 1

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

Read article

How to Use Python to Query and Sort MS Access Data in a Pandas DataFrame

This week, we learn how to filter and sort data in a Pandas DataFrame using Python.

Read article

How to Open a RecordSet in Access VBA and Loop Through the Records

This week, we open a RecordSet in Access using VBA, so we can loop through the records.

Read article


Coding for kids in Python - Introduction

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

Read article

Pandas accdb DataFrame / How to install Pandas for Python

This week, we install the Pandas module for Python, and test it using MS Access .accdb data in a DataFrame.

Read article




Insert One Million Rows into SQL Server - How to Use SqlBulkCopy

This week, we show how to efficiently insert millions of rows using SqlBulkCopy.

Read article

Featured on Toptal

Learn how Sean may soon be featured on Toptal.



Read article

See Beyond the Numbers

This year Mackenzie & Mackenzie celebrates 20 years in Data.



Read article

Top 5 Tools for Data Analysts in 2020 - Python, SQL, Excel, DAX, Power BI

In this week’s video, we look at the top five tools for data analytics.



Read article

Python on accdb - How to Use Python on MS Access Data

This week, we use Python to use data in a MS Access database.

Read article

Why Your Economics Degree is Awesome for a Data Analytics Career

In this week’s video, I reflect on my Economics degree and it’s increasing value in analytics today.

Read article

Making a Delimited Column Using TSQL

Ever wonder how you can have one field with values from many rows in your table? This is a common problem in data transformation. Find out how to do it.

Read article

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

Ever wondered how to split one column into multiple columns?



Read article

Comparing Covid-19 Coronavirus Cases vs Deaths in 11 Countries Using a Scatter Diagram

In this video, we compare 11 countries to see a comparison of cases vs deaths on a scatter diagram.

Read article

How to Extract Data from SQL Server Using vb.Net, SqlClient, and ConfigurationManager

In our follow up video on our data extraction video for Oracle, we look at using similar techniques to pull data from SQL Server, then integrate that data with Oracle data in one dataset.



Read article

How I Learned Why Great Notification Is Important

Read how computers in 1984 caused me to think about notification.

Read article




How to Use vb.Net with ODBC and Configuration Manager to Extract Data From Oracle

Learn how to extract data from Oracle databases using vb.Net, ODBC, and ConfigurationManager.



Read article

The Professional Problem, 3 Things They Need, and 1 They Don't Have

Why do people constantly run into problems with their data, even when they are highly trained in their area?

Read article

Why Finding Uniqueness is the Key: 6 Methods to Help

Find out why keys and uniqueness are so important for data transformation and data analysis.



Read article

3 Reasons Why You Should Learn Data Techniques

Find 3 big reasons why you should learn data techniques if you are a professional or business person.

Read article raw data for analysis.

Read article

Why Your Data Analysis Toolkit Needs Microsoft Access

Understand why Microsoft Access skills are pretty much mandatory in the world of data analysis.

Read article




Why You Need to Avoid Dinosaurs and Learn Data Normalization

Find out why data normalization skills are so important in data analysis and data science.

Read article