Intro

My name is Tyler, and I'm an analyst, a database administrator, and a general data and technology specialist for a local water utility company.

As an analyst, I work with fairly small data sets to find trends and patterns.  In water utilities, this can mean reviewing break rates on water pipes, customer water usage trends, or department efficiencies.  There's no one-size-fits-all tool for analytics, so you'll see me using anything from Excel (most common) to Tableau or r.  I'm finding new analytical resources weekly, so I'll share my favorites here.

As a database administrator, I handle a wide range of responsibilities.  Some databases I've created from scratch, including table and user interface design.  Others I monitor on a SQL server and consult with departments about their data entry techniques.  Still others I handle reporting to go along with the analytics noted above.  Most often this is done in Access simply for ease-of-access (sorry for the pun) when I don't have the full admin rights of our Tech Services department.  I've found some great tools in Access during the last year, and since I'm fairly new to the world of database management, I'll share some of these tools in more basic language here.

Since I'm also one of the data junkies and techies in my department, I get called on for a lot of troubleshooting, laptop setup, and software recommendations.  While these aren't the norm, I still find some great tools from time to time that I'll also share here.

Subscribe to be notified of new tools as I find them, or just look for me on your next Google search when you've hit a brick wall.

May your data be clear and concise,

Tyler

PS: Mine Datum is the term used for a point 1,000 meters below sea level, typically used as a rule of thumb for the deepest a mineshaft should run.  The implied pun is entirely intended.