What you'll learn:
- 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
In this course, you'll walk through Trifacta *basics step by step. We'lltakeyou through not only how to use **Trifacta and itstransforms and functions, but also what common pitfalls you might encounter along the waywhile cleaning data. You'll seethe real experience of data cleaning. Data cleaning isn't always clearcut, and this is why we'll show you what it looks like to iterate changes on your dataset as new information presents itself during the data preparation/data munging process.
*This is a very basic course geared toward people who have little experience with data cleaning.
**Please note that in this course, we use an older version of Trifacta Wrangler.
Note: Data analysts and scientists spend up to 80 percent of their time preparing andcleaning their data. This is a lot of time that could be used in more important phases of the data life cycle, sosaving time at the data preparationstagegives you a competitive edge in the data space because you canuse saved time toward more important things, like analyzing yourdata.
Forrester research identifies data preparation tools as “must haves." Trifacta Wrangler is one of those tools and the product is guided by a board of advisors that has the likes of DJ Patil and Jeff Hammerbacher, among other notables. The company has designed the product to guide you through the data prep, requiring less coding skills.
