Send the link below via email or IMCopy
Present to your audienceStart remote presentation
- Invited audience members will follow you as you navigate and present
- People invited to a presentation do not need a Prezi account
- This link expires 10 minutes after you close the presentation
- A maximum of 30 users can follow your presentation
- Learn more about this feature in our knowledge base article
Do you really want to delete this prezi?
Neither you, nor the coeditors you shared it with will be able to recover it again.
Make your likes visible on Facebook?
You can change this under Settings & Account at any time.
Growning BI Capability
Transcript of Growning BI Capability
Business Appetite for BI
Business Insight Competency Centre (BICC)
People Data Tool
Corporate Focus on Headcount Management
Data Warehouse Foundations
Clarity of Direction
PDT Headcount Monitoring Tool
Growing BI Capability
People Data Tool (PDT)
BICC exists to provide the Department with optimal BI that is accessible, timely, consistent and offering one version of truth
A Team of Dedicated Experts, with responsibility for:
Developing BI Strategy
Implementing BI Applications
Overseeing Data Management (Governance, Meta Data, Integration)
Supporting BI Users
Enterprise BUS Model
Dedicated BI Data Model
Expandable and Flexible
Increased Control of Meta Data
Data Stewardship Culture
Agreed Data Definitions
Online Data Collection
System to System Integration
Push of a button data transfers
Data Architect (BICC)
Cube v Relational
Cube based data marts for flexible analysis
Single source of the truth
Small pilots before roll out
On the Fly Development
NB: BIS 2020 to be re-thought following recent MOG changes.
Potentially even greater oportunity for BI function to add value.
Headcount tracking across the BIS Group (45 Partner Organisations)
Inform workforce planning
Integration with finance data
Single source of authorised People and Vacancies
Dimensional data model linking finance and HR data at Cost Centre or People Level with ability to track changes over time at all organisational levels
Automated Extract Transform Load from multiple corporate systems to data model
Single source of the truth for standard reporting/data discovery at Corporate Group or individual organisation level for people and vacancy data
Group wide agreed definitions for data attributes
Flexibility to incorporate new data entities with minimal effort
Interactive Data Dashboards with Drill In Ability
System to system connectivity via RESTful principles
Increase system automation
Data collected at the correct grain takes effort, but saves time overall.
Communication efforts to data creators need to be better
Rich, granular data is prime for data discovery
Data discovery tools are ideal to support rapid prototyping
Investment in these tools enhances organisational data capability
Powerful Tracking Tool
Data modelling technique of Slowly Changing Dimensions implemented on key attributes
Changes tracked at individual level
Allows trends in data to be analysed over time at multiple levels of aggregation
Powerful decision review tool
We have the foundations...
...so how do we grow?
So whats the outcome...
...how does this bear fruit?