Pi-Hole is a custom DNS server designed specifically to block ads, trackers, and malware. Pi-Hole can run from virtually any always-on hardware, including a Raspberry Pi, old PC, NAS, or Cloud Service.
See https://pi-hole.net/ for more information.
Here I will discuss my installation process, some initial results, and some extra resources. Read More
I recently had the pleasure of automating a reporting system for a client that required the use of an existing complex and pre-formatted Excel template with specific page breaks, merged cells, borders, and more. Here I describe how I was able to use Python and Excel together while maintaining the original template structure and formatting. Read More
Part 2 of how to use Power Query in Excel to retrieve data from ArcGIS Online. In this part I cover how to access secured resources. Read More
A guide to using Power Query to access ArcGIS Online Feature Services using Dynamic Parameters for an easy-to-update tool. Read More
Beginner tips and tricks for quickly navigating data in Excel. Read More
Tips and Tricks that make your map layouts easier to work with, including making multiple dataframes align, scales work, and legends snap to grids properly! Read More