Tableau Training: How to Prepare Data for Tableau (Data Structure Rules)

Connect with us! •Subscribe to the OneNumber Newsletter: onenumber.biz/newsletter •Follow Eric Parker on LinkedIn: www.linkedin.com/in/eric-parker-37513249/ Video Description: Are you having trouble getting your data to work in Tableau the way you want? Join us to learn how to prepare data for analysis in Tableau! You can find a thousand tutorials on how to use Tableau, but they're all worthless until your data is structured for analysis in the format that Tableau likes. Don't get stuck in your analysis journey because Tableau doesn't like your data. 16 data formats to avoid, 8 key rules for structuring data, and 1 video you can't miss. Check out the recording to learn about the key concepts you can utilize to prepare for your data for Tableau. Resources: •Tableau Public Workbook: public.tableau.com/app/profile/eric.parker/viz/How… •Restaurant Database Example Excel Workbook (From Walkthrough): data.world/ericparker/restaurant-database-exampleh… •Preparing Messy Crosstab Data for Tableau: onenumber.biz/blog-1/2017/9/25/preparing-crosstab-… •How to Clean Dirty Data with Tableau Prep: onenumber.biz/blog-1/2018/5/17/how-to-clean-dirty-… •8 Data Formats Tableau Doesn't Like: onenumber.biz/blog-1/2018/12/7/8-data-formats-tabl… •Fill in trailing blanks in a data set: onenumber.biz/blog-1/2019/10/10/how-to-fill-in-mis… •Here are 3 Things Tableau Prep Can’t Do (2018): onenumber.biz/blog-1/2018/6/14/answered-when-do-yo… •How to Unpivot (Transpose) Data in Tableau Prep:    • How to Unpivot (Transpose) in Tableau...   •Joins, Blends and Unions in Tableau. What's the difference? (Webinar Recording): onenumber.biz/blog-1/2018/1/17/join-blends-and-uni… •Data Blending in Tableau – How it Works and When You Need it: onenumber.biz/blog-1/2017/12/19/data-blending-in-t… •How to Validate Join Results in Tableau Desktop: onenumber.biz/blog-1/2022/4/6/how-to-validate-join… •Tableau Relationships vs. Joins Webinar Recording: onenumber.biz/blog-1/2021/12/8/tableau-relationshi… Chapters: 16 Source Data Formats to Avoid 0:00 Intro 4:30 16 Source Data Formats to Avoid 5:30 1. Multiple Values in the Same Cell 6:50 2. Dimensional Column Sections 7:35 3. Header Rows with Trailing Blanks 8:22 4. Merged Cells 8:42 5. Multiple Tables in One Sheet 9:37 6. Multiple-Row Column Names 10:21 7. Measures on Rows 11:30 8. Blank Headers and Titles in Table 12:45 9. Multiple Dimensions in the Same Cell 14:28 10. Total Rows and Columns 15:14 11. Dimension Running Across Columns 16:18 12. Duplicate Column Names 17:26 13. Sectional Row Titles 18:07 14. Pre-Writing Aggregation Calculations 19:30 15. Repeating Header Rows 20:00 16. Dates on Columns Data Vocabulary 21:32 Fact Tables 22:56 Dimension Tables 23:50 Dimensions and Measures 8 Key Rules for Structuring Data 24:40 1. First Row of Table Contains Column Names 24:58 2. Each Unique Field Gets its Own Column 25:25 3. Use Consistent Field Names Across Tables 26:14 4. No Blanks (Nulls) Unless Necessary 27:25 5. Tableau Often Functions Best When Data is Combined in a Super Table 28:25 6. Fact Tables Should be Unioned (Not Joined) 29:47 7. Dimension Tables Should be Joined (Not Unioned) 30:27 8. Mixed Tables can be Categorized as Fact Tables Walkthrough & Wrap Up 31:00 Example Data Preparation Walkthrough 40:25 Resources, Q&A