Step 1: Reading Data

1. Read social media data in Excel.

Step 2: Data Processing

1. Handle missing values.

2. Remove duplicates in all columns.

3. Filter data to rows that you want to include in your analysis.

Step 4: Data Visualization

1. Color code data.

2. Social Media monitoring dashboard consisting of line chart, bar chart, pie chart, and scatter plot.

Introduction to KNIME: Social Media Dashboard

Visual Analysis of Social Media Data

This workflow reads and manipulates social media data . Then the data is visualized into dashboards.

Step 2: Data Processing

1. Sum up like, comments, and share columns.

2. Rename to new column.

3. Advance data aggregation: counting the mean per date.

Step 2a: Data Cleaning

1. Filter data to rows that you

   want to include in your

   analysis