On this episode of Industrial Talk, we're onsite at Accruent Insights and chatting with Leonella Bass and Edward Bass about Data Analytics - Solutions to identify and access valuable operational data.  Here are the key takeaways:





Industrial IoT security with Palo Alto Networks. 0:00

Palo Alto Networks Industrial IoT Security report analyzes improved ROI and reduced complexity.
Leonella provides background on herself and her business, discussing her experience in Venezuela and her love for sequel products.


Data standardization and migration. 3:42

Edward describes their experience working in maintenance connection and SQL reporting, and how they helped clients with data standardization and migrations.
Edward explains their company's unique approach to mapping fields and assessing asset condition, risk, and maintenance connections.


Data analysis and normalization for various systems. 7:38

Stakeholders want to validate data usage and identify areas for improvement in their systems.
Leonella: Standardize data from different systems to create a unified view for reporting and decision-making.
Leonella: Ensure data accuracy and security by normalizing data from legacy systems and spreadsheets.


Improving data accuracy in CMMS with SQL. 12:15

Edward highlights the importance of standardization and reporting in CMMS to identify untrustworthy data and improve accuracy.
Edward and Scott MacKenzie discuss the need for a team effort to ensure quality data, involving stakeholders and end users in the process.
Leonella discusses data cleaning, mentioning the importance of mapping and standardizing data, as well as the time it takes to complete the process (5 hours).
Edward agrees that data cleaning is heavy lifting, but notes that SQL allows for running loops to make the process more efficient.


Data efficiency solutions with Team Data Efficiency Solutions. 18:41

Leonella provides geeky insights on data QC and Excel use, with a focus on primary keys and VLOOKUP.
Scott MacKenzie thanks listeners for tuning in and invites them to reach out to Leonella and Edward vas for data analytics services.







Also, get your exclusive free access to the Industrial Academy and a series on “Why You Need To Podcast” for Greater Success in 2023. All links designed for keeping you current in this rapidly changing Industrial Market. Learn! Grow! Enjoy!
LEONELLA BASS' CONTACT INFORMATION:
Personal LinkedIn: https://www.linkedin.com/in/leonella-bass-crl-13633aa9/
EDWARD BASS' CONTACT INFORMATION:
Personal LinkedIn: