前言:
本文参照https://zhuanlan.zhihu.com/p/72412039进行练习,目的是为了熟悉Tableau的基本页面。
基本操作的学习可以在下面网站进行学习
https://www.w3cschool.cn/tableau/tableau_questions_and_answers.html
具体操作:
1.熟悉数据源
本次数据来源于Tableau自带的超市案例
数据源如下:
![](https://img.haomeiwen.com/i19593862/38fdf7d76880d7e1.png)
![](https://img.haomeiwen.com/i19593862/c8d63c3922b68a7e.png)
一句话总结:
有基本的订单号、订单时间、发货时间、销售金额、类型、地区、客户ID、客户类型、利润额。
2.可分析维度
首先,简单介绍一下Tableau的模块分为三个:图表、仪表盘、故事。
![](https://img.haomeiwen.com/i19593862/e466285dd1d348c9.png)
图表:单个作图,仪表盘:将多个图表组合,故事:将多个仪表盘组合。
2.1 可分析维度有5个 如下图
![](https://img.haomeiwen.com/i19593862/1a853f85aba1494e.png)
存在缺陷则是没有进行指标化思维,业务思维的关联性不足。
3.具体图表展示
3.1客户分析
![](https://img.haomeiwen.com/i19593862/8647bf72040e15db.png)
![](https://img.haomeiwen.com/i19593862/158561f891bab272.png)
![](https://img.haomeiwen.com/i19593862/45bf4456bd87c5b8.png)
![](https://img.haomeiwen.com/i19593862/c845a59489d1d842.png)
![](https://img.haomeiwen.com/i19593862/d5af2850cf344577.png)
3.2配送分析
需要新增两个字段
![](https://img.haomeiwen.com/i19593862/095deff339844d23.png)
![](https://img.haomeiwen.com/i19593862/019e22a9b99b7119.png)
![](https://img.haomeiwen.com/i19593862/4d29e1d7574c2b41.png)
![](https://img.haomeiwen.com/i19593862/c28273eefadd074a.png)
![](https://img.haomeiwen.com/i19593862/8e3a454c798e9953.png)
![](https://img.haomeiwen.com/i19593862/ce83caf9d53ad0c1.png)
![](https://img.haomeiwen.com/i19593862/ceb66651c3b8d685.png)
3.3销售分析
![](https://img.haomeiwen.com/i19593862/a64fac73228892f5.png)
![](https://img.haomeiwen.com/i19593862/d45b991b25f16fb4.png)
![](https://img.haomeiwen.com/i19593862/e21f3e924e21ce60.png)
![](https://img.haomeiwen.com/i19593862/2dc15d528e8ef785.png)
![](https://img.haomeiwen.com/i19593862/1afffb08d02557e0.png)
3.4利润分析
![](https://img.haomeiwen.com/i19593862/c495b26c093c4ba0.png)
![](https://img.haomeiwen.com/i19593862/bbb681e5a931675c.png)
![](https://img.haomeiwen.com/i19593862/e5bf337394ef5345.png)
![](https://img.haomeiwen.com/i19593862/6a1699d6ec9a16e8.png)
![](https://img.haomeiwen.com/i19593862/3baddb95f5b7b756.png)
3.5销售预测
![](https://img.haomeiwen.com/i19593862/2d1a63d5ef5b798b.png)
![](https://img.haomeiwen.com/i19593862/ff01c589789e3e73.png)
![](https://img.haomeiwen.com/i19593862/c701c13150fa41af.png)
![](https://img.haomeiwen.com/i19593862/1c7944ea5888d15d.png)
网友评论