Experian Data Quality Community
-
Unlock the Power of Markdown in Aperture Data Studio
Did you know Aperture Data Studio supports Markdown? This lesser-known feature can transform how you present information, making your dashboards, workflows, and catalog entries more engaging and easier to read. Markdown enables a wide range of formatting options, including: Text formatting (headers, subheaders, bold,…
-
How to Implement Uniqueness & Referential Integrity Checks in Aperture Data Studio
Hi everyone, Happy New Year! 🎉 I wanted to share a quick tip that came up in a recent discussion around BCBS 239 compliance and data quality checks in Aperture Data Studio. Specifically, how to handle Uniqueness and Referential Integrity validations. Context When working with BCBS 239 or similar regulatory frameworks,…
-
Missing Tables in "Table or Database View" but Accessible via "Database Query
Hi community, I successfully created an external system connection to a database schema, including credentials. However, when I try to create a dataset using the "Table or Database View" option, I notice that some tables are missing from the list. Interestingly, I am able to access and query those missing tables using…
-
How to save profiling result as view for multiple table(50+ tables)
I have many tables, i need to run profiling on each of the tables and need to save the results as view. Since i have more number of tables, is there any way to do this altogether, rather then doing the same thing each table one by one.
-
Use of If-Then-Else logic in Aperture Data Studio
Imagine you are asked to use Aperture Data Studio to generate a new field for your sales data. You have the input fields: Discount Code, Quantity and Price. The ask is to generate a new field “Offer Price” using the following logic: How can you do this in Aperture Data Studio? The answer is to build a custom transformation…
-
Importing and Exporting Workflows
One of the very first things that you will probably wonder, is just how portable are my workflows that I create in Data Studio? The answer is simple. In v1.x if you have a workflow that you have created, there are some dependencies but as long as your source and target environments contain the same sources and…
