Integrating corporate data with DataMarket data
Qlik DataMarket data can be integrated with your corporate data to provide a broader context for that data and yield greater insights into your markets.
DataMarket data comes from a variety of sources, and as a result, associations with your data may not always be immediately evident. You might find that a number of associations have to be edited in the data preparation step. For example, you might find it valuable to evaluate certain characteristics of the countries you operate in. But fields for countries in some DataMarket data sets might not have enough values in common with your corporate data to make the association useful. That is why you must carefully assess the associations between your data and DataMarket data.
The following illustrations demonstrate how to integrate corporate and DataMarket data and create meaningful Qlik Sense visualizations.
Compare sales to Gross Domestic Product (
When you are doing business in a country or considering entering a country's market, there are a number of indicators that can help you determine if your company's performance aligns as you expect with the demographic and economic environment in that country.
The corporate data in this illustration enables sales data to be aggregated by country. A bar chart compares the sales by country. That can provide insight into how your company is doing across all its markets.
To see how you are doing within each country, you could compare your company's sales to country data that indicates how strong the market is. For example, you could compare sales in each country with the country's Gross Domestic Product (
Qlik DataMarket contains a data set in the
Assuming there is a good association between the country fields in the corporate and DataMarket data, you can add
Show sales in euros
When reviewing sales data, a common visualization is a
When selecting the
Create alternative measures for sales
With DataMarket currency data, you can add a further enhancement to the sales bar chart. The chart compares sales to per capita
This is where it is important that the