Creating an Analytical Dataset (Udacity)

Offered by Udacity, Alteryx,
Creating an Analytical Dataset (Udacity)

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

Class Deals by MOOC List - Click here and see Udacity's Active Discounts, Deals, and Promo Codes.

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..
Udacity's Intro to Programming is your first step towards careers in Web and App Development, Machine Learning, Data Science, AI, and more! This program is perfect for beginners.
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.
This course is part of the Business Analyst Nanodegree Program.

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 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 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)
Go to Class
MOOC List is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Related Courses

Data Analysis and Visualization (Udacity) Udacity
Georgia Institute of Technology,Udacity

Data Analysis and Visualization (Udacity)

Data and visual analytics is an emerging field concerned with analyzing, modeling, and visualizing complex high dimensional data. This course will introduce students to the field by covering state­-of-­the-art modeling, analysis and visualization techniques. It will emphasize practical challenges involving complex real world data and include several case studies and hands-on work with the R programming language.

Self Paced
Self-Paced
Applied Plotting, Charting & Data Representation in Python (Coursera) Coursera
University of Michigan

Applied Plotting, Charting & Data Representation in Python (Coursera)

This course will introduce the learner to information visualization basics, with a focus on reporting and charting using the matplotlib library. The course will start with a design and information literacy perspective, touching on what makes a good and bad visualization, and what statistical measures translate into in terms of visualizations. The second week will focus on the technology used to make visualizations in python, matplotlib, and introduce users to best practices when creating basic charts and how to realize design decisions in the framework.

Aug 10th 2026
4 Weeks
Spatial Data Science and Applications (Coursera) Coursera
Yonsei University

Spatial Data Science and Applications (Coursera)

Spatial (map) is considered as a core infrastructure of modern IT world, which is substantiated by business transactions of major IT companies such as Apple, Google, Microsoft, Amazon, Intel, and Uber, and even motor companies such as Audi, BMW, and Mercedes. Consequently, they are bound to hire more and more spatial data scientists. Based on such business trend, this course is designed to present a firm understanding of spatial data science to the learners, who would have a basic knowledge of data science and data analysis, and eventually to make their expertise differentiated from other nominal data scientists and data analysts.

Aug 10th 2026
5-12 Weeks
Supply Chains for Manufacturing: Capacity Analytics (edX) EdX
MIT,MITx

Supply Chains for Manufacturing: Capacity Analytics (edX)

Learn about various models, methods and software tools to help make better decisions for system design in manufacturing systems and supply chains. You will learn about frameworks and models for structuring key system design issues and trade-offs that arise in today’s supply chains and manufacturing systems.

Aug 11th 2026
5-12 Weeks
Segmentation and Clustering (Udacity) Udacity
Udacity

Segmentation and Clustering (Udacity)

Use machine learning to create segments. The Segmentation and Clustering course provides students with the foundational knowledge to build and apply clustering models to develop more sophisticated segmentation in business contexts. In this course, you'll learn how to use an advanced analytical method called clustering to create useful segments for business contexts, whether its stores, customers, geographies, etc. You'll learn this through improving your fluency in Alteryx, a data analytics tool that enables you prepare, blend, and analyze data quickly.

Self Paced
Self-Paced
Introduction to Accounting Data Analytics and Visualization (Coursera) Coursera
University of Illinois at Urbana-Champaign

Introduction to Accounting Data Analytics and Visualization (Coursera)

Accounting has always been about analytical thinking. From the earliest days of the profession, Luca Pacioli emphasized the importance of math and order for analyzing business transactions. The skillset that accountants have needed to perform math and to keep order has evolved from pencil and paper, to typewriters and calculators, then to spreadsheets and accounting software. A new skillset that is becoming more important for nearly every aspect of business is that of big data analytics: analyzing large amounts of data to find actionable insights. This course is designed to help accounting students develop an analytical mindset and prepare them to use data analytic programming languages like Python and R.

Aug 10th 2026
5-12 Weeks
Big Data Analytics in Healthcare (Udacity) Udacity
Georgia Institute of Technology,Udacity

Big Data Analytics in Healthcare (Udacity)

Data science plays an important role in many industries. In facing massive amount of heterogeneous data, scalable machine learning and data mining algorithms and systems become extremely important for data scientists. The growth of volume, complexity and speed in data drives the need for scalable data analytic algorithms and systems. In this course, we study such algorithms and systems in the context of healthcare applications.

Self Paced
Self-Paced
Data Wrangling with MongoDB (Udacity) Udacity
Udacity,MongoDB University

Data Wrangling with MongoDB (Udacity)

In this course, we will explore how to wrangle data from diverse sources and shape it to enable data-driven applications. Some data scientists spend the bulk of their time doing this! Students will learn how to gather and extract data from widely used data formats. They will learn how to assess the quality of data and explore best practices for data cleaning. We will also introduce students to MongoDB, covering the essentials of storing data and the MongoDB query language together with exploratory analysis using the MongoDB aggregation framework.

Self Paced
Self-Paced
Data Visualization in Tableau (Udacity) Udacity
Udacity

Data Visualization in Tableau (Udacity)

Learn the fundamentals of data visualization and practice communicating with data. This course covers how to apply design principles, human perception, color theory, and effective storytelling with data. If you present data to others, aspire to be a business analyst or data scientist, or if you’d like to become more effective with visualization tools, then you can grow your skills with this course.

Self Paced
Self-Paced
Introduction to Neurohacking In R (Coursera) Coursera
Johns Hopkins University

Introduction to Neurohacking In R (Coursera)

Neurohacking describes how to use the R programming language and its associated package to perform manipulation, processing, and analysis of neuroimaging data. We focus on publicly-available structural magnetic resonance imaging (MRI). We discuss concepts such as inhomogeneity correction, image registration, and image visualization.

Aug 10th 2026
4 Weeks