Problem $425$ points

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 diagramsRaw 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$

$1)$ Fill out the following data cube.

You are required to show data in all visible sides of the data cube.

$2)$ Provide the data cube that drills down the one you provided in question

$1)$ on Michigan Campuses

You are required to show data in all visible sides of the data cube.

$3)$ Starting from the cube in Question $1,$ we would like to pivot the $3$

dimensions as shown below.

Fill out the data cube provided below.

You are required to show data in all visible sides of the data cube.

$4)$ Fill out the following data cube.

You are required to show data in all visible sides of the data cube.

$5)$ Provide the data cube slice below for #NewlyEnrolled for Year $=2021.$

Fill out the slice provided below.