// DASHBOARD
TOOL Power BI · Tableau · Looker · Excel| DATABASE SQL Server · PostgreSQL| LANGUAGE Python · SQL| PROJECT Sales & Demand Analytics| PYTHON Numpy · Pandas · pyodbc| MODELLING DAX · Star Schema · Pivot Table · XLOOKUP · VLOOKUP| STATUS Actively Learning| SPECIALIZATION Data Analytics & Engineering| TOOL Power BI · Tableau · Looker · Excel| DATABASE SQL Server · MySQL| LANGUAGE Python · SQL| PROJECT Sales & Demand Analytics| PYTHON Numpy · Pandas · pyodbc| MODELLING DAX · Star Schema · Pivot Table · XLOOKUP · VLOOKUP| STATUS Actively Learning| SPECIALIZATION Data Analytics & Engineering|
// Data Analyst | Computer Engineer

Mark John
Meraña.

I build end-to-end data solutions—from ingesting and transforming raw data to delivering analytics dashboards and actionable insights.

// Based in Philippines  ·  Available for roles

// What I Can Do
Data Analyst
Primary
Python SQL Server Power BI Looker DAX Excel Star Schema
Data Engineer
Supporting
Python Airflow dbt PostgreSQL Superset MinIO Docker
Backend Engineer
Learning
FastAPI Python REST APIs PostgreSQL
Currently available for full-time.
Current Tech Stack

What I'm Working With Right Now

Focused, honest, and actively building depth in each tool.

📈
Dashboard & BI
Primary Skill
Building interactive reports, KPI cards, slicers, and drill-through pages. Learning DAX measures and calculated columns.
🗄️
SQL Server & PostgreSQL
Primary Tool
Writing queries, JOINs, aggregations, and stored procedures. Designing simple star schemas for BI consumption.
🧩
Data Engineering
Supporting Tool
ETL, ELT, dbt for data manipulation and preparation before loading into SQL Server, perform visualization.
🐍
Python
Supporting Tool
Writing basic automated data extraction, cleaning, and manipulation for data analysis and engineering
Projects

Published Work

All posts →
Dashboard
Project 1 — Power BI Dashboard
Power BISQL ServerDAXData Modeling

My First End-to-End Power BI Dashboard: Plant Wilting Detection

How I took sensor data stored in SQL Server, built a flat table schema, wrote DAX measures, and created a live Power BI report that tracks plant health in real time.

Sales Analytics Dashboard
Project 2 — Sales & Demand Analytics · Part 1 of 4
Power BIPythonStar SchemaDescriptive

From Raw CSV to Professional Dashboard: Building a Sales Analytics Pipeline

A complete end-to-end pipeline — from a raw 9,994-row Kaggle CSV through Python cleaning, star schema design, to an interactive Power BI dashboard. Part 1 of 4.

Sales Analytics Dashboard
Project 3 — Sales & Demand Analytics · Part 2 of 4
Power BIPythonStar SchemaDiagnostic

From Raw CSV to Professional Dashboard: Building a Sales Analytics Pipeline

A complete end-to-end pipeline — from a raw 9,994-row Kaggle CSV through Python cleaning, star schema design, to an interactive Power BI dashboard. Part 2 of 4.

📦// Future project
Coming Soon — Project 4

Another SQL or BI Case Study

...