And final schema and data
Assignment
Your task is to design visualization that you believe effectively
analysis and communicates the data and provide a short write-up (no more
than 4 paragraphs) describing your design. While you must use the data
set given, note that you are free to transform the data as you see fit.
Some sample Data cleanup and star schema-building tutorial with PowerBI
are provided in the links below, but you are free to use any ETL or
Visualization tool to clean and build the data model. Those tutorials
are just examples and you are not required to follow.
https://radacad.com/build-your-first-star-schema-model-in-action-power-bi-modeling-basics
https://radacad.com/get-started-with-power-query-movies-data-mash-up
Develop some interesting questions about the selected data set – put
yourself in the shoes of a data analyst, and think about all the
different kinds of analysis tasks that a person might want to perform.
Do NOT make all of your questions be about correlations or min or max
values.
Extra credit: Build ETL process to transform the source data into star schema, upload your ETL code, and final schema and data.