The final dashboard combines all required information in three pages, grouping the key results in a summary page and the two other tabs focusing on the specific areas of work: events and products.
Sample of Dashboard with mock data
The overview page provides a snapshot view for artisan of all their data sources, how social media channels are performing overtime, and the best selling products and events. The data sources combined in this dashboard included Eventbrite, Shopify, Facebook and Instagram in a basic data pipeline with transformations done in Power BI and data stored in Excel. The next step would be to automate the data pipeline by using technologies such as Azure Data Factory to minimise the human intervention needed to achieve the same result.
The top row of area charts displays a metric from each data source overtime and a KPI comparison to last year. Followers and engagement are measured overtime for the social media channels as an indicator of audience health. The data pulled for Shopify and Eventbrite in the snapshot shows how overall finances and event attendance are tracking overtime. This panel acts as a single source of truth for the marketing team.
The bottom left line graph shows a visual correlation of engagement from social media channels to finances from their sales platforms. The question that this answers is if social media engagement can impact the sales of products on different platforms. The marketing team will be able to use the donut charts to make decisions based on what products are currently performing well, to either continue to promote those, or boost less popular product types and see what effect this has. This decision making process will replicate for the events held by artisan.
From the overview, the user can then investigate data and answer questions relating to the facilitators and events data. This view uses the same layout as the overview to provide visual consistency for the user to locate data. The purpose of these metrics is to indicate the financial stability of facilitators and their events. The artisan team can use these metrics to understand how their efforts are impacting the greater community. artisan can also use Power BI filters to cut the data in different ways to report on and understand how individual facilitators are performing.