Page 84 - DCAP606_BUSINESS_INTELLIGENCE

Unit 5: Microsoft Business Intelligence Platform

Notes
markets could be realistically analysed and reports were often out of date by completion.
Further problems were introduced by discrepancies in the data definitions. To make faster
and more accurate decisions, managers needed a way to quickly obtain current and
comprehensive reports with maximum accuracy.
Looking forward, the company anticipated expanding their business intelligence
capabilities beyond network deployment to optimize business decisions in other units.
These new capabilities were expected to yield increasing amounts of data that would
require an expansion of storage capacity. A framework was sought for designing and
defining future data warehousing and business intelligence implementations.
Creating a Platform to Support Growth and Control Costs
Originally selected to perform an assessment of the organization’s overall business
intelligence capabilities, Hitachi Consulting was subsequently engaged to provide a
comprehensive solution to this pressing issue. By utilizing expertise in BI and in
collaboration with the IT, finance, marketing, and network development teams, Hitachi
Consulting designed a platform to bring visibility to the company’s network deployment
efforts. The implementation of a Cognos dashboard, built on an Oracle relational database
system, would be linked to a data feed from the existing network monitoring system.
Organized by phase and by market, the new dashboards would offer decision makers the
option to obtain a high level view or to drill down into the specifics of each. Without the
constraints of limited data or the prohibitive costs of manual analysis, reports could be
infinitely configured and generated nightly. Key metrics, such as population counts, sites
on air, sites leased, and duration calculations, would be integrated while data definitions
would be consolidated for increased accuracy.

The future needs of the organization were also considered as the system was designed to
serve as the foundation for the development of a more robust and scalable data warehousing
platform. Hitachi Consulting helped define the data warehouse framework and design
standards by assisting the client in developing an internal “Centre of Excellence” for
future implementations.
Cost Savings is realized with Improved Operational Efficiencies
With an aggressive and costly objective of doubling service coverage in less than a year,
this young company worked closely with Hitachi Consulting to help them achieve it.
Through our business intelligence expertise and implementation, the company realized
immediate gains in operational efficiency.
The company is now better positioned to minimize development costs through more
accurate financial insights. Reports that formerly required many hours of preparation are
near-instantly generated with greater relevance, scope, and accuracy. Managers, in turn,
gain increased visibility of schedule slips which has enabled them to prevent them as they
occur.
The system is expected to pay for itself through the cost savings of only a single market.
Data that was formerly available to only a few is now empowering those making the
decisions to manage a network build-out that is on time and on budget.
Questions:

1. Analyse a case find out what is the problem?
2. What solution does wireless broadband services provider provides to Hitachi
Consulting?
Source: www.hitachiconsulting.com/files/.../CS_WirelessProviderBI.pdf

LOVELY PROFESSIONAL UNIVERSITY 79