This Excel dashboard was crafted to showcase the interactive potential of data visualization within the Excel environment. It is centered around the analysis of a freely available dataset related to social media activity. The primary objective was to provide diverse insights into understanding user behavior across various social media platforms and achieving different goals.
To bring this dashboard to life, I embarked on a structured data collection process, represented in the second image, where I meticulously gathered and organized the dataset. Furthermore, I devised several intricate formulas to extract and present accurate analytical results.
Key components of the dashboard include a Multi-Level Doughnut Chart, which elegantly illustrates traffic sources, a line chart to convey unique views data, and a bar chart to dissect revenue estimations.
This dashboard serves as a powerful tool for exploring social media dynamics, user behaviors, and revenue projections, all within the familiar Excel environment.