|
|
| (12 intermediate revisions by 2 users not shown) |
| Line 1: |
Line 1: |
| − | == Introduction == | + | == Introduction to Datonis Business Intelligence == |
| − | Altizon Systems has developed a self-serve Business Intelligence tool. This tool can be used by the Plant Stakeholders to build and visualize dashboards without needing support from the development team. This can be used as a quick way to build custom reports and analyze data that varies per use case and industry vertical.
| + | Datonis BI is a web based business intelligence tool. It provides an easy-to-use interface for exploring and visualizing data. It provides a rich set of data visualization components and the ability to build custom dashboards for analysing your data. |
| | | | |
| − | '''[[Analytics Data Model|Learn more about the data model]]'''
| + | Datonis BI has been built on top of [https://superset.incubator.apache.org/ Apache Superset], an open-source enterprise-ready business intelligence web application. Superset users will find the interface very familiar. Any differences will be called out in this documentation. |
| − | '''[[Create your own custom dashboards|Learn more about creating custom dashboards]]'''
| |
| | | | |
| − | == Analytics Data Model ==
| + | To help plant users get started quickly, Datonis BI comes pre-built with data models that are built on top of Datonis MInt. If you are an existing Datonis MInt user, please refer to the [[Datonis Manufacturing Intelligence Beta|MInt data model documentation]] to understand MInt concepts in more detail. |
| − | MINT currently has 4 main fact data models that it uses to render reports.
| |
| | | | |
| − | 1) '''Slot_data''': This contains the production timeline data which includes the uptime, downtime, part booking, downtime reason bookings, etc which is used to compute operational dashboards. This can be used to create slot level reports for e.g. performance per Part per Slot or Part changeover analysis.
| + | == Getting started with Datonis BI == |
| | + | Datonis BI documentation is structured into the following main modules: |
| | | | |
| − | 2) '''Faas_data''': This contains data rolled up at a greater granularity i.e. Shift or Day level and Part and Operation level. This can be considered as analytics data and most of the multi-day reports in the current MINT application run on this source.
| + | * Data Model - This has information regarding the table structure and entity-relationship diagrams. |
| − | | + | :'''[[Analytics Data Model|Learn more about the data model]]''' |
| − | 3) '''CBM/Quality/Production data''': This contains hourly statistical data like Cp/CpK, min, avg, max etc. which are essential for condition-based monitoring for the selected parameters. This can be used to create hour level reports like First -our output, Points out of limits per hour trend, Hourly Part Energy, etc.
| + | * Dashboard Builder- A user manual to help the user create his/her own custom dashboards |
| − | | + | :'''[[Create your own custom dashboards|Learn more about creating custom dashboards]]''' |
| − | 4) '''Traced Object''': This data model of a traced object is completely use case-specific and it only has a few common fields like: machine_key, part_key, workorder_key, from, to,etc. There are currently no roll -ps happening on this data. This is a very custom data model and is currently '''out of the cope''' of the star schema model proposed below as we attempt to define a generic data model that is applicable to most of the MINT user data.
| |
| − | | |
| − | == Star Schema of the MINT Analytics Data Model ==
| |
| − | | |
| − | === '''Faas Data:''' ===
| |
| − | This is further divided into 2 models:
| |
| − | | |
| − | ==== '''WorkcenterShiftFact:''' ====
| |
| − | This model is used to create most of the Productivity related KPIs and Reports in existing MINT. The main dimensions (groupby) of this model are at Workenter, Shift and Working day (Calendar Date).
| |
| − | | |
| − | '''Note -''' Any categorical column can be used as a dimension.
| |
| − | | |
| − | '''SCHEMA IMAGE TO BE UPLOADED'''
| |
| − | | |
| − | The proposed star schema has 6 main fact tables:
| |
| − | | |
| − | ● '''WorkcenterShiftFact:''' Captures all the productivity parameters that can be used to calculate OEE, availability, performance and energy consumption ,etc.
| |
| − | | |
| − | ● '''WorkcenterShiftDownTimeReasonsFact''': Captures details of all the downtime incidents occurring on a workcenter on a given day.
| |
| − | | |
| − | ● '''WorkcenterShiftRejectionsFact''': Captures details of all the rejections on a workcenter.
| |
| − | | |
| − | ● '''WorkcenterShiftOperatorsFact''': Captures operators who have worked on a workcenter on a given day.
| |
| − | | |
| − | ● '''WorkcenterShiftProductivityDownTimeReasonsFact''': Captures details of all the downtime incidents occurring on a workcenter when it is running on a given day.
| |
| − | | |
| − | ● '''WorkcenterShiftProductionParametersFact''': Captures details of all the production parameters produced on a workcenter when it's running on a given day.
| |
| − | | |
| − | This is the most insightful data model for overall productivity metrics and will let us create a lot of reports on a daily/weekly/monthly basis. This will also allow reports like QOQ comparison of cells/workcenters/shifts on productivity, quality and performance parameters.
| |
| − | | |
| − | '''Note -''' It is possible for the user to select any categorical column mentioned in the table as a groupby to the chart being created (e.g. machine_name, shift_name, category_code, etc).
| |
| − | | |
| − | Along with the groupby, the user will have to choose a numeric column from the table to view the details. This column will have an aggregation associated with it (e.g. if you select production_quantity; options like MIN, MAX, AVG, COUNT, etc will be shown) to be selected by the user.
| |
| − | | |
| − | Additionally, the user can create custom metrics and/or KPIs to add business meaning to the charts (e.g. If the user wants to see specific energy consumption, he can create a metric by taking the ratio of electricity and production_quantity).
| |
| − | | |
| − | ==== '''WorkcenterPartRoutingShiftFact:''' ====
| |
| − | While the model above in (a) only provides roll up to a machine level, this model adds 2 more dimensions to the above model namely: Part and Routing.
| |
| − | | |
| − | Part can be compared to an SKU, Batch, Product (depending on the nomenclature each industry uses).
| |
| − | | |
| − | Routing is a set of operations that a Part goes through in its lifecycle from Raw Material to Finished Good (e.g. In a bottling plant, each Part (bottle in this case) goes through Cleaning -> Filling -> Capping -> Sticker Printing -> Packing. These 5 are operations and the complete flow is called routing).
| |
| − | | |
| − | '''SCHEMA IMAGE TO BE UPLOADED''' | |
| − | | |
| − | The fact tables in the star schema for this model are:
| |
| − | | |
| − | ● '''WorkcenterPartRoutingDailyFact:''' Contains all the parameters (production, rejection, energy) for a part and routing for a day/shift on the machine on which it was produced.
| |
| − | | |
| − | ● '''WorkcenterPartRoutingDownTimeReasonsDailyFact:''' Contains all the downtime reason details for each row in the part routing model.
| |
| − | | |
| − | ● '''WorkcenterPartRoutingRejectionsDailyFact:''' Contains all the rejection details for each row in the part routing model.
| |
| − | | |
| − | This data model will allow for reports on part level analytics w.r.t. the machines on which they are produced some of which include performance monitoring, specific energy consumption, Part rejections etc.
| |
Datonis BI is a web based business intelligence tool. It provides an easy-to-use interface for exploring and visualizing data. It provides a rich set of data visualization components and the ability to build custom dashboards for analysing your data.
To help plant users get started quickly, Datonis BI comes pre-built with data models that are built on top of Datonis MInt. If you are an existing Datonis MInt user, please refer to the MInt data model documentation to understand MInt concepts in more detail.
