Pro Tableau (eBook)

A Step-by-Step Guide

Seema Acharya, Subhashini Chellappan (Autoren)

eBook Download: PDF

2016 | 1st ed.
XXIII, 845 Seiten
Apress (Verlag)
978-1-4842-2352-9 (ISBN)

Infos

Leverage the power of visualization in business intelligence and data science to make quicker and better decisions. Use statistics and data mining to make compelling and interactive dashboards. This book will help those familiar with Tableau software chart their journey to being a visualization expert.

Pro Tableau demonstrates the power of visual analytics and teaches you how to:

• Connect to various data sources such as spreadsheets, text files, relational databases (Microsoft SQL Server, MySQL, etc.), non-relational databases (NoSQL such as MongoDB, Cassandra), R data files, etc.
  
• Write your own custom SQL, etc.
  
• Perform statistical analysis in Tableau using R
  
• Use a multitude of charts (pie, bar, stacked bar, line, scatter plots, dual axis, histograms, heat maps, tree maps, highlight tables, box and whisker, etc.)
  

What you'll learn

• Connect to various data sources such as relational databases (Microsoft SQL Server, MySQL), non-relational databases (NoSQL such as MongoDB, Cassandra), write your own custom SQL, join and blend data sources, etc.
  
• Leverage table calculations (moving average, year over year growth, LOD (Level of Detail), etc.
  
• Integrate Tableau with R
  
• Tell a compelling story with data by creating highly interactive dashboards
  

Who this book is for

All levels of IT professionals, from executives responsible for determining IT strategies to systems administrators, to data analysts, to decision makers responsible for driving strategic initiatives, etc. The book will help those familiar with Tableau software chart their journey to a visualization expert. 

Seema Acharya is a Lead Principal with the Education, Training and Assessment department of Infosys Limited. She is an educator by choice and vocation, and has rich experience in both academia and the software industry. She is also the author of the books, 'Fundamentals of Business Analytics', ISBN: 978-81-265-3203-2, publisher - Wiley India and 'Big Data and Analytics', ISBN: 9788126554782, publisher - Wiley India. She has co-authored a paper on 'Collaborative Engineering Competency Development' for ASEE (American Society for Engineering Education). She holds the patent on 'Method and system for automatically generating questions for a programming language'. Her areas of interest and expertise are centered on Business Intelligence, Big Data and Analytics technologies such as Data Warehousing, Data Mining, Data Analytics, Text Mining and Data Visualisation.

Subhashini Chellappan is a Software Engineering Team Lead with the talent division of Accenture. She has rich experience in both academia and the software industry.

She has published couple of papers in various Journals and Conferences.

Her areas of interest and expertise are centered on Business Intelligence, Big Data and Analytics technologies such as Hadoop, NoSQL Databases, Spark and Machine Learning.

Inhalt

Table of contentChapter 1: Introducing Visualization and TableauWhy Visualization?What is Visualization?Positioning of TableauTableau product linesFile types in Tableau.twb.twbx.tds.tdsx.tde.tbmChapter 2: Working with Single and Multiple Data SourcesDesktop ArchitectureData Connection PageConnect to a FileExcelOpen with legacy connectionTextMicrosoft AccessR data file (.rdata)Connect to a ServerMicrosoft SQL ServerMySQLNoSQL Databases (MongoDB, Cassandra)Metadata GridUsing Data ExtractsAll about JoinsUsing Custom SQLUsing Data BlendingChapter 3: Simplifying and Sorting your DataFiltering on dimensions and measuresSoring on single dimension – Primary sortSorting on more than one dimension – Secondary SortSlicing your data by dateDiscrete datesContinuous datesOrganizing your dataGroupsHierarchiesSetsStatic setsDynamic setsDifference between groups and setsChapter 4: Measure Values and Measure NamesUsing measure values and measure names in a viewChapter 5: Using Quick Table Calculations in TableauRunning TotalPercent of TotalPercentileRankMoving averageYear over Year GrowthLevel Of Detail (LOD) calculationsChapter 6: Customizing your DataString CalculationsNumber CalculationsDate CalculationsLogical CalculationsChapter 7: StatisticsDescriptive StatisticsSumAverageMinMaxCountCount(distinct)MedianStandard DeviationVarianceUsing the Analytics PaneConstant LinesAverage LinesFive magical number summaryBox and whisker plotTrend LinesForecastChapter 8: Chart FormsBar ChartPie chartLine graphScatter PlotHistogramHeat MapTree MapHighlight TableChapter 9: Advance Visualization MethodsWaterfall ChartsGantt ViewBullet GraphChapter 10: Dashboard and StoriesCreating an interactive dashboardAdding Actions to your dashboardTelling stories with dataChapter 11: Integration of R with TableauFunctions such as (SCRIPT_INT(), SCRIPT_REAL(),SCRIPT_BOOL(), SCRIPT_STR())Data MiningAffinity AnalysisK-means Clustering

Produkt-Details

• Erscheint lt. Verlag: 23.12.2016
• Zusatzinfo: XXIII, 845 p. 1063 illus., 1032 illus. in color.
• Verlagsort: Berkeley
• Sprache: englisch
• Themenwelt: Mathematik / Informatik ► Informatik ► Datenbanken
• Themenwelt: Mathematik / Informatik ► Informatik ► Netzwerke
• Themenwelt: Mathematik / Informatik ► Informatik ► Programmiersprachen / -werkzeuge
• Themenwelt: Mathematik / Informatik ► Informatik ► Software Entwicklung
• Schlagworte: Chart Forms • Data Calculation • data visualisation • Integration with R • Measure Data • Measure Names • Number Calculation • Quick Table calculations • R • String Calculation • tableau
• ISBN-10: 1-4842-2352-7 / 1484223527
• ISBN-13: 978-1-4842-2352-9 / 9781484223529