Alexandra Petra BergerMini plots (aka sparklines) using Seaborn and PandasHave you ever used sparklines, the powerful tool to show data trend, in Excel? If not, you are missing out and you should! However, it has…Aug 14Aug 14
Alexandra Petra BergerTrivial but tricky SQL tasksHere are samples of 2 test tasks I was asked on a tech interview. Even though there must be tons of similar posts on the similar topic aka…Aug 7Aug 7
Alexandra Petra BergerJoining SQL-Tables based on SUBSTRINGThe situation is as follows: we have two tables with similar (aka partially identical), yet different values, and we want to connect the…Aug 5Aug 5
Alexandra Petra BergerMastering SQL CASE: query for attribute having 2 sub-attributesHave you ever been puzzled by how to translate the following layout into SQL logic: you got two main domains, then sub-domain A and…Jul 19Jul 19
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…Dec 3, 2023Dec 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…Jun 20, 2023Jun 20, 2023
Alexandra Petra BergerTop 10 competitors in the videogame market. Dashboard with TableauDec 8, 2022Dec 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.Jun 20, 2022Jun 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…Jun 13, 2022Jun 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…Jun 10, 2022Jun 10, 2022