When data comes to my world

I achieved the Bachelor’s in Computer Science from Southern Polytechnic State University in 2012 and the Master’s in Engineering Management from University of Southern California in 2014. Like most of the new graduates, I did not know what my career would look like. However, I know I love data and how powerful the data is.

I am passionate about data. Everyone talks about data now, but do you know what data means to the business and how data can ultimately help the company make money? As a senior data analyst, my job is to make data accessible, present data visually, communicate data insights, and make recommendations to help business users make actionable decisions. Instead of providing pages of numbers, I use data to tell stories.

This website is the place to not only share my ideas of data analysis, visualization, insights and storytelling, but also share how I grow personally and professionally. I’d love to spread my positive energy to the world. Let’s start…


Nikki Yu – Senior Data analyst

Santa Monica, CA, United States.


  • Skilled in building and analyzing sales, operations and marketing dashboards and reports into actionable insights and driving business results.
  • Collected and documented requirements from cross-capability enterprise partners to ensure that projects are properly scoped, setting-up projects at the onset for success.
  • Led collaboration with database developers to extract and warehouse data for analysis with goal of developing data-driven recommendations for ongoing optimization.
  • Recognized as a collaborative, self-starter who is detail-oriented, meticulous and a deadline evangelist.
  • Well-equipped expert in Tableau.

Data Visualization

My portfolio showcases various Makeover Monday projects created in my free time. I love the Makeover Monday and Tableau community.

Makeover Monday is your weekly learning and development appointment with yourself and hundreds of passionate data people.


Interested in More Data Visualizations?

Please check my Tableau Public Profile: https://public.tableau.com/profile/nikki.yu

Let’s build something together.


How to String Agg a Dimension in Tableau?

Tableau does not have string_agg() function like SQL. I’d like to show list instead of asterisk when multiple values are present. Use Case: my company works with vendors to manufacture products. One product might be manufactured by different vendors . I’d like to show vendors associated with each product. If there are multiple vendors associated …

Predictive Analytics – Project 5: A/B Test a New Menu Launch

Topic: A/B Test | Tool: Alteryx Project Overview: The coffee restaurant would like to conduct a market test with a new menu and needs to figure whether the new menu can drive enough sales to offset the cost of marketing the new menu. To minimize the risk, the management team decides to test the changes …

Predictive Analytics – Project 4: Predicting Default Risk (Creditworthiness)

Topic: Classification Model | Tool: Alteryx Step 1: Business and Data Understanding What decisions need to be made? A small bank which typically get 200 loan applications per week and approved by hand suddenly received nearly 500 loan applications due to a financial scandal that hit a competitive bank last week. As a loan officer,  …