My page
Analytics Engineer
Explorer
mypage_db
Tables
fact_daily_activity
dim_engineer
skills
activity
writing
projects
Views
Saved Queries
mypage_db
engineer_id = 1
1 -- What I work with every day.
2 -- Data Modeling is my core passion — I love turning messy data into clear structures.
3 SELECT s.skill_name, s.category, s.proficiency
4 FROM dim_skill s
5 JOIN dim_engineer d ON d.engineer_id = s.engineer_id
6 WHERE d.name = 'Yuji';
7
1 -- My GitHub contribution history.
2 -- Coding is a daily habit — consistency matters more than intensity.
3 SELECT dt.date, f.contributions
4 FROM fact_daily_activity f
5 JOIN dim_engineer d ON d.engineer_id = f.engineer_id
6 JOIN dim_date dt ON dt.date_id = f.date_id
7 WHERE d.name = 'Yuji' ORDER BY dt.date DESC;
8
1 -- Where I share what I learn.
2 -- Writing helps me solidify ideas and give back to the community.
3 SELECT w.platform, w.url, w.topics
4 FROM dim_platform w
5 JOIN dim_engineer d ON d.engineer_id = s.engineer_id
6 WHERE d.name = 'Yuji';
7
1 -- OSS tools I built for the analytics engineering community.
2 -- Focused on making data modeling more observable and understandable.
3 SELECT p.title, p.description, p.tags, p.github_url
4 FROM dim_project p
5 JOIN dim_engineer d ON d.engineer_id = p.engineer_id
6 WHERE d.name = 'Yuji';
7
1 -- Just curious...
2 SELECT d.salary
3 FROM dim_engineer d
4 WHERE d.name = 'Yuji';
5
Schema · fact_daily_activity (galaxy)
click to inspect
Results
Press ▶ Run Query to execute
| # | skill_name | category | proficiency |
|---|---|---|---|
| 1 | 'Data Modeling' ★ passion | Analytics Engineering | expert |
| 2 | 'Data Engineering' | Engineering | proficient |
| 3 | 'SQL' | Query Language | expert |
| 4 | 'Python' | Programming | proficient |
| 5 | 'Airflow' | Orchestration | proficient |
public repos 35
followers 75
following 79
365 rows · ordered by date DESC · source: github.com/yujikawa
| # | platform | url | topics |
|---|---|---|---|
| 1 | 'medium' | medium.com/@yujikawa ↗ | Analytics Engineering, dbt, data modeling |
| 2 | 'qiita' | qiita.com/yujikawa ↗ | Analytics Engineering, Python, SQL |
| 3 | 'zenn' | zenn.dev/yujikawa ↗ | Analytics Engineering, dbt, data stack |
| # | title | description | tags | github_url |
|---|---|---|---|---|
| 1 | 'Modaryn' | Analyzes dbt projects to score model complexity and structural importance. | PythondbtCLI | github.com/yujikawa/modaryn ↗ |
| 2 | 'Modscape' | A YAML-driven data modeling visualizer bridging conceptual and physical models. | TypeScriptYAMLData Modeling | github.com/yujikawa/modscape ↗ |
| 3 | 'clipable' | Converts spreadsheet clipboard data into a Markdown table instantly. Copy cells from Excel or Google Sheets, run clipable, and the Markdown table is ready to paste. | PythonCLIMarkdown | github.com/yujikawa/clipable ↗ |
| 4 | 'Alisql' | Analyzes SQL files using Jinja2 ref() macros, extracting table dependencies and visualizing them as graphs. | RustSQLCLI | github.com/yujikawa/alisql ↗ |
| 5 | 'Wordic' | Manage your personal word dictionary on your local PC. Store words with values and descriptions, then look them up instantly from the terminal. | RustCLI | github.com/yujikawa/wordic ↗ |