This project presents an end-to-end analytics workflow applied to the Korean Drama (K-Drama) industry, spanning data preparation in Excel, relational modeling and ingestion in MySQL, advanced SQL analysis, and strategic insight generation for business decision-making.
The work goes beyond descriptive reporting by introducing:
The final output is a decision-support framework designed for content strategy and programming teams at streaming platforms, enabling data-driven partner selection, genre investment planning, and identification of true breakout titles within competitive release-year contexts.
Hi, I’m Mike Alfaro. I’m an Information Science student with a strong interest in data analytics, business intelligence, and using data to support real-world decision making. I enjoy building projects that combine technical depth with clear storytelling, especially in areas like media analytics, user behavior, and data-driven strategy.
This project reflects my interests in:
You can learn more about my work and connect with me here: