很多同学张嘴叭叭就要几天拿下的,结果连考试大纲都不看。不学,不练,不看,不会。上来就要裸考,同学,你要脱纲啊。
这本教科书的编写就是紧紧围绕着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一课,然后配合一定的练习慢慢就有体会了)