Power Query Archives - PK: An Excel Expert

Mastering Merged Query & PIVOT Column Techniques in Power Query

October 16, 2023July 27, 2024 PKComments Off

Power Query is a game-changer for those looking to improve their data analysis skills in Excel. With its variety of functionalities, this tool has particularly emphasized its importance in data

Power Pivot

Profit Analysis Dashboard using What-if Parameter

April 27, 2022March 4, 2025 PKComments Off

In this article, we have created a Profit Analysis using What-if Parameter in Microsoft Power BI. You can use this trick in your Sales dashboard. Profit Analysis Dashboard using What-if

Charts and Visualization

Dynamic Pivot Table with Multiple Tables using Power Query

January 31, 2021August 23, 2024 PKComments Off

In this article, we have created a dynamic Pivot Table with Multiple Tables using Power Query. We have taken 4 different yearly Sales Table as given in below image- Dynamic Pivot

Power BI

Daily Sales Report – Data Extraction from multiple PDF files

November 15, 2020September 16, 2024 PKComments Off

In this article, we have created a Daily Sales Report (DSR) in Microsoft Power BI. We have extracted and consolidated the data from multiple PDF files using Power Query. After

Charts and Visualization

Dynamic Filled map in Excel

August 23, 2020June 14, 2024 PKComments Off

In the article, You will learn how to create a dynamic filled map in Microsoft Excel. Filled Map is available with Office 365 subscription. You can display the Region, country,

Power Pivot Dashboard

Fully Automated Excel dashboard with multiple source files

April 12, 2020February 18, 2025 PKComments Off

In this article, we have create a full automatic excel dashboard with multiple excel source files. Each source file can have multiple worksheets. For data consolidation we have used Power