top of page

Business Intelligence Reporting Solutions Strategy

Business Intelligence Reporting Solutions include the design, development and deployment of Business Intelligence  reporting applications/tools.

Examples include: 

  • Executive Decisioning Boards

  • Strategic Decisioning Boards for Command Center's Strategy Room

  • Tactical Decisioning Boards for Operations Command Center's War Room

  • Scoreboards including Balanced Scorecards 

  • Web Based Reporting Tools

  • Dashboards (Strategic, Executive, Operational, Productivity and Workforce)

  • Customer Reporting Tools 

  • Client Reporting Tools 

  • Scheduled Reporting Tools

  • Embedded Reports

  • Self Service Reporting Tools

  • Reporting Deliverables for Mobile Channels that include Apps for Mobile Phones 

  • Report Metadata

 

For these tools above to be generated, there has to be a very good Reporting Team.

The effectiveness and the quality of deliverables from this team will partly be dependent on the quality of clarity and substance in:

  1. Reporting Governance Model

  2. Reporting Operating Model

  3. Reporting Organization Model

 

Also some of the other factors that will impact the effectiveness and the quality of deliverables include the roles, skills, competencies along with clear strategic direction for the team.

 

Generically, some of the roles, skills and competencies needed in this team include:

  • Report Developers

  • Hadoop Ecosystem

    • Big Data Engineer

    • Hadoop Developers

    • Hadoop Java with Kafka

    • Solution Architect

    • Storm Developer/Architect

    • Open Source Infrastructure Engineer

  • Big Data Cloud Analytics Developer

  • Business Intelligence Solution Architect

  • ETL Developer

  • Data Scientist

  • Reporting Analyst

  • Dashboard/Portal Designer/Developer

  • RDBMS Database Administrator

  • NoSQL Solutions Developer

  • SQL Solutions Developer

  • Security Administrator

 

Some of the basic deliverables for this team include among others:

  1. Designing and Developing Reporting Solution and Related Services in Support of Business Operations

  2. Designing and developing self-service core reports

  3. Defining and capturing required report metadata

  4. Rationalizing information requests

  5. Designing, developing and deploying dashboards and scorecards

  6. Monitoring the effect of business or system changes on reports

  7. Providing Subject Matter Expertise on reporting tool suites

  8. Providing Front-line evaluation of tools, tool updates and tool versions

  9. Supporting business units’ reporting needs

  10. Coordinating the design and development of training materials for the business users' communities

Basic Deliverables: A-Step-Further

Design and develop reporting solutions and related services in support of business operations

Drive and support the deployment of reporting solutions and associated standards and methodologies.  The Reporting Solution Methodologies are developed and maintained and are updated to incorporate enhancements and improvements gained from its ongoing deployment and use across the business

 

Design and develop self-service core reports

Design and develop core reports which customers that have appropriate security access can select, choose the parameter values and submit the report.  The reports are executed against the most recent data and delivered to the customers using the delivery method specified for the particular reports.

 

Define and capture required report metadata

Define set of metadata required for each report.  The metadata contain information on report ownership, run date, etc.

 

Rationalize Information Requests

Work together to rationalize initial report clusters and then on an on-going basis as new report requests are received, they are determined if reports in the existing catalog can meet the requestors needs or if a new report are needed to be created

 

Design, develop and deploy dashboards and scorecards

After major report rationalization efforts, the team focuses on information delivery in the form of dashboards and scorecards.  Delivering information in this format facilitate quick decision making based on consistent and accurate operational information. The Command Center and operations areas  benefit greatly from this type of information at their finger tips.

 

Monitor the effect of business or system changes on reports

The team keeps abreast of any change to source systems or databases that affect the reports.  These changes take the form of migrating operational systems to new versions of software or converting to new operational applications/platforms

 

In addition, the team also:

  • Provides Subject Matter Expertise on reporting tool suites

  • Engages in Front line evaluation of tools, tool updates, tool versions

  • Supports business units’ reporting needs

  • Coordinates the design and development of reporting related training materials

bottom of page