I'm feeling quite frustrated as I try to resolve an issue. I currently have 19 tables (listed below), and I've been grappling with finding the most efficient model setup to ensure that my queries run effectively in Power Bi which is a new tool for me.
Quite a big ask. I dont want to put everything on here for obvious privacy reasons but also my data dictionery is quite large.
Any suggestions would be most welcome.
-
Beneficiaries Table:
- Columns:
- What is your current situation
- Post code
- Details of Medical Condition
- School Name
- Session Title
- Organisation
- Interested session
- Date of Birth (dob)
- ID
- Address
- Avatar
- Email address
- Mobile phone
- Other telephone number
- Website
- EDI Values
- Job Title
- Membership in any Networks/Forums
- Comments or Questions
- Message
- Relationship to young person
- Upload your CV
- Signed
- Emergency Contact Name
- Emergency Contact Relationship
- Emergency Contact Number
- Emergency Contact Email
- UpShot ID
- UpShot ID (text)
- Team Name
- Preferred Time
- Charity ID
- Created At
- Created By
- Name
- Updated At
- Columns:
Beneficiaries Categories Table:
- Columns:
- Charity ID
- Created At
- ID
- Is Default
- Is Stopped
- Name
- Updated At
- Columns:
Beneficiaries Types Categories Table:
- Columns:
- Beneficiary Cat ID
- Beneficiary Type ID
- Created At
- ID
- Updated At
- Columns:
Changes Table:
- Columns:
- Activity
- Created At
- Icon
- ID
- Name
- Participation
- Stage ID
- Updated At
- Columns:
Indicators Table:
- Columns:
- Created At
- ID
- Indicator Type
- Instruction
- Name
- Approved
- Ratio Set ID
- Stage ID
- Default Question
- Description
- Detail
- Icon
- Private
- Unit
- Updated At
- Columns:
Outcome Indicators Table:
- Columns:
- ID
- Indicator ID
- Outcome ID
- Updated At
- Columns:
Outcomes Table:
- Columns:
- Icon
- ID
- Title
- Updated At
- Columns:
Project Beneficiaries Table:
- Columns:
- Beneficiary ID
- Created At
- ID
- Project ID
- Updated At
- Columns:
Project Story Categories Table:
- Columns:
- Allow Sign Out Story
- Created At
- Display Intro Msg
- Display Respondent Name
- ID
- Is Stopped
- Project ID
- Story Category ID
- Updated At
- Columns:
Projects Table:
- Columns:
- Beneficiary Category ID
- Charity ID
- Created At
- ID
- Name
- Updated At
- Columns:
Ratio Sets Table:
- Columns:
- Created At
- ID
- Ratio Category ID
- Title
- Updated At
- Columns:
Stories Table:
- Columns:
- Beneficiary IDs
- Location
- Number
- Project ID
- Story Category ID
- Story Group
- Actual Created At
- Approved
- Charity ID
- Created At
- Edited By
- ID
- Text
- Updated At
- User ID
- Columns:
Story Beneficiaries Table:
- Columns:
- Beneficiary ID
- Created At
- ID
- Project ID
- Story ID
- Updated At
- Columns:
Story Categories Table:
- Columns:
- Color
- Created At
- Current Fields
- Description
- ID
- Intro Msg
- Is Default
- Is Stopped
- Name
- Scale Indicator Choices
- Story Privacy Data
- Updated At
- Columns:
Story Changes Table:
- Columns:
- Change ID
- Created At
- ID
- Known Beneficiaries Count
- Number
- Story ID
- Unknown Beneficiaries Count
- Updated At
- Columns:
Story Indicator Beneficiaries Table:
- Columns:
- Beneficiary ID
- Created At
- ID
- Indicator ID
- Indicator Type
- Number
- Outcome ID
- Story ID
- Sub Ratio ID
- Updated At
- Columns:
Story Indicators Table:
- Columns:
- Created At
- ID
- Indicator ID
- Indicator Question ID
- Known Beneficiaries Count
- Number
- Outcome ID
- Story ID
- Unknown Beneficiaries Count
- Updated At
- Columns:
Story Change Beneficiaries Table:
- Columns:
- Beneficiary ID
- Change ID
- Created At
- ID
- Story ID
- Updated At
- Columns:
Sub Ratios Table:
- Columns:
- Created At
- Default Criteria
- Default Points
- ID
- Name
- Priority
- Ratio Set ID
- Updated At
- Columns:
Tried many variations to model the data none of which is proving right