Forum Discussion

JoostvdLinden's avatar
JoostvdLinden
Brass Contributor
May 04, 2023

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

  • 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

Resources