Hospitality
Airbnb Executive Dashboard
Executive dashboard analyzing pricing, occupancy trends, neighborhood performance, and revenue opportunities.
Explore Case Study →Hello, I'm
Somel Eraño Chan (Soms)
Business Intelligence
& Process Improvement Professional
I bridge the gap between data and business by combining analytical thinking, process improvement, and practical data solutions to solve problems, uncover insights, and help teams make better decisions.
Explore My Portfolio →About Me
I’m a Business Intelligence & Process Improvement Analyst specializing in data analytics, Power BI, Excel, SQL, KPI development, and process improvement.
I turn business data into clear insights that help organizations understand performance, identify opportunities, improve processes, and make better decisions. My experience includes developing dashboards and reports, analyzing operational and financial data, designing performance metrics, and delivering data-driven solutions for business needs.
I take an end-to-end approach to analytics—from understanding the business problem and preparing the data to analysis, visualization, insights, and recommendations.
I’m open to part-time, project-based, freelance, consulting, and full-time opportunities in Business Intelligence, Data Analytics, Reporting, and Process Improvement.
Every project in this portfolio follows a structured analytics workflow—from understanding the business problem to delivering actionable recommendations.
Featured Analytics Projects
Browse through my end-to-end analytics case studies.
Banking
Bank Churn Analysis
Customer retention dashboard identifying churn drivers, high-risk customers, and business opportunities.
Explore Case Study →
Healthcare
Hospital ER Analysis
Analyze patient waiting times, referrals, emergency room utilization, and operational efficiency.
Explore Case Study →
HR
HR Data Analytics
Workforce insights including employee demographics, attrition, diversity, and HR KPIs.
Explore Case Study →
Banking
Financial Consumer Complaints
Customer complaint analytics highlighting issue trends, service quality, and resolution insights.
Explore Case Study →
Manufacturing
Manufacturing Downtime
Discover production losses, downtime reasons, and operational improvements.
Explore Case Study →
Retail
Food & Beverage Sales
Sales dashboard for revenue, product performance, profitability, and customer purchasing behavior.
Explore Case Study →
Finance
Financial Report Dashboard
Executive financial reporting using KPI monitoring, profitability, and performance tracking.
Explore Case Study →Capstone Projects
Larger, end-to-end capstone builds across different analytics tools.
Certifications
Data Analytics Fundamentals
DataSense Analytics
May 2026
Advanced Excel Formula
DataSense Analytics
June 2026
Power BI Guided Projects
DataSense Analytics
July 2026Technical Skills
Power BI
DAX
Power Query
SQL
Excel
Python(Ongoing)
Data Modeling
Dashboard Design
Business Analysis
Data Storytelling
Lean Six Sigma