Perform basic business intelligence analysis
Overview
This standard is about performing basic business intelligence analysis to support organisational information assessment.
This involves obtaining Business Intelligence (BI) reporting requirements, scoping BI reporting, creating basic data models, identifying key trends and communicating outputs using reports and presentations.
This standard is for those who need to perform basic business intelligence analysis as part of their duties.
Performance criteria
You must be able to:
- Assist in gathering and documenting BI reporting requirements from stakeholders
- Create basic BI data models to assess organisational scenarios
- Document internal procedures for BI analysis and report production
Develop and build new standard BI reporting outputs for organisational stakeholders in line with organisational requirements
Query datasets using SQL (Structured Query Language) to identify correct BI data
Create and compile basic analysis information to identify key trends in BI data
Develop and maintain BI reports integrating data visualisations and routine analysis in line with organisational procedures
Create and deliver presentations to communicate BI reporting outcomes
- Contribute to process improvement of BI analysis and reporting in line with organisational requirements
Knowledge and Understanding
You need to know and understand:
How to obtain and document BI requirements from stakeholders
The steps involved in creating BI data models and how to apply them
The importance of documenting BI analysis and reporting
How to present BI data and information to stakeholders
- How to develop and maintain BI dashboard and reporting outputs
- How to collect information and develop new BI data sets
- How to apply SQL to query and extract data
- How to produce and communicate key trend analysis
How to create BI presentations for internal stakeholders to review
How to identify key trends in BI data
The steps involved in BI analysis and reporting process improvement and how to apply them