Forum Discussion
Skills matrix - SharePoint or excel data structure advice
Hi,
trying to implement employee skills/competency matrix in the business. 10-20 employees with about 50 skills to be assessed (Levels 1-5).
would like to collect data/make assessments via forms or power apps to automatically populate SharePoint list or excel tables. Then import to power BI to dashboard, report, search.
seeking advice on how to structure this data? One or more tables? One long row of data for each employee, rating against each skill? Or seperate skills and employees tables? If so how to configure?
finally, will ultimately be using this data to identify people who are suitable for job offers which outline these same skills. So looking to another table of these jobs to bring into power BI to do some matching.
thsnks in advance for any advice or steers towards solutions.
Adroitaops , whatever you do, better you have start schema for analysis
refer these
https://www.sqlbi.com/blog/marco/2017/10/02/why-data-modeling-is-important-in-powerbi/
https://www.sqlbi.com/articles/the-importance-of-star-schemas-in-power-bi/
1 Reply
- amitchandakSuper User
Adroitaops , whatever you do, better you have start schema for analysis
refer these
https://www.sqlbi.com/blog/marco/2017/10/02/why-data-modeling-is-important-in-powerbi/
https://www.sqlbi.com/articles/the-importance-of-star-schemas-in-power-bi/