Fontys MarCom

Project description

At the moment, the MarCom-department of FH-ICT uses several social media accounts. They actively use their Facebook, Instagram, LinkedIn, and YouTube accounts. Out of all these social media accounts, a lot of data is available. Currently, the data from all these various sources is imported manually and stored locally. When the data has been imported and stored, it is manually exported to Power BI, where it will be implemented and used in a dashboard.
MarCom has given the following assignment:

“How can the data from multiple social media channels from Fontys Information & Communication Technology /FHICT/ be stored and visualized within a dashboard to fulfill the wishes of the team Marketing and Communication.”

Context

All the data from the different social media channels is processed manually. This takes a lot of time, and the MarCom department lacks the technical knowledge to handle these tasks. Currently, there is no form or reporting/data analysis. In the first iteration of this project, (DDD 1) a working data dashboard was produced, which is not yet in use due to the lack of automation of data imports. Also, the use is not embedded in the practice of MarCom, due to the manual nature of this dashboard.

Results

The end product delivered consists of a dashboard visualizing the data of YouTube and Instagram and an automated data pipeline for those two social media channels. Firstly, a data pipeline needed to be implemented. To achieve that, we made a script consisting of an access key required to access the API data and data cleaning. Furthermore, we created a database that will store historical data, and the connection between the API and the database was also included in the script. We connected the database with Power BI, so when new data is added, the new values are automatically added to the visualizations in the dashboard.