National Department of Education, Federated States of Micronesia

Client : National Department of Education
Category: Education
Date : 24th May 2018
Status : In Process
Location Federated States of Micronesia
Tags : Education
NDOE Logo

Introduction:

The “National Department of Education (NDOE)” of the Federated States of Micronesia is the governing body of Micronesia, a country in western pacific ocean. Micronesia is made up of 4 island states – Pohnpei, Kosrae, Chuuk and Yap. NDOE works closely with the state education department. They have 31 employees and three (3) major divisions consists of – basic education, special education and technical education.

NDOE wanted to develop and view reports of every school based on some predefined criterion such as state wise, school wise, student wise, teacher wise etc for their analysis purpose.

NDOE wanted to generate reports to analyse each and every school how they are performing. They wanted to monitor KPI’s like-

  1. student-teacher ratio
  2. subject wise performance
  3. grading reports
  4. overall performance of the school etc.

NDOE wanted to use open source BI tool Jaspersoft (community edition). All of their data is stored in SQL server.

But they had two specific requirements which was more complex to implement-

  1. NDOE wanted a table of content through which they can easily navigate to the desired report page.
  2. NDOE wanted a customised view of every state wise report generated which included dynamically changing the cover page (including content and image logo) based on input parameter selection.

There were two different tasks for our developers –

  1. New report creation and
  2. Updation of already existing report

Jasper Studio 6.4.0 was used and the entire reports development was done using the community edition.

As stated earlier NDOE needed customized reports based on certain criterion. JFree charts were used to generate those reports and client can make parameter selections according to which report content was getting updated. Based on entered parameter value NDOE could view the desired report. Some of the input parameters were state, school, subject etc.

As far as table of content was concerned “Report Book” concept of Jaspersoft was used.

Some of the reports also needed a customised cover page wherein “Dynamic Styling” technique was used so that as soon as state input parameter value is changed the view of the cover page gets changed accordingly.

For updation of existing reports stored procedure query was used.

DB used – SQL Server

BI tool – Jaspersoft Studio 6.4.0 CE (community edition)

Challenge

NDOE wanted to generate reports to analyse each and every school how they are performing. They wanted to monitor KPI’s like-

  1. student-teacher ratio
  2. subject wise performance
  3. grading reports
  4. overall performance of the school etc.

NDOE wanted to use open source BI tool Jaspersoft (community edition). All of their data is stored in SQL server.

But they had two specific requirements which was more complex to implement-

  1. NDOE wanted a table of content through which they can easily navigate to the desired report page.
  2. NDOE wanted a customised view of every state wise report generated which included dynamically changing the cover page (including content and image logo) based on input parameter selection.

There were two different tasks for our developers –

  1. New report creation and
  2. Updation of already existing report
Solution

Jasper Studio 6.4.0 was used and the entire reports development was done using the community edition.

As stated earlier NDOE needed customized reports based on certain criterion. JFree charts were used to generate those reports and client can make parameter selections according to which report content was getting updated. Based on entered parameter value NDOE could view the desired report. Some of the input parameters were state, school, subject etc.

As far as table of content was concerned “Report Book” concept of Jaspersoft was used.

Some of the reports also needed a customised cover page wherein “Dynamic Styling” technique was used so that as soon as state input parameter value is changed the view of the cover page gets changed accordingly.

For updation of existing reports stored procedure query was used.

Tools and Technologies

DB used – SQL Server

BI tool – Jaspersoft Studio 6.4.0 CE (community edition)

Learn

Latest Posts on Our Blog

Business Intelligence

Installation of Firebird db

By admin

Steps to install firebird db 1. Go to google and type firebird in search box and then click on first link. License aggrement 2. Click on downloads and then install Firebird latest version(5.0.0). 3. It will navigate to the below...
  • 0
Software Testing

Defect Life Cycle

By admin

This blog explains about the complete life cycle of a bug and different status of bug from the stage it was identified,fixed,retest and close. What is Defect life cycle? Defect life cycle is the life cycle of a defect or...
  • 0