Power BI Examples and Architecture | CLEARIFY

Power BI Data Models in QQube Version 10

QQube Version 10 contains examples (.pbix files) for each of the data models included in the product.  There are approximately 5,700 DAX Measures available for drag and drop usage, and were formulated under the watchful eyes of some of the most world renowned DAX experts.

Click on a data model link to view the included examples, measures, and overall architecture:

DATA MODELS		TOTAL DAX MEASURES
Customers and Receivables
	Sales	450
	Open Sales Orders	57
	Accounts Receivable	35
Jobs, Time, and Mileage
	Job Cost Details	498
	Time Tracking	186
	Vehicle Mileage	153
	Flexible Custom Period Financials
	Profit and Loss by Job	219
	Profit and Loss by Job by Class	219
Inventory
	Inventory Management	443
	Bill of Materials
Vendors and Payables
	Purchases	208
	Open Purchase Orders	54
	Accounts Payable	35
Payroll and Human Resources
	Payroll	393
Financial Statements
	Standard Monthly Period
	Balance Sheet	155
	Profit and Loss	207
	Statement of Cash Flows	88
	Advanced Monthly Period   [QUICKBOOKS ENTERPRISE ONLY]
	Profit and Loss with Actual, Budget and Forecast	0
	Flexible Custom Period    [QUICKBOOKS ENTERPRISE ONLY]
	Balance Sheet	82
	Profit and Loss	251
Financial Statements by Class
	Standard Monthly Period
	Balance Sheet	74
	Profit and Loss	207
	Statement of Cash Flows	88
	Advanced Monthly Period     [QUICKBOOKS ENTERPRISE ONLY]
	Profit and Loss with Actual, Budget and Forecast	0
	Flexible Custom Period     [QUICKBOOKS ENTERPRISE ONLY]
	Profit and Loss	251
Financial for 52/53 Tax Year
	52/53 Periods Profit and Loss     [QUICKBOOKS ENTERPRISE ONLY]	192
	52/53 Periods Profit and Loss by Class     [QUICKBOOKS ENTERPRISE ONLY]	192
General Ledger and Accountant
	Standard Trial Balance
	Trial Balance (All Dates)	0
	Trial Balance - Current	8
	Trial Balance Activity	345
	Trial Balance Activity by Class	174
	General Ledger Detail	214
	Profit and Loss Detail	139
	Fixed Assets	29
	Cash Position	22
Auditing
	Audit Trail	16
Totals		5684