Heavy data using PowerQuery
Teach you this story. Always think like this.
If you want to recommend someone who has to work with heavy Excel data, what should I recommend?
🔸 every time, this idea has to bounce up.
"Power Query, sir."
👉 It's a tool that helps make work "convenient, easy to use, accurate." It was born specifically for this job.
These three words are the most important thing to work with Data.
"Dear power query." It's really good for life.
This is a small example of power query. It's simple.
---------------/ / ---------------
Want to specify a Rank Rating according to Revenue.
We will use the Conditional Column add columns menu.
👉 simple procedure like this.
1) Click the column you want to use to define the condition.
2) Select Add Column Tap, select "Conditional Column" to add conditional columns (if you do not click Select Column, the "Conditional Column" menu cannot be used).
3) Configuration to add "Conditional Column" type column, there is something to define is
4) New column name, name the desired new column
5) Column Name defines the desired column as a condition (more than 1 column can be specified)
6) Define the Operator to be used to determine the conditions (Equals, Does not equal, Begins with,...)
7) Value configures to condition column generation.
8) Output Specifies the desired value for the new column.
9) Additional conditions can be defined.
10) Else Specifies the desired value if the check value does not meet the checked condition.
11) Click on the "OK" button to create a new column according to the set conditions.
The important 🔸 is...
Write it down. Next month, no need to do more. Just paste the new sales file and press refresh, it will automatically cut the Rate Ranking for us:)
👉 Interested to Apply Power Query Course: Automating Data Cleaning and Transformation ☺️
************************
Patriotic
Learn Excel With Pichart
Smart Excel For Better LIFE
# powerquery # dataTransformation# dataCleansing# data analysis # data aanalyst# ExcelByPichart # ExcelTips # PowerQuery # PivotTable # HRTools # Excel Technique # Works Sensitive with Excel # Query Summary # HR Excel Line # Vaique ÉSua
