Power BI Pro: SO Sales Order
Work in Progress. Please contact us!
_SO_Sales_Order: Power BI Pro Templates
This page describes DataSelf Pro’s customizable Power BI Templates for SO Sales Order.
KPI: A key performance indicator. Examples: a Report such as "Yearly Revenue"; a Dashboard widget (e.g., the main chart from the Cash Flow Projection dashboard); a Semantic Model measure (e.g., Cost of Sales from the _SI_SalesInvoice Semantic Model); a Semantic Model dimension (e.g., the Customer dimension from _AR_Aging_Today that provide the list of customers with open AR).
Dashboards
A Power BI Dashboard contains one or more Power BI Worksheets and/or other objects such as webpages.
Dashboard Naming Convention:
“Power BI Workbook name (pbix file)”: “Power BI Dashboard name (view name)”
E.g., “– Booked by Month: Company” dashboard can be found in the “Company” worksheet on the “– Booked by Month.pbix” workbook. In Power BI Tenant, search for “– Booked by Month”, then click the “Company” view.
Dashboard List
– Booked by Month: Company (2 KPIs)
– Booked by Month: Customer (2 KPIs)
– Booked by Month: Item (2 KPIs)
– Booked by Month: Salesperson (2 KPIs)
– Booked by Month: Ship To (2 KPIs)
– Fulfillment Rates: Fill Rate (3 KPIs)
– Fulfillment Rates: Fill Rate by Customer (3 KPIs)
– Fulfillment Rates: Fill Rate by Product (3 KPIs)
– Fulfillment Rates: Fill Rate by Salesperson (3 KPIs)
– Open Orders by Order Date: Company (2 KPIs)
– Open Orders by Order Date: Customer (2 KPIs)
– Open Orders by Order Date: Item (2 KPIs)
– Open Orders by Order Date: Salesperson (2 KPIs)
– Open Orders by Order Date: ShipTo (2 KPIs)
– Orders Not Shipped Prior Day: Orders Not Shipped Prior Day (2 KPIs)
– Top Booked this Period: Month (6 KPIs)
– Top Booked this Period: Quarter (6 KPIs)
– Top Booked this Period: Week (6 KPIs)
– DataSelf Analytics: SO Late & Pending by Customer (2 KPIs)
– DataSelf Analytics: SO Late & Pending by Item (2 KPIs)
– DataSelf Analytics: SO Late and Pending Panel (2 KPIs)
Reports
A Power BI Report is a Power BI Worksheet with a grid or chart. Report Naming Convention:
Main report of a Workbook: “Power BI Workbook name (pbix file)”
Slices of the main report: “Power BI Workbook name (pbix file)”: “Power BI Worksheet name (view name)”
E.g.:
“Customer - Booked Details” report can be found in the “Core” worksheet on the “Customer - Booked Details.pbix” workbook. In Power BI Tenant, search for “Customer - Booked Details”, then click the “Core” view.
“Customer - Booked Details: Salesperson” report can be found in the “Salesperson” worksheet on the “Customer - Booked Details.pbix” workbook. In Power BI Tenant, search for “Customer - Booked Details”, then click the “Salesperson” view.
Report List
All - DataSelf Analytics: SO Missed Shipments (1 KPI)
Customer - Booked Details: Core (1 KPI)
Customer - Booked Details: Item (1 KPI)
Customer - Booked Details: Salesperson (1 KPI)
Customer - Booked Details: ShipTo (1 KPI)
Customer - Booked per Month: Company (1 KPI)
Customer - Booked per Month: Core (1 KPI)
Customer - Booked per Month: Item (1 KPI)
Customer - Booked per Month: Salesperson (1 KPI)
Customer - Booked per Month: ShipTo (1 KPI)
Customer - Late Open Orders by Days Late: Core (1 KPI)
Customer - Late Open Orders by Days Late: Item (1 KPI)
Customer - Late Open Orders by Days Late: Salesperson (1 KPI)
Customer - Late Open Orders by Days Late: ShipTo (1 KPI)
Customer - Lost Sales by Order Month: Core (1 KPI)
Customer - Lost Sales by Order Month: Item (1 KPI)
Customer - Lost Sales by Order Month: Salesperson (1 KPI)
Customer - Lost Sales by Order Month: ShipTo (1 KPI)
Customer - Open Order Details by Expected Month: Core (1 KPI)
Customer - Open Order Details by Expected Month: Item (1 KPI)
Customer - Open Order Details by Expected Month: Salesperson (1 KPI)
Customer - Open Order Details by Expected Month: ShipTo (1 KPI)
Customer - Open Orders All: Core (1 KPI)
Customer - Open Orders All: Days Late (1 KPI)
Customer - Open Orders All: Item (1 KPI)
Customer - Open Orders All: Salesperson (1 KPI)
Customer - Open Orders All: ShipTo (1 KPI)
Customer - Orders with Shipment Expected Yesterday: Core (1 KPI)
Customer - Orders with Shipment Expected Yesterday: Item (1 KPI)
Customer - Orders with Shipment Expected Yesterday: Salesperson (1 KPI)
Customer - Orders with Shipment Expected Yesterday: ShipTo (1 KPI)
Item - Late Open Orders by Days Late: Core (1 KPI)
Item - Late Open Orders by Days Late: Customer (1 KPI)
Item - Late Open Orders by Days Late: Salesperson (1 KPI)
Item - Late Open Orders by Days Late: ShipTo (1 KPI)
Item - Lost Sales by Order Month: Core (1 KPI)
Item - Lost Sales by Order Month: Customer (1 KPI)
Item - Lost Sales by Order Month: Salesperson (1 KPI)
Item - Lost Sales by Order Month: ShipTo (1 KPI)
Item - Open Orders All: Core (1 KPI)
Item - Open Orders All: Customer (1 KPI)
Item - Open Orders All: Days Late (1 KPI)
Item - Open Orders All: Salesperson (1 KPI)
Item - Open Orders All: ShipTo (1 KPI)
Item - Open Orders with Shipment Expected Today: Core (1 KPI)
Item - Open Orders with Shipment Expected Today: Customer (1 KPI)
Item - Open Orders with Shipment Expected Today: Salesperson (1 KPI)
Item - Open Orders with Shipment Expected Today: ShipTo (1 KPI)
Salesperson - Booked per Month: Core (1 KPI)
Salesperson - Booked per Month: Customer (1 KPI)
Salesperson - Booked per Month: Item (1 KPI)
Salesperson - Booked per Month: ShipTo (1 KPI)
Salesperson - Lost Sales by Order Month: Core (1 KPI)
Salesperson - Lost Sales by Order Month: Customer (1 KPI)
Salesperson - Lost Sales by Order Month: Item (1 KPI)
Salesperson - Lost Sales by Order Month: ShipTo (1 KPI)
Semantic Model
Semantic Models allow users to easily and quickly do ad hoc analysis and customize reports, dashboards, and stories. This properly deployed Semantic Model will contain data from your Sales system (e.g., ERP, POS, and/or Excel/CSV files) refreshed on a schedule (e.g., every night, hour, or minute).
A Power BI Semantic Model contains data and a data model that prepares your raw data for powerful reporting. Semantic Models include dimensions, hierarchies, measures, and parameters that can be used in reporting. Semantic Models' data come from source systems' tables (e.g., Item table from your ERP) and are modeled via Power BI Desktop.
Subject to change without notice. The actual templates can be slightly different than the documented ones.