We have been reading about all the ways to make our vizzes in Tableau with more creativity and appeal. During my weekly practice for creating viz as part of makeovermonday2020 community, I came across geographical data which in way required data prep. This guide is about how I used a PNG image of the country as a map background that looked better than the default using paint and excel.

我們 一直在閱讀有關使Tableau變得更具創意和吸引力的各種方法。 在我的每周實踐中，作為makeovermonday2020社區的一部分來創建Viz時，我遇到了需要準備數據的地理數據。 本指南介紹了我如何使用該國家的PNG圖像作為地圖背景，該背景看起來比使用paint和excel的默認圖像更好。

讓我們開始 (Let’s Begin)

The guide would use the data from dataworld.com but steps can be used for other dataset as well. If you would like to continue with the same dataset, you can get it here.

該指南將使用dataworld.com的數據，但步驟也可用于其他數據集。 如果您想繼續使用相同的數據集，可以在此處獲取。

準備數據 (Prep the data)

Initially, data from the source had only two fields, region and number of companies. Now for any other dataset, you might have more and even have perfect blending with Tableau inbuilt Map. However Let’s consider the case where data plotted in tableau have more nulls than you can consider.

最初，來自源的數據只有兩個字段，地區和公司數量。 現在，對于任何其他數據集，您都可以與Tableau內置Map進行更多甚至完美的融合。 但是，讓我們考慮一下表格中繪制的數據具有比您可以考慮的更多的空值的情況。

Now for plotting points on the map we need these things:

現在要在地圖上繪制點，我們需要這些東西：

1. Latitude or Y co-ordinates
   緯度或Y坐標
2. Longitudes or X co-ordinates
   經度或X坐標
3. A background Image to plot the points.
   繪制點的背景圖像。

Since the locations in the data are from Scotland, I search on google for a png image of the same.

由于數據中的位置來自蘇格蘭，因此我在Google上搜索了該圖像的png圖像。

After downloading the Image, Open it into paint.

下載圖像后，將其打開到繪畫中。

Now you have to try and map all the points in the data to the image i.e. pixels. use google map for reference. Since we do not need exact location, you can be vague and keep the location relative.

現在，您必須嘗試將數據中的所有點映射到圖像(即像素)。 使用谷歌地圖作為參考。 由于我們不需要確切的位置，因此您可能會含糊其詞，并保持位置相對。

After you are done, getting x and y coordinates for each point, add these as columns in you data.

完成后，獲取每個點的x和y坐標，將它們添加為數據中的列。

您對下載的圖片滿意嗎？ (Are you happy with the Image you downloaded?)

Since the image I downloaded was a png, It was just black map on white background which would stand oddly out from rest of my dashboard.

由于我下載的圖片是png，因此它只是白色背景上的黑色地圖，與我的儀表板其余部分格格不入。

So After I decided the color scheme of the dashboard, I used the same color as the background for this map and chose appropriate color for the landmass. You can use Paint for this.

因此，在確定儀表板的配色方案之后，我為此地圖使用了與背景相同的顏色，并為大陸選擇了合適的顏色。 您可以為此使用Paint。

If you have Photoshop and photoshopping skills, I am sure you can have better results.

如果您具有Photoshop和Photoshopping技能，我相信您可以得到更好的結果。

讓我們將其移至Tableau，好嗎 (Let’s move this to Tableau, shall we)

1. Connect your data to Tableau. Go to map>background images.
   將數據連接到Tableau。 轉到地圖>背景圖像。
2. Add your image.
   添加您的圖片。
3. Select your column X and Y as X and Y in the dialog box.
   在對話框中選擇X和Y列作為X和Y。
4. Fill out Top bottom left right as the following or in your case as respective dimensions of the image.
   如下所示或在您的情況下，分別按圖像的各個尺寸填充左上角。

5. Add X and Y to the shelves and cards.

5.在架子和卡片上添加X和Y。

Tada, Your map is ready.

多田，您的地圖已經準備好。

快速簡便嗎？ (Quick and Easy right?)

So I hope you are able to plot your data on the custom background map. If you are stuck or have some doubt, Feel free to drop a response or mail us.

因此，我希望您能夠在自定義背景圖上繪制數據。 如果您遇到困難或有任何疑問，請隨時回覆或給我們發送郵件。

Feel free to follow us for more updates.

請隨時關注我們以獲取更多更新。

Until next time.

直到下一次。