Transforming Data into Business Intelligence

Hi, I'm Deric Marangu

Business/Data Analyst, BI Specialist & ICT Systems Support

I transform complex datasets into clear, actionable insights that drive business growth. With expertise in Python, SQL, Excel, and Power BI, I help organizations make data-driven decisions. As a Business Information Technology graduate, I also keep hospital ICT systems running and build custom business software that replaces manual paperwork.

0
Projects Completed
0
Years Experience
0
Client Satisfaction
Deric Marangu - Business/Data Analyst, BI Developer and ICT Systems Support

My Journey Through Silence to Data

From quiet observer to data storyteller - A journey of transformation

2001

The Beginning: Born into Humility

I was born in 2001 into a humble family, growing up in a society that often dismissed my opinions and made me feel like my voice didn't matter. This environment gradually shaped me into extreme introversion, self-centeredness, and low self-esteem. Making genuine friends felt impossible, so I created imaginary companions who wouldn't judge me. Books became my sanctuary, my true friends in a world that didn't understand silence.

Childhood

The Mind's Cinema: Endless Replays

My mind became a theater constantly replaying every interaction, every moment, like an endless movie. But these replays weren't entertaining - they were sources of frustration and self-doubt. Each failure, each awkward moment, played on loop, breaking me down piece by piece. At puberty, my teachers grew concerned about my profound silence, sending me to local counselors and motivators, but my operating system seemed to shut down in public spaces.

Primary School

Finding Solace in Silence

In my final year of primary school, I found my tribe - people who, like me, drew energy from solitude rather than noise. For the first time, my silence became a source of pride rather than shame. I became unique in the entire school - known not for being loud, but for my profound quietness. Teachers respected me, students greeted me with honor, and even the noisiest touts in matatus seemed to absorb my calm energy. I had become a noiseless celebrity.

High School

The Boundary of Labels

High school brought new challenges as I learned about introverts and extroverts from peers. These labels drew boundaries I hadn't known existed. Every gaze started to mean something else - "They think I hate them," "They don't like me," "She wants more talkative people." My pride turned to paranoia, and I began what I call mental self-torture, replaying scenarios, people, and moments thousands of times in my mind.

Self-Discovery

Finding Control in Data

I asked myself: "What am I good at?" The answer was clear - I excelled at overthinking and analysis. Data gave me a sense of control I desperately needed. Since childhood, my life had depended on data - how someone treated me determined whether I'd say hello the next morning, how someone looked at me decided if they were friend or enemy. Spontaneity felt impossible; I needed proof from data. This realization sparked my passion for data analysis.

Transformation

From Self-Analysis to Business Intelligence

I immersed myself in YouTube, studying patterns for survival. As I grew older, more realities revealed themselves, creating more insecurities and mental loops. I learned from renowned mentors online - Vanessa Edwards, Robert Greene, Brian Tracy - hoping one day for official therapy. I devoured books from "Atomic Habits" to "How to Win Friends and Influence People," all to outsmart my own operating system.

University

Amplifying My Purpose

At university, studying Business Information Technology, I found my calling. The degree opened me to human psychology, computer systems, data, and analysis - it amplified my natural persona. When AI emerged, I had both data and sources, transforming me into a full data analyst. Today, I don't analyze smiles or walking styles anymore - I analyze three-year sales trends, marketing patterns, and consumer behavior to help businesses make informed decisions.

Today

Facing Life by the Horn

While social challenges still exist, I now face them head-on using data-driven decisions. Yesterday, during a market visit, I felt the familiar urge to hide from the stage and multitude. But instead, I walked forward, knowing from my data that these fears are my brain's false alarms. This is just 1/1,000,000th of what I carry. I have much to share and even more to learn, which is why you'll find me daily on my computer, exploring best practices.

Thanks to the internet, I learned that one way to deal with social anxiety is to talk it out - and that's exactly what I'm doing now, turning my greatest challenge into my greatest strength through the power of data.

"I don't just analyze data—I understand the human stories behind every number. Because I've spent a lifetime learning to read between the lines, to see patterns where others see chaos, and to find truth in the silence between data points."

Technical Expertise

Tools and technologies I use to transform data into insights

Data Analysis

  • Python & Pandas
  • Exploratory Data Analysis (EDA)
  • Statistical Analysis
  • Data Cleaning & Validation
  • Data Visualization

Database Management

  • SQL & MySQL
  • Database Design
  • Query Optimization
  • Data Modeling
  • ETL Processes

Business Intelligence

  • Power BI & DAX
  • Excel Advanced Analytics
  • Dashboard Development
  • KPI Tracking
  • Interactive Reports

Analytical Thinking

  • Pattern Recognition
  • Problem Decomposition
  • Critical Thinking
  • Data Storytelling
  • Business Insights

Web Development

  • HTML5 & CSS3
  • JavaScript
  • PHP
  • Responsive Design
  • Web Analytics
  • API Integration

AI & Automation

  • AI-Powered Data Analysis
  • Domain Knowledge Brainstorming
  • Script Generation & Optimization
  • Complex Data Interpretation
  • Continuous Learning & Skill Enhancement

Digital Marketing

  • SEO (Search Engine Optimization)
  • Social Media Marketing
  • Email Marketing
  • Digital Prospecting
  • Landing page & website content understanding

ICT & Systems Support

  • Network & System Administration
  • Hardware & Software Troubleshooting
  • ICT Asset Management & Tracking
  • User Support & Technical Documentation
  • Hospital Information Systems Support

Custom Business Software

  • Desktop & Web Business Applications
  • Database-Backed Tools
  • Role-Based Access & Financial Records
  • Automated Reporting Workflows
  • User Training & Support

Featured Projects

Real-world data analytics solutions that delivered measurable results

Pharmacy Management System screenshot
Healthcare Software

Pharmacy Management System

Stock and sales management application for a pharmacy with role-based access, secure financial records, expiry-aware stock control that sells the soonest-to-expire stock first, and a built-in user assistant. Runs as an installed Windows program.

Desktop App Database Role-Based Access
Less expired stock, accurate sales records
Small Business Management System screenshot
Business Systems

Small Business Management System

Integrated system for production tracking, true-cost calculation and automated reporting, so owners see real costs, output and performance without manual paperwork.

Production Costing Reporting
True costs and reports, automated
Imara: Manufacturing Management System screenshot
Manufacturing Software

Imara: Manufacturing Management System

Business management system for a wire nail manufacturer covering production, stock, sales invoices, expenses and ledgers, with cost-matched profit reporting, input validation and secure backups. Runs as an installed desktop application.

Electron Node.js SQLite
True cost and profit per unit sold
Hospital ICT Asset-Tracking Tool screenshot
ICT Management

Hospital ICT Asset-Tracking Tool

Internal tool that records every ICT asset of a hospital, where each item is located and who it is assigned to, replacing scattered lists with one reliable inventory.

ICT Assets Inventory Hospital
One reliable equipment inventory
Outpatient & Inpatient Reporting Dashboards screenshot
Healthcare Analytics

Outpatient & Inpatient Reporting Dashboards

Operational dashboards that help hospital departments monitor performance and give management a clear view of what is happening across the facility.

Power BI Excel KPI Reporting
Departments see performance at a glance
Cafeteria Business Report (20 Months) screenshot
Business Reporting

Cafeteria Business Report (20 Months)

Analysis of twenty months of cafeteria sales and operations data, turned into a clear business report on trends and performance.

Excel Power BI Data Cleaning
20 months of data, one clear report
E-commerce Performance Dashboard
Retail Analytics

E-commerce Performance Dashboard

Comprehensive analysis of online retail performance with customer segmentation and sales forecasting that increased conversion rates by 23%.

Power BI SQL Python
23% increase in conversions
Banking Data Visualization System
Financial Analysis

Banking Data Visualization System

Interactive financial dashboard for tracking transactions and customer insights that reduced reporting time by 65%.

Excel Power BI SQL
65% faster reporting
Customer Behavior Analysis
Marketing Analytics

Customer Behavior Analysis

Deep dive into customer purchasing patterns and marketing campaign effectiveness that optimized ad spend by 31%.

Python SQL Power BI
31% ad spend optimization
Sales Forecasting Model
Predictive Analytics

Sales Forecasting Model

Advanced time-series forecasting model that improved sales prediction accuracy by 42% and reduced inventory costs.

Python Excel SQL
42% better predictions
Inventory Management System
Operations Analytics

Inventory Management System

Real-time inventory tracking and optimization system that reduced stockouts by 78% and improved turnover ratio.

SQL Power BI Excel
78% fewer stockouts
Healthcare Analytics Platform
Healthcare Analytics

Healthcare Analytics Platform

Comprehensive healthcare data analysis platform that improved patient outcomes and reduced operational costs by 27%.

Python SQL Power BI
27% cost reduction

Interested in seeing more of my work?

View All Projects on dericBI

Professional Experience

My journey through data analytics roles and responsibilities

St. Anne Mission Hospital Feb 2026 - Present

IT Intern

St. Anne Mission Hospital
Supporting ICT operations, developing operational reports and dashboards, and providing technical support across hospital information systems and infrastructure.
  • Develop operational and management reports
  • Data cleaning, validation, and analysis
  • Design dashboards and reports using Power BI and Excel
  • Support network administration and ICT infrastructure maintenance
  • Provide technical support for hardware, software, and hospital information systems
  • Maintain an up-to-date inventory of hospital ICT equipment (location and assigned users) and technical documentation
  • Provide day-to-day technical support to staff and troubleshoot ICT issues to keep hospital operations running
  • Support departments (including Renal) with patient-record organization and departmental reporting
  • Verify underlying records for accuracy before reporting, and build simple visual dashboards for departments
  • Support data-driven decision-making through reporting and analysis
Teaching 2023 - Present

Computer Literacy & Data Analytics Instructor

Teaching computer literacy and data analytics to underserved communities, developing comprehensive curriculum, and mentoring students in data visualization techniques.
  • Teaching computer literacy and data analytics to underserved communities
  • Developing comprehensive data analytics curriculum for beginners
  • Mentoring students in data visualization and analysis techniques
  • Creating interactive learning materials and real-world projects
  • Empowering youth with digital skills for the modern workforce
Data Analysis Jan 2025 - Present

Business/Data Analyst & Consultant

Developing interactive dashboards and custom business applications for retail, healthcare and service clients, automating reporting processes, and providing data-driven insights for business strategy. Explore my consultancy work.
  • Developed interactive dashboards for retail and service clients
  • Automated reporting processes saving 20+ hours weekly
  • Provided data-driven insights for business strategy
  • Built custom business applications, websites and database-backed tools for operational workflows
  • Cleaned and organized messy client data into reliable reports and usable business information
  • Mentored small businesses in data literacy
IT Assistant May 2024 - Jul 2024

IT Assistant (Industrial Attachment)

Kinoro Tea Factory
Analyzed operational and logistical data, maintained Excel-based reporting systems, and supported data-driven agricultural decisions.
  • Analyzed operational and logistical data
  • Maintained Excel-based reporting systems
  • Supported data-driven agricultural decisions
  • Processed farmer data for production optimization
  • Analyzed logistics, vehicle turnaround and farmer-delivery data to support operational planning
  • Supported sustainability reporting and compliance activities
  • Provided general IT troubleshooting and technical support to staff
Kirinyaga University 2021 - Oct 2025

Bachelor of Business Information Technology (BBIT)

Kirinyaga University
Graduated October 2025. Specialized in Data Analytics and Information Systems, developing expertise in database management and advanced data visualization techniques.
  • Graduated October 2025 with a Bachelor of Business Information Technology
  • Specialized in Data Analytics and Information Systems
  • Developed expertise in database management
  • Learned advanced data visualization techniques
  • Building foundation in business intelligence

Frequently Asked Questions

Quick answers about who I am, what I do and how I can help

Who is Deric Marangu?

Deric Marangu (full name Deric Mwiti Marangu, trading as DericBI) is a Business Information Technology graduate of Kirinyaga University (October 2025), based in Meru, Kenya. He works as a data analyst, Power BI and BI developer and ICT systems support specialist, and builds custom business software for hospitals and small businesses.

What does Deric Marangu do currently?

Since February 2026 he has been an IT intern at St. Anne Mission Hospital, supporting hospital computers, networks and information systems, keeping the ICT asset inventory, and building operational reports and dashboards. Since January 2025 he has also worked as a freelance data analyst and BI developer through DericBI.

What services does DericBI offer?

DericBI offers Power BI and Excel dashboards, automated reporting and KPI tracking, data cleaning and analysis, custom business applications and database-backed tools, ICT support and asset tracking, and training in computer literacy and data analytics.

Which tools and technologies does Deric Marangu use?

Power BI, Excel, SQL, Python, HTML, CSS, JavaScript and PHP, together with network and system administration tools for ICT support. He also uses AI tools to speed up software development, documentation and workflow improvement.

What systems has Deric Marangu built?

Examples include a pharmacy management system with role-based access, financial records and expiry-aware stock control; a small business management system for production tracking, true-cost calculation and automated reporting; Imara, a desktop management system for a wire nail manufacturer built with Electron, Node.js and SQLite; and a hospital ICT asset-tracking tool.

How can I contact Deric Marangu or hire him for a project?

Deric is based in Meru, Kenya and is available for freelance projects. Contact him on WhatsApp at +254 791 360 805, by email at dericmarangu@gmail.com, or through LinkedIn.

Let's Work Together

Ready to transform your data into actionable insights?

Location

Meru, Kenya

Phone

+254 791 360 805

Email

dericmarangu@gmail.com