Author: Sean Carney
-
Power Supply
Status: Built My power supply is based on the Erica Synths mki x es.EDU Power Supply. I created a 6 HP rack mount clone so I could bring the power switch and status LEDs forward to the front of the rack. Why hide the blinkenlights inside the case?
-
Building a Second Brain
Over the past year I’ve seen a good amount of hype around Diago Forte’s book Building a Second Brain and decided to add it to my reading list. I’m always skeptical when I see titles in the ‘Productivity’ category since it seems like most authors in the genre spend a lot to time evangelizing their…
-
SQL for accounting and finance professionals
If you’re an accounting or finance professional wanting to learn SQL, I’ve got good news: most of the knowledge you have of Excel or Google Sheets can be translated into SQL. Whether you’re looking at a spreadsheet or a database table, the core fundamentals are the same: it’s all about manipulating a big grid of…
-
Secure your Raspberry Pi by enabling automatic software updates
One of the biggest steps you can take to ensure your security online is to keep the software on your devices up to date and install any software updates that come out. This advice doesn’t just apply to your computers and phones, but also internet of things devices like a Raspberry Pi or BeagleBone Black.…
-
Calculating medians and quartiles across groups in SQL
One of the best ways to understand data is through the use of descriptive statistics, figuring out the minimum and maximum values, the median value, and the quartiles. When you’re working with smaller datasets this is easy, but with larger datasets you need to parse a lot of data to get these metrics. Luckily, you…
-
Getting started with your Raspberry Pi – Flashing an OS to a SD card in Windows 10
Once you get your Raspberry Pi, the first thing you need to do before you can use it is install an operating system. The Raspberry Pi is a bit unique since it has no on-board storage and only uses a micro-SD card for the operating system and user files. This guide walks you through how…
-
ETL in MySQL – How to automatically load data into a table every day
I’m working on a dashboard to track COVID-19 cases per capita in Calgary, and while the government’s open data API provides daily case counts within the city it doesn’t have any history available. The easy solution to this is to download the data on a daily basis and archive it myself, but I want to…
-
Installing MySQL 8 on Ubuntu 20.04
If you need a database for a project, MySQL is one of the most popular choices. It’s free, open-source and is a core part of of the popular LAMP (Linux, Apache, MySQL, PHP) web application stack. If you want to get started using MySQL for a project, here’s a guide of how to install it…
-
Secure your Raspberry Pi with a firewall
After you’ve changed the default username and password on our Raspberry Pi or BeagleBone Black, the next step to securing it is to install and configure a firewall. A firewall will help keep your device secure by limiting or block connections to the services running on your device, creating a far smaller attack surface that…
-
Create Professional Reports in Excel using R and XLSX
While R is the real workhorse of data analysis and modeling, if you want to share the results of your work with other people your probably going to send it in a spreadsheet. Luckily the xlsx package for R makes it easy to export simple spreadsheets and also has advanced functionality to create workbooks with…