Latest Data Storage Technical Articles

Categories

UDW Data Calculations, Post Disturbance Review, UI, and Backup | Part 2

UDW Data Calculations, Post Disturbance Review, UI, and Backup | Part 2

Effectively managing data includes processing it after initial collection: performing calculations, reviewing for anomalies, and displaying the data for easier actionable insights.


Data Model and Functionality of Utility Data Warehouse | UDW Part 1

Data Model and Functionality of Utility Data Warehouse | UDW Part 1

Storing data long-term for recording and reporting purposes is the job of the utility data warehouse, quite different from data-collection processes that optimize systems and predict failures.


Data Flow Tutorial With Mage.ai | Part 6: Refined Data Presentation

Data Flow Tutorial With Mage.ai | Part 6: Refined Data Presentation

We conclude the data flow project with the step of developing a business intelligence dashboard to present machine data, at a reliable schedule, to a leadership or maintenance team.


Data Flow Tutorial With Mage.ai | Part 5: Basic Data Dashboards

Data Flow Tutorial With Mage.ai | Part 5: Basic Data Dashboards

We begin to wrap up our data flow project with an introduction to visual-based (GUI) tools and dashboards to present the data ingested from the Google Sheets fault data source.


Handling of Power System Data | Indications, Counters, and Data Flags

Handling of Power System Data | Indications, Counters, and Data Flags

For large process systems, learn how the location of data indication and flag processing can increase or decrease the burden on computers at the device, RTU, or main computer level.


Understanding the JSON Data Format for Industrial Control Architecture

Understanding the JSON Data Format for Industrial Control Architecture

It is important to have some baseline understanding of JavaScript Object Notation, or JSON, one of the most common data exchange formats used in the connected industrial world today.


9 Critical Steps to Building a Digital Twin for Your Factory

9 Critical Steps to Building a Digital Twin for Your Factory

Digital twins are a virtual process representation merging the simulation and real worlds to increase efficiency, optimize parameters, and predict successful operations for a variety of industries.


Data Flow Tutorial With Mage.ai | Part 4: PostgreSQL Database

Data Flow Tutorial With Mage.ai | Part 4: PostgreSQL Database

To transfer data from a local spreadsheet to a database to create visual dashboards, we must now define the outbound integration to the PostgreSQL database through the mage.ai editor.


Data Flow Tutorial With Mage.ai | Part 3: Connecting to Google Sheets

Data Flow Tutorial With Mage.ai | Part 3: Connecting to Google Sheets

In this article, we will explore the inbound integration to the mage.ai pipeline, connecting to the spreadsheet data source using the Google Sheets API through a JSON credentials file.


Data Flow Tutorial With Mage.ai | Part 2: Initializing the Software

Data Flow Tutorial With Mage.ai | Part 2: Initializing the Software

Data pipelines are software services that progress the data from source to storage, hopefully without too much programming complexity. In this article, we begin by initializing the mage.ai software.


Data Flow Tutorial With Mage.ai | Part 1: The Challenge of Data

Data Flow Tutorial With Mage.ai | Part 1: The Challenge of Data

All of modern industry relies on data. In the first installment of a series showcasing the importance of industrial data movement, we explain the challenge of data flow and build a fault list.


Create Your Own IIoT Tech Stack Project | Part 8: Final - Data Dashboard

Create Your Own IIoT Tech Stack Project | Part 8: Final - Data Dashboard

In this final installment of the IIoT tech stack project, learn how to design the customer-facing dashboard or observability platform using the data acquired from the MQTT client device.


Create Your Own IIoT Tech Stack Project | Part 7: Integrating Data With Database

Create Your Own IIoT Tech Stack Project | Part 7: Integrating Data With Database

As we approach the conclusion of this IIoT project, we’ll explore the integration of the Mosquitto MQTT broker, Node-RED, and InfluxDB, leaving only the data dashboard setup for the final step.


Create Your Own IIoT Tech Stack Project | Part 6: Node-RED Development

Create Your Own IIoT Tech Stack Project | Part 6: Node-RED Development

This article will explore the setup of Node-RED, the glue that will serve to connect all of the individual components of the solution that we have created up to this point.


Create Your Own IIoT Tech Stack Project | Part 5: Database Setup

Create Your Own IIoT Tech Stack Project | Part 5: Database Setup

Now that our IIoT project has verified the transmission of an MQTT data payload packet, this next article will explore the setup of an InfluxDB database to store the incoming sensor data.


Create Your Own IIoT Tech Stack Project | Part 3: Commissioning MQTT Broker

Create Your Own IIoT Tech Stack Project | Part 3: Commissioning MQTT Broker

Learn to develop an actual IoT solution end to end. Create a Mosquitto MQTT broker for the Raspberry Pi client in order to connect and publish Sense HAT sensor data.


Create Your Own IIoT Tech Stack Project | Part 1: MQTT Client Setup

Create Your Own IIoT Tech Stack Project | Part 1: MQTT Client Setup

Learn to develop an actual IoT solution end to end, from the initial data collection to web-based visualization and analytics. This first article in the series will explore the setup of the edge device.


5 Reasons Why Sensors Are Crucial For Modern Manufacturing

5 Reasons Why Sensors Are Crucial For Modern Manufacturing

Data has become the currency that enables operational excellence. Sensors are the key links, acting as the eyes and ears of modern manufacturing units by providing real-time data on machine performance.


Advanced Web-Based HMI Project: Part 1

Advanced Web-Based HMI Project: Part 1

Taking web-based HMI design from a simulated project to the real-world environment. Part 1 introduces tag instances and attributes.


Creating and Using a Virtual Environment in Python

Creating and Using a Virtual Environment in Python

An overview of the theory, implementation, and reason to utilize a virtual environment in your Python scripting journey.