Project Overview

The Media Analytics Dashboard streamlines the process of monitoring daily news from the internet related to the City of Dearborn. This enhances the city's current situational awareness strategies, keeping them informed about what's happening in the city andfurther analyze the news. This way, they can better understand and serve the community.

Client

The City of Dearborn’s Social Media Department

Team

Haofei Xu

Rena Shen

Matthew Tomaszewski

Zhaoyi Meng

Liqian Yang

Problem Statement

The City of Dearborn's current method for collecting online news is inefficient and time-consuming. They are looking for an automated and budget-fridendly way to check dauly news and analysis.

Current workflow:

Step 1

Manually set up Google alerts to receive daily emails related to their interests.

Step 2

Manually sift through each email.

Step 3

Manually catalog the news, and conduct an analysis.

Solution

• Our project streamlines the collection, normalization, and visualization of data. It eliminates the need for our client to manually collect and process information.
• This reduces errors from manual operations and significantly improves data quality and process efficiency. Moreover, data visualization techniques, like word clouds, highlight recurring themes from relevant news articles.
• We also incorporate sentiment analysis from Google Natural Language into our data calculations to assign a score to each article. This gives our clients a straightforward overview of the articles.