free site design templates

Example work

Below are example projects using publicly available data.
TFWP

Dynamic Visualization of Approved Temporary Foreign Workers in Canada 2024, Q1

College scene

Wage Analysis of Employees at Ontario Public Colleges 

First, a visual analysis of the wages paid to executives and employees at Ontario colleges. The data is from the Ontario Sunshine list.

Second, a more in-depth analysis based on inferential and predictive machine learning models

Cloud work

See google cloud text analysis program

Google cloud programming

This Google Cloud application I wrote is a Docker app that can be run as a CloudRun service. It will authenticate to one's Google services (GMail or Google Drive) and read a series of documents/emails you specify. It will then conduct a text analysis and cluster the documents into thematic groups. The program generates a series of detailed visualizations and data files that can be downloaded and used for further analysis.

Telecommunications patents

Data analysis: telecommunications patents

This is a small part of an old research project. Here, I examine and visualize telecommunications patents from the USPTO. This is interesting because it shows the growth of international players, especially the Chinese (Huawei, in particular) over the past 15 years. 

Huawei topic modelling

Topic modeling examining the Huawei brand

Examines changes to people's perception of Huawei.

IO Table

This shows the economic relationships between different industries in New Zealand and China. The Power BI visualization allows for dynamic exploration of the graph.

Power BI - Data viz

I often work with networks. I thought it would be fun to create a dynamic visualization of the economic relationships between industries in New Zealand and China. The visualization uses OECD data from the international input output tables to show those ties. 

You can see the dynamic visualization and read more about my process here.

Bass forecasts

Using the Bass Model to Forecast Sales

This project shows how different kinds of communication goods ranging from newspapers to mobile phones were adopted in the USA and Canada. A simple Bass model is used to forecast sales for each good. A discussion shows how innovative consumers help sales relative to consumers that imitate others in their purchases. The historical data shows that modern consumer goods like personal computers and mobile phones have strong network effects that encourage consumers to purchase compared to other kinds of communication technologies like radio, newspaper or television.

Python machine learning

Python for machine learning

Jupyter notebooks are a popular way to experiment with data and present results to business stakeholders. These two examples show how I used modern machine learning techniques for predictive analytics. In these Coursera examples, I use logistic regression, xgboost and random forest models to model two different example problems:

1) Gaining insight into employee turnover and predicting workers most at risk of leaving the company.

2) Determining which customers are more likely to stop using the Waze driving application.  

Missle command clone

Invasion earth

Fun with Javascript

This is a fun missile-command clone I whipped up in a couple of hours programming with ChatGPT. 
Give it a try. (Opens a new window)

The images were done for free using free prompt-driven AI web sites.

Reports

Immigration

A Comparison of Real and Simulated Immigrants

While a Master's student, I worked in the research department at Statistics Canada on LifePaths. I examined how the simulation model's immigrants compared to the experiences of real immigrants using the Census and Labour Force Survey data. The goal was to determine how well the model performed on these new Canadians.

See the report here.

Canada shift share

Regional economic analysis paper

During my Master's I came up with a twist on the traditional shift-share method. Rather than look at changes the level of employment across industries and regions, we looked at the change in occupations across regions. We focused on the regions of Alberta during a resource boom period. Our work resulted in a paper.

Brox, J., E. Carvalho, and J. MacKay. 2010. “Regional Employment Changes in a Booming Resource Economy: A Modified Shift-Share Analogue Regression of Changes in Employment Patterns within the Economic Regions of Alberta.” Canadian Journal of Regional Science 33(2): 25–44.

See my research page for more recent examples.

Regional change...

Regional economic analysis

This is a regional economic analysis conducted after I graduated with my Master's in Economics, but before I started my PhD. My client was the York Regional Municipality in Ontario, Canada. The approach used is shift-share -- a popular approach to measuring regional economic growth. In this report, I measure changes in employment levels across different industries and regions of Ontario.

Here's the report.

Certifications

Contact: Jon MacKay