The Qiita Advent Calendar 2022 is supported by the following companies, organizations, and services.

Advent Calendar 2022 / Database & DWH

クリスマスに向けデータに関する想いや技術をぶっちゃける Advent Calendar 2022

Participant17People

Subscriber17People

Category：Database & DWH

Creator：

@yuji_sakurai

背景

データギルドSinkCapitalを運営している櫻井です。
今年も皆様には大変お世話になりました。
今回は普段お世話になっている皆様にお声がけさせて頂き、データを使って日々ご活躍されている方達にデータに関する色々な想いを語って頂こうと思います。
データに関わる人々のクリスマスを盛り上げていきましょう！

記事テーマ

データの仕事の中で感じた喜びや辛み、Tipsなど
- ◯ データ抽出依頼を３ヶ月続けて感じたこと
- ✕　デザイナーとして心がけていること10選
データにまつわる目下の課題や、来年やってみたいこと
- ◯　データスチュワートって言われているが、俺が思う最強のデータマネジメントはこれだ
データに関連した技術を使ってみたなどあれこれ
- ◯　Looker Studioの新機能＊＊を使ってみた
- ✕　Python２とPython３違いについて

記事投稿までのフロー

カレンダーから空いている日付を選択して下さい
- 運営(櫻井・本林)と面識のない方は登録前にお手数をおかけしますが、 yuji.s@sink-capital.com までご連絡いただけますと幸いです
仮のタイトルをいれて登録を完了して下さい(「なんか書きます！」だけでもOKです)
公開日までに櫻井の方でタイトルを確認させていただき、問題等あった場合はご連絡させていただきます
該当の日付までにQiita記事などを作成し、URLを紐付けていただければ自動的に公開されます
(任意参加)いいねが一番多かった記事に対する表彰式(プレゼント贈呈)を未定にオンラインで行う予定のため、興味のある方は是非 yuji.s@sink-capital.com までご連絡いただけますと幸いです！

注意事項

記事の背景にて自己紹介を入れて下さい
記事内容は公開日に弊社SNS等で広報される予定です
宗教・思想に関連した記事は禁止いたします
公序良俗に反する記事は禁止いたします
内容的に不安のあるものは気軽に yuji.s@sink-capital.com までお問い合わせ下さい

Series 1

Sun	Mon	Tue	Wed	Thu	Fri	Sat
27	28	29	30	1 @yuji_sakurai データ定義管理はQA・問い合わせを綺麗に残すだけでいけるのではという話 Overwrite Title URL You can post either your article on Qiita or your blog post. When you participate, When you participate, we will assume that you have agreed to the terms of use	2 @tanaka_kanata 主キーに想いをはせるのはディナーのあとで Overwrite Title URL You can post either your article on Qiita or your blog post. When you participate, When you participate, we will assume that you have agreed to the terms of use	3 @KentoKarakawa ビジネスにとって意味のあるデータとは Overwrite Title URL You can post either your article on Qiita or your blog post. When you participate, When you participate, we will assume that you have agreed to the terms of use
4 @Booklin Webアナリストの目線から、Cookie制限系の話まとめてみた Overwrite Title URL You can post either your article on Qiita or your blog post. When you participate, When you participate, we will assume that you have agreed to the terms of use	5 @yuji_sakurai データ周りで話題のdbt(data build tool)をBigQueryを使ってみました Overwrite Title URL You can post either your article on Qiita or your blog post. When you participate, When you participate, we will assume that you have agreed to the terms of use	6 @AntiBayesian 「10年使えるデータ活用システム」への一歩目 Overwrite Title URL You can post either your article on Qiita or your blog post. When you participate, When you participate, we will assume that you have agreed to the terms of use	7 @maruchan_006 Pipedrive Web Formsでutmを取得する方法 Overwrite Title URL You can post either your article on Qiita or your blog post. When you participate, When you participate, we will assume that you have agreed to the terms of use	8 @yuji_sakurai 個人作成したswiftゲームアプリの一年をデータから振り返ってみる Overwrite Title URL You can post either your article on Qiita or your blog post. When you participate, When you participate, we will assume that you have agreed to the terms of use	9 @harune-hosoda 立ち上げ期のデータマネジメントを支えた課題表 Overwrite Title URL You can post either your article on Qiita or your blog post. When you participate, When you participate, we will assume that you have agreed to the terms of use	10 @mokab n=1で始めた生活改善withデータ Overwrite Title URL You can post either your article on Qiita or your blog post. When you participate, When you participate, we will assume that you have agreed to the terms of use
11 @kwonline 人事データ分析のためにディメンショナルモデルDWHを作る Overwrite Title URL You can post either your article on Qiita or your blog post. When you participate, When you participate, we will assume that you have agreed to the terms of use	12 @0kayu2511 TreasureData（分析基盤）導入時に気をつけたいアンチパターン Overwrite Title URL You can post either your article on Qiita or your blog post. When you participate, When you participate, we will assume that you have agreed to the terms of use	13 @hyuta WEBサイト分析ログ管理の常識とは Overwrite Title URL You can post either your article on Qiita or your blog post. When you participate, When you participate, we will assume that you have agreed to the terms of use	14 @tanaka_kanata データアナリストがよく出会うnullについてまとめてみた。 Overwrite Title URL You can post either your article on Qiita or your blog post. When you participate, When you participate, we will assume that you have agreed to the terms of use	15 @okatty 注目の最新海外データ系サービスまとめ Overwrite Title URL You can post either your article on Qiita or your blog post. When you participate, When you participate, we will assume that you have agreed to the terms of use	16 @kotaRof データが核になる新規事業開発に分析官として並走した話 Overwrite Title URL You can post either your article on Qiita or your blog post. When you participate, When you participate, we will assume that you have agreed to the terms of use	17 @minaduking なにか書く Overwrite Title URL You can post either your article on Qiita or your blog post. When you participate, When you participate, we will assume that you have agreed to the terms of use
18 @maruchan_006 さようなら、掛け違えたJOINキーたち Overwrite Title URL You can post either your article on Qiita or your blog post. When you participate, When you participate, we will assume that you have agreed to the terms of use	19 Join calendar on 19 day You can also reserve a slot without registering a title or URL. Title URL Articles to be submitted are welcome on any website as well as on Qiita. If you link a limited shared article by the day before, it will be automatically published around 7:00am on the same day. When you participate, When you participate, we will assume that you have agreed to the terms of use	20 Join calendar on 20 day You can also reserve a slot without registering a title or URL. Title URL Articles to be submitted are welcome on any website as well as on Qiita. If you link a limited shared article by the day before, it will be automatically published around 7:00am on the same day. When you participate, When you participate, we will assume that you have agreed to the terms of use	21 @panja Adobe Experience Platform Debugger を使ってみて「良かった機能」3選 Overwrite Title URL You can post either your article on Qiita or your blog post. When you participate, When you participate, we will assume that you have agreed to the terms of use	22 @kiri1701 データ品質の現在地を測る Overwrite Title URL You can post either your article on Qiita or your blog post. When you participate, When you participate, we will assume that you have agreed to the terms of use	23 Join calendar on 23 day You can also reserve a slot without registering a title or URL. Title URL Articles to be submitted are welcome on any website as well as on Qiita. If you link a limited shared article by the day before, it will be automatically published around 7:00am on the same day. When you participate, When you participate, we will assume that you have agreed to the terms of use	24 @yuji_sakurai データギルドにおけるQCD向上に向けた取り組み Overwrite Title URL You can post either your article on Qiita or your blog post. When you participate, When you participate, we will assume that you have agreed to the terms of use
25 @__Rossi__ Pytorchってめちゃくちゃ便利やん! Overwrite Title URL You can post either your article on Qiita or your blog post. When you participate, When you participate, we will assume that you have agreed to the terms of use	26	27	28	29	30	31

1	@yuji_sakurai データ定義管理はQA・問い合わせを綺麗に残すだけでいけるのではという話 Overwrite Title URL You can post either your article on Qiita or your blog post. When you participate, When you participate, we will assume that you have agreed to the terms of use
2	@tanaka_kanata 主キーに想いをはせるのはディナーのあとで Overwrite Title URL You can post either your article on Qiita or your blog post. When you participate, When you participate, we will assume that you have agreed to the terms of use
3	@KentoKarakawa ビジネスにとって意味のあるデータとは Overwrite Title URL You can post either your article on Qiita or your blog post. When you participate, When you participate, we will assume that you have agreed to the terms of use
4	@Booklin Webアナリストの目線から、Cookie制限系の話まとめてみた Overwrite Title URL You can post either your article on Qiita or your blog post. When you participate, When you participate, we will assume that you have agreed to the terms of use
5	@yuji_sakurai データ周りで話題のdbt(data build tool)をBigQueryを使ってみました Overwrite Title URL You can post either your article on Qiita or your blog post. When you participate, When you participate, we will assume that you have agreed to the terms of use
6	@AntiBayesian 「10年使えるデータ活用システム」への一歩目 Overwrite Title URL You can post either your article on Qiita or your blog post. When you participate, When you participate, we will assume that you have agreed to the terms of use
7	@maruchan_006 Pipedrive Web Formsでutmを取得する方法 Overwrite Title URL You can post either your article on Qiita or your blog post. When you participate, When you participate, we will assume that you have agreed to the terms of use
8	@yuji_sakurai 個人作成したswiftゲームアプリの一年をデータから振り返ってみる Overwrite Title URL You can post either your article on Qiita or your blog post. When you participate, When you participate, we will assume that you have agreed to the terms of use
9	@harune-hosoda 立ち上げ期のデータマネジメントを支えた課題表 Overwrite Title URL You can post either your article on Qiita or your blog post. When you participate, When you participate, we will assume that you have agreed to the terms of use
10	@mokab n=1で始めた生活改善withデータ Overwrite Title URL You can post either your article on Qiita or your blog post. When you participate, When you participate, we will assume that you have agreed to the terms of use
11	@kwonline 人事データ分析のためにディメンショナルモデルDWHを作る Overwrite Title URL You can post either your article on Qiita or your blog post. When you participate, When you participate, we will assume that you have agreed to the terms of use
12	@0kayu2511 TreasureData（分析基盤）導入時に気をつけたいアンチパターン Overwrite Title URL You can post either your article on Qiita or your blog post. When you participate, When you participate, we will assume that you have agreed to the terms of use
13	@hyuta WEBサイト分析ログ管理の常識とは Overwrite Title URL You can post either your article on Qiita or your blog post. When you participate, When you participate, we will assume that you have agreed to the terms of use
14	@tanaka_kanata データアナリストがよく出会うnullについてまとめてみた。 Overwrite Title URL You can post either your article on Qiita or your blog post. When you participate, When you participate, we will assume that you have agreed to the terms of use
15	@okatty 注目の最新海外データ系サービスまとめ Overwrite Title URL You can post either your article on Qiita or your blog post. When you participate, When you participate, we will assume that you have agreed to the terms of use
16	@kotaRof データが核になる新規事業開発に分析官として並走した話 Overwrite Title URL You can post either your article on Qiita or your blog post. When you participate, When you participate, we will assume that you have agreed to the terms of use
17	@minaduking なにか書く Overwrite Title URL You can post either your article on Qiita or your blog post. When you participate, When you participate, we will assume that you have agreed to the terms of use
18	@maruchan_006 さようなら、掛け違えたJOINキーたち Overwrite Title URL You can post either your article on Qiita or your blog post. When you participate, When you participate, we will assume that you have agreed to the terms of use
19	Join calendar on 19 day You can also reserve a slot without registering a title or URL. Title URL Articles to be submitted are welcome on any website as well as on Qiita. If you link a limited shared article by the day before, it will be automatically published around 7:00am on the same day. When you participate, When you participate, we will assume that you have agreed to the terms of use
20	Join calendar on 20 day You can also reserve a slot without registering a title or URL. Title URL Articles to be submitted are welcome on any website as well as on Qiita. If you link a limited shared article by the day before, it will be automatically published around 7:00am on the same day. When you participate, When you participate, we will assume that you have agreed to the terms of use
21	@panja Adobe Experience Platform Debugger を使ってみて「良かった機能」3選 Overwrite Title URL You can post either your article on Qiita or your blog post. When you participate, When you participate, we will assume that you have agreed to the terms of use
22	@kiri1701 データ品質の現在地を測る Overwrite Title URL You can post either your article on Qiita or your blog post. When you participate, When you participate, we will assume that you have agreed to the terms of use
23	Join calendar on 23 day You can also reserve a slot without registering a title or URL. Title URL Articles to be submitted are welcome on any website as well as on Qiita. If you link a limited shared article by the day before, it will be automatically published around 7:00am on the same day. When you participate, When you participate, we will assume that you have agreed to the terms of use
24	@yuji_sakurai データギルドにおけるQCD向上に向けた取り組み Overwrite Title URL You can post either your article on Qiita or your blog post. When you participate, When you participate, we will assume that you have agreed to the terms of use
25	@__Rossi__ Pytorchってめちゃくちゃ便利やん! Overwrite Title URL You can post either your article on Qiita or your blog post. When you participate, When you participate, we will assume that you have agreed to the terms of use

Sun	Mon	Tue	Wed	Thu	Fri	Sat
27	28	29	30	1 @yuji_sakurai データ定義管理はQA・問い合わせを綺麗に残すだけでいけるのではという話 Overwrite Title URL You can post either your article on Qiita or your blog post. When you participate, When you participate, we will assume that you have agreed to the terms of use	2 @tanaka_kanata 主キーに想いをはせるのはディナーのあとで Overwrite Title URL You can post either your article on Qiita or your blog post. When you participate, When you participate, we will assume that you have agreed to the terms of use	3 @KentoKarakawa ビジネスにとって意味のあるデータとは Overwrite Title URL You can post either your article on Qiita or your blog post. When you participate, When you participate, we will assume that you have agreed to the terms of use
4 @Booklin Webアナリストの目線から、Cookie制限系の話まとめてみた Overwrite Title URL You can post either your article on Qiita or your blog post. When you participate, When you participate, we will assume that you have agreed to the terms of use	5 @yuji_sakurai データ周りで話題のdbt(data build tool)をBigQueryを使ってみました Overwrite Title URL You can post either your article on Qiita or your blog post. When you participate, When you participate, we will assume that you have agreed to the terms of use	6 @AntiBayesian 「10年使えるデータ活用システム」への一歩目 Overwrite Title URL You can post either your article on Qiita or your blog post. When you participate, When you participate, we will assume that you have agreed to the terms of use	7 @maruchan_006 Pipedrive Web Formsでutmを取得する方法 Overwrite Title URL You can post either your article on Qiita or your blog post. When you participate, When you participate, we will assume that you have agreed to the terms of use	8 @yuji_sakurai 個人作成したswiftゲームアプリの一年をデータから振り返ってみる Overwrite Title URL You can post either your article on Qiita or your blog post. When you participate, When you participate, we will assume that you have agreed to the terms of use	9 @harune-hosoda 立ち上げ期のデータマネジメントを支えた課題表 Overwrite Title URL You can post either your article on Qiita or your blog post. When you participate, When you participate, we will assume that you have agreed to the terms of use	10 @mokab n=1で始めた生活改善withデータ Overwrite Title URL You can post either your article on Qiita or your blog post. When you participate, When you participate, we will assume that you have agreed to the terms of use
11 @kwonline 人事データ分析のためにディメンショナルモデルDWHを作る Overwrite Title URL You can post either your article on Qiita or your blog post. When you participate, When you participate, we will assume that you have agreed to the terms of use	12 @0kayu2511 TreasureData（分析基盤）導入時に気をつけたいアンチパターン Overwrite Title URL You can post either your article on Qiita or your blog post. When you participate, When you participate, we will assume that you have agreed to the terms of use	13 @hyuta WEBサイト分析ログ管理の常識とは Overwrite Title URL You can post either your article on Qiita or your blog post. When you participate, When you participate, we will assume that you have agreed to the terms of use	14 @tanaka_kanata データアナリストがよく出会うnullについてまとめてみた。 Overwrite Title URL You can post either your article on Qiita or your blog post. When you participate, When you participate, we will assume that you have agreed to the terms of use	15 @okatty 注目の最新海外データ系サービスまとめ Overwrite Title URL You can post either your article on Qiita or your blog post. When you participate, When you participate, we will assume that you have agreed to the terms of use	16 @kotaRof データが核になる新規事業開発に分析官として並走した話 Overwrite Title URL You can post either your article on Qiita or your blog post. When you participate, When you participate, we will assume that you have agreed to the terms of use	17 @minaduking なにか書く Overwrite Title URL You can post either your article on Qiita or your blog post. When you participate, When you participate, we will assume that you have agreed to the terms of use
18 @maruchan_006 さようなら、掛け違えたJOINキーたち Overwrite Title URL You can post either your article on Qiita or your blog post. When you participate, When you participate, we will assume that you have agreed to the terms of use	19 Join calendar on 19 day You can also reserve a slot without registering a title or URL. Title URL Articles to be submitted are welcome on any website as well as on Qiita. If you link a limited shared article by the day before, it will be automatically published around 7:00am on the same day. When you participate, When you participate, we will assume that you have agreed to the terms of use	20 Join calendar on 20 day You can also reserve a slot without registering a title or URL. Title URL Articles to be submitted are welcome on any website as well as on Qiita. If you link a limited shared article by the day before, it will be automatically published around 7:00am on the same day. When you participate, When you participate, we will assume that you have agreed to the terms of use	21 @panja Adobe Experience Platform Debugger を使ってみて「良かった機能」3選 Overwrite Title URL You can post either your article on Qiita or your blog post. When you participate, When you participate, we will assume that you have agreed to the terms of use	22 @kiri1701 データ品質の現在地を測る Overwrite Title URL You can post either your article on Qiita or your blog post. When you participate, When you participate, we will assume that you have agreed to the terms of use	23 Join calendar on 23 day You can also reserve a slot without registering a title or URL. Title URL Articles to be submitted are welcome on any website as well as on Qiita. If you link a limited shared article by the day before, it will be automatically published around 7:00am on the same day. When you participate, When you participate, we will assume that you have agreed to the terms of use	24 @yuji_sakurai データギルドにおけるQCD向上に向けた取り組み Overwrite Title URL You can post either your article on Qiita or your blog post. When you participate, When you participate, we will assume that you have agreed to the terms of use
25 @__Rossi__ Pytorchってめちゃくちゃ便利やん! Overwrite Title URL You can post either your article on Qiita or your blog post. When you participate, When you participate, we will assume that you have agreed to the terms of use	26	27	28	29	30	31

1	@yuji_sakurai データ定義管理はQA・問い合わせを綺麗に残すだけでいけるのではという話 Overwrite Title URL You can post either your article on Qiita or your blog post. When you participate, When you participate, we will assume that you have agreed to the terms of use
2	@tanaka_kanata 主キーに想いをはせるのはディナーのあとで Overwrite Title URL You can post either your article on Qiita or your blog post. When you participate, When you participate, we will assume that you have agreed to the terms of use
3	@KentoKarakawa ビジネスにとって意味のあるデータとは Overwrite Title URL You can post either your article on Qiita or your blog post. When you participate, When you participate, we will assume that you have agreed to the terms of use
4	@Booklin Webアナリストの目線から、Cookie制限系の話まとめてみた Overwrite Title URL You can post either your article on Qiita or your blog post. When you participate, When you participate, we will assume that you have agreed to the terms of use
5	@yuji_sakurai データ周りで話題のdbt(data build tool)をBigQueryを使ってみました Overwrite Title URL You can post either your article on Qiita or your blog post. When you participate, When you participate, we will assume that you have agreed to the terms of use
6	@AntiBayesian 「10年使えるデータ活用システム」への一歩目 Overwrite Title URL You can post either your article on Qiita or your blog post. When you participate, When you participate, we will assume that you have agreed to the terms of use
7	@maruchan_006 Pipedrive Web Formsでutmを取得する方法 Overwrite Title URL You can post either your article on Qiita or your blog post. When you participate, When you participate, we will assume that you have agreed to the terms of use
8	@yuji_sakurai 個人作成したswiftゲームアプリの一年をデータから振り返ってみる Overwrite Title URL You can post either your article on Qiita or your blog post. When you participate, When you participate, we will assume that you have agreed to the terms of use
9	@harune-hosoda 立ち上げ期のデータマネジメントを支えた課題表 Overwrite Title URL You can post either your article on Qiita or your blog post. When you participate, When you participate, we will assume that you have agreed to the terms of use
10	@mokab n=1で始めた生活改善withデータ Overwrite Title URL You can post either your article on Qiita or your blog post. When you participate, When you participate, we will assume that you have agreed to the terms of use
11	@kwonline 人事データ分析のためにディメンショナルモデルDWHを作る Overwrite Title URL You can post either your article on Qiita or your blog post. When you participate, When you participate, we will assume that you have agreed to the terms of use
12	@0kayu2511 TreasureData（分析基盤）導入時に気をつけたいアンチパターン Overwrite Title URL You can post either your article on Qiita or your blog post. When you participate, When you participate, we will assume that you have agreed to the terms of use
13	@hyuta WEBサイト分析ログ管理の常識とは Overwrite Title URL You can post either your article on Qiita or your blog post. When you participate, When you participate, we will assume that you have agreed to the terms of use
14	@tanaka_kanata データアナリストがよく出会うnullについてまとめてみた。 Overwrite Title URL You can post either your article on Qiita or your blog post. When you participate, When you participate, we will assume that you have agreed to the terms of use
15	@okatty 注目の最新海外データ系サービスまとめ Overwrite Title URL You can post either your article on Qiita or your blog post. When you participate, When you participate, we will assume that you have agreed to the terms of use
16	@kotaRof データが核になる新規事業開発に分析官として並走した話 Overwrite Title URL You can post either your article on Qiita or your blog post. When you participate, When you participate, we will assume that you have agreed to the terms of use
17	@minaduking なにか書く Overwrite Title URL You can post either your article on Qiita or your blog post. When you participate, When you participate, we will assume that you have agreed to the terms of use
18	@maruchan_006 さようなら、掛け違えたJOINキーたち Overwrite Title URL You can post either your article on Qiita or your blog post. When you participate, When you participate, we will assume that you have agreed to the terms of use
19	Join calendar on 19 day You can also reserve a slot without registering a title or URL. Title URL Articles to be submitted are welcome on any website as well as on Qiita. If you link a limited shared article by the day before, it will be automatically published around 7:00am on the same day. When you participate, When you participate, we will assume that you have agreed to the terms of use
20	Join calendar on 20 day You can also reserve a slot without registering a title or URL. Title URL Articles to be submitted are welcome on any website as well as on Qiita. If you link a limited shared article by the day before, it will be automatically published around 7:00am on the same day. When you participate, When you participate, we will assume that you have agreed to the terms of use
21	@panja Adobe Experience Platform Debugger を使ってみて「良かった機能」3選 Overwrite Title URL You can post either your article on Qiita or your blog post. When you participate, When you participate, we will assume that you have agreed to the terms of use
22	@kiri1701 データ品質の現在地を測る Overwrite Title URL You can post either your article on Qiita or your blog post. When you participate, When you participate, we will assume that you have agreed to the terms of use
23	Join calendar on 23 day You can also reserve a slot without registering a title or URL. Title URL Articles to be submitted are welcome on any website as well as on Qiita. If you link a limited shared article by the day before, it will be automatically published around 7:00am on the same day. When you participate, When you participate, we will assume that you have agreed to the terms of use
24	@yuji_sakurai データギルドにおけるQCD向上に向けた取り組み Overwrite Title URL You can post either your article on Qiita or your blog post. When you participate, When you participate, we will assume that you have agreed to the terms of use
25	@__Rossi__ Pytorchってめちゃくちゃ便利やん! Overwrite Title URL You can post either your article on Qiita or your blog post. When you participate, When you participate, we will assume that you have agreed to the terms of use

You can increase the number of series when Calendar 1 is filled with more than 10 articles.

The Qiita Advent Calendar 2022 is supported by the following companies, organizations, and services.