$30 off During Our Annual Pro Sale. View Details »

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

Avatar for NaoyaShimizu NaoyaShimizu
June 04, 2021
Technology
0
82

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

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

Avatar for NaoyaShimizu

NaoyaShimizu

June 04, 2021
Tweet

More Decks by NaoyaShimizu

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

Other Decks in Technology

See All in Technology
AWSの新機能をフル活用した「re:Inventエージェント」開発秘話
Avatar for みのるん minorun365
2
460
松尾研LLM講座2025 応用編Day3「軽量化」 講義資料
Avatar for Aratako aratako
6
3.7k
[2025-12-12]あの日僕が見た胡蝶の夢 〜人の夢は終わらねェ AIによるパフォーマンスチューニングのすゝめ〜
Avatar for tosite tosite
0
180
ActiveJobUpdates
Avatar for Kuniaki IGARASHI igaiga
1
320
NIKKEI Tech Talk #41: セキュア・バイ・デザインからクラウド管理を考える
Avatar for Ryosuke Sekido sekido
PRO
0
210
[Data & AI Summit '25 Fall] AIでデータ活用を進化させる！Google Cloudで作るデータ活用の未来
Avatar for kirimaru kirimaru
0
3.9k
Knowledge Work の AI Backend
Avatar for KNOWLEDGE WORK / 株式会社ナレッジワーク kworkdev
PRO
0
260
Amazon Bedrock Knowledge Bases × メタデータ活用で実現する検証可能な RAG 設計
Avatar for Tomoaki tomoaki25
6
2.4k
Strands AgentsとNova 2 SonicでS2Sを実践してみた
Avatar for Yuuki Yamashita yama3133
1
1.9k
テストセンター受験、オンライン受験、どっちなんだい？
Avatar for Yuuki Yamashita yama3133
0
170
株式会社ビザスク_AI__Engineering_Summit_Tokyo_2025_登壇資料.pdf
Avatar for VISASQ eikohashiba
1
120
AR Guitar: Expanding Guitar Performance from a Live House to Urban Space
Avatar for Ekito ekito_station
0
230

Featured

See All Featured
Music & Morning Musume
Avatar for Bryan Veloso bryan
46
7k
Collaborative Software Design: How to facilitate domain modelling decisions
Avatar for Kenny Baas-Schwegler baasie
0
100
HU Berlin: Industrial-Strength Natural Language Processing with spaCy and Prodigy
Avatar for Ines Montani inesmontani
PRO
0
110
Exploring the relationship between traditional SERPs and Gen AI search
Avatar for Ray Grieselhuber raygrieselhuber
PRO
2
3.4k
Odyssey Design
Avatar for Ryan Kendrick rkendrick25
PRO
0
440
Fantastic passwords and where to find them - at NoRuKo
Avatar for Phil Nash philnash
52
3.5k
Redefining SEO in the New Era of Traffic Generation
Avatar for Szymon szymonslowik
1
170
Build your cross-platform service in a week with App Engine
Avatar for Jose L jlugia
234
18k
XXLCSS - How to scale CSS and keep your sanity
Avatar for Zaharenia Atzitzikaki sugarenia
249
1.3M
Why You Should Never Use an ORM
Avatar for John Nunemaker jnunemaker
PRO
61
9.7k
Evolving SEO for Evolving Search Engines
Avatar for Ryan Jones ryanjones
0
73
Building Experiences: Design Systems, User Experience, and Full Site Editing
Avatar for Michelle Schulp Hunt marktimemedia
0
330

Transcript

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

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