c
cate__analyst

Catherine M

@cate__analyst

Data Analyst

Kenya
English
About me
I am a business data analyst proficient with using Excel, SQL, Power BI and Python for analysis. Skilled in data collection, cleaning, and visualization, I specialize in identifying trends, uncovering hidden patterns, and providing clear, data-backed recommendations for decision-makers. I have experience in retail operations, sales performance reporting, project management, and process documentation. I am adept at building dashboards, automating reports, and developing predictive models to solve complex business problems.... Read more

Skills

c
cate__analyst
Catherine M
Offline • 
Average response time: 3 hours

See my services

Data Formatting
I will do excel data cleaning, formatting, deduplication and sorting
Data Dashboards
I will create power bi dashboards and reports for business insights

Portfolio

Work experience

Upwork

Sales & Marketing Analyst

Upwork • Freelance

Sep 2024 - Apr 20261 yr 7 mos

Performed data cleaning, data preprocessing, and data validation on sales and marketing datasets using Excel Conducted data analysis to identify trends in sales performance, customer behavior, and marketing campaigns Built interactive Excel dashboards and data visualizations to track KPIs such as revenue, conversion rates, and product performance Transformed raw data into actionable insights to support data-driven decision-making Created reports and dashboards for business intelligence and performance tracking Applied data wrangling techniques including deduplication, formatting, sorting, and structuring datasets Analyzed CRM data, e-commerce data, and campaign metrics to improve reporting accuracy Used Microsoft Excel and Google Sheets for data analysis, reporting, and visualization Improved data quality and data integrity by standardizing and organizing datasets

Nonprofit Solutions Matter

Full-time • 5 yrs 11 mos

Monitoring and Evaluation Assistant

Oct 2022 - Aug 20241 yr 10 mos

Collected, cleaned, and managed program data to ensure data accuracy, consistency, and reliability Supported monitoring and evaluation processes by tracking project indicators and performance metrics Conducted data analysis on program outcomes to assess impact and inform decision-making Maintained and updated databases and data collection tools (Excel/Google Sheets) Assisted in developing M&E frameworks, logframes, and indicators for program tracking Prepared reports and data visualizations to communicate findings to stakeholders and donors Performed data validation and quality assurance checks to improve data integrity Analyzed survey and field data to identify trends, gaps, and program performance insights Supported baseline, midline, and endline evaluations Collaborated with field teams to ensure accurate data collection and reporting processes

Business Counsellor

Aug 2018 - Sep 20224 yrs 1 mo

Trained and mentored over 350 entrepreneurs, guiding them on the best ways to grow their businesses and make better financial decisions. Worked closely with partners and local authorities to build program capacity and improve program visibility. Collected and organized performance data, supporting monitoring activities and reporting. Facilitated market linkages that improved income stability for 40% of entrepreneurs.