tutorials-blog

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...

How to Integrate Azure Logic Apps with Other Azure Services

23/08/2023: Introduction Azure Logic Apps provide a great way to automate workflows and business processes in the cloud. With Logic Apps, you can integrate various Azure services together to build end-to-end solutions without writing any code. JBI Training can supply a complete solution to all of your tech training requirements. If you are considering a Azure Logic Apps course, please feel free to get in contact and we can supply exactly what you need for yourself or your team. There are many examples of how Logic Apps can connect to other Azure resources like Azure Functions, Azure Storage, Azure...

Python Machine Learning FAQs questions

23/08/2023: Introduction Python has become one of the most popular programming languages for machine learning. With its extensive libraries and easy to understand syntax, Python provides a flexible environment to build and deploy machine learning models. As one of the leading tech training companies in the World today JBI Training has trained staff from some of the most recognisable companies operating today. If you are considering training as an individual or to train your team in machine learning training, simply get in touch and we can supply the perfect solution. In this comprehensive guide,...

Machine Learning in R vs Python

23/08/2023: Machine learning has transformed fields like computer vision, natural language processing, robotics, and predictive analytics. Mastering machine learning algorithms and techniques is a crucial skill for aspiring data scientists and AI engineers. The two most popular programming languages for applying machine learning are Python and R. Both languages have robust machine learning libraries and active user communities. But they have some key differences in their ecosystem and approach. JBI Training offers courses both in Python and R to find out more get in contact or visit our machine learning...

Azure Logic Apps: How to create a logic app

22/08/2023: Automating workflows and business processes is key for organizations looking to improve efficiency and productivity. With Azure Logic Apps, you can quickly build scalable workflows to integrate systems and data across cloud services and on-premises infrastructure. This step-by-step guide will show you how to get started building logic apps on Azure. To master Azure Logic Apps you might consider taking a course in Azure Logic Apps Training either as an individual or your team. Working one-to-one with an expert instructor. Contact JBI Training for more details. What are Azure Logic Apps?...

How to Code in TypeScript

21/08/2023: TypeScript is a typed superset of JavaScript that provides optional static typing, classes, interfaces, and other features to help build robust applications at scale. This guide will walk through the key aspects of coding in TypeScript with examples. This material is taken from our Typescript training courses, JBI training can supply a complete solution for your training in typescript either as an individual or for an entire team. If you are interested in training or customising a course, simply get in touch and we'd be delighted to assist. Introduction to TypeScript TypeScript adds type...

How to Migrate from JavaScript to TypeScript

21/08/2023: TypeScript has rapidly grown in popularity as a way to create more robust JavaScript applications. This guide covers the key steps involved in migrating an existing JavaScript codebase to TypeScript. JBI Training offers a complete solution to all of your Typescript Training requirements. To train a team, customise a course or find out more simply get in touch and our dedicated advisors will be happy to help. Introduction TypeScript extends JavaScript syntax with type annotations and other features like classes and interfaces. The additional type information allows catching errors during...

How to Create Top N Parameter in Tableau

18/08/2023: Allowing users to filter views to show the top or bottom N values is a common requirement in Tableau. Using parameters makes this flexible for end users. In this article, you'll learn how to create Top N parameters in Tableau Desktop to dynamically rank and filter data. This article is part of our on-going blog series of useful 'how-to' guide in Tableau. The material from JBI Trainings is part of our tableau courses which can be accessed remotely or in person in London. Simply follow the link to participate in the training for you or your team. Tableau Training London Introduction to...

How to Query in Tableau

18/08/2023: Tableau offers powerful options for querying your data beyond just dragging fields to shelves. Learning how to write custom SQL queries gives you greater control and flexibility. JBI Training offers a number of options for you and your team to train in Tableau. Our blog material and guides are just the start of your Tableau training adventure. If you are considering training your team, get in contact to place them on our Tableau Course In this article, you'll learn: Basic SQL query syntax Building queries on database views Using parameters in queries Query performance tips Let's dive...

How to Show Top N in Tableau

17/08/2023: Displaying the top or bottom values in your data is a common task in Tableau. The Top N feature allows you to quickly filter your views to the most or least significant rows. In this article, you'll learn multiple methods for showing the top and bottom records in Tableau Desktop. The material from this article is part of our tableau course. JBI Training can supply training in Tableau to your entire team. Introduction to Top N in Tableau Analysing the top and bottom performers in your data is crucial for many business objectives. For example: Identifying top-selling products to promote...

How to Concatenate in Tableau

16/08/2023: Combining multiple fields together into a single field is known as concatenation in Tableau. This allows you to merge text from different columns, blend data sources, and create new calculated fields. Concatenation is a handy technique for data preparation and shaping that enables more customised analysis. This topic is taught on Tableau training courses including courses run by JBI Training. In this guide, you'll learn what concatenation is, why it's useful, and how to concatenate fields in Tableau using both calculated fields and table calculations. What is Field Concatenation in Tableau?...

How to Add Filter in Tableau Dashboard

16/08/2023: Introduction Tableau is one of the most popular business intelligence and data visualisation platforms used today. It allows you to connect to data, build interactive dashboards, and gain insights through analytics. A key feature in Tableau is the ability to filter your data. Adding filters to a Tableau dashboard allows you to focus on particular data points, highlight key trends and patterns, and simplify complex views for clearer analysis. In this step-by-step guide, you'll learn how to add and configure filters in Tableau dashboards. We'll cover the basics of filter shelves, settings,...

Which companies prefer Python?

15/08/2023: Python has become one of the most in-demand programming languages across industries. Its versatility and large ecosystem make it a preferred choice for companies ranging from tech giants to early-stage startups. Python is especially popular at organisations leveraging data science, machine learning, and automation, with teams of staff tat top companies regularly placed on python data analyst courses from tech training companies such as JBI Training. An Introduction to Python Adoption Released in 1991, Python has gradually gained mainstream popularity thanks to its user-friendly syntax,...

Is Python Good for Finance?

15/08/2023: With finance going increasingly digital, the importance of leveraging quality data and automation continues to grow. This makes Python, with its large ecosystem of specialised libraries, an intriguing option for financial analysts and developers. But is Python truly a good match for the diverse needs of finance? An Introduction to Using Python in Finance Modern finance rests on processing data to uncover insights, build models, and improve decision-making. Python makes these tasks more effective through its strengths in data manipulation, visualisation, and rapid development capabilities....

BLOG

Filter