Stop using Excel and Google Sheets as databases! Do this instead.
2021 Michigan IT Symposium Breakout Session from Wednesday, December 15 @ 2 pm
We all do it on a daily basis: we use Excel spreadsheets, Google Sheets, and Google Forms as databases, not only to manage administrative todos, but also to collect and share data. And why not? They're quick and easy to setup, which allows us to "get on down the road" and tackle the next item on our todo list. But inevitably, we then have to DO something with that data; summarize it, analyze it, share it, update it, change it. And most of us get to a point where the satisfaction from the initial "quick and easy" setup leads to the frustration of "Why did I do it this way?", "There's got to be a better way", or "I wish X had this feature!". Enter off-the-shelf (and often inexpensive) cloud databases. Gone are the old days of Microsoft Access and Filemaker. Now, there are dozens of options when it comes to easy-to-setup and use but versatile cloud databases, with familiar-looking forms and reports, but with the underlying power of automation and workflow processing. But with all of these options, which do you choose? How much will they cost? Where do I start? Well, come no further than this proposal!
Presenters: Mikhail Zolikoff, Michigan Medicine
Area(s) of Focus: Precision Health & Patient Care and Administration