Analytics Tuts

Analytics Tuts

Analytics and Data Visualization Tutorials

  • Linkedin
  • Twitter
  • Pinterest
  • GitHub
  • Home
  • R
  • Tableau
  • Excel
  • SQL
  • Alteryx
  • Python
  • Power BI
  • Automation
    • Airtable
    • Power Automate
  • Hire Me

Tag: M query

Handling Merged Headers in Excel with Power Query

March 27, 2025 Niket Kedia Leave a comment

Hello Friends!! In this blog post, we will explore a Power Query M script that performs a series of transformations on a table from an Excel workbook. This script refines and reshapes the data, making it more structured and analysis-friendly. Let’s break it down step by step and file attached to download.

Read more
  • Excel

Ranking by groups using Power query in Power BI

May 10, 2022 Niket Kedia 16 comments

Hello Friends, Today we’ll be learning how to create ranking by groups using Power query in Power BI. Easy and quick tutorial to follow. Power BI is attached used in the tutorial.

Read more
  • Microsoft Power BI

Find me on Codementor

Codementor badge
Get Data Scientist Handbook Copy
Copyright © 2015-2024 | Analytics Tuts Theme: Dynamic News