Published inAnalytics Vidhya·PinnedHow I built a Twitter dashboardFrom building an ETL pipeline to automatically update a dashboard. — In this article, I would like to share how I use Python to extract data from Twitter API and stream them into the PostgreSQL database, perform sentiment analysis and further build a dashboard using Tableau to track the weekly trends. Background “Based on Twitter usage statistics, there are 500 million tweets…Tableau4 min readTableau4 min read
Apr 12, 2021Hotel Performance Descriptive AnalysisUse 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…3 min read3 min read
Published inAnalytics Vidhya·Feb 17, 2021How To Think Tableau Level of Detail Expressions as Writing SQL Group ByThree 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…Tableau3 min readTableau3 min read
Feb 15, 2021Determine sell price for secondhand luxury bagsAn 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. …Tableau5 min readTableau5 min read
Published inAnalytics Vidhya·Jan 31, 2021Cohort Analysis with TableauIncrease 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…Tableau2 min readTableau2 min read
Published inAnalytics Vidhya·Dec 23, 2020Online Business Reporting with SQLFrom 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. …Sql6 min readSql6 min read
Published inAnalytics Vidhya·Dec 20, 2020AB testing in the game with PythonAnalyze 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. …Ab Test4 min readAb Test4 min read
Dec 5, 2020Data visualization using R | Customer Churn | Exploratory Data AnalysisData 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…Tableau6 min readTableau6 min read
Nov 9, 2020How to import CSV file to pgAdmin🐘For the demo, I am going to use olist dataset, a dataset of orders made at olist.com. Import CSV file to pgAdmin Create a database2 min read2 min read
