A tutorial using PostgreSQL, pgAdmin 4 and the Pagila Dataset. — The following tutorial will walk you through the following tasks: Download PostgreSQL and pgAdmin 4 to your own PC or environment. Connect to PostgreSQL server Download and load the Pagila database set (based on the famous Sakila training database). Provide resources and a link to a Github repository detailing these…

Using PostgreSQL and Pagila Database to practice creating and using ERDs Using pgAdmin 4 and PostgreSQL this article will demonstrate how to Create an Entity Relationship Diagram (ERD) of the Pagila Database to gain a greater understanding of the data you will be working with and to create a reference…

With a function to make it easier to produce and analyze them — With most classification problems a simple accuracy score just will not cut it. Because of this there are many different metrics available to data scientists who are looking to identify how well their model is working. There are benefits and drawbacks with having a plethora of measuring tools at your…

An interactive 3D geospatial tool — At this point in the early stages of my career in data science I haven’t worked with geospatial data to a large degree. In fact, it almost appears to me that some data scientists try to avoid working with geospatial data with the intent of leaving it to GIS professionals…

‘’Ouch!” my toddler son whined as I combed his jumbled tangles of thin but burgeoning hair. I painstakingly worked not to snag a curl, however, my efforts were in vain. His gentle whining created a question. Would he rather me “gently” struggle with this endeavor while causing modest pain for…