Interactive Media Intelligence Dashboard
Gain insights from your media data
How to Use This Dashboard
Follow these simple steps to analyze your media data:
-
Prepare your CSV file: Ensure it has the following columns:
Date, Platform, Sentiment, Location, Engagements, Media Type.
-
Upload your CSV: Click the "Choose CSV File" button below and select your prepared CSV.
-
View the insights: Once uploaded, the dashboard will automatically clean your data and display interactive charts along with key insights for each visualization.
1. Upload Your CSV File
Processing data...
2. Data Cleaning Process
The dashboard automatically performs the following data cleaning steps upon CSV upload:
- Converts the 'Date' column to a proper datetime format.
- Fills any missing values in the 'Engagements' column with a default of 0.
- Normalizes column names (e.g., `Date` becomes `date`, `Media Type` becomes `mediatype`) for consistent processing.
- Rows with invalid or unparseable dates will be filtered out.
3.1. Sentiment Breakdown (Pie Chart)
Top 3 Insights:
3.2. Engagement Trend Over Time (Line Chart)
Top 3 Insights:
3.3. Platform Engagements (Bar Chart)
Top 3 Insights:
3.4. Media Type Mix (Pie Chart)
Top 3 Insights:
3.5. Top 5 Locations by Engagements (Bar Chart)
Top 3 Insights: