SAP Analytics Cloud - Master Class

Navigate the SAP Analytics Cloud landing page to access stories, models, data sets, and files with customizable tabs, and build dashboards from models or data sets.

Create a dataset to support your first SAP Analytics Cloud story, preview the 29‑column retailer data, upload an Excel file, ensure headers, then import and name Sak Retailer Dataset.

Prepare your data by checking each column, distinguishing measures from dimensions, setting primary IDs and descriptions, choosing data types (nominal, ordinal, continuous, textual) and aggregation, then build hierarchies and save.

Prepare a professional and proven dashboard framework to boost efficiency in future projects. Gain practical application across work stories through thoughtful setup.

Explore SAC stories, choosing templates, smart discovery, or responsive, canvas, and grid pages. Adopt the optimized design experience, featuring scripting, an updated interface, and new functions.

Migrate a classic story to the optimized design experience, with a backup copy, and convert to overwrite the existing story to access new features.

Build a reusable dashboard framework in SAP Analytics Cloud by arranging text boxes, charts, and a logo with panels, lanes, and grid guides.

Switch between edit mode, view mode, and present mode to test dashboards as end users, and save as template with placeholders and data from a data set.

Create the first charts in sap analytics cloud for management dashboards by exploring numeric point charts, bar charts, and time series charts, and preview dashboards on different devices.

Build your first numeric point chart in SAP Analytics Cloud by adding a sales measure, optionally a second value, and adjusting formatting, title, and number scale for KPI display.

Build bar charts by setting sales as the measure and market as the dimension, then sort by sales and market, and adjust styling and axis alignment for a clean dashboard.

Add a time series chart, set sales as the measure and order date as the time dimension, and adjust granularity and hierarchies for a clean dashboard.

Explore device preview in SAP Analytics Cloud Master Class to test dashboards on desktop, mobile, and 4K, using auto mode, responsive rules, and widget sizing and hiding.

Explore interactivity in dashboards by upgrading from a static Excel-like report to a dynamic SAP Analytics Cloud view, adding linked analysis, filters, and variances.

Explore linked analysis in SAP Analytics Cloud to filter dashboards across all widgets on a page or story, enabling single-click deep dives and flexible filter management.

Learn how SAP Analytics Cloud filters shape dashboards, including story, page, and widget filters; grasp global vs page-level filters, group filters, linked analysis exceptions, and viewer creation limits.

Create a story filter with a dimension by selecting country in the filter bar, pinning the filter, and using dynamic or static member filtering plus paste filter values and wildcards.

Insert a page filter, select the country dimension, and set display. Use linked analysis to exclude total sales and enable cascading effects.

Use the widget filter with the country dimension to filter a chart, apply it to that chart only, then remove it to explore dimensions in filters.

Explore measures as filters in SAP Analytics Cloud, using profit with a dimension context like order ID and thresholds such as 1000 and 2000 via the story filter.

Explore time filters for reporting dashboards, learning to set fixed and dynamic ranges, lookbacks, and current-date offsets to display monthly, quarterly, or yearly sales.

Master variances in SAP Analytics Cloud to compare sales over time, visualize deltas with bars or integrated bars, and interactively analyze drivers by region such as Latin America and Mexico.

Explore how to customize tooltips in SAP Analytics Cloud by adding measures and dimensions to charts, using the builder tab and context menu. Note tooltips don't appear on mobile.

Explore advanced charts, add a detail page to your dashboard, and learn to create your own calculations and customized measures.

Switch to a pie chart for the two segments, consumer and corporate, show absolute values with zero decimals and inline legends, note no variances, and prefer direct labeling.

Create a tree map to visualize hierarchical dimensions, drill down from markets to countries, and compare sales figures with variance data and hover details.

Create a scatter plot with a calculated measure for return on sales, format as percentage, and drill into market details using linked analysis, portfolios, and reference lines.

Master restricted measures in SAP analytics cloud by displaying sales by product category, calculating category share, and comparing six markets in one trellis chart.

Create a heat map that shows the average order value by markets and discount categories using aggregation and measure-based dimensions.

Create a box plot to visualize sales distribution by order IDs, subdividing by market with a horizontal orientation to reveal right-skewed distributions, outliers, and a linked market deep-dive.

Explore advanced measures in SAP Analytics Cloud by expanding on calculated measures, restricted measure aggregations, and measure based dimensions, as we cover all remaining measures in this section.

Compute the date difference between two dates to measure days from order to ship, use average for day differences, and drill down by segment with selectable granularity.

Convert a dimension to a measure to enable calculations, using order id as an example and a max aggregation to display the maximum order id in a numeric point chart.

Create a calculated dimension using an if function to categorize sales by male and female customers based on the last digit of the customer ID, demonstrated on a bar chart.

Create a running total by cumulating sales over a time dimension with order date and monthly hierarchy, filtered to 2020, and explore using max as an operation in bar charts.

Jump into interactivity in the SAP Analytics Cloud master class, level two, covering input controls, advanced filters, and hyperlinks to elevate your dashboard experience.

Explore measure input control in the SAP Analytics Cloud master class, enabling users to switch between measures like profit, sales, and storage costs with title updates across charts and dashboards.

Utilize dimension input control to swap market hierarchies and subcategories, creating flexible scatter plots and exchangeable dimensions for interactive dashboards in sac.

Create advanced filters to handle complex exceptions across multiple dimensions, excluding TV sales in Latin America and combining markets with product categories for precise dashboards.

Design a Netflix-style KPI overview landing page with tiles linking to dashboards, a minimal time-series chart, and current-month KPI, enabling guided navigation to deeper details.

Explore commenting in SAP Analytics Cloud dashboards across widget, page, and story levels, with limits, tagging, and visibility in PowerPoint and PDF exports.

Explore SAP Analytics Cloud view settings, including view and present modes, toolbar customization, story filters, and per-chart controls for hiding, locking, and reordering widgets.

Discover why visual tables are underrated in dashboards and when to use them for details. Learn why geo maps are overrated and what better alternatives exist for effective data presentation.

This introduction to tables shows how to add a table to a dashboard and set rows, dimensions, and measures. Explore styling, sorting, in-cell charts, thresholds, and country–city dimensions.

Learn to build table calculations in SAP Analytics Cloud, including cumulative sum and accumulative share, using the formula editor, client calculations, and show/hide totals for dynamic analysis.

Apply thresholds as conditional formatting in sap analytics cloud to color a table of customer orders by return on sales, using id and a 5% threshold activated in the story.

Explore practical tips for table management in SAP Analytics Cloud, including drill limits, performance tuning, linked analysis filtering, freezing headers, reordering dimensions and measures, and manual column width control.

Master cross calculations in SAP Analytics Cloud to create restricted calculation shells that affect all measures, compare time ranges like H1 2019 and June 2019, and drive dashboards with input controls.

Learn how to prepare data for geo maps in SAP Analytics Cloud, assign coordinates to cities, and decide when geo maps add value for location analysis over typical KPIs.

Create a bubble map in SAP Analytics Cloud by using a geomap layer, configuring color by percentage, size by sales, and applying linked analysis to filter other charts.

Explore choropleth mapping in SAP Analytics Cloud master class, drill down from countries to states and cities, adjust color measures and gradients, and apply geo filters to analyze sales.

Overlap multiple layers in a geomap by adding a heat map to a flow layer, then adjust layer order and toggle visibility to assess usefulness.

Explore the publishing process of stories, learn how to use the bookmark feature, and discover methods to export data.

Publish the story to the catalog view on the home page, save it to favorites, and customize the tile with a description, image, and filters to boost engagement.

Save and retrieve dashboard views with bookmarks, naming and setting default or global bookmarks, access via the bookmark symbol, edit and share them, and tailor views with time settings.

Export csv and excel options in SAP Analytics Cloud. Export charts and tables with csv or excel, adjust number formatting, and use text to columns to split data.

Export SAP Analytics Cloud content as PDFs via File export; PDFs are high-resolution screenshots of story pages and appendix, and this demonstrates settings for story links and chart filters.