Quantifiably Good
Would you like to help us out? We would love your help! If you have an idea for an article, know someone who is doing cool stuff with data, or want to contribute an article for Datagami yourself then please contact us at contact@datagami.blog. You can also follow us or share the site with your... Continue Reading →
Earlier this year, I wrote a brief post about how to connect Snowflake to Esri's ArcGIS. That worked for version 10.4. When we upgraded to 10.7, the ODBC connection appeared to connect to Snowflake but wouldn't actually retrieve any data. Today, I finally was able to connect w/ some Esri folks to learn about their... Continue Reading →
Today, we're featuring a guest blogger. Kimberly Miles is a seasoned IT Leader with 10+ years of specialized experience overseeing technical program and data product management, driving product vision, strategy, and innovation. One of the obstacles to managing data is justifying why a data strategy is essential. For data-obsessed people like me, data governance is... Continue Reading →
Tip: Avoid using reserved words as object names. The other day, I chose a name for a schema in SQL Server that had some unintended consequences. I had created some audit tables to track historical changes and named the schema "audit". It didn't occur to me that "audit" is a SQL Server reserved word. I... Continue Reading →
Data migration can be incredibly daunting. Finding a home for every field, pixel, and document in a new system is like moving between libraries that have completely different classification systems. Or like helping an elderly relative move out of their decades-long home and downsize into a new apartment. Often it feels like being caught up... Continue Reading →
We started Datagami because we wanted to highlight positive uses of data. This month I was thrilled to be able to visit Bletchley Park – one of the most impressive and positive uses of data I know of. The town of Bletchley is just about an hour’s train ride north of London and Bletchley Park... Continue Reading →
This article is a collaboration with my daughter, Meghan Bailey. Each state gets an allotment of electoral college votes based on their population. States with a higher population get more electoral votes such as Texas' 38 (based on July 2019 estimated population of just under 29 million). Those states with a smaller population are allotted... Continue Reading →
This has been a year like no other, the effects of Covid-19 have impacted us all on personal and professional levels. In the first part of the year, I was looking at booking behaviors and worrying about the impacts to travel in Asia. By the end of March, I found myself obsessively checking Covid-19 statistics... Continue Reading →
The above graph was on the Georgia Department of Public Health site and it shows the top 5 counties with the greatest number of confirmed COVID-19 cases. At first glance, it appears that their case counts have been on the decline. That's great news! Except that it's not quite correct. Look closely and you'll see... Continue Reading →
I'm so excited! 314 Pie just delivered my dinner and it's baking as I write this. I ordered several different pies and was wondering how I was going to tell them apart. Then I noticed some shapes on the top of the crust - diamonds, rectangle and a triangle. Their cooking instructions showed the legend:... Continue Reading →
Yesterday wasn't a good day. I work on a small "team". We don't really interact as a team ought to. We end up working in silos because that is the path of least resistance. We lack any cross training, change control process, and basic communication. One developer deployed code into production without informing anyone. It... Continue Reading →