SAP Analytics Cloud (SAC) Full Course

Compare live and input data connections; live connections reflect changes in real-time, while input connections replicate data and enable model reuse, with refresh or scheduling to update.

Explore how SAP Analytics Cloud retrieves real-time data without storing it, using metadata to drive visualizations, authorize access, and define aggregation levels for live stories.

Learn how a reverse proxy acts as a middleman between the api and the data to overcome the same-origin policy and enable live data access.

Import data connections replicate data flows into Sipi Analytics cloud before visualizations, using an advanced data modeling and storage engine via the analytics cloud connector and agent.

Explore how SAC connects via cloud connector and secure tunnel to fetch data through database drivers, store it in data models, and refresh on schedule, with recreated authorizations during import.

Create a direct analytics model in SAP Analytics Cloud by adding dimensions—order date, customer, product—and a sales measure, then save as direct sales model.

Explains the modeler navigation in SAC, highlighting the wrangling screen, undo/redo, view options, visibility toggles, sorting, hierarchy creation, calculated columns, data merging, and the sidebar for configuring models.

Read stories to analyze data with interactive reports and dashboards, using pages of widgets like charts and tables that connect to data sources or models, with templates or page creation.

Choose canvas, responsive, or grid pages to structure stories; canvas allows overlapping widgets, responsive enforces non-overlap and device adaptation, and grid displays data in tables.

Explore the story builder interface in sap analytics cloud, insert widgets and charts, edit in builder or styling mode, and export to pdf or google slides, then publish to catalog.

Explore the builder panel in sac by adding charts to a story, selecting and blending data models, and configuring chart types, colors, filters, and style options.

Explore how to apply conditional formatting in SAP Analytics Cloud using thresholds and measure comparisons, defining color thresholds for sales and sales aftertax, and saving your story.

Learn how to use the action bar in SAC to sort and rank data in charts and tables, enable linked analysis, and customize visuals with insights and controls.

Explore how hierarchies in a dimension enable drill down and roll up, visualized with pie charts of technology, machines, phones, and furniture, with legends for deeper drill paths.

Create and customize a table in SAP Analytics Cloud by adding dimensions such as date, product name, and region, then add measures and apply filters to organize data.

Explore the table action bar in SAP Analytics Cloud, including drill down on hierarchies, freezing columns, swapping axes, and auto-adjusting cell visibility for effective table presentation.

Explore table formatting in SAP Analytics Cloud: customize an entire table, individual columns, or a single cell, apply styling, thresholds, totals, freezing, sorting, templates, and column management.

Learn to apply page filters and story filters in SAC, using input controls to filter by dimension or subcategory, with cascading effects, hierarchical values, and dynamic or fixed date ranges.

Create calculated measures in the SAC calculation editor, add new chart elements, apply restricted measures by dimensions, use functions and aggregations to compute totals like tax and sales.

Style stories by designing dashboards in SAC: arrange charts, name the dashboard, and customize borders, colors, fonts, and the canvas while formatting data in thousands and adding input controls.

Blend data from multiple sources by linking two models on a common column. Blend occurs at the aggregation level, with joins on the lowest possible level.