Introduction
A Dashboard is a visualization tool that displays important data through various charts and graphs, providing an overview of key metrics in architect. A good comparison is checking a car’s gauges, it is a good way to determine the health of a car. In our case, it is used to find the health of the supply chain when differing scenarios are run.
Gains’ will provide three important dashboards that is catered to your data:
Cost Analysis
Scenario Analysis
Base Scenario Validation
In these dashboards, we can utilize filters like specific output scenarios, distribution centers, customer sites, and products to simplify the process of identifying flaws in your supply chain
To view these created dashboards:
Select Dashboards in the left pane
You will see the three dashboards that were built on your data
You will find multiple charts in these Dashboards
To filter the charts:
Select the drop down for the following constraint types
Output Scenario
Servicing Site (Distribution Center)
Demand Product
Customer (Site)
Base Scenario
Now you can choose one or multiple options in each constraint type to filter your data which will be reflected in the charts
Instructional Guide
Exercise: Comparing the Landed Cost Among Customer Locations
General Overview:
What if you wanted to compare the Landed Cost among the different Customer locations?
Landed Cost can be described as the total cost of shipping products from a distribution center to a customer location. This cost includes shipping, handling, insurance, etc.
In this exercise we will use a map of US states to display the Landed Cost among the different customer locations. The larger the bubbles are, the higher the demand is for that customer location. The darker the bubble is, the more it costs to ship to a customer location.
Preparing Scenario for Landed Cost Dashboard
Before we create a Dashboard for Landed Cost, we must solve it ourselves. Executing the output for a scenario will not solve Landed Cost. By following the steps below, we are able to solve Landed Cost.
In the left pane, navigate to Output. After that, select Report.
For the “Pick 2 new DC” scenario, select the Dollar Sign under the landed cost column.
After a few moments, this symbol will change to a Download icon
Now the Landed Cost has been solved for “Pick 2 new DC”
Creating a Dashboard
In the left pane, select Dashboards
Select + Create New Dashboard
In the top right corner of the screen select + Visualization
From there select the option SQL Server Data Source
Picking Landed Cost Dashboard Preset
Now you can select the table that you want to build a dashboard from.
Use the search bar to find Landed Cost Summary
Select Landed Cost Summary
Choose the option Select Data
Overview of Formatting
Now you are presented with several options to format your chart
Changing the Chart Type
Change the chart type from Column to Scatter Map
Dragging Fields to Sections
Now you can begin to drag Fields to the different Sections
Fields are on the very left of the screen and the Sections are to the right of the Fields
Drag the Latitude field to the Latitude section
Drag the Longitude field to the Longitude section
Drag the Customer field to the Label section
Drag the AvgLandedCost field to the Color By Value section
Drag the TotalDemand field to the Bubble Radius section
Modifying Settings of a Field
After it has been dragged to the Color by Value Section, click on AvgLandedCost
Click the Aggregation section and select Average
Click the Fraction Digits section and select 4
Select Update Field
Adding a Filter to the Chart
Click on Add Visualization Filter + and select OutputScenario
Selecting an Element of the Filter
Select the created OutputScenario dropdown
Unselect the All option
Select the pick 2 new DC output scenario
Select Apply
Changing the Title
Click on the pencil icon to change the Title of the chart
Change the Title from “LandedCostSummary” to “Landed Cost Among Customers”
Saving the Chart
We have successfully created a chart that shows the Landed Cost among Customer locations
Explanation:
The larger the bubble is, the higher the demand is for a customer location.
The darker the bubble is, the more it costs to ship to a customer location.
Make sure to hit the Check Mark in the top right corner to save your changes
This will save the chart to the dashboard.
Saving the Chart
You have the option to add another chart to this dashboard by selecting + Visualization, but we will not do this
Instead, we will finish this exercise by selecting the Check Mark again
Now we have saved the dashboard to the environment
