Experian Data Quality Community
Learn, collaborate and solve problems with like-minded data quality enthusiasts.
Discussion List
-
Convert Boolean ✅❌Convert Boolean [Category: Conversion] This function converts a binary or Boolean values (i.e. true…
-
Contains Non-Latin Characters 🈯Contains Non-Latin Characters [Validation] This function identifies the presence of any character…
-
Reverse String ⏪Reverse String If you find yourself needing to reverse a string (i.e. for bespoke building of anony…
-
PCI Detection 💳 (Payment Card Information)Summary The following package is used to detect payment card information (PCI) and whether it is pr…
-
SIC Conversion 🏷️Summary The following package is used in processing Standard Industry Classification (SIC) codes, a…
-
Challenge 3 - It's a Date!This latest challenge is all about dates. The sample dataset highlights a common challenge many of …
-
Scheduling workflows using the Data Studio REST API in version 2In v2.0 of Data Studio, the REST API has changed from v1, so this original post has been updated fo…
-
Sharing of useful functions to support contact data validationHi all, I've found myself using a few functions on a regular basis so thought I'd share t…
-
Using Format Phone NumberI was wondering how everyone uses the function Format Phone Number in Aperture. For myself, I am to…
-
Challenge 2 - Title Casing SurnamesDoes it bother you when you get mail through the letter box and your name is not presented with ‘st…
-
Datasetdropzone directory changes in v2.1.2Hi all, I’m writing this post to inform you all on the upcoming change to the datasetdropzone direc…
-
Export directory changes in v2.1.2Hi all, I’m writing this post to inform you all on the upcoming change to the Export directory in v…
-
Attention all V1 & V2 users...Today we have launched a new sub category, Migrating from V1 to V2, which contains posts to aid you…
-
✏️ Challenge Index 🔍Each month we're posting a new challenge for you to have a go at to test your data skills. Cha…
-
Challenge 1 - Gender Title Mismatch DetectionThis first challenge is concerned with identifying records that are displaying inconsistent informa…
-
🏆 How to respond to challenges 🏆Guidance When you've successfully completed a challenge. Make sure you post your solution so o…
-
Open Data Sources by CountryA few open data sources. Feel free to add more. United States: http://www.data.gov/ Austria: htt…
-
💡 Submit a challenge idea 💡We love to hear challenge ideas from our Community members, so if you have an idea that you think w…
-
Function to calculate the number of working days between two datesRecently I wanted to create a function in Data Studio to calculate the number of working days betwe…
-
How to systematically sample with a fixed sample size and varying population sizeI was recently asked how to build a Data Studio workflow that would output a systematically sampled…
-
What is the status of data catalog integrations, for example Collibra?What is the current status of Aperture to Collibra-integration? https://marketplace.collibra.com/pr…
-
Community guidelinesWe welcome you and your views in our community! We want to make this a positive, safe and vibrant p…
-
How to earn points, badges and to increase rankThe Experian Data Quality Community isn't about the volume of discussions and questions but ab…
-
How to register and manage your accountYou need to register to post and comment, but don’t worry - it takes a couple of minutes. Click Reg…
-
Welcome to the Experian Data Quality Community 🙌 Welcome! At Experian, we’re extremely proud of our data quality solutions, and we've set up t…Pinned post Read only 166 views 0 comments 0 points Most recent by Tanj Jagpal Welcome to the community
-
Using a network path for the server import or export directoryIt may be desirable to have Data Studio v1 or v2 import and export data from a network path. This w…
-
Handling Gmail email addresses for duplicate identificationThe problem: Gmail allows multiple e-mail addresses for a single account With over 1 billion active…
-
Scheduling workflows using the Data Studio REST APIAperture Data Studio is intended to be invoked from third party schedulers , like Windows Task Sche…
-
Data Studio v1.6.2 is now available!This maintenance release resolves several issues caused when executing workflows using the REST API…
-
Approach for Matching Product data (product description)Yesterday @MiteshKhatri @Akshay Davis @Katya Jermolina and I were having a discussion about approac…
-
Partition Values (Dynamic SQL Partition Row Number)A question that's cropped up for a couple of clients recently is how do I segment my data and …
-
Accesing data from quick sense filesHi everyone, I'm new in data aperture and I have a client who calculates KPIs in a quick sense…
-
Cross-system and cross-table relationship discovery automationIn our customer cases data quality issues are often cross-system inconsistencies. Technically, cust…
-
Data Studio and MDMIt sometimes gets asked how we co-exist with an MDM system. We have many customers using Data Studi…
-
Extracting a specific piece of information from an address using regular expressions and lookupsData Studio has several built-in functions to allow you parse strings of text and extract a particu…
-
How to trigger an e-mail notification if a job failsData Studio has a range of default notification options which allow you to send a custom email to d…
-
Sharing database connections across teamsWhat's the recommended approach to sharing tables/views and connections to databases across a …
-
Ensuring you always return the same duplicate ID with Find DuplicatesFind Duplicates returns consistent Cluster ID after each run. Consistency here applies to the seque…
-
Getting started with Regular Expressions in Data StudioA regular expression (from here on we’ll call them “regex” for short) is a well-known and powerful …
-
Tips to improve workflow performanceIf you ever find that a workflow is taking a long time to execute, you might want to think of ways …
-
Using a discriminant for Find Duplicates clusteringFind Duplicates will use fuzzy matching to link records, however, in some cases you may have a disc…
-
Data Studio v1.6.0 is now available!The latest version of Data Studio introduces new features, existing functionality enhancements, per…
-
Dealing with PIITalking to a prospect today about PII - identifying it on data loaded into the system and then proc…
-
What's better invalid data or missing data?A discussion that seems to come up from time-to-time is, whether it is better to have gaps in your …
-
Extract a number (6-char SIC code) from a string and perform a lookup (2-char SIC to get category)Using some of the Company's House open data, I recently built a simple workflow that extracts …
-
Floating Point numbers with Microsoft Excel Open XML Spreadsheet (.XLSX) filesWhen using .XLSX files in Aperture, be aware that floating point numbers will be treated differentl…
-
The importance of profiling when using Find duplicatesWhen implementing Find duplicates in Aperture Data Studio we've seen many examples of the impo…
-
Great article on building loyalty with a Single Customer View!Just sharing a great article written by @aysha_aktemur on how Aperture Data Studio empowers loyalty…
Categories
Popular tags
- Release notes 224
- Aperture Data Studio 166
- Functions 64
- Find Duplicates 59
- Datasets 47
- Workflows 46
- REST API 37
- Data Studio 33
- feature demos 26
- dmx 26
- JDBC 24
- tips and tricks 23
- Rules 19
- Automations 19
- validation 17
- Validate 17
- Transform 16
- Community Challenge 15
- Notifications 15
- v2.14 15
- datasource 15
- Downloads 14
- v2.12 14
- v2.8 14
- Extensions 14