Blackline Safety

Client : Blackline Safety
Category : IOT
Date : 21 March, 2016
Status : In Process
Location Canada
Tags : IOT,Technology
Blackline Safetly Logo

Company Overview

Blackline Safety is a global connected safety technology leader, providing comprehensive live-monitoring and wireless gas detection. They help teams working in hazardous environments respond to emergencies in real-time and manage efficient evacuations, accounting for everyone’s safety along the way. They deliver turn-key, work-anywhere connected safety monitoring solution with gas detection, 3G wireless, two-way speakerphone and live monitoring to meet the demanding safety challenges of organizations in over 200 countries.

Blackline safety mainly has products for wirelessly connected lone worker safety monitoring. They mainly had requirement of creating reports for usage of devices which include fleet health, Device usage and compliance, calibration review, recommended maintenance, alert report, zone report etc. Blackline wanted to have three types of report i.e. reports which showed Current analysis (current state data analysis), Period analysis (analysis of data from past 7 days) & Trend analysis (last 6 months analysis). They also had some problem in existing reports which needed to be fixed. They wanted their solution to be White labelled.

Apart from this, they also had a custom requirement which required coding. They wanted a code which can allow making changes in the parameters of the scheduled reports, thus reducing the effort of manually changing the parameters for each and every report.

– Written SQL queries to develop Current, Period & Trend analysis reports using Jaspersoft Studio
– Developed Bar charts, Pie charts & Tabular components for three categories of Reports
– Added Java code to make customizations in Pie chart, Bar chart etc.
– Added custom CSS to make changes in the formatting of the report when exported
– Written code in core Java and used Jaspersoft Rest APIs to make dynamic changes in the scheduled reports
– Changes in the SQL queries and some already existing reports
– ETL Monitoring

Operating System : Linux server
BI Server : Jaspersoft 5.6 community edition
Database : MySQL
ETL : Pentaho Data integration
Connectivity : SSH

Challenge

Blackline safety mainly has products for wirelessly connected lone worker safety monitoring. They mainly had requirement of creating reports for usage of devices which include fleet health, Device usage and compliance, calibration review, recommended maintenance, alert report, zone report etc. Blackline wanted to have three types of report i.e. reports which showed Current analysis (current state data analysis), Period analysis (analysis of data from past 7 days) & Trend analysis (last 6 months analysis). They also had some problem in existing reports which needed to be fixed. They wanted their solution to be White labelled.

Apart from this, they also had a custom requirement which required coding. They wanted a code which can allow making changes in the parameters of the scheduled reports, thus reducing the effort of manually changing the parameters for each and every report.

Solution

– Written SQL queries to develop Current, Period & Trend analysis reports using Jaspersoft Studio
– Developed Bar charts, Pie charts & Tabular components for three categories of Reports
– Added Java code to make customizations in Pie chart, Bar chart etc.
– Added custom CSS to make changes in the formatting of the report when exported
– Written code in core Java and used Jaspersoft Rest APIs to make dynamic changes in the scheduled reports
– Changes in the SQL queries and some already existing reports
– ETL Monitoring

Tools and Technologies

Operating System : Linux server
BI Server : Jaspersoft 5.6 community edition
Database : MySQL
ETL : Pentaho Data integration
Connectivity : SSH

Learn

Latest Posts on Our Blog

Software Testing

Different Levels of Testing in Software Testing

By admin

What are the Levels of Software Testing? In this blog,we are going to understand the various levels of software testing In Software Testing,we have four different levels of testing,which are as mentioned below: Unit Testing Integration Testing System Testing Acceptance...
  • 0
Pentaho

How To Get Subfolder Names In Pentaho

By admin

Introduction Pentaho is a business intelligence and data integration platform, and you can use “Get subfolder names” in transformations, The ability to retrieve subfolder names from a directory is often required when dealing with dynamic or changing file structures. Here...
  • 0
Software Testing

How To Create Graphical Reports In Bugzilla?

By admin

In Bugzilla, Graphical reports encompass bar,line and pie charts,serving various purposes.For instance,when a user needs to identify the Severity of the bugs for the particular component and intends to visualize this data graphically,they have two available options to choose from...
  • 0