Visualizing addresses on maps isn't always easy. You often end up needing to display various metrics at the region and district level, but you don't have that information in your source data. However, if you have Czech or Slovak ZIP codes in your data, you can easily convert them to districts and regions using a free tool I've prepared for you.
On my GitHub, you'll find a CSV file containing a mapping of Czech (and most Slovak) postal codes to their corresponding districts and regions. You can use this file to easily join with your data, whether in a database, Power BI, or even Excel.
How to use the table in Power BI and Excel
The easiest way is to use Power Query, which allows you to load the CSV file and merge it with your data into a single table. Prepare a column containing the country code (CZ or SK) and the ZIP code separated by a hyphen (e.g., CZ-11150).
Then, in Power Query, load the CSV file from GitHub (or your local drive) and join it to your data using the country_zip column. The other columns are:
- county - district name
- region - region name
Tip: If you want to work with the values in Power BI map visuals, don't forget to set the data category of the
countyandregioncolumns to the geographic type (County, State or Province) and choose the corresponding level.
