Turning data into clarity — one day at a time.
A Data Analyst building real analytics systems through my structured #100DaysOfData journey.
I don’t just learn tools, I build automated pipelines that connect them:
- SQL for structuring databases
- Python for automated cleaning & ETL
- Power BI for insightful dashboards
- GitHub for documentation & systems thinking
blakusnaku analytics is where all those come together — a space dedicated to transforming curiosity into systems, and systems into clarity.
Building an automated multi-city pipeline using InsideAirbnb data (NY, Seattle, Portland).
Status: Data Cleaning → KPI Modeling → BI Integration
Exploring advanced interactive visualizations, automated pop-up generators, relationship graphs, and HTML-based storytelling.
Portfolio-grade tracker for learning KPIs, hours, skill progression, and project pipelines.
Automated multi-city ETL pipeline with schema validation, cleaning, transformation, and KPI modeling.
Live analytics tracking for study hours, completion %, and skill growth.
.PNG)
Interactive visualization lab exploring relationship graphs, automated popup generators, and HTML-driven visuals.
End-to-end BI project analyzing sales, profit trends, and discount effects.
Daily logs, pipelines, reflections, and all study-day outputs.
🔗 https://github.com/blakusnaku/blakusnaku-100-days-of-data
SQL • Python (pandas) • Power BI • Excel
DAX • ETL • Data Modeling • Automation • Dashboard Design
VS Code • SQLite • Google Sheets • GitHub • Canva
Each study day follows a 4-block workflow — a simplified version of real analytics pipelines:
| Block | Focus | Tool |
|---|---|---|
| 1 | SQL Querying & Schema Design | SQLite |
| 2 | Python Data Cleaning & Transformation | pandas |
| 3 | Power BI Visualization | Power BI |
| 4 | Reflection & Documentation | GitHub / Markdown |
📊 Track Progress:
Study Dashboard @ blakusnaku Analytics
📍 LinkedIn – JP Malit
💻 GitHub – @blakusnaku
🧡 X – @blakusnaku
Consistency builds skill — and skill builds opportunity.