Experienced Data Analyst specializing in Power BI, SQL, Excel, Reporting Automation, Financial Reconciliation, and Business Intelligence. Helping organizations transform complex datasets into actionable insights through dashboards, analytics, automation, and data storytelling.
I'm Charles Edquila, a Data Analyst and Business Intelligence Developer with hands-on experience turning messy datasets into clean, decision-ready insights. Currently working as a Junior Analyst at Alera Group, I bring hands-on experience in Power BI development, reporting automation, and financial reconciliation gained across multiple roles in data and analytics.
My work spans the full analytics lifecycle — from raw data ingestion and reconciliation to executive-level dashboards and automated workflows. I've reduced manual reporting overhead by 80% through Power Automate and API-integrated solutions, and I consistently deliver actionable intelligence that helps stakeholders make faster, more confident decisions.
I hold a BS in Information Technology from PRMSU, graduating With Academic Distinction, and I'm certified in Data Analytics with Power BI through DataSense Analytics. I bring both technical depth and business communication skills to every project.
End-to-end data and analytics solutions tailored to your business needs.
Executive dashboards, KPI reporting, operational reporting, and end-to-end business intelligence solutions built with DAX and data modeling best practices.
Data cleaning, trend analysis, forecasting, business insights, and comprehensive reporting that translates complex data into clear, actionable recommendations.
Advanced Power Query transformations, dynamic Pivot Tables, KPI tracking models, and fully automated reporting workbooks for operational efficiency.
Power Automate workflows, REST API integrations, and automated business reporting pipelines that eliminate manual effort and improve data freshness.
A track record of delivering data-driven value across industries.
Real-world analytics solutions across Power BI, SQL, Excel, and Python.
Analyzed Emergency Department operations through patient demographics, operational performance, patient experience, and Monte Carlo-based demand forecasting for 2025.
Analyzed 11,757 flood control projects worth ₱705.2B (2018–2025), achieving Top 6 in the Power BI Pilipinas Contest. Surfaced critical contractor gaps and 80.5% completion rates.
Multi-page interactive dashboard analyzing revenue, profit, premium, claims, and loss ratios across a simulated insurance portfolio with DAX-based KPI modeling.
Analyzed ₱1.4B in sales across 50K+ rows, uncovering a 10–15% cross-category sales gap with seasonal demand patterns and actionable pricing recommendations.
Dashboards evaluating job roles, salary benchmarks, and programming language usage across tech professions, built with Power Query and Excel data transformation.
End-to-end data cleaning pipeline using MySQL: duplicate removal, date normalization, missing value imputation via self-joins, and staged backup strategies.
Analyzed global layoff data using MySQL window functions, rolling totals, and country/industry breakdowns to surface workforce reduction patterns.
Pivot-based KPI tracker analyzing regional sales, demographic segments, and product categories. Identified a $1M loss in Enterprise and recommended targeted pricing strategies.
Interactive Streamlit web application with real-time BMI calculation, validation logic, and personalized feedback. Published publicly on Streamlit Cloud.
Live AppA full-stack analytics toolkit spanning data engineering, visualization, and automation.
Open to BI projects, analytics consulting, and full-time opportunities.