Profile Picture
Data Analyst ยท Tacloban, Eastern Visayas, PH

Kirk Lester Olayer

Data analyst turning raw numbers into clear, actionable decisions. Specializing in SQL querying, Power BI dashboards, and Excel data modeling โ€” always looking for the story behind the numbers.

SQL Power BI Excel MySQL Data Visualization DAX

4 case studies
๐Ÿ“Š

TechNova sales report

Analyzed โ‚ฑ85M in total sales across Luzon, Visayas, and Mindanao. Built monthly trend charts and regional breakdowns with sales rep performance tracking.

Power BI DAX Excel
๐Ÿ’ธ

Spend data dashboard

Built a Power BI dashboard tracking spending by customer segment, city, and store number โ€” covering corporate, home office, consumer, and small business segments.

Power BI Data Modeling Excel
๐ŸŒŠ

DPWH flood control tracker

Developed a Power BI dashboard monitoring 320 DPWH flood control projects nationwide, tracking โ‚ฑ326bn budget utilization, project status, and flood incident reduction by region.

Power BI Government Data DAX
๐Ÿ—„๏ธ

Delivery fee SQL analysis

Queried and filtered a deliveries database using MySQL โ€” filtering by delivery fee thresholds, region (NCR), and vehicle type to surface logistics insights.

MySQL SQL Querying Data Filtering

PDF previews
TechNova Sales Report
โ‚ฑ85M total sales ยท 3,254 units ยท Luzon, Visayas, Mindanao
Open PDF โ†’
Spend Data Dashboard
Customer segments ยท City-level spend ยท Store performance
Open PDF โ†’
DPWH Flood Control Project Tracker
320 projects ยท โ‚ฑ326bn budget ยท 17 regions nationwide
Open PDF โ†’

Tools & proficiency
SQL / MySQL
82%
Power BI
80%
Excel
85%
DAX
75%
Data visualization
80%
Data modeling
75%

Let's connect
๐Ÿ”—
LINKEDIN
linkedin.com/in/kirkolayer
โŒจ
GITHUB
github.com/Watzx
๐ŸŒ
PORTFOLIO
watzx.github.io/kirkolayer
๐Ÿ“
LOCATION
Tacloban, Eastern Visayas, PH