Research Database

[D33pV4lue]

I am in the process of modernizing my research database. Current version is an old axcess database for notes and folders with spreadsheets/other pertinent information. I am attempting to build the new one to house everything using Power Apps. When you click on an entry it will have a brief overview tab and tab to enter notes and attach files. 

 

Curious to know the system/process that others use? I am a Power Apps noob but it is low code and very customizable. With the help of AI I figure it can make it pretty funcational. Looking for things I can incorporate into the database that would be useful for searching or to reference when I look back.

[lnofeisone]

Download all your data and upload it to Google Cloud Storage. Buy Gemini subscription. Index your data. Check out Google AI Studio if you want a preview of what it can do. You can now search for anything you want and run analysis/analytics on top of any file (Excel, powerpoint, word, pdf) with built in extraction if you have any pesky tables that are stored in PDF. You can ask questions like "What was the PE of company X in 2008" or "What was the average PE for company X from 2008 to 2015."