Upgrade to Pro — share decks privately, control downloads, hide ads and more …
Sign up for free

PowerQueryで統計表を使えるデータに！其の0

Avatar for NaoyaShimizu NaoyaShimizu
June 04, 2021
Technology
110
0

 PowerQueryで統計表を使えるデータに！其の0

データ利活用はまずExcel内で使えるデータにするところから

Avatar for NaoyaShimizu

NaoyaShimizu

June 04, 2021

More Decks by NaoyaShimizu

See All by NaoyaShimizu
NYC Open Data for All 2020 Report ニューヨーク市オープンデータ レポート日本語訳
Avatar for NaoyaShimizu naoyashimizzz
0
930

Other Decks in Technology

See All in Technology
AIに任せた品質は、誰が見立てるのか - AI時代のテストマネジメント
Avatar for nakanao nakanao
3
3k
Azure Serverless 2026：Production-ready な AI エージェント基盤 / Azure Serverless 2026: Production-Ready AI Agent Platform
Avatar for miyake miyake
2
580
Goodbye ShellScript, Hello File-based App
Avatar for Shunsuke Tsuchiya shunsock
0
930
AIエージェントの自己改善をどう設計するか / How to Design Self-Improvement for AI Agents
Avatar for 223 22mi
26
17k
SREは、MCPとAutopilotをこう使え！
Avatar for kazumax55 kazumax55
3
960
Lambda MicroVMsは常駐サーバーの代わりに なるか？ Kiro Crew を動かして検証してみた / Kiro Crew on Lambda MicroVMs
Avatar for Kazuki Adachi k_adachi_01
2
180
データ_AIの事業の勝敗をわけるもの
Avatar for KJ(Kenji Matsuda) nek0128
1
480
事業課題から技術的負債に向き合う
Avatar for SansanTech sansantech
PRO
2
2.3k
品質と信頼性を地続きにする
Avatar for gr1m0h grimoh
2
980
Railsのように考える: See through the Master
Avatar for Koji SHIMADA snoozer05
PRO
5
1.3k
作って終わりじゃないサーバーレス 〜9年運用する大規模EC物流API基盤の設計・運用のリアル〜
Avatar for ZOZO Developers zozotech
PRO
0
500
Genieを崇めよ
Avatar for camay kameitomohiro
0
170

Featured

See All Featured
How to Think Like a Performance Engineer
Avatar for Harry Roberts csswizardry
28
2.8k
B2B Lead Gen: Tactics, Traps & Triumph
Avatar for Sophie Logan marketingsoph
0
250
Improving Core Web Vitals using Speculation Rules API
Avatar for Sergey Chernyshev sergeychernyshev
21
1.6k
Measuring Dark Social's Impact On Conversion and Attribution
Avatar for Stephen Akadiri stephenakadiri
2
290
Distributed Sagas: A Protocol for Coordinating Microservices
Avatar for Caitie McCaffrey caitiem20
333
23k
10 Git Anti Patterns You Should be Aware of
Avatar for Lemi Orhan Ergin lemiorhan
PRO
659
62k
Building a A Zero-Code AI SEO Workflow
Avatar for Ian Lurie portentint
PRO
0
730
Building Better People: How to give real-time feedback that sticks.
Avatar for Will Jessup wjessup
370
20k
Bioeconomy Workshop: Dr. Julius Ecuru, Opportunities for a Bioeconomy in West Africa
Avatar for AKADEMIYA2063 akademiya2063
PRO
1
370
The Art of Programming - Codeland 2020
Avatar for Erika Heidi erikaheidi
57
14k
The Curse of the Amulet
Avatar for Matthew Lei leimatthew05
3
15k
Evolving SEO for Evolving Search Engines
Avatar for Ryan Jones ryanjones
0
300

Transcript

  1. Excel内で完結！ PowerQueryで 扱いにくい集計表を、使える「データ」に変えよう！ Excelの「データ」タブの この辺が PowerQueryへいざなう！

  2. 「データ」になっていれば、可視化もカンタン! ※PowerBIで区市町村別のシンプルなグラフに