Explore tweets tagged as #PowerQuery
みちこ的効率化の集大成的なのがRPAでデータ取得、PowerQueryでデータ整形、HAYAWAZAで仕訳したやつ 1日ごとのPOSレジデータ取得（10店舗） 31ファイルをPowerQueryで統合 HAYAWAZAで列スプリットしてからコンバートして、この時点では複合エラーなんだけど、摘要3で取得した内容で変換してゴール
1
0
5
PowerQueryの練習にTIBORのデータ取得してみたけどちょいちょい表形式変わるおかげでやたら時間食ったお まぁ30年分データ取れたのでよし！（ ＾ω＾）
0
0
1
The Definitive Guide to Power Query (M) — versatile language specifically designed for data manipulation & transformation. Get this HUGE guidebook here: https://t.co/IhLChX4ynt v/ @PacktDataML 🌟🌟🌟🌟 Learn about Power Query M: https://t.co/8Haow4rkPd
0
5
13
0
3
34
How to make your Power Query Case Insensitive 🤔 The Compare Case enumeration (keyword) is available for - - Text.Contains - Text.StartsWith - Text.EndsWith - And a few others #Mjoy #PowerQuery
0
5
65
Instead of scrolling sideways to check columns, click the row header and view the whole row as a record. It’s a much easier way to look at wide tables in #PowerQuery.
1
5
53
Dear Data Analyst. What’s the cost of your Data Analysis knowledge? SQL = $200 DAX = $300 Excel = $200 Python = $300 Tableau = $200 PowerQuery = $300 Data Modeling = $300 Data visualization= $200 Presentation skill = $300 Joins and SubQueries = $300 Mine: $2100
11
11
122
ついにWEB版ExcelでPowerQueryが動くようになる？ やっとSharePointをExcel単体で読めるようになって、リストをDB代わりに使えるようになるんかな！？ https://t.co/2snrXqjqck
0
10
83
Groupbyは、もとはPowerQueryにある機能を、あまりにも使われないからExcelに持ってきた感じでしょうか。 PivotbyもPowerPivotがあるのに、、 でもこちらは再利用性があれば便利に使えるかも。
ExcelのGROUPBY関数とかPIVOTBY関数は、それだけで1冊本が書けてしまいそうなくらいのボリュームがありますね。 まず、引数が大量にあるので、基本的な説明だけで大変。
1
0
1
New video drops today at 6PM! 🎥 I’ll show how to build a Customer Segmentation Dashboard in Excel, from Power Query to final design. On notification: https://t.co/rqEqSGFCmz Get ready to turn raw data into real insights. #Excel #DataAnalytics #Dashboard #PowerQuery
17
10
65
Want to repeat rows based on a column value? 🔁 This Power Query trick does it. No loops, no manual work. Clean, simple, and super handy! 😎 {M}joy! → https://t.co/K8lExXj6a8
0
2
27
Navigating through extensive tables in #PowerQuery can be quite challenging, right? Instead of getting lost in the sea of columns, try pressing CTRL + G to jump directly to the column you're looking for. Hope this tip helps! 😉 Black Friday Sale 🎉 - https://t.co/K8lExXjDZG
2
4
35
Oh yeah!,I decided to recreate the e-commerce dashboard in Power BI , all thanks to @ObohX for his well-detailed YouTube session! Cleaned a 6-file dataset in Power Query, wrote DAX measures, and built a sleek 2-page dark-theme dashboard #PowerBI #PowerQuery #DataVisualization
9
7
89
