Media Attention & High-Profile Crime Case Popularity Analysis
Independent research and analysis project, 2026 · Dataset v1.0 frozen · Power BI visualization in progress
- Built the dataset from scratch rather than downloading a finished one.
- Maintained a separate source workbook holding URLs, collection dates, platform metrics, selection rules, and limitations.
- Created consistent Case IDs and standardized date formats so the sheets could be compared to each other.
- Normalized platform-level metrics and created a weighted cross-platform popularity score.
- Built a Media Triggers table linking documented real-world events to the related metrics.
- Revised the original assumptions when the source data did not support them, instead of forcing the data toward the expected conclusion.