What are Quality Insights?
Oracle Analytics automatically analyzes data quality to help you cleanse and enrich your data.
When you edit a table in the join diagram or transform editor, Oracle Analytics analyzes the quality of the data and provides a visual summary known as a
quality insight in a tile above each column. Quality insights enable you to
explore your data, and use a visual overview of the content to assess and
improve data quality. The quality summary is based on a sample of the data,
but changes that you make are applied to all of your data. Quality insights
display a frequency tile for text or a histogram for dates and numbers.
Description of the illustration quality-insights-intro.png
Quality tiles enable you to:
- Explore - Explore your data in real time
using instant filtering, which enables you to temporarily
filter data across all column in the table. You can filter
on multiple values at the same time.
Description of the illustration quality-insights-filter.pngThe value being filtered is marked with a green box. Filters aren't added to the data preparation script.
- Review - Use the interactive visualizations
such as bar charts and histograms to evaluate your data and
identify anomalies and outliers.
Description of the illustration quality-insights-charts.pngThe quality tiles at the top of each column provide an instant assessment of the quality of content in that column based on a deep semantic understanding of the data.
- Assess - Hover over the quality bar to see a
popup summary showing the percentage of valid and invalid
values. Click on areas marked in red to filter on invalid
values.
Description of the illustration quality-insights.png - Replace or correct - When you've identified
anomalies and outliers, use inline replace to correct
values. You get immediate feedback on the improvements to
the data quality on the quality bar.
Description of the illustration quality-insights-replace-1.png - Scroll - Navigate large datasets using the
scrollable mini-map.
Description of the illustration quality-insights-scroll.png - Rename columns - Create more readable column
names easily.
Description of the illustration quality-insights-rename-columns.png
Make sure that you toggle the Quality Tiles
option bottom right to display quality tiles.
Description of the illustration quality-insights-toggle.png