Prepare Your Data for Tableau: A Practical Guide to the Tableau Data Prep Tool
暫譯: 為 Tableau 準備數據:Tableau 數據準備工具實用指南
Costello, Tim, Blackshear, Lori
- 出版商: Apress
- 出版日期: 2019-12-17
- 售價: $1,510
- 貴賓價: 9.5 折 $1,435
- 語言: 英文
- 頁數: 202
- 裝訂: Quality Paper - also called trade paper
- ISBN: 1484254961
- ISBN-13: 9781484254967
-
相關分類:
Data-visualization
海外代購書籍(需單獨結帳)
買這商品的人也買了...
相關主題
商品描述
Focus on the most important and most often overlooked factor in a successful Tableau project--data. Without a reliable data source, you will not achieve the results you hope for in Tableau. This book does more than teach the mechanics of data preparation. It teaches you: how to look at data in a new way, to recognize the most common issues that hinder analytics, and how to mitigate those factors one by one.
Tableau can change the course of business, but the old adage of "garbage in, garbage out" is the hard truth that hides behind every Tableau sales pitch. That amazing sales demo does not work as well with bad data. The unfortunate reality is that almost all data starts out in a less-than-perfect state. Data prep is hard.
Traditionally, we were forced into the world of the database where complex ETL (Extract, Transform, Load) operations created by the data team did all the heavy lifting for us. Fortunately, we have moved past those days. With the introduction of the Tableau Data Prep tool you can now handle most of the common Data Prep and cleanup tasks on your own, at your desk, and without the help of the data team. This essential book will guide you through:
- The layout and important parts of the Tableau Data Prep tool
- Connecting to data
- Data quality and consistency
- The shape of the data. Is the data oriented in columns or rows? How to decide? Why does it matter?
- What is the level of detail in the source data? Why is that important?
- Combining source data to bring in more fields and rows
- Saving the data flow and the results of our data prep work
- Common cleanup and setup tasks in Tableau Desktop
What You Will Learn
- Recognize data sources that are good candidates for analytics in Tableau
- Connect to local, server, and cloud-based data sources
- Profile data to better understand its content and structure
- Rename fields, adjust data types, group data points, and aggregate numeric data
- Pivot data
- Join data from local, server, and cloud-based sources for unified analytics
- Review the steps and results of each phase of the Data Prep process
- Output new data sources that can be reviewed in Tableau or any other analytics tool
Who This Book Is For
Tableau Desktop users who want to: connect to data, profile the data to identify common issues, clean up those issues, join to additional data sources, and save the newly cleaned, joined data so that it can be used more effectively in Tableau
商品描述(中文翻譯)
專注於成功的 Tableau 專案中最重要且最常被忽視的因素——數據。沒有可靠的數據來源,您將無法在 Tableau 中達成期望的結果。本書不僅教授數據準備的機械操作,還教您:如何以新的方式看待數據,識別妨礙分析的最常見問題,以及如何逐一減輕這些因素。
Tableau 可以改變商業的走向,但「垃圾進,垃圾出」的老話是每個 Tableau 銷售推廣背後的殘酷真相。那個驚人的銷售演示在不良數據下並不會如預期般有效。不幸的現實是,幾乎所有數據一開始都處於不完美的狀態。數據準備是困難的。
傳統上,我們被迫進入數據庫的世界,數據團隊創建的複雜 ETL(提取、轉換、加載)操作為我們完成了所有繁重的工作。幸運的是,我們已經過了那些日子。隨著 Tableau Data Prep 工具的推出,您現在可以在自己的桌面上獨立處理大多數常見的數據準備和清理任務,而無需數據團隊的幫助。本書將指導您完成:
- Tableau Data Prep 工具的佈局和重要部分
- 連接數據
- 數據質量和一致性
- 數據的形狀。數據是以列還是行的形式排列?如何決定?這有什麼重要性?
- 來源數據的詳細程度是什麼?這為什麼重要?
- 組合來源數據以引入更多字段和行
- 保存數據流和我們數據準備工作的結果
- Tableau Desktop 中的常見清理和設置任務
您將學到的內容:
- 識別適合在 Tableau 中進行分析的數據來源
- 連接本地、伺服器和雲端數據來源
- 檢視數據以更好地理解其內容和結構
- 重新命名字段、調整數據類型、分組數據點和聚合數值數據
- 透視數據
- 從本地、伺服器和雲端來源聯接數據以進行統一分析
- 檢視數據準備過程中每個階段的步驟和結果
- 輸出可以在 Tableau 或任何其他分析工具中檢視的新數據來源
本書適合對象:
希望連接數據、檢視數據以識別常見問題、清理這些問題、聯接額外數據來源,並保存新清理的聯接數據以便在 Tableau 中更有效使用的 Tableau Desktop 使用者。
作者簡介
Tim Costello is a senior data architect focused on the data warehouse life cycle, including the design of complex ETL (Extract, Transform, Load) processes, data warehouse design and visual analytics with Tableau. He has been actively involved with Tableau for almost 10 years. He founded the Dallas/Fort Worth Tableau user group. He has delivered hundreds of Tableau classes online and in person all over the USA and Canada.
When Tim isn't working with data, he is probably peddling his bicycle in circles around DFW airport in Dallas, Texas. He aspires to be a long distance rider and enjoys going on rides ranging over several days and hundreds of miles at a time.
Lori Blackshear is a senior business process architect and expert at facilitating meaningful and productive communication between business and technology groups. She has deep experience in healthcare (human and veterinary), software development, and research and development in support of emergency services.
Lori served as a paramedic in Fort Worth, Texas and Nashville, Tennessee before shifting careers to helping people solve problems with data. When Lori isn't pondering business processes, she is active in the Fort Worth Civic Orchestra (violin) and the East Fort Worth Community Jazz band (tenor saxophone).
作者簡介(中文翻譯)
Tim Costello 是一位資深數據架構師,專注於數據倉儲生命週期,包括複雜的 ETL(提取、轉換、加載)過程設計、數據倉儲設計以及使用 Tableau 進行視覺分析。他在 Tableau 的參與已近十年,並創立了達拉斯/沃斯堡 Tableau 使用者小組。他在美國和加拿大各地提供了數百場 Tableau 課程,無論是線上還是面對面。
當 Tim 不在處理數據時,他可能正在德克薩斯州達拉斯的 DFW 機場周圍騎自行車。他渴望成為一名長途騎行者,並喜歡進行為期數天、數百英里的騎行。
Lori Blackshear 是一位資深業務流程架構師,擅長促進業務與技術團隊之間有意義且富有成效的溝通。她在醫療(人類和獸醫)、軟體開發以及支持緊急服務的研究與開發方面擁有豐富的經驗。
Lori 曾在德克薩斯州沃斯堡和田納西州納什維爾擔任急救醫療技術員,之後轉行幫助人們用數據解決問題。當 Lori 不在思考業務流程時,她活躍於沃斯堡市民管弦樂團(小提琴)和東沃斯堡社區爵士樂隊(次中音薩克斯風)。