Project Success Stories
- Jetstar is a value based low cost carrier airline.
- Collectively the Jetstar Group of airlines operate over 1900 weekly flights to 15 countries across the Asia and Asia Pacific region
Project: Reports and Dashboards – Commercial Department
Project Objective
Design and Build the commercial datawarehouse and to further source information from multiple sources across the organisation, for example Finance, Operations. This is a preliminary project to further scoping and implementing a Business Intelligence Solution.
Project Problem and Solution
Reports were being generated out of disparate legacy systems and individual purpose built applications.
Consolidating reporting data into one ODS was the first step to building reports based on business needs. e.g. KPI, Financial tracking, Passenger reports, route profitability.
The technology chosen was Microsoft SQL server, being the technology of choice for the organization wide datawarehouse.
Project: Marketing Reports and Dashboards
Project Objective
This project was to build reports and dashboards off the back of the marketing divisions multiple front line customer management tools. The organization utilizes multiple tools to store data and generate reports.
Project Problem and Solution
A purpose built datawarehouse was built based on SQL server and reports and dashboards were generated.
- Victoria’s Largest Health Services.
- 13,000 employees
- Over 40 sites including 6 major Hospitals
Project: KPI Dashboard builder
Project Objective
This project was to build live dashboards for one category of KPI’s for Southern Health.
This is to form part of a larger set of executive level dashboards.
All KPI’s and reports are in line with government based requirements centred on quality and control of the health sector.
Project Problem & Solution
The KPI reports were manually created by consolidating data from various departments, hence this time consuming task would take weeks to complete. Reports were not in real time and hence created room for error and out of date information. This meant the organization could not react to immediate issues as and when they arose. Some of these issues included:
- Patient and performance management
- Reduction in administrative cost
- Discovery of new revenue opportunities
- Supply cost optimization
- Fraud identification
- Detection of cost effective treatments
- Disease management targeting early prevention vs. expensive late-stage therapies.
- Efficient and effective reporting
BCS designed a reporting architecture and delivered a KPI focussed dashboard as paid Proof of Concept which is now being rolled out across the organisation.
All company names, trademarks, logos, and copyrights that are not property of BCS Technology International are property of their respective owners.