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

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

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

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.

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

Power BI REST API custom functions

Excel MCP Server & CLI - 23 tools, 214 operations for AI-powered Excel automation via COM API

Power BI REST API Connector - Admin Version

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

Blackbaud data connectors for Power Query and Power BI

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

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

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

Unlock insights into the U.S. healthcare landscape from 2019 to 2020. Our PowerBI-driven analysis delves into hospital performance, patient outcomes, and payer-provider dynamics. Dive into detailed reports and visualizations for informed decision-making, empowering healthcare stakeholders, and shaping the industry's future.

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.

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.

A PowerBI dashboard to analyze raw sales data from a multinational pharmaceutical manufacturing company and get insights into the performance of the sales team, customers, and distributors.

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.

Collection of useful Power Query M templates, functions and snippets

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.

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

Heart Disease Analysis Power BI Dashboard A data-driven Power BI report analyzing heart disease patient data to uncover insights by gender, age, and health metrics. Built using Power BI, Excel, and DAX to demonstrate data modeling, visualization, and business intelligence storytelling for healthcare analytics.

This dashboard (Data Jobs v3) was created for Job Seekers, Job Transitioners, and Job Swappers to solve a common problem: information about the data job market is scattered and hard to grasp. Using a real-world dataset of 2024 data science job postings (including titles, salaries, and locations) this project provides a single, easy-to-use interfac

An end-to-end Power BI analytics practice project exploring global Data Science salary trends, job market dynamics, and hiring funnels. Featuring interactive dashboards, advanced DAX measures, and geospatial analysis to uncover insights into compensation, degree requirements, and industry demand.

This repository features the Superstore Sales Analysis project, demonstrating data cleaning and analysis using Python and SQL, along with interactive visualization in Power BI. Explore the code and reports to gain insights into sales performance, customer behavior, and product analysis.

Navigating the data job market can feel like a maze with information scattered everywhere. This dashboard (V2.0) is designed specifically for Job Seekers, Job Transitioners, and Job Swappers to cut through the clutter! Using a real-world dataset of 2024 data science job postings rich with details on titles, salaries, and locations.

Creates new spreadsheet from metadata

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

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