Forum Discussion
Completeness of a product dossier (based on SharePoint)
Hi all,
I have received this interesting question from one of our customers. They have a Microsoft 365 subscription that includes Microsoft 365 Business Premium and Power BI Pro. They are actively working in SharePoint Online, that's where they store all their data. I think this is a Business Intelligence related question.
They import and export products and per product a standard set of documents should be created, i.e. a technical file, a test report, etc. They sell hundreds of products.
They would like to have a per product overview of how complete the dossier is, and make it measurable.
For example: The documentation for Product X is 75 percent complete, because the following documents are missing:
- X
- Y
- Z
Would it be feasible to generate such an overview in Microsoft 365?
Only thing I could think of is making sure there are content types created in SharePoint Online and leveraging managed metadata search.
Thanks for all help provided!
1 Reply
- christinepaytonIron Contributor
IMO your best bet here is to use Power BI; the OData connector is quite good at pulling file metadata. This would involve some DAX, so you'd need to dig into how that works a bit, but it would be totally feasible to do this with the tool, assuming that the files are reasonably consolidated (e.g. in a single library or a few libraries, not spread across 100+ sites). I have a video on how to use the OData connector to access file information here: https://youtu.be/yeIQ9jKln_I