Cleaning and Preparing Data

Learn basic techniques for how to organize and clean data in spreadsheets in preparation for distribution and analysis. Modal  - A better way to learn technical skills.
When
October 28, 2022 - November 11, 2022
Registration closes October 27, 2022 at 12:00 PM Pacific
Subscription fee
$5,000
MORE THAN A COURSE
You get access to all of Modal's Courses for 1-year, starting on October 28, 2022.
Reimbursement
Submit a single FlexEd application for the 1-year subscription immediately after payment - no certificate of completion needed.
Additional courses are covered by the subscription fee.
Who Is This For?
Non-data professionals interested in cleaning and preparing data they’ve collected for later analysis.
Any prerequisites?
  • Familiar with data fundamentals, such as the difference between structured and unstructured data.
  • Familiar with how to read a data plan.
  • Familiar with data collection processes.
  • Knowledge of common spreadsheet tools (ex. Excel) to edit, sort, filter, validate, and manipulate data
What will I be able to do after this Course?
    Create clean, organized datasets in preparation for sharing and analysis.
    NEED HELP DECIDING?
    Book time with a learning expert.

    A Typical Week

    Monday
    Self Study
    Kick-off new topic with self-study & online learning
    • Coaches support learners hitting roadblocks
    • Manager check-in to bring learning into company context
    Tuesday
    Wednesday
    Labs
    Learning material leads into practice environment & labs
    • Coaches support learners hitting roadblocks
    • Pair programming to bring learning into company context
    • Community allows students to help each other
    Thursday
    Live Event
    Interactive live session hosted by Coaches
    • Community allows students to help each other
    • Community Groups host expert AMAs & guided community discussions
    Friday
    Projects
    Work on a weekly project
    • Community allows students to help each other
    • Group projects
    • Coaches support learners hitting roadblocks
    Saturday
    sunday
    Work at your own pace
    Expert coaching and actionable feedback from Coaches
      Modal clover loop
      This course is part of Modal's Preparing Useful Data Learning Path. Take this course individually or enroll in all three courses and take on a Capstone project.
      Course 1: Data Collection
      Learn methods for collecting useful and usable data, such as identifying potential data sources that align with a research question, selecting the right data collection method, and curating data from existing sources.
      Course 2: Representing Accurate Insights
      Differentiate between different types of bias, identify misleading statistics, and develop your own defensible experiment that mitigates the effect of bias.
      This Course: Cleaning and Preparing Data
      • Learn how to assess data organization requirements and use a variety of methods to organize your data.
      • Learn several techniques for cleaning your data and converting the results into useful formats based on stakeholder needs.
      Capstone Project
      Apply the skills you acquired on this Learning Path to solve a real-world data analysis challenge and earn your certificate.

      Why Modal?

      Projects & Practice
      Real world exercises contextualize learning in real-world context.
      On-Demand Coach Support
      You are never alone. Coaches are always present and can help you!
      Live Sessions
      Hear from guest speakers and expert instructors through engaging lectures.
      Technical Labs
      Technical Labs
      Hands-on labs allow you to play with new tools and concepts to build real skills.
      Modal Community
      Community of Peers
      You will be part of a learning community were support is abundant.
      Asynchronous Learning
      Asynchronous Learning
      Self-paced learning is scheduled for each learner, with a dashboard to help you keep on track.

      Other Courses

      “I love the quantity & quality of learning materials, the interactivity, the live sessions, the coaches, are invaluable. I can really feel the difference in the level of engagement that Modal has to every participant compared to an ordinary course."

      Modal clover colored
      - Veselina Stoyanova - Reporting Analyst, EMAG
      Need help? Contact us