Data blending made easy
iDashboards Data Integrator (iDI)
Consolidate and blend data from multiple locations in diverse formats, and transform it into a useful data set. With iDashboards’ Data Integrator (iDI), you can easily mix and match your data sources using simple, drag-and-drop tools – no programming or coding required.
Become a data blending master
Connecting to data is one thing, but blending it is where iDI truly excels. You can blend data from different sources or formats like Excel, Access, database servers, text files, web services and more. But it doesn’t end there – you have access to dozens of tools to prep data for consumption. Some of the most popular functions include:
- Cleanse: Replaces missing or unwanted values with new content
- Aggregate: Analyzes the data set to find min, max, count, mean, sum, and more
- DeDup: Finds and filters out duplicates based on given criteria
- Transform: Creates new columns and performs calculations from existing ones
- Transpose: Flattens a data set; creates a new column for unique values in a chosen column
- Reverse Transpose: Regroups data from multiple columns to a single column with multiple rows
- Merge: Joins two or more inputs into a single output based on matching criteria
- Share: Save jobs to the Common Jobs folder and everyone can collaborate
No programming Repeatable results.
When we said “no programming”, we meant it – even when it comes to the data automation process. Once the data is configured, you can schedule that workflow to continuously run as often as every 15 minutes without the need for manual intervention.
We understand your data isn’t pretty, but our charts are! Not only can you prepare your data by aggregating, filtering, formatting and extracting new dimensions, but you can also report on it. Sharing PDF, Excel and HTML reports has never been easier!