I will build excel dashboards and automate reports with vba

Kenya

I speak English

2 orders completed

Data Analysis Mojo

Data | Data Analytics | Statistical Modeling & Analytics | RStudio, R, SPSS, Python, Excel. I specialize in statistical modeling & analytics using R and RStudio to turn complex datasets into publicat...
About this Gig

Hello, I engineer high-impact BI analytics control panels and dynamic financial analytics models that convert raw spreadsheets into visual operations centers. Using advanced Power Query pipelines, custom VBA macros, and interactive Excel dashboard setups, I streamline your tracking systems for sales performance, financial forecasting, and operational KPIs.


What you get:

- Custom Interactive Excel Dashboards with dynamic filters & slicers

- Financial Modeling & Forecasting spreadsheets (P&L, Cash Flow)

- VBA / Macro automation to eliminate repetitive manual entry

- Power Query setup for automated data cleaning & multi-sheet merging


Whether you are tracking e-commerce sales, project budgets, or sales commissions, I deliver highly secure, scalable, and easy-to-use spreadsheet tools. Contact me before placing an order to discuss your exact tracking needs!

Technology:

Excel

•

Google Analytics

•

Google Sheets

•

MATLAB

•

Power BI

Analysis Type:

Quantitative Analysis

•

Statistical Analysis

Expertise:

Business Insights

•

Trends

•

Forecasting

•

Probability

•

Math

Programming language:

Python

•

R

•

SPSS

•

Other

Tools:

Jamovi

•

RStudio

•

Stata

•

Google Colab

•

Microsoft Excel

My Portfolio