Skip to main content

Multi-Source Charts

Merge Data from Multiple Data Sources

Combining data from multiple data sources is one of the most common challenges for business analysts. The disparate data stores are often a collection of integrated or non-integrated data management systems with heterogeneous schemas and query languages.

For example, an insurance company stores sales targets and actual sales data in the same system but separate databases, validating sales performance requires mapping between the two datasets. Hospital Management Systems (HIS) and Claims Management Systems (CMS) store patient information and the insurance claims separately. Extracting and visualizing meaningful information from such systems requires merging the datasets.

Combining data using custom SQL queries and Excel is a time-consuming process. New Wyn Multi-Charts allows technical and non-technical users to quickly and easily build visualizations using multiple datasets.

Wyn Enterprise Multi-Source Charts removes all data combining hazels and eliminates the need to do some work outside of the BI tool to be ready with an analytical chart.

Here, we'll discuss the new and advanced Multi-Source Chart type and the configurations it provides.

Multiple links map the data separately and are not joined together.

In the previous example, the links map the data using an SQL query:

Select * from TargetSales 
INNER JOIN ActualSales
ON TargetSales.SalesRepresentative = ActualSales.SalesRepresentative

OR

Select * from TargetSales 
INNER JOIN ActualSales
ON TargetSales.Quarter = ActualSales.Quarter

rather on both data fields together like in SQL query below: 

Select * from TargetSales 
INNER JOIN ActualSales
ON 
( TargetSales.SalesRepresentative = ActualSales.SalesRepresentative 
AND 
TargetSales.Quarter= ActualSales.Quarter )
Multi-Source Charts Specific Configurations and Settings
Understand the Story Behind Your Data

Wyn is a web-based BI and data analytics platform that provides greater insight into your data.

Wyn offers built-in tools for report and dashboard creation, data governance, security integration, embedded BI, automated document distribution, and a business-user-friendly interface for self-service business intelligence.

About the author

Paarisha Rana

As a software engineer, Paarisha enjoys GrapeCity's environment of encouragement and learning. She enjoys reading, aerobics, travelling, and exploring historical places. Paarisha graduated from Uttar Pradesh Technical University (UPTU) at Lucknow (India) with a Bachelor's of Technology in Information Technology, and you can find her on LinkedIn.
Back to top