Resources
Discussion List
-
Licensing for Aperture Data StudioThis article provides an overview of all things cloud licensing including pre-requisites, activatio…
-
🛢️ Loading from OData using the Autonomous REST ConnectorThe Autonomous REST Connector JDBC driver packaged with Aperture allows you to load (and refresh) t…
-
📑 API paging with the Autonomous REST ConnectorIn this article I want to share a few approaches to configuring paging when accessing REST APIs usi…
-
Aperture REST API calls as Datasets within ApertureData is available from Aperture via the REST API that is not available in Aperture. Full details of…
-
♻ Reusable workflow example – calculate word frequencyToday I’d like to share with you a reusable workflow that I built a little while ago not only as a …
-
ℹ️ Importing your Datasets into Excel or Tableau using ODataYou can easily get your data from Data Studio into Excel or Tableau using OData. OData (odata.org) …
-
ℹ How to use Functions in WorkflowsWorkflows Workflows is the area in Data Studio where designer users tend to spend most of their tim…
-
How I got started with Data StudioAssuming Data Studio is set up and your user account has been created, “Your space” is your persona…
-
ℹ How to track DQ issues with Issue listsIssue lists allow you to capture problematic records, assign them to stakeholders and collaborate o…
-
🎞️ A short video demonstation on using the Quick Actions bar, shortcuts and moreSince Aperture Data Studio 2.8.0 users have been able to use the Quick Actions bar to access freque…
-
Use a value in your data as the export file nameIf you are looking to use a value in your data as the export file name, you may have looked at the…
-
How to identify blocking keys for Find DuplicatesBlocking keys identifies records that are similar, creating blocks or potential groups of matches. …
-
Quick Actions menuSince v2.8 Aperture Data Studio has had a command palette that makes shortcuts and access to freque…
-
Best practices designing complex WorkflowsA Workflow is a sequence of steps that defines a process to transform and manipulate your data. Whe…
-
Suggest Validation rules - Validate stepAperture Data Studio has a Validate workflow step that allows you to define rules of how data in sp…
-
How to highlight null/empty valuesWhen performing exploratory data analysis, or presenting data in grids in a dashboard, you may want…
-
How to set up an export file name based on a fixed or variable inputIn this article, we will be exploring a number of ways to set up an export file name. Imagine you s…
-
How to append leading or trailing zeroes to a numberAperture makes it very easy for you to append a chosen character to any value to achieve an overall…
-
How to remove leading or trailing charactersHere's a simple example of how you can remove leading or trailing characters. Assume you have loade…
-
Find Duplicates Training DataAttached is data to be used with Find Duplicates Training.
-
Find Duplicates Service Installer FAQHere are some FAQs on the Find Duplicates Service Installer available since Aperture Data Studio v2…
-
Tips and Tricks to make Find Duplicates Blocking Keys and Ruleset more readableWhat is your first impression of the blocking keys and ruleset definitions required for Find Duplic…
-
Tune Rules with Find Duplicates WorkbenchThe Find Duplicates Workbench provides you with the capability to tune your Find Duplicates rules u…
-
Identifying two names in a single string with the DelimitedField filterSometimes, the names data you have collected may not be in the best form to be parsed or standardiz…
-
Maximum cluster sizeFind Duplicates comes with a default setting for maximum cluster size at 500. This setting is there…
-
Find Duplicates - Standardize Name and AddressWhen setting up your Find Duplicates step, the match column allows you to determine which columns y…
-
Find Duplicates with Phonetic ComparatorsWe now have the new phonetic comparators (Soundex, NYSIIS and Double Metaphone) for Find Duplicates…
-
Moved: 📽 📺 Achieve more with your data - videosThis discussion has been moved.
-
🎞️ A demonstration on data maskingData Studio can suggest the hashing or masking of data based on a combination of data tagging and s…
-
🎞️ Here is a short demonstration video on sharingIn this video I will show how different types of user role and license assignments have different a…
-
-
New Experian Data Quality RoadmapI am delighted to announce that the interactive version of Experian Data Quality's product roadmap …
-
The chaining effectWhat is the chaining effect? Find Duplicates in Aperture Data Studio works by identifying blocks or…
-
Reviewing Find Duplicates ResultsWhen you preview the Find Duplicates results, you will see the Cluster ID and Match status. Record…
-
Encryption-at-rest FAQSince release 2.4.5, you can turn on a new security setting at Settings>Security, Encryption to …
-
Tuning Blocking KeysReview Find Duplicates step results Reviewing the Find Duplicates results may not be the best way t…
-
Building RulesIn order to start testing the Find Duplicates step, the Find Duplicates settings will also need to …
-
Profiling many datasets of different schemasTo profile thousands of datasets easily, you can create a reusable workflow with a replaceable sour…
-
Exact match and fuzzy match with Find Duplicates StepAperture Data Studio offers a Find Duplicates step that runs on a powerful standardization and matc…
-
Fuzzy Match with Regular ExpressionsImagine you have an address field containing variation of city names, for example: You need to dete…
-
Gauge Chart and Scoreboard chart with up/down tickGauge Chart A new chart type named Gauge chart has been added to the Chart step. The Gauge chart i…
-
🎞 Creating roles and assigning permissionsData Studio gives you some very fine grain control over what a given user can do within the system.…
-
🎞 Creating environmentsYou may have noticed that some users have more than one environment in their Data Studio Installati…
-
Selecting Best Record with Harmonize DuplicatesThere are times when you just want a quick way to deduplicate your data without necessarily knowing…
-
Exact Match with List functionsThere are a number of List functions that may be useful when you are trying to de-duplicate a list …
-
Exact Match with the Group StepThe Group step can be used as an easy way to identify and de-duplicate data that matches exactly. L…
-
Why worry about duplicated data?What is duplicated data? Duplicated data refers to data representing the same entity. An entity can…
-
Quick introduction to Blocking Keys and Rules for Find DuplicatesThe concept of Blocking Keys and Rules may be foreign to you if you haven’t already used the Find D…
-
All Find Duplicates Pre-built RulesetsThis dmx file will import all the Find Duplicates default rulesets. These are pre-built rules and b…
-
-
🎞 A Short Feature Demo on data validation in Data Studiohttps://bcove.video/3hw8COt