The third session of the Data Science Club featured some excellent talks on data analytics in games and data warehousing. In case you missed it or would like to revisit some of the details, see the recordings.
The first speaker was Ivan Trancik, the CEO of Cellense – a company with extensive knowledge in the gaming business and insights that gaming companies can squeeze out from data that they collect. For market research they mostly analyze data from Steam to see what people play and how often, and Google Trends, to see what people talk about. Their insights then answer questions, such as why is your game not selling so well, or what the successful games do differently. Plenty of other data comes from the games themselves, which allows optimization of both, game play by modifying frustrating levels or monetization to offering relevant in-game purchases to various segments of players.
The second talk was by Tomáš Synek, a Division Director in Adastra, with many years of experience in designing solutions for managing and analyzing vasts amounts of data. He dove into the challenges that big organizations, such as banks or telcos, face when they design their data warehouses. Their data often comes from multitudes of sources, of varying quality, and needs to be processed into several levels of granularity and logic to provide value for different users of the data. He provided a thorough description of all components, in such a system, and showed us the stages of data modelling on this scale.
Tomáš was followed by his colleague Matúš Nagy, a DWH Consultant, who provided a deep dive into optimizing the performance of SQL queries. He showed us some of the common pitfalls and the steps to take when analyzing an underperforming query. In addition to the talk Matúš prepared Data Warehousing and SQL so you can try running these queries yourself on three types of common databases: Oracle DB, MySQL and Postgres. The session closed with the usual pizza and great discussions.
Please do not hesitate to get in touch with any of the speakers with any questions you may have, whether they are simple, incredibly difficult or about open job positions. We look forward to meeting you on the fourth session on Monday 27 October. Book your seat!