Use Altryx to merge 1.2M transition data, analyze and share the interactive dashboard with Tableau. — Problem Statement The hotel’s executive would like to know the general status of their business. They are interested in how different types of customers stay at each hotel, how amenities impact line revenue, etc. Goal Provide insights on current business performance, allow executives to have a better understanding of the customer, and further…

Three examples to demonstrate how I approach different business problems — Level of Detail Expression is an important concept for Tableau calculation field. FIXED level of detail expressions compute a value using the specified dimensions, without reference to the dimensions in the view. FIXED Level of Detail Expressions When learning how to write LOD, I struggled a lot. I don’t know…

An end to end project from collecting data, creating data pipeline to a business intelligence web application. — This is a project about giving people a recommendation on how to set a price for their used luxury bag. I started the project by creating a data pipeline of extracting data using web scrapping, transforming, cleaning data using pandas, and loading the data for BI web application. From this…

Increase revenue and decrease customer churn — In this article, I would like to document my learning of cohort analysis. Cohort analysis is a way to group your customer based on the different traits. There are two main way to divide customers Acquisition cohorts: Customer groups divided based on their first purchase day(join day). Behavioral cohorts: Customer…

From creating CSV import pipeline using python to analyze the data with PostgreSQL. — As an analyst, it is essential to extract the data we want for a large database, and SQL is the tool for this! SQL stands for Structured Query Language, and it is a language for creating, deleting, updating, and extracting data from the database. …

Analyze a mobile game AB testing result and provide recommendations. — AB testing is a popular way to experiment with changes in websites, games, etc. We can see the result in a short time and make decisions accordingly. I recently took several statistics thinking using Python courses and a course about designing and analyzing AB testing. …

Data visualization is a powerful way to transform messy data into useful insights for decision making and uncover patterns. There are a lot of tools for visualization, such as Tableau for creating interactive dashboards, python’s seaborn package, etc. Recently, I am learning how to plot data using R. As a…