I have knowledge in QLik/Sense, Big Query, Google Data Studio ( and related )
I need to create a map with multiple points and each point will display data from the database (point related)
The table will look for example like this:
+------------+---------------------------+-----------+---------+-------+
| Store Name | Store Location (Long/Lat) | Product | Ordered | Sold |
+============+===========================+===========+=========+=======+
| Store 1 | XXX,XXX | Product 1 | True | False |
+------------+---------------------------+-----------+---------+-------+
| Store 2 | YYY,YYY | Product 1 | True | True |
+------------+---------------------------+-----------+---------+-------+
| Store 2 | YYY,YYY | Product 2 | False | True |
+------------+---------------------------+-----------+---------+-------+
So when you hove over with mouse on the map at store "Store 2", You will see pop up box with only:
+------------+----------+-----------+
| Product 1 | True | True |
+------------+----------+-----------+
| Product 2 | False | True |
+------------+----------+-----------+
And Store 1:
+------------+----------+-----------+
| Product 1 | True | False |
+------------+----------+-----------+
I have tried:
- Google Data studio (limit one dimension for example store name and that it)
- Qlik Limit to 1 dimension
- Google maps, better but I can display only 1 product, not a list of products
Any suggestions, what can be used?
In my opinion in Qliksense it is easiest.
First just load Store and Product table and create simple data model:
Then add new chart (Map) and set location fields:
Add new calculated dimension:
and that's all. Ready:
As a workaround - you can consider doing some extra work before visualizing your data like in an example below (BigQuery Standard SQL)
If you run above in BigQuery Geo Viz Tool - you will get something like below
To “spice” the visualization a little, you can add some extras:
So, the result will be little bit better formatted (as in below pic)
You might be able to adopt this “technic” unless you will find the tool that handles all your needs on its own
Meantime, have in mind that different tools will treat such workaround in a different way – for example, if you run above two scripts within Goliath – you will have respectively:
and
Also, in Goliath, Geo Visualization is in-built feature, so you can interactively build geo visualizations with multiple layers and combining results from multiple queries, etc. without leaving BigQuery Tool
Disclosure: I am an author, product owner and am leading development of Potens.io Suite of Tools (which Goliath is a part of) - which is also clearly stated in my SO profile