SAP DataSphere vs. SAP Analytics Cloud: From ZERO to a Predictive Analytics Dashboard for Sales.

I hope this post helps you in learning SAP DataSphere.

We can create an interactive analytical dashboard in SAP Data Sphere using the sample sales order data. With visualizations, filters, and predictive analytics, you are transforming raw data into actionable insights. SAP Data Sphere’s flexibility and powerful tools make it easy to create meaningful dashboards for any business use case.

Wagner Sabino .'.

Step 1: Getting a Trial Account for SAP Data Sphere

Before we begin, you'll need access to SAP Data Sphere. Here’s how to sign up for a free trial:

1. Visit the SAP Data Sphere Trial Page: Go to SAP Data Sphere Trial. Note: You will need an SAP account, which you can create for free if you don't have one.
2. Sign Up for the Trial: Click on the "Start your free trial" button. You’ll be prompted to log in or create an account. Once logged in, you can follow the instructions to activate your trial.
3. Activate the Trial: After creating your account, confirm your email address and follow the instructions to activate your trial account. Once your trial is active, you'll be able to access the SAP Data Sphere interface.
4. Access Your SAP Data Sphere Workspace: Once the trial is set up, navigate to the SAP Data Sphere dashboard. This is where you’ll create your data models, visualizations, and analytics.

Step 2: Importing Sample Sales Order Data

SAP provides sample datasets to help you get started. Follow these steps to import the Sales Order sample data:

1. Navigate to Data Builder: On the SAP Data Sphere main dashboard, look for the "Data Builder" tab on the left-hand menu and click on it. The Data Builder allows you to import, transform, and model your data.

1. Import Sample Sales Order Data: In the Data Builder, click on the "Import" button at the top-right corner. This will open a menu of options. From the available sample datasets, select the "Sales Order Sample" dataset.

1. Review and Confirm Import: Once selected, you will see a preview of the data. Confirm that this is the dataset you want to import by clicking "Next," and then complete the process by clicking "Import". The Sales Order data will now appear in your workspace under the "Data Sources" section.

Step 3: Building the Data Model

Before creating visualizations, we need to create a data model that organizes the sales order data into useful fields. Follow these steps:

1. Create a New Space: In SAP Data Sphere, data is organized into spaces. Go back to the main dashboard and click on "Spaces". Here, create a new space by clicking "Create Space" and give it a relevant name like "Sales Order Analysis".
2. Assign Your Data Source to the Space: In the newly created space, go to the "Data Builder" tab. You’ll see the Sales Order data that you imported. Drag and drop this dataset into your space.
3. Modeling the Data: Now, click on "New Graphical View" in the Data Builder. Select the Sales Order dataset as your input and choose the fields you want to work with, such as:

• Sales Order ID (SALESORDERID) – The unique identifier for each sales order.
• Partner ID (PARTNERID) – The customer or partner associated with the sales order.
• Gross Amount (GROSSAMOUNT) – The total amount of the sales order, including taxes.
• Net Amount (NETAMOUNT) – The amount after applying discounts and excluding taxes.
• Tax Amount (TAXAMOUNT) – The total tax applied to the order.
• Delivery Status (DELIVERYSTATUS) – The current status of the delivery process.
• Billing Status (BILLINGSTATUS) – The status of the billing process for the sales order.

Step 4: Creating Visualizations

With the data model in place, it’s time to create visualizations. Here’s how you can create charts, graphs, and tables:

1. Go to SAP Analytics Cloud: To start building visualizations, navigate to the "Story Builder" tab in the left-hand menu. This is where you’ll create interactive charts and tables.

Step 5: Adding Filters for User Interactivity

To make the dashboard more interactive, SAP Data Sphere allows you to add filters that help users explore the data in more detail. Here’s how we can add relevant filters based on your data:

Add a Date Range Filter:

1. In Story Builder, click the "Filter" icon at the top of the page.
2. Choose "Date Range" as the filter type.
3. Connect the filter to the "Created Date (CREATEDAT)" field. This will allow users to select a custom date range and view sales orders created within that timeframe.
4. This filter will help users analyze trends over specific periods, such as viewing sales in a particular quarter or year.

Add a Sales Organization Filter:

1. Next, add a filter for Sales Organization so users can focus on sales from specific regions or sales divisions.
2. Link this filter to the "Sales Organization (SALESORG)" field.
3. By applying this filter, users can narrow down the data to only view sales from certain sales organizations, helping them understand performance at a regional level.

Add a Partner ID (Customer) Filter:

1. Lastly, add a filter for Partner ID. This filter will allow users to isolate sales data for specific customers or partners.
2. Connect this filter to the "Partner ID (PARTNERID)" field from your dataset.
3. This filter will be useful for users who want to focus on the sales performance of specific customers, making it easier to drill down into customer-specific data and insights.? ? ? ? ? ? ? ? ??? ?

How Filters Enhance the User Experience:

By adding these filters, we give users the flexibility to explore the data in ways that matter to them. They can:

• Focus on sales from specific time periods (e.g., the last quarter or fiscal year).
• Analyze sales performance by region or sales organization.
• Drill down into data by specific customers (Partner ID), which is useful for customer analysis and segment-specific performance.

Step 6: Implementing Predictive Analytics

SAP Data Sphere allows us to use historical data to predict future trends and identify anomalies. Let’s implement predictive analytics to forecast future sales and detect unusual patterns in your sales data.

Go to Predictive Scenario:

1. Navigate to the "Predictive Scenario" section from the left-hand menu in SAP Data Sphere.
2. This is where you can build forecast models based on historical sales data to gain predictive insights.

Create a Sales Forecast:

1. Select "Time Series Forecast" as the type of predictive model.
2. Choose "Net Amount (NETAMOUNT)" as the target variable for the forecast. This will allow us to predict future net sales based on past trends.
3. Use "Created Date (CREATEDAT)" as the time field to predict future sales trends over time.
4. After configuring the model (e.g., defining time intervals such as monthly or quarterly forecasts), SAP Data Sphere will generate a sales forecast based on our historical data.
5. We can then display this forecast as a line graph in our dashboard to visualize future sales projections.

Anomaly Detection:

1. In addition to forecasting, you can enable Anomaly Detection in the Predictive Scenario section.
2. Choose "Net Amount (NETAMOUNT)" or "Gross Amount (GROSSAMOUNT)" as the target variable, depending on the type of anomalies we want to detect (e.g., unusually high or low sales amounts).
3. SAP Data Sphere will analyze your historical sales data and automatically flag any anomalies, such as:Sudden drops in sales.Unusual spikes in demand for specific customers or regions.
4. We can visualize these anomalies directly on your dashboard, helping your team investigate potential issues or capitalize on unusual growth patterns.

How Predictive Analytics Adds Value:

By using SAP Data Sphere’s predictive analytics capabilities, we can:

• Plan more effectively by forecasting future sales and identifying seasonal patterns.
• Detect and respond to anomalies in our sales performance, allowing you to address issues like unexpected sales drops or inventory problems.
• Visualize predictions easily in the dashboard, enabling your stakeholders to make data-driven decisions based on future trends.

Step 7: Sharing and Publishing the Dashboard

Once our dashboard is ready, we can share it with others or publish it for your team to access.

1. Publish the Dashboard:
2. Sharing Links or Embedding the Dashboard:

Final Note

Transforming raw data into predictive analytics and creative dashboards for any enterprise business use case.

I hope this post helps you in learning SAP DataSphere.

Wagner Sabino .’.