Search this site
Embedded Files
Skip to main content
Skip to navigation
TEA Data Fellows Learning Hub
Home
Synchronous Webinars
Webinar 1: Data 101
Webinar 2: Data Culture
Webinar 3: Intro to Data Platforms
Webinar 4: Data Platforms Deep Dive
Webinar 5: Analyzing, Understanding, and Cleaning Data
Webinar 6: Data Cleaning, Part 2
Webinar 7: Measurement, Analysis, and Implementation Plans
Webinar 8: Descriptive and Exploratory Analysis
Webinar 9: Project Management: The RSSP Team
Webinar 10: Data Fellows Refresh
Webinar 11: Mid-Cycle Stepbacks and End-of-Cycle Improvement Reviews
Webinar 12: Preparing for the Mid-Cycle Stepback Part 1
Webinar 13: Preparing for the Mid-Cycle Stepback Part II
Webinar 14: Data Storytelling
Webinar 15: Tableau Row-Level Security
Webinar 16: Facilitating Rich Discussions
Webinar 17: Broadening Stakeholder Audiences
Webinar 18: Preparing Data for Visualization
Webinar 19: Joins and Unions
Webinar 20: Calculated Fields
Webinar 21: Case Study 1
Webinar 22: Case Study 2
Webinar 23: Implementation Data Part I
Webinar 24: Implementation Data Part II
Webinar 25: Tutoring Data Part I
Webinar 26: Tutoring Data Part II
Webinar 27: Tutoring Capacity Part I
Webinar 28: Tutoring Capacity Part II
Webinar 29: Using Data for Goal Setting
Webinar 30: Using Data for Goal Setting II
Webinar 31: The Leadership Table
Webinar 32: The Three Stages of Publishing Data
Webinar 33: Data Fellows Summer Refresh I
Webinar 34: Data Fellows Summer Refresh II
Webinar 35: Fundamentals of Survey Design
Webinar 36: Designing Survey Questions
Webinar 37: Prepping Survey Results
Webinar 38: Visualizing Survey Results
Webinar 39: Row Level Security
Webinar 40: Masking
Webinar 41: Data Exploration
Webinar 42: Data Visualization
Webinar 43: Data Modeling & Star Schema
Webinar 44: Optimizing a Data Model
Webinar 45: Calculated Metrics
Webinar 46: Advanced Calculated Metrics
Webinar 47: Dynamic Row Level Security
Webinar 48: Hierachy Row Level Security
Webinar 49: Dashboard Design
Webinar 50: Dashboard Design II
Webinar 51: User Guided Analytics
Webinar 52: Advanced Analytics
Webinar 53: User Experience
Webinar 54: Advanced User Experience
Webinar 55: Inferential Statistics
Webinar 56: Review Dashboard Buildout
Asynchronous Modules
S.M.A.R.T. Goals and Measurement Plan
Progress Monitoring
Power BI
Google Data Studio
Tableau
Excel
Data Cleaning
Change Management
Monitoring Implementation
Descriptive Analysis in Google Sheets/Excel
Project Management: Soft Skills
Data Storytelling
Hypothesis Testing Part 1
Hypothesis Testing Part II: Conducting T-Tests in Excel
Organization and Time Management
Preparing for Rocktober: Managing Stress & Preserving Relationships
Structuring Data for Visualizations
The Life of a Data Fellow
How to Clean Data Faster
Now what? Student Level Data Analysis
The Gift of Feedback
Year-End Reflection
Case Study 1: Benchmark Data
Case Study 2: Benchmark Data Part 2
Case Study 3: Implementation Data Part I
Case Study 4: Implementation Data Part II
Case Study 5: Tutoring Data Part I
Case Study 6: Tutoring Data Part II
Case Study 7: Tutoring Capacity Part I
Case Study 8: Tutoring Capacity Part II
Troy ISD
Theory of Action: Identifying and Testing Limitations
Characteristics of Effective Teams
Inter-Rater Agreement
RSSP System Archetypes
Data Fellows Feature: Carol Maitland
Survey Design
Implementation Planning with Data
Cleaning and Transforming Survey Data
Visualizing Survey Results Walkthrough
Row Level Security Walkthrough
Masking Walkthrough
Data Exploration Walkthrough
Data Visualization Walkthrough
Data Modeling & Star Schema Walkthrough
Optimizing a Data Model Walkthrough
Calculated Metrics Walkthrough
Advanced Calculated Metrics Walkthrough
Dynamic Row Level Security Walkthrough
Hierarchy Row Level Security Walkthrough
Dashboard Design Walkthrough
Dashboard Design II Walkthrough
User Guided Analytics Walkthrough
Advanced Analytics Walkthrough
User Experience Walkthrough
Advanced User Experience Walkthrough
Inferential Statistics Walkthrough
Dashboard Buildout Walkthrough
Communities of Practice
Office Hours
Resource Library
TEA Data Fellows Learning Hub
Home
Synchronous Webinars
Webinar 1: Data 101
Webinar 2: Data Culture
Webinar 3: Intro to Data Platforms
Webinar 4: Data Platforms Deep Dive
Webinar 5: Analyzing, Understanding, and Cleaning Data
Webinar 6: Data Cleaning, Part 2
Webinar 7: Measurement, Analysis, and Implementation Plans
Webinar 8: Descriptive and Exploratory Analysis
Webinar 9: Project Management: The RSSP Team
Webinar 10: Data Fellows Refresh
Webinar 11: Mid-Cycle Stepbacks and End-of-Cycle Improvement Reviews
Webinar 12: Preparing for the Mid-Cycle Stepback Part 1
Webinar 13: Preparing for the Mid-Cycle Stepback Part II
Webinar 14: Data Storytelling
Webinar 15: Tableau Row-Level Security
Webinar 16: Facilitating Rich Discussions
Webinar 17: Broadening Stakeholder Audiences
Webinar 18: Preparing Data for Visualization
Webinar 19: Joins and Unions
Webinar 20: Calculated Fields
Webinar 21: Case Study 1
Webinar 22: Case Study 2
Webinar 23: Implementation Data Part I
Webinar 24: Implementation Data Part II
Webinar 25: Tutoring Data Part I
Webinar 26: Tutoring Data Part II
Webinar 27: Tutoring Capacity Part I
Webinar 28: Tutoring Capacity Part II
Webinar 29: Using Data for Goal Setting
Webinar 30: Using Data for Goal Setting II
Webinar 31: The Leadership Table
Webinar 32: The Three Stages of Publishing Data
Webinar 33: Data Fellows Summer Refresh I
Webinar 34: Data Fellows Summer Refresh II
Webinar 35: Fundamentals of Survey Design
Webinar 36: Designing Survey Questions
Webinar 37: Prepping Survey Results
Webinar 38: Visualizing Survey Results
Webinar 39: Row Level Security
Webinar 40: Masking
Webinar 41: Data Exploration
Webinar 42: Data Visualization
Webinar 43: Data Modeling & Star Schema
Webinar 44: Optimizing a Data Model
Webinar 45: Calculated Metrics
Webinar 46: Advanced Calculated Metrics
Webinar 47: Dynamic Row Level Security
Webinar 48: Hierachy Row Level Security
Webinar 49: Dashboard Design
Webinar 50: Dashboard Design II
Webinar 51: User Guided Analytics
Webinar 52: Advanced Analytics
Webinar 53: User Experience
Webinar 54: Advanced User Experience
Webinar 55: Inferential Statistics
Webinar 56: Review Dashboard Buildout
Asynchronous Modules
S.M.A.R.T. Goals and Measurement Plan
Progress Monitoring
Power BI
Google Data Studio
Tableau
Excel
Data Cleaning
Change Management
Monitoring Implementation
Descriptive Analysis in Google Sheets/Excel
Project Management: Soft Skills
Data Storytelling
Hypothesis Testing Part 1
Hypothesis Testing Part II: Conducting T-Tests in Excel
Organization and Time Management
Preparing for Rocktober: Managing Stress & Preserving Relationships
Structuring Data for Visualizations
The Life of a Data Fellow
How to Clean Data Faster
Now what? Student Level Data Analysis
The Gift of Feedback
Year-End Reflection
Case Study 1: Benchmark Data
Case Study 2: Benchmark Data Part 2
Case Study 3: Implementation Data Part I
Case Study 4: Implementation Data Part II
Case Study 5: Tutoring Data Part I
Case Study 6: Tutoring Data Part II
Case Study 7: Tutoring Capacity Part I
Case Study 8: Tutoring Capacity Part II
Troy ISD
Theory of Action: Identifying and Testing Limitations
Characteristics of Effective Teams
Inter-Rater Agreement
RSSP System Archetypes
Data Fellows Feature: Carol Maitland
Survey Design
Implementation Planning with Data
Cleaning and Transforming Survey Data
Visualizing Survey Results Walkthrough
Row Level Security Walkthrough
Masking Walkthrough
Data Exploration Walkthrough
Data Visualization Walkthrough
Data Modeling & Star Schema Walkthrough
Optimizing a Data Model Walkthrough
Calculated Metrics Walkthrough
Advanced Calculated Metrics Walkthrough
Dynamic Row Level Security Walkthrough
Hierarchy Row Level Security Walkthrough
Dashboard Design Walkthrough
Dashboard Design II Walkthrough
User Guided Analytics Walkthrough
Advanced Analytics Walkthrough
User Experience Walkthrough
Advanced User Experience Walkthrough
Inferential Statistics Walkthrough
Dashboard Buildout Walkthrough
Communities of Practice
Office Hours
Resource Library
More
Home
Synchronous Webinars
Webinar 1: Data 101
Webinar 2: Data Culture
Webinar 3: Intro to Data Platforms
Webinar 4: Data Platforms Deep Dive
Webinar 5: Analyzing, Understanding, and Cleaning Data
Webinar 6: Data Cleaning, Part 2
Webinar 7: Measurement, Analysis, and Implementation Plans
Webinar 8: Descriptive and Exploratory Analysis
Webinar 9: Project Management: The RSSP Team
Webinar 10: Data Fellows Refresh
Webinar 11: Mid-Cycle Stepbacks and End-of-Cycle Improvement Reviews
Webinar 12: Preparing for the Mid-Cycle Stepback Part 1
Webinar 13: Preparing for the Mid-Cycle Stepback Part II
Webinar 14: Data Storytelling
Webinar 15: Tableau Row-Level Security
Webinar 16: Facilitating Rich Discussions
Webinar 17: Broadening Stakeholder Audiences
Webinar 18: Preparing Data for Visualization
Webinar 19: Joins and Unions
Webinar 20: Calculated Fields
Webinar 21: Case Study 1
Webinar 22: Case Study 2
Webinar 23: Implementation Data Part I
Webinar 24: Implementation Data Part II
Webinar 25: Tutoring Data Part I
Webinar 26: Tutoring Data Part II
Webinar 27: Tutoring Capacity Part I
Webinar 28: Tutoring Capacity Part II
Webinar 29: Using Data for Goal Setting
Webinar 30: Using Data for Goal Setting II
Webinar 31: The Leadership Table
Webinar 32: The Three Stages of Publishing Data
Webinar 33: Data Fellows Summer Refresh I
Webinar 34: Data Fellows Summer Refresh II
Webinar 35: Fundamentals of Survey Design
Webinar 36: Designing Survey Questions
Webinar 37: Prepping Survey Results
Webinar 38: Visualizing Survey Results
Webinar 39: Row Level Security
Webinar 40: Masking
Webinar 41: Data Exploration
Webinar 42: Data Visualization
Webinar 43: Data Modeling & Star Schema
Webinar 44: Optimizing a Data Model
Webinar 45: Calculated Metrics
Webinar 46: Advanced Calculated Metrics
Webinar 47: Dynamic Row Level Security
Webinar 48: Hierachy Row Level Security
Webinar 49: Dashboard Design
Webinar 50: Dashboard Design II
Webinar 51: User Guided Analytics
Webinar 52: Advanced Analytics
Webinar 53: User Experience
Webinar 54: Advanced User Experience
Webinar 55: Inferential Statistics
Webinar 56: Review Dashboard Buildout
Asynchronous Modules
S.M.A.R.T. Goals and Measurement Plan
Progress Monitoring
Power BI
Google Data Studio
Tableau
Excel
Data Cleaning
Change Management
Monitoring Implementation
Descriptive Analysis in Google Sheets/Excel
Project Management: Soft Skills
Data Storytelling
Hypothesis Testing Part 1
Hypothesis Testing Part II: Conducting T-Tests in Excel
Organization and Time Management
Preparing for Rocktober: Managing Stress & Preserving Relationships
Structuring Data for Visualizations
The Life of a Data Fellow
How to Clean Data Faster
Now what? Student Level Data Analysis
The Gift of Feedback
Year-End Reflection
Case Study 1: Benchmark Data
Case Study 2: Benchmark Data Part 2
Case Study 3: Implementation Data Part I
Case Study 4: Implementation Data Part II
Case Study 5: Tutoring Data Part I
Case Study 6: Tutoring Data Part II
Case Study 7: Tutoring Capacity Part I
Case Study 8: Tutoring Capacity Part II
Troy ISD
Theory of Action: Identifying and Testing Limitations
Characteristics of Effective Teams
Inter-Rater Agreement
RSSP System Archetypes
Data Fellows Feature: Carol Maitland
Survey Design
Implementation Planning with Data
Cleaning and Transforming Survey Data
Visualizing Survey Results Walkthrough
Row Level Security Walkthrough
Masking Walkthrough
Data Exploration Walkthrough
Data Visualization Walkthrough
Data Modeling & Star Schema Walkthrough
Optimizing a Data Model Walkthrough
Calculated Metrics Walkthrough
Advanced Calculated Metrics Walkthrough
Dynamic Row Level Security Walkthrough
Hierarchy Row Level Security Walkthrough
Dashboard Design Walkthrough
Dashboard Design II Walkthrough
User Guided Analytics Walkthrough
Advanced Analytics Walkthrough
User Experience Walkthrough
Advanced User Experience Walkthrough
Inferential Statistics Walkthrough
Dashboard Buildout Walkthrough
Communities of Practice
Office Hours
Resource Library
Webinar
6
:
Data Cleaning, Part 2
Synchronous Webinar 6 - Data Prep, Part 2
Slides
Webinar 6 Recording.mp4
Recording
Webinar 6: Data Cleaning and Prep, Part 2
Note Catcher
Resources
Joining Practice
Joining Practice Data Set
Connecting and Combining Data Resources
Connecting and Combining Data Resources
Exit Ticket
Report abuse
Page details
Page updated
Report abuse
