Data wrangling with Tableau and Excel October 11 2016 JRNL 520H

What is data wrangling? Data wrangling is the process of preparing raw data for use in a data analysis or visualization software.

What are the causes of dirty data? ● Data entry error

What are the causes of dirty data? ● Data entry error Incompatible tables ●

What are the causes of dirty data? ● Data entry error Incompatible tables ● Incompatible table format ●

What should we look out for when cleaning data? ● Table formating

What should we look out for when cleaning data? ● Table formating Variable type ●

What should we look out for when cleaning data? ● Table formating Variable type ● Invalid character values ●

What should we look out for when cleaning data? ● Table formating Variable type ● Invalid character values ● Invalid numeric values ●

What should we look out for when cleaning data? ● Table formating Variable type ● Invalid character values ● Invalid numeric values ● ● Grouping data

What should we look out for when cleaning data? ● Table formating Variable type ● Invalid character values ● Invalid numeric values ● ● Grouping data Missing values ●

Ideal format of data in Tableau 1. Start your data in cell A1. Remove all introductory information and footnotes. 2. Have the first row be the column headers/variable names 3. Have every subsequent row be one observation. No cross-tabulation!

Ideal format of data in Tableau Before After

Data Interpreter Tableau’s Data Interpreter feature draws out sub-tables and removes some of that extraneous information to help prepare your data source for analysis. Note: the data interpreter only works with Microsoft Excel files, not CSV or other file types.

Data Interpreter Tableau’s Data Interpreter feature draws out sub-tables and removes some of that extraneous information to help prepare your data source for analysis. Note: the data interpreter only works with Microsoft Excel files, not CSV or other file types. Complete Tableau exercise

Joins A JOIN is a means for combining columns from one or more tables by using values common to each. There are four main join types: inner, left, right and full outer.

Joins Complete Tableau exercise

Wrangling in Excel Sometimes the data interpreter in Tableau isn’t able to detect all of the errors in the dataset. In cases like this, you will need to manually clean the data in Excel. Complete Tableau exercise

Columnar format Pivot Tabular format

Columnar format Pivot Tabular format Complete Tableau exercise

Data wrangling with Tableau and Excel October 11 2016 JRNL 520H - PowerPoint PPT Presentation

Data wrangling with Tableau and Excel October 11 2016 JRNL 520H What is data wrangling? Data wrangling is the process of preparing raw data for use in a data analysis or visualization software. What are the causes of dirty data? Data

Applying the Data Wrangling Process Nicole G Weiskopf, 8/21/18 Wrangling diabetes Research

The bottom line We are the data science people but the world needs to know about it Wrangling vs

Overview of Wrangling Hypertension Nicole G Weiskopf, 8/26/18 Wrangling hypertension Research

Beginner Intermediate Understanding Level

Prerequisites - You have installed Tableau Desktop on your computer. Available here:

Introductjon to EHR Data Quality Nicole G Weiskopf, 8/21/18 Learning Objectjves What is data

Tableau helps people see and Designing Tableau understand data Tableau Research Suppose you

Data Wrangling John Meehan Jeff Rasley Working with raw

General-Purpose Inductive Programming for Data Wrangling Automation Lidia Contreras-Ochando,

Data Visualization with Tableau October 26-27, 2017 Sacramento, CA Brittany Fong & Erol

02 Preparing data for analysis Gabor Bekes Data Analysis 1: Exploration 2019 Variable types

Analytics Open Labs: Introduction to Tableau at the University of Kentucky 1 pm - 3 pm 1st

The Art and Science of Data Wrangling Kristen M. Altenburger and Sam Pepose Facebook Core Data

MS EXCEL Utilities THE EXCEL DEMOGRAPHIC Data Management and Building Reports My Boss Said

Accessing Tableau Accessing Tableau Accessing Tableau Once Tableau access is approved:

Wrangling the Bugzilla Beast Robinson Tryon September 23 rd , 2015 1 Wrangling the Bugzilla

What we need 1. Laziness and partial recalc 2. Caching 3. Asynchronous result production

Buffer overflows & friends CS642: Computer Security

Building SoCs with Migen and MiSoC Sbastien Bourdeauducq M-Labs Ltd, Hong Kong

Towards prac+cal incremental recomputa+on for scien+sts Philip J. Guo and Dawson Engler Workshop

CSE543 - Introduction to Computer and Network Security Module: Authentication Professor Trent

Concept Mix : Self-Service Analytical Data Integration Based on the Concept-Oriented Model

ImprovingtheMachineLearningPipelineatDuke Dima Fayyad Sean Holt David Rein Project Leads: AJ

IMPROVING $PORT PERFORMANCE ON $ARCH PLATFORM-BASED PERFORMANCE TUNING OF WEBKIT (PORT=QT