Learn, collaborate and solve problems with like-minded data quality enthusiasts.
Hi everyone, In this post I'd like to provide you all with a sneak peak of a new real-time data quality enforcement offering that we're currently exploring, that we'd love to get your feedback on (complementing our existing contact data validation products). The idea centres around exposing Data Studio functionality (e.g.…
It's really important to us that we listen to your feedback and use it to inform our product direction and to improve things that frustrate you. We're always keen to hear from customers about their experience with Data Studio. There are two ways you can do this. If you have time you can book a slot to have a conversation…
When you navigate into any of our categories you will see a Follow button in the sidebar. This will allow you to subscribe to getting email notifications and notifications in the community about that topic. So for example if you want to be notified of new releases, navigate to the release and downloads section and click…
We have renewed the SSL certificates for the aperture data studio servers successfully and we have tested the same. We have created the .pfx file and applied the certificate in find duplicate server as well. But when we tried to test the find duplicate through settings—>communications—>workflows, we are getting the below…
Hi Team, We have installed the aperture Data studio and Find duplicates in to the two different servers.We have enabled the port 446 to connect the application through firewall.But when we tried to connect the application, the connectivity is getting refused and the port is not supporting. powershell Test-NetConnection…
Issue lists allows Users in the same Space (including read-only Consumer users) to capture problematic records, allocate owners and collaborate on a resolution. Once a data issue has been ‘fixed’ in the source system, the Workflow will automatically set the Issue to the ‘Resolved’ status. Here is a detailed article about…
Hi, Anyone using Github connection to/from Aperture? If so, for what kind of purpose(s)? @Josh Boxer How would you recommend to use that? Br, Katri
Seeking a solution where I can build simple audiences – age 50+, US residents, household income $55000+, living in specific zip codes. Once I build that audience, I need it delivered to my Facebook campaign for targeting within 8 hours (I am happy to upload these audiences to Facebook manually but if this can be automated,…
Hi team, We need to enable SSO for our server and we got the certification. Can you please guide me how we can apply that certification fingerprint in SAML.
The Compare step allows you to detect and highlight differences between two data sources, e.g. year on year sales data or monthly customer sign ups. There are 3 outputs available to help determine if changes are as expected or if not, need further investigation. Results by key: quickly see if records have changed based on…
Hello, I've been at Experian Data Quality for over 10 years now. During that time I've been a Consultant working with Aperture Data Studio (and before that Pandora). I've worked with our Sales Teams to understand the needs of potential clients and demonstrate solutions to their problems. Recently I have switched to being a…
Data is available from Aperture via the REST API that is not available in Aperture. Full details of Spaces, User Groups, Users, Jobs, Datasets etc. We would like to use Aperture to manage Aperture. For example: An automated workflow which checks for long running jobs and notifies us of issues; a regular review of user…
Hi community, does anyone knows what does this error means?
Good morning, I'm trying to get outputs of a particular workflow, see image below, but it fails and returns the title error. The input is coming from the REST API that collects Aperture stats and the grouping is done on the column NAME (see attached file); the Rows to Columns step is introduced to re-orientate the data for…
Hi Team, We need to set up batch alerting for both failure and success for the below email addresses on the CAIS production environment. But the jobs are not yet placed in the environment. Could you please help us to set up the email notification for both job failure and success. Regards Uma Devi k
Connecting Data Studio directly to your data sources and CRM systems, like Salesforce, has never been easier. This video is to remind and inform users, just how easily two systems can work in harmony, without any complex development. We've created out of the box connectors, for a wide range of common platforms, to make…
Hi, Is it possible when loading an Excel file, to select only specific worksheets to load? I tried and could not see any options, but wondering if I missed something. Using version 2.12.13.108. Thanks
Hi, just wondering whether views are materialized (and only updated when underlying data is changed) or whether the view logic is executed each time the view is used. Thanks
Hi there, my duplicate store is generation very big clusters and I am struggling to find why is this matching. I am using the workbench and I checked a few records but non of them are matching so my question is. How can I see in a big cluster where and why this records are matching? TIA
has the process changed to update ssl cert on newer version? previously i used to do this, and hit save, now i see this, and does the section for public certificate needs to be empty? you guidance will be really appreciated, as our cert is expiring in 1 month or so on our dev server. Br, HS
Hello dear community, my use case is: we refresh more that 200 dataset ( from SAP source) in the same refresh workflow. For reasons that we don't know some of these dataset are not being refresh sometime. How can I track the list of dataset the should be refresh but are not ? The issue is that the refresh workflow is not…
Hello, I would like to ask if there is a way for certain profiles not to go through the validation process when entering data
Is there a way to disable a user that has not logged in to the Experian Data Studio app after a certain period of time? For example, if it's been 90 days then the user would not be able to access Experian DS. We have SSO set up.
Super Administrator role created a new role whose sole purpose is to Add/Modify/Delete Users. All of the responsibilities under "Security" which include: Manage users, manage user groups, etc have bee assigned to the new role. However, the new role cannot delete a user. The user "Provisioning" with the new role follows the…
@Seamus Kyle Hi Seamus, We have a requirement, where we know the Invalid Address and we want to correct the Address. For Example , We have address Hurtnkatu 2 HYVINKÄÄ FIN 05820 But actual address is: Hurtankatu 2 HYVINKÄÄ FIN 05820 So there was some Spelling mistake. Is it Possible to get teh correct Street Address when…
Is it possible to Group in Validate Step. My Goal is to get the Data Along with the Stat example I want to see how many contacts are active , inactive and Passive along with that when I click Active stats it shows me the data like the way we can do in interactive snapshot.
Hi there, On the duplicate step when we change the matching rules I wonder if two records are empty this is going to be considered an exact match? Is there a way of not considering an empty field?
Adding the 'Creation date' in the objects listing (workflows, functions, etc) would be a very useful feature.
Is there any Official Data Studio Certification?
I know we have the 'Modified' field listed on the workflows page. Is there a way to see the actual creation date for workflows?
Hi. I am looking for the communities thoughts on best practice for testing only numbers exist in alphanumeric fields (useful for number only fields where we want to include leading 0s). We are currently deciding on our standard approach. We currently use Regex as it's efficient and precise. The 'To Number' option is too…
Hi Everyone, We just upgraded to the latest version (2.13.2.35) but have been having trouble exporting to snowflake. It just gets stuck and the jobs don't even cancel. I am working with support also but checking to see if anyone has successfully been able to do so? I had issues prior to the upgrade as well. Regards, Sumit
To our valued customers, Being able to load data from external databases and cloud storage service is an integral part of Data Studio. We're most interested in getting feedback on your experience in using this feature. Your answers will allow us to shape our product to better meet your expectations. The survey should not…
Hi, I'm raising this on here as it's come up a few times with various users and I want to see what others' think of the idea to essentially combine the filter and split steps (which perform the same action, with the only difference being the split step allows users to view unfiltered results): vs I myself have found on…
We have fails under the Data 360 rule Foreign Country Code Is Not Reported rule. AS, which refers to American Samoa and MP is Northern Mariana Islands which shows as the State code. I need to confirm if the Country code should be U.S. since these are considered U.S. territories. Also, we have one for Japan (JP) that is…
Hello Aperture Data Studio customers, In our next User Group event that we hold twice a year, we’re very keen on presenting and talking about topics that you as our customers are interested in. To get an idea of what your current challenges are, or what you would like to learn more about during this event, please let us…
Submitted on behalf of a customer. Multiple active users collaborating in a Space have created many Workflows and Views etc. It is becoming difficult to quickly find the specific item that you are looking for sometimes needing to go in and out of a few things before finding the correct item. It would be good if the…
This discussion has been moved.
Hi @Danny Roden , I have 2 scenarios i wanted to run past you to get some advise, please: I have a list of ID's in a column and I want to be able to find out using a validate step (Function canvas) to see which ID's have come up in that column twice without having to use the group step 2. I have a date column with…
Summary This package contains a single function but may be updated in the future to include others. Finance Format Number 💲 Suggested by @Sharat Kutty, this function converts Negative numbers are put it in brackets so the number i.e. -100.23 becomes (100.23) and shows up as Red color. All 0 and above shows in normal color.…
Summary This package contains a couple of functions but may be updated in the future to include others. Format Number as a Percentage 🔣 This is a function, suggested by @George_Stephen and intended to be used to help create a presentation form of percentages for use on dashboards/views. The function takes a numeric input…
This post simply acts as an index for all the functions shared in this library. If you would like to receive a notification whenever a new function is added, please bookmark this post by clicking on the bookmark icon to the right of the title. Current functions available: 👪 Parse Full Name - A handy set of functions that…
Hello dear community, Aperture allows us to identify through "Associations" link between: Data set, views, workflows Is there any web-service allowing us to get such information for all spaces ( or for a specific space)? I mean : Used in , Depends on If such REST API is available it could be great and we would be able to…
Aperture is a powerful tool when validating business information you already have. We can leverage trusted address sources, like the Royal Mail’s Postal Address File, for the UK. This will ensure that the addresses and business name information you hold is accurate and deliverable as per that trusted source. That’s all…
Please introduce an if-else logic in workflow step. Currently this is being achieved with issuing fire-events and executing next workflow based on the fire event. It would be nice to control the workflow steps with if-else logic. Please let me know if there is a better way to execute if-else logic other than using fire…
If you've got requests for additional functions, domains or reference data that you'd like to see in this space please let us know. When submitting your request, please try to clearly outline what the function needs to achieve e.g. data looks like [THIS] to begin with, and the function needs to do [THIS] in order to make…
Is it Possible to get the list of the WFs in all Spaces. Through the Aperture API?
Hello, Do you have or do you have any plans to add possibility for using Genesys OAuth for creating an external system? Best regards, Katri
Hi, I would like a timestamp of when data is last loaded in ADS using the 'add dataset' capability. Furthermore, I would like this to reflect the most recent refresh date when we the data is reloaded. Is there any functionality with ADS to do this ? Thanks Jasper
Hi, Is there a way I can copy dashboards, or their underlying charts between spaces. I am creating numerous ADS Dashboards each in their own space but with the same layout. All will point to a different dataset (always structured the same). I thought about creating a master list of charts and sharing them, then just…
Hi. Is there a way to insert a new column in a file and specify what values you want that column to contain (new values that are not in the file today)? I am working with result files from tests in PCSM and need to compare them, but the files need a unique key. I just need to create a column in each with a numerical value…
Some of our workflows, when ran using difference sources (for different clients), will have different column mappings at job execution vs workflow definition. Could this be displayed as part of the Job Execution Details? We require functionality like this to report on what column mappings and parameter values have been…
It will be great to see one view shared across which all spaces and which all wfs
Hello dear community, We try to list all dataset in all spaces with their last refresh date. Our Aperture version id 2.8.8 We noticed that the rest API "datasets" allow us to get in it's json response: datasets : information of dataset in spaces columns: … tables: information of dataset (rows account, name …) batches:…
Summary This package contains a single function but may be updated in the future to include others. UK Postcode formatter 🏡 This function simply adds a space between the incode and the outcode for a given UK postcode (e.g. SW1A1AA becomes SW1A 1AA). See below for preview of the function definition logic and some sample…
Hi, I wonder if you can help me tackle this challenge. Let's say your customer has a dataset containing information about gamers. With their details and what games they like to play and such … You are a gaming platform and hold data about different games. Each game's data is stored in a separate dataset. These datasets…
Hi All, My name's Job and I've been with Experian for around 12 years. In that time I have worn many different hats, covering various areas of the business, but my current role is a Data Quality Advisor/Data Consultant, within Experian Data Quality (EDQ) The main focus of my role is to work with our existing Aperture…
Following on from @Steve's discussion (here), I wanted to share some further thoughts on this subject as it's a topic that crops up quite regularly. If I have not got permissions to hold or process PII (personally identifiable information) then I'd want an automated means of flagging whether it is present in my data…
Hi there, I was trying to create a priority on the harmonizing step to choose an email based on a score but it's not working. I checked everything to see what's wrong but couldn't find anything, can you help me? I am using the same rules on other fields for example to choose the most recent phone and address on the…
Hi there, I would like to Match Names (Forename and Surname) we addresses, but would like to exclude initials. Ideally I want to them to match unless the Forename has only one character or only a initial, is that possible? How do I set up this? The new page is looking very nice by the way 😊
Hello, I'm designing a re-usable workflow (parent = test for community), which uses another re-usable workflow (child = Dynamic Flag). The child workflow requires two inputs specified at runtime - "source A" and "source B". I want to be able to choose the values for "source A" and "source B" when dragging the parent onto…
Regarding installing releases, is there a way to easily identify the severity of each release made available? For example, if a new release came out with security features can it be easily identified whether that particular release contains an Urgent update for vulnerabilities that should be installed as soon as possible,…
Hey there! I have 6+ years in Data Quality at Experian, I'm based in Melbourne, Australia. Leading a professional services team that delivers solutions and services to our customers. Need advice or guidance on Data Quality? Just drop me a line—I'm here to help you make the most of it!
Hi All, I would like to check if it is possible to run Aperture on Kubernetes ? I understand from Documentation that it does not support Multi node clusters, but is it possible to run on a Single Node Kubernetes Cluster or can I restrict it to run in just one node ?
Whilst this is not technically a feature demonstration of Aperture Data Studio, many of our users have been asking to learn more about the recently acquired IntoZetta business and the software capabilities of the platform. The IntoZetta platform is ultimately a software solution that is targetted at supporting data…
Hello dear community, Is it possible to export (the result of a workflow) in different folders or sub-folders, in other words, workflows of the same space exporting in differents folders or sub folders Because today (my version is 2.8.8) allows my to export only in my space export folder: \Export\Production\space1…
In the Workflows, Datasets and Automations screens, users can use the Search box to filter and find the item they are looking for. When users have edited that item and closed it, the screen remembers the filter that was previously applied. This doesn't happen in the Custom Events screen - the filter is lost and the view…
A while ago Experian kindly added in an option to run individual workflows without the Fire Events being triggered. Would it be possible to add the same option for a whole Schedule of workflows? I've been asked if I can refresh a large number of workflows so we can see their results but without the emails being sent to…
End point for View is required currently we have only for datasets Exporatble objects end point only provides Space specific output, it would be helpful if we can get output for all spaces. We have 40+ spaces its very difficult to create 40+ rest files to get this.
Dataset refresh does not add a new column, when it is added in the table in source system. Manual refresh is required in that case
George_Stephen - December 11 "Please create a Administration Space that contains information of all objects in all spaces" This discussion was created from comments split from: Having an issue managing too many objects.
Many users of Aperture Data Studio use it to create, maintain and operationalise a single view of their 👧customers, 👩🎓 students, 🧔citizens, 🤒 patients, 🦹♂️ nominals, 👨🔧staff or other party data (not that kind of party 🎈). This functionality of matching data together (in both bulk scenarios to cluster records within a…
Aperture Data Studio is a powerful Data Quality and Enrichment platform that can be used for all sorts of tasks, but we also provide it with pre-built solution packages to help clients with specific use cases. This post aims to highlight the pre-built solution package we have to help monitor the quality of UK credit data…
Hi everyone 🖐️ I'm from the regional Product Management team based in Melbourne, Australia. I've been with Experian Data Quality for the past 3 years. If you are from the ANZ region and would like to chat about your use cases in Aperture Data Studio, new product ideas, or products in general, do send me a message!
Ever since Aperture Data Studio’s pre-curser, Pandora, one of our most used features and most loved features of the software has been the profiling capabilities and in recent releases this has come on even further. Data profiling is fundamentally the process of rapidly evaluating data (during a discovery phase or…
Hi everyone, My name's Danny and I'm an Aperture Data Studio product specialist at Experian. I'm based in Derby (UK) and my role at Experian about promoting growth in understanding and usage of Data Studio both within the business and outside. I work closely with key partners to explore jont ventures and new solutions, our…
We upgraded today our prod servers, and now we have the same situation, settings in find duplicates .ini file get overwritten and experianmatch start storing everything in C. we changed the Ini file settings to D drive, and after that we have to rename the duplicate store to get it stored in D drive again. we don t want to…
Hi We have 2.12.8 in Development and 2.12.1.16 in Production. We transferred few of our workflows from Production to Development when we had 2.12.1 version in Both Environment. But when we Transferred the Workflow we observed the Trend Charts is broken, we dig into more and found that the Stats based on the Trend was…
Hi - I've been working with Experian Data Quality's data management platforms for almost 10 years, and have covered a lot of bases in that time, including working on software testing, 3rd line support, and product management. Now I help mainly UK-based users to build solutions in Aperture. I'm particularly interested in…
Hello! I'm a Senior Solutions Consultant at Experian Data Quality, stationed in Sydney, Australia. With a diverse background spanning Cyber, Networking, and Data Quality, I specialize in collaborating with our clients to tailor our solutions to their needs. My primary goal is to provide expertise on our range of solutions,…
Hello, I've proudly been part of the Experian Data Quality team for over four years, leveraging over 15 years of experience in the data domain. I began as a consultant working with Aperture Data Studio to drive our clients' Data Quality initiatives. My responsibilities included overseeing full-cycle solution delivery,…
Last week we welcomed over 40 customers to our latest Data Quality User Group. Held in our London office and online the session was a chance to: hear about product updates, find out about our recent user experience research, view live demos and hear from Shawbrook Bank on how they’ve implemented Aperture Data Studio. One…
I am a Senior Consultant at Experian Data Quality and is mainly responsible to support our ANZ clients to derive the most value from Aperture Data Studio implementation. My primary focus is from delivery perspective where I work with customers to help them achieve their data quality objectives using Data Studio in order to…
New Look are a UK-based fashion retailer, operating online and in-store. With 440 stores across the UK and Republic of Ireland, and over 238 million visits to their website and app in 2022, they hold the second largest share of the womenswear market for 18-44 year olds. Customer address data plays a pivotal role in their…
Yodel is one of the UK’s largest courier companies, delivering over 190 million parcels nationwide each year. Yodel experienced unprecedented growth in demand during the Covid-19 pandemic, when the need for contactless delivery became critical. Using Experian’s Address Validation technology, Yodel were able to increase…
Find out how Bunches significantly improved their delivery rates and operational efficiencies using Experian’s Address Validation technology CHALLENGE OVERVIEW As more people celebrated special occasions at home during the pandemic, online ordering and postal delivery of flowers and gifts grew significantly. During this…
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…
Subscribe to be the first to find out!
You asked for a community forum that was easier to navigate, packed with expert content and with a clear way to share ideas for improvement! Christmas has truly come early, and you can now enjoy our new look community forum with much clearer and structured categories, including categories specifically for our Experian…
Subscribe to this category to be the first to know!
As Aperture Data Studio users, you have the ability to access eLearning for Aperture Data Studio. Here you can learn Aperture Data Studio at your own pace and at a time that suits you. It is a great way to stay on top of the latest releases and features of Aperture Data Studio, and to ensure you are using the product to…
Submitted on behalf of a customer. We have created many different validation rules to monitor the quality of different datasets over time. It would be useful to denote who is the owner of a specific rule in case changes need to be made in future.
Submitted on behalf of a customer. Sometimes users might be unaware that the data they are about to load already exists in a different Space. Rather than sharing it as a View we end up with multiple versions of the same data making it difficult to know which is the correct version to use. One idea is an administrator…
Submitted on behalf of a customer. There are tools in the workbench that are useful to analyze Find duplicates match results, but the problem we are having is when there are records matched as a Possible match within a cluster we want to manually review them and maybe allow the reviewer to set them as a definite match or…
We want to improve this community even more, which is why I'd love to set up some time with you to understand how we can best serve you. Set up a conversation with me using the link below: Book some time to talk about your experience with the community
I am the Head of Customer Experience at Experian Data Quality and work closely with our talented development teams across United Kingdom and Malaysia to provide you with this community site. If you have any feedback, good or constructive, please do reach out to me by sending me a direct message (via the community inbox -…
We’re so excited to hear your ideas to make Aperture Data Studio even better. 📌 Before you get started Search for the idea to see if it exists already – we review ideas regularly based on votes, so upvoting an existing idea and commenting with your use case is a great way to get visibility on your idea. When you’re ready…
Hi, I've worked at EDQ for almost 5 years now and been responsible for the user experience in Data Studio for the majority of that time. I now work across all of EDQs products ensuring that our customer experience is as good as it can be, both in product and in our wider customer experiences like our community. I live in…
You can easily get your data from Data Studio into Excel or Tableau using OData. OData (odata.org) is “an open protocol that allows the consumption of data via a simple and standard RESTful API”. If you choose to turn on OData in Data Studio (v2.2.3), you will be able to link your datasets (including snapshots) to any BI…
This post is to raise awareness of an additional workflow step, that is increasingly being used to provide value in many different Aperture Data Studio deployments. This step allows workflows to call a REST API in a flexible yet well-controlled manner. What do you mean additional workflow step? When you install Data…