Topic: Data Cubes and Data Warehouse

Important:

$$ You are required to provide ALL data on the visible sides of each data cube.

$$ For your convenience, these are two suggested ways on how to provide your answers in this problem:

o Feel free to print the provided empty data cubes, hand$-$draw the cubes in a piece of paper and insert a readable image of the cube into your single answers document.

o You can also draw directly on the provided empty data cube using a drawing editor.

XWZ University has $4$ campuses across $2$ states: Michigan $($Detroit and Lansing$)$ and Wisconsin $($Madison and Milwaukee$).$

Let us consider the following table that contains the number of applicants and number of newly enrolled students per semester$/$year$.$

In the following questions:

$$ Campus refers to Detroit, Lansing, Madison, Milwaukee. These values must be shown in this order in your diagrams.

$$ State refers to Michigan, Wisconsin. These values must be shown in this order in your diagrams.

$$ Semester refers to Fall, Winter. These values must be shown in this order in your diagrams.

$$ Year refers to $2020,2021,2022.$ These values must be shown in this order in your diagrams.

$$

Raw Data:

Campus Semester and Year #Applications #NewEnrolled

Detroit Winter $202050001000$

Detroit Fall $202055001100$

Detroit Winter $202160001200$

Detroit Fall $202165001300$

Detroit Winter $202270001400$

Detroit Fall $202275001500$

Lansing Winter $20202000500$

Lansing Fall $20202200600$

Lansing Winter $20212400700$

Lansing Fall $20212600800$

Lansing Winter $20222800900$

Lansing Fall $202230001000$

Milwaukee Winter $20203000450$

Milwaukee Fall $20203100500$

Milwaukee Winter $20213200550$

Milwaukee Fall $20213300600$

Milwaukee Winter $20223400650$

Milwaukee Fall $20223500700$

Madison Winter $20204000600$

Madison Fall $20204050620$

Madison Winter $20214100640$

Madison Fall $20214150660$

Madison Winter $20224200680$

Madison Fall $20224250700$

Fill out the following data cube.

staye

You are required to schrew data in al visible sides of the dala cube