Improve datamodel than the one I have

Power BI Data Model
1

Hello,
I have a report that tracks the credits of the employees where each employee has a job title/profession, and a Major they have/should have and the courses they should study and the number of credits they need to take.
I have MasterTrainingCredit table which has College,Major, Required Courses and credits required.
MasterStreamSubject table that has College,JobCode,Profession,Major.
CourseMap that has Course,RequiredCourses and the trainingPlan.
EmployeeDetails with Employee name,ID, their Manager and their Manager etc.
A fact table that has the details of Courses,Credits,When they Earned the credit,Name,ID and College.
Attaching a copy of my datamodel.
Appreciate if you could help me build a better datamodel.
LMSTest.pbix (138.1 KB)

Appreciate any inputs!! Thanks for the help.

2

Bumping this post for more visibility.

3

Hi @Vsb79 - I have looked at the Data Model and don’t see any issues. In case you have specific requirement similar to as raised in Show the Required Categories from DimTable when not present in FactTable for which I have already provided solution, then can help further.

Thanks
Ankit J

4

Hello @Vsb79, just following up if the response from @ankit help you solve your inquiry?

We’ve noticed that no response has been received from you since a few days ago. In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved.