Skip to content
View sh16ma's full-sized avatar
🐻‍❄️
🐻‍❄️
6 followers · 23 following

Achievements

Achievement: Pull Sharkx2

Achievements

Achievement: Pull Sharkx2
Block or Report

Block or report sh16ma

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Please don't include any personal information such as legal names or email addresses. Maximum 100 characters, markdown supported. This note will be visible to only you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
sh16ma/README.md

iceberg_header_image

top_lang_commit

🧊 LINKS　

  Gist   GitPress   X   Kaggle

🧊 Career Details

❄ Data Analysis Engineer (Oct.2020~) 
{exprain}
  • Cloud :
    Google Cloud
    ( Google Cloud Spanner Google Cloud Composer Google Dataflow Google Pub/Sub Google Cloud Storage )
  • ETL : {Learning （勉強中)}
    dbt Argo Terraform
  • DWH :
    BigQuery Presto
  • BI :
    Looker LookerStudio Tableau
  • ML/DL:
    BigQueryML NumPy Polars scikit-learn Plotly
  • MidleWear :
    Git Docker Anaconda
  • REPL(対話型実行環境) :
    Colaboratory Jupyter Lab （Markdown Python）
  • IDE :
    iTerm2 (Zsh Vim)
  • OS :
    Macintosh
  • Data Source :
    Firebase GA4
❄ Growth Hacker (Apr.2016 ~ Sep.2020) 
{exprain}
  • SEM (SEO / PPC) :
    Google TagManager Google Analytics(UA/360) Google SearchConsole Google AdSense Google Optimize
  • Aggregation / Presentation :
    Google Sheets Google Slide Microsoft Excel Microsoft PowerPoint
  • CMS :
    WordPress
  • Front End & library
    HTML5 CSS3 Bootstrap JavaScript jQuery
  • IDE :
    Atom
  • OS :
    Windows

🧊 Other Details

❄ CERTIFICATIONS

• Google Analytics Individual Qualification #2017 #2018
• Python 3 Basic Grammar Certification #2020
• Python 3 Data Analyst Certification #2021
• -

❄ COMITGRAPH

profile-summary-card-output

Pinned Loading

  1. #🔎 #BigQuery #OUTLINE #🔎 #BigQuery #OUTLINE
    1 
    # BigQuery 集計・分析の為の記述構成
    2 
    SQLを用いての集計・分析を行うと、クエリだけで軽く数百行を超えることがしばしばある。<br>
    3 
    おおまかに、どのエリアにどのテーブル（整形したサブクエリ）が存在しているのかを予め決めておくことで、<br>
    4 
    容易にクエリを記述・読み返すことができる。<br>
    5 
    <br>
  2. #💎 #TreasuerData #集計テク #Presto #SQL ... #💎 #TreasuerData #集計テク #Presto #SQL #構成比
    1 
    /*********************************************************
    2 
     * ID-POS
    3 
     *
    4 
     *　　　　POSデータのDWH（約80億レコード/1テーブル）を全て回すのはリスク。
    5 
     *　　　　「WHERE句」を用いて、レコード取得制限の掛ける絞り込み。