We have .csv files exported from Wistia (a video hosting service). These files contain video viewing data such as # of plays, hours watched, % viewed, etc.
We would like to get more granular information based on these data by breaking down each stat according to user, type of video, etc.
Please find the attached Excel file to see Wistia data (see "Wistia raw export" worksheet) and the type of information we'd like to extract from it (see "Information needed" worksheet).
We would then like to have a way of visualizing such information easily, for example if we want to see how many hours user X spends viewing video type Y.
Excel should be adequate for our purpose, but we are open to suggestions.