こうした“同じ形式で毎回届くExcelファイル”、皆さんはどうやって集計していますか？ もし今、毎回コピペして1つの表にまとめているのなら、それはもうムダな作業です。 解決策はPower Query。しかも慣れれば超簡単 Power Query（パワークエリ）は、複数 ...

Have you ever found yourself staring at a spinning wheel, waiting for your Power Query to refresh, only to wonder if there’s a better way? For anyone working with large datasets, refresh delays aren’t ...

Have you ever spent hours wrestling with messy spreadsheets, trying to clean up data that just won’t cooperate? Or maybe you’ve found yourself manually merging files, painstakingly copying and pasting ...

Since I wrote about the Snowflake query tags generated by Power BI earlier this year, one important piece of functionality ...

Do you often feel like you are spending more time managing your data in Excel than actually analyzing it? I get it. For years, I navigated spreadsheets with the same basic tools. That was until I ...