Social Media Analytics Dashboard
•
Data Cleaning: Removed duplicate columns, merged hashtags using a delimiter, and
applied trimming functions for uniform formatting.
•
Dashboard Development: Designed an engaging dashboard using Adobe Photoshop
with a dark blue-cyan gradient theme and interactive elements.
•
Data Visualization: Created insightful charts, including tooltip charts for detailed
post metrics and interactive features for user engagement analysis.
•
Tools Used: Microsoft Excel for data preprocessing, Adobe Photoshop for dashboard
design, and Power BI for data visualization.