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
Advanced SQL : SQL Expert Certification Preparation Course
- 4.5
-
![]()
![]()
![]()
![]()
![]()
Complete Your Oracle SQL Knowledge From Intermediate to Advanced Level and Become a Database SQL Expert in Oracle! "One", "Enough", "Ultimate" Course to make you an "SQL Expert!"....
Applied Machine Learning in Python
- 4.6
-
![]()
![]()
![]()
![]()
![]()
This course will introduce the learner to applied machine learning, focusing more on the techniques and methods than on the statistics behind these methods....
A Business Approach to Sustainable Landscape Restoration
- 4.7
-
![]()
![]()
![]()
![]()
![]()
Integrated landscape management and large-scale landscape restoration should be in every company’s business strategy because in order to reach the Sustainable Development Goal on Land Degradation Neutrality (SDG Number 15....
Google Data Analytics Capstone: Complete a Case Study
- 4.8
-
![]()
![]()
![]()
![]()
![]()
This course is the eighth course in the Google Data Analytics Certificate. Case studies are commonly used by employers to assess analytical skills....
