Welcome to Data Wrangling for Business. This course will cover data wrangling principles and techniques for business. Key topics include data extraction, profiling, cleansing, integration, transformation, and automating data processes for business purposes. In the course, you will apply principles and techniques using data transformation tools, programming languages, and data process automation tools. The course offers you an opportunity to learn how to embed appropriate communication mechanisms for collaboration to identify and resolve real-world data challenges revealed in datasets and business processes, creating business value in today’s disparate computing and dynamic business environment.
了解顶级公司的员工如何掌握热门技能

该课程共有7个模块
In this module, you will learn about the structure of relational databases and how to use SQL queries for information retrieval, focusing on single-row and group functions. In the next module, you will build upon this foundation by exploring data manipulation and data joining techniques.
涵盖的内容
7个视频16篇阅读材料1个作业
7个视频•总计20分钟
- Course Overview•3分钟
- Meet Your Faculty•2分钟
- Relational Database Data Structure•3分钟
- Unique Values•3分钟
- Constraints•5分钟
- Working with Text Values•2分钟
- TIMESTAMP•3分钟
16篇阅读材料•总计67分钟
- Course Introduction•2分钟
- Syllabus - Data Wrangling for Business•10分钟
- Academic Integrity•1分钟
- Data Wrangling Key Questions & Steps•2分钟
- Relational Databases•1分钟
- Go to Canvas•1分钟
- Key SQL Concepts•5分钟
- Overview of Predefined Functions •2分钟
- Single-Row vs. Group Functions•10分钟
- Overview of Single-Row Functions•2分钟
- Uses of Single-Row Functions•4分钟
- Single-Row Function Example•10分钟
- Overview of Group Functions•2分钟
- Uses of Group Functions•4分钟
- Group Function Example•10分钟
- Go to Canvas•1分钟
1个作业•总计30分钟
- Module 1 Quiz•30分钟
The module also highlights how effective data manipulation and joining contribute to the broader goals of data wrangling and preparation, ensuring that data is both well-organized and ready for analysis.
涵盖的内容
14篇阅读材料1个作业
14篇阅读材料•总计113分钟
- Data Manipulation Overview•3分钟
- INSERT•4分钟
- Update•5分钟
- Delete•10分钟
- TCL Core Operations•10分钟
- Summary Table•10分钟
- Data Joining Overview•10分钟
- Data Joining Types Overview•10分钟
- Inner Join•10分钟
- Left Join•10分钟
- Right Join•10分钟
- Full Outer Join•10分钟
- Cross Join•10分钟
- Go to Canvas•1分钟
1个作业•总计45分钟
- Module 2 Quiz•45分钟
In this module, you will learn how to explore datasets using Python. You’ll practice techniques to inspect dataset structure (rows, columns, and data types), and detect missing, invalid, or inconsistent data. You will also learn how to generate descriptive statistics and distribution summaries, as well as interpret profiling results to guide data cleansing and improve overall data quality.
涵盖的内容
2个视频16篇阅读材料1个作业
2个视频•总计6分钟
- Data Profiling•3分钟
- Data Profiling Example•3分钟
16篇阅读材料•总计82分钟
- Go to Canvas•1分钟
- Data Profiling Overview•10分钟
- Discovering Data Structure Overview•2分钟
- Rows and Columns•7分钟
- Data Type•7分钟
- Non-Null Entries•7分钟
- Discovering Data Structure Example•10分钟
- Discovering Data Content Overview•3分钟
- Summary Statistics•4分钟
- Descriptive Statistics•4分钟
- Frequency Distribution•4分钟
- Missing Values•3分钟
- Duplicate Data•3分钟
- Incorrect or Ambiguous Data•4分钟
- Discovering Data Content Example•10分钟
- Data Profiling•3分钟
1个作业•总计30分钟
- Module 3 Quiz•30分钟
By the end of this module, you will be able to apply practical data cleansing techniques to improve data quality and make your analysis more accurate and trustworthy.
涵盖的内容
2个视频12篇阅读材料1个作业
2个视频•总计3分钟
- Data Cleansing•1分钟
- Data Cleansing to Handle Outliers•2分钟
12篇阅读材料•总计32分钟
- Data Cleansing Overview•2分钟
- Go to Canvas•1分钟
- Overview of Types of Data Issues•2分钟
- Missing Values•3分钟
- Duplicates•3分钟
- Inconsistent Formats•3分钟
- Outliers and Anomalies•3分钟
- Incorrect or Invalid Values•3分钟
- Data Types Conversions•3分钟
- Filtering•3分钟
- Data Cleansing Example•2分钟
- Practice: Data Profiling and Cleansing•4分钟
1个作业•总计30分钟
- Module 4 Quiz•30分钟
In this module, you will learn how to transform raw data into clean, structured datasets that are ready to be linked with other relevant data for enrichment. To perform these tasks, you will continue your work with Python and explore later in upcoming modules, tools like Alteryx to enhance your data preparation and enrichment workflow.
涵盖的内容
2个视频12篇阅读材料1个作业
2个视频•总计5分钟
- Data Transformation•2分钟
- Data Enrichment Example•3分钟
12篇阅读材料•总计82分钟
- Data Transformation Overview•1分钟
- Converting Data Types•4分钟
- Converting Units of Measurement•4分钟
- Mapping Data Values•10分钟
- Splitting Data Values•10分钟
- Data Enrichment Overview•2分钟
- Data Unions•10分钟
- Data Joins•10分钟
- Derivation of New Values•10分钟
- Errors and Exceptions Overview•10分钟
- Handling Errors and Exceptions•10分钟
- Go to Canvas•1分钟
1个作业•总计30分钟
- Module 5 Quiz•30分钟
This module emphasizes techniques for gathering, integrating, and transforming data from diverse sources. Hands-on exercises focus on automating data extraction from webpages and processing textual data, enabling the conversion of raw, unstructured information into structured, analyzable formats. By applying these methods, participants learn to create unified datasets that are ready for deeper analysis and the generation of meaningful insights.
涵盖的内容
1个视频17篇阅读材料1个作业
1个视频•总计2分钟
- Do Businesses Need to Automate Web Data Collection?•2分钟
17篇阅读材料•总计137分钟
- What is Data Integration?•3分钟
- What is Unstructured Text Data?•3分钟
- Common Transformation Techniques•4分钟
- Go to Canvas•1分钟
- Web Scraping Overview•2分钟
- Go to Canvas•1分钟
- Beautiful Soup Overview•3分钟
- Other Beautiful Soup Find Methods•3分钟
- Go to Canvas•1分钟
- Beautiful Soup Function Example•90分钟
- Go to Canvas•1分钟
- Transforming Unstructured Text Data•10分钟
- Natural Language Toolkit (NLTK)•3分钟
- Tokenization: Breaking Text Into Words•3分钟
- Removing Stopwords to Reduce Noise•4分钟
- Normalizing Words with Lemmatization•3分钟
- Result of Text Transformation•2分钟
1个作业•总计30分钟
- Module 6 Quiz•30分钟
In this module, you will learn how to use the industry automation tool, Alteryx, to automate the processes of data transformation and data integration. This skill will help you in your professional career to ease and expedite data processing.
涵盖的内容
5篇阅读材料1个作业
5篇阅读材料•总计101分钟
- Data Wrangling Using Automation Tools•4分钟
- Alteryx for Automation•4分钟
- Go to Canvas•1分钟
- Example Using Alteryx •90分钟
- Congratulations! •2分钟
1个作业•总计30分钟
- Module 7 Quiz•30分钟
位教师

提供方

提供方

Founded in 1898, Northeastern is a global research university with a distinctive, experience-driven approach to education and discovery. The university is a leader in experiential learning, powered by the world’s most far-reaching cooperative education program. The spirit of collaboration guides a use-inspired research enterprise focused on solving global challenges in health, security, and sustainability.
从 Data Analysis 浏览更多内容
NNortheastern University
课程
类别:预览预览类别:提供的学分提供的学分
UUniversity of Colorado Boulder
课程
状态:免费试用免费试用类别:提供的学分提供的学分
UUniversity of Colorado Boulder
课程
状态:免费试用免费试用类别:提供的学分提供的学分
EEdureka
课程
类别:预览预览类别:提供的学分提供的学分
人们为什么选择 Coursera 来帮助自己实现职业发展

Felipe M.

Jennifer J.

Larry W.

Chaitanya A.
常见问题
To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. You can try a Free Trial instead, or apply for Financial Aid. The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.
When you purchase a Certificate you get access to all course materials, including graded assignments. Upon completing the course, your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile.
Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.
更多问题
提供助学金,



