Visualization Assignment

You are a Business Intelligence consultant for the University of Louisville. The Graduate Programs Curriculum Committee is considering revising the number of credits in their Full$-$Time $13-$Month MBA Program. They are considering increasing the number of credit hours, but before making that decision, they want to see how the FTMBA Program compares to a variety of other business schools. The Program Director, Sandeep Goyal, has asked you to gather program credit and length data and present it in such a way that would be help the Committee make its decision.

You will create two visualization pages for this assignment: Competitive Overview and ACC Comparison. You should pull in the file from the $$MBA Credit Hours$$ dataset on blackboard via PowerQuery. It will be important for your visualization that you select the correct data types.

The requirements for each page are found below.

Competitive Overview

$$ Matrix $($All fields included in one matrix$)$

o School

o Credits

o Months

$$ Slicers $($Each a separate slicer$)$

o KY Institution

o $14-$Month Completion

o Adjacent State

o ACC

$$ Cards $($Each a separate card$)$

o Number of Schools Represented

o Average Length

o Average Credit Hours

o UofL Length $($See Hint$)$

o UofL Credit Hours $($See Hint$)$

The page should include essential elements such as a title $($unless you feel the visual doesn$$t need it$),$ segmenting, and branding $($e$.$g$.,$ colors, logos$,$ fonts$).$ Visuals should not be left in their default format $($e$.$g$.,$ font, size$).$ Imagine that this report will be presented to the Program Director, Curriculum Committee, and Dean of the College.

ACC Comparison

$$ Clustered Column Chart

o Credit Hours by Institution

$$ Clustered Column Chart

o Months to Completion by Institution

$$ Slicer

o $14-$Month Completion

This page should be limited only to the ACC Schools through appropriate filtering. Make sure that UofL is clearly indicated as distinct from the other schools on the column chart. The page should include essential elements such as a title, segmenting, and branding. Visuals should not be left in their default format $($e$.$g$.,$ font, size$).$ Imagine that this report will be presented to the Program Director, Curriculum Committee, and Dean of the College.

Hint: For the cards on the Competitive Overview page that show UofL Length and UofL Credit Hours, you should hardcode these values into measures and use the measures in the cards. This ensures that these values are hardcoded and do not change with filtering.