Yan Peng

Yan is a dynamic professional with a PhD in Linguistics and extensive experience in research and education. With a solid foundation in academia, she has seamlessly transitioned into data analytics, showcasing exceptional analytical skills and a keen eye for detail.

During her transition, Yan completed a rigorous online program in Data Analytics, focusing on Excel, Tableau, SQL, and Python. At Data School, Yan has been enhancing her proficiency in Tableau, Power BI, and Alteryx (see Certifications). Her portfolio (see below) showcases a range of high-quality projects across various domains.

Yan's expertise lies not only in technical proficiency but also in effectively communicate complex insights through data visualization and storytelling. Her considerable teaching experience has honed her public speaking skills, resulting in presentations characterized by well-defined structure, clarity, and audience engagement. At Data School, Yan has contributed valuable insights and solutions to various client projects.

Skills

  • Data Preparation: Tableau Prep, Alteryx, Power BI

  • Data Visualization: Tableau Desktop, Power BI

  • Database Query Language: SQL

  • Programming Language: Python

Key Competencies

  • Analytical Thinking

  • Translating Business Requirements into Data Questions

  • Storytelling

  • Effective Communication

  • Attention to Detail

Consultancy Experience

  • Engaged in short-term consulting projects across diverse industries, including healthcare, agriculture, insurance, hospitality, and waste management.

    • Collaborated with clients to gather, structure, and analyze business requirements.

    • Performed data preparation, transformation, and designed optimized data structures tailored to client needs.

    • Developed and implemented interactive dashboards to provide actionable insights.

    • Presented solutions to clients, offering strategic recommendations for future improvements.

  • Currently supporting a medical billing agency on a long-term consultancy project.

    • Maintained and updated existing dashboards, improving product offering.

    • Improved reporting consistency by consolidating data from multiple sources.

    • Enhanced dashboard performance by evaluating and optimizing data sources.

    • Automated data updates for dashboards with diverse data sources and underlying prep flows on Tableau Server.

    • Created visual sketches of data models and flows behind the dashboards, enhancing team understanding and decision-making.

    • Presented results weekly to the entire team, ensuring transparency and alignment on progress.

Portfolio

Tableau Projects

GitHub Repositories

Blog Posts

Avatar
Tue 23 Jul 2024 | Yan Peng
Steal Like An Artist
Today marked the second day of Dashboard Week, a challenging and exhilarating experience. Our task was to create two business dashboard templates using Tableau and Power BI. We worked with a mock HR dataset and the well-known Superstore dataset
Avatar
Mon 22 Jul 2024 | Yan Peng
How I Created an Informative Dashboard in Just 5 Hours
Today was the first day of our dashboard week. We got a dataset we've never seen before in the morning and were asked to choose a story, make a sketch, and build a dashboard in Tableau within five and half hours. To succeed in such a stressful task, having a plan is crucial
Avatar
Sun 07 Jul 2024 | Yan Peng
How to Use KPI Cards as Action Buttons in Tableau
Switching between KPIs in a Tableau chart typically requires a parameter control. However, there are times when you might want to introduce another layer of interactivity, either because your dashboard is already loaded with filters or to make it more versatile
Avatar
Tue 18 Jun 2024 | Yan Peng
What Are Specific Dimensions in Table Calculations in Tableau?
When setting up table calculations in Tableau, the "Compute Using" section offers options to define how comparisons are made. For instance, when computing percent difference down the table, each quarter is compared to the previous one within each year (image below)
Avatar
Tue 04 Jun 2024 | Yan Peng
How to Set Up a Date Field in a Year-Over-Year Dual Axis Chart
In this post, I will show you how to create a year-over-year dual axis chart in Tableau, with the x-axis displaying the month-year date format of the current year. The following chat visualizes the sums of sales from the current and the previous year using a line and an area chart, respectively
Avatar
Sun 16 Jun 2024 | Yan Peng
How To Be A Confident Newcomer
Navigating a career change can be daunting, especially when starting something new feels uncomfortable, and you fear failure. A year ago, I decided to change my career, and my life has transformed in many ways thanks to that decision and my dedication to achieving my goals
Avatar
Sat 08 Jun 2024 | Yan Peng
The "Profit Ratio" Problem
In this post, I will address a type of KPI that requires caution when it comes to aggregation. I call it the "profit ratio" problem
Avatar
Thu 30 May 2024 | Yan Peng
Ein Anwendungsfall für die Kombination vom Satz und LOD-Ausdrücken in Tableau
In Tableau kann man Sätze verwenden, um eine Teilmenge von Daten unter einer bestimmten Bedingung zu erstellen. Man umgeht dabei nicht nur komplexe Berechnungen, sondern der erstellte Satz gestaltet sich auch dynamisch
Avatar
Sun 12 May 2024 | Yan Peng
How to Become a Better Learner
One motivating factor for me to apply for the Data School was its focus on candidates with the potential to become good data analysts
Avatar
Sun 12 May 2024 | Yan Peng
How to Highlight Series in a Line Chart in Power BI
In this article, I will demonstrate a quick workaround for highlighting series in a line chart in Power BI. This is a common limitation in the Microsoft tool
Avatar
Mon 06 May 2024 | Yan Peng
Storytelling with Tableau Storyboard
Storyboard in Tableau is a powerful tool for storytelling. In the blog post, I'm going to guide you through a personal story of mine based on my Spotify streaming history (storyboard available here). Some of story types I used are explained in this video
Avatar
Thu 02 May 2024 | Yan Peng
A Use Case for Generating New Rows in Tableau Prep
"New Rows" is a quite handy feature in Tableau Prep for filling gaps in sequential data, often used to generate dates. In this post, we will look at a fictitious use case where new rows have to be generated to make the data aggregatable
Avatar
Sun 28 Apr 2024 | Yan Peng
Normalisierung absoluter Zahlen
In diesem Beitrag zeige ich, wie man durch Datenzusammenführung und Berechnung absolute Werte in Bezug auf eine Größe normiert, um die Zahlen in einen Kontext zu setzen und sie vergleichbar zu machen
Avatar
Tue 09 Apr 2024 | Yan Peng
Numbers Are Not Just Numbers
Welcome to my first blog post as a Data Schooler! In our first week of training, we delved into the theoretical underpinnings of data analysis
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