Power BI Pro: IN Inventory On Hand History

_IN_On_Hand_History: Power BI Pro Templates

This page describes DataSelf Pro’s customizable Power BI Templates for IN Inventory On Hand History.

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).

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.:

  • “Item - Historical On Hand KPIs: Core” report can be found in the “Core” worksheet on the “Item - Historical On Hand KPIs.pbix” workbook. In Power BI Tenant, search for “Item - Historical On Hand KPIs”, then click the “Core” view.

  • “Item - Historical On Hand KPIs: Whse” report can be found in the “Whse” worksheet on the “Item - Historical On Hand KPIs.pbix” workbook. In Power BI Tenant, search for “Item - Historical On Hand KPIs”, then click the “Whse” view.

Report List

Item - Historical On Hand: Cost by Company (1 KPI)
Item - Historical On Hand: Cost by Item (1 KPI)
Item - Historical On Hand: Cost by Item Cat (1 KPI)
Item - Historical On Hand: Cost by Whse (1 KPI)
Item - Historical On Hand: Qty by Company (1 KPI)
Item - Historical On Hand: Qty by Item (1 KPI)
Item - Historical On Hand: Qty by Item Cat (1 KPI)
Item - Historical On Hand: Qty by Whse (1 KPI)
Item - Inventory Turnover: Company (1 KPI)
Item - Inventory Turnover: Highest Avg Cost OH (1 KPI)
Item - Inventory Turnover: Highest Cost of Sales (1 KPI)
Item - Inventory Turnover: Item (1 KPI)
Item - Inventory Turnover: Item Cat (1 KPI)
Item - Inventory Turnover: Items Not Moving (1 KPI)
Item - Inventory Turnover: Slow Moving Items (1 KPI)
Item - Inventory Turnover: Top Items in a Period (1 KPI)
Item - Inventory Turnover: Top Items in a Year (1 KPI)
Item - Inventory Turnover: Top Items This Year (1 KPI)
Item - Inventory Turnover: Whse (1 KPI)
QA IN On Hand History: Cost by Item (1 KPI)
QA IN On Hand History: Cost by Item Cat (1 KPI)
QA IN On Hand History: Cost by Whse (1 KPI)
QA IN On Hand History: Qty by Item (1 KPI)
QA IN On Hand History: Qty OH Item Cat (1 KPI)
QA IN On Hand History: Qty OH Whse (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., Customer Relatioship Management 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.