【2022年】十大資料清理課程熱門排行推薦與優惠精選！

課程介紹

Analyst from time to time may need to analyze small datasets from larger datasets that may exist in other applications or other forms of storage for very quick results.

Excel has proven to be a very reliable support analytical tool in this regard ,

…瞭解更多細節

哪些人適合這堂課？

• Analysts, who want a quick start in excel data cleaning
• Consultants
• Marketing professionals
• Bankers
• Accountants
• Anybody who wants a quick start to some essential excel data cleaning concepts and techniques

學習目標

• How to detect and fix errors in datasets imported into Excel for analysis
• How to categorize and fix errors in the different data types in excel using basic to advanced excel functions
• Different concepts and techniques used in excel data cleaning

課程介紹

Praise for Todd’s coaching and consulting…

Todd, you are amazing! I appreciate your editing services! The 1st line on my AQR review is “congrats for a strong 1st submission”. I actually had no dings on my grammar etc. (Doctoral Candidate, Arizona)

…瞭解更多細節

哪些人適合這堂課？

• Doctoral Students
• Early Career Researchers
• Undergraduate and Master’s Students Who Are Beginning to Conduct Independent Research

學習目標

• Why it is important to have a properly formatted questionnaire
• Nuances of different types of data collection – paper, online, archival, 3rd party, institutional, agency
• How to properly and accurately clean data in SPSS and Excel
• How and why to report the data cleaning process

課程介紹

One of the most essential aspects of Data Science or Machine Learning is Data Cleaning. In order to get the most out of the data, your data must be clean as uncleaned data can make it harder for you to train ML models. In regard to ML & Data Science,

…瞭解更多細節

哪些人適合這堂課？

• Students who want to learn the basics of Data Cleaning

學習目標

• Professional ways for handling the data
• Learn Standard visualization techniques like Histograms, Scatterplots etc
• How to locate discrepancies, and deal with issues

課程介紹

In this course, you’ll walk through Trifacta *basics step by step. We’ll take you through not only how to use **Trifacta and its transforms and functions, but also what common pitfalls you might encounter along the way while cleaning data. You’ll see

…瞭解更多細節

哪些人適合這堂課？

• You, if you are brand new to data cleaning
• You, if you are brand new to using Trifacta software

學習目標

• Navigate Trifacta’s grid-view panel
• Upload datasets to Trifacta
• Begin a flow in Trifacta
• Engage Trifacta’s predictive capabilities
• Use Trifacta’s drop-down menus
• Isolate and view transformed rows
• Understand Wrangle language
• Use the header, derive, set, delete, drop, deduplicate, extract, split, settype, replace, and rename transforms
• Use the len, coalesce, find, if, in, ismissing, isvalid, isnull, ismismatched and coalesce functions
• Build patterns
• Escape special characters
• Use logical and comparison operators
• Employ matches
• Differentiate Numbering Systems

課程介紹

Before you read what I have to say, see what my students are saying about my courses on Excel:

“I would like to tell you that I am very impressed with your courses so far – I particularly like the short videos that allow me to get to a topic quickly

…瞭解更多細節

哪些人適合這堂課？

• Course is purely focussed on helping you achieve Ninja level status for Excel Advanced Data Cleaning functions

學習目標

• Learn Beginner to Advanced tricks on Go To Special, Sanitizing, Find & Replace, Text to Column and Text Formulas
• Get Downloadable Case Studies + Picture based eBook [mapped to the Lectures]
• Get Course Completion Certificate
• Learn from the Pro – a Professional Corporate Trainer (PwC, EY, RBS, Tata Group, XLRI etc.)

課程介紹

Welcome to this course on Data Cleaning in R with Tidyverse, Dplyr, Data.table, Tidyr and many more packages!

You may already know this problem: Your data is not properly cleaned before the analysis so the results are corrupted or you can not even p

…瞭解更多細節

哪些人適合這堂課？

• Anybody working with R will benefit from this course since data cleaning is an integral part of any form of analysis

學習目標

• Convert raw and dirty data into clean data
• Understand how clean data looks and how to achieve it
• Use the R Tidyverse packages to clean data
• Handle missing values in R
• Detect outliers
• Filter and query tables
• Select a proper class for your data
• Clean various classes of data (numeric, string, categorical, integer, …)

課程介紹

In this course you’ll learn how to:

Quickly identify and remove duplicate records

Break up data using the Text To Column Feature

Learn when to use the General & Text format

Understand delimiters

Understand how to join data from multiple cells us

…瞭解更多細節

哪些人適合這堂課？

• Beginner level through advance students.
• Anyone that works with Excel.
• Anyone in a Business Analyist, Project Manager, Data Entry, Customer Service role, or in Accounting & Finance

學習目標

• Data manipulation techniques.
• Formulas to manipulate text such as Upper, Lower, Proper, Left, Right, Mid, Contatenation, Concat, TextJoin
• Small intro to the use of Pivot Tables
• How to use the Text To Column feature
• Delimiters 101 – General versus Text

課程介紹

Welcome to very simple yet powerful Excel: Data cleaning and analysis using TEXT functions course

We are glad to meet you. If only we could shake hands! 

Are you wondering how is this course going to be useful to you? 

Hey, did you watch the pr

…瞭解更多細節

哪些人適合這堂課？

• Anyone who wants to learn Excel completely
• Business analysts
• Financial Analysts
• Consultants
• Start up founders
• Project Managers
• College students

學習目標

• Complete overview of Microsoft Excel interface
• Data analysis in Excel
• Data manipulation in Excel
• Data cleaning in Excel
• Application of TEXT functions in data analysis

課程介紹

Learn Tableau Prep, no prior knowledge of data preparation or cleansing required. 

From beginner to Competent user in just one concise course. This course teaches you ALL the functionality of Tableau Prep.

The three stages of this course:

 Fi

…瞭解更多細節

哪些人適合這堂課？

• People new to ‘Tableau Prep’
• Anyone wishing to find a good tool to prepare data

學習目標

• Understand fully and have practical experience using ‘Tableau Prep’

課程介紹

The problem

Most data analyst, data science, and coding courses miss a critical practical step. They don’t teach you how to work with raw data, how to clean, and preprocess it. This creates a sizeable gap between the skills you need on the job and t

…瞭解更多細節

哪些人適合這堂課？

• You should take this course if you want to become a Data Analyst and Data Scientist
• This course is for you if you want a great career
• The course is also ideal for beginners, as it starts from the fundamentals and gradually builds up your skills

學習目標

• The course provides the complete preparation you need to become a data analyst
• Fill up your resume with in-demand data skills: Python programming, NumPy, pandas, data preparation – data collection, data cleaning, data preprocessing, data visualization; data analysis, data analytics
• Acquire a big picture understanding of the data analyst role
• Learn beginner and advanced Python
• Study mathematics for Python
• We will teach you NumPy and pandas, basics and advanced
• Be able to work with text files
• Understand different data types and their memory usage
• Learn how to obtain interesting, real-time information from an API with a simple script
• Clean data with pandas Series and DataFrames
• Complete a data cleaning exercise on absenteeism rate
• Expand your knowledge of NumPy – statistics and preprocessing
• Go through a complete loan data case study and apply your NumPy skills
• Master data visualization
• Learn how to create pie, bar, line, area, histogram, scatter, regression, and combo charts
• Engage with coding exercises that will prepare you for the job
• Practice with real-world data
• Solve a final capstone project