MS Excel/Power BI: Unpivoting and Properly Pivoting Data in MS Excel and Power BI
DescriptionIn 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 form to create a proper pivot table for data analysis.
To unpivot data in Microsoft Excel, the speaker first selects the range of data, which contains the columns to be unpivoted. He then goes to the data tab and selects the "From Table/Range" option, which loads the data into Power Query. In Power Query, he selects the columns to be unpivoted and goes to the transform tab, where he unpivots the columns using the "Unpivot Columns" option. This converts the data into two columns, one for years and one for values. He then goes to the home tab and presses the "Close and Load" button to load the data into Microsoft Excel.
With the new unpivoted data, the speaker creates a pivot table in Microsoft Excel. He adds fields to the rows area, columns area, and values area and renames the row and column headings. He also formats the value fields and inserts a pivot chart with a single click.
To unpivot data in Power BI, the speaker first imports the data into Power BI using the "Get Data" feature. He then loads the data into Power Query and unpivots the columns using the "Unpivot Columns" button. He makes sure that the years and values are in numeric format and loads the data into Power BI. He then creates a dashboard from the data by inserting a line chart and a map chart, which he converts into a slicer. The speaker concludes by thanking the viewers and encouraging them to like and subscribe for more tutorials and updates.
Data Source: https://api.worldbank.org/v2/en/indicator/SP.POP.TOTL?downloadformat=excel
#UnpivotingData #PivotTable #MSExcel #PowerBI #DataAnalysis #DataVisualization #Dashboard #WorldPopulation