Brief Introduction
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 prograCourse Summary
This course teaches how to create an analytical dataset by combining data from multiple sources, cleaning and transforming it, and performing statistical analysis to generate insights.Key Learning Points
- Learn how to combine and clean data from multiple sources
- Transform data using SQL and Python
- Perform statistical analysis and generate insights
Related Topics for further study
Learning Outcomes
- Create a clean and transformed analytical dataset
- Perform statistical analysis and generate insights
- Apply SQL and Python to data transformation
Prerequisites or good to have knowledge before taking this course
- Basic knowledge of SQL
- Familiarity with Python
Course Difficulty Level
IntermediateCourse Format
- Self-paced
- Online
Similar Courses
- Data Wrangling with MongoDB
- Data Cleaning with Python
Related Education Paths
Related Books
Description
Learn how to prepare data to ensure the efficacy of your analysis while improving fluency in Alteryx.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.
Knowledge
- Instructor videosLearn by doing exercisesTaught by industry professionals
Outline
- 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
Summary of User Reviews
Learn how to create an analytical dataset with Udacity's online course. Students praise the course for its comprehensive coverage and hands-on approach to learning.Key Aspect Users Liked About This Course
Hands-on approach to learningPros from User Reviews
- Comprehensive coverage of creating analytical datasets
- Interactive exercises and projects for practical application
- Experienced instructors with industry knowledge
- Flexible schedule and self-paced learning
- Great value for the price
Cons from User Reviews
- Requires prior knowledge of programming
- May be too basic for experienced data analysts
- Limited interaction with instructors
- No option for live sessions or group projects
Data Visualization Techniques
- 3.3
-
![]()
![]()
![]()
![]()
![]()
Gain hands-on experience in creating effective visualizations This course will focus on building a variety of data visualizations using multiple tools and...
Databases: Relational Databases and SQL
- 0.0
-
![]()
![]()
![]()
![]()
![]()
This course is one of five self-paced courses on the topic of Databases, originating as one of Stanford's three inaugural massive open online courses released in the fall of 2011....
Designing A Successful Social Media Feed!
- 4.7
-
![]()
![]()
![]()
![]()
![]()
4 Principles of Design That Can Transform Your Content and Focus. This course borrows four timeless principles from Visual Design to totally transform your Social Media strategy!...
Geographical Information Systems - Part 1
- 3.6
-
![]()
![]()
![]()
![]()
![]()
This course is organized into two parts presenting the theoretical and practical foundations of geographic information systems (GIS). In particular, you will learn:...
