So I think I am doing something wrong. Since I had something set up before joining Enterprise DNA and after watching some of the videos I am attempting to clean up the model and follow some of the best practices. But I think the number of things I need to be able to do is further complicating what has to be setup and connected to what relative to the video demo.
So the only thing that existed at the time in this model was a central table called “Location Code” and that allowed me to use the ‘Enrollments’, ‘Registrations’, and ‘Expenses’ tables to look at Enrollments which is Headcount, Registrations which is courses taken by students that name up the headcount, and Expenses which is the cost of running a location. The ‘Registration’ table allowed me to calculate Revenue.
Now to complicate the things I need to be able to look at ‘Registrations’ by the individual student and leverage the demographic data about the student that would be found in the ‘Enrollments’. Since the Student ID repeats in both tables I cannot create a relationship between the two tables so I created a table of just the Distinct Student ID’s called ‘Student ID’ so that I could link the two. The problem is as setup I cannot use “Student ID” from the ‘Student ID’ calculated table and connect elements from both ‘Registrations’ and ‘Enrollments’. The next part of it is I created a ‘Completed Courses’ calculated table that counts registrations in the table ‘Registrations’ by Student ID, Academic Year, Academic Program, Academic Career. Because the other goal is to look at how many courses students are taken in an academic year. The goal is to be able to look for distinguishable traits (demographic variables from ‘Enrollments’ table) of students as they are group by the number of completed courses.
I wish I could deconstruct the entire Power BI setup and start anew but I cant. Thoughts, help?