Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Current »

This section will provide you with essential insights into Pricefx's Analytics functionality through Dashboards.

Dashboards enable you to efficiently establish the required data structures for promptly analyzing sales and customer data, with minimal effort and initial analysis process requirements. They are also essential in understanding price lists and grids and the relationships between different accelerators and capabilities in Pricefx.

In this section you will learn to explore Sales Insights and a few of the most commonly used dashboards, to help you make informed decisions based on analytical data.

Learn more about Dashboards here.

How To Explore Sales Insights

All our how-to guides and video tutorials contain screenshot of our demo system and the information that you see will differ depending on your organizational configuration and the version of Pricefx software that you are running.

Note that while you will be working for this course on the demo partition (if you have already requested one), on projects, to be able to use Dashboards you will need Product Master, Customer Master and Transaction data loaded into the Pricefx. In the demo partition, dummy data has already been uploaded for you.

image-20240409-170734.png

There are 9 dashboards including some variations of the dashboards (per customer and per product). For the purposes of this walkthrough, we will look at Sales Insights Revenue and Margin. Follow along in your petition to get used to the process.

image-20240409-170902.png

Explore the Sales Insights Revenue and Margin Dashboard

  1. To view the results, scroll trough the vertical bar and examine all the charts within this dashboard. One of the charts shows revenue and margin results per customer; hover over the colored dots to access additional details (display may vary).

image-20240409-171431.png
  1. To work with your dashboard and look at different datasets use the different filters provided. You can find them on the left side under Dashboard Settings and Data Filter options.

image-20240409-171748.png
 Check out the meanings of the available fields by opening this window.

Datamart - source of information used in the dashboard display.

Product field helps you to filter the information by products or group of products.

Customer field helps you to choose specific customers.

Date From and Date To defines from which period this data should be displayed.

Time Period groups the data in a certain manner, e.g., by week, month, quarter on base of the chosen above period.

Product Aggregation - Allows to define a custom grouping dimension to reduce the granularity of the product data.

Customer Aggregation – Allows to define a custom grouping dimension to reduce the granularity of the customer data.

Band By for Customer color coding customers on base of a certain criteria.

Band by For Product color coding products on base of a certain criteria.

Column chart axis type - option to select the chart type.

Currency – choosing a specific currency.

Generic Filter – can help you to filter your data further with different rules.

  1. If you want to see more filters, check the Set Filter button.

image-20240409-172422.png

To complete this step without making any real changes, simply Cancel.

All dashboards contain portlets (charts) that are customizable. You can rearrange them, add new portlets, and hide unnecessary ones.
5. To move a portlet, hover over the upper part until a palm icon appears instead of a cursor. Then, while holding the left click, move the portlet up or down.

Adjust the size of the portlet by using the arrow located in the bottom right corner.

  1. Add portlets through the action button Add Portlet in the top right corner of the browser window (display may vary).

image-20240409-173123.png
  1. To remove and/or export the portlets click on three dots on the portlet itself and choose from the available options in the dropdown.

image-20240409-173300.png
  1. You can save the changes to your dashboard as preferences. Do this either as a new preference or as an add-on to an existing preferences by clicking the Dashboard Options button (cogwheel) in the top right corner.

To see different types of information, you need to apply different filters.

Visualizing Data on Customer and Product Performance

  1. To evaluate your customers and products performance, for example, by specific period and industry you will need to use relevant filters.

  2. Use the magnifying glass icon to browse different customers.

  3. Click to select any number of customers you want for this exercise then click on Select Items.

    image-20240409-174353.png

  4. Fill the fields with the needed information.

  5. Click Apply Settings.

Now you can review the dashboard results. Hover around the charts to see more details (the display may differ).

image-20240409-174658.png

Outliers Dashboard

You can use the same process for other relevant dashboards.

Remember that when the system displays performance, like in the Outliers dashboard, worst performing customers are displayed in red while the ones with a good health score are green. You can use the filters again to select and display the information you want. To learn more details, hover over the pie charts.

For this example, we used the criteria below.

 Filtering information in Outliers dashboard

Product: BR1600SI, BN1350M2, BN1100M2, BR1000S-JP, BR1200S-JP

Customer: CID-0008, CID-0009, CID-0010, CID-0011 

Date from: 1/1/2023  

Date To: 12/31/2023

Product Aggregation: Product Id

Customer Aggregation: Customer Id

Calculation Model: (Max-Min) Split

KPI: Revenue

Top Product(s)/ Customer(s): 5

Currency: EUR

Once filled in , you will click on Apply Settings to review the new dashboard.

image-20240409-175410.png

Comparison Waterfall Dashboard

To view all pricing factors impacting revenue and margin for underperforming customers and products, access the Dashboards drop-down menu and choose the Comparison Waterfall option.

image-20240409-175614.png

This dashboard facilitates comparing the performance of the poorest customers and products over two years.

  1. Filter the data for two specific products and customers to create one series for the previous year and another series for the current year, assessing revenue and margin. Input the following filter values:

 Filter Values for Comparison Waterfall in Sales Insights > practice criteria

Comparison Type: Date

Products: BR1000S-JP; BN1100M2 (or your two lowest performance products identified)

Date From (1): 1/1/2022

Date To (1): 12/31/2022

Date From (2): 1/1/2023  

Date To (2): 12/31/2023

  1. Click Apply Settings to review the dashboard.

  2. Hover over the chars to see more details.

image-20240409-175949.png

If you want to filter information, you can also use the Set Filter option. Then, as usual, click on Apply Settings.

image-20240409-180121.png

  • No labels