Profiling data in PowerPivot: Detecting duplicates

Generally - when you are given an unexplored dataset - your first task should be to identify some of its properties in order to make a more informed decision regarding the accuracy of reporting you can achieve with it. Many Business Intelligence professionals have robust tools at their disposal that can be used to deeply explore a dataset; however, data analysts can use the inherent capabilities of PowerPivot to get the job done.