Power BI Pro: Inventory On Hand Today
_IN_On_Hand_Today: Power BI Pro Templates
This page describes DataSelf’s Power BI Pro customizable Templates for Inventory On Hand Today.
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., “- Cost on Hand Today: Item” dashboard can be found in the “Item” worksheet on the “- Cost on Hand Today.pbix” workbook. In Power BI Tenant, search for “Cost on Hand Today”, then click the “Item” view.
Dashboard List (with screenshot examples)
– Cost On Hand Today: Company (2 KPIs)
– Cost On Hand Today: Item (2 KPIs)
– Cost On Hand Today: Whse (2 KPIs)
– Qty On Hand Today: Company (2 KPIs)
– Qty On Hand Today: Item (2 KPIs)
– Qty On Hand Today: Whse (2 KPIs)
– Qty On Hand Today, On PO, On SO and Net: Company (2 KPIs)
– Qty On Hand Today, On PO, On SO and Net: Item (2 KPIs)
– Qty On Hand Today, On PO, On SO and Net: Whse (2 KPIs)
– Top Cost On Hand: Item (2 KPIs)
– Top Cost On Hand: Whse (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.:
“Qty On Hand Today” report can be found in the “Core” worksheet on the “Qty On Hand Today.pbix” workbook. In Power BI Tenant, search for “Qty On Hand Today”, then click the “Core” view.
“Qty On Hand Today: Whse” report can be found in the “Whse” worksheet on the “Qty On Hand Today.pbix” workbook. In Power BI Tenant, search for “Qty On Hand Today”, then click the “Whse” view.
Report List (with screenshot examples)
DataSelf Analytics: Days of Stock (1 KPI)
DataSelf Analytics: Items by Whse (1 KPI)
DataSelf Analytics: Slow Moving Items (1 KPI)
DataSelf Analytics: Stuck Items (1 KPI)
Item - Cost and Qty On Hand Today: Core (1 KPI)
Item - Cost and Qty On Hand Today: Whse (1 KPI)
Item - Qty On Hand Today: Core (1 KPI)
Item - Qty On Hand Today: Whse (1 KPI)
Item - Qty On Hand, On PO, On SO and Net Today: Core (1 KPI)
Item - Qty On Hand, On PO, On SO and Net Today: Whse (1 KPI)
Item - Cost and Qty On Hand Today: Core (1 KPI)
Item - Cost and Qty On Hand Today: Item (1 KPI)
Item - Qty On Hand Today: Core (1 KPI)
Item - Qty On Hand Today: Item (1 KPI)
Item - Qty On Hand, On PO, On SO and Net Today: Core (1 KPI)
Item - Qty On Hand, On PO, On SO and Net Today: Item (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 inventory management system (e.g., ERP 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 system’s tables (e.g., Item table from your ERP) and is modeled via Power BI Desktop.
Subject to change without notice. The actual templates can be slightly different than the documented ones.