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.

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

When to Excel and When Not To: Why Specialists Don't Use Excel for Data Transformations

Start your journey in data transformation, and learn why specialists don't use Excel to transform 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