Dashboards Don't Change Business - People Do

Transcript

1. Dashboards Don’t Change Business – People Do. /in/kieramonaghan/ Speakerdeck.com/kieramonaghan www.km-analytics.com
2. I once built a dashboard that no one used…
3. 1. It was created in Looker Studio, was not intuitive, and required too many clicks to access the data. 2. The data was too complex for the audience, alienating them. 3. It was missing additional data sources.
4. Why should your audience care?
5. 1. Focus on the audience. 2. Create an emotional connection. 3. Who is your audience, why should they care?
6. Showcasing success offers new opportunities.
7. Owning, managing, and learning from failure.
8. Had a meeting with the stakeholders to understand their needs to make an effective dashboard.
9. Communication Collaboration Timing Trust What made the difference:
10. 1. Decision to create the dashboard in Power BI and embed into Microsoft Teams. 2. Evaluated the audience, choosing effective data visualisations. 3. Included additional data sources such as MSN News and Apple News.
11. 10 56 Unique Visitors to Power BI Dashboard Unique Visitors to Looker Dashboard
12. Embedding Power BI Dashboards in MS Teams. Teams needs the Power BI tab. You - Need a Viewer role in the workspace that hosts the item. You - Have permission to view the organisation app. Users – Are Teams users with access to the relevant channel and chat. Users – Have permission to view the items in Power BI
13. 1. Open a channel or chat in MS Teams and select the + icon 2. Select the Power BI 3. Select save to Add the Power BI tab and go to report configuration 4. You will see a configuration screen and be able to embed an item by pasting a link or browsing your workspaces.
14. Visualisations. This is the method of creating representations of information in graphs. It is important to choose the data visualisation technique based upon the data you are using, but also to support the data story you are telling throughout the report. Here is a list of some common data visualisation techniques: Pie Chart, Bar Chart, Gantt Chart, Choropleth Map, and Word Cloud just to name a few.
15. Pie charts. Pie Charts are one of the most common and basic data visualisations, utilised across a wide range of applications. They are best used to illustrate proportions, or part-to-whole comparisons. As they are simple to read, they are best placed to audiences who are unfamiliar with the data and only interested in key takeaways For those who seek a more thorough explanation of the data, a Pie Chart will not suffice.
16. Use a Pie Chart for Device Category and demographic splits.
17. Bar charts. One axis of the charts shows the categories being compared, and the other shows a measured value. Then the length of the bar indicated how each group measures according the value. An issue is that labelling, and clarity can be overlooked. This needs to be addresses so the viewer can clearly understand the data. One of the most common used data visualisations worldwide.
18. Use a Bar Chart for comparing Impressions/CTR, comparing metrics over time, and user journeys (funnel).
19. Gantt charts. For this, tactics to be deployed are listed on the vertical axis and time intervals on the horizontal axis. The horizontal bars in the body of the chart represent the duration of each activity. Gantt Charts are popular within project management, as they demonstrate project timelines or progression of tasks. Gantt charts are effective at showcasing timelines to enable viewers to understand every aspect of media activity deployed.
20. Use a Gantt Chart to demonstrate campaign overview detailing timelines of media deployed.
21. Choropleth maps. They use progressions of colours on a spectrum to distinguish high values from low. Choropleth Maps utilise shading and colours to visualize numerical values across geographical regions. It allows viewers to ascertain changes from one region to the next. However, a downside to these maps is this type of visualisation doesn’t provide exact numerical values.
22. Use a Choropleth Map when you have geographical data on regional or global campaigns.
23. Word clouds. The more a specific word is in the data set, the larger it appears in the visualisation. A Word Cloud, or a tag Cloud is a representation of text data in which the size of the word is proportional to its frequency. Usually used on websites and blogs to identify significant keywords and comparing difference between two textual data sources. They are also used in qualitative datasets, such as the specific words people use to describe a product.
24. Use a Word cloud when analysing keywords for PPC and SEO campaigns.
25. Key takeaways: 1. 2. 3. Make your dashboard about the audience and not yourself. Use the appropriate data visualisations to keep them engaged. Continuous improvement - ask questions of your audience.
26. How can you align your work to not just produce data, but move people?
27. Hey, I’m Kiera I deliver great user experiences online by utilising analytics data to its full potential, connect with me. + www.km-analytics.com /in/kieramonaghan/