I have a new guide today in Towards Data Science on making the leap from spreadsheets to databases.
In what follows, I help narrow down the options by introducing three database model paradigms while also providing an example of a spreadsheet that particularly benefits by being converted into that model. You might wish to keep open a copy of your most problematic spreadsheet as you review these descriptions to try and diagnose the problem that landed you in spreadsheet jail and determine which database model is the best antidote.
These descriptions are written for project managers and executives with some tech-savvy trying to better understand their data needs. Data professionals whose companies have inadvertently stuck them in spreadsheet jail can also refer to this piece to find the language they need to advocate for the adoption of more robust database technologies.
The whole piece is available to enjoy at this link: https://towardsdatascience.com/choose-the-right-database-model-free-your-data-from-spreadsheets-8d1129626b42?sk=1df6ece94c700eef30d1c710d94000e2.