Frederik Egervari

Frederik's educational background is in nanoscience, with a focus on chemistry. While working in the field of computational chemistry, he started writing Python code to analyze the movement of molecules which led to an interest in data analytics. This interest made him join the Data School, where he developed a particular interest in ETL and backend processes that are crucial to the success of data projects.

During the Data School, Frederik has had the opportunity to work with clients in the financial and banking sectors, utilizing Alteryx and Tableau for their data projects.

Aside from his work in data, Frederik is passionate about natural sciences, particularly space travel. In his free time, he enjoys engaging in physical activities such as weight training and jogging as a means to unwind.

Certifications

Blog Posts

Avatar
Sun 10 Sep 2023 | Frederik Egervari
No-Coding ETL in Azure vs. Alteryx
Azure Data Factory (ADF) is a tool within Microsoft's Cloud Platform that provides an environment for executing data transformations. While it integrates well with coding-based transformation tools such as Databricks, Python Notebooks, etc
Avatar
Fri 20 Jan 2023 | Frederik Egervari
Using External Stages to load Data from S3 Buckets to Snowflake
In Snowflake an external stage allows you to pull data from an existing S3 Bucket into your snowflake instance. Let’s go through how this can be done and why and how an external stage is used
Avatar
Sat 24 Dec 2022 | Frederik Egervari
The Alteryx Multithreading Engine
The AMP (Alteryx Multithreaded Processing) Engine is a feature in Alteryx that enables Workflow to be executed faster. This is done by using multiple threads at the same time to process the data. To understand how this works, we first have to understand what a thread is
Avatar
Wed 31 Aug 2022 | Frederik Egervari
XML in Alteryx
XML (Extensible Markup Language) is a language that is widely used to structure data. Alteryx Workflow files like .yxmd’s are written in XML and can be observed and changed like this. Therefore, you can open a workflow via the editor, to observe this
Avatar
Fri 12 Aug 2022 | Frederik Egervari
Helpful lesser-known functions of Alteryx
There are many different options and functions on how to optimize working with Alteryx Designer due to the mostly unknown features of the program. Since Alteryx offers so many different features, but not always the optimal usability, some of those are unknown, even by experienced users
Avatar
Sat 23 Jul 2022 | Frederik Egervari
Understanding Fuzzy Logic
This Blogpost is about the logic behind the Fuzzy Matching tool. Understanding the logic helps to optimize the matches of the tool
Avatar
Sun 19 Jun 2022 | Frederik Egervari
Dynamic SQL Queries in Alteryx
When connecting to databases within an Alteryx Workflow it can be a useful option to pull the data in dynamically. This way the amount of data that has to be pulled from the database can be reduced to increase the speed of the workflow
Avatar
Sun 05 Jun 2022 | Frederik Egervari
Displaying multiple Charts in one Worksheet – The Trellis Chart
Trellis Charts are used to display multiple charts on one worksheet. They are great to get a quick overview. For example, you could build charts for individual countries, categories, etc. An example is shown in Fig. 1
Avatar
Wed 01 Jun 2022 | Frederik Egervari
Conditional Formatting for Text in Tableau
The feature to color text based on a condition is not built into Tableau natively, but - as with so many things in Tableau - there is a workaround on how to still include this into your vizzes. Color coding some text can be quite nice
Avatar
Thu 26 May 2022 | Frederik Egervari
Date based Functions in Tableau
Tableau offers a variety of functions based on dates. Understanding the differences is important for working with dates. DATEPART and DATETRUNC When you want to aggregate the data to the level of a year, month, week, etc
Avatar
Thu 26 May 2022 | Frederik Egervari
Tableau's Moving Calculations
A Moving Calculation is a table calculation that can be performed within Tableau. It aggregates values within the past or future to smooth a curve to neglect short time fluctuations from, most of the time, a line chart
Avatar
Tue 24 May 2022 | Frederik Egervari
Working with Tableau Extracts
Tableau enables you to use data extracts as a data source in a workbook. Extracts offer a few options that might be helpful. The idea of an Extract Extracts are the counterpart of the usual live connections used in Tableau
Avatar
Tue 24 May 2022 | Frederik Egervari
Data Preparation within Tableau Desktop
Often data needs to be transformed before it can be loaded into Tableau Desktop, in the Tableau world, Prep is the tool to do that task. But Tableau Desktop also allows you to do some basic data preparation itself and this might be enough to do the task
Avatar
Tue 24 May 2022 | Frederik Egervari
Default Field Properties in Tableau
Each field can be formatted in many different ways in Tableau. Coloring, text size, shape, etc. can be manually defined for a field. This can be done in two different ways. The regular way is to drag a field into the view and then change the settings via formatting, applying color, and so on
Avatar
Tue 24 May 2022 | Frederik Egervari
The Tableau Data Interpreter
Excel spreadsheets are often formatted so humans can understand them quickly. But Tableau needs a more structured approach to work with the data. The Data Interpreter is a tool within Tableau that allows reading in such files, even if they are not in the format you would want them to be
Avatar
Fri 20 May 2022 | Frederik Egervari
Different Number Formats in a single Field
Normally Tableau allows the use of one number format per field. But with positive values, it is possible to use two different formats within one field. This can be useful when you display numbers over highly different ranges. Fig.1, taken from a Workout Wednesday Challenge [https://www
Avatar
Fri 13 May 2022 | Frederik Egervari
Color individual Columns in a Table in Tableau
Tableau’s strong side aren’t tables. That’s why it is sometimes difficult to find all the different settings to format your table the way you want to. One of those things is the coloring of tables. Normally you can color the whole table by one Dimension or Measure
Avatar
Wed 11 May 2022 | Frederik Egervari
Improving Pie Charts (Part 3/3) – Expanding Donut Chart
So far I have covered how to build a Donut Chart [https://www.thedataschool.co.uk/frederik-egervari/improving-pie-charts-part-1-3-donut-chart] and a Sunburst Donut Chart [https://www.thedataschool.co.uk/frederik-egervari/improving-pie-charts-part-2-3-sunburst-donut-chart]
Avatar
Wed 11 May 2022 | Frederik Egervari
Improving Pie Charts (Part 2/3) – Sunburst Donut Chart
In the last blog of this series, I have covered how to build a Donut Chart [https://www.thedataschool.co.uk/frederik-egervari/improving-pie-charts-part-1-3-donut-chart] . Now let’s get a bit more advanced and build a chart that also includes an additional dimension
Avatar
Wed 11 May 2022 | Frederik Egervari
Improving Pie Charts (Part 1/3) – Donut Chart
Pie Charts are one of the most basic visualization types. They can be understood quickly and are visually pleasing. But they are also often misused – As a rule of thumb: Try to use only up to five colors per pie
Avatar
Sun 08 May 2022 | Frederik Egervari
Custom SQL Queries in Tableau
Connecting to big databases can slow Tableau down significantly since it can take quite a long time to run the calculations. Since the speed of Tableau is one of the reasons why it is so fun to work with, this is quite annoying
Avatar
Sun 08 May 2022 | Frederik Egervari
The Data Model in Tableau
The Tableau Data Model describes how you connect multiple data sources are connected. Here Tableau differentiates between two different types. 1. Physical Tables Physical Tables are built when two or more data sources are connected via joins or unions
Avatar
Wed 04 May 2022 | Frederik Egervari
Pareto Charts in Tableau
The Idea of Pareto Charts Pareto Charts are a way to display big contributing factors to a measure. This Chart is based on the Pareto Principle [https://en.wikipedia.org/wiki/Pareto_principle], which states that 80% of consequences result out of 20% of the causes
Avatar
Sat 30 Apr 2022 | Frederik Egervari
Predicting Values in the Future – Time Forecasting Tools in Alteryx
The Time Series tools in Alteryx offer an easy way to predict how a value is likely to behave in the future by looking back at historical values. The function is similar to the Predictive tools
Avatar
Sat 30 Apr 2022 | Frederik Egervari
Creating an Extended Bar Chart in Tableau
There are some fancy Chart Types in Tableau. The Extended Bar Chart is one of them. The advantage of an Extended Bar Chart compared to normal Bar Charts is that you can display more text at the start of a bar. Lately, I have written a blog post [https://www.thedataschool.co
Avatar
Sun 24 Apr 2022 | Frederik Egervari
Using a Coordinate System to generate Tableau Visualizations
Most Charts that are built and used in Tableau are pretty simple. If you drag a Dimension onto Rows,  a Measure onto Columns, and select the Bar Chart on the Marks Card, the Chart is built easily and quickly. This is why Tableau is great for inexperienced users to get started
Avatar
Sun 24 Apr 2022 | Frederik Egervari
Web Scraping in Alteryx
Web Scraping can be an effective way to pull much data from an internet source and Alteryx is very helpful at doing so. Here I want to share with you how you can quickly get publicly available data from a website and transform it to make it useable
Avatar
Thu 21 Apr 2022 | Frederik Egervari
Creating a Burndown Chart in Tableau
A Burndown Chart is a nice method to display how a value decreases over time. So for example if you want to display how fast a certain budget decreases over time. Here we can see a Burndown Chart of a modified Superstore dataset. A budget that was available from November 2019 onwards is shown
Avatar
Mon 11 Apr 2022 | Frederik Egervari
Condition-based hiding of Worksheets
If you are building a dashboard, you often run into the situation that you might only want to show a certain worksheet if a condition is met
Avatar
Mon 04 Apr 2022 | Frederik Egervari
Using Alteryx Macros to cooperate more effectively at Data Preparation
Lately, we, in DSDE2 had our first projects where we had to work as a whole group of eight to analyze data. Thereby a major task is coordinating how to work with each other, to distribute the work most effectively and achieve the best results
Avatar
Sun 03 Apr 2022 | Frederik Egervari
Fuzzy Matching in Alteryx
The Fuzzy Match Tool in Alteryx can be a very powerful tool when you try to match two data streams but the matching condition is not always met hundred percent and therefore a join doesn’t work
Avatar
Sun 20 Mar 2022 | Frederik Egervari
Increasing User Control by using Parameters in Tableau
Parameter actions are a good way to allow a dashboard user additional options to choose a parameter. By including a dropdown to select a specific dimension the user has the option to take a look at what she/he is interested in. 1. Create a Parameter At first a parameter has to be created
Avatar
Tue 08 Mar 2022 | Frederik Egervari
Getting Intersecting Spatial Data in Tableau and Alteryx
If you are working with Spatial Data, within Tableau or Alteryx, you have to watch out for a few possible stepping stones. One can occur when you try to create an output with an overlap over two different Spatial Columns
Avatar
Tue 08 Mar 2022 | Frederik Egervari
The Alteryx Advanced Certification
In the process of the Data School, the second Alteryx Certification is not just scheduled for us in DSDE2 yet, but I decided to try to pass it a bit earlier since I am feeling quite comfortable using Alteryx
Avatar
Fri 04 Mar 2022 | Frederik Egervari
Working across different tables in Tableau
To use multiple sheets, maybe from different data sources, in a single visualization Tableau offers different ways to do so. The way to combine the tables has to fit to the according data within and might get a bit complicated from time to time
Avatar
Thu 17 Feb 2022 | Frederik Egervari
Interactivity within Tableau
Tableau lives of its interactivity. It’s one of the features which makes using Tableau fun and can generate an interactive user experience instead of just simply displaying graphs
Powered by The Information Lab
1st Floor, 25 Watling Street, London, EC4M 9BR
Subscribe
to our Newsletter
Get the lastest news about The Data School and application tips
Subscribe now
© 2025 The Information Lab