TableauPrep官方视频教程_tableauprep-专业指导文档类资源-CSDN文库

Tableau

4星 · 超过85%的资源

所需积分/C币: 45

浏览量·697

RAR

112.23MB

2018-05-28 23:00:41 上传

身份认证购VIP最低享 7 折!

评论收藏

内容反馈

资源推荐

资源详情

资源评论

<html xmlns="http://www.w3.org/1999/xhtml"><head><meta charset="utf-8"><meta name="generator" content="pdf2htmlEX"><meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1"><link rel="stylesheet" href="https://csdnimg.cn/release/download_crawler_static/css/base.min.css"><link rel="stylesheet" href="https://csdnimg.cn/release/download_crawler_static/css/fancy.min.css"><link rel="stylesheet" href="https://csdnimg.cn/release/download_crawler_static/10443693/raw.css"><script src="https://csdnimg.cn/release/download_crawler_static/js/compatibility.min.js"></script><script src="https://csdnimg.cn/release/download_crawler_static/js/pdf2htmlEX.min.js"></script><script>try{pdf2htmlEX.defaultViewer = new pdf2htmlEX.Viewer({});}catch(e){}</script><title></title></head><body><div id="sidebar" style="display: none"><div id="outline"></div></div><div id="pf1" class="pf w0 h0" data-page-no="1"><div class="pc pc1 w0 h0"><img class="bi x0 y0 w1 h1" alt="" src="https://csdnimg.cn/release/download_crawler_static/10443693/bg1.jpg"><div class="t m0 x1 h2 y1 ff1 fs0 fc0 sc0 ls0 ws0">01getting_started_with_tableau_prep</div><div class="t m0 x1 h2 y2 ff1 fs0 fc0 sc0 ls0 ws0">02the_tableau_prep_interface</div><div class="t m0 x1 h2 y3 ff1 fs0 fc0 sc0 ls0 ws0">03the_input_step_0</div><div class="t m0 x1 h2 y4 ff1 fs0 fc0 sc0 ls0 ws0">04the_input_step_0</div><div class="t m0 x1 h2 y5 ff1 fs0 fc0 sc0 ls0 ws0">05group_and_replace</div><div class="t m0 x1 h2 y6 ff1 fs0 fc0 sc0 ls0 ws0">06the_profile_pane</div><div class="t m0 x1 h2 y7 ff1 fs0 fc0 sc0 ls0 ws0">07the_pivot_step</div><div class="t m0 x1 h2 y8 ff1 fs0 fc0 sc0 ls0 ws0">08the_aggregate_step</div><div class="t m0 x1 h2 y9 ff1 fs0 fc0 sc0 ls0 ws0">09the_join_step</div><div class="t m0 x1 h2 ya ff1 fs0 fc0 sc0 ls0 ws0">10the_union_step</div><div class="t m0 x1 h2 yb ff1 fs0 fc0 sc0 ls0 ws0">11the_output_step</div><a class="l"><div class="d m1"></div></a><a class="l"><div class="d m1"></div></a><a class="l"><div class="d m1"></div></a><a class="l"><div class="d m1"></div></a><a class="l"><div class="d m1"></div></a><a class="l"><div class="d m1"></div></a><a class="l"><div class="d m1"></div></a><a class="l"><div class="d m1"></div></a><a class="l"><div class="d m1"></div></a><a class="l"><div class="d m1"></div></a><a class="l"><div class="d m1"></div></a></div><div class="pi" data-data='{"ctm":[1.568627,0.000000,0.000000,1.568627,0.000000,0.000000]}'></div></div></body></html>

<div id="pf2" class="pf w0 h0" data-page-no="2"><div class="pc pc2 w0 h0"><img class="bi x0 y0 w1 h1" alt="" src="https://csdnimg.cn/release/download_crawler_static/10443693/bg2.jpg"><div class="t m0 x2 h3 yc ff2 fs1 fc1 sc0 ls1 ws1">Free Training Transcript: </div><div class="t m0 x2 h3 yd ff2 fs1 fc1 sc0 ls0 ws0">Getting Started with </div><div class="t m0 x2 h3 ye ff2 fs1 fc1 sc0 ls2 ws2">Tableau Prep</div></div><div class="pi" data-data='{"ctm":[1.568627,0.000000,0.000000,1.568627,0.000000,0.000000]}'></div></div>

<div id="pf3" class="pf w0 h0" data-page-no="3"><div class="pc pc3 w0 h0"><img class="bi x0 y0 w1 h1" alt="" src="https://csdnimg.cn/release/download_crawler_static/10443693/bg3.jpg"><div class="t m0 x3 h4 yf ff3 fs2 fc2 sc0 ls0 ws0">2</div><div class="t m0 x4 h5 y10 ff4 fs3 fc1 sc0 ls3 ws0">Welcome to this video on Getting Started with Tableau Prep. You can download the data set </div><div class="t m0 x4 h6 y11 ff5 fs3 fc1 sc0 ls3 ws3">and packaged ow le underneath the video to follow along in your own copy of Tableau </div><div class="t m0 x4 h6 y12 ff5 fs3 fc1 sc0 ls3 ws3">Prep. We’re working with data for bestselling books.</div><div class="t m0 x4 h7 y13 ff2 fs4 fc1 sc0 ls4 ws4">Getting Started with Tableau Prep</div><div class="t m0 x4 h6 y14 ff5 fs3 fc1 sc0 ls3 ws3">Tableau Prep makes it easy to get your data ready for analysis. With the same highly </div><div class="t m0 x4 h6 y15 ff5 fs3 fc1 sc0 ls3 ws3">interactive, drag and drop interactions you’re used to, Tableau Prep can be used to </div><div class="t m0 x4 h6 y16 ff5 fs3 fc1 sc0 ls3 ws3">combine, clean, and shape your data exactly how you want it. </div><div class="t m0 x4 h6 y17 ff5 fs3 fc1 sc0 ls3 ws3">Preparing data is done by by building a ow, made up of steps such as cleaning, pivoting, </div><div class="t m0 x4 h6 y18 ff5 fs3 fc1 sc0 ls3 ws3">or aggregating data. Tableau Desktop works best with data that is “tidy” in structure. That </div><div class="t m0 x4 h6 y19 ff5 fs3 fc1 sc0 ls3 ws3">is, the data should be in rows and columns, and each row should represent one item of data </div><div class="t m0 x4 h6 y1a ff5 fs3 fc1 sc0 ls3 ws3">and each column should be one attribute. How do we get our data that way using Tableau </div><div class="t m0 x4 h5 y1b ff4 fs3 fc1 sc0 ls3 ws0">Prep? Let’s jump in! </div><div class="t m0 x4 h7 y1c ff6 fs4 fc1 sc0 ls5 ws5">Building a ow</div><div class="t m0 x4 h6 y1d ff5 fs3 fc1 sc0 ls0 ws0">First, we’ll connect to the data set. Our bestseller data is in Excel. We’ll connect to the </div><div class="t m0 x4 h6 y1e ff5 fs3 fc1 sc0 ls0 ws0">ABA Bestseller list from February 28th. Here in the Connections Pane we see the list of </div><div class="t m0 x4 h6 y1f ff5 fs3 fc1 sc0 ls0 ws0">tables (or sheet tabs) in this data set. We’ll drag out a table, and now we have our rst </div><div class="t m0 x4 h6 y20 ff5 fs3 fc1 sc0 ls0 ws0">step in the ow. </div><div class="t m0 x4 h6 y21 ff5 fs3 fc1 sc0 ls0 ws0">This input step is congurable below. We can bring in every sheet in the le by using </div><div class="t m0 x4 h5 y22 ff4 fs3 fc1 sc0 ls0 ws0">wildcard union and leaving the matching pattern blank. Over on the right we can see a </div><div class="t m0 x4 h6 y23 ff5 fs3 fc1 sc0 ls0 ws0">list of the elds we’ll bring in from these tables. Everything looks good. </div><div class="t m0 x4 h6 y24 ff5 fs3 fc1 sc0 ls0 ws0">Up in the ow pane, we can rename this step by double clicking and typing a name--let’s </div><div class="t m0 x4 h6 y25 ff5 fs3 fc1 sc0 ls0 ws0">call this February 28th. </div><div class="t m0 x4 h6 y26 ff5 fs3 fc1 sc0 ls0 ws0">To add another step to the ow, we’ll click the plus button. We just want a basic cleaning </div><div class="t m0 x4 h6 y27 ff5 fs3 fc1 sc0 ls0 ws0">step to start. This will let us see the state of our date and what we might need to do to </div><div class="t m0 x4 h6 y28 ff5 fs3 fc1 sc0 ls0 ws0">clean it. Below the ow pane, we now see the prole pane and data grid. The prole pane </div><div class="t m0 x4 h6 y29 ff5 fs3 fc1 sc0 ls0 ws0">shows a card for each eld in the data set, and the cards display the values in each eld </div><div class="t m0 x4 h6 y2a ff5 fs3 fc1 sc0 ls0 ws0">as well as distribution information about how frequently each value appears. By clicking </div><div class="t m0 x4 h6 y2b ff5 fs3 fc1 sc0 ls0 ws0">on a bar, we can highlight related values in other elds. </div></div><div class="pi" data-data='{"ctm":[1.568627,0.000000,0.000000,1.568627,0.000000,0.000000]}'></div></div>

<div id="pf4" class="pf w0 h0" data-page-no="4"><div class="pc pc4 w0 h0"><img class="bi x0 y0 w1 h1" alt="" src="https://csdnimg.cn/release/download_crawler_static/10443693/bg4.jpg"><div class="t m0 x3 h4 yf ff3 fs2 fc2 sc0 ls0 ws0">3</div><div class="t m0 x4 h6 y10 ff5 fs3 fc1 sc0 ls0 ws0">The Info eld has multiple pieces of information in one column. If we look down at that </div><div class="t m0 x4 h6 y11 ff5 fs3 fc1 sc0 ls0 ws0">data grid, which shows a more row-level representation of the data, we see that this </div><div class="t m0 x4 h6 y12 ff5 fs3 fc1 sc0 ls0 ws0">eld has a pipe between title and author, then a dollar sign before the price, and a pipe </div><div class="t m0 x4 h6 y2c ff5 fs3 fc1 sc0 ls0 ws0">and “ISBN”. We can split these values out into unique columns--as we want for analysis. </div><div class="t m0 x4 h6 y2d ff5 fs3 fc1 sc0 ls0 ws0">Click on the card and open the menu. There are multiple cleaning options here, but we’ll </div><div class="t m0 x4 h6 y2e ff5 fs3 fc1 sc0 ls0 ws0">choose automatic split. Tableau Prep is smart enough to recognize common delimiters--</div><div class="t m0 x4 h6 y2f ff5 fs3 fc1 sc0 ls0 ws0">even when they’re dierent--and will split out these four new columns. </div><div class="t m0 x4 h6 y30 ff5 fs3 fc1 sc0 ls0 ws0">Renaming the new elds is as easy as double clicking and typing the desired name. We </div><div class="t m0 x4 h6 y31 ff5 fs3 fc1 sc0 ls0 ws0">no longer need the original Info eld, so we can remove it. We can also split this eld and </div><div class="t m0 x4 h5 y32 ff4 fs3 fc1 sc0 ls0 ws0">remove the original. Now we have all the distinct columns we want. </div><div class="t m0 x4 h6 y33 ff5 fs3 fc1 sc0 ls0 ws0">Price is currently a string data type, but it should be a decimal number. We can click the </div><div class="t m0 x4 h6 y34 ff5 fs3 fc1 sc0 ls0 ws0">data type icon and choose number (decimal). </div><div class="t m0 x4 h6 y35 ff5 fs3 fc1 sc0 ls0 ws0">We have more weeks worth of data, so let’s add them to the ow. We can connect to new </div><div class="t m0 x4 h6 y36 ff5 fs3 fc1 sc0 ls0 ws0">data (it can be from any source, but ours happens to be another Excel le). We’ll bring in </div><div class="t m0 x4 h5 y37 ff4 fs3 fc1 sc0 ls0 ws0">a table, select wildcard union, and now we have our second data source. </div><div class="t m0 x4 h6 y38 ff5 fs3 fc1 sc0 ls0 ws0">To combine two steps in the ow, simply drag one onto the other, and chose Join or </div><div class="t m0 x4 h6 y39 ff5 fs3 fc1 sc0 ls0 ws0">Union. Here we have the same column structures, so we want to Union. We can verify </div><div class="t m0 x4 h6 y3a ff5 fs3 fc1 sc0 ls0 ws0">everything matched up correctly. </div><div class="t m0 x4 h6 y3b ff5 fs3 fc1 sc0 ls0 ws0">Now we simply need to make sure the cleaning we did is applied to the results from the </div><div class="t m0 x4 h6 y3c ff5 fs3 fc1 sc0 ls0 ws0">union, not the rst data set alone. We can right click on the line and select Remove, then </div><div class="t m0 x4 h5 y3d ff4 fs3 fc1 sc0 ls0 ws0">drag the union step to the cleaning step. That’s all it takes!</div><div class="t m0 x4 h6 y3e ff5 fs3 fc1 sc0 ls0 ws0">Our data is prepped and ready for use, so let’s create an output step. We’ll click the plus </div><div class="t m0 x4 h6 y3f ff5 fs3 fc1 sc0 ls0 ws0">and add an output. We’ll choose a CSV. We can where to save the le, and what to name it. </div><div class="t m0 x4 h6 y40 ff5 fs3 fc1 sc0 ls6 ws6">Now when we run the ow, we generate a new le (Tableau Prep doesn’t write back to the </div><div class="t m0 x4 h6 y41 ff5 fs3 fc1 sc0 ls0 ws0">original data source). This new le contains all of our data as we cleaned and combined it. </div><div class="t m0 x4 h6 y42 ff5 fs3 fc1 sc0 ls0 ws0">We’re ready for analysis!</div><div class="t m0 x4 h7 y43 ff6 fs4 fc1 sc0 ls7 ws4">Conclusion</div><div class="t m0 x4 h6 y44 ff5 fs3 fc1 sc0 ls0 ws0">Flows in Tableau Prep can be simple or complex, and each type of step has robust </div><div class="t m0 x4 h6 y45 ff5 fs3 fc1 sc0 ls0 ws0">options. Thank you for watching this video on Getting Started with Tableau Prep. We </div><div class="t m0 x4 h6 y46 ff5 fs3 fc1 sc0 ls0 ws0">invite you to continue with the other free training videos to learn more about using </div><div class="t m0 x4 h5 y47 ff4 fs3 fc1 sc0 ls8 ws7">Tableau. </div></div><div class="pi" data-data='{"ctm":[1.568627,0.000000,0.000000,1.568627,0.000000,0.000000]}'></div></div>

<div id="pf5" class="pf w0 h0" data-page-no="5"><div class="pc pc5 w0 h0"><img class="bi x0 y0 w1 h1" alt="" src="https://csdnimg.cn/release/download_crawler_static/10443693/bg5.jpg"><div class="t m0 x2 h3 yc ff7 fs1 fc1 sc0 ls1 ws1">Free Training </div><div class="t m0 x2 h3 yd ff7 fs1 fc1 sc0 ls9 ws8">Transcript: The Tableau </div><div class="t m0 x2 h3 ye ff7 fs1 fc1 sc0 lsa ws9">Prep Interface</div></div><div class="pi" data-data='{"ctm":[1.568627,0.000000,0.000000,1.568627,0.000000,0.000000]}'></div></div>

评论收藏

内容反馈

普通网友

2021-06-03

Tableau案例课程(2020版，完整版4个阶段) 网盘地址：https://pan.baidu.com/s/10JTjymrcpz0iYEktmzvgpA 提取码: xbe4
普通网友

2021-06-03

Tableau案例课程(2020版) 网盘地址：https://pan.baidu.com/s/1l1dZcY2WLYOw86xVX7RieA 提取码：9zrm 备用地址（腾讯微云）：https://share.weiyun.com/N8wedXbz 密码：m63g2h
lsw20141990

2019-08-02

根本不是视频，就是几个英文的pdf