What is the VLOOKUP formula? Merging records or data tables into a single source is a common process that Analysts have to do every day. In Excel this is often achieved using the VLOOKUP formula. According to the Microsoft documentation you would: Use VLOOKUP when …
If you read my introduction post on configuring load balancers over on the Information Lab Blog, I discussed the basic process for configuring Alteryx Server to use a load balancer. That only covered a setup with no SSL configured and the built in Authentication. The …
One of the projects I have wanted to get started with was creating and sharing videos on YouTube. My biggest problem was always getting the time to write the script, record the video, edit, process and upload. With the current lock-down and keeping everyone at …
In the last entry for this series, we created a Random Forest model to try and predict which passengers survived their trip on the Titanic. Without any customisation of the Random Forest, we were able to achieve an accuracy of 0.75119, not as good as …
Last time we ran through the exploratory data analysis to Pre-processing The first step of creating models is the pre-processing of your data. Cleaning the data up to remove nulls, applying any scaling or normalising you need and potentially aggregating the raw data you are …
The Journey Begins For any budding Data Scientist to build their data science chops and reputation, they need to develop lots of models in different applications. One of the best resources to do that and see how well you are doing compared to other people …
Once you start getting into data science one of the biggest challenges you face, and where much of your time is spent, is getting data into a tidy and usable state. I came across an blog post (by Jean-Nicolas Hould) recently which applied the process …
So far in this series we have looked at the tools to get data into Alteryx and to make some changes. In this post we are going to look at the tools to bring many different data sources together. The posts in this series so …
When your connecting to databases with Alteryx you are always looking to connect to ODBC drivers. While I would love to see some more custom optimised connectors which store the connection information with the connection (the SalesForce Connector is heading in that direction), the current …
What a fantastic couple of days it has been. It started with the Alteryx User Group then followed with 2 days at Alteryx Inspire Europe. I’m going to put down my thoughts and I would love to hear any experiences from other people. Alteryx User …