Profiling data in PowerPivot: Detecting duplicates

Star InactiveStar InactiveStar InactiveStar InactiveStar Inactive
 

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.

Read more...

Tags: dax, excel

 

2007-2015 VidasSoft Systems Inc.