Udacity

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 with R (Udacity) Udacity
Udacity,Facebook

Data Analysis with R (Udacity)

Statistics & Data Analysis

Visually Analyze and Summarize Data Sets. Exploratory data analysis is an approach for summarizing and visualizing the important characteristics of a data set. Promoted by John Tukey, exploratory data analysis focuses on exploring data to understand the data’s underlying structure and variables, to develop intuition about the data set, to consider how that data set came into existence, and to decide how it can be investigated with more formal statistical methods.

Self Paced
Self-Paced
Statistics Data Analysis EDA
Details
Functional Programming in Scala Capstone (Coursera) Coursera
École Polytechnique Fédérale de Lausanne

Functional Programming in Scala Capstone (Coursera)

Statistics & Data Analysis Data Science

In the final capstone project you will apply the skills you learned by building a large data-intensive application using real-world data. You will implement a complete application processing several gigabytes of data. This application will show interactive visualizations of the evolution of temperatures over time all over the world.

Aug 10th 2026
5-12 Weeks
Interface Scala Interactive
Details
Firebase Analytics: Android (Udacity) Udacity
Udacity,Google

Firebase Analytics: Android (Udacity)

Statistics & Data Analysis Computer Science

Improve your apps with better user data. In this course, you’ll learn how to grow an app's user base using Firebase Analytics, a free and unlimited analytics solution. You'll be able to learn who your users are and how they interact with your app. You can then use this information to make informed decisions to improve your app, such as how difficult to make a level in a game, where to place an advertisement, or what products to stock.

Self Paced
Self-Paced
Android Analytics Android Apps
Details
Supply Chains for Manufacturing: Capacity Analytics (edX) EdX
MIT,MITx

Supply Chains for Manufacturing: Capacity Analytics (edX)

Management & Leadership Engineering

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
Manufacturing Supply Chain Principles of Manufacturing MicroMasters
Details
Applied Plotting, Charting & Data Representation in Python (Coursera) Coursera
University of Michigan

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

Statistics & Data Analysis Data Science

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
Python Data Analysis Data Science
Details
Visualization for Data Journalism (Coursera) Coursera
University of Illinois at Urbana-Champaign

Visualization for Data Journalism (Coursera)

Statistics & Data Analysis Data Science

While telling stories with data has been part of the news practice since its earliest days, it is in the midst of a renaissance. Graphics desks which used to be deemed as “the art department,” a subfield outside the work of newsrooms, are becoming a core part of newsrooms’ operation. Those people (they often have various titles: data journalists, news artists, graphic reporters, developers, etc.) who design news graphics are expected to be full-fledged journalists and work closely with reporters and editors.

Aug 10th 2026
5-12 Weeks
Python Storytelling Data Analysis
Details
Introduction to Accounting Data Analytics and Visualization (Coursera) Coursera
University of Illinois at Urbana-Champaign

Introduction to Accounting Data Analytics and Visualization (Coursera)

Statistics & Data Analysis Data Science

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
Excel Accounting Data Analysis
Details
Data Wrangling with MongoDB (Udacity) Udacity
Udacity,MongoDB University

Data Wrangling with MongoDB (Udacity)

CS: Software Engineering

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
Programming MongoDB Databases
Details
Population Health: Responsible Data Analysis (Coursera) Coursera
Leiden University

Population Health: Responsible Data Analysis (Coursera)

Statistics & Data Analysis Data Science

In most areas of health, data is being used to make important decisions. As a health population manager, you will have the opportunity to use data to answer interesting questions. In this course, we will discuss data analysis from a responsible perspective, which will help you to extract useful information from data and enlarge your knowledge about specific aspects of interest of the population.

Aug 10th 2026
4 Weeks
Data Analysis R Programming Regression Analysis
Details
Statistics (Udacity) Udacity
Udacity,San Jose State University

Statistics (Udacity)

Sci: Mathematics Statistics & Data Analysis

The Science of Decisions. We live in a time of unprecedented access to information...data. Whether researching the best school, job, or relationship, the Internet has thrown open the doors to vast pools of data. Statistics are simply objective and systematic methods for describing and interpreting information so that you may make the most informed decisions about life.

Self Paced
Self-Paced
Math Statistics Probability
Details