Open Data Tank Workshops

The Analytics Process Model

  • The Analytics Process Model
  • Applying the Analytics Process Model to Small Analyses

Understand the Organization and Define the Problem

  • Understanding the Organization Overview
  • The Importance of Understanding the Organization
  • Defining the Organization’s Objectives
  • Exercise: Defining Organizational Objectives
  • Assessing Your Research Audience
  • Translating Research Audience Needs into Analyses Requirements
  • The “Decision Problem” vs. the “Research Problem”

Descriptive Research: Surveys

  • Parts of a Survey
  • Survey Objective
  • Open-Ended/Closed-Ended Questions
  • Survey Design
  • Levels of Measurement
  • Determining Scales
  • Sources of Possible Survey Error
  • Increasing the Response Rate
  • Electronic Survey Tools

Sampling

  • Sampling Terminology and Definitions
  • Sampling Overview
  • Sample Size Calculation
  • Sampling Techniques
  • Sources of Sampling Errors

Exploratory Research: Secondary Data

  • Secondary Data Overview
  • Internal Secondary Data
  • External Secondary Data
  • Advantages and Disadvantages of Secondary Data
  • Data Integrity and the Internet

Exploratory Research: Interviews

  • Overview of Interviews
  • Types of Interviews
  • Interview Preparation
  • The Interview Guide
  • Professionalism
  • Recording the Interview

Descriptive Research: Surveys

  • Parts of a Survey
  • Survey Objective
  • Open-Ended/Closed-Ended Questions
  • Survey Design
  • Levels of Measurement
  • Determining Scales
  • Sources of Possible Survey Error
  • Increasing the Response Rate
  • Electronic Survey Tools

Research Designs and Data Collection Methods

  • Research Designs
  • Overview of Primary and Secondary Data Collection Methods
  • Developing a Hypothesis
  • Linking Analytical Objectives to Organizational Objectives

Planning the Data Collection Project

  • Advantages of Planning
  • The Project Charter
  • The Components of the Project Charter

Research Designs and Data Collection Methods

  • Research Designs
  • Overview of Primary and Secondary Data Collection Methods
  • Developing a Hypothesis
  • Linking Analytical Objectives to Organizational Objectives

Planning the Data Collection Project

  • Advantages of Planning
  • The Project Charter
  • The Components of the Project Charter

Exploratory Data Analysis

  • Exploratory Data Analysis
  • Analysis Toolpak Descriptive Statistics
  • Data Description Report

Preparing the Data

  • Data Definition Files
  • Assessing Data Quality
  • Identifying and Handling Missing Data
  • Applying “Business Rules” to Data Quality
  • More Data Preparation Techniques
  • Documenting Assumptions and Rationale for Data Selection.