@Mark F. excellent question...I've learned a lot about property analysis from podcasts, books etc., but there are certain aspects of property analysis that I've had to learn mostly from experience.
I often think of property analysis in two ways:
First is "the paper assessment" (which includes the P/L spreadsheets, the appraisal, SQ footage, data on the local market, and all other info that can be easily conveyed on paper--or at least on a computer). You can learn a lot about "paper assessments" via podcasts, books, youtube videos, etc.--for instance, you can learn how to analyze a property's financials via podcasts, articles, etc.
Second is "the physical assessment" (which includes all of the things that CAN'T be easily conveyed on paper or on a computer--these are things that often require a skilled in-person assessment of the property and neighborhood). For instance, knowing where the load-bearing walls are, knowing what types of tenants the property will attract, knowing the routing of plumbing & condition of the sewer main, knowing how noisy the street is, knowing that the house has a serious settling issue or water diversion problem, and--importantly--knowing how the property could be changed to force appreciation/rent. These are all things that are NOT easily conveyed on paper. Moreover, many parts of the "physical assessment" cannot be easily learned via books, podcasts, etc. Instead, the best way to learn about these issues is through experience--personally viewing lots of properties and having discussions with GCs, PMs, and other pros...
Here's an example: I once bought a 2 br, 1 ba A property in an A neighborhood at a discount because it was on a moderately busy street that turned off retail buyers (but it wasn't so busy that it would turn off tenants). This is info that you only learn by visiting the property. The property had an unusually large entryway that didn't have much use, and small bedrooms that probably turned off other buyers (again, I only learned this by visiting the property). I bought the place knowing I could easily convert part of that entryway into a bathroom, and expand one of the bedrooms into the space--creating a nice large master suite. Because of the layout of the existing walls, and the routing of existing plumbing, ducts & electric, I knew it would be a fairly simple and inexpensive operation (again--I only knew this because I visited the property)...after the work was done, it transformed the place from a negative cashflow property (that mostly only appealed to college kids) into a cashflow positive property that appeals to couples, couples with a child, well-off single people, and pairs of housemates.
The "physical assessment" and the ability to see the potential of a property is a skill that can't be easily learned via books, youtube videos, etc.--because it requires actually going out and viewing a lot of different properties in-person, learning to spot opportunities that aren't apparent to other buyers, learning from GCs what is (and isn't) easily do-able, learning from PMs and agents about the local tenant pool and the unique dynamics of the neighborhood, etc., etc.
Books, podcasts, youtube videos are incredibly valuable, but there are many aspects of real estate that are best learned through direct experience.
