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)

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.

Power BI REST API custom functions

Power BI REST API Connector - Admin Version

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

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

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

Collection of useful Power Query M templates, functions and snippets

Sales Data analysis project using Power BI and SQL | Kaggle Dataset | Data Cleaning | Data Visualisation | Power Query | Model | DAX | SQL Data Analysis | SSMS

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

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.

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

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.

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

Creates new spreadsheet from metadata

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.

Custom Excel linked data types with RDF & SPARQL