Mirlan DzhumagulovFirebase, BigQuery and Tableau as a comprehensive solution for analytics of your mobile productIn this article I would like to speak about the pros and cons of using a custom analytical solution for your mobile product (app/game)…Mar 21Mar 21
Mirlan DzhumagulovHow to upload Pandas DataFrame to Google BigQuery tableThis is the short instruction-like article where I’m sharing my experience about uploading pandas dataframe to BigQuery storage using…Jan 1Jan 1
Mirlan DzhumagulovHow much does New smartphone cost in your working hours?This article is not typical for my data analytics blog, but in some way it also relates to analysis.Nov 8, 2023Nov 8, 2023
Mirlan DzhumagulovWebApp Retention rate calculation using data stored in BigQueryIn this article I would like to cover a Web Application use case of calculating Classic retention rate based on the data of events using…Oct 21, 2023Oct 21, 2023
Mirlan Dzhumagulov3 Python functions to help you extract data from AmplitudeIn this article I’ll provide 3 custom python functions to extract analytical RAW data from Amplitude service and transform it to the…Sep 18, 20231Sep 18, 20231
Mirlan DzhumagulovEvaluation of the Dota2 heroes effectivenessThis is the experimental article that has a goal just to introduce one of the many methodologies that can be used in evaluation of…Jul 31, 2023Jul 31, 2023
Mirlan DzhumagulovSQL cheatsheet (part 2)This is the continuation of the article SQL cheatsheet (part 1). The idea of the article series to help to refresh basic SQL knowledge for…Jun 20, 2023Jun 20, 2023
Mirlan DzhumagulovSQL cheatsheet (part 1)This cheat sheet will be helpful for those who need to refresh some basic knowledge of SQL after some time off or also could be helpful if…Jun 9, 20231Jun 9, 20231
Mirlan DzhumagulovCollecting RAW event data from Amplitude through APIThis article is a short instruction about how to collect RAW data of in-app events from Amplitude (https://amplitude.com/). It could be…Feb 17, 2023Feb 17, 2023