This is a list of cities with relevent states and countries which can be used as web data source in power bi and excel for practice.
| City | State/Province | Country |
|---|---|---|
| New York | NY | USA |
| Los Angeles | CA | USA |
| Toronto | ON | Canada |
| London | England | UK |
| Sydney | NSW | Australia |
| Paris | Ile-de-France | France |
| Berlin | Berlin | Germany |
| Edinburgh | Scotland | UK |
| Tokyo | Tokyo | Japan |
| Rome | Lazio | Italy |
| Madrid | Community of Madrid | Spain |
| Dublin | Leinster | Ireland |
| Dubai | Dubai | UAE |
| Cape Town | Western Cape | South Africa |
| Stockholm | Stockholm | Sweden |
| Oslo | Oslo | Norway |
| Copenhagen | Capital Region | Denmark |
| Amsterdam | North Holland | Netherlands |