-
Data Studio Salesforce Connection
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…
-
Use REST APIs to automate processes
Data Studio now has over 100 REST APIs that allow information to be extracted or actions taken programmatically allowing processes run automatically with little intervention. APIs also enable integration with third party applications to make Aperture part of your broader business operations. Besides the additional APIs…
-
Aperature Data Studio Elearning
Hello how do you request access to the elearning? is there a cost? We are planning to use the product to maximum degree possible. this could come in handy in our learning process, especially if it includes videos/samples for the functions within. 403 App Not Assigned Sorry, you can't access Docebo-Production because you…
-
Helpful wizard for Find duplicates rules and blocking keys
Since v 2.14 Data Studio users can now create Find duplicates rules and blocking keys by answering simple yes/no questions if you want to include email, phone number or any identifiers contained in your data. This will generate the usual scripts (which can be further edited for more advanced use cases) containing the…
-
Introducing Rulesets to Data Studio
Rulesets are a new object released in v2.14. They are collections of rules used in the Validate step to ensure consistency across the business that similar data always has the latest version of relevant rules applied. Similar to Views, Functions and other objects they can be versioned, published and shared between…
-
🎞️ Here is a short demonstration video on sharing
In this video I will show how different types of user role and license assignments have different abilities within Data Studio. I will show one way that I might share a particular view of the data to 'consumer users' that they can look at and explore but cannot save or manipulate beyond data exploration.
-
Use a View in the Map to target step
The Workflow step Map to target allows the schema (column order and column names) of a table of data to be quickly updated to match another data table’s schema. It is now possible to use a View as the ‘Target schema’ that is being mapped to, which is useful: to create a schema in Explore mode using Transform to share a…
-
Managing Data Quality issues using Issue lists
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…
-
Compare two data sources
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…
-
🛡️ Introducing...IntoZetta
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…
-
🎞️ A demonstration on data masking
Data Studio can suggest the hashing or masking of data based on a combination of data tagging and sensitive data classification. This short demonstrates this functionality
-
🎞️ Here is a short video demonstration on Training your own data tags
-
🎞 Creating roles and assigning permissions
Data Studio gives you some very fine grain control over what a given user can do within the system. Here's a short video describing role creation and assignment.
-
🎞 Creating environments
You may have noticed that some users have more than one environment in their Data Studio Installation. Here's a video showing why, and how you can have multiple environments of your own
-
🎞 A Short Feature Demo on trending your data validation results in Data Studio
-
🎞 A Short Feature Demo on data validation in Data Studio
https://bcove.video/3hw8COt
-
🎞 A Short Feature Demo on data unions and find duplicates in Data Studio
-
🎞 A Short Feature Demo on dynamic workflows in Data Studio
https://bcove.video/3ygaHTL
-
🎞 A Short Feature Demo on data views in Data Studio
https://bcove.video/3hqh0Nt
-
🎞 A Short Feature Demo on dataset management in Data Studio
-
🎞 A Short Feature Demo on Profiling in Data Studio
-
Profiling Data for the first time and changing the underlying data
This short video illustrates the ease with which you can define a dataset, profile the data to dynamically refresh via a view and then change the contents of the dataset without having to define it all over again
-
Unioning data example workflow with customer data
This workflow combines the sample data of Customer V1 and Customer V3 to demonstrate that the data from a common schema can be combined using a UNION step.4 The FILTER step reduces this to just UK data The BRANCH step sends the data in two directions, to an inline PROFILE step and to a SPLIT step. The profile, does a…
-
Changing source file schemae and data definitions
Legacy system files often come without a schema or data definition embedded in the file, and if there is one, it might not be one that you are particularly happy with. One of the capabilities of Data Studio, is the support of using a Data Definition Language (DDL) file or COB file to accompany your file upload. DDL and COB…
