powerquery-m

Edit Power Query M as files in VS Code — with Copilot, Claude, or any AI coding agent — and sync back to Excel, including workbooks Excel already has open. No Excel required to extract.

A comprehensive, community-curated reference guide for Power Query M language. Includes categorized syntax, examples, and best practices for over 200+ functions across tables, text, numbers, dates, lists, records, and more. Ideal for Power BI, Excel, and dataflow developers.

My public library of reusable functions, scripts, code snippets, and utilities I have written in PowerQueryM language

A dynamic Power BI project transforming raw Balance Sheet and Profit & Loss Statement data into a strategic decision-making tool.

Production Power BI solution for electronics distribution - SAP HANA ETL, star schema, inventory & sell-out analytics

Automated survey data cleaning using Excel Power Query - includes UN region mapping and normalized fact tables.

Comprehensive sales and financial analytics solution featuring advanced Excel techniques, Power Pivot data modeling, DAX calculations, and Power Query ETL for Atliq Hardware business intelligence

Dashboard desenvolvido em Power BI para análise do setor de alimentação no Brasil, utilizando dados da Receita Federal e IBGE para mapear concentração de empresas, riscos, tendências e oportunidades de expansão.

Recettes Power Query (M) et DAX pretes a coller pour Power BI : 16 taches courantes, code teste, explication complete liee. Par Data SL Consulting.

Power BI sales dashboard — AdventureWorks 2019-2022

Kurz Středně pokročilé Power BI a Power Query/jazyk M ( Excel Town, 18 hod) - v Power Query příprava dat, seskupování podle různých kritérií, přímé psaní kódu M, v Power BI vlastní datový model, vlastní metriky DAX, sestavení reportu - zde soubory z lekcí.

Power BI Dashboard Based on 50K+ Bank Transactions

Different Data Projects, ETLs & Data Visualization (Schema Optimization, != Data Sources, Power BI , Power Query , DAX & M languages , MS Access and other tools)

Production Power BI report decomposing YoY sales into Price-Volume-Mix drivers, diagnosing root causes by category/customer/salesperson, and tracking sales quality vs budget. Built on SAP HANA with dynamic DAX text cards that auto-generate plain-English summaries.