很多同学张嘴叭叭就要几天拿下的,结果连考试大纲都不看。不学,不练,不看,不会。上来就要裸考,同学,你要脱纲啊。
这本教科书的编写就是紧紧围绕着Tableua官方所给出的考点,请注意是紧紧的,你要是想学点超纲的的,那种一般人把握不住的知识的话,对不起 得交钱。
考试形式: 45道多选 看清楚了是多选 多选就意味着你必须有能力判断每个选项的对错
考试时间:60分钟
第一部分 连接和准备数据 (23%)
Domain 1: Connecting to and Preparing Data
1.1 Create live connections and extracts 创建live connection and extracts
live connection就是数据从哪来的就搁那,我在Tableau里边也不碰它。 Extract就是抄作业,把数据从别人的作业复制到你的作业本上
1.1.1 Create a live connection to a data source
1.1.2 Explain the differences between using live connections versus extracts
1.1.3 Create an extract
1.1.4 Save metadata properties in a .TDS (这一条你不特殊学的话,你都不知道是啥意思)
1.1.5 Create a data source that uses multiple connections
1.2 Create and manage the data model
创建数据模型。 数据模型就是把几个表整到一起,但是你不能硬整,大力出不了奇迹,你得按照一定的方法把它们拼到一起
这个部分的核心考点就是不同表格之间的关系
‘说! 你们之间到底是什么关系’
1.2.1 Add relationships to a data source
1.2.2 Add joins and unions
1.2.3 Explain when to use a join versus a relationship
1.3 Manage data properties
Data Properties主要是给每个column改变出厂设置,比如以前这个column name叫刘英,现在你叫Lucy了
1.3.1 Rename a data field
1.3.2 Assign an alias to a data value
1.3.3 Assign a geographic role to a data field
1.3.4 Change data type for a data field (number, date, string, Boolean, etc.)
1.3.5 Change default properties for a data field (number format, aggregation, color, date format, etc.)
Domain 2: Exploring and Analyzing Data 探索和分析数据(37%)三分之一的分数在此
2.1 Create basic charts (你要是这章都不学你给我出去)
2.1.1 Create a bar chart
2.1.2 Create a line chart
2.1.3 Create a scatterplot 散点图
2.1.4 Create a map using geographic data 地图
2.1.5 Create a combined axis chart (好好学,考完证也经常用的到)
2.1.6 Create a dual axis chart
2.1.7 Create a stacked bar
2.1.8 Create a density map
2.1.9 Create a chart to show specific values (crosstab, highlight table)
2.2 Organize data and apply filters
2.2.1 Create groups by using marks, headers, and the data pane (这是一个充满了Tableau术语的考点)
2.2.2 Create sets by using marks and the data pane (创建Sets对下一个Level的考试也非常有用)
2.2.3 Organize dimensions into a hierarchy (hierarchy是Tableau的一个特殊功能,会单独讲)
2.2.4 Add a filter to a view
2.2.5 Add a date filter
2.3 Apply analytics to a worksheet
2.3.1 Add a manual or a computed sort (排序)
2.3.2 Add a reference line (添加辅助线,但是这个reference line是有很多种类型的)
2.3.3 Use a quick table calculation
2.3.4 Use bins and histograms
2.3.5 Create a calculated field (e.g. string, date, simple arithmetic)
2.3.6 Explain when to use a parameter (一般这种Explain的问题会以选择题的形式出现)
2.3.7 Display totals on a worksheet (这里说的不全面,totals包含subtotal和grand total)
Domain 3: Sharing Insights (分享洞见 - 让别人看看你做出来了个啥)
3.1 Format view for presentation (这个部分的知识基本上就是知道和不知道,没有太深的深度)
3.1.1 Use color from the marks card
3.1.2 Configure fonts
3.1.3 Format marks as shapes
3.1.4 Configure viz animations
3.1.5 Change size of marks
3.1.6 Show and hide legends
3.2 Create and modify a dashboard
Action,Layout 这些可都不是看起来那么简单的。 你可能觉得你会,但是一操作起来就蒙圈了。这里有个东西没说,但是一般Tableau Developer都犯怵的就是Container
3.2.1 Add worksheets to a dashboard
3.2.2 Add interactive elements for consumers (e.g. show filters, data highlighter, tooltips)
3.2.3 Add dashboard actions (e.g. filter action, highlight action, parameter control, URL action)
3.2.4 Configure a dashboard layout and create device-specific dashboards
3.2.5 Create a story and a story point
3.3 View and share workbook data
3.3.1 Share a workbook (e.g. twbx as a PDF or an image, publish to Tableau Server)
3.3.2 View and export underlying data
3.3.3 Export to Microsoft PowerPoint
Domain 4: Understanding Tableau Concepts (理解Tableau概念)
4.1 Understand dimensions and measures (为了这一考点,特意写了一篇文章。参见章节)
4.1.1 Explain what kind of information dimensions usually contain
4.1.2 Explain what kind of information measures usually contain
4.1.3 Explain the difference between dimensions and measures
4.2 Understand discrete and continuous fields (离散和连续)
4.2.1 Explain how discrete fields are displayed
4.2.2 Explain how continuous fields are displayed
4.2.3 Explain the difference between discrete date parts and continuous date values (请注意这里说的是date,别傻不拉几的以为这里就是让你解释,你心想老师我能解释明白啊,人家其实问的是如果用不同类型的date, 它会对Tableau里的作图有什么影响)
4.3 Understand aggregations
4.3.1 Explain the default aggregation for measures
4.3.2 Describe how an aggregated measure changes when dimensions are added to a view
(先认真阅读product hierarchy一课,然后配合一定的练习慢慢就有体会了)