YoVDO

Creating an Analytical Dataset

Offered By: Udacity

Tags

Business Intelligence Courses Data Analysis Courses Business Analysis Courses Alteryx Courses Data Cleaning Courses Spatial Analysis Courses Structured Data Courses Unstructured Data Courses Data Formatting Courses

Course Description

Overview

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.


    • Syllabus

    • 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.
    • Data Issues
      • Learn to clean dirty data.,Learn to how to adjust for missing data.,Be able to identify and correct outliers.
    • Data Formatting
      • Learn about the importance of data format for analysis.,Transpose, aggregate, and cross tabulate data.,Learn how to use parse data.
    • Data Blending
      • Learn how to merge data from multiple sources.,Learn to use common data blending techniques.,Explore fuzzy matching and spatial analysis

    Taught by

    Maureen Wolfson

    Related Courses

    مهارات برنامج Excel للعمل: المبادئ الأساسية
    Macquarie University via Coursera     Everyday Excel, Part 1
    University of Colorado Boulder via Coursera     Financial Forecasting in Python
    DataCamp     Microsoft Excel Mastery: From Beginner to Pro
    Udemy     Curso de Excel Online Completo: De Básico a Profesional
    Udemy