power-query

This is a collection of all the code that can be found on my YouTube channel Sigma Coding.

Проект открытого методического пособия по Power BI, Power Query, Power Pivot

Detach your M code from workbooks to reuse it! Import modules from local or web storage (unlimited number of sources)

Power Query M functions for working with Tabular Data Packages (Frictionless Data) in Power BI and Excel

Blackbaud data connectors for Power Query and Power BI

Power BI Custom Connector for loading tables directly from Tabular Data Packages (Frictionless Data) into Power BI

Collection of useful Power Query M templates, functions and snippets

Creates new spreadsheet from metadata

Power Query Formula Language (aka M) support for Atom

Code for the demos of the session about Power Query M language

Bootcamp ministrado pela IGTI com o objetivo apresentar os fundamentos básicos e avançados do ambiente de desenvolvimento do Business Intelligence e realizar práticas nas ferramentas, desde a obtenção dos dados, modelagem do Data Warehouse, ETL, relatórios analíticos e Dashboards.

Sample Financial Data

Business Analysis of a fictitious company and created an Interactive Dashboard using Power BI

Power Query extension for the Twilio API

The folder of my work with Excel, VBA, and PowerBI for Data Analysis & Visualization.

I chose 'AdventureWorksLT2019.bak' and 'AdventureWorksLT2017.bak' data for analysis & visualization. The query editing was done in 'Microsoft SQL Server Management Studio' and the visualization part was using 'Microsoft Power BI'. Also for analysis, I used MS Excel and PowerBI's query tool.

A cost analysis dataset of region-wise different IT departments was used for this project. I used excel and powerBI query tools to analyze and build the relational model. After that used different visualization tools to show different budgets and forecasts comparisons.

📋 📊 Excel exercises using Power Query, Pivot Tables and Dashboards.

Functions and other M code for use in Power Query/ Power BI