Open in app

Sign In

Write

Sign In

thejasmine
thejasmine

30 Followers

Home

About

Published in Analytics Vidhya

·Pinned

How I built a Twitter dashboard

From 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…

Tableau

4 min read

How I built a Twitter dashboard
How I built a Twitter dashboard
Tableau

4 min read


Apr 12, 2021

Hotel Performance Descriptive Analysis

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…

3 min read

Hotel Performance Descriptive Analysis
Hotel Performance Descriptive Analysis

3 min read


Published in Analytics Vidhya

·Feb 17, 2021

How To Think Tableau Level of Detail Expressions as Writing SQL Group By

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…

Tableau

3 min read

Think Tableau Level of Expression in SQL way
Think Tableau Level of Expression in SQL way
Tableau

3 min read


Feb 15, 2021

Determine sell price for secondhand luxury bags

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. …

Tableau

5 min read

Determine sell price for secondhand luxury bags
Determine sell price for secondhand luxury bags
Tableau

5 min read


Published in Analytics Vidhya

·Jan 31, 2021

Cohort Analysis with Tableau

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…

Tableau

2 min read

Cohort Analysis with Tableau
Cohort Analysis with Tableau
Tableau

2 min read


Published in Analytics Vidhya

·Dec 23, 2020

Online Business Reporting with SQL

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. …

Sql

6 min read

Online Business Reporting with SQL
Online Business Reporting with SQL
Sql

6 min read


Published in Analytics Vidhya

·Dec 20, 2020

AB testing in the game with Python

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. …

Ab Test

4 min read

AB testing in Game — analyze using Pty
AB testing in Game — analyze using Pty
Ab Test

4 min read


Dec 5, 2020

Data visualization using R | Customer Churn | Exploratory Data Analysis

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…

Tableau

6 min read

Data visualization using R | Customer Churn | Exploratory Data Analysis
Data visualization using R | Customer Churn | Exploratory Data Analysis
Tableau

6 min read


Nov 9, 2020

How 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 database

2 min read

How to import CSV file to pgAdmin
How to import CSV file to pgAdmin

2 min read

How to import CSV file to pgAdmin🐘

Photo by Caspar Camille Rubin on Unsplash

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 database

--

--

thejasmine

thejasmine

30 Followers

📍San Francisco, CA| Business Analytics | Strategy | Payments | https://thejasminehuang.com

Following
  • Rashi Desai

    Rashi Desai

  • Rejoice Denhere

    Rejoice Denhere

  • Cheng-Wei Hu | 胡程維

    Cheng-Wei Hu | 胡程維

  • Jasmine Lin

    Jasmine Lin

  • Roger Huang

    Roger Huang

Help

Status

Writers

Blog

Careers

Privacy

Terms

About

Text to speech