We need to be able to get out of our XML/XLS datas various statistic informations, analyse them and create some graphics.
The data comes from the playlist of our TV channel. We have it in single XML files (one per day) or in a monthly XLS file containing all single day XML files.
We need to be able at any time, by analysing the data (single day or monthly file) to know :
- how many events from a category or group of categories were played (column CATEGORY)
- inside this category or group of categories, how many events from the sub category (column DIRECTOR) were played, and how many events from each different directors
- how many times an artist (column CAST) or a title (column TITLE) or a producer (column PRODUCER) was played
+ simple display and graphics or the results obtained by those requests.
This can be made using already existing softwares properly set to our needs, or custom software or web based software...etc
Example of requests :
How many events were played from category MUSIC VIDEO HITS and category MUSIC VIDEO ESSENTIALS from each DIRECTOR
How many events were played from category MUSIC VIDEO HITS and category MUSIC VIDEO ESSENTIALS from DIRECTOR "SCPP CTV"
you can find an example of file attached.