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:

Reporting Governance Model

Reporting Operating Model

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:

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

Designing and developing self-service core reports

Defining and capturing required report metadata

Rationalizing information requests

Designing, developing and deploying dashboards and scorecards

Monitoring the effect of business or system changes on reports

Providing Subject Matter Expertise on reporting tool suites

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

Supporting business units’ reporting needs

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