Khepera Walker.
Open to Data & BI Analyst roles

Turning Complex Data Into Clear Business Decisions

Data Analyst specializing in business intelligence, reporting, data visualization, and operational analytics. I use Power BI, SQL, Excel, and Python to transform raw data into actionable insights.

View My ProjectsContact Me
Preferred stack
SQL
PY
PBI
XLS
DAX
portfolio_overview.pbix
Core toolstack
Power BI · SQL
Also fluent in
Python · Excel
Focus areas
BI REPORTING·OPS ANALYTICS·DATA VISUALIZATION
STACK: PBI / SQL / PYTHON / EXCELSTATUS: AVAILABLE

Professional Profile

I combine hands-on business operations experience with rigorous data analytics — translating complex operational data into practical decisions that leaders can act on.

More about me

Featured Projects

Case studies in business intelligence and analytics across healthcare, consumer sales, transportation, finance, and marketing.

All projects
Dashboard visualization with bar and line charts for healthcare operations and revenue analysis

Healthcare · Operations

Healthcare Operations & Revenue Analysis

Business problem

Leadership lacked a consolidated view of how patient admissions, medical conditions, medication use, and insurance billing interact — making it hard to explain why revenue moved and where claim denials were eroding margin.

A six-year Power BI analysis of patient demographics, admissions, medical conditions, medications, lab results, and insurance billing — built to answer ten stakeholder questions about care delivery and revenue performance.

SQLPower BIPower QueryDAXData Modeling
View Project
Abstract retail sales analytics visual with donut, line, and bar chart motifs in teal and blue

Retail · Sales & Profitability

BrightMart Sales Analytics

Business problem

BrightMart, a retailer operating across Atlantic Canada, needed to know how it could improve profitability — which regions, categories, salespeople, channels, and months actually drive performance, and where cost is quietly eating margin.

A retail sales analysis combining T-SQL aggregation in Microsoft Fabric with a Python/Jupyter exploratory notebook — covering revenue, cost, profit, margin, discounting, returns, and channel and segment behaviour.

SQLPythonJupyterpandasMatplotlibMicrosoft Fabric
View Project
Sales analytics visualization with a heat map of Illinois, bar charts, and a donut chart

Consumer · Sales

Illinois Lottery Sales & Consumer Analytics

Business problem

Statewide lottery sales data is fragmented across products, regions, and retail channels, obscuring the consumer patterns that drive revenue.

Exploratory analysis and segmentation of sales by product, geography, and ticket type to reveal demand patterns, seasonal trends, and underperforming segments.

PythonSQLPower BIExcel
View Project
Logistics analytics visualization with a route network map and cost comparison charts

Transportation · Operations

Transportation Route Cost Analysis

Business problem

Route-level transportation costs vary widely, and without a consistent cost model it is difficult to see which routes erode margin.

A route cost model comparing cost per mile, per stop, and per route over time — isolating the operational factors behind cost variance.

SQLPower QueryPower BIExcel
View Project
Financial analytics visualization with trend lines comparing fuel price indices and surcharges

Finance · Pricing

Fuel Surcharge Analysis

Business problem

Fuel surcharges must track volatile fuel price indices — misalignment quietly impacts margin and billing accuracy.

Trend and variance analysis of surcharge schedules against fuel price indices, with dashboards that highlight gaps and forecast exposure.

ExcelPythonDAXPower BI
View Project
Marketing analytics visualization with a conversion funnel and campaign performance bar charts

Marketing · Performance

Marketing / Event Performance Analytics

Business problem

Marketing and event spend is often reported in silos, making ROI comparisons across campaigns and channels unreliable.

A performance scorecard framework that standardizes acquisition, engagement, and ROI metrics across campaigns and events for apples-to-apples comparison.

Power BISQLExcel
View Project

Technical Skills

A full analytics toolkit, from raw data to boardroom.

Full skills matrix

Data Analytics

  • Data Cleaning
  • Exploratory Data Analysis
  • Statistical Analysis
  • Trend Analysis
  • Root Cause Analysis
  • KPI Development

Business Intelligence

  • Power BI
  • DAX
  • Power Query
  • Data Modeling
  • Dashboard Development

Technical

  • SQL
  • Python
  • Excel
  • Microsoft Fabric

Business

  • Marketing Analytics
  • Operations Analytics
  • Transportation Analytics
  • Performance Reporting
  • Process Improvement

Analytics Capabilities

What I can do for your team

Capabilities developed across operations, finance, and marketing analytics engagements.

Reporting & Dashboards

Executive-ready Power BI dashboards and recurring reports that make performance visible at a glance.

Data Modeling & SQL

Clean, well-structured data models and efficient SQL that turn fragmented sources into one reliable dataset.

Trend & Root-Cause Analysis

Exploratory and statistical analysis that explains why a metric moved — not just that it did.

Process Improvement

Automated, repeatable reporting workflows that replace manual spreadsheet work and reduce errors.

Ready to discuss your data needs?

Currently open to Data Analyst, Business Intelligence Analyst, Marketing Analyst, and Operations Analyst opportunities. Download my resume for a detailed view of my background, or reach out directly.

Download Resume
LinkedInGitHubEmail

Prefer to start a conversation?

Send a message through the contact form and I'll get back to you — or email me directly at kheperawalker@gmail.com.

Go to Contact Form