适用对象:夏令营学员 维护:喜乐君(Tableau Visionary Hall of Fame) 配套文档: 《Tableau 免费版下载指 南》《Tableau 安装与数据连接指南》
为什么课前要准备数据
Tableau 是"用数据讲故事"的工具,上手的关键不是看教程,而是亲手把数据拖进画布、做出第一张图。如果等到上课才装软件、才找数据,时间都会耗在安装和环境问题上。
这份课前准备帮你做两件事:
- 把软件和数据在开课前就位,上课直接做图;
- 用一份已经整理好的中文样例数据完成暖身练习,带着成果来上课。
一、课前准备清单(开课前完成)
- 装好 Tableau:按《下载指南》选 Public 或 Free 版,约 10 分钟完成安装与注册。
- 下载本课样例数据:
china_airports.csv(见文末「下载区」)。 - 完成课前暖身练习:按第三节步骤,画出一张中国机场分布图。
- (选做)浏览数据集推荐:从第四节挑一个自己感兴趣的方向,上课更有目标。
二、本课提供的样例数据:中国机场经纬度
地理地图是 Tableau 的招牌功能,但中国地图经常卡在「地名识别」和「坐标系」上。这份文件已经为你把中文机场名 + WGS-84 经纬度整理好,开箱即用,无需任何清洗。
字段说明
- 机场ID:OpenFlights 全球机场唯一编号
- 机场中文名称:用于地图标签显示
- 机场英文名称:原始数据英文标识
- 城市:机场所在城市
- IATA代码:三字码(如
PEK=北京首都),可用于关联其他航空数据 - 纬度 / 经度:WGS-84 坐标系,Tableau 可直接识别为地理角色
数据规模与质量
- 235 个中国机场(含港澳台)
- CSV 格式、UTF-8 编码、约 20KB
- 已验证:无空行、无异常坐标,可直接连接
它适合练什么
- 中国机场分布符号地图(最基础、5 分钟出图)
- 按城市着色,观察枢纽城市密度
- 作为「维度表」,后续自行从 OpenFlights 扩展航线数据做空间分析
三、课前暖身练习:5 分钟画出中国机场地图
跟着做,开课前就能产出第一张图:
- 启动 Tableau → 左侧「连接」→「文本文件」→ 选择
china_airports.csv。 - 在数据源页面确认字段无误,尤其「纬度」「经度」被识别为数字类型。
- 新建工作表 → 把经度拖到「列」、纬度拖到「行」(Tableau 会自动识别为经纬度)。
- 把机场中文名称拖到「标记」卡的「标签」,把城市拖到「颜色」。
- 一张中国机场分布图就出现了 —— 带着它来上课。
排错提示:如果画布显示成世界地图而非中国局部,右键「纬度 / 经度」字段 → 确认「地理角色」已被正确识别。
四、更多中文数据集推荐(按学习场景)
Tableau 官方 42 个样例几乎全是英文、欧美场景。下面这些中文、免费、且符合关系型规范的数据源,更适合中国用户入门。每个都附一句话定位和获取地址。
- 入门首选 · Tableau 示例-超市
- 官方自带中文零售数据,含订单 / 退货 / 用户 3 张关联表,是学「表关联」的最佳起点。
- 获取:Tableau 左侧「已保存的数据源」→
Sample - Superstore(中文版),无需下载。 - 宏观经济 · 国家统计局「国家数据」
- 最权威的中文官方数据源,GDP、人口、CPI 等可按「指标 × 时间 × 地区」导出 CSV / Excel,天然适合多表关联。
- 地址: https://data.stats.gov.cn/
- 电商分析 · 阿里云天池 淘宝用户行为
- 百万级用户行为数据(点击 / 收藏 / 加购 / 购买),适合漏斗分析与用户画像,需注册阿里云账号。
- 地址: https://tianchi.aliyun.com/dataset/649
- 金融量化 · 中国股票日线 / AKShare
- Kaggle 上有 1990–2024 沪深上市公司日线数据(Apache 2.0 许可);也可用开源库 AKShare 自助导出 A 股数据。
- Kaggle: https://www.kaggle.com/datasets/eren2222/chinese-daily-historical-stock-market-1990-2024
- AKShare: https://github.com/akfamily/akshare
- 地理空间 · 中国行政区划 GeoJSON
- 免费、每日更新的省 / 市 / 区县 / 街道五级边界(WGS-84),用于 Tableau 填充地图(Choropleth)。
- 地址: https://geojson.hxkj.vip/
- 通用练习 · 和鲸社区
- 中文版「Kaggle」,国内可直接访问,含天气、疫情、招聘等大量中文数据集与在线 Notebook。
- 地址: https://www.heywhale.com/datasets
- 进阶航空 · OpenFlights 全球机场 / 航线
- 开源航班数据库,可下载全球机场与航线数据,结合本课机场样例做航线空间分析。
- 地址: https://openflights.org/
五、课前常见问题(FAQ)
- Q:Public Edition 和 Free Edition 选哪个?
。详见 《下载指南》
- Q:为什么强调 WGS-84 坐标系?
A:Tableau 地图使用 WGS-84(GPS 标准)。本课样例与 GeoJSON 数据源均为 WGS-84,可直接使用;高德 / 百度数据需先转换坐标系再导入。
- Q:样例 CSV 打不开或乱码?
A:用 Excel 或 Tableau 直接打开即可;若遇编码问题,确认以 UTF-8 读取(本课文件已是 UTF-8 中文)。
- Q:Kaggle 打不开怎么办?
A:国内可改用阿里云天池、和鲸社区等替代源,无需科学上网。
六、课程学习路径(预览)
基于以上数据源,课程后续会按如下节奏推进,课前心里有数即可:
- 第一周 · 入门:Tableau 示例-超市 —— 连接数据、建立表关联、销售额 / 利润柱状图、地理地图。
- 第二周 · 宏观:国家统计局数据 + 行政区划地图 —— 数据并集 / 混合 / 关联、中国 GDP 热力图、时间序列预测。
- 第三周 · 真实数据:电商 / 股票 / 航线空间分析 —— 漏斗分析、K 线图、双轴航线地图、发布到 Tableau Public。
七、📥 下载区
样例数据:`china_airports.csv` —— 235 个中国机场经纬度(含中文名称、城市、IATA、纬度、经度),CSV / UTF-8。
用途:课前暖身练习、地图可视化、后续航线分析的基础维度表。
获取方式(任选其一):
- 方式一:复制下方完整数据,保存为
china_airports.csv(推荐,离线可用) - 方式二:在课程资料包 / 课程群中下载同名文件
机场ID,机场中文名称,机场英文名称,城市,IATA代码,纬度,经度
3364,北京首都国际机场,Beijing Capital International Airport,Beijing,PEK,40.080101013183594,116.58499908447266
3366,海拉尔东山机场,Dongshan Airport,Hailar,HLD,49.2050018311,119.824996948
3368,天津滨海国际机场,Tianjin Binhai International Airport,Tianjin,TSN,39.124401092499994,117.346000671
3369,太原武宿机场,Taiyuan Wusu Airport,Taiyuan,TYN,37.74689865112305,112.62799835205078
3370,广州白云国际机场,Guangzhou Baiyun International Airport,Guangzhou,CAN,23.39240074157715,113.29900360107422
3371,长沙黄花国际机场,Changsha Huanghua International Airport,Changcha,CSX,28.189199447599997,113.220001221
3372,桂林两江国际机场,Guilin Liangjiang International Airport,Guilin,KWL,25.21809959411621,110.03900146484375
3373,南宁吴圩机场,Nanning Wuxu Airport,Nanning,NNG,22.608299255371094,108.1719970703125
3374,深圳宝安国际机场,Shenzhen Bao'an International Airport,Shenzhen,SZX,22.639299392700195,113.81099700927734
3375,郑州新郑国际机场,Zhengzhou Xinzheng International Airport,Zhengzhou,CGO,34.519699096699995,113.841003418
3376,武汉天河国际机场,Wuhan Tianhe International Airport,Wuhan,WUH,30.7838,114.208
3378,兰州中川机场,Lanzhou Zhongchuan Airport,Lanzhou,LHW,36.5152015686,103.620002747
3379,西安咸阳国际机场,Xi'an Xianyang International Airport,Xi'an,XIY,34.447102,108.751999
3381,西双版纳嘎洒机场,Xishuangbanna Gasa Airport,Jinghonggasa,JHG,21.973899841308594,100.76000213623047
3382,昆明长水国际机场,Kunming Changshui International Airport,Kunming,KMG,25.1019444,102.9291667
3383,厦门高崎国际机场,Xiamen Gaoqi International Airport,Xiamen,XMN,24.54400062561035,118.12799835205078
3384,南昌昌北国际机场,Nanchang Changbei International Airport,Nanchang,KHN,28.864999771118164,115.9000015258789
3385,福州长乐国际机场,Fuzhou Changle International Airport,Fuzhou,FOC,25.935100555419922,119.66300201416016
3386,杭州萧山国际机场,Hangzhou Xiaoshan International Airport,Hangzhou,HGH,30.22949981689453,120.43399810791016
3387,宁波栎社国际机场,Ningbo Lishe International Airport,Ninbo,NGB,29.82670021057129,121.46199798583984
3388,南京禄口国际机场,Nanjing Lukou Airport,Nanjing,NKG,31.742000579833984,118.86199951171875
3389,合肥骆岗国际机场,Hefei Luogang International Airport,Hefei,HFE,31.780000686645508,117.2979965209961
3390,青岛流亭机场,Liuting Airport,Qingdao,TAO,36.2661018372,120.374000549
3391,上海虹桥国际机场,Shanghai Hongqiao International Airport,Shanghai,SHA,31.197900772094727,121.33599853515625
3392,烟台莱山机场,Yantai Laishan Airport,Yantai,YNT,37.40169906616211,121.37200164794922
3393,重庆江北国际机场,Chongqing Jiangbei International Airport,Chongqing,CKG,29.719200134277344,106.64199829101562
3394,贵阳龙洞堡机场,Longdongbao Airport,Guiyang,KWE,26.53849983215332,106.8010025024414
3395,成都双流国际机场,Chengdu Shuangliu International Airport,Chengdu,CTU,30.578500747680664,103.9469985961914
3396,西昌青山机场,Xichang Qingshan Airport,Xichang,XIC,27.989099502563477,102.18399810791016
3397,喀什机场,Kashgar Airport,Kashi,KHG,39.5429000854,76.0199966431
3398,和田机场,Hotan Airport,Hotan,HTN,37.03850173950195,79.86489868164062
3399,乌鲁木齐地窝堡国际机场,Ürümqi Diwopu International Airport,Urumqi,URC,43.907100677490234,87.47419738769531
3400,哈尔滨太平机场,Taiping Airport,Harbin,HRB,45.6234016418457,126.25
3402,牡丹江海浪国际机场,Mudanjiang Hailang International Airport,Mudanjiang,MDG,44.5241012573,129.569000244
3404,大连周水子机场,Zhoushuizi Airport,Dalian,DLC,38.9656982421875,121.53900146484375
3406,上海浦东国际机场,Shanghai Pudong International Airport,Shanghai,PVG,31.143400192260742,121.80500030517578
4030,三亚凤凰国际机场,Sanya Phoenix International Airport,Sanya,SYX,18.302900314331055,109.41200256347656
4033,丽江机场,Lijiang Airport,Lijiang,LJG,26.6800003052,100.246002197
4054,大理机场,Dali Airport,Dali,DLU,25.649401,100.319
4097,拉萨贡嘎机场,Lhasa Gonggar Airport,Lhasa,LXA,29.2978000641,90.91190338130001
4108,济南遥墙机场,Yaoqiang Airport,Jinan,TNA,36.857200622558594,117.21600341796875
4109,常州奔牛机场,Changzhou Benniu Airport,Changzhou,CZX,31.919701,119.778999
4110,宜宾菜坝机场,Yibin Caiba Airport,Yibin,YBP,28.8005555556,104.545
4120,海口美兰国际机场,Haikou Meilan International Airport,Haikou,HAK,19.934900283813477,110.45899963378906
4144,沈阳桃仙机场,Taoxian Airport,Shenyang,SHE,41.639801025390625,123.48300170898438
4145,东营胜利机场,Dongying Shengli Airport,Dongying,DOY,37.5085983276,118.788002014
4148,洛阳机场,Luoyang Airport,Luoyang,LYA,34.741100311299995,112.388000488
4149,徐州观音机场,Xuzhou Guanyin Airport,Xuzhou,XUZ,34.059056,117.555278
4301,九寨沟黄龙机场,Jiuzhai Huanglong Airport,Jiuzhaigou,JZH,32.8533333333,103.682222222
4302,揭阳潮汕国际机场,Jieyang Chaoshan International Airport,Shantou,SWA,23.552,116.5033
4308,敦煌机场,Dunhuang Airport,Dunhuang,DNH,40.16109848022461,94.80919647216797
4380,长春龙嘉机场,Longjia Airport,Changchun,CGQ,43.9962005615,125.684997559
6341,北京南苑机场,Beijing Nanyuan Airport,Beijing,NAY,39.782798767089844,116.38800048828125
6342,赤峰机场,Chifeng Airport,Chifeng,CIF,42.23500061035156,118.90799713134766
6343,长治机场,Changzhi Airport,Changzhi,CIH,36.247501,113.125999
6344,大同机场,Datong Airport,Datong,DAT,40.060299,113.482002
6345,呼和浩特白塔国际机场,Baita International Airport,Hohhot,HET,40.851398,111.823997
6346,包头机场,Baotou Airport,Baotou,BAV,40.560001373291016,109.99700164794922
6347,石家庄正定国际机场,Shijiazhuang Daguocun International Airport,Shijiazhuang,SJW,38.28070068359375,114.6969985961914
6348,通辽机场,Tongliao Airport,Tongliao,TGO,43.556702,122.199997
6349,乌兰浩特机场,Ulanhot Airport,Ulanhot,HLH,46.195333,122.008333
6350,锡林浩特机场,Xilinhot Airport,Xilinhot,XIL,43.91559982299805,115.96399688720703
6351,北海机场,Beihai Airport,Beihai,BHY,21.5394,109.293999
6352,常德机场,Changde Airport,Changde,CGD,28.9188995361,111.63999939
6353,张家界荷花机场,Dayong Airport,Dayong,DYG,29.1028,110.443001
6354,梅县机场,Meixian Airport,Meixian,MXZ,24.350000381469727,116.13300323486328
6355,珠海金湾机场,Zhuhai Jinwan Airport,Zhuhai,ZUH,22.006399,113.375999
6356,柳州白莲机场,Liuzhou Bailian Airport,Liuzhou,LZH,24.2075,109.390999
6357,湛江机场,Zhanjiang Airport,Zhanjiang,ZHA,21.214399,110.358002
6358,恩施机场,Enshi Airport,Enshi,ENH,30.3202991486,109.48500061
6359,南阳姜营机场,Nanyang Jiangying Airport,Nanyang,NNY,32.980801,112.614998
6360,襄阳刘集机场,Xiangyang Liuji Airport,Xiangfan,XFN,32.1506,112.291
6361,宜昌三峡机场,Yichang Sanxia Airport,Yichang,YIH,30.55655,111.479988
6362,安康五里铺机场,Ankang Wulipu Airport,Ankang,AKA,32.708099,108.931
6363,格尔木机场,Golmud Airport,Golmud,GOQ,36.4006,94.786102
6364,汉中城固机场,Hanzhong Chenggu Airport,Hanzhong,HZG,33.134136,107.206014
6365,庆阳机场,Qingyang Airport,Qingyang,IQN,35.799702,107.602997
6366,西宁曹家堡机场,Xining Caojiabu Airport,Xining,XNN,36.5275,102.042999
6367,延安二十里铺机场,Yan'an Ershilipu Airport,Yan'an,ENY,36.636902,109.554001
6368,榆林榆阳机场,Yulin Yuyang Airport,Yulin,UYN,38.35971,109.590927
6375,迪庆香格里拉机场,Diqing Airport,Shangri-La,DIG,27.7936,99.6772
6376,芒市机场,Mangshi Airport,Luxi,LUM,24.4011,98.5317
6377,普洱思茅机场,Pu'er Simao Airport,Simao,SYM,22.793301,100.959
6378,昭通机场,Zhaotong Airport,Zhaotong,ZAT,27.325599670410156,103.75499725341797
6379,赣州机场,Ganzhou Airport,Ganzhou,KOW,25.853333,114.778889
6380,景德镇机场,Jingdezhen Airport,Jingdezhen,JDZ,29.3386001587,117.176002502
6381,九江庐山机场,Jiujiang Lushan Airport,Jiujiang,JIU,29.476944,115.801111
6382,衢州机场,Quzhou Airport,Quzhou,JUZ,28.965799,118.899002
6383,连云港机场,Lianyungang Airport,Lianyungang,LYG,34.571667,118.873611
6384,台州路桥机场,Huangyan Luqiao Airport,Huangyan,HYN,28.56220054626465,121.42900085449219
6385,临沂沭埠岭机场,Shubuling Airport,Linyi,LYI,35.04610061645508,118.41200256347656
6386,泉州晋江国际机场,Quanzhou Jinjiang International Airport,Quanzhou,JJN,24.7964,118.589996
6387,黄山屯溪国际机场,Tunxi International Airport,Huangshan,TXN,29.733299255371094,118.25599670410156
6388,潍坊机场,Weifang Airport,Weifang,WEF,36.646702,119.119003
6389,威海机场,Weihai Airport,Weihai,WEH,37.18709945678711,122.22899627685547
6390,苏南硕放国际机场,Sunan Shuofang International Airport,Wuxi,WUX,31.494400024399997,120.429000854
6391,武夷山机场,Nanping Wuyishan Airport,Wuyishan,WUS,27.7019,118.000999
6392,温州龙湾国际机场,Wenzhou Longwan International Airport,Wenzhou,WNZ,27.912201,120.851997
6393,盐城机场,Yancheng Airport,Yancheng,YNZ,33.425833,120.203056
6394,义乌机场,Yiwu Airport,Yiwu,YIW,29.3446998596,120.031997681
6395,舟山机场,Zhoushan Airport,Zhoushan,HSN,29.9342002869,122.361999512
6396,昌都邦达机场,Qamdo Bangda Airport,Bangda,BPX,30.553600311279297,97.1082992553711
6397,达州河市机场,Dachuan Airport,Dazhou,DAX,31.1302,107.4295
6398,广元机场,Guangyuan Airport,Guangyuan,GYS,32.3911018371582,105.7020034790039
6399,泸州机场,Luzhou Airport,Luzhou,LZO,28.85219955444336,105.39299774169922
6400,绵阳机场,Mianyang Airport,Mianyang,MIG,31.4281005859375,104.74099731445312
6401,南充机场,Nanchong Airport,Nanchong,NAO,30.79545,106.1626
6402,林芝米林机场,Nyingchi Airport,Nyingchi,LZY,29.303300857543945,94.33529663085938
6403,万州五桥机场,Wanxian Airport,Wanxian,WXN,30.8017,108.433
6404,阿克苏机场,Aksu Airport,Aksu,AKU,41.262501,80.291702
6405,且末玉都机场,Qiemo Yudu Airport,Qiemo,IQM,38.233611,85.465556
6406,库车机场,Kuqa Airport,Kuqa,KCA,41.677856,82.872917
6407,库尔勒机场,Korla Airport,Korla,KRL,41.69779968261719,86.12889862060547
6408,克拉玛依机场,Karamay Airport,Karamay,KRY,45.46655,84.9527
6409,伊宁机场,Yining Airport,Yining,YIN,43.955799,81.330299
6410,黑河机场,Heihe Airport,Heihe,HEK,50.1716209371,127.308883667
6411,佳木斯机场,Jiamusi Airport,Jiamusi,JMU,46.84339904789999,130.464996338
6412,锦州机场,Jinzhou Airport,Jinzhou,JNZ,41.10139846801758,121.06199645996094
6413,齐齐哈尔三家子机场,Qiqihar Sanjiazi Airport,Qiqihar,NDG,47.239601135253906,123.91799926757812
6414,延吉朝阳川机场,Yanji Chaoyangchuan Airport,Yanji,YNJ,42.8828010559,129.451004028
6427,安庆天柱山机场,Anqing Tianzhushan Airport,Anqing,AQG,30.582199,117.050003
6429,山海关机场,Shanhaiguan Airport,Qinhuangdao,SHP,39.968102,119.731003
6430,运城关公机场,Yuncheng Guangong Airport,Yuncheng,YCU,35.116391,111.031388889
6432,嘉峪关机场,Jiayuguan Airport,Jiayuguan,JGN,39.856899,98.3414
6433,丹东机场,Dandong Airport,Dandong,DDG,40.0247,124.286003
6434,鄂尔多斯伊金霍洛机场,Ordos Ejin Horo Airport,Dongsheng,DSN,39.49,109.861388889
6435,攀枝花保安营机场,Bao'anying Airport,Panzhihua,PZI,26.54,101.79852
6743,哈密机场,Hami Airport,Hami,HMI,42.8414,93.669197
6744,梧州长洲岛机场,Wuzhou Changzhoudao Airport,Wuzhou,WUZ,23.456699,111.248001
6752,塔城机场,Tacheng Airport,Tacheng,TCG,46.67250061035156,83.3407974243164
6772,朝阳机场,Chaoyang Airport,Chaoyang,CHG,41.538101,120.434998
6943,漠河古莲机场,Gu-Lian Airport,Mohe County,OHE,52.912777777799995,122.43
6944,济宁曲阜机场,Jining Qufu Airport,Jining,JNG,35.292778,116.346667
6946,阿勒泰机场,Altay Air Base,Altay,AAT,47.7498855591,88.08580780030002
6954,满洲里西郊机场,Manzhouli Xijiao Airport,Manzhouli,NZH,49.566667,117.33
6955,乌海机场,Wuhai Airport,Wuhai,WUA,39.7934,106.7993
6963,铜仁凤凰机场,Tongren Fenghuang Airport,Tongren,TEN,27.883333,109.308889
6964,吉安井冈山机场,Jinggangshan Airport,Jian,JGS,26.856899261499997,114.736999512
7052,西安西关机场,Xi'an Xiguan Airport,Xi\'AN,SIA,34.376701,109.120003
7457,佛山沙堤机场,Foshan Shadi Airport,Foshan,FUO,23.083299636799996,113.069999695
7458,惠州机场,Huizhou Airport,Huizhou,HUZ,23.0499992371,114.599998474
7503,阜阳西关机场,Fuyang Xiguan Airport,Fuyang,FUG,32.882157,115.734364
7504,龙岩冠豸山机场,Longyan Guanzhishan Airport,Longyan,LCX,25.6746997833,116.747001648
7505,保山云端机场,Baoshan Yunduan Airport,Baoshan,BSD,25.053301,99.168297
7506,兴义机场,Xingyi Airport,Xingyi,ACX,25.0863888889,104.959444444
7508,黎平机场,Liping Airport,Liping,HZH,26.32217,109.1499
7519,怀化芷江机场,Zhijiang Airport,Zhijiang,HJJ,27.4411111111,109.7
7527,临沧机场,Lintsang Airfield,Lincang,LNJ,23.738100051900002,100.025001526
7862,腾冲驼峰机场,Tengchong Tuofeng Airport,Tengchong,TCZ,24.9380555556,98.48583333330001
7894,玉树巴塘机场,Yushu Batang Airport,Yushu,YUS,32.836388888900004,97.0363888889
7898,淮安涟水机场,Lianshui Airport,Huai An,HIA,33.7908333333,119.125
7932,阿里昆莎机场,Ngari Gunsa Airport,Shiquanhe,NGQ,32.1,80.0530555556
8043,中卫沙坡头机场,Zhongwei Shapotou Airport,Zhongwei,ZHY,37.573125,105.154454
8082,百色右江机场,Baise Youjiang Airport,Baise,AEB,23.7206001282,106.959999084
8233,喀纳斯机场,Kanas Airport,Burqin,KJI,48.2223,86.9959
8407,邯郸机场,Handan Airport,Handan,HDG,36.5258333333,114.425555556
8417,鸡西兴凯湖机场,Jixi Xingkaihu Airport,Jixi,JXA,45.293,131.193
8442,日喀则和平机场,Shigatse Air Base,Shigatse,RKZ,29.3519,89.311401
8630,巴彦淖尔天吉泰机场,Bayannur Tianjitai Airport,Bayannur,RLK,40.926,107.7428
8781,黔江武陵山机场,Qianjiang Wulingshan Airport,Qianjiang,JIQ,29.5133333333,108.831111111
8826,长白山机场,Changbaishan Airport,Baishan,NBS,42.066944,127.602222
8845,永州零陵机场,Lingling Airport,Yongzhou,LLF,26.338661,111.610043
8876,扬州泰州机场,Yangzhou Taizhou Airport,Yangzhou,YTY,32.5634,119.7198
8889,天水麦积山机场,Tianshui Maijishan Airport,Tianshui,THQ,34.5593986511,105.86000061
8921,康定机场,Kangding Airport,Kangding,KGT,30.1575,101.734722
8926,吐鲁番交河机场,Turpan Jiaohe Airport,Turpan,TLQ,43.0308,89.0987
8971,固原六盘山机场,Guyuan Liupanshan Airport,Guyuan,GYU,36.0788888889,106.216944444
8974,长海机场,Changhai Airport,Changhai,CNI,39.2666666667,122.666944444
8979,加格达奇机场,Jiagedaqi Airport,Jiagedaqi District,JGD,50.371389,124.1175
9025,毕节飞雄机场,Bijie Feixiong Airport,Bijie,BFJ,27.267066,105.472097
9107,宜春明月山机场,Yichun Mingyueshan Airport,Yichun,YIC,27.8025,114.3062
9308,吕梁机场,Lüliang Airport,Lvliang,LLV,37.683333,111.142778
9310,稻城亚丁机场,Daocheng Yading Airport,Daocheng,DCY,29.323056,100.053333
9311,甘南夏河机场,Gannan Xiahe Airport,Xiahe city,GXH,34.8105,102.6447
9386,新源那拉提机场,Xinyuan Nalati Airport,Xinyuan,NLT,43.4318,83.3786
9770,张掖甘州机场,Zhangye Ganzhou Airport,Zhangye,YZY,38.8018989563,100.675003052
9843,池州九华山机场,Jiuhuashan Airport,Chizhou,JUH,30.7403,117.6856
9844,鞍山腾鳌机场,Anshan Air Base,Anshan,AOG,41.105301,122.853996
9845,大庆萨尔图机场,Saertu Airport,Daqing,DQA,46.7463888889,125.140555556
9846,遵义新舟机场,Zunyi Xinzhou Airport,Zunyi,ZYI,27.5895,107.0007
9848,伊春林都机场,Lindu Airport,Yinchun,LDS,47.7520555556,129.019125
9849,安顺黄果树机场,Anshun Huangguoshu Airport,Anshun,AVA,26.2605555556,105.873333333
9854,通化三源浦机场,Tonghua Sanyuanpu Airport,Tonghua,TNH,42.2538888889,125.703333333
9857,苏州光福机场,Suzhou Guangfu Airport,Suzhou,SZV,31.2631,120.401001
10160,二连浩特赛乌苏国际机场,Erenhot Saiwusu International Airport,Erenhot,ERL,43.4225,112.096667
10209,北京大兴国际机场,Beijing Daxing International Airport,Beijing,PKX,39.509945,116.41092
10363,河池金城江机场,Hechi Jinchengjiang Airport,Hechi,HCJ,24.805,107.6997
10800,抚远东极机场,Dongji Aiport,Fuyuan,FYJ,48.199494,134.366447
10937,六盘水月照机场,Liupanshui Yuezhao Airport,Liupanshui,LPF,26.609417,104.979
10938,凯里黄平机场,Kaili Airport,Kaili,KJH,26.972,107.988
10939,神农架红坪机场,Shennongjia Hongping Airport,Shennongjia,HPG,31.626,110.34
10940,张家口宁远机场,Zhangjiakou Ningyuan Airport,Zhangjiakou,ZQZ,40.7386016846,114.930000305
10941,阿尔山伊尔施机场,Arxan Yi'ershi Airport,Arxan,YIE,47.3106,119.9117
10942,衡阳南岳机场,Hengyang Nanyue Airport,Hengyang,HNY,26.9053,112.627998
10943,阿坝红原机场,Hongyuan Airport,Ngawa,AHJ,32.53154,102.35224
11473,金昌金川机场,Jinchuan Airport,Jinchuan,JIC,38.542222222199996,102.348333333
11498,博乐阿拉山口机场,Alashankou Bole (Bortala) airport,Bole,BPL,44.895,82.3
11499,富蕴可可托海机场,Fuyun Koktokay Airport,Fuyun,FYN,46.804169,89.512006
11545,临汾乔李机场,Linfen Qiaoli Airport,LINFEN,LFQ,36.132629,111.641236
11713,日照山字河机场,Rizhao Shanzihe Airport,Rizhao,RIZ,35.405033,119.324403
11714,三明沙县机场,Shaxian Airport,Sanming,SQJ,26.4263,117.8336
12047,老河口机场,Guangzhou MR Air Base,Guanghua,LHK,32.389400482177734,111.69499969482422
12048,十堰武当山机场,Shiyan Wudangshan Airport,Shiyan,WDS,32.591667,110.907778
12050,花土沟机场,Huatugou Airport,Mengnai,HTT,38.201984,90.841495
12052,蚌埠机场,Bengbu Airport,Bengbu,BFU,32.8477333333,117.320244444
12053,如皋机场,Rugao Air Base,Rugao,RUG,32.25788497924805,120.50165557861328
12054,芜湖机场,Wuhu Air Base,Wuhu,WHU,31.3906,118.408997
12055,鄯善机场,Shanshan Airport,Shanshan,SXJ,42.91170120239258,90.24749755859375
12056,营口兰旗机场,Yingkou Lanqi Airport,Yingkou,YKH,40.542524,122.3586
12921,阿拉善左旗巴彦浩特机场,Alxa Left Banner Bayanhot Airport,Alxa Left Banner,AXF,38.74831,105.58858
13192,德令哈机场,Delingha Airport,Haixi,HXD,37.125286,97.268658
13193,琼海博鳌机场,Qionghai Bo'ao Airport,Qionghai,BAR,19.13824,110.454775
13211,乌兰察布集宁机场,Ulanqab Jining Airport,Wulanchabu,UCB,41.129722,113.108056
13229,邵阳武冈机场,Shaoyang Wugang Airport,Shaoyang,WGN,26.802,110.642
13470,白城长安机场,Baicheng Chang'an Airport,Baicheng,DBC,45.505278,123.019722
13471,陇南成州机场,Longnan Chengzhou Airport,Longnan,LNL,33.788,105.797
13472,上饶三清山机场,Shangrao Sanqingshan Airport,Shangrao,SQD,28.3797,117.9643
13473,松原查干湖机场,Songyuan Chaganhu Airport,Songyuan,YSQ,44.938114,124.550178
13474,建三江机场,Jiansanjiang Airport,Jiansanjiang,JSJ,47.11,132.660278
13476,遵义茅台机场,Zunyi Maotai Airport,Zunyi,WMT,27.81638,106.33268
13477,荔波机场,Libo Airport,Libo,LLB,25.4525,107.961667
13478,承德普宁机场,Chengde Puning Airport,Chengde,CDE,41.1225,118.073889
13479,五大连池德都机场,Wudalianchi Dedu Airport,Wudalianchi,DTU,48.445,126.133
13480,额济纳旗桃来机场,Ejin Banner-Taolai Airport,Ejin Banner,EJN,42.0155,101.0005
13481,阿拉善右旗巴丹吉林机场,Alxa Right Banner Badanjilin Airport,Alxa Right Banner,RHT,39.225,101.546
13482,霍林郭勒霍林河机场,Holingol Huolinhe Airport,Holingol,HUO,45.487222,119.407222
13483,果洛玛沁机场,Golog Maqin Airport,Golog,GMQ,34.418066,100.301144
13485,莎车叶尔羌机场,Yeerqiang Airport,Yarkant,QSZ,38.281055,77.075192
13488,沧源佤山机场,Cangyuan Washan Airport,Cangyuan,CWJ,23.273889,99.373611
13489,澜沧景迈机场,Lancang Jingmai Airport,Lancang Lahu,JMJ,22.415833,99.786389
13490,宁蒗泸沽湖机场,Ninglang Luguhu Airport,Ninglang,NLH,27.5403,100.7593
13494,忻州五台山机场,Xinzhou Wutaishan Airport,Xinzhou,WUT,38.597456,112.969173
13496,扎兰屯成吉思汗机场,Chengjisihan Airport,Zhalantun,NZL,47.865833,122.767503
14090,元谋机场,Yuanmou Air Base,Yuanmou,YUA,25.737499237061,101.88200378418
14092,兴城机场,Xingcheng Air Base,,XEN,40.580299377399996,120.697998047下节课见
带着装好的 Tableau 和那张机场地图来上课,我们直接进阶做仪表板与故事。如果在准备过程中遇到问题,先回看《下载指南》和《安装与数据连接指南》,或在群里提问。
唯有知识,让我们免于平庸。
作者:xilejun · v1.0 · 2026-07-08
结语
好的学习数据能让 Tableau 的学习曲线减半。从官方 Superstore 到真实业务数据,选择「够用但不复杂」的数据集是关键。
No comments yet