An open API service providing repository metadata for many open source software ecosystems.

GitHub topics: powerquerym

rabestro/powerquery-artifactory-utils

A collection of custom Power Query (M) functions to extract data from the JFrog Artifactory REST API.

Size: 9.77 KB - Last synced at: 11 days ago - Pushed at: 11 days ago - Stars: 0 - Forks: 0

iberta/Tabla_Calendario_Power_BI

Tabla de fechas creada en Power Query / M

Size: 1000 Bytes - Last synced at: 20 days ago - Pushed at: 20 days ago - Stars: 0 - Forks: 0

tirnovar/Power-BI-Admin-REST-API-Connector

Power BI REST API Connector - Admin Version

Size: 675 KB - Last synced at: 8 days ago - Pushed at: 10 months ago - Stars: 45 - Forks: 7

rabestro/exercism-api-powerquery-m

A collection of Power Query M scripts to interact with the Exercism.org API (v2), simplifying data extraction for tracks and exercises.

Size: 17.4 MB - Last synced at: about 1 month ago - Pushed at: about 1 month ago - Stars: 0 - Forks: 0

alisonpezzott/useful-snippets

A collection of useful code snippets for common development tasks of an analytics data engineer Microsoft based.

Language: Jupyter Notebook - Size: 15.6 KB - Last synced at: about 1 month ago - Pushed at: about 1 month ago - Stars: 0 - Forks: 1

alisonpezzott/alisonpezzott

Repo do perfil do Alison Pezzott

Size: 2.19 MB - Last synced at: about 1 month ago - Pushed at: about 1 month ago - Stars: 11 - Forks: 5

OscarValerock/PowerQueryFunctions

A Power BI Service compatible M Power Query custom functions library.

Language: Python - Size: 182 KB - Last synced at: 5 days ago - Pushed at: 2 months ago - Stars: 37 - Forks: 12

tirnovar/m-custom-functions

This library contains created mostly pure M-functions.

Size: 1.1 MB - Last synced at: 8 days ago - Pushed at: 8 months ago - Stars: 75 - Forks: 21

tirnovar/Power_BI_REST_API_PQ

Power BI REST API custom functions

Size: 9.53 MB - Last synced at: 8 days ago - Pushed at: 9 months ago - Stars: 71 - Forks: 16

alisonpezzott/calendar_periods_time_tables_power_bi

Calendar (dates), Periods and Time table for Power BI and Fabric

Language: M - Size: 8.86 MB - Last synced at: 2 months ago - Pushed at: 6 months ago - Stars: 48 - Forks: 22

Chiagoziemchidera/HRAnalytics-Diversity-and-Inclusion

The insights derived from this project provide valuable input for HR departments and company executives to foster an inclusive workplace, improve talent management strategies, and ensure equitable opportunities for all employees.

Size: 399 KB - Last synced at: 4 months ago - Pushed at: 4 months ago - Stars: 0 - Forks: 0

Hermione-Granger-1176/Old-Files

All Excel and other files for practice

Language: HTML - Size: 24.4 MB - Last synced at: 4 months ago - Pushed at: 4 months ago - Stars: 0 - Forks: 0

szilardev/PowerQueryFindAndReplace

Finds and replaces values ​​in one table based on values ​​in another table.

Size: 0 Bytes - Last synced at: 4 months ago - Pushed at: 4 months ago - Stars: 0 - Forks: 0

SatyaCoder29/Comparison-of-Region-based-Sales-Tableau

The region-based sales comparison analyzes sales performance across different regions. It identifies trends, top-performing regions, and areas needing improvement by comparing metrics like revenue, growth rate, and product demand. This analysis helps optimize sales strategies and resource allocation for better performance.

Size: 416 KB - Last synced at: 4 months ago - Pushed at: 6 months ago - Stars: 0 - Forks: 0

SatyaCoder29/Superstore-Sales-Analysis-

Analyzed Superstore Sales Data to uncover trends, optimize sales, and improve profitability. Explored customer segments, regional performance, and product categories using Python and Power BI. Delivered actionable insights to enhance revenue, streamline inventory, and refine marketing strategies, driving data-informed decision-making.

Size: 5.07 MB - Last synced at: 4 months ago - Pushed at: 6 months ago - Stars: 0 - Forks: 0

SatyaCoder29/SmartFinance-Dynamic-Financial-Dashboard

SmartFinance: Dynamic Financial Dashboard is an interactive tool designed to visualize key financial metrics like revenue, expenses, and profit. It features real-time data updates, charts, slicers, and navigation for easy analysis. This dashboard helps businesses make data-driven decisions and optimize financial performance.

Size: 900 KB - Last synced at: 4 months ago - Pushed at: 6 months ago - Stars: 0 - Forks: 0

SatyaCoder29/E-commerce-Sales-Analysis

Performed E-commerce Sales Analysis to identify trends, optimize sales, and improve decision-making. Analyzed customer patterns, seasonal trends, and product performance using Python, SQL, and Power BI. Delivered actionable insights to enhance revenue, streamline inventory management, and boost customer engagement.

Size: 626 KB - Last synced at: 4 months ago - Pushed at: 6 months ago - Stars: 0 - Forks: 0

tomiapo/monday-to-powerbi

monday.com api to power bi integration

Size: 4.88 KB - Last synced at: 6 months ago - Pushed at: 6 months ago - Stars: 2 - Forks: 0

marclelijveld/PowerQuery

This repository includes Power Query script for different functions

Size: 6.84 KB - Last synced at: 7 months ago - Pushed at: over 1 year ago - Stars: 6 - Forks: 0

softrutasintercampusITM/SmartTransitITM

Desarrollo de un sistema de análisis y optimización de rutas de transporte intercampus utilizando Power BI y Python, con el fin de mejorar la eficiencia y la satisfacción del usuario en el servicio de transporte entre campus de la universidad ITM

Size: 4.74 MB - Last synced at: 7 months ago - Pushed at: 7 months ago - Stars: 0 - Forks: 0

AnHerbWorm/DataAnalysis

Modules (VBA/Python) and Queries (Power Query M) for common data analysis and reporting tasks.

Language: VBA - Size: 62.5 KB - Last synced at: 6 months ago - Pushed at: over 2 years ago - Stars: 3 - Forks: 1

amalanov/EditExcelPQM

Visual Studio Code plugin to edit Power Query M code stored inside xlsx/xlsm file

Language: TypeScript - Size: 29.2 MB - Last synced at: 6 months ago - Pushed at: over 2 years ago - Stars: 20 - Forks: 9

szilardev/PowerQueryEasterCalculator

Calculates the date of Easter and related holidays (Pentecost and Good Friday).

Size: 281 KB - Last synced at: 11 months ago - Pushed at: 11 months ago - Stars: 0 - Forks: 0

stephanyed/replace-data-from-another-table

Replace data of main table from another table (exclude null cells) in Power Query

Size: 28.3 KB - Last synced at: 12 months ago - Pushed at: about 1 year ago - Stars: 0 - Forks: 0

Turnipdo/SSMS-SQL-PowerQueryM-Functions

Using Power Query M to extract values from Excel workbooks for dynamic insertion into SQL code.

Size: 13.3 MB - Last synced at: 2 months ago - Pushed at: about 1 year ago - Stars: 0 - Forks: 0

Turnipdo/Real-Time-BTC-USD-Airflow-DAG-Extract-In-Excel

Using yfinance, we grab minute-by-minute BTC-USD data, dump it into PostgreSQL, and link Excel via ODBC for quick analysis!

Language: Python - Size: 56.6 KB - Last synced at: 2 months ago - Pushed at: about 1 year ago - Stars: 0 - Forks: 0

SSlinky/MegaQuery

Useful and reusable power queries.

Size: 138 KB - Last synced at: about 1 year ago - Pushed at: about 1 year ago - Stars: 0 - Forks: 0

Xwilarg/PowerQueryMCheatSheet

A website to help with Power Query M

Language: HTML - Size: 26.4 KB - Last synced at: about 1 year ago - Pushed at: almost 5 years ago - Stars: 1 - Forks: 0

maingarcada/PowerBi_learnings

PowerBI learnings include all cases of modules I have practiced in terms of PowerBI

Size: 1.3 MB - Last synced at: about 1 year ago - Pushed at: almost 3 years ago - Stars: 0 - Forks: 0

trxn8r/trxn8r

Transactionator - The Trippy T-Rex Bulk CSV Importer/Transformer/Deduplicator; for the TillerHQ.com 2022 MS Excel Challenge; Better than my resume for Tiller Sr. Engineering Job 😱

Size: 161 MB - Last synced at: about 1 year ago - Pushed at: about 3 years ago - Stars: 3 - Forks: 1

rabestro/exercism-solutions-power-query-m

Solving problems from the site Exercism in Power Query M language

Size: 78.1 KB - Last synced at: 8 days ago - Pushed at: about 1 year ago - Stars: 0 - Forks: 0

jwr42/City-Bikes-Regression

Predictive linear regression model constructed in Power BI that uses the outside air temperature to predict the number of journeys taken on the Helsinki bike system, in the Helsinki and Espoo metropolitan areas of Finland.

Size: 576 KB - Last synced at: over 1 year ago - Pushed at: over 1 year ago - Stars: 0 - Forks: 0

udipta14/Store_Sales_Analysis

The aim of this project was to built an interactive dashboard in Power BI with a store's sales dataset. The dashboard is accessible through the link provided in Readme file.

Size: 22.5 KB - Last synced at: 26 days ago - Pushed at: over 1 year ago - Stars: 0 - Forks: 0

ManinderpreetPuri/Business-Resilliance-Program-Data-Analysis

I utilized Power BI and MS excel to bring insights into MIC's Business Resilience Program(BRP) which aims to support small businesses during COVID pandemic in states: Victoria, South Australia and Tasmania. BRP is an initiative by MIC in collaboration with the Australian Small Business Advisory Services (ASBAS) digital solutions.

Size: 5.84 MB - Last synced at: over 1 year ago - Pushed at: almost 4 years ago - Stars: 0 - Forks: 0

MStasiw/Build-Win-Print-Queues

Automates the building of Windows Print Queues which conform to a standard by obtaining input from CLI

Language: PowerShell - Size: 49.8 KB - Last synced at: almost 2 years ago - Pushed at: almost 2 years ago - Stars: 0 - Forks: 0

Mrcwr2/Power_Query_M-code_HVAC_PM_Autobuilder

Manipulating Data excel data in power query so that it works in our JLL Corrigo System and is built automatically. (Names and amounts have been changed for privacy)

Size: 2.23 MB - Last synced at: almost 2 years ago - Pushed at: over 3 years ago - Stars: 0 - Forks: 0

agusvaldes/call-center-anonymous-bank

Este proyecto de Power BI presenta un análisis exhaustivo de las llamadas recibidas en el call center "Anonymous Bank" durante el año 1999.

Size: 13.1 MB - Last synced at: about 2 years ago - Pushed at: about 2 years ago - Stars: 0 - Forks: 0

scioffi96/Call-center-Anonymous-bank

Este dashboard de Power BI muestra las operaciones del call center del banco Anonymous Bank para el año 1999.

Size: 11.9 MB - Last synced at: about 2 years ago - Pushed at: about 2 years ago - Stars: 0 - Forks: 0

fedeandresg/call-center-anonymous-bank

Este dashboard de Power BI muestra las operaciones del call center del banco Anonymous Bank para el año 1999.

Size: 12.2 MB - Last synced at: about 2 years ago - Pushed at: about 2 years ago - Stars: 0 - Forks: 0

menkar91/dataTools

Herramientas para el manejo de datos

Language: TSQL - Size: 75.2 KB - Last synced at: about 2 years ago - Pushed at: about 2 years ago - Stars: 0 - Forks: 1

jstrong013/PracticeEngine 📦

Scripts that assist with the consumption of the Practice Engine API

Language: PowerShell - Size: 5.86 KB - Last synced at: 5 days ago - Pushed at: over 2 years ago - Stars: 0 - Forks: 0

JBJ2110/SML-25-Days-of-DAX-snippets

A place for #SML members to share code snippets

Size: 1000 Bytes - Last synced at: over 2 years ago - Pushed at: over 2 years ago - Stars: 0 - Forks: 0

PhilipColtharp/convert-PowerShell-dir

convert PowerSHell Get-ChildItem (dir) output to table with m-code

Language: MATLAB - Size: 5.86 KB - Last synced at: 8 months ago - Pushed at: almost 3 years ago - Stars: 0 - Forks: 0

Ehijator/ArsenalScrape

This project will be analysing historical data accquired from FBREF it will be accquire sports historical data on my favorite football team ARSENAL FC

Language: Python - Size: 9.77 KB - Last synced at: over 2 years ago - Pushed at: almost 3 years ago - Stars: 0 - Forks: 0

marclelijveld/powerquerym Fork of itsnotaboutthecell/powerquerym

Power Query M

Size: 3.09 MB - Last synced at: over 2 years ago - Pushed at: over 3 years ago - Stars: 0 - Forks: 0

claudioaf/PowerBI

This repository is intended for content developed using Dax and M language in Power BI.

Size: 324 KB - Last synced at: about 2 years ago - Pushed at: over 3 years ago - Stars: 1 - Forks: 0