Alexandra Petra BergerWriting SQL for “the last value is the final” caseThere are times when we need to express kind of “the last one is the final” logic with SQL, meaning the last value met in a row should be…7 min read·Dec 3, 2023----
Alexandra Petra Berger4 Ways To Clean The Data in PandasOftentimes, if not always, data analytics don’t get to work with a clean and neat dataset, and the most effort goes into re-organizing…6 min read·Jun 20, 2023----
Alexandra Petra BergerTop 10 competitors in the videogame market. Dashboard with Tableau1 min read·Dec 8, 2022----
Alexandra Petra BergerInternet speed in regions of Russia — visualization with PlotlySimple visualization of data from speedtest.net. The visualization includes almost all regions: except Kamchatka, Crimea.1 min read·Jun 20, 2022----
Alexandra Petra BergerPulkovo (LED) Airport passenger traffic vizGot an idea to visualize my local airport data. What could be more of an easy way to get something interactive. Hub and spoke maps are…1 min read·Jun 13, 2022----
Alexandra Petra BergerGirls, poverty and hard-working in math:Excel dashboard “Student Performance” (dataset taken from Kaggle): Is there a relationship between success in math and social background…3 min read·Jun 10, 2022----