SQL Power Methodology: Summary
SQL Power Data Warehousing Methodology has evolved with our
Data Warehousing Consulting practice and has been validated and
confirmed by our Clients and Consultants on many successful BI
Solution implementations.
Our Methodology contains activities grouped in seven major
phases:
- BI Strategic Planning activities focus on the development
of a Business Case for a BI Solution; Organization of a BI
Steering Committee; Definition of the Required BI
Infrastructure and creation of the BI Evolution Roadmap.
- Scoping activities relate to the initiation of a BI
project and include the development of the Project Charter,
Business Assessment, Requirement Gathering, Project Planning
and creation of the Project Team.
- This phase includes Analysis and Design activities to
create the DW Architecture, conduct Technology and Data
Quality Assessments, design Data Models, Metadata Repository,
ETL Application and BI Reports.
- This is the code construction phase during which all
physical Data Models, ETL Code and BI Reports are
constructed.
- Testing activities focus on Unit testing, System
Integration Testing, User Training and User Acceptance
Testing. Testing includes quality checking of all ETL code
and BI reports constructed in the Build phase.
- The solution deployment planning rollout and Production
Rollout execution activities include User Training and
Production deployment of BI databases, Metadata Repository,
ETL code and BI Report.
- Post-production implementation activities focus on BI
application Monitoring and Support, including monitoring of
Data Load Logs, Data Volumes, Data Auditing, Report Usage
frequencies and Change Tracking.
The effective execution of a successful BI project requires
that a proper project management approach is used. Thus there
is an additional Project
Management phase that applies equally to any activities
on a BI project.
Top 10 Ways to Ensure a Successful BI Implementation
- Secure a strong Business Sponsor
- Under-commit and over-deliver on BI projects (especially in the early phases)
- Supplement your team with seasoned Business Intelligence experts
- Design your Data Warehouse for scalability and constant change
- Invest in good BI productivity tools (including Design Tool, ETL Tool, and Data Cleansing Tool)
- Implement Data Auditing processes: Data Integrity = End User Confidence = BI Program credibility
- Strive for end-user self-sufficiency: Choose easy and intuitive BI Reporting Tools
- Decommission obsolete and lesser-used subject areas
- Continuously look for ways to reduce on-going BI Costs
- Promote Data Warehouse growth - a static Data Warehouse is a dead Data Warehouse
|
The shortest time to delivery of the BI Solution is
guaranteed by high quality deliverables produced in each
development phase, as shown on the diagram.
|
Email this page
Print‑friendly version