Excel Superstore Sales Analysis
Excel Advanced
PivotTables
KPI Dashboard
9,994 rows
I turn businesses and financial data into decisions. SQL, Power BI , Excel, and Python. Available for remote roles worldwide.
Download CV
I'm Carlton Waiti, a Data Analyst and Economics & Finance finalist at Kenyatta University, Nairobi. I build financial dashboards, SQL analyses, and BI reports that answer real business questions. My projects have been independently rated 9.5–9.8 / 10.
I combine Economics & Finance academic training with hands-on data analytics — so I don't just describe what happened in the data, I explain why it happened and what the business should do next.
Cleaning and exploring datasets to surface patterns, inefficiencies, and growth opportunities using Excel, SQL, and Python.
Designing multi-page Power BI dashboards with star schemas, DAX measures, and bookmark navigation for executive reporting.
Analyzing audited financial data using IFRS-adjusted frameworks to identify anomalies, trends, and CFO-level insights.
Applying macroeconomic reasoning to interpret market conditions, policy impacts, and business performance in African markets.
Every project follows: business problem → data preparation → analysis → insights → recommendations. Each one is structured the way a consultant would present to a client.
SQL scripts, DAX measures, data models, and written analysis; everything is open and reviewable.
I'm Carlton Waiti — a BSc Economics & Finance student at Kenyatta University, Nairobi. My path into data analytics was anything but linear.
Before I ever opened Power BI or wrote a SQL query, I was out in the field collecting and analyzing data for research initiatives backed by UNICEF and the ILO, managing data integrity across hundreds of structured surveys, and translating raw field findings into reports that shaped real policy decisions. That experience taught me something most analysts learn much later: data is only as valuable as the decision it enables.
I now apply that thinking to business analytics. My Economics & Finance background means I don't just describe what happened in the data — I explain why it happened and what the business should do next.
What makes me different: I identified the Ethiopia IAS 29 hyperinflation gain anomaly in Safaricom's financials, the M-PESA COVID zero-rating inflection point, and the FY2022 capex spike as a strategic acquisition — not just numbers on a page.
Provide freelance data analytics and web development services to small businesses and entrepreneurs across Nairobi and remotely. Financial Analysis, Data Analysis.
At UDPK, in partnership with UNICEF and ILO, contributed to a UNPRPD-backed research initiative on disability inclusion in climate action across Nairobi communities. Used KoboToolbox and ODK. Outputs were policy-facing.
Conducted structured surveys across multiple Nairobi communities as part of UNICEF's national disability inclusion research program. Managed data integrity across hundreds of records.
Supported labor conditions research for domestic workers and caregivers across Nairobi as part of a union-led advocacy initiative. Data Analysis, Research Analysis.
Managed financial reporting, variance analysis, and compliance for a growing freight and logistics operation in the greater Nairobi area. Financial Accounting, Cash Flow, +10 skills.
Managed payroll support, budgeting, and expense tracking. Produced routine summaries for management to support purchasing, vendor follow-up, and cash control.
Specialising in quantitative economic analysis, financial modelling, and data-driven decision-making. Engaged in research-based fieldwork through partnerships with UNICEF and ILO. Building a portfolio of real-world analytics case studies focused on business performance, customer analysis, and financial insights.
Skills assessed against real delivered projects, not self-reported. Ratings from independent project reviews.
PivotTables, Power Query, XLOOKUP, KPI dashboards, data cleaning. 9,994-row retail sales project delivered.
CTEs, window functions, LAG(), DENSE_RANK(), analytical views, 10 business queries. Olist project rated 9.5/10.
Star schema, 20 DAX measures, PARALLELPERIOD, AVERAGEX, DATEDIFF, conditional color hex, bookmark navigation. Safaricom project rated 9.8/10.
Pandas, Matplotlib, Jupyter Notebook. Demand forecasting project in progress using Superstore dataset.
My edge: Economics & Finance academic foundation applied to every analysis. I explain the business reasoning behind the numbers, not just the numbers themselves.
Open to remote Data Analyst roles, freelance analytics work, and meaningful collaborations. Email and LinkedIn are the fastest channels.
Share the role, project, or objective. I'll respond within 24 hours.