BOM = bill of materials
BIM = building information modeling
placing data within the model other than just the lines
The question— is this a one off project or is it a possible career?. If a one off, then as Alex said,
I checked the warehouse
if you download this then run a report (file menu / generate report) will get a data file which would give you an idea of the exported data
Now display the same warehouse example in layout, then attach a label call out to say the fan to get the attribute.
So for a one off you could sort the excel sheet manually and insert it in to layout as you previously mentioned.
However if this is a career, then one builds a collection of components and add meaningful data to them,The fan example instead of being 3 components of different sizes would be a scale_able dynamic component with options of your known stock and the ability to add a model, cost,style…or custom data. A simple fan-1 would refer to the imported table designed as you want with description and quantity.
Its all about time