You can use Microsoft Power BI Desktop with the Printix Power BI solution to get insights about your print usage, printers, print queues and much more.
- Install Power BI Desktop.
- Download the Printix Power BI Desktop file.
- Connect to your extracted Printix data.
See also:
DISCLAIMER
- Printix, or any contributor to these reports is not responsible and therefore not liable for any damage caused by usage of these reports.
- These reports are purely indicative.
- Values in for example the Cost report may vary and show different amounts and volumes than stated on invoices issued by your print provider.
Install Power BI Desktop
- Visit powerbi.microsoft.com.
- Download and install Power BI Desktop (it is free) on a Windows computer.
Download the Printix Power BI Desktop file
- Visit github.com/printix/Power-BI/releases.
- In the Latest release section scroll to and select Assets to expand this section.
- Select Source code (zip) to download the Power-BI-n.n.n.zip file. Where n.n.n is the version number.
- Extract the files from the Power-BI-n.n.n.zip file.
Connect to your Printix extracted data
Printix database
- Open Power BI Desktop.
- On the File menu select Open, and browse to the folder where you extracted the Power BI files.
- Select Power BI template files (.pbit) as file type.
- Select the file PowerBI/Printix.pbit and select Open.
- Enter your values and select currency. Select Load.
- Sheets per tree
Recommended value: 8333. Enter the number of sheets produced from a tree. Used in the report: Tree-O-Meter. - Cost per mono sheet
Enter the cost per mono impression (BW). Suggested value (in US dollar): 0.0134. - Cost per color sheet
Enter the cost per color impression (Color). Suggested value (in US dollar): 0.0336. - Cost per sheet
Enter the cost per sheet printed (Paper). Suggested value (in US dollar): 0.0067. - Display currency
Select the currency. Example: US Dollar.
- Sheets per tree
- On the File menu select Options and settings, and then select Data source settings.
- In Data source settings, select Edit permissions to open the Edit permissions dialog.
- Select Database and select Credentials select Edit…
- Select Save.
- Select OK.
- Select Close.
- Select Refresh on the ribbon menu to get the latest data from the Printix SQL database.
Own database
- Open Power BI Desktop.
- On the File menu select Open, and browse to the folder where you extracted the Power BI files.
- Select Power BI template files (.pbit) as file type.
- Select the file PowerBI/Printix.pbit and select Open.
- Enter your values and select currency. Select Load.
- On the File menu select Options and settings, and then select Data source settings.
- In Data source settings, select Change source to open the SQL Server database dialog.
- Select OK.
- In Data source settings, select Edit permissions to open the Edit permissions dialog.
- Select Database and under Credentials select Edit…
- Select Save.
- Select OK.
- Select Close.
- Select Refresh on the ribbon menu to get the latest data from your own SQL database.
Post your comment on this topic.