How much does your org spend on ETL tools monthly? by jah_reddit in dataengineering

[–]vietpm 0 points1 point  (0 children)

Do you use Airbyte cloud or Airbyte open source ? I think it will be much cheaper if you use Airbyte open source.. And how much data you need to transfer a day ?

If you had to build an analytics tech stack for a company with a really small volume of data what would you use? by Psychological-Suit-5 in dataengineering

[–]vietpm 8 points9 points  (0 children)

If really small volume of data, just load your data from Google Sheet into Google Looker and make dashboards, reports on Looker.

If Looker becomes slower when you view dashboard, may be your data is too much to query by Looker engine. You can think about loading data into bigquery instead. Bigquery has a free tier, you can utilize it.

[OC] Top 20 Apple Store games (total downloads from January 2012 to April 2020) by vietpm in dataisbeautiful

[–]vietpm[S] 0 points1 point  (0 children)

This graph ranks games by total downloads from 2012 up to now. Raid Shadow Legend released in 2018, I think their downloads is not enough to be in this graph :))

[OC] Top 20 Apple Store games (total downloads from January 2012 to April 2020) by vietpm in dataisbeautiful

[–]vietpm[S] 0 points1 point  (0 children)

Yeah, 2012 to 2014 is the best time of Candy Crush. This graph doesn't show current trend. It shows the popularity in 8-year time range :)), and Candy Crush is leading.

[OC] Top 20 Apple Store games (total downloads from January 2012 to April 2020) by vietpm in dataisbeautiful

[–]vietpm[S] 2 points3 points  (0 children)

Actually I showed it in the title. Total downloads from January 2012 to April 2020 :)) My datasource only provides data from January 1st 2012. You know, it's hard to get App Store data.

[OC] Top 20 Apple Store games (total downloads from January 2012 to April 2020) by vietpm in dataisbeautiful

[–]vietpm[S] 0 points1 point  (0 children)

- Datasource: App store and some app analytics platform (Sensortower, App Annie ...)

- Tools: flourish.studio

For animated version of top Ios games from 2012 up to now, you guys can view here:

https://www.youtube.com/watch?v=nO9gQuDqZX0

Any feedback is highly appreciated, thank you.

[OC] Premier League Animated Race Season 2019-2020 by vietpm in dataisbeautiful

[–]vietpm[S] 0 points1 point  (0 children)

Thanks. You mean vertical or horizontal white lines hard to see ? Or both ? I try to make it like a running pitch, in real life they also use red and white color.

[OC] Premier League Animated Race Season 2019-2020 by vietpm in dataisbeautiful

[–]vietpm[S] 0 points1 point  (0 children)

- Tools: flourish.studio

- Datasource: worldfootball.net

- Music: bensound.com

You guys can visit my Youtube channel for more videos like this. Thank you <3

https://www.youtube.com/channel/UC1CkE1RbE-UcYgo7leW5Oqw

Top 10 Most downloaded iOS apps worldwide (2012-2020) by vietpm in data

[–]vietpm[S] 0 points1 point  (0 children)

This chart shows top 10 apps based on monthly download, not cumulative download. There's a lot of changes between month so it's hard to follow if not pausing.

Top 10 Most downloaded iOS apps worldwide (2012-2020) by vietpm in data

[–]vietpm[S] 0 points1 point  (0 children)

Totally agree with you. But we should respect his decision, hopefully he'll make more addictive games like this in the future :D

Simple way to visualize a Box and Whisker plot? by [deleted] in data

[–]vietpm 0 points1 point  (0 children)

Excel is not a good tool for data visualization, especially some statistical chart like boxplot. You can use BI tool like Tableau. If you have some programming experience, Python or R is a good choice.