This tutorial explains how to sort data in Looker Studio in a custom order, beyond the standard alphabetical or numerical sorting. Using a hypothetical bank loan portfolio dataset from a Google Sheet (link in description), the tutorial walks through creating a Looker Studio report, connecting to the Google Sheet data source, and setting up the…
This tutorial provides a comprehensive guide to pivoting and unpivoting data within SQL Server. We’ll delve into the process of transforming data from a row-based to a column-based format, and vice versa. You’ll learn how to pivot data based on single or multiple columns, as well as how to unpivot pivoted data to restore its…
In this video, the speaker explains how to unpivot data in Microsoft Excel and Power BI. The data used in the video is world population data downloaded from the World Bank, which is already pivoted, but not in the form of an Excel pivot table. The speaker wants to convert this data into an unpivoted…
The video is showing how to use the mapping technique in Microsoft Excel to summarize data. The data being used is a large set of sales from January 1st, 2018 to December 31st, 2018, of various grocery items. The goal is to create a table that shows the total sales of each grocery item, grouped…
