power-query

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.

microsoft sql database dashboard models data-visualization microsoft-sql-server relational-databases power-query sqlserver powerbi msexcel adventure-works powerbi-visuals data-visualization-project powerbi-report microsoft-power-bi microsoft-data-analysis

UpdatedApr 22, 2023
TSQL

sio /LibPQ

Star80

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

library module modules excel power-bi power-query powerbi powerquery

UpdatedAug 21, 2023
JavaScript

tirnovar /Power_BI_REST_API_PQ

Star70

Power BI REST API custom functions

rest rest-api power-bi power-query m powerquery powerquerym power-query-m power-bi-rest-api powerbi-custom-functions power-bi-custom-functions

UpdatedSep 5, 2024

jxareas /PL-300-Guide

Star62

Questions, Solutions & Labs of Microsoft's Official Power BI Certification.

microsoft sql powershell power-bi business-intelligence learn data-analysis northwind power-query dax powerbi t-sql powerquery business-analytics contoso power-bi-dax pl-300-questions pl-300-exam

UpdatedFeb 15, 2025
PowerShell

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

Star43

Power BI REST API Connector - Admin Version

admin rest-api power-bi power-query powerbi powerquery powerquerym powerbi-service power-bi-api power-query-m power-bi-apis

UpdatedAug 29, 2024

nimblelearn /datapackage-m

Star29

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

excel csv-files tabular-data data-transformation power-bi data-acquisition data-visualization open-data data-visualisation data-analytics data-analysis power-query tabular-data-package data-package powerbi json-table-schema frictionlessdata datapackage

UpdatedJun 10, 2021
R

blackbaud /powerbi-connector

Star27

Blackbaud data connectors for Power Query and Power BI

power-query powerbi m

UpdatedMar 10, 2025

kerski /powerquery-connector-pbi-rest-api-commercial

Star26

Power Query Custom Data Connector for Power BI REST APIs (Commercial)

power-query

UpdatedMar 18, 2025
PowerShell

pvn-ptl /AdventureWorks-Analytics

Star26

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

UpdatedDec 6, 2021

NiveditaSureshK /Sales-Analysis-DB-MSExcel

Star14

Assessed historical shipping data for a shipping company selling products and shipping them to its customers' destinations to determine future shipping strategies.

spreadsheet pivot-tables power-query msexcel sales-analysis power-pivot data-analysis-excel

UpdatedOct 11, 2022

deepamkalekar /Sale-Data-Analysis-PowerBI

Star13

sql dashboard data-visualization power-query powerbi data-cleaning sql-data-analysis

UpdatedOct 14, 2021

xShaimaa /Udacity-Data-Analysis-and-Viz-with-Microsoft-Power-BI

Star12

Projects for Udacity's Data Analysis and Visualization with Microsoft power BI that covers: data pre-processing, visualization, and analysis using Power BI as primary tool.

udacity dashboard data-model data-visualization business-intelligence power-query data-preprocessing powerbi

UpdatedDec 18, 2022

SarangGami /HR-Analytics-Dashboard-PowerBI-PowerQuery

Star11

The HR-Analytics Attendance Dashboard uses Power Query, DAX Query and Power BI to analyze employee attendance data and provide insights into attendance patterns. The data is cleaned and transformed using Power Query and DAX Query. A dashboard is created with visualizations, measures, filters, and slicers to help HR identify areas for improvement.

data-analysis power-query powerbi hr-analytics dax-query

UpdatedMar 16, 2023

anton-dudarev /power-query

Star10

Collection of useful Power Query M templates, functions and snippets

power-query powerquery

UpdatedJan 23, 2023
MATLAB

nimblelearn /datapackage-connector

Star10

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

csv-files tabular-data data-transformation power-bi data-acquisition data-visualization open-data data-visualisation data-analytics data-analysis power-query tabular-data-package data-package powerbi json-table-schema frictionlessdata datapackage

UpdatedJun 16, 2020

MonicaDara /Sales-Analysis-Dashboard-PowerBI

Star9

Enable stakeholders with an engaging Power BI dashboard illustrating key e-commerce performance indicators and patterns. Evaluate sales data, predict forthcoming trends, and formulate knowledgeable approaches to foster business expansion.

data-visualization business-intelligence predictive-analysis power-query dax sales-analysis sales-forecasting dax-expression e-commerce-analysis power-bi-dashboard dax-query decision-making-tools

UpdatedApr 24, 2024

Praveendinesha /Sales-Insights-Analysis_E-Commerce

Star8

Empower decision-makers with an interactive Power BI dashboard showcasing e-commerce performance metrics and trends. Analyze sales data, forecast future trends, and drive informed strategies for business growth.

data-visualization business-intelligence power-query dax predictive-analytics sales-analysis sales-forecasting dax-expression power-bi-dashboard dax-query e-commerce-analytics decision-making-tools