Make a Pivot from Another Pivot Table in Excel
Recently, a client shared data with me that is clearly a pivot table and wanted me to make another pivot from it using Excel. This is a common and annoying problem we all face when working with Excel. Today, let me share my approaches for creating a pivot from another pivot report using Excel. Option […]
How to Merge Multiple CSV Files in Excel (Step-by-Step Guide)
Have a bunch of CSV files in a folder and want to merge or combine them to one big file? Follow these simple instructions to combine multiple CSV files in to one spreadssheet using Microsoft Excel (2016 or above). What you need? Method 1: Merge CSV Files using Power Query (Recommended) This is by far […]
SQL vs. Power Query – The Ultimate Comparison
Podcast: Play in new window | Download
Subscribe: Apple Podcasts | Spotify | RSS
On the left side, we have a veteran warrior with 37 years of data battle scars and redundant six pack. They call him SQL.
On the right side, there is a young challenger with transformative powers and “never say undo” attitude. He goes by the moniker Power Query.
Who is going to win this battle?!?
How to make a pivot table when you have data in multiple sheets [Tutorial]
Recently I had to create a Pivot report from monthly data. But there is a twist. The data is spread across multiple sheets, one for each month. Let me explain how I built the pivot for that scenario.
How to “auto” generate calendar tables with Power Query – The best method
Calendar (or date) table is crucial for performing date intelligence calculations in Power BI.
Normally, you would find a reasonable calendar table in most data models. But occasionally I come across models where there is no calendar table.
So I present to you, the ultimate & best way to generate calendar table using Power Query.
How to connect to a SINGLE file on SharePoint from Power Query (Fix Unable to Connect Error)
Want to connect SharePoint files to Power Query but keep getting “unable to connect” error? Here is a simple fix to the problem.
Extract data from PDF to Excel – Step by Step Tutorial
Recently I had to extract data from multiple credit card statements and combine them to one Excel table. In this tutorial, let me share you simple steps to deal with PDF data and extracting it to Excel.