DEV Community: Collins Sigei

Git workflow

Collins Sigei — Sun, 30 Aug 2026 11:53:15 +0000

Git workflow: Working Directory, Staging, Commit and Push

This will demonstrate how to create folders, files, and pushing a data set to Github using Git.
Our data set is: Car Imports Analysis.

Create a folder in desktop

Barta@DESKTOP-I97ED39 MINGW64 /c/One Drive/onedrive/desktop
$ mkdir Car-Imports-Analysis

Create a data folder inside Car-Imports-Analysis

Barta@DESKTOP-I97ED39 MINGW64 /c/One Drive/onedrive/desktop/Car-Imports-Analysis
$ mkdir data

Create a file inside Car-Imports-Analysis

Barta@DESKTOP-I97ED39 MINGW64 /c/One Drive/onedrive/desktop/Car-Imports-Analysis
$ touch README.md

Add content to README.md file

Barta@DESKTOP-I97ED39 MINGW64 /c/One Drive/onedrive/desktop/Car-Imports-Analysis
$ echo "#Car-Imports-Analysis" >README.md

Used Nano terminal text editor to write the texts and display in README.md file.

Barta@DESKTOP-I97ED39 MINGW64 /c/One Drive/onedrive/desktop/Car-Imports-Analysis $ nano README.md

`Barta@DESKTOP-I97ED39 MINGW64 /c/One Drive/onedrive/desktop/Car-Imports-Analysis
$ nano README.md`

Barta@DESKTOP-I97ED39 MINGW64 /c/One Drive/onedrive/desktop/Car-Imports-Analysis
$ cat README.md
#Car-Imports-Analysis
##Project Overview
This project analyses the Car Imports data records for different car models in the respective years
##Tools Used
- Microsoft Excel
- Github
- Git
- Power Bi

Initialize the project with Git using git init:
Barta@DESKTOP-I97ED39 MINGW64 /c/One Drive/onedrive/desktop/Car-Imports-Analysis $ git init Initialized empty Git repository in C:/One Drive/OneDrive/Desktop/Car-Imports-Analysis/.git/
Connecting the local project 'Car Imports Analysis' to Github using SSH key:


Barta@DESKTOP-I97ED39 MINGW64 /c/One Drive/onedrive/desktop/Car-Imports-Analysis (main)
$ git remote add origin git@github.com:Collins-Sigei/Car-Import-Analysis-.git

The following are the steps towards pushing the project to Github:

Staging the project:

Barta@DESKTOP-I97ED39 MINGW64 /c/One Drive/onedrive/desktop/Car-Imports-Analysis (main)
$ git add .
warning: in the working copy of 'data/Car Imports Data Records.csv', LF will be replaced by CRLF the
 next time Git touches it

Commit

Barta@DESKTOP-I97ED39 MINGW64 /c/One Drive/onedrive/desktop/Car-Imports-Analysis (main) $ git commit -m "Add Car Imports Analaysis Records Project" [main (root-commit) 9a2d029] Add Car Imports Analaysis Records Project 2 files changed, 1009 insertions(+) create mode 100644 README.md create mode 100644 data/Car Imports Data Records.csv

Select and copy the SSH key from Github to gitbash
Connect local project to github

Barta@DESKTOP-I97ED39 MINGW64 /c/One Drive/onedrive/desktop/Car-Imports-Analysis (main)
$ git remote add origin git@github.com:Collins-Sigei/Car-Import-Analysis-.git

Push the project to Github

Barta@DESKTOP-I97ED39 MINGW64 /c/One Drive/onedrive/desktop/Car-Imports-Analysis (main)
$ git push -u origin main
Enter passphrase for key 'C:\Users\Barta/.ssh/id_ed25519':
Enumerating objects: 5, done.
Counting objects: 100% (5/5), done.
Delta compression using up to 4 threads
Compressing objects: 100% (5/5), done.
Writing objects: 100% (5/5), 48.25 KiB | 345.00 KiB/s, done.
Total 5 (delta 0), reused 0 (delta 0), pack-reused 0 (from 0)
To github.com:Collins-Sigei/Car-Import-Analysis-.git
 * [new branch]      main -> main
branch 'main' set up to track 'origin/main'.

Getting Started with Excel for Data Analytics: From Basics to Data Cleaning

Collins Sigei — Sun, 30 Aug 2026 11:27:22 +0000

Microsoft Excel

Microsoft Excel is a spreadsheet program used to calculate data, organize information, and perform detailed analysis. It structures data into rows and columns, allowing users to perform mathematical operations and create charts.

Excel User Interface

This entails the parts that the user interacts while using Microsoft Excel.

Ribbon - A large panel near the top holding tools categorized across tabs like Home, Insert, Page Layout, and Formulas.
Quick access toolbar - A small, customizable toolbar at the very top-left corner that holds frequent commands like Save, Undo, and Redo.
Name box - Located to the left of the formula bar, it displays the cell reference or address of your currently active cell (e.g., A1).
Formula Bar - A long input bar next to the name box used to type, view, and edit data or formulas inside active cells
Column Bar - The horizontal gray bar running across the top of the worksheet grid that displays letters (A, B, C, etc.) to identify each vertical column
Worksheet tab - A small clickable label at the bottom of the Excel window that represents an individual sheet inside your workbook.

Data Formatting in Excel

Changing visual presentation of data without altering its actual values.

Number Formatting

This involves changing the how the value looks in a cell without altering the actual value stored in the cell.

Select the Home tab
Go to the Number ribbon
Select from the dropdown options the appropriate format to apply to the data set.

Data Sorting

This is arranging the data set in a particular order, either from largest to smallest in numeric values and from A to Z in text form.

Data Filtering

This allows specific data to be isolated from a large dataset

Click any single cell inside a dataset
On the data tab, in the sort and filter section, select filter

Freezing Panes

This allows the selected column and row to be visible when scrolling through a large dataset.

Go to the view tab
Select the row and/or column that should be visible
Head to windows ribbon under the view tab and click on freeze panes

Data Cleaning

Process of ensuring that the data does not not have incorrect information, duplicates, inconsistencies and errors.

Step 1. Remove Duplicates

Expunge the repeated data from the dataset

Select the whole dataset through ctrl+A
Go to the Data tab
Under data tools ribbon, select remove duplicates
Check the box "My data has headers" and press Ok

Step 2. Formatting

Ensure the respective columns have the correct format type, that is numerical and text formatting to align with the values in that column.

Step 3. Find and Replace

Use this to remove inconsistencies in each column

Select the specific column and click ctrl+H
Input the category that is duplicated and replace with one term to refer the selected category
Replicate the process in the other columns

Step 4. Remove Blanks

Utilizing the find and replace method, remove the blanks from each column and replace with either 'unknown' or 'not provided'

Text Functions

=UPPER() Converts the text to uppercase
=LOWER()Converts the text to lowercase
=PROPER() Capitalizes the first letter of each word and makes the rest lowercase

Aggregate Functions

=SUM() Adds all numbers in a range together
=AVERAGE() Calculate the mean of a range
=MEDIAN () Finds the number that appears in the middle when arranged in a particular order
=MODE()Find the most repeated value in an ordered set
=MAX() Finds the highest value in a data set
=MIN() Finds the lowest value in a data set

Date Functions

=Today() Returns the current date
=Now() Returns both the current date and time
=Year()Extracts the year from a given date
=Month() Extracts the month from a given date
=Day() Extracts the day from a given date
=Datedif() Calculates the difference between two dates