14 Ways to Create an Excellent UI for a Dashboard

Everything you would want to add to your dashboard can be found under the Insert tab. To begin, click the “Insert” tab and select SmartArt. SmartArt gives you dozens of options for organizing your dashboard, including flowcharts, matrices, pyramids and other shapes. You’re not limited to just one.

Create a story point

1. Click the New Story tab.
2. In the lower-left corner of the screen, choose a size for your story.
3. By default, your story gets its title from the sheet name.
4. To start building your story, double-click a sheet on the left to add it to a story point.
5. Click Add a caption to summarize the story point.

Create and Format Charts

1. In your Dashboard sheet, click Insert and select the kind of chart you’d like to make.
2. Right-click on the chart and click Select Data.
3. Click Add in Legend Entries (Series).
4. In the Series name field, click the title of the column you want to add on the Raw Data sheet.

I come from a sea-faring family, so when I hear the word dashboard the image that comes to my mind is the view of the nautical instruments the skipper or pilot sees at the helm. The pilot can see the sea and a series of displays which convey a large amount of information at a glance.

1. Decide on an End Goal.
2. Pick a Dashboard Type.
3. Use the Five-Second Rule.
4. Go Minimalistic.
5. Put Emphasis on Information Architecture.
6. Choose Your KPIs Carefully.
7. Provide Context.
8. Don’t Forget about Aesthetics.

Ardent’s Situational Awareness Dashboard provides real-time data visualization of natural threats impacting the Nation. Fill out the form below to learn more about the collected public data, the architecture behind the operations dashboard, or how we migrated this solution from our data center into a secure cloud.

A dashboard is a collection of views from multiple worksheets. A story contains a sequence of worksheets or dashboards that work together to convey information.

A workbook contains sheets. A sheet can be a worksheet, a dashboard, or a story. A worksheet contains a single view along with shelves, cards, legends, and the Data and Analytics panes in its side bar. A story contains a sequence of worksheets or dashboards that work together to convey information.

One dashboard can contain up to 20 components. Each component can be present in the form of a chart, table, or matrix….Components

• Horizontal bar chart.
• Vertical bar chart.
• Line chart.
• Pie chart.
• Donut chart.
• Funnel chart.
• Scatter chart.

An effective dashboard contains 3 elements, namely:

• Know Your Audience: determines which content and the level of details to include in the dashboard.
• Tell A Story: presents your findings in an intuitive way and illustrates the findings that support your statements.
• Leads to Action: makes connections and answers questions.

A user can access dashboards from the Dashboards tab, depending on the dashboard folder permissions and user permissions. One dashboard can contain up to 20 components. Each component can be present in the form of a chart, table, or matrix. On top of that, you can also select the Visualforce page component type.