Pinned Loading

1. Coffee_review_text_QA_LLMs Coffee_review_text_QA_LLMs Public

   Connects to OpenAI, applies Large Language Models (LLMs) & LangChain, and builds a platform to chat with coffee customer review text data using Python. Visualizes text data with R

   HTML 1

2. SQL_Python_Google_big_query SQL_Python_Google_big_query Public

   A collection of my selected SQL files, interacting with Google Big Query (GBQ) and Python

3. Dram_shop_PCA Dram_shop_PCA Public

   Applies Principal Component Analysis (PCA) to dimensionality reduction using Python, SQL, and GBQ.

   Jupyter Notebook

4. High_school_performance High_school_performance Public

   Visualizes the data, builds a multi-linear regression model, applies a 10-fold cross-validation resampling method, and evaluates LM, SVM, and KNN model performance using R

   HTML

5. Power_BI_projects Power_BI_projects Public

   Interactive Power BI business intelligence dashboard analyzing e-commerce operations, sales revenue, and customer KPIs. Features an optimized Star Schema data model, advanced data cleaning via Powe…

6. Tableau_projects Tableau_projects Public

   Interactive Tableau dashboards showcasing advanced business intelligence, time-series analysis, and executive data storytelling. Featured projects include dynamic e-commerce KPI tracking and a 12-m…