ℹ️Objective: Style and theme a dashboard for easier readability and a better look and feel.
Estimated Time: 25 mins
Exercise Description: You have created an analytics dashboard with visualizations that show variances and thresholds, you added interaction for our viewers, but before you share the dashboard with your colleagues at BestRun, you need to make sure your dashboard is not only insightful but also looks visually appealing.
Key Features:
- Learn about the styling panel and how to format your visualizations
- Learn how to simplify your visualisations by hiding unnecessary information
- Learn how to add an image or a logo to your dashboard
- Use Device Preview to preview your analytical content across various devices and screen sizes (i.e. Laptop, Tablet, Phone)
ℹ️Exercise check! Does your dashboard look like this screenshot?
In this section we will cover theme and styling options in SAP Analytics Cloud to tweak your story into a professional dashboard.
🚩Story creators can quickly change styling options for an entire story in the story preferences. This enables users to quickly apply corporate themes and sync their styling across different dashboards. We will first apply color and table preferences in this menu.
-
Click File
-
Click Edit Story
-
Click Preferences
ℹ️Welcome to Story Preferences!
In story preferences, story creators can choose to set standard theme and styling options for their entire story. This enables the business user with ease in quickly styling their entire story. Creators can choose to apply story preference changes to all pages, lanes, and tiles or only to newly created pages, lanes, and tiles.
- Click Charts/Geo
🚩Let us apply a custom color palette to our story that is based on our corporate colors
-
Expand Standard Color Palettes
-
Click Create New Palette
-
Expand Number of Swatches
-
Change Number of Swatches to six
ℹ️SAP Analytics Cloud offers a variety of color entry options to maximize your ability to stylize your story.
- Change each swatch's hexcode.
Swatch 1: f4f4f4
Swatch 2: ccccce
Swatch 3: 8c8a8a
Swatch 4: fc5411
Swatch 5: fc7928
Swatch 6: f9c43e
- Click Create
🚩We want to apply this color palette to everything on our story, so we change the option to All.
- Click All pages, lanes, and titles
- Scroll untill Default Styling Template is Visible
🚩We can choose different styling templates for our charts and tables based on dashboard needs. In this instance, we want our tables to appear in report-styling.
-
Expand Default Styling Template
-
Click Report Styling
ℹ️In the previous section we manually changed the format of thresholds for an individual chart. In story preferences we can choose to sync apply this format across our entire story.
-
Expand Default Threshold Style
-
Click Color Values
-
Click OK
- Click Apply
🚩We want to remove the empty header in our top lane and create a summary lane with KPIs for our story that stands out.
-
Right Click the Title field in our Top Lane
-
Click Remove
-
Click and Drag the Numeric Point Chart to the Right
-
Drop the Numeric Point Chart Here
-
Click and Drag the Numeric Point Chart to the Right
-
Drop the Numeric Point Chart Here
-
Click and Drag the Numeric Point Chart to the Right
-
Drop the Numeric Point Chart Here
ℹ️We have created some space on the left of our top lane for corporate branding covered later in this section. Let’s edit the charts on our dashboard to declutter the view.
🚩We can also easily customize the backgrounds of each lane to section our dashboard into logical segments. Let’s accent our top lane to highlight the KPIs.
-
Click the Top Lane with the Numeric Point Charts
-
Click Designer to Open the Styling Point Charts
-
Click Styling Panel (in case not already selected)
-
Click the Paint Bucket for Lane Styling Options
- Choose Black Color
🚩We can also change the background of the left lane to separate the input controls from visualizations.
- Click Left Lane
🚩Instead of using a solid color, we can apply a custom gradient to our story.
-
Expand Lane Background Color
-
Click Gradient
-
Click Gradients to expand
-
Click Create New Gradient
🚩In the gradient creation menu, users can apply specific colors on the gradient range or add additional swatches within the gradient.
-
Click on first swatch
-
Click hex to ccccce
-
Click on second swatch
-
Click hex to f2f2f2
-
Click Create
🚩Now our story has lanes that are clearly differentiated into logical segments. Utilizing background is a great way to enhance your dashboard for clarity. We can notice that the color of our KPIs do not stand out against the dark background. Let’s change the font color so they are accented appropriately.
- Click on Gross Margin Numeric Point Chart
-
Expand Font Colors
-
Select the White Swatch
- Click on Sales Revenue numeric point chart
-
Expand Font Colors
-
Select the White Swatch
- Click on Avg Sales Revenue numeric point chart
-
Expand Font Colors
-
Select the White Swatch
- Resize your numeric point charts so they are smaller.
🚩In responsive pages, the story is divided into cells that are used to format the placement and size of all elements on the story. This enables the story view to be easily converted for viewing on a variety of device formats, including mobile. Users can choose to change the size and spacing between cells.
ℹ️We will also now resize the other charts in our story. It is recommended to leave white space in between charts for better visual clarity.
🚩After some resizing and moving charts, our story looks like this! There are still some details we can polish in our charts.
🚩Currently our KPIs are showing granular information. For better readability, we should reduce the number of significant digits. Let us format these numbers in our dashboard.
- Click on Gross Margin numeric point chart
-
Click Designer to Open the Builder Panel (in case if not already open)
-
Switch to Styling Panel (in case not already open)
- Scroll to the Bottom of the Styling Panel to Number Format
🚩It is recommended to use auto-formatted scale for numbers in your dashboard as SAC will automatically adjust the scale based on the context of your data. You can also use scale formatting to change the way scale is being displayed
-
Expand Scale
-
Click Auto-formatted
- Click the Sales Revnue numeric point chart
-
Scroll to the Bottom of the Styling Panel to Number Format
-
Expand Scale
-
Click Auto-formatted
- Click the Avg Sales Revnue numeric point chart
-
Scroll to the Bottom of the Styling Panel to Number Format
-
Expand Scale
-
Click Auto-formatted
🚩Now that we have formatted our KPIs, we can hide any redundant information in our charts.
- Hold Shift and Left Click the Three
Numeric Point Charts
🚩We can choose to hide a variety of different details on our charts so only the important elements are visible. Let’s hide the chart title and subtitle for now.
-
Click More Actions
-
Click Show/Hide
-
Deselect Chart Title
-
Deselect Subtitle
ℹ️Let us now improve the number formatting for our other charts to improve the readability for our story viewers. First, change the formatting for our time series chart.
- Click Gross Margin per Order Date for Actual Chart
-
Click Designer to Open the Builder Panel (in case if not already open)
-
Switch to Styling Panel (in case not already open)
-
Scroll to the Bottom of the Styling Panel to Number Format
-
Expand Scale
-
Click Auto-formatted
🚩Next, change the formatting on our bar chart for sales manager metrics.
- Click Gross Margin per Sales Manager Chart
-
Scroll to the Bottom of the Styling Panel to Number Format
-
Expand Scale
-
Click Auto-formatted
🚩You can also change the decimal places in the Styling Panel
- Click Expand
- Select 0 decimal places
🚩We will now look at editing our Geo Map visualization to fit the styling of the rest of our story.
- Click the Geo Map
-
Switch to Builder Panel
-
Click OK to move out of Builder Layer 1
🚩Depending on the geo visualization layer and your data, there are a variety of different basemap types that can be applied to your geo map to best represent your data. We will choose a darker layout.
-
Expand Basemap Options
-
Click Transparent Dark Gray
🚩Let us theme the choropleth layer data to be colored with a more accurate gradient.
- Click Edit Layer
🚩Let’s create a custom gradient for the choropleth colors that matches the corporate colors we chose for our story.
-
Click Expand on Avg Delivery Time
-
Click Expand Palette
-
Click Add New Gradient
-
Click the first swatch
-
Change the hex to ccccce
-
Click the second swatch
-
Change the hex to fc7928
-
Click Create
🚩Next, we will look at formatting text and titles on our story. Let us first rename our input controls by double-clicking on their name.
-
Rename New Measure Input Control to Measure by double clicking on the heading
-
Rename New Dimension Input Control to Dimension by double clicking on the heading
🚩We can add a dynamic text title for our lane of charts so other analysts viewing our story can quickly understand the context of our visualizations. Let us add a title for the chart section that dynamically represents the data presented.
- Rename Click to Enter Title... to Overview for
🚩We can now create a dynamic text field that updates with input control selection.
-
Right Click Insider the Header to Open the Context Menu
-
Click Dymanic Text
ℹ️Welcome to Dynamic Text!
Dynamic text can be created in your story and are automatically updated based on the selected filters or input controls specified in this menu. This means that your story dashboard will automatically update with headers and titles suited to the context of your data.
🚩Let us create a dynamic text based on the region filter we have applied on the page.
-
Click Dimension
-
Expand ANA260_ORDER_FINANCE
-
Click Region
-
Click Create
🚩You have just created your first Dynamic Text. This text field will automatically update with the Page Filters applied on Region.
- Add Regions at the End of the Header
ℹ️Let’s add a corporate logo to finalize the look of our dashboard!
- Click the Top Lane with the Numeric Point Chart
ℹ️In order to upload the corporate logo to SAP Analytics Cloud, we need to first download it from the GitHub page for this workshop under teched2021-ANA260
- Click Excercises
- Click Resources
- Click logo.png
- Click Download to download the file
-
Click Insert
-
Click Image
🚩We want to upload a company logo from local files to our story. For best performance, it is recommended to use vector images.
- Click Upload in the Builder Panel
- Select logo.png from your downloaded files
- Click logo.png
- Resize the Image as Tall as the Numeric Point Charts
Our page looks great with all the styling changes we have made. We should now rename the page in our story accordingly
-
Click Expand on Page 1
-
Click Rename
-
Rename the story page Overview
-
Click Rename
🚩Now that we have stylized our story, users can choose to preview their responsive page in a variety of device formats. We know that our executives will be consuming this dashboard on multiple devices. Thus, we want to make sure the dashboard looks great when displayed on mobile.
-
Click Format
-
Click Device Preview
ℹ️Welcome to Device Preview!
From the preview screen, you can change the device or size to see how your page looks. In some cases, tiles resize and flow to fit smaller resolution screens when space becomes limited.
-
Click Expand Device
-
Click iOS
🚩We can that the numeric point charts on iOS are larger than necessary. Let’s fix the size in the Designer panel.
- Click the numeric point chart
- Click Designer
🚩We can change the font scaling for individual charts. All changes will only be reflected in the specified device format and do not change the original story.
- Change the Font Scale from 100% to 86%
- Click the second numeric point chart
- Change the Font Scale from 100% to 86%
🚩We have now customized the scaling of our story for a specific platform (Small iOS Phones). Does your story look like this screenshot in Device Preview?
- Click Device Preview to leave this view
🚩Story creators can also easily swap to view mode on the top right. This enables the user to see what viewer behavior is like on the story page with input controls and Explorer view.
- Click View Mode
ℹ️You have now completed Theme and Style section! In this section, we have learned how to apply overall style changes in story preferences, hide and show chart features, change lane and font colors, auto format numbers, apply visual changes to geo maps, create dynamic text in our story, add external images, and edit the scaling of our story on different device formats.
You have completed the entire Theme and Style section!
You are now able to:
- Use the styling panel
- Simplify your visualisations by hiding unnecessary information
- Add an image or a logo to your dashboard
- Use Device Preview to preview your analytical content across various devices and screen sizes (i.e. Laptop, Tablet, Phone)