Learning SAP Analytics Cloud

Table of contents

1. Preface
   1. What this book covers
   2. What you need for this book
   3. Who this book is for
   4. Conventions
   5. Reader feedback
   6. Customer support
      1. Downloading the example code
      2. Downloading the color images of this book
      3. Errata
      4. Piracy
      5. Questions
2. Getting Started with SAP Analytics Cloud
   1. Anatomy of SAP Analytics Cloud
      1. The Home screen
      2. The main menu
   2. Data sources and models
      1. Create a direct live connection to SAP HANA
      2. Connecting remote systems to import data
      3. Connect Google Drive to import data
      4. Refreshing imported data
   3. Visualization
   4. Collaboration
   5. Presentation
   6. Administration and security
   7. Signing up for the trial version
   8. Summary
3. Models in SAP Analytics Cloud
   1. Understanding measures and dimensions
   2. Planning and analytical models
   3. Creating a new analytical model
      1. Selecting a source file
      2. Setting name, description, and other parameters for the model
      3. Setting dimension type
      4. Creating a location dimension
      5. Deleting unnecessary columns from the model
      6. Creating a hierarchical relationship between two columns
   4. Viewing the model in the modeler interface
      1. The time dimension
      2. Account dimension
      3. Private dimensions
   5. Browsing models
      1. Copying a model
      2. Deleting a model
      3. Clearing model data
   6. Viewing model data
      1. Viewing numerical data
      2. Viewing data graphically
      3. Observe some more data filtration
   7. Summary
4. Planning model
   1. Creating a planning model
   2. Visualizing planning model data
   3. Viewing the text data
   4. Spreading, distributing, and assigning values
   5. Creating private versions
   6. Summary
5. Creating Stories Using Charts
   1. Demo models
      1. The Best Run demo model
      2. The Planned Events model
         1. Creating a new story
         2. Selecting a model for the story
         3. Creating a numeric point chart to show net revenue
   2. The calculation editor
   3. Apply conditional formatting using thresholds
      1. Gross margin numeric point chart
      2. Styling tiles
      3. Gross margin percentage numeric point chart
      4. Create a calculated measure - Gross Margin %
         1. Formatting a measure
         2. Viewing calculated measures in data view
   4. Presenting data with a line chart in a story
      1. Applying filters to the time dimension
      2. Creating a bar chart
      3. Drilling up and down in a chart
      4. Creating a stacked Bar/Column chart
      5. Creating calculated and restricted measures with input control
      6. Creating Calculated Measure and input control
      7. Adding values to input control
      8. Creating a Restricted Measure
      9. Creating the Difference From measure
   5. Summary
6. Extending Stories with KPI, Filters, and Other Handy Objects
   1. Key performance indicators (KPIs)
   2. Story and page filters
   3. Creating a chart to display key performance indicators
      1. Setting a chart's attributes
   4. Adding a reference line to a chart
   5. Setting individual chart filters
      1. Adding a page filter
         1. Adding a page filter for products
      2. Adding a location page filter
      3. Adding a story filter
      4. Creating a linked analysis
   6. Adding dynamic text
   7. Adding static text
      1. Adding shapes
      2. Adding images
         1. Present mode
   8. Creating hyperlinks
   9. Examining data behind a visualization
      1. Setting styling preferences for your story
   10. Creating an aggregation calculation
   11. Pinning and commenting on a data point
   12. Saving your story
   13. Summary
7. Analyzing Data Using Geomaps and Other Objects
   1. Working with story pages
      1. Adding comments to a page
      2. Creating a geomap with a bubble layer
   2. Location clustering in geomaps
      1. Creating a geomap with a choropleth layer
   3. Applying a filter to a geomap
   4. Linking different models
      1. Create a chart based on linked dimensions.
      2. Join types
      3. Intersecting data example
   5. Creating a combination column and a line chart
   6. Using predictive forecasting through a trend time series chart
      1. Adding a forecast
      2. Modifying forecast
      3. Adding a time calculation
   7. Summary
8. Working with Tables and Grids
   1. Copying objects between pages
   2. Applying ranking
   3. Copying objects to the same page
   4. Grids and tables
   5. Working with tables
   6. Applying filters to a table
   7. Showing/hiding table elements
   8. Sorting table data
   9. Showing totals
   10. Applying a date filter
   11. Testing the effects of page filters on a table
   12. Styling tables
   13. Creating formatting rules
   14. Setting visibility filters
   15. Swapping the table axis
   16. Freezing table rows and columns
   17. Using KPIs in a table
   18. Working with grids
   19. Creating a blended table
   20. Copying objects, pages, and stories
   21. Copying grouped objects
       1. Copying pages with all objects
       2. Copying an entire story
   22. Saving a story as a PDF
   23. Creating a personalized dashboard by pinning story objects
       1. Pinning story objects
   24. Adding text notes to the home screen
   25. Summary
9. Collaboration
   1. Creating an events and tasks workflow
   2. Creating an event
   3. Creating tasks
      1. Displaying and monitoring events and tasks
   4. Events toolbar
   5. Sharing a story with colleagues and granting access privileges
   6. Collaborating via discussions
   7. Sharing files and other objects
   8. Summary
10. Digital Boardroom
    1. Optimizing the display
    2. Creating an agenda
    3. Creating agenda sub-items
    4. Enabling data exploration
    5. Setting navigation targets
    6. Enabling touch cell input
       1. Setting preferences
       2. The Digital Boardroom page
    7. Starting a meeting
       1. Inviting people to the meeting
       2. Starting a presentation in a meeting
    8. Adding annotations
    9. Stopping an online meeting
    10. Summary
11. System Administration
    1. Creating users
    2. Setting a user password
    3. Changing passwords
    4. Importing users
    5. Exporting users
    6. Deleting users
    7. Assigning roles
       1. Assigning a single role to multiple users
       2. Assigning or updating an individual user's role
    8. Built-in roles
    9. Creating a new role
    10. Role settings
    11. Permissions
    12. Test role permissions
        1. Update user profile
    13. Forming teams
    14. Transferring the system owner role
    15. Setting security for models
    16. Monitoring user activities
        1. Monitoring data changes
    17. Monitoring the system
    18. Deployment
    19. The export process
    20. The import process
    21. Summary