tutorials-blog

Alteryx Training: How to Export Data to Excel

02/10/2023: Alteryx is a powerful tool for data preparation and analytics. With Alteryx, you can connect to various data sources, clean and transform data, and perform analysis. Once your data prep is complete in Alteryx, you'll often want to export the output to Excel for additional analysis and reporting. Excel provides robust charting and visualization capabilities that complement Alteryx. In this guide, you'll learn how to seamlessly export Alteryx data to Excel during your Alteryx training. This guide is part of JBI Trainings Alteryx Course Overview of Exporting Alteryx Data to Excel Exporting...

Alteryx: How to Remove Duplicate Rows

24/08/2023: Duplicate rows can sneak into your data and cause major issues with data accuracy and integrity in your Alteryx workflows. Removing duplicate rows is an essential step in the data cleansing process. This guide will provide step-by-step instructions for eliminating duplicate rows in Alteryx using various tools and techniques. To master Alteryx you should enrol yourself or your team in one of JBI Trainings courses in Alteryx training, Feel free to get in contact to make an inquiry or find out how we can customise a course for your teams particular requirements. What Are Duplicate Rows?...

Alteryx: How to VLOOKUP

24/08/2023: The VLOOKUP function is an essential tool for linking and enriching data in Alteryx. This guide will demonstrate how to perform VLOOKUPs in Alteryx to append columns from one data set to another based on a common key. JBI Training offers a complete solution for all of your or your teams training in Alteryx to find out about our Alteryx training course simply get in contact we we will be happy to assist. What is VLOOKUP in Alteryx? VLOOKUP stands for Vertical Lookup. It searches vertically through a lookup table to find and return the corresponding row for a searched key. This allows you...

Integrating Alteryx with Other Data Science Tools: A How-To Guide

A Comprehensive Guide to Integrating Alteryx with Other Data Science Tools

28/04/2023: This article is brought to you by JBI Training, the UK's leading technology training provider. Learn more about JBI's tech training courses including Alteryx and Pentaho Data Integration I. Introduction to Alteryx Integration Alteryx is a powerful data analysis platform that enables users to perform a wide range of data processing and analysis tasks. However, there may be times when you need to integrate Alteryx with other data science tools and platforms to get the most out of your data. For example, you may want to use Alteryx to preprocess data and then pass it to a machine learning...

How to Import Multiple Sheets in Alteryx

27/04/2023: This article is brought to you by JBI Training, the UK's leading technology training provider. Learn more about JBI's tech training courses including Alteryx and Pentaho Data Integration Introduction: Alteryx is a powerful data analytics and workflow automation tool that helps users to blend, prepare and analyze data from different sources. Importing multiple sheets in Alteryx can be a daunting task for users who are new to the software. However, with the right guidance and step-by-step instructions, it can be done easily. In this guide, we will provide a comprehensive tutorial on how...

How to Remove Duplicates in Alteryx – Step-by-Step Guide

Alteryx How-to: Removing Duplicates in Data Sets

27/04/2023: This article is brought to you by JBI Training, the UK's leading technology training provider. Learn more about JBI's Power BI training courses including Alteryx and Pentaho Data Integration I. Introduction Duplicate data is a common issue in data analysis, and removing duplicates is an essential step for ensuring data accuracy and integrity. However, manually removing duplicates from a large dataset can be a time-consuming and error-prone process. This is where Alteryx comes in – Alteryx offers various tools and functionalities that can help streamline the process of removing duplicates....

A Beginner's Guide to Using Alteryx's Predictive Tools for Machine Learning

Using the Predictive Tools in Alteryx for Machine Learning

27/04/2023: This article is brought to you by JBI Training, the UK's leading technology training provider. Learn more about JBI's tech training courses including Alteryx and Pentaho Data Integration Outline: I. Introduction - Explanation of the importance of machine learning - Brief overview of Alteryx's predictive tools and their capabilities II. Preparing Data for Machine Learning - Overview of the importance of data preparation - Cleaning and transforming data in Alteryx - Feature engineering and feature selection III. Building and Evaluating Models - Overview of the machine learning process in...

Mastering the Alteryx Input Tool: A Comprehensive Guide for Connecting to Data Sources, Configuring Options, and Using Advanced Features

How to Use the Alteryx Input Tool: A Comprehensive Guide

26/04/2023: This article is brought to you by JBI Training, the UK's leading technology training provider. Learn more about JBI's tech training courses including Alteryx and Pentaho Data Integration I. Introduction Alteryx is a powerful data analytics and visualization tool that enables users to analyze and transform data with ease. At the heart of the Alteryx platform is the Input tool, which is used to bring data into your workflow from a variety of sources. Whether you're working with CSV files, Excel spreadsheets, or database tables, the Input tool provides a quick and easy way to connect to...

A Comprehensive Guide to Data Cleaning and Reshaping with Alteryx

Mastering Data Cleaning and Reshaping with Alteryx: A Step-by-Step Guide

26/04/2023: This article is brought to you by JBI Training, the UK's leading technology training provider. Learn more about JBI's Power BI training courses including Alteryx and Pentaho Data Integration Section 1: Introduction to Alteryx Alteryx is a powerful data analytics platform that allows users to blend, cleanse, and analyze data from various sources. It is particularly useful for data preparation and cleaning tasks, as well as data reshaping and transformation. Alteryx provides a graphical user interface (GUI) that makes it easy for users to create workflows and automate data processes without...

How to Use the Generate Rows Tool in Alteryx: A Comprehensive Guide

06/04/2023: This article is brought to you by JBI Training, the UK's leading technology training provider. Learn more about JBI's tech training courses including Alteryx and Pentaho Data Integration Introduction: The "Generate Rows" tool in Alteryx allows users to create rows of data based on a set of parameters. This tool is particularly useful when working with data that needs to be expanded or "unpivoted" to make it more usable in downstream applications. In this guide, we will provide a step-by-step tutorial on how to use the Generate Rows tool in Alteryx, along with some use cases to illustrate...

BLOG

Filter