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

Power BI REST API custom functions

Power BI REST API Connector - Admin Version

Blackbaud data connectors for Power Query and Power BI

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.

Collection of useful Power Query M templates, functions and snippets

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

Power BI custom data connector plugin for Pardot (by salesforce)

Creates new spreadsheet from metadata

Analyzing Manufacturing and Inventory Operations of the AdventureWorks Database using Power BI

Power BI based Data\Business analysis of e-commerce company with focus on demographic analysis

Power Query Formula Language (aka M) support for Atom

Custom Excel linked data types with RDF & SPARQL

In this repository I prove my knowledge and technical skills using this tool as a Data Analyst.

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

Data Visualization for Atliq Hardware sales

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.