Sign-up now and get instant access
Leave a comment
Customized training to master new skills and grow your business.
Beginner to advanced classes taught by Microsoft MVPs and Authors.
In-depth boot camps take you from a novice to mastery in less than a week.
Season Learning Pass
Get access to our very best training offerings for successful up-skilling.
Stream Pro Plus
Combine On-Demand Learning platform with face-to-face Virtual Mentoring.
A new horizon in technical exam preparation
Quick references for when you need a little guidance.
Summaries developed in conjunction with our Learn with the Nerds sessions.
Digital goodies - code samples, student files, and other must have files.
Stay up-to-date on all things Power BI, Power Apps, Microsoft 365 and Azure.
Earn money by driving sales through the Pragmatic Works' Training Affiliate Program.
It's time to address your client's training needs.
Learn how to get into IT with free training and mentorship.
Discover the faces behind our success: Meet our dedicated team
How can we help? Connect with Our Team Today!
Find all the information you’re looking for. We’re happy to help.
Can you confidently claim that your data is clean? Our Data Analyst, Achara McNair-Tarfa, claims that her data is cleaner than yours. How does she have such confidence in her data? Here, you can view a demo by our Sr. Product Engineer, Manual Quintana, to explain how components in Pragmatic Works’ Task Factory can help you to not only claim your data is clean, but also save you time and gain efficiency.
The components shown in our demo help on two fronts. One is with the monotonous task of data cleansing, like trimming and null handling. The other will truly validate data quality. These components remove the need for all that scripting, making your life easier and saving you time.
In Visual Studio, you can leverage Task Factory’s data cleansing components in an easy-to-use interface with packages that you’ve entered into the data flow task. Then it’s as easy as choosing what action you want taken from a list of input columns. No need for custom coding and scripting. With the time saved, you can now focus on the dynamic pieces of your package.
What about loading from a delimited file? Here’s where the data quality component, called the File Gateway Task, comes into play. This component allows the user to choose a delimited file and implement certain validation rules. Then the user can choose the columns and how they want the comparison done. File Gateway does a conditional split for your delimited files. So, it splits out the good vs. the bad and this will be presented in one of the outputs that we can send to any destination.
There’s also a massive amount of bad addresses in most databases, whether badly formatted addresses or non-deliverable addresses. Our own address database had thousands of bad addresses, costing us thousands of dollars in undeliverable mail before we fixed it. The Task Factory product has two transforms to clean and validate addresses and make them CASS certified for cheaper mail delivery.
These are only a few of the over 60 components in Task Factory that will save you time and make your day to day data chores easier and more efficient. And even more good news — Task Factory is forever free in Visual Studio. Visit our website or click below to learn more about how Task Factory will help you confidently say, “My data is clean!”
Join other Azure, Power Platform and SQL Server pros by subscribing to our blog.