PinnedKirsten Jiayi PaninTowards Data ScienceThe Power of Geospatial Intelligence and Similarity Analysis for Data MappingStrategically enhancing address mapping during data integration using geocoding and string matching4 min read·Feb 17, 2024----
PinnedKirsten Jiayi PaninTowards Data ScienceNavigating Slowly Changing Dimensions (SCD) and Data Reinstatement: A Comprehensive GuideStrategies for efficiently managing dimension changes and data restatement in enterprise data warehousing6 min read·Feb 5, 2024----
Kirsten Jiayi PaninTowards AIComprehensive Data Analysis with SQL and Data Visualization: Alibaba User’s Behavior InvestigationAs data analysts, we all know that a beautiful dashboard can tell stories of the dataset, and meaningful business insights can turn data…7 min read·Jan 17, 2023----
Kirsten Jiayi PanAvocado Planting and Sales — Data Warehousing, Analyzing, and Reporting17 min read·Sep 9, 2022--1--1
Kirsten Jiayi PaninTowards AIUnderstanding the Emotion Tone of Text with AI — Sentiment Analysis on Monkeypox Tweets5 min read·Aug 21, 2022----
Kirsten Jiayi PaninTowards AIUsing AI to Implement Vector-Based Technology in Topic ModelingBest on-hand example for learning one of the most advanced technology and encoding algorithm in topic modeling.4 min read·Aug 11, 2022----