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 …
As 2019 starts I have finally made the jump to self-hosting my blog. This is to learn more about building and deploying websites, specifically, I want to start deploying more deep learning models and driving some web application. What this means is I want to …
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 …
Its been a while since I have blogged anything (and definitely not achieving the goal of one post each month) but I wanted to submit a Makeover Monday post. This weeks data set was based on the If the World was 100 people website. I …
I want to get more involved in the Tableau community events, like Makeover Monday and Workout Wednesday. So here is my first attempt at Workout Wednesday. Nice little project 🙂
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 …