I'm Allesandro Yudo Asmara - Data Analyst & Excel Expert.
I blend business × technology to ship dashboards, automations, and data analysis that accelerate decisions. Tools: Excel, Sheets, SQL, Python, Tableau, Power BI, Looker. Detail-oriented, outcome-driven, and fast to deliver.
- 🏆 Microsoft Office Specialist - Excel Expert (Certified)
- 🎥 Content Creator - 48k social followers
- 🎯 Educator - helped 3,000+ learners upgrade their data skills at Kerja.id
About
Hello, I'm Sandro. Passionate about the synergy of business and technology. I build clean pipelines, useful dashboards, and lightweight automations for real-world teams - from F&B and retail to insurance and education. I’m a detail-oriented problem solver committed to delivering high-quality results promptly.
What I do
ETL with Power Query/Python, data modeling (star schema), KPI dashboards, Excel/Sheets automation, training & documentation.
How I work
Start with decisions → metrics → minimal MVP. Iterate fast with feedback; measure time saved & business impact.
Impact
Cut manual prep by 80% via automation; accelerated reporting; taught hundreds with 4.9/5 average rating.
Skills
Data & BI
Excel, Power Query, Power Pivot, Power BI, Google Sheets, Looker Studio, Tableau
Programming
Python (pandas), SQL (BigQuery), VBA, Apps Script, OOP, Prompt Engineering
Soft Skills
Problem solving, analytical thinking, public speaking, leadership, communication
Projects
Click a card to view details. Each project includes ⚠️ Problem, 🎯 Objective, and 🛠️ Solution. Use the group filter to browse Dashboards, Programming, or Data Analysis.
On-Going Projects
Here are my two business projects developed by me (and team).
Experience
- Developer & Instructor - Kerja.id · Jan 2024-PresentBuilt LMS, authored Excel-for-DA curriculum (eBooks + exercises), mentored hundreds (avg 4.9/5 rating).
- Market Data Analyst Manager - PT. Pesta Porta Abadi · Oct 2024-Mar 2025Built BigQuery pipelines (Sheets/POS/API), Looker dashboards, and a Python geo-mapping app; improved tracking & decisions.
- Data QA Engineer (IFRS17) - FWD Insurance · May 2023-Oct 2024Automation with Excel VBA/Python; rigorous data quality validation; ETL mapping & UAT support.
- Data Analytics Student Development Coordinator - RevoU · Nov 2023-May 2024Ensured learning experience & curriculum alignment; reporting & QC for student activities.
- Data & Excel Content Creator & Freelancer - Self-Employed · Jan 2023-PresentContent & services for Excel/Data; clients incl. BCA Insurance, PLN Icon Plus, Monde, Adaro Services, SJEC, BPR Arto Moro, etc.
- Data Analyst - PT. Medikal Putri Sharavasti · Aug 2022-Jan 2023Data cleaning/analysis, ad-hoc reports & visualizations to answer business questions.
- Data Analyst Associate (Virtual Internship) - RevoU × Astro · Sep 2022-Nov 2022Led projects; dashboards by level; ML clustering for marketing; forecasting & simulation.
- Small Business Owner - Bubobi · Mar 2020-Apr 2021Built & ran a boba brand; learned digital marketing, ops, selling, resource mgmt.
- Supervisor HRD - Ramayana · Mar 2019-Jun 2020Leadership & coordination foundations supporting later analytics roles.