Answered step by step
Verified Expert Solution
Link Copied!

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:
1-% of spending on food per month
2-% of change in CPI from January to December
3- Number of months with CPI increase per year
4- Average CPI spending per year
5- Number of months with CPI decrease per year
KPI's for the average monthly wages dataset:
1- Average per capita monthly income during the
second quarter of 2022
2- The rate of change in an individual's average income
3- Average wage per nationality
4- Average wage per gender
5- 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?
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Spatial Database Systems Design Implementation And Project Management

Authors: Albert K.W. Yeung, G. Brent Hall

1st Edition

1402053932, 978-1402053931

More Books

Students also viewed these Databases questions