|In the previous article we saw the problem with importing CSV files.
Here is how the new Power Query can be used to clean the data while importing.
|We explore a very powerful and extremely useful approach to bin analysis using VLOOKUP.Estimated reading time 10 min
Estimated time saving many hours (if you were doing this manually)
|Let us explore numeric grouping in Pivot Table with the Ageing Analysis scenario.Estimated reading time 7 min
Estimated time saving – hours!
|Bin or Bucket Analysis is a common requirement.We will see how easy this is using Grouping feature of Pivot Table.Estimated reading time 10 min|