Skills matrix - SharePoint or excel data structure advice

[Adroitaops]

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. 

[amitchandak · Accepted solution]

@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/