Roman Zydyk's portfolio | Data analytics
I created Tableau basics online course focusing on beginners. It consists of theoretical parts as well as practice. The course covers the entire dashboarding lifecycle – firstly it focuses on data loading and data preparation then creating basics visualizations, formatting these vizes, creating calculations and parameters, working with analytics functions and the last step is …
In this analysis I took a look at the Forbes Billionaires over the past 10 years. Most of the Billionaires are Men from USA, aged 50-80 from Finance sector. During the past 10 years only Warren Buffett and Bill Gates were able to remain in the top 5. From the technical perspective I had to …
💧 – The most important liquid. How much water do we have? How much water do we use? Does everyone has access to safe drinking water? I decided to participate in the Tableau IronViz 2020 competition which is focused on Health & Wellness. I analysed water resources, water withdrawals and percentage of people with access …
Part of the bachelor thesis (in Czech). Scraped data from STIS using Alteryx Designer. Data cleaned and added information about addresses (geolocation using Google Maps API). Done some analysis on data quality (also mentioned in bachelor thesis) and overall analysis of table tennis teams location in the Czech republic. Useful for players, fans, clubs or …
How many women are in parliaments? Week 30 of the #makeoverMonday focused on number of women in parliaments. Historically, ~1 of 10 parliament members was a woman. As of 2019 the situation got a little bit more diverse with almost every 4th parliament member being a woman. Despite the fact that few countries did a …
Final (and winner) team project at the Data Science & Business intelligence Academy VŠE 2019/2020. Our task was to find some open data, clean them, develop a classification or regression model, tune it, and interpret it. We selected public data from the Czech police. Used the last 12 years. Merged all the files together (14 …
Can you differentiate between penguin species? 🐧 Wait, what? Well, for the week 28 of #makeovermonday we got penguin species dataset with attributes like bill depth and length, body mass and flippers length. I analysed data a bit and the result (and my first ever attempt for the #makeoverMonday) you can see below. As we …
Because I started playing tennis recently I was interested in the best table tennis players characteristics. So I did sort of very basic EDA on historic ATP players dataset. For the code and findings check out Kaggle notebook: < Back
Part of the Power BI task for Data Science & Business intelligence Academy VŠE. The task was to create Power BI dashboard using czech open data. We created Power BI dashboard analysing counterfeit findings of Czech trade authority. Dashboard shows data from Czech Trade Inspection Authority and informs about counterfeit products found in the Czech …
