Ben Mangel

Meet Ben—an experienced Data Analyst blending expertise in technology, data analysis, and design. His diverse background includes tax and audit, honing his attention to detail in (financial) data.
Proficient in Tableau, Alteryx, PowerBI, Figma, and programming languages like R, Python, SQL, and TypeScript, Ben transforms data into actionable insights.
His passion lies in innovating with data, and what sets him apart is his genuine love for collaboration. Ben thrives on working closely with teams and clients, ensuring insights become impactful actions.

Manufacturing and Factory Automation (3 months)

  • Supported the development of Alteryx Workflows across various industry departments.
  • Engaged in workflow and macro development, predictive analytics, and documentation best practices using Alteryx.
  • Managed stakeholders and projects with of over 20 individuals.
  • Conducted basic and intermediate Alteryx training sessions for over 25 participants.

Insurance (6 months)

  • Developed dashboards in Tableau for the board and senior management to provide unprecedented insights and support decisions.
  • Structured requirements gathering for various projects to understand user needs and create effective dashboards.
  • Creating templates in Tableau for an enterprise-wide user group with a focus on UI and UX aspects for more consistent reports, easier dashboard creation, and a better user experience.

Skills

Data Visualization: Tableau, PowerBI
Data Preparation: Alteryx, SQL, Python
Programming: R, TypeScript
Design: Figma

Key competencies

  • Project Management
  • Requirements gathering
  • UI / UX Design
  • Effective and proactive communication
  • Attention to detail

Short term projects

Münster University of Applied Sciences
  • Delivered hands-on Tableau workshops for beginners and advocated for best practices in dashboard design to postgraduate students.
Public Health Insurance
  • Delivered hands-on Tableau workshops for beginners and advocated for best practices in dashboard design to postgraduate students.
Indoor Recreation
  • Developed a financial analysis dashboard, offering a unique and previously unseen perspective on the store's financial performance.
  • Conducted a comprehensive market basket analysis using R, with results seamlessly visualized in Tableau, providing actionable business insights.
Furniture Trade and Production
  • Collaborated in the design and execution of Alteryx workflows, enhancing data processing and analysis capabilities.
Internal Project
  • Leveraged API integrations to query CRM data, followed by historization in a Postgres database using Alteryx.
  • Transformed historized CRM data into insightful visualizations in Tableau, offering a novel perspective on the progression of opportunities.

Before Data School

  • Drees & Sommer: Internship Data Science (6 months)
  • Wirth Schmies & Partner mbB: Working Student Tax, Audit, Corporate Finance (1 year)
  • StB Stefan Ruprecht: Commercial Apprenticeship as Junior Tax Assistant (2.5 years)
  • Studies: Business Administration (B.A.)

A Story of the Internet - Google Rebuild

Netflix Analysis

Trade War: USA vs. China

Certifications

Blog Posts

Avatar
Thu 13 Jul 2023 | Ben Mangel
How to: Connect with Alteryx Gallery MongoDB
A notable function of the Alteryx server is the ability to connect to MongoDB databases, espeacially the MongoDB which contains the data about the Alteryx Gallery
Avatar
Fri 30 Sep 2022 | Ben Mangel
Dashboard Week: Day 4
Second to last day in the training phase of the Dataschool and the fourth day in the Dashboardweek. Like on our first day we had to access an API - this time a fandom API to the Breaking Bad / Better Call Saul universe. To series which are both highly recommended to watch
Avatar
Thu 29 Sep 2022 | Ben Mangel
Dashboard Week: Day 3
Todays task was a tricky one. After the Brexit referendum the current cohort DS 3 had to build dashbaords related to the Brexit. This was our task for this day aswell
Avatar
Tue 27 Sep 2022 | Ben Mangel
Dashboard Week: Day 2
It's the second day of the dashboard week - the week where we get a task every day which we have to solve. The task from our first day was pretty cool, what I did can you read here. The on our second day was a dashboard in PowerBI with several requirements regarding the data
Avatar
Tue 27 Sep 2022 | Ben Mangel
Dashbaord Week: Day 1
The last week of our training has started and, like every cohort before us, it is a dashboard week. Every day we get an assignement to solve and present on this day. Task for day 1 was to access the data.police.uk API and build an app to get data from the API
Avatar
Mon 19 Sep 2022 | Ben Mangel
Fix an axis with a reference line
Tableau offers the possibility to fix an axis. This has different advantages, but from it's strenght, and that's in the name, it ist fixed. It is always, always, always the same unless you change it. There are some usa cases where you need to fix an axis dynamically
Avatar
Wed 07 Sep 2022 | Ben Mangel
Fill NULL values with the value one row above in Tableau Prep
NO CODING SOLUTION It is a tricky thing to fill up values from one row above to the current row. In Alteryx you can use the Multi Row formula tool which is not part of Tableau Prep (September 2022)
Avatar
Wed 17 Aug 2022 | Ben Mangel
How to: Variance Chart
What is an variance chart? It shows the difference from, for example the sales, of a selected category to the other categories. It could look like this: There are several ways to build a variance chart
Avatar
Fri 08 Jul 2022 | Ben Mangel
How to: Quadrant charts with sets
In this post I want to explain how to build a quadrant chart. So what makes a quadrant chart? Imagine you want to know how a specific group of your customers is composed
Avatar
Mon 20 Jun 2022 | Ben Mangel
Summarise Spatial Objects in Alteryx
Alteryx has a Spatial only tab on it's interface. But why should you stick to it if there are other tools which can manipulate spatial data too? For example the summarise tool. You may know at as a handy thing to group your data and calculate the sum, average etc
Avatar
Mon 20 Jun 2022 | Ben Mangel
Project 2: Reshaping data
The Friday of our second week was project time again! We worked together in pairs. I had the opportunity - and pleasure - to work with Ozlem from the DS 32, how we spent our day can you read here in her blog! Our topic was reshaping of data, i.e. pivot und un-pivot data in Tableau prep and Alteryx
Avatar
Tue 14 Jun 2022 | Ben Mangel
First steps in the DS Germany!
Hello and welcome to my first blog ever! I've never done this before, so let's see where we end up. The goal of these blogs is to help us, the data schoolers, to reflect what we experienced and learned in the Data School
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