updates

DMS – Datamanagement Studio

Strengths:

  • Automatic creation of datasets
  • Universal dashboards, dashboard templates
  • Easily configurable
  • Cloud-based service
  • Device-independent solution
  • Map-based and heatmap-based visualization
  • Data model (block diagram) editor
  • Dashboard editor, various layout schemes
  • Web application development using drag-and-drop techniques
  • Efficient storage of extremely large amounts of measurement or analysis data
  • Exceptional data retrieval speed
  • Built-in Excel functionality (Office not required) with significant speed increase
  • Integration with SCADA and CMMS systems
  • Integration of EMS functions
  • Diverse, freely expandable analytical and statistical functions

What is DMS?

DMS is an easily manageable data modeling and dashboard editing program. Its main purpose is to create dashboards displaying the measured and calculated data of the metering network. However, it not only creates dashboards but complete web applications containing menu systems and control elements necessary for selecting data, facilities, and changing time when displaying historical data.

A special feature of the system is the system of universal identifiers (Smart ID) introduced for data grouping, which allows us to create universally applicable data processing and dashboard schemes. The extraordinary workload of individual data assignment thus decreases to a fraction, while the created schemes can be used in multiple projects.

The data from DMS can be displayed on a dashboard and map, accessed by users in the form of a web application using the DMS cloud service. It is completely configurable so that users can see what they need from the projects and dashboards created in the system and perform any necessary interventions.

Goals and Benefits of Using DMS

Goals: Benefits:
Designing editor interfaces by the client. Hierarchical description of tree-sturcture  metering groups and client groups.
Establishment of client and metering groups. Data processing and visualization.
Dashboard configuration. Editable dashboards.
Web application development. Big Data

Capabilities of DMS

  1. Topology and data model descriptors
  2. Dashboard editor
  3. Data collection system from databases, file systems, and database tables
  4. Collection and visualization of measurement data from meters
  5. Metering network structures
  6. Customizable grouping of meters belonging to individual clients (tenants, partners, departments, stores, functional and accounting groups, etc.)
  7. During project creation, elements can be selected from a pre-configured repository of data sources using drag-and-drop techniques
  8. Many data processing routines and some dashboard elements are independent of specific data, thanks to the introduction of Smart ID, enabling the creation of general data processing schemes
  9. Operation module containing the list of clients and the models and dashboards assigned to them
  10. Project-level approach to creating and associating structures
  11. Thematic map display of GPS-enabled data
  12. Efficient compression of large amounts of measurement or analysis data (compresses the database to about 2%)
  13. Extremely fast data retrieval (retrieval of a single data item occurs in the microsecond range)
  14. Modular support for analytical tasks
  15. Basic user skills equivalent to PowerPoint are sufficient for data aggregation and dashboard design.

DMS Requirements

Operating System: Any Windows operating system; Recommended: Windows Server 2016. MS-SQL (Oracle, MySQL, PostgreSQL, etc.) database manager
100 GB of free disk space

System Limitations:

  • Basic programming knowledge required for using the program’s basic functions.
  • Higher level of programming and mathematical knowledge required for more complex analytical and statistical tasks.

 

What Can Be Analyzed?

  • Measurement data from locations and buildings.
  • Any data originating from known data collection systems within DMS.
  • Any data available in Excel, CSV, or SQL database tables.
  • Data from EMS systems.

 

Data Sources:

  • System databases (EMS, VISION, CMMS).
  • File systems (Excel, CSV).
  • Database tables (SQL).

 

EMS Data Analysis Capabilities:

  • Load profile analysis.
  • Predictive analytics, consumption forecasting, time series load prediction.
  • X-Y statistics, regression analysis.
  • Examination of dependencies on environmental parameters (cross-correlation analysis).
  • Peak consumption analytics.
  • Comprehensive heating-cooling analysis (temperature frequency, cooling-heating degree analysis, calculation of cooling-heating days, detection of deviant days, temperature-dependent consumption, third-degree regression curve, mapping of heating deviations, CUSUM analyses, heating efficiency calculation…).
  • Calculation of greenhouse gas emissions.
  • Cost calculation, controlling tasks.
  • Expert analyses, industry comparisons.
  • Gantt chart creation.

 

Special dashboards:

  • Energy map for consumers and breakdown over time.
  • Snake diagram for displaying energy source distribution or temporal changes in consumption.
  • Special heat map diagrams.
  • Control chart (automatic bandwidth determination for predictive analytics).
  • Combined diagrams from multiple data types.
  • 3D diagrams.
  • 100 types of Highcharts dashboard elements.
  • 100 types of Vision X10 dashboard elements.
  • User-configurable dashboard for any dataset with a cloud-hosted editor.
  • Reconfiguration of existing diagrams with a cloud-hosted editor.

 

Display of Information:

  • Displaying information through various user-editable dashboards as a web application.
  • Mapping of data with GPS information.
  • Visualization on a heat map.

updates