Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please make the necessary adjustments to my star schema diagrams based on my professor's feedback, i'll also attach our KPI's for reference Your datasets include
please make the necessary adjustments to my star schema diagrams based on my professor's feedback, i'll also attach our KPI's for reference Your datasets include numeric measures such as KPI'S for the CPI dataset:
of spending on food per month
of change in CPI from January to December
Number of months with CPI increase per year
Average CPI spending per year
Number of months with CPI decrease per year
KPI's for the average monthly wages dataset:
Average per capita monthly income during the
second quarter of
The rate of change in an individual's average income
Average wage per nationality
Average wage per gender
Total average of wages earned per year
spending amount. I can see that you updated one,
but what about the other dimensional model? Should
the fact table include those attributes? Another way to
look at it is from the KPIs. If you are going to measure
the monthly income, where will you retrieve this data
from if it is not stored in the data mart?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started