DEV Community: Leonard Mwilu

Jumia Product Performance & Pricing Dashboard

Leonard Mwilu — Sat, 05 Sep 2026 17:47:07 +0000

This is an end-to-end Jumia e-commerce data analysis and interactive Microsoft Excel dashboard project; analyzing product pricing, promotional discounts, customer ratings, and engagement metrics for Jumia listings.

Project Overview

Jumia and its marketplace sellers require data-driven insights into how pricing strategies, promotional discounts, and customer ratings impact overall engagement. Because direct sales volume and revenue figures are not present in the dataset, in the provided dataset I assumed that review counts indicated customer engagement.

In this project I processed raw Jumia product data, performed data quality audits, standardized messy records, enriched the dataset with logical categories and performance flags, evaluated linear correlations, and build an interactive, single-screen Microsoft Excel dashboard.

Core Questions I used to drive my Analysis

Are larger promotional discounts associated with higher customer engagement (reviews)?
Do highly rated products attract stronger customer interaction?
Do current price points move together with average customer ratings?
Which products represent top catalog performers versus underperforming promotional risks?
What specific pricing or marketing adjustments should sellers execute?

PivotTable and analysis workflow

Data Audit Summary

Total Raw Records: 115 rows
Duplicate Records: 3 full duplicate rows identified and removed (reducing clean catalog count to 112 unique products).
Price Ranges: Evaluated and converted to midpoints on row 39 for consistent numeric analysis while preserving auditable source text.
Missing Values: 58 missing values in ratings and reviews were treated as "uncaptured data" rather than converted to zeros. Below is a snippet of the audit summary.

Data Cleaning & Transformation Rules

All data transformations were executed cleanly in Cleaned_Data (tblProducts) and documented in the workbook Data_Dictionary:

Product Name: Standardized using =TRIM().
Prices: Cleaned of text characters (KSh, commas) and converted to numeric currency (KSh #,##0.00). Range values were resolved using midpoints: (Min + Max) / 2.
Discounts: Stripped of % signs, converted to decimals, and formatted as Percentage (0%).
Reviews: Converted negative values to absolute whole numbers via =ABS().
Ratings: Extracted numeric values by removing " out of 5" and converted to decimals.

Calculated & Enriched Fields

Discount Amount: Old Price - Current Price
Price Category:

Low Price: KSh 493.00 (First Quartile)

Medium Price: KSh 493.01 – KSh 1,669.50 (First Quartile to Third Quartile)

High Price: > KSh 1,669.50 (Third Quartile)
Discount Category: Low (<20%), Medium (20% - 40%), High (>40%)
Rating Category: Poor (<3.0), Average (3.0 - 4.5), Excellent (>4.5)

Excel formulas I used

I used several Excel formulas in this project and below is a list of most of the Formulas.

=VALUE(SUBSTITUTE(SUBSTITUTE(B2,"KSh",""),",",""))
=VALUE(SUBSTITUTE(D2,"%",""))/100
=IF(E2="","",ABS(VALUE(E2)))
=IF(F2="","",VALUE(SUBSTITUTE(F2," out of 5","")))

Total products  =ROWS(tblProducts[Product])     
Average current price   =AVERAGE(tblProducts[Current Price])        
Average old price   =AVERAGE(tblProducts[Old Price])        
Average discount    =AVERAGE(tblProducts[Discount])     
Average rating  =AVERAGE(tblProducts[Rating])       
Total reviews   =SUM(tblProducts[Review])       
Most expensive price    =MAX(tblProducts[Current Price])        
Least expensive price   =MIN(tblProducts[Current Price])        

Discount Amount: =[@[Old Price]]-[@[Current Price]]     
Rating Category: =IF([@Rating]="","Missing",IF([@Rating]<3,"Poor",IF([@Rating]<=4.5,"Average","Excellent")))

Discount Category: =IF([@Discount]="","Missing",IF([@Discount]<0.2,"Low Discount",IF([@Discount]<=0.4,"Medium Discount","High Discount")))

Price Category =IF([@[Current Price]]="","Missing",IF([@[Current Price]]<=Price_Q1,"Low Price",IF([@[Current Price]]<=Price_Q3,"Medium Price","High Price")))

Validation Check : =IF(OR([@Rating]<0,[@Rating]>5),"Check rating",IF(OR([@Discount]<0,[@Discount]>1),"Check discount",IF([@[Current Price]]>[@[Old Price]],"Check prices","OK")))       

=CORREL(tblProducts[Discount],tblProducts[Review])
=CORREL(tblProducts[Rating],tblProducts[Review])
=CORREL(tblProducts[Current Price],tblProducts[Rating])

=QUARTILE.INC(tblProducts[Current Price],1)
=QUARTILE.INC(tblProducts[Current Price],3)

=IF([@[Current Price]]="","Missing",IF([@[Current Price]]<=Price_Q1,"Low Price",IF([@[Current Price]]<=Price_Q3,"Medium Price","High Price")))

Below is a snippet image of the cleaned data table (tblproducts) achieved after data cleaning and addition of relevant columns(Enriched Fields).

After completing clean-up and analysis these are the total sheets I had in my Excel workbook.

I finally generated PivotTables and charts which I later used to build my dashboard. Below is an image of the PivotTables in one sheet.

Using this PivotTables I was able to generate Pie Chart and Column Charts for ease of building the Dashboard.

Dashboard design and slicer connections

To build a seamless, audit-ready presentation, I designed the Dashboard tab as a single-screen analytical hub that isolates reporting from underlying data logic.
The visual layout features high-level KPI cards, dynamic charts, and assumptions & recommendations sections, all driven by interactive Slicers connected across multiple PivotTables.
Using Excel's Report Connections, selecting a filter—such as Rating Category, Discount Category, or Price Category—instantly updates all visuals and summary metrics simultaneously, allowing stakeholders to cross-analyze product performance without altering the core dataset.

Below are the slicers I used.

The steps involved in connecting the Slicers with all the PivotTables are; right click on the Slicer, click report connections,on the pop-up min-window that comes up, tick all the boxes in the list and then click OK. This steps are as shown in the below image.

Below is the dashboard I came up with at the end of the project.

Key Findings & Correlation Analysis

Linear relationships were evaluated across complete paired observations using Pearson correlation (=CORREL()):

Business Recommendations

Optimize Discount Bands: Products in the Medium Discount group (20%–40%) generate higher average engagement (15.26 reviews) than items in the High Discount group (>40%, averaging 11.13 reviews).
Sellers should avoid slashing prices beyond 40% as it destroys margin without boosting sales volume.
Audit Low-Rated, High-Discount Listings: 10 products pair high discounts (>40%) with poor ratings (<3.0). Deep price cuts on low-quality products harm brand reputation; Jumia should inspect these items for quality defects or inaccurate descriptions.
Promote Catalog Star Performers: 6 listings achieve both Strong Engagement (greater or equal to 14 reviews) and Excellent Ratings (>4.5). Sellers should feature these items in sponsored ad campaigns to capture high conversion rates.
Fix Average-Rated High-Volume Listings: 6 items generate high engagement (greater or equal to 14 reviews) but possess mediocre satisfaction ratings (3.0–4.5). Sellers should inspect buyer feedback to fix minor packaging or product flaws.

Data Limitations & Analytical Challenges

Engagement Proxy: Review count is used as a proxy for customer engagement. The dataset omits direct sales units, page views, and financial revenue.
Listing Age & Visibility: Review totals may reflect how long a product has been active on Jumia or its placement algorithm rather than price responsiveness.
Correlation vs. Direct link: Observed statistical correlations do not establish direct cause-and-effect relationships.

Some of the Key Lessons I Learned while doing the project

Audit-Trail Data Cleaning: Cleaning raw e-commerce data requires preserving source inputs alongside normalized values. Converting price ranges to midpoints while keeping original text ensuring data integrity and traceability.

Data Types and Regional Formatting: Unstructured text strings (e.g., "KSh", ",", " out of 5", "%") break Excel numerical functions. Stripping formatting artifacts early prevents downstream #VALUE! errors in PivotTables and Formulas.

Percentile-Based Performance Thresholds: Applying objective mathematical cutoffs (such as using Price_Q1/Price_Q3 for 1st and 3rd Quartiles) eliminates subjective bias when categorizing catalog items.

Separation of Architecture & Presentation: Structuring the Excel workbook into dedicated functional layers (Raw_Data -> Cleaned_Data ->tblproducts ->Data Dictionary -> Analysis -> Pivot_Tables -> Dashboard) maintains readability, prevents circular references, and simplifies troubleshooting.

The Repository Structure I used

jumia-product-performance-dashboard/

├── README.md

├── data/

│   └── Excel_jumia_dataset.csv

├── dashboard/

│   └── jumia_product_dashboard.xlsx

└── images/

         ├── raw-data.png

         ├── cleaned-data.png

         ├── pivot-tables.png

         └── dashboard.png

Github repository link: https://github.com/Immeleo/jumia-product-performance-dashboard

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

Leonard Mwilu — Sat, 29 Aug 2026 18:33:11 +0000

Introduction

3rd week into Data Science and Analytics with Lux Dev Academy. This week we started a two-week learning module on the use of Microsoft Excel to clean and analyze data.

In the modern data-driven landscape, organizational decision-making hinges on the ability to transform raw, unstructured inputs into clear and actionable insights.

"Garbage in, garbage out" (GIGO) remains the defining axiom of data engineering. Statistical models, pivot tables, and visualization dashboards are only as reliable as the underlying data clean-up routines. Data cleaning is not a preliminary administrative chore; it is the core analytical step where data validity and structural integrity are established.

Excel Use Cases

Some of the common area/scopes where Excel is used are:

Data Entry
Data Analysis
Data Cleaning
Reporting (using dashboards & Pivots).

Navigating the Excel Interface & Understanding Data Types

Navigating the Excel Interface

We started by learning most if not all the components and features of Microsoft Excel. Below images show most important sections of the Microsoft excel, indicated on an open blank sheet.

The core interface components are:

Ribbon: this is the top navigation toolbar organize into tabs which include Home, Insert, Data, Formulas, Reviews and Help.
Formula bar: Displays and also can be used to edit the cell value or the underlying formula active in a selected cell.
Name Box: Displays the name or the defined name of the currently selected cell or range.
Worksheet Grid: This is the primary worksheet made up of rows(numbered 1 - 10000...) and columns(lettered A-X...)
** Cells**: this is the intersection of a row and a column where data, text, or formulas are entered.
Sheet Tabs: this a located at the bottom and enables one to switch between different worksheets within a single excel workbook file.
Status Bar: this is bar at the bottom of the worksheet that shows the real-time information or calculations like count of values in selected cells, sum of values in a selected range. Highlighted in yellow in the below image.

Other important sections of excel can be found once you click the file tab at the top left corner. This sections include Home(button to return to worksheet), New(for creating new workbook), Open (to open an existing excel file from the laptop/host machine),info, print, export ( can be used to convert the file into other formats like pdf), close, recent, Favorites and more. This appears as shown in the image below.

Data Types

Excel categorizes data entering a cell into distinct underlying visuals and mathematical data types. Understanding how Excel stores and processes these data types is important since mismatched data types result in execution errors during analysis.
Some the Excel data types include the following:

Numeric(Values); these are right-aligned and are floating-point numbers.
Text(Strings); these are left-aligned and are alphanumeric sequences(cannot be evaluated mathematically)
Date & Times; also Right-aligned and are sequential serial numbers where Day 1 is 1/1/1900. Time is represented by fractional values.
Boolean(Logical); they are centered on a cell and restricted to uppercase binary values: TRUE or FALSE.
Formulas & Errors; expressions starting with =. They yield dynamic data or error states.

Conditional Formatting

Learned about conditional formatting which is a feature of Microsoft Excel that automatically changes how a cell looks based on the data inside it. Instead of manually applying colors or styles to individual cells, you set rules (conditions) and the software formats the cells automatically when those conditions are met.
Conditional formatting can be applied on both text and numbers. When working with conditional format there as many options and functions provided in Microsoft Excel. Some of this options are highlighted in the below image.

Sample of data with conditional formatting applied is as shown below.

How it works: You select the cells you want to monitor, define the rule, and the forma updates automatically.

One important function during conditional formatting of data in Excel is the Find and Replace tool. You can access it instantly using keyboard shortcuts:
- Ctrl + F opens the Find tab directly.
- Ctrl + H opens the Replace tab directly.

Below is how it appears once open in an Excel sheet.

Formulas, Functions, and References: The Calculation Engine.

Formulas represent the foundational syntax of Excel analytics. Every formula begins with an equals sign =, signaling to the calculation engine to evaluate the subsequent expression rather than treating it as a literal string.

Mathematical Operators and Order of Operations.

Excel adheres to the standard algebraic order of operations PEMDAS: Parentheses, Exponents, Multiplication/Division, Addition/Subtraction. While using Excel we face situations where we use one or all of these operations and there its very crucial to understand how to apply and use them properly. When building analytical sheets, one is required to structure complex algebraic expressions logically. The symbols used for the different operations are as shown below.

Addition & Subtraction: + and -
Multiplication & Division: * and /
Exponentiation:^ (e.g., =10^2 yields 100)
Comparison Operators: =, <> (Not equal to), >, <, >=, <=

Mastering Cell References: Relative vs. Absolute vs. Mixed

Understanding cell referencing is very important for one to become proficient data analyst. When formulas are copied from one row or columns to another, cell references adapt based on the presence of dollar sign $ anchors.

Relative References: Cell references are relative by default. For a formula containing =A1+10 in cell B1 is dragged down to B2, it automatically shifts to =A2+10. The formula stores the relative offset rather than a fixed address.
- Absolute References: Adding a dollar sign $ before both the column letter and row numbers locks the reference completely. For example if =$A$4*.001 is copied from cell L1 down to L10, every single cell will evaluate against cell A4. This is very essential for central parameters like discount factors, tax rates or KPI targets.
- Mixed References: This lock either the row or the column, leaving the other free to adjust dynamically. eg $A10 and B$10.

Core Statistic Functions

The foundation of initial exploratory data analysis relies on fundamental aggregation functions:

=SUM(range): used to calculate the total arithmetic sum of a numeric range.
=AVERAGE(range): used to compute the arithmetic mean.
=COUNT(range): used to count cells containing numeric values only.
=COUNTA(range): used to count non-empty cells (includes text, numbers, logical values TRUE/FALSE and errors).
=COUNTBLANK(range): Counts empty cells within a specified range.
=MIN(range) or =MAX(range): used get the minimum or maximum value in a range of values. Other statistical functions we covered included: =COUNTIF()& =COUNTIFS(), =SUMIF() & =SUMIFS(), =AVERAGEIF() and =AVERAGEIFS().

Structured Data: Working with Excel Tables.

The single most impactful practice for modern analytics in Excel is converting raw data blocks into official Excel Tables(Keyboard Shortcut: Ctrl + T).
Some of the advantages of using Structured data are:

Dynamic Auto-Expansion: When new rows or columns are added directly adjacent to a Table, the table automatically expands to encompass the new data, automatically extending formulas, formatting, and data validation rules.
Structured references.
Calculated Columns: Entering a formula in a single cell of a table column automatically fills down the entire column instantly.
Integrated Filter Controls: Automatic addition of sorting and filtering drop-downs on the header row

Data Preparation & Data Cleaning Techniques.

Data cleaning is the process of detecting, correcting or removing corrupt, inaccurate, incomplete, improperly formatted or duplicate records from a dataset. Below are some of the methodologies we covered for execution with Excel.

Text Cleaning & Manipulation Functions

Uncleaned text files often contain leading or trailing whitespaces, non-breaking spaces, merged text strings or inconsistent casing.
Some of the functions for cleaning text we covered are:

=TRIM(text): removes all leading & trailing spaces and reduces multiple internal spaces to a single space.
=CLEAN(text): removes all non-printable ASCII characters.
=UPPER(text) and =LOWER(text): standardizes text strings into uniform uppercase or lowercase for case-sensitive comparisons.
=PROPER(text): Capitalizes the first letter of each word in a text string. It is useful for names and addresses.
=LEN(text): Used to count the total characters in a text string. One of the use cases would be when validating Fixed-length IDs. These functions can be used together when need arises. e.g =LOWER(CONCAT(text1,text2,text3,..))

Substring Extraction: LEFT, RIGHT, MID, and FIND.

Data fields frequently combine multiple pieces of data into single alphanumeric codes, for example Transaction ID is TXN-88492-2026. To extract individual variables, you combine string positional functions:

=LEFT(text, [number of characters]): used to extract characters from the start of a string.
=RIGHT(text, [number of characters]): used to extract characters from the end of a string.
=MID(text, start number, number of characters): used to extracts characters from any starting position within the string.
=FIND(find_text, within_text): Returns the 1-based index position of a specific character sequence and it is case-sensitive.

Conclusion

Mastering Microsoft Excel for data analytics is not about memorizing isolated functions but it is about building robust, repeatable data processing pipelines. We established the baseline mechanism required to operate within the spreadsheet efficiently. understanding cell layout, controlling relative and absolute reference framing, using official Excel Tables, and applying string extraction and text-cleaning functions to sanitize messy real-world inputs.

_ Never replace blank cells with guesses but you can replace them with a keyword like "Unknown"._

My First GitHub Project: From a Local Folder to GitHub Using Git and SSH

Leonard Mwilu — Thu, 20 Aug 2026 18:32:22 +0000

Introduction

In my 2nd Week in Data Science & AI Analytics at LUX Academy we dive more into Git Bash and GitHub interactions and operations by doing our first project and publishing it on GitHub using push , commit and remote origin commands.

Steps from start to publishing on GitHub

Gathering Information

The data for this project was provided as Excel forms both .xlsx and .csv files, by the instructor.
Creation of local folders

I created my local folder in my laptop's Desktop folder using git bash commands. In Git Bash, using the cd command I navigated to my Desktop which was located inside OneDrive folder. cd ~/OneDrive/Desktop/
Inside the Desktop folder, I created a new folder and named it after my project Kenya-Hospital-Health-Records-Analysis using the mkdir command.
I then used cd Kenya-Hospital-Health-Records-Analysis to move into the new folder(directory). Inside this folder, I created a new subfolder called data using cd data, to hold my files. I then created the README file which holds information about my project and is a crucial part of any GitHub repository. Here I used the touch command i.e touch README.md.
Moving files from Downloads to my project data folder

Since the data I was provided with was shared via WhatsApp, I downloaded the files into my laptop's Downloads folder and I had to move them to my project folder(data).
Using git bash commands I easily moved my file from Downloads to data folder. Command for moving files in git is mv /sourceFolder/filename.file_extension /destinationFolder. In my case all i did to do was

mv ~/Downloads/Kenyan_Hospital_Health_Records.xlsx ~/OneDrive/Desktop/Kenya-Hospital-Health-Records-Analysis/data

Now that my folder and data were set, I was ready to push and publish on GitHub.

Creation of GitHub Repository

In order to push from my local folder to GitHub, I needed to create a repository on my GitHub account. I logged into my GitHub account, navigated to Repositories(appears once you click the profile icon at top right corner) and then clicked NEW. I then type my repository name Kenya Hospital Health Records Analysis, entered a short description about it, and then clicked Create repository. Once my repository was ready I copied the SSH address.
Connecting Local folder and GitHub repository
- First I used ssh -T git@github.com to test my connection which was successful.
- Using git init I created the hidden .git folder that lets git to track the files in my working directory(folder).
- Using git branch -M main I ensured that my local branch was named main to align with GitHub defaults.
- using git add . and git commit -m "adding my kenya health records analysis project" I added my files to the staging area and created my baseline snapshot.
- I then linked my local repository with GitHub repository via SSH using git remote add <SSH_address copied from GitHub earlier>
Pushing my project to GitHub

Using git push -u origin main I uploaded my commits and set the default upstream tracking branch.
Verifying Successful Push

I then returned to my GitHub account, and after refreshing the page, my project had successfully been uploaded to my GitHub repository and the content of my README.md was on display.

_ I am so happy that after a few challenges with git bash commands I successfully managed to complete my first project. I am ready for the next challenge as we dive deep into Data Science_

Starting My Journey with Data Science and AI Analytics: What I've Learned So Far

Leonard Mwilu — Sun, 16 Aug 2026 08:47:04 +0000

Hello DEV Community! 👋

I'm starting a new chapter in my career journey and wanted to document my progress here. I recently enrolled in LUXDEV (Data Science and AI Analytics Cohort 9 2026), and I'm excited to share my first updates!

🎯 Why I Enrolled

I wanted to build a rock-solid foundation in Data Science and get certified instead of learning randomly without structure. My goal is to understand data analysis, structuring and how to deduce information from cleaned data, using this to make predictions and decisions.

📚 What We've Covered So Far

Here is a quick summary of what I've tackled in the first couple of modules:
**1st Week: Software Installation and Initial Setups

Git and GitHub: Installed and set up Git on my laptop and linked it with my existing GitHub account.
DBeaver and Postgress: Installed Postgress and DBeaver. Used DBeaver to create DB on Postgress.
Aiven: Created an account on Aiven Site. Created two services MySQl and Postgress. Linked both database with DBeaver for ease management.

💡 Key Takeaway

DBeaver is a Open Source Database management tool
Aiven is a online(cloud) platform for creating database and more and gives free usage for 1 DB at a time for learning purposes.
Learned about this site DEV Its the first time to hear about it

🚀 What's Next

This 2nd week we dive into the real deal now that we are set.

I'd love to connect with others currently taking Data Science & AI Analytics or learning Data Engineering. Leave a comment below or drop your favorite learning tips!

DEV Community: Leonard Mwilu

Jumia Product Performance & Pricing Dashboard

Project Overview

Core Questions I used to drive my Analysis

PivotTable and analysis workflow

Data Audit Summary

Data Cleaning & Transformation Rules

Calculated & Enriched Fields

Excel formulas I used

Dashboard design and slicer connections

Key Findings & Correlation Analysis

Business Recommendations

Data Limitations & Analytical Challenges

Some of the Key Lessons I Learned while doing the project

The Repository Structure I used

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

Introduction

Excel Use Cases

Navigating the Excel Interface & Understanding Data Types

Navigating the Excel Interface

Data Types

Conditional Formatting

Formulas, Functions, and References: The Calculation Engine.

Mathematical Operators and Order of Operations.

Mastering Cell References: Relative vs. Absolute vs. Mixed

Core Statistic Functions

Structured Data: Working with Excel Tables.

Data Preparation & Data Cleaning Techniques.

Text Cleaning & Manipulation Functions

Substring Extraction: LEFT, RIGHT, MID, and FIND.

Conclusion

My First GitHub Project: From a Local Folder to GitHub Using Git and SSH

Introduction

Steps from start to publishing on GitHub

Gathering Information

Creation of local folders

Moving files from Downloads to my project data folder

Creation of GitHub Repository

Connecting Local folder and GitHub repository

Pushing my project to GitHub

Verifying Successful Push

Starting My Journey with Data Science and AI Analytics: What I've Learned So Far

🎯 Why I Enrolled

📚 What We've Covered So Far

💡 Key Takeaway

🚀 What's Next