Dorcus Nyangasi
Data Analytics and Reports Intern at Minet Kenya
Data Analytics at ALX
Kenya
Hi, I'm Dorcus Nyangasi!
Data Analytics and Reports Intern at Minet Kenya
A dedicated and skilled professional with a strong background in Applied Statistics and Data Analytics. Dorcus Nyangasi is passionate about leveraging data analysis, data insights, innovative solutions to drive impactful outcomes. With a proven track record in Analysis, Dorcus specializes in Power BI analysis. A lifelong learner, Dorcus is committed to continuous improvement and excellence in all endeavors. Outside of work, Dorcus enjoys community service, exploring technology, and adventure bringing creativity and enthusiasm to every aspect of life.
Experience
Minet Kenya
Data Analytics and Reports Intern
October 2024 - Present
- Examine submitted claims for accuracy and completeness.
- Cross-check claim details against the policy terms, coverage limits, and exclusions.
- Calculate claim settlements, balancing customer satisfaction with cost efficiency.
- Maintain records of claims for auditing and reporting purposes.
- Generate reports on claim trends, patterns, and metrics using Power BI to assist in decisionmaking.
- Work with other departments, such as underwriting, to resolve complex claims
Khwisero County Polytechnic
ICT Instructor Volunteer
March 2024 - August 2024
- Plan and deliver ICT training sessions on various topics, including computer basics, Microsoft Office Suite, internet usage, and basic programming, tailored to the needs of students and staff.
- Assess and Monitor trainees' progress through tests, assignments and practical exercises.
- Guide Practical Learning Activities. 4 Manage the ICT training lab, ensuring that all computers, software, and peripheral devices were updated, well-maintained, and ready for use during training sessions.
- Kept accurate records of training sessions, attendance, and student progress.
- Taught basic cybersecurity practices to promote safe and responsible use of ICT resources, including the importance of data protection, password management, and safe internet usage.
Kakamega County Revenue Agency
Attachee
May 2022 - July 2022
- Compiled comprehensive statistical data for analysis and reporting purposes.
- Assisted in drafting work plans to guide the agency's operations and resource allocation.
- Developed logical frameworks to outline project objectives, activities, and expected outcomes.
- Performed accurate data entry and conducted data analysis using Excel software to generate insights.
- Participated in collecting data from various sources to support revenue analysis and reporting.
- Created matrices to monitor and evaluate project performance and progress.
- Assisted in the review and validation of sector plans to ensure alignment with strategic goals.
- Contributed to the allocation of revenue collection targets across sub-counties to optimize efficiency.
- Analyzed trends in revenue collection to identify patterns and inform strategic decisions
Education
Data Analytics
ALX
Graduated in 2024
Certificates & Badges
No certificates or badges added
Projects
Total Hip Replacement Analysis Dashboard
•https://drive.google.com/file/d/1aruZPHNojyiFeS2dDHHC6bURs9uc-yni/view?usp=sharingPower BI Analysis
Developed an interactive Power BI dashboard to analyze inpatient discharges for total hip replacements using a dataset from DataCamp. The project highlights patient demographics, Length os Stay trends, medical details, and financial performance. Key features include visualizations for hospital performance, procedure insights, and cost analysis.
This project employs Power BI to create dynamic visualizations of water resource data in Maji Ndogo, offering a comprehensive view of the community’s water challenges and opportunities. By transforming complex datasets into intuitive dashboards, the analysis uncovers trends, identifies inefficiencies, and highlights actionable solutions. The project showcases the potential of data visualization to drive informed decision-making and sustainable change in water resource management.
MySQL Analysis: Restoring the Lifeblood of Maji Ndogo
•https://1drv.ms/u/c/a35a8ab197f2bbc4/EQ--8AXRlQZLgiTTEWOZwMIB0DPX1n-aIMcw0SQ3ZiMBHw?e=fWPYfFData Analysis
This project leverages MySQL to analyze and address water supply challenges in Maji Ndogo, a community grappling with limited access to clean water. By examining water usage patterns, infrastructure deficiencies, and potential improvements through database-driven insights, the project provides actionable recommendations to restore and sustain the community's vital water resources. This analysis underscores the power of data in driving impactful solutions for water equity.
Investigating Access to Safe and Affordable Drinking Water: Google Sheets Analysis
•https://docs.google.com/spreadsheets/d/1qEpNHjd66_l7PCu-JxDAmvz7zBrszfccdCrRZ3aQt6M/edit?usp=sharingData Analysis
This project explores the critical issue of access to affordable drinking water across different countries, analyzing disparities using population size, area and income group. By examining water quality, availability, the research highlights how various people access clean and affordable water. The project integrates data-driven insights, case studies, and innovative approaches to address one of the most pressing global needs—equitable access to clean water.
Languages
English
Swahili
Skills
Data Analysis
Data Collection
Teamwork
Data Visualization
Excel Expert
SQL
Power BI
Communication
Ready for a personalized experience? We use cookies and similar technologies to tailor our site just for you. By clicking 'Accept', you're giving us the thumbs up to use cookies and similar technologies. 🍪