Looker

Marketplace

Develop for Marketplace

Blocks

Cortex Data Foundation for SAP - Operational Dashboards

By Google
Common operational analytics dashboarding templates for data replicated from SAP S/4 or ERP into BigQuery leveraging Cortex Data Foundation content.
Common operational analytics dashboarding templates for data replicated from SAP S/4 or ERP into BigQuery leveraging Cortex Data Foundation content.

Version

v2.0.0

Release Notes

Category

Blocks

ETL Providers

N/A

SQL Dialects

Google BigQuery

Overview

Install this block for free by importing the project(s) from the GitHub repository linked at the top of the listing.

Easily run reports on your SAP ERP data all within Looker’s snappy, intuitive interface. Use this Block to deploy Cortex Data Foundation compatible Looker dashboards for common operational analytics including finance, order to cash and more. Customize for your business needs and get started quickly with sample dashboards included in this Block.

Order to Cash Analytics:

  • Order fulfillment: Identify potential issues and areas for optimization with a 360° view of delivery performance status including open orders, order cycle time, and on-time delivery in full.
  • Order status snapshot: Identify, act, and resolve potential issues faster with sales order health checks across order statuses like fill rate, return orders, canceled orders, average deliveries per order, and late deliveries.
  • Order details: Analyze and channel effective communication with customers with access to granular details at sales order level including order quantity and value, confirmed quantity, delivered quantity, and blocked orders.
  • Sales performance: Get trend analyses of sales performance by critical drivers like product, brand, category, customer, sales organization, distribution channel, and division.
  • Billing and pricing: Assess performance of billing and pricing metrics including billed quantity, tax amount, discount, rebate, list price, adjusted price, and intercompany price.

Financial analytics:

  • Accounts receivables: Identify receivables expected in the near future with the ability to drill by customer, company code, and invoice document.
  • Overdue receivables: Gain a view of overdue receivables and amounts to determine which customers require immediate monitoring and follow-up.
  • Days sales outstanding: Analyze sales vs receivables and the average days to collect payments to help identify and mitigate long term cash flow risks.
  • Doubtful receivables: Identify and gain insights into customers with the potential to become bad debt and help avoid risks.

Note: To use this Block, you will need to deploy Cortex Data Foundation for SAP BigQuery accelerator content. For more information and to install this content please visit Cortex Github. Please reach out to your account team or contact us for assistance. Bugs may also be raised in the Data Foundation repository here.

REQUIRED DATA: The datasets required by this Block can be obtained by following the installation and configuration instructions for the Google Cloud Cortex Framework.

Related Content

Amazon Redshift Administration

AWSFine-tune your Redshift deployment with a comprehensive view of performance and query analysis.Blocks

BigQuery Information Schema Performance Monitoring

LookerMonitor and Explore your BigQuery Usage and PerformanceBlocks

© 2021 Looker Data Sciences, Inc.
Privacy | Terms | Cookies