Proplanner is now an Advantive Company.

Power BI Reporting of SFV MES and Factboard Data

View post titled Power BI Reporting of SFV MES and Factboard Data

Proplanner’s new Power BI connector for Shop Floor MES (SFV) and Factboard allow you to combine, summarize and report on the vast amount of data collected by those systems.  This data can then be aggregated, filtered, analyzed, formatted, charted and displayed per your needs and even shared among other users in your company.

Shop Floor MES collects data about every Activity performed by every user on every unit.  Additionally, engineers can choose to ask the user to scan or enter additional data as they perform Worksteps inside those Activities.  Since all Industrial Internet of Things (IIOT) interfaces, such as DC Torque Tools, Pick-2-Light Systems, or PLC’s are connected to SFV Worksteps, this means that all collected data from those systems is available as well.

Factboard receives Posted transactions from SFV and any other factory systems capable of sending JSON Posted messages.  Often these transactions involve key shop floor events such as products arriving and departing stations, Assembly line stoppages, or Quality and Logistics issues.  These transactions, including all of their attribute data are available to Proplanner’s PowerBI connector.

To take advantage of this powerful new capability, find the Proplanner connector, (included free to all subscribers) and connect to your dataset, then sign into your Proplanner account and the connection will be established.   When you open your Power BI session this connection will provide access to all the SFV MES and Factboard data tables.

In the Proplanner data model, each assembly line is in its own folder, and contains, Signoff, Issue and Build List data.  Additionally, any IIOT data can be found in the Custom Tables associated with each device interface (i.e. Workstep IOT table).  Once selected, you will be able to choose how many months of data to pull from each data set. 

When you apply that imported data in PowerBI, you can preview it in a spreadsheet table format.  You will then want to use the PowerBI features to transform it and filter out unwanted data that you don’t plan to use in your visualization.  In the example below, we are only looking for data from the torque tools in the selected workstations.

Once you apply, all the data will be loaded into PowerBI and the table will show up with all fields defined with appropriate data types.

At this point, you can select your desired values for charts or tables.  Sometimes, you will get more attribute values than desired (i.e. torque and angle), you can filter what you need (i.e. torque) and sort even further using Slicers.  For example, you can select specific resources and/or date ranges. 

With PowerBI, you can even share these custom reports via the web and publish to other people within your organization.

Check out this video for even more information on how to use this powerful new capability!

There are no comments yet.
Add Comment

* Indicates a required field

© 2024 Proplanner. All rights reserved.