This post is a placeholder for a potential presentation.
It was submitted to DNUG Connections German User Group https://dnug.de/call-for-abstracts/
Abstract / Summary
This presentation presents a tool used at Continental for extracting data from HCL Connections into Excel.
The tool is implemented in Excel with vba/ macros.
It is available as open source here.
Duration: 30min-60min depending on interest, questions, how deep you want the tool to be explained (incl. implementation explanation or not).
- Feature highlights
- Implementation/ technology highlights
Use Cases / Feature highlights
Export a profile search into Excel
Fill User information from ConNext Directory
Based on email in a Table column
Extract also Profile Picture to Column as comment
Extract also Tags with Pre-filtering
Export Feed (e.g. Forum Entries) into Excel
Consolidation of Feed export aggregating over the number of result pages
Get&Transform/PowerQuery
See detailed post here
Network Reporting for Profiles based on Tags taxonomy
Based on this tool we can do a network tag-based analysis / report.
Example all Knowledge Brokers in the company with distribution over the tools/expertise areas they support.
One can handle the reporting either in Excel or PowerBI.
No comments:
Post a Comment