About this Course

The Creating an Analytical Dataset course provides students with foundational knowledge to input, clean, blend, and format data in preparation for analysis. You will learn:

  • The common sources and types of data
  • To identify and correct common issues with data
  • To format data in useful ways for analysis
  • To blend data from multiple sources together

    Throughout this course you’ll also learn the techniques to apply your knowledge in a data analytics program called Alteryx. At the end of the course, you’ll complete a project based on the principles in the course..

    This course is part of the Business Analyst Nanodegree.

  • Course Cost
    Free
    Timeline
    Approx. 2 weeks
    Skill Level
    Beginner
    Included in Course
    • Icon course 01 3edf6b45629a2e8f1b490e1fb1516899e98b3b30db721466e83b1a1c16e237b1 Rich Learning Content

    • Icon course 04 2edd94a12ef9e5f0ebe04f6c9f6ae2c89e5efba5fd0b703c60f65837f8b54430 Interactive Quizzes

    • Icon course 02 2d90171a3a467a7d4613c7c615f15093d7402c66f2cf9a5ab4bcf11a4958aa33 Taught by Industry Pros

    • Icon course 05 237542f88ede3178ac4845d4bebf431ddd36d9c3c35aedfbd92e148c1c7361c6 Self-Paced Learning

    • Icon course 03 142f0532acf4fa030d680f5cb3babed8007e9ac853d0a3bf731fa30a7869db3a Student Support Community

    Join the Path to Greatness

    This free course is your first step towards a new career with the Predictive Analytics for Business Nanodegree Program.

    Free Course

    Creating an Analytical Dataset

    by Alteryx

    Enhance your skill set and boost your hirability through innovative, independent learning.

    Icon steps 54aa753742d05d598baf005f2bb1b5bb6339a7d544b84089a1eee6acd5a8543d

    Course Leads

    • Maureen Wolfson
      Maureen Wolfson

      Instructor

    What You Will Learn

    Lesson 1

    Understanding Data

    • Learn to identify structured, unstructured, and semistructured data.
    • Get an introduction to the most common data types.
    • Learn about the most common sources of data.
    Lesson 1

    Understanding Data

    • Learn to identify structured, unstructured, and semistructured data.
    • Get an introduction to the most common data types.
    • Learn about the most common sources of data.
    Lesson 2

    Data Issues

    • Learn to clean dirty data.
    • Learn to how to adjust for missing data.
    • Be able to identify and correct outliers.
    Lesson 2

    Data Issues

    • Learn to clean dirty data.
    • Learn to how to adjust for missing data.
    • Be able to identify and correct outliers.
    Lesson 3

    Data Formatting

    • Learn about the importance of data format for analysis.
    • Transpose, aggregate, and cross tabulate data.
    • Learn how to use parse data.
    Lesson 3

    Data Formatting

    • Learn about the importance of data format for analysis.
    • Transpose, aggregate, and cross tabulate data.
    • Learn how to use parse data.
    Lesson 4

    Data Blending

    • Learn how to merge data from multiple sources.
    • Learn to use common data blending techniques.
    • Explore fuzzy matching and spatial analysis
    Lesson 4

    Data Blending

    • Learn how to merge data from multiple sources.
    • Learn to use common data blending techniques.
    • Explore fuzzy matching and spatial analysis

    Prerequisites and Requirements

  • No programming experience required
  • Interested in using data to make better business decisions
  • Alteryx license (provided to nanodegree students at no cost, compatible with Windows only)

    See the Technology Requirements for using Udacity.

  • Why Take This Course

    Ever heard of the term garbage in, garbage out? This is as true in analytics as it is anywhere else. In this course, you’ll learn how to prepare data to ensure the efficacy of your analysis, a foundational skill for anyone using advanced analytics. You'll learn this through improving your fluency in Alteryx, a data analytics tool that enables you prepare, blend, and analyze data quickly. This course is ideal for anyone who is interested in pursuing a career in business analysis, but lacks programming experience.

    What do I get?
    • Instructor videos
    • Learn by doing exercises
    • Taught by industry professionals
    Icon globe e82eae5d45465aba4fbe4bb746905ce55dc3324f310b79c60e4a20089057d347

    Udacity 现已提供中文版本! A Udacity tem uma página em português para você! There's a local version of Udacity for you!

    前往优达学城中文网站 Ir para a página brasileira Go to Indian Site or continue to Global Site