Building a Hangman Game with Python (Step-by-Step)
Have you ever played Hangman? It's a fun guessing game that's easy to play and even easier to code. In this post, I'll walk you through…
Posted onHave you ever played Hangman? It's a fun guessing game that's easy to play and even easier to code. In this post, I'll walk you through…
Posted onAfter gaining proficiency in Python through learning and practice, I decided to embark on my own project using my personal data. Lately, it…
Posted onAs I was working for BI analyst already for some time, I have realized the importance of learning Python programming language, given its…
Posted onWe often hear phrases like: On average, an average person, average salary, average temperature, and so on. But what average exactly are we…
Posted onTableau - it’s a powerful data visualization tool. I wanted to make an experiment with Tableau, and as I recently found a very interesting…
Posted onThere are 2 effective tools when we need to group our data or to entitle new value. IF function The IF() function returns a value if a…
Posted onAnother way to make our queries easier is to use a view in BigQuery. A view is a virtual table with data, where the content is defined by…
Posted onA temporary table stores data within the database session, in which it was created. When the session is ended, the dataset is…
Posted onSubquery is a statement that appears inside another query statement. It is also called an inner or nested query. The inner query executes…
Posted onThe simplest query in SQL looks like this: If we want to group our column results or to order them in alphabetical or numerical order, then…
Posted onAs soon as we are logged in, in the Navigation menu (upper left corner), under the BigQuery we need to choose SQL Workspace. And that’s…
Posted onEvery beginner in data analysis comes to the idea that it is impossible to work like this. It is impossible to work without access to a…
Posted onThere are a huge amount of useful functions in Excel, that will cover almost every need. In addition to the functions, I have already…
Posted onExcel offers a wide range of tools for data analysis. I want to tell you shortly about my favorite, as I found it the most convenient and…
Posted onLet’s say, we have a dataset with a list of managers and the number of clients they manage. There are several ways to check the column with…
Posted onDocumentation is not what everyone likes, but what almost everyone needs. Especially data analysts. Working with data implies responsibility…
Posted onAs I was learning, I've often encountered files with a .csv extension. There is one quick and effective way to work with them more…
Posted onSQL is of course the sophisticated tool for data cleaning and analysis, but do not underestimate Excel. There are so many cases when the…
Posted onWhat should we do as soon as we get the data for analysis? We need to check it on 3 points: Data is relevant and can answer our question or…
Posted onLet's imagine, we work on a people-management project. We need to know, how satisfied our company’s employees are and what they think about…
Posted onFirst of all, what is the Data model? Data model - is a model that is used for organizing data elements and how they relate to one another…
Posted onYou can find a lot of different Data types browsing the Web. I want to write about some of them. First of all, we divide data into…
Posted onI am sure that everyone has had at least one such case when you open your computer and cannot find that "Untitled" file that you need so…
Posted onData is everywhere around us. It is in our smartwatches, GPS trackers, posts on Instagram, or reviews on Google. The amount of it is huge…
Posted onMy name is Maryna, and I'm going to write here about tips and insights that I have recently learned. After almost 7 years of being a…
Posted on