Prepared by Yusra Mahmood
Lecture 2
Working on Sample Data Set
Steps:
1. Load the Data File. In our case it is “Country Population by Year” (Excel Sheet).
2. Open the Power Query Editor to analyze the data.
3. In our dataset, we have to remove top 3 rows as they are not giving any important
information.
“When you practice something with conscious mind and then continue practicing the same even with sub-conscious mind, you
master it.”
, Prepared by Yusra Mahmood
4. Now we want to take transpose (reverse the rows and columns).
“When you practice something with conscious mind and then continue practicing the same even with sub-conscious mind, you
master it.”
Lecture 2
Working on Sample Data Set
Steps:
1. Load the Data File. In our case it is “Country Population by Year” (Excel Sheet).
2. Open the Power Query Editor to analyze the data.
3. In our dataset, we have to remove top 3 rows as they are not giving any important
information.
“When you practice something with conscious mind and then continue practicing the same even with sub-conscious mind, you
master it.”
, Prepared by Yusra Mahmood
4. Now we want to take transpose (reverse the rows and columns).
“When you practice something with conscious mind and then continue practicing the same even with sub-conscious mind, you
master it.”
