Economics & Finance Finalist | Data Analyst (Excel • SQL • Power BI)

I help teams make better decisions by analyzing business and economic data. My work focuses on turning raw datasets into clear insights, dashboards, and practical recommendations. Web development is a secondary skill I use to present work professionally.

Download CV

I turn business and economic data into clear insights and recommendations using Excel, SQL, and Power BI. My work focuses on real decisions improving performance, identifying growth opportunities, and communicating results through dashboards and case studies.

What I Do

Turning Data Into Strategic Business Decisions

I specialize in transforming raw business and economic data into clear insights that help organizations make smarter decisions. Using tools such as Excel, SQL, and Power BI, I analyze performance, identify opportunities, and communicate findings through structured case studies and dashboards.

Data Analysis

Cleaning and exploring datasets to identify patterns, inefficiencies, and growth opportunities. Tools: Excel, SQL, Python.

Business Intelligence

Designing dashboards that track KPIs, visualize trends, and support leadership decision-making. Tools: Power BI, Excel Dashboards.

Economic & Business Insights

Applying economic thinking to interpret market trends, financial performance, and consumer behavior to guide business strategy.

Featured Projects

Business Analytics Case Studies

Each project follows a professional structure: business problem → data preparation → analysis → insights → recommendations.

Dashboard Showcase

Interactive Dashboards Built for Decisions

These dashboards are built with business questions in mind — clear KPIs, drill-down views, and insights that support real decisions.

Executive KPI Dashboard

Weekly leadership dashboard tracking revenue, profit, margin, growth, and top drivers with drill-down filters.

  • Power BI
  • DAX
  • Data Model

Retail Sales Dashboard

Excel dashboard analyzing revenue trends, product performance, regional drivers, and margin opportunities.

  • Excel
  • PivotTables
  • KPIs

Data Analyst (Economics Background)

I turn messy data into clear insights and business recommendations using Excel, SQL, and dashboards.

Portfolio Projects (Real Business Problems)

Sales performance, customer segmentation, executive dashboards, and forecasting — with actionable recommendations.

Tools I Use

Excel (PivotTables, cleaning), SQL (joins, aggregation), Power BI (KPIs, DAX basics), reporting & storytelling.

About

Economics + Data Analytics for Better Decisions

I’m Carlton Waiti — an Economics & Finance student focused on becoming a top-tier Data Analyst. I build dashboards and analysis that answer real questions: what’s driving performance, where revenue leaks, who the best customers are, and what to do next.

My approach is simple: clean the data, find the signal, explain the “why”, and translate insights into actions leaders can implement.

Business Thinking

I don’t just visualize data — I explain what it means and what decision should follow.

Remote-Ready

Clear communication, structured delivery, and documentation that makes work easy to review.

Side skill: I also build clean portfolio websites and landing pages — useful for presenting analytics work professionally.

Experience

Aug 2024 – Present

Freelance Analyst & Web Projects (Portfolio + Client Work)

Freelance

Built professional portfolio/client websites and structured reporting pages to present business services clearly. I focus on clean, responsive delivery and data-ready layouts that support dashboards and decision reporting.

Dec 2023 – Aug 2024

Finance Account Associate

Flekc Freight & Logistics

Supported reporting and operations performance through budgeting, cost tracking, and compliance. Worked with financial records to identify cost drivers and improve accuracy in reporting and reconciliations.

May 2022 – Jan 2023

Accountant

Truce Lounge

Managed payroll support, budgeting, and expense tracking. Produced routine summaries for management to support purchasing, vendor follow-up, and cash control.

Education & Certifications

2022 – 2026

BSc. Economics & Finance

Kenyatta University

Training in quantitative reasoning, economic analysis, and finance fundamentals — now applied through real-world analytics projects.

In Progress

Certified Public Accountant (CPA) — Part 1 & 2

In Progress

Building strong foundations in accounting, compliance, and business reporting — useful for financial and operations analytics.

Completed

Google Data Analytics Professional Certificate

Coursera

Data cleaning, analysis, and structured problem-solving. Applied learnings to dashboard and case study projects.

Next Target

Microsoft Power BI Data Analyst (PL-300)

Planned

Strong industry-recognized certification for dashboards, data modeling, DAX, and reporting workflows.

Skills

Analytics Toolkit Built for Real Business Decisions

I focus on the skills companies test: data cleaning, SQL querying, KPI design, dashboards, and clear recommendations.

Core Tools

Excel (Advanced)
Strong

PivotTables, Power Query basics, XLOOKUP, dashboards, KPI tracking, data cleaning.

SQL (In Progress)
Growing

SELECT, WHERE, GROUP BY, JOINs, CTEs, window functions (next), analysis-ready queries.

Power BI (Building)
Building

Data modeling, measures (DAX), interactive dashboards, executive reporting.

Python (Optional Track)
Planned

Pandas for cleaning & analysis, basic visualization, simple forecasting (when needed).

What I Do With Data

Data Cleaning

Remove duplicates, handle missing values, standardize columns, build tidy datasets.

SQL Analysis

Extract, join, and aggregate data to answer business questions and track KPIs.

Dashboards & KPIs

Executive dashboards that show performance, drivers, and drill-down insights.

Business Recommendations

Turn analysis into actions: where to focus, what to fix, and expected impact.

Contact Carlton

I’m open to remote data analyst opportunities, freelance analytics work, and meaningful collaborations. For professional inquiries, email and LinkedIn are the best channels. If you prefer a short discussion, you can also schedule a quick call and I’ll be prepared.

Available for Remote Work
Nairobi, Kenya (EAT, UTC+3)
Response Time
Usually within 24 hours
Work Style
Clear communication • documented results
Core Tools
Excel • SQL • Power BI
Professional communication • No spam • Respectful follow-ups
Send a Message

Share the role, project, timeline, or main objective. I’ll review your message and respond within 24 hours.