The background to this post was a request to provide an updated list of sites in our SharePoint environment for use as a data source in Power BI.
Columns with benefits
'Columns with benefits' and how you can find more than just titles in SharePoint Online
Reusable columns
Reusing columns is useful if you want to establish a consistent definition across lists and libraries. You can share the definition across multiple lists and libraries so that you don't have to recreate the column settings each time. A significant additional benefit is that when items are added to a reusable column they discoverable through search (the magic only happens after it has been populated). Reusable columns are called site columns in SharePoint.
