DEV Community: Gloria Adhiambo Awinja

Building an Interactive Excel Dashboard for E-commerce Product Analysis: A Case Study of Jumia Products

Gloria Adhiambo Awinja — Sat, 05 Sep 2026 21:44:47 +0000

Introduction

E-business platforms generate large amounts of product data, including prices, discounts, ratings, and customer reviews. When properly analyzed, this information can help sellers and businesses understand product performance and identify areas that may require attention.
For this project, I built an interactive Excel dashboard for Jumia product analysis. The project focused on transforming raw product data into a structured dataset, performing exploratory analysis, and presenting the results through an interactive dashboard.
The main objective was to investigate relationships between price, discount, rating, and customer reviews, while identifying products with strong or weak performance.

1. Project Objective

The main objective was to build an interactive Excel dashboard that could answer questions about Jumia product performance.
Specifically, I wanted to understand:
• Whether larger discounts were associated with more customer reviews.
• Whether highly rated products attracted stronger review engagement.
• Whether product price and rating appeared to move together.
• Which products had the highest and lowest ratings.
• Which products had the highest discounts.
• Which products generated the most reviews.
• Which products might require additional pricing, marketing, or product-quality attention.
An important consideration throughout the project was that reviews were treated as a proxy for customer engagement, not as a measure of sales or revenue.

2. Dataset and Business Questions

The dataset contained information about 112 Jumia products.
The analysis focused on product-level variables such as:
• Product
• Current Price
• Old Price
• Discount
• Rating
• Reviews
The business questions guiding the analysis were:

Does a higher discount correspond to more reviews?
Do highly rated products receive more reviews?
Is there a relationship between current price and rating?
Which products have the highest ratings?
Which products have the lowest ratings?
Which products have the highest discounts?
Which products have the highest number of reviews?
Are there products with high discounts but relatively weak ratings or engagement?

These questions helped determine which calculations, PivotTables, and visualizations were needed.

3. Initial Data-Quality Audit

Before making changes to the dataset, I performed a data-quality audit to understand the condition of the raw data.
The audit focused on:
• Number of rows and columns=116
• Blank or missing values =55 each for two columns
• Duplicate records =2
• Price ranges =2
• Misspelled column header=1
• Improperly written product names=1
One of the most important findings from the audit was the presence of missing ratings.
Out of the 112 products, 55 products had no recorded rating and review, meaning that approximately 49.1% of the products lacked rating and review information.
This was important because rating-based and review-based analysis could only be performed reliably on the products with available ratings.
The original dataset was preserved rather than overwritten so that the cleaning process remained traceable.

4. Cleaning and Preparation Decisions

The raw data was kept separate from the cleaned dataset. This ensured that the original data remained available for comparison and verification.
The cleaned dataset was then prepared for analysis by:
• Checking and correcting data types.
• Handling missing values where appropriate.
• Ensuring prices were treated as numerical values.
• Ensuring discount values were represented consistently as percentages.
• Checking rating and review fields.
• Creating additional analytical fields.
• Converting the cleaned range into an Excel Table for easier reference and analysis.
The cleaned table was named cleaned

5. Excel Formulas and Enrichment Fields

After cleaning the dataset, I created additional fields to support the analysis. Some of these tables were:
Discount Amount
The discount was calculated from the difference between the old price and current price.
For example:
= [Old Price]- [Current Price]]
Rating Categories
Products were also classified according to their rating to make it easier to analyze rating quality.
The categories were designed to distinguish products with poor, average, and excellent ratings.
For example:

=IF([Rating]="","Missing”, IF([@Rating] <3,"Poor”, IF([@Rating] <=4.5,"Average","Excellent")))

This classification made it easier to summarize rating performance using PivotTables.

These enrichment fields transformed the original variables into categories that could be used for business-oriented analysis.

6. PivotTable and Analysis Workflow

After preparing the cleaned dataset, I created PivotTables to summarize the data. This was vital because some of these tables would bring about slicers and graphs that would be used to represent data on the dashboard.
The PivotTables were used to investigate:
• Distribution Rating.
• Discount distribution.
• Price versus rating.
• Engagement by discount category.
• Top products by rating.
• Bottom products by rating.
• Top products by discount.
• Top products by reviews.

7. Relationship Analysis

To investigate relationships between numerical variables, I created scatter plots with trendlines.
The three relationships analyzed were:
Discount vs Reviews
The calculated correlation for this was 0.0440, which indicated a very weak relationship.
The analysis therefore did not suggest that discount percentage strongly explained differences in review engagement.
Rating vs Reviews
The calculated correlation was 0.0572, indicating a very weak positive relationship.
This suggested that rating alone did not strongly explain differences in review engagement.
Current Price vs Rating
The calculated correlation was 0.1101, indicating a very weak relationship.
The analysis therefore provided limited evidence of a meaningful relationship between current price and rating.
These analyses however, reinforced an important lesson, that a single variable should not automatically be treated as the main driver of product performance.

8. Dashboard Design and Slicer Connections

The final stage of the project was to transform the analysis into an interactive dashboard. At the topmost of the Dashboard was the heading/header written in bold formart and a large font size. Beneath it was 5 key performance indicators commonly known as KPI's. They included
• Total Products: 112
• Average Current Price: Ksh 1,186.89
• Average Discount: 0.365089286
• Average Rating: 3.889474
• Total Reviews: 723
Beneath this KPI's were three slicers that allowed the dashboard to be filtered interactively. To do these it was paramount to Report connection by right clicking while your cursor is on a slicer and choosing "Report connection" , The slicers used were:

Price Category-it categorized data into High price, Low price and Medium Price.
Discount Category-it categorized data into High discount, Low discount, and Medium discount
Rating Category- that categorized data into average, excellent, poor and missing for missing values.

Charts were located beneath these slicers and used to communicate patterns in the data.
The dashboard was designed to allow users to move from an overall view of product performance to more specific product-level analysis.

Besides the chart I created a recommendation table that would inform the Jumia sellers.
It is also important to note that when building a dashboard, Presentability and neatness are key, the colors used in the graphs, dashboard background and headings must be consistent.

9. Key Findings

High-Engagement Products
The top 10 products by reviews accounted for 388 of the 723 total reviews, representing approximately 53.7% of all reviews in the dataset.
The 120W Cordless Vacuum Cleaner had the highest review count with 69 reviews, followed by the 137 Pieces Cake Decorating Tool Set with 55 reviews.
This shows that review engagement was concentrated among a relatively small group of products.
Top-Rated Products
The top 10 products by rating had an average rating of 4.94/5.
Seven of these products had a rating of 5.0, while the remaining three had ratings of 4.8.
These products could provide useful benchmarks for understanding characteristics associated with positive customer experiences.
Low-Rated Products
The bottom five products by rating had an average rating of 2.12/5, compared with the overall dataset average of 3.89/5.
The lowest-rated product was the Wall-Mounted Sticker Punch-Free Plug Fixer, with a rating of 2.0/5.
These products may require investigation before additional marketing or promotional resources are allocated to them.
Highly Discounted Products
The top 10 products by discount had an average discount of 54%.
The highest individual discount was 61%, recorded for the Pen Grips for Kids Pen Grip Posture Correction Tool for Kids.
However, the relationship analysis showed that discount percentage had only a very weak relationship with reviews. Therefore, larger discounts should not automatically be assumed to produce stronger engagement.

Screenshot of original data, cleaned data, pivot tables, and Dashboard.

To to attach a face to our long article I have uploded the four most vital images that were generated in this analysis but most of all a view of the dashboard that was created.

a) The original data

b) The Cleaned Data

c) Pivot tables

d) Dashboard

10. Business Recommendations

Based on the analysis, several recommendations can be made.
1. Prioritize High-Engagement Products
Since the top 10 products accounted for approximately 53.7% of all reviews, sellers could identify what these products have in common and prioritize similar products for visibility, promotion, and inventory planning.
2. Test Targeted Discounts
Medium-discount products recorded the highest total reviews at 348. However, the correlation between discount and reviews was very weak.
Rather than relying on large discounts across all products, sellers should test targeted promotional strategies and evaluate their results using multiple performance indicators.
3. Investigate Low-Rated Products
Products with consistently low ratings should be investigated before receiving additional promotional investment.
Possible areas for investigation include product quality, product descriptions, customer expectations, and fulfillment experience.
4. Use Highly Rated Products as BenchmarksThe highest-rated products can be examined to identify practices that may contribute to positive customer experiences.
These could include product quality, accurate descriptions, competitive pricing, and reliable fulfillment.
5. Use Multiple Metrics for Decision-Making
Because the relationships between price, discount, rating, and reviews were weak, sellers should avoid relying on a single metric when making business decisions.
A broader analysis incorporating sales, revenue, listing age, customer feedback, and other product-level factors would provide stronger evidence.

11. Limitations

This analysis has several limitations.

No sales or revenue data: The dataset does not contain actual sales, revenue, profit, or conversion data. Reviews were therefore used only as a proxy for customer engagement.
Missing ratings: 55 of the 112 products, or 49.1%, had no recorded rating. This limits rating-based comparisons.
No listing-age information: The dataset does not indicate how long each product had been available. Older listings may naturally have more reviews.
Correlation does not imply causation: The correlation analysis identifies relationships between variables but cannot establish that discounts, prices, or ratings directly cause changes in review engagement.
Limited customer information: The dataset does not contain detailed review comments, product-quality measures, seller information, or delivery performance.
Dataset size: The analysis covers 112 products and therefore should not automatically be generalized to every product on Jumia or the wider e-commerce market.

Conclusion

The Jumia Product Performance Dashboard transformed raw e-commerce product data into an interactive analytical tool covering 112 products.
The analysis showed that discount, rating, and current price had only weak relationships with the available review data. At the product level, however, engagement was concentrated among a smaller group of products, while a separate group of products had notably low ratings.
At the same time, the limitations of the dataset highlighted the importance of combining reviews with additional business information such as sales, revenue, listing age, and customer feedback. Additionally, the importance of having a good dashboard in a business was seen.

Project Resources

The complete project files are available in my GitHub repository and include original data, cleaned dataset, analysis, PivotTables, dashboard, and supporting documentation.

GitHub Repository link
https://github.com/gee-999/JUMIA-PRODUCT-PERFORMANCE-PROJECT

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

Gloria Adhiambo Awinja — Sun, 30 Aug 2026 20:26:55 +0000

Introduction

Microsoft Excel is an application that was developed by Microsoft as a tool for organizing information in rows and columns, performing calculations and presenting data. Overtime, excel has evolved into a powerful tool for data analysis.
Data specialist adopted excel and begun using it for various purposes including data entry, cleaning, organizing, storing, calculating, and validating data among others.
In this article we will be learning the basics of excel and data cleaning in the process of data analysis. We will use example to see how we can convert raw data into meaningful data that can be used to generate powerful insights.

Overview

1.Understanding the Excel Interface
2.Data Types
3.Functions
4.Data Analysis

i) Understanding the Excel Interface.

The first time you open an excel worksheet you will be met by a book like image with a toolbar panel at the top referred to as a ribbon, beneath it on the left a bar referred to as a name box, and next to it is what is referred to as a formular bar, at the center and what covers the main area is a worksheet frame with rows and columns, with each having a column and row header. The rows are numbered from 1 to 1,048,576 while the Columns are named from A to XFD.

An example of a worksheet would be like the one bellow.

The different parts of a worksheet are precisely named in the image below:

For a better understanding we shall define the parts labelled in our image above.

Control Menu/Box- Opens a menu with commands for controlling the Excel window, such as minimizing, maximizing, or closing it.

Quick Access Toolbar-Provides quick access to frequently used commands, such as Save, Undo, and Redo.

Ribbon-The main area at the top of Excel that contains the different commands and tools used to work with a workbook.

Ribbon Category/Tab- Organizes Excel commands into different tabs, such as Home, Insert, Page Layout, Formulas, Data, and Review.

Title Bar- it displays the name of the current workbook along with the name of the Excel program.

Help Button- Opens Excel's help and support features, allowing users to find information or guidance when needed.

Worksheet Frame- This is the main part of the Excel window where the worksheet grid and its contents are displayed.

Select All Button- Selects the entire worksheet at once, including all rows and columns.

Name Box- Shows the location or name of the currently selected cell, such as A1. It can also be used to move quickly to a specific cell.

Active Cell-The cell that is currently selected and ready for data entry or editing.

Dialog Box Launcher- A small button that opens a dialog box containing additional settings and options for a particular group of commands.

Insert Function Button (fx)- Helps users find and insert functions into formulas without having to type the entire function manually.

Column Headings- The letters at the top of the worksheet that identify each column, such as A, B, C, and D.

Row Headings-The numbers along the left side of the worksheet that identify each row.

Formula Bar- Displays the contents of the selected cell and allows users to enter or edit data, text, and formulas.

Category Groups- Groups related commands together on the Ribbon, making it easier to find and use the tools needed for a particular task.

Worksheet Area- The main grid made up of rows and columns where users enter, organize, and view their data

workbook- is an excel file that contains one or more worksheets.

Split Boxes- Divide the worksheet window into separate sections so that different parts of the worksheet can be viewed or scrolled at the same time.

Scroll Bars- Allow users to move around the worksheet vertically or horizontally to view areas that are not currently visible.

Sheet Tabs- Allow users to switch between different worksheets within the same Excel workbook.

Insert Worksheet Button-Adds a new worksheet to the current workbook, making it possible to organize information on separate sheets.

Status Bar-Located at the bottom of the Excel window and displays useful information about the current worksheet, selected cells, and other activities.

View Buttons-Allow users to change how the worksheet is displayed on the screen.

Normal View-The standard Excel view used for entering, editing, and working with data in a worksheet.

Page Layout View- Shows the worksheet in a format similar to how it will look when printed, including page boundaries and margins.

Page Break Preview- Shows where Excel will divide the worksheet into separate pages when the document is printed.

Zoom Slider- Allows users to increase or decrease the size of the worksheet displayed on the screen, making it easier to view the data.

Data Types

Now having understood the excel interface we will look at the different data types catered for in the excel working space.
They include:

Numeric-data type that contains only numbers.
Text-data types that contain text and strings
Date-contains date which includes, days, months, and years.
Time-contains the time
Currency-contains the different currency like KES and $
Boolean-refers to the data that generates TRUE and FALSE values.

Functions

Functions refer to predefined formulas in excel that perform specific calculations.
In our article today we are going to look at text, numeric, date and COUNT Functions used in excel.

a.)Text function

In excel you will encounter text function like
Upper function, Upper()-is used to change a given text into uppercase.
Lower function, Lower()-is used to convert a given text into lowercase.

Proper function, Proper()- is used to convert a given text into proper case E.g. Mary Ann

Find function, Find()-its a function that is used to find a certain text within another text.

Left function, by Left()-is used to extract a specified number of text to the left of a text string.

Right function, right()-is used to extract a specified number of text to the right of a txt string.

Length function, Len()-is used to count the number of characters in a cell or text including spaces.

Mid function, mid()-extracts a specific number of characters from the middle of a string.

CONCAT function, CONCAT()-it is used to combine text from two or more cells into one

b.) Numeric Functions and Operators

Operators refer to symbols used in excel to perform calculations.
These operators include:

Arithmetic Operators which involve: i) Addition (+) ii) Subtraction (-) iii) multiplication (*) iv) Division (/) v) Exponent (^)

c.) Mathematical functions

i) Power()
ii) sqrt()

d.) Aggregate Functions

In addition we have aggregate functions which can be used to work on a group or range of numbers and give one output.
PRODUCT()
MIN()
MAX()
MODE()
MEDIAN()
SUM()
AVERAGE()

e.) Date Function

These are functions used to create, extract, calculate, or manipulate dates and times in excel
They include:
TODAY()
NOW()
DAY()
MONTH()
YEAR()
DATEDIF()
NETWORK()

f.)Counting Functions

These are functions that are used to count cells or values in a range.
They include
COUNT()
COUNTA()
COUNTBLANK()

e.)Conditional Aggregation Functions

We also have another set of functions that are used to calculate or summarize data only when certain conditions are met.
This functions can be used with both numerical and text data types. They include:
SUMIF()
SUMIFS()
COUNTIF()
COUNTIFS()
AVERAGEIF()

Data analysis

The process of analyzing data in excel begins with having data, then cleaning the data and ensuring each entry is in the correct order, and finally analyzing it to get answers to the questions at hand. We shall define some more labels that will be paramount in our journey to analysis our data.

Data cleaning: This is the process of finding and correcting or removing inconsistencies in a dataset so that the data is accurate and ready for analysis.

Data validation: refers to a feature that is in excel that controls the type of data that a user can enter into a cell, and if entered at a later time when we have our data it prevents entry of current data that is not coherent with the type of data specified.

Conditional Formatting : this refers also to an excel feature that automatically changes the outlook of a cell when they meet a specified condition.
Sorting: these refers to arranging data in a particular order.
sorting is unique for numeric, text, and date data types and custom filter where you use your own condition.
In numeric Sorting numbers are sorted from largest to smallest or smallest to largest
In text sorting sorting occurs either from A to Z or Z to A
While in date sorting its done from oldest to newest or newest to oldest.
Above that we have multilevel sorting where we sort data using more than one criterion, one after another.

Filtering: is the process of displaying only the data that meets specific conditions while temporarily hiding the other data.

Just like sorting filtering depends on the data type, where we have text filters having criterions like equals, does not equal, Begins with, Ends with, Contains, Does not contain, meanwhile number filters have criterions like Equals, Does not Equal, greater than, less than, less than or Equal to, Between, Top 10 and

date filters containing criterions like equals, before, after, Between, Today, Tomorrow, Yesterday, This week, Last week etc.
custom filters on the other hand is used where you use your own conditions.

Now we shall look at an example that puts to practice every information that has been discussed in the article.

Lets say we have a data called Nurses salary. Our data contains different column entries including Nurses id, first name, last name, age, country, year of employment, salary and the type of shift each does.

The image below shows a sample of the data we are working with.

It is important to note that before begin anything with your data you must have two worksheets, one which contains the original data, and the other named cleaned which you will be cleaning and carrying out your analysis

i) cleaning the data

The first thing is to remove duplicates- Select your data range or press Ctrl + A to select the whole table. Go to the Data tab on the top ribbon. Click Remove Duplicates.

1.cleaning numeric data example

Point to note in our data set is that the age column seems to have age appearing on the left side of the column instead of the right. All text appear on the left and numeric data to the right. Our data seems to have a problem with data type so we will go to Home-Number tab-select numeric

after correction

In the salary column you will also note blanks, where there is no entry, for numeric we leave it like that.

2.Cleaning date example

the first entry contains a different format of the date so we are required to change it into one format

3. An Example of cleaning Text Data

Firstly, check if there are any blanks in text columns and convert them to unknown Using ctrl+H that enables you to find the blanks and replace them.

then click on replace all

The text data my contain text not written in proper format like names.
for example look at our screenshot below.
we are required to right click in the columns header-insert column, and use the function Proper to change the names into proper format.

create yet another final column that you will copy the entries from the column first name p to, to avoid having reference errors when the column first name is tampered with.

delete the other columns and remain with the last created column named first name proper.

Conclusion

Excel provides a simple and practical starting point for data analytics because it allows users to organize, examine, clean, and prepare data within a single application. Understanding basic concepts such as rows, columns, cells, cell references, formulas, and functions creates a strong foundation for working with datasets. Through the practical dataset used in this article, it has been demonstrated that Excel can be used to identify and correct common data-quality problems such as missing values, duplicate records, inconsistent text entries, and incorrect data formats. Features such as sorting, filtering, tables, and functions make the cleaning process more efficient and help ensure that the resulting dataset is accurate and consistent. Overall, data cleaning is an important step in the data analytics process because the quality of analysis depends largely on the quality of the data being analyzed. By mastering these basic Excel skills, beginners can confidently move from raw data to a clean, structured dataset that is ready for further analysis and visualization.

PUSHING A LOCAL FOLDER TO GITHUB USING GIT AND SSH.

Gloria Adhiambo Awinja — Sat, 22 Aug 2026 21:30:01 +0000

Introduction

As a beginner in the data industry it is paramount to understand that projects are often created and stored locally on a computer before being shared or backed up online. Therefore, the first step into the journey of a data specialist becomes to learn the simplest yet most important thing: How to transfer these folders or files in your local PC into GitHub. This article will show you how to transfer locally created directory to GitHub using Git and a SSH key.
Git Bash commonly known as Git is a tool installed on your computer that tracks and manages changes made to your projects' files and folders. GitHub on the other hand, is an online platform where you can store your Git projects. The platform enables you to access, share, and collaborate on the project from anywhere. Meanwhile, an SSH key is a secure digital key that allows your computer to connect to your GitHub account without repeatedly entering a password.
In this article I will show you how to create or access your local folders and files using git and transfer them to a GitHub platform with the use of a SSH key.

Overview

The article will contain:

How to create a local Directory
Initializing Git
Adding Local Directories to the Staging Area
Committing the Project
Connecting the Local Repository to a Remote Repository
Understanding the SSH KEY
Pushing the Project to GitHub Using a SSH key

A. Creating a Local Directory

Steps to Creating a Local Directory.

NB: We will use Sales Project as an example of our project directory.

The first step in creating your local project directory is to check your current working directory. This is done by opening the Git terminal and writing the command:

pwd

This command simply asks, where am I right now?

After knowing where you are, you can now create a project directory in the location you are currently in or open a new location you would like the directory to appear.

Lets say we want to create a directory called Sales Project, and we would like it to be located in the Desktop directory. What we require is to open the desktop directory and create our sales project directory there.
To open the Desktop Directory we use a command cd which allows us to enter into a directory of our choice as long as the directory exists in our local PC. So our code would be:

cd Desktop

Now, having opened the desktop folder, we want to create our sales project directory. To create a folder we are required to use the command mkdir.The code appears as:

mkdir "sales Project"

Now, when you check your Desktop, you should be able to see a folder called Sales Project.

You can also check for the presence of the folder by using ls under the directory Desktop. ls is simply a command we use to show the files and folders in your current location.

After creating our sales project directory we are required to create a README.md file. A README.md file is a document that is created using markdown language and is used to explain what the project is about, the tools used, how it works, and other important information concerning the project. It helps users understand a project without having to read the code.

To create it we use the command touch , the code appears as:

touch README.md

Afterwards we can create a folder That will contain all the data used in the project in question. For example our data could entail excel files, screenshots and pictures. Lets say our folder is called DATA, then we will have to create it by coding:

mkdir DATA

With these steps we would have successfully created our folder called Sales Project, which contains a README.md file and a folder where we can place the data we are working on called DATA. So in summary the codes of creating this directory in our PC would be:

pwd
cd Desktop
mkdir "Sales Project"
cd Sales Project
touch README.md
mkdir DATA

B. Initializing Git

When we say Git initialization we refer to the process of enabling Git to start tracking a particular folder as a Git repository.
In our example, when we initialize git we are enabling the ordinary directory we called Sales Project to be turned into a git repository where changes made to it can be tracked.
To enable this we use the command:

git init

c. Adding Files to the Staging Area

After initializing, we are required to tell Git which changes we want to include in our next commit. For this to be possible we use the command:

git add

Now depending on the changes in the directory you want to stage you will use different ways to initialize. For instance, if you want to add everything in the directory and its subdirectories to the staging area we use the command:

git add .

if you want to select specific changes then you select the specific areas you want to add to the staging area. For example, we want to add the changes in the README.md file alone we will initiate a:

git add README.md

if we need changes committed in the DATA folder only we will have:

git add DATA/

D. Committing the Project

A commit refers to a saved checkpoint of the project. It records the changes that you had prepared in the staging area.
The command used to commit is:

git commit -m " what you are committing"

The message inside the quotation marks describes what the commit contains and helps in understanding the project later.
taking the example of our project we could write

git commit -m "Sales project"

E. Connecting the Local Repository

After committing we are now required to create a repository on GitHub. GitHub, acts as a remote location where we can store and access the project online.

The remote repository can be given a name , and a description, and it will generate a SSH key URL which will be used in connecting the local repository to GitHub. The command used will be:

git remote add origin

Here origin means the name given to GitHub repository connected to the local project. If we use the example of our project the command would appear as:

git remote add origin git@github.com:username/repository.git

with the URL written after origin being an SSH remote URL that connects the local Git repository to the GitHub repository.

Understanding the SSH KEY

To connect your local Git repository to GitHub securely, you require a key called the secure shell key or commonly called the SSH key.
It is generated and obtained after you have configured the Git Bash, the key is generated using the command:

ssh-keygen -t ed25519 -C "Your email@example.com"

Consequently, Git bash will ask you to enter a passphrase twice for the purpose of confirmation. Then it will generate a private key and a public key, which helps us to connect the local Git repository to GitHub securely.
For safety purposes we will use the public key written with .pub which stands for public.

The command
cat ~/.ssh/id_ed25519.pub|clip

shows us how to copy and clip the key.

After acquiring this public key we are required to go to the GitHub account, and open settings then click SSH key, then New SSH Key and add the SSH key there.

Afterwards return to Git Bash and test the connection using the command

ssh -T git@github.com

Once the connection is successful, we now know we will be able to connect the local repository with the remote repository using the command;

git remote add origin git@github.com:username/repository.git

Allowing GitHub to verify that the computer is authorized to access the repository.

F. Pushing the Project to GitHub

After connecting the project to GitHub, check what your branch is called using the command:

git branch

A branch in this context refers to a separate version of Git project that allows you to make changes without directly affecting the main branch. Meanwhile, the main branch is the primary branch of a Git repository which contains the main, stable version of your project.

Its important that the local branch and remote branch you are pushing to match. In the past the branch was commonly referred to as master but with time the modern GitHub default branch evolved and begun to be called main.

So for instance if your default branch is master and your remote branch was created as main you will be required to change it to main and hence, use the command

git branch -M main

This changes your branch to main.

Now after dealing with the branch, the next step is to push the project and it is done using the command:

git push -u origin main
or

git push -u origin master

depending with what your remote repository is called. After pushing your project successfully, the repository will appear in your GitHub account marking the end of the process of creating and pushing a directory to become a repository from the local PC to a remote GitHub repository.

This image shows the steps of pushing a local directory to GitHub using git.

Now lets have a code example showing the flow of events in the process of pushing a locally created directory to GitHub using the SSH key:

example
Lets consider that we already set up our SSH key and we want to push a locally generated project from the git bash to GitHub using the SSH key.
While using our example of Sales Project as our directory, this is how the flow of creating a directory and pushing it would look like:


pwd 
cd Desktop
mkdir "Sales Project"
cd "Sales Project"
touch README.md
mkdir DATA
cd .. ##this allows you to go a step back from current directory.
     ## this one for instance will take you back to README.md
echo "sales" >README.md # enables writing text into a file
cat README.md # displays contents of a file in the terminal
nano README.md # enables editing of README.md file
git init
git status ##Helps check what is happening in your git project
git add .  
git commit -m "Sales Project"
git remote add origin git@github.com:username/repository.git                                                   
git branch
git push -u origin main

Conclusion

In conclusion, moving a project from a local computer to GitHub involves a clear sequence of steps which involve creating and initializing the repository, staging and committing changes, establishing an SSH connection, linking the local repository to a remote repository, and pushing the committed work to GitHub. Each stage serving a specific purpose in maintaining a reliable version-controlled project. Understanding this workflow provides a practical foundation for managing projects, tracking changes, and collaborating through Git and GitHub.