JJ Juliana Jepkogei
Portfolio — Vol. I
Jambo — a profile in data

I'm Juliana Jepkogei

Business & Marketing Analyst, by way of Eldoret and Illinois.

Portrait of Juliana Jepkogei
Juliana Jepkogei Normal, Illinois
Scroll
IIntroduction
Based in
Normal, Illinois
Roots
Eldoret, Kenya
Focus
Marketing & Business Analytics

Juliana turns marketing noise into a short list of decisions worth making. Trained in economics in Kenya, and in marketing analytics and data science in Illinois, she moves comfortably between an SPSS output and a stakeholder meeting — turning churn models, campaign KPIs, and search data into a plan a team can actually act on.

IIExpertise

Where marketing meets measurement

Seven tools she returns to most often — each one a different lens on the same question: what does the data actually tell us to do next?

SPSS

Data Analysis & Interpretation

Turning raw data into actionable insight that fuels strategic marketing decisions — distilling complex datasets into the trends that reveal customer behavior, campaign performance, and ROI.

SPSS expertise: detecting the patterns that drive data-backed marketing strategy with precision.

KPI

Marketing Campaign Performance Tracking

A results-driven approach to tracking digital campaigns across social, email, and PPC — continuously monitoring CTR, conversion rate, and engagement to optimize for maximum impact.

Mastering KPIs to fine-tune marketing efforts for stronger engagement and conversions.

GA4

Google Analytics Mastery

A deep understanding of Google Analytics to track and analyze website traffic, user journeys, and campaign success — transformed into insightful, actionable reports and dashboards.

Proficient in building detailed, real-time performance reports that inform data-driven strategy.

SEO / SEM

SEO & SEM Analytics

Dissecting SEO and SEM performance to keep websites performing at their best — tracking organic search metrics and keyword rankings with tools like Google Search Console and SEMrush.

Harnessing search data to improve rankings and boost organic traffic.

BI

Dashboard Creation — Power BI, Tableau, VS Code

Custom, visually engaging dashboards that showcase marketing performance clearly and compellingly, giving stakeholders at-a-glance insight to drive faster, better decisions.

Crafting data stories through interactive visualizations that make key metrics impossible to miss.

Forecast

Predictive Analytics

Leveraging predictive analytics to stay ahead of marketing trends — forecasting customer behavior and campaign outcomes so teams can stay proactive rather than reactive.

Predicting trends to empower forward-thinking marketing strategies.

SQL

SQL

A foundational, working knowledge of SQL to query databases, access key datasets, and support marketing insight with clean, reliable data analysis.

Blending marketing analytics and data science to craft unique brand identities for business decisions & growth — with a difference.
IIIEducation

Grounded in analytics, built on business

2024

Master of Science in Marketing Analytics

Illinois State University, Normal, IL
December 2024
2023

MBA, with a Certificate in Data Science

Illinois State University, Normal, IL
May 2023
2017

Bachelor of Arts in Economics

Moi University, Eldoret, Kenya
June 2017
IVSkills

Tools of the trade

A working toolkit spanning statistics, visualization, and the everyday software of a modern analyst.

Analysis & Statistics

R Studio0%
SQL0%
Python0%
HTML / CSS0%

Tools & Delivery

Power BI0%
Tableau0%
Visual Studio0%
Excel / Word / Access / PowerPoint0%
VLeadership & Certifications

Beyond the spreadsheet

Leadership & Involvement

NABA Inc. — National Association of Black Accountants

Member

International Students Association

Member

Kenyan Student Association, Illinois State University

President

Licenses & Certifications

Inbound Marketing — HubSpot Academy

October 2023

Distributed Computing with Spark SQL — Coursera

December 2022

Google Analytics for Beginners — Google Analytics Academy

January 2022
VISample Projects

Selected work

A few projects that show how she moves from raw data to a decision someone can act on.

Case File — R Studio

Customer Churn Prediction for Banks

Chi-square segmentation & Random Forest

Analyzed bank customer churn data and identified six key variables linked to churn through chi-square tests. Using "Aggregate" and "Table" functions, studied averages and pair-wise frequencies to segment customers and flag at-risk groups. Random Forest emerged as the strongest model on accuracy and sensitivity — one banks can use to target retention offers toward high-value customer segments.

Case File — Visual Studio

Interactive Visualizations — HTML, JavaScript & D3.js

COVID-19 data across 32 countries

Built interactive scatter plots and bar graphs to surface trends in cases, infections, and deaths, with continent-based color coding, hover detail, and a filter slider that let users explore global and regional disparities for themselves.

Case File — Tableau

Strategic Investment Analysis for Airbnb Hosts in Seattle

Price, location & projected revenue

An in-depth analysis to identify the strongest investment opportunities for prospective Airbnb hosts in Seattle — weighing bedrooms, purchase price, zip code, and projected revenue to guide property selection toward the city's most promising areas.

Case File — Power BI

Power BI Dashboards

Project 1 & a deeper data-analysis pass

Two Power BI builds: an initial dashboard project, followed by a deeper data-analysis pass turning the underlying dataset into a clearer, more decision-ready view.

VIIContact

Let's put your data to work.

Open to marketing analytics, business intelligence, and data-driven growth roles.

Send an Email