News

This article is by JC Raveneau and originally appeared on the DataRobot Blog here: https://blog.datarobot.com/introducing-microsoft-sql-server-integration

We're happy to announce the early release of our SQL Server Integration feature.

This article is by Joe DosSantos and originally appeared on the Qlik Blog here: https://blog.qlik.com/is-the-data-lake-dead

Assumption #1:“Data storage is expensive, so let’s build our Hadoop data lake, where the economics look much more attractive.

This article is by Robert Lenius and originally appeared on the Alteryx Engine Works Blog here: https://community.alteryx.com/t5/Engine-Works-Blog/Verifying-Tax-IDs-With-REGEX/ba-p/529729

Have you ever found yourself putting data into some online application only to have it fire back that the format is incorrect? This could be things like a phone number, address, or in the bad example on the right, a name .

Typically, this is done through regular expressions, also known as REGEX functions.

This article is by Colin Priest and originally appeared on the DataRobot Blog here: https://blog.datarobot.com/data-science-fails-the-transparency-sweet-spot

Does your organization apply appropriate human resources governance when hiring staff? Large enterprises tend to follow the same basic processes for hiring human staff.

This article is by Clive Bearman and originally appeared on the Qlik Blog here: https://blog.qlik.com/to-sqoop-or-not-to-sqoop-that-is-the-question

Hadoop-based data lakes are one of the hottest trends in big data today because they promise to provide dynamic insights into your enterprise data for improved analytics.

This article is by CP Lewis and originally appeared on the Alteryx Engine Works Blog here: https://community.alteryx.com/t5/Engine-Works-Blog/Automate-the-Repetitive-Stuff-to-Free-Yourself-Up-to-Focus-on/ba-p/526300

You know how amazing it would be to free up some of your time and look into more advanced topics in Alteryx or look into crazy, off the wall problems? You are not alone! I have wanted to continue looking into this and that in my spare time but for the longest time, I couldn’t. Why you might ask? I didn’t know how to automate my work from end to end and had to continue to manually do things.

This article is by Bob Laurent and originally appeared on the DataRobot Blog here: https://blog.datarobot.com/ai-experience-london-sky-uk

There’s a lot to love when it comes to automated machine learning. At DataRobot, we see firsthand the game-changing results that businesses get from this powerful technology.

This article is by Simon Kirby and originally appeared on the Qlik Blog here: https://blog.qlik.com/has-data-ai-and-bots-brought-us-closer-than-ever-to-achieving-the-modern-day-kitt-car

 
As a kid, I loved the TV show “Knight Rider.” But, for me, the star of the show wasn’t David Hasselhoff, it was the intelligent automobile KITT. KITT – the Knight Industries Two Thousand – was smart, funny and sarcastic, which is always well received by us Brits.

This article is by Joshua Burkhow and originally appeared on the Alteryx Engine Works Blog here: https://community.alteryx.com/t5/Engine-Works-Blog/5-MORE-Useful-Design-Patterns-in-Alteryx-You-Need-to-Master/ba-p/520943

 
Solution #6: Keeping Sort Order After a Summarize, Unique or Other Tools

Use Case:

You have data that you want to summarize or get rid of duplicates and in developing a workflow realize that the data gets automatically sorted on the output, but you would like to keep the order that the data is in or some order other than what is given, even with aggregation!

You can simply do this by adding a Record ID tool, and in the case of a Summarize tool, just use the Sort Order column as a ‘First’ or in the case of using the Unique tool just sort on that column after the Unique tool.

This article is by Rob Hegarty and originally appeared on the DataRobot Blog here: https://blog.datarobot.com/exceed-your-clients-expectations-ai-solutions-that-every-asset-manager-needs

The Asset Management industry, like most industries, is in the midst of transformation.