Xenomorph - Data Quality

An analysis of data quality for Equities, FX Rates and Treasuries for both a single data vendor and the percentage spread between two data vendors for FX Rates.

Contact partner Watch video

Data Quality

Analysis of data quality (gaps, flat spots, spikes and outliers) for a single data vendor for three types of asset - Equities (Close Price), FX Rates (Close Price) and Treasuries (Yield), using different test parameters for each. The analysis can be filtered by any of the asset types and the number of erroneous points is shown for the selected assets. Drill-down is possible for the Treasuries to reveal how the erroneous points are grouped according to expiry year of the Treasury. The second analysis shows the spread (difference) in percent between the quoted FX Rates (Ask Price, Bid Price and Mid Price) from two data vendors to highlight issues with emerging market currencies. The third analysis shows the actual Close Price history, both as physical data and on a chart, for the selected Equity along with indicators to show where each flat spot, spike and outlier actually occurs.

Want to become a Power BI Partner?

Certified partners are an important part of the team! Find new business opportunities, make connections, and share your company’s talents and experience with Power BI users around the world.

Sign up

Need help signing up?
Please contact pbiptnr@microsoft.com.

Request demo