Twitch Use Case

Link to Polish version

 

Problem:
The main objective of the project is to present trends among the gaming and e-sports community, which are of interest to game developers, marketing agencies, or the general online community.

 

Description:
The application is an aggregation of data about users and their achievements from a gaming-profiled streaming service.

The data is divided into two categories:

1.monthly content statistics based on data from sullygnome.com,

2.daily updates of the TOP 100 streamers from streamscharts.com.

The main idea behind the creation of the application was to show the full capabilities offered by MicroStrategy and how it cooperates with other tools. For this purpose, data was obtained using various techniques.

The user on their side receives an application that fully supports the statistical aspect of the project, as well as provides the ability to interact with the data through the addition of appropriate filters, time transformations, or visualizations. The report in this form is directed at people who expect a ready-made real-time summary, e.g. directors, managers, or employees making data-based decisions.

Technology:
Information from the sullygnome.com website uses the option of downloading monthly updates in CSV format – this process has been automated using Python and Knime. In the case of streamscharts.com, the provided REST API was used, which was implemented directly in MicroStrategy.

Leave a comment