---
title: "John Githui (@JohnMG) | Hashnode"
description: "I am learning data science and data analysis. Read the latest articles by John Githui on Hashnode."
url: "https://hashnode.com/@JohnMG"
---

@JohnMG

# John Githui

@JohnMG · Joined February 2023

I am learning data science and data analysis

### [Git and GitHub for Newbies: An Introduction to Version Control](https://johnmg.hashnode.dev/git-and-github-for-newbies-an-introduction-to-version-control?utm_source=hashnode&utm_medium=feed)

Say you are solving the Rubik’s cube, and you are a couple of steps toward the whole solution and at this point you get stuck. Maybe you would need to track back a few steps or get assistance from a friend to solve the cube’s puzzle. To do this, you ...

2 min read · [johnmg.hashnode.dev](https://johnmg.hashnode.dev/git-and-github-for-newbies-an-introduction-to-version-control?utm_source=hashnode&utm_medium=feed)

[May 28, 2023](https://hashnode.com/posts/git-and-github-for-newbies-an-introduction-to-version-control/6472c7e37e1e55a0ad1a4a8c)

### [Git and GitHub Essentials: Understanding the Basics](https://johnmg.hashnode.dev/git-and-github-essentials-understanding-the-basics?utm_source=hashnode&utm_medium=feed)

Git is a version control system used to manage and keep track of changes in software code. The changes can be hosted on a web platform i.e. GitHub. These two tools are essential for developers as changes are made in code daily. A basic introduction t...

4 min read · [johnmg.hashnode.dev](https://johnmg.hashnode.dev/git-and-github-essentials-understanding-the-basics?utm_source=hashnode&utm_medium=feed)

[1](https://hashnode.com/posts/git-and-github-essentials-understanding-the-basics/6472c6f27e1e55a0ad1a4a8a) [May 28, 2023](https://hashnode.com/posts/git-and-github-essentials-understanding-the-basics/6472c6f27e1e55a0ad1a4a8a)

### [Subqueries Unraveled: Exploring SQL’s Hidden Power](https://johnmg.hashnode.dev/subqueries-unraveled-exploring-sqls-hidden-power?utm_source=hashnode&utm_medium=feed)

As you work with tables and databases, sometimes you may require the output from one query, to act as input in another query, in order to get the desired output from the second query. This would require writing two queries. The first is meant to get ...

3 min read · [johnmg.hashnode.dev](https://johnmg.hashnode.dev/subqueries-unraveled-exploring-sqls-hidden-power?utm_source=hashnode&utm_medium=feed)

[May 22, 2023](https://hashnode.com/posts/subqueries-unraveled-exploring-sqls-hidden-power/646bdc979ae8f88189be0a76)

### [Visualizing Data in Excel: Charts and Conditional Formatting](https://johnmg.hashnode.dev/visualizing-data-in-excel-charts-and-conditional-formatting?utm_source=hashnode&utm_medium=feed)

These are visualizations used to visually represent data in bars and graphs. Not every stakeholder and user of data may be well-equipped with data skills. Charts are better used to relay information, and findings and pick up trends in data. To create...

3 min read · [johnmg.hashnode.dev](https://johnmg.hashnode.dev/visualizing-data-in-excel-charts-and-conditional-formatting?utm_source=hashnode&utm_medium=feed)

[May 22, 2023](https://hashnode.com/posts/visualizing-data-in-excel-charts-and-conditional-formatting/646bdad2c52d37b8f1cda910)

### [Excel Formulas: Mastering Data Manipulation](https://johnmg.hashnode.dev/excel-formulas-mastering-data-manipulation?utm_source=hashnode&utm_medium=feed)

The key thing to know about formulas is that they begin with an “ = ” sign. I feel like this is important to begin with because as a beginner I would always forget that, and start wondering why my formula is not working. Remembering this will definit...

7 min read · [johnmg.hashnode.dev](https://johnmg.hashnode.dev/excel-formulas-mastering-data-manipulation?utm_source=hashnode&utm_medium=feed)

[May 22, 2023](https://hashnode.com/posts/excel-formulas-mastering-data-manipulation/646bd9f7b4fab4b93d142bd0)
