r e p o l e v e D p r p e A p / l o t e c v e e t i D h l c a r A t r I o B P
t s i l / i a t c c e e p t i S h t c r r A o l p a p c u i n S h h c c e e T T
/ r o r s n e v o i p r S D s s s s e e n i n i s s u u B B
r / e r g o a t c n a e r M i D m I a r B g / W o r D P
m
m
m
m
l
l
t
t
t
t
t
m
t
l
l
t
t
t
t
t
l
A B / D t / r c e e l t i e h d c o r A M a t a t a a D D
r e g a n a M a t a d a t e M
/ r t e c p e o t i l h e v c e r A D L L T T E E
r e g a n a M y t i r u c e S
r e t s e T d a e L
t s i l a i c e p S s t a t S / g n i n i M a t a D
r o t a c u d E
PROJECT/PROGRAM LAUNCH AND MANAGEMENT PROJECT DEFINITION readiness ss 1 Assess DW/BI readine Develop preliminary project scope/charter 2 Develop Build business justification 3
1 2 3 4 5
PROJECT PLANNING & MANAGEMENT Establish project identity Identify project resources Prepare project plan Develop Develop project proj ect communicatio c ommunication n plan Conduct project team kick-off & planning
6 7 8 9
Develop process to manage scope/control changes Develop process to measure success User acceptance/project review Ongoing project management
1 2 3 4 5 6
PROGRAM PLANNING & MANAGEMENT Establish governance responsibility/process Establish pr ogram communicatio communication n plan Establish enterprise data stewardship Establish program best practices Conduct periodic program assessments Ongoing program management
1 2 3 4 5 6 7
BUSINESS REQUIREMENTS DEFINITION Identify and prepare interview team Select interviewees Schedule interviews Prepare interview questionnaires questionnaires Conduct user kick-off & prepare interviewees Conduct business user interviews Conduct IT data audit interviews
write-ups e-ups and incorporate feedback. 8 Publish interview writ Analyze interv interview iew findin findings gs 9 Analyze 10 Document findings and review requirements deliverables deliverables 11 Publish requirements 12 Prioritize and revise project scope 13 User acceptance/project review
t
t
t
l
t
l
r
r
l
l
t
t
l
l
LEGEND: l Primary responsibility m Involved t Provides input r Informed of results
t
l
t
t
l
l
t
t
l
l
m
m
m
m
m
m
m
m
m
m
m
m
m
m
m
m
m
m
m
m
m
m
m
t
l
l
r
m
m
l
l
m
r
r
r
r
r
r
r
r
r
r
r
r
r
l
l
m
m
m
m
m
m
m
m
m
m
m
r
r
r
r
r
r
r
r
r
r
r
r
m
l
m
m
m
l
m
m
r
l
m
m
m
l
m
m
m
m
m
m
m
m
m
m
m
m
m
t
m
l
m
m
m m
m
m
m
m
m
m
m
m
m
m
m
r
r
l
m
m
r
r
r
r
r
r
r
r
r
r
r
l
m
m
t
t
l
l
m
t
l
l
m
l
t
t
t
t
t
t
t
t
t
t
t
m
m
m
l
l
m
m
m
m
m
m
l
m
t
t
l m m
r
m
l
m
r
l
m
m
l
t
m
m
r
r
r
m
m
l
t
m
m
l
l
m
r
m
m
l
l
m
m
m
m
m
m
m
m
m
m
m
r
r
r
m
m
m
m
r
r
r
r
r
t
t
t
r
r
r
r
r
r
l t
r
r
r
r
r
r
r
r
r
r
r
r
r
DW/BI TECHNICAL ARCHITECTURE 1 2 3 4 5 6 7 8 9 10
1 2 3 4 5
APPLICATION ARCHITECTURE DESIGN Create architecture task force Gather & document technical r equirements equirements Review current technical environment Develop Develop architecture arc hitecture implications document Create architecture model Determine phased implementation approach Define and specify subsystems Create the architecture plan Develop configuration recommendations User acceptance/project review PRODUCT SELECTION (Repeat for each selection area) Develop evaluation matrix Research candidate products Develop product short list Evaluate product options Optional prototype (may repeat for multi products) Select business process / data for evaluation Define completion completion criteria cr iteria Acquire resources (internal/vendor) Determine test configuration Install evaluation prerequisites & components components Train the evaluation team Develop & tune prototype Conduct tests Analyze & document results
m
m
m
m
m
l
m
m
m
m
l
t
m
m
m
l
m
m
m
l
t
t
t
l
m
l
t r
r
r
l
m
r
l
l
t
r
r
t
t
l
r
r
m
m
m
m
m
m
m
m
m
m
l
m
m
m
m
l
m
m
m l
l
l
l
l
m
l
m
m
l l
Read Free Foron 30this Days Sign up to vote title m
m
m
r
m
Master your semester with Scribd & The New York Times Special offer for students: Only $4.99/month.
l l
m
m
Not useful Cancel anytime.
Useful m m
l
m
m
m
m
m
m
l
l
l
l
m
t
t
t
t
l
l
l
t
l
m
t
t
t
l
m t
Home
Saved
Top Charts
Books
Audiobooks
Magazines
News
Documents
Sheet Music
Master your semester with Scribd & The New York Times Special offer for students: Only $4.99/month.
Upload
Sign In
Read Free For 30 Days Cancel anytime.
Join
Search
Home
Saved
389 views
0
Sign In
Upload
Join
RELATED TITLES
0
BI Task List Uploaded by Ravi Rajasekharuni
Top Charts
Books
Audiobooks
BI Task List Doc from Kimball Group
Save
Embed
Share
Print
Magazines
News
Documents
Deolitte ETL Testing
1
Download
of 3
Etl
SQL
Search document
COMPANY NAME -- PROJECT NAME
Fans
Sheet Music Project Task 6 Implement security monitoring and compliance sys 7 User acceptance/project review
1 2 3 4 5
CREATE INFRASTRUCTURE PLAN Create draft infrastructure model and plan Review/update plan with key IT groups Create final version of initial plan Monitor and update plan User acceptance/project review
1 2 3 4 5
PRODUCT INSTALLATION (Repeat for each product) Installation planning Meet prerequisites Install hardware / software Test hardware / software User acceptance/project review
Front Office
s r e s U s s e n i s u B
/ r o r s e n v o i p r S D s s s s e e n i n i s s u u B B
r / e r g a o n t c a e r M i D m I a r B g / W o r D P
r
r
r
Coaches
r e g a n a M t c e j o r P
Regular Line-Up
d a e L t c e j o r P s s e n i s u B
t s y l a n A s s e n i s u B
t s y l a n A A Q / d r a w e t S a t a D
m
r
r
Special Teams
A B D / / t r c e e l t i e h d c r o A M a t a t a a D D
r e g a n a M a t a d a t e M
/ r t e c p e l o t i h e v c r e A D L L T T E E
/ r e p o l e v e D p r p e A p / l o t e c v e e t i D h l c a r A t r I o B P
r
r
r
r
m l
r
r
r
l
r
r
r
r
r
r
r
r
r
r
r
m
l
m
l
m
l
m
l
l
r o t a c u d E
r e g a n a M y t i r u c e S
m
m
r e t s e T d a e L
t s i l a i c e p S s t a t S / g n i n i M a t a D
t s i l / i a t c c e e t p i S h t c r r A o l p p a u c S i n h h c c e e T T
DIMENSIONAL DATA MODEL DESIGN Review business requirements Review/develop data warehouse bus matrix Select business process Declare fact table grain Identify dimensions Identify metrics Develop high level model diagram Document attributes list Identify candidate data sources Profile data Develop base and derived metrics Design detailed dimensional model Review data model with IT Review data model with business us ers Review design recommendations for BI Tool Review design recommendations for DBMS Finalize logical design documentation Draft source to target data map User acceptance/project review
1 2 3 4 5 6 7 8 9 10 11
PHYSICAL DATABASE DESIGN Define standards for physical objects Design physical tables & columns Finalize the source to target map Estimate database size Design development database Design auditing and staging tables Develop initial index plan Design the OLAP database Develop initial aggregation plan Develop initial partitioning plan User acceptance/project review
1 2 3 4 5 6 7
PHYSICAL DATABASE IMPLEMENTATION Install and setup the RDBMS Build physical storage structure Implement table partitioning Complete table and index sizing Create tables and indexes Create OLAP database User acceptance/project review
l
m
t
t
t
m
t
l
t
t
m
m
m
l
m
t
m
m
m
m
l
m
m
t
m
m
m
m
l
m
m
t
m
m
m
m
l
m
m
t
m
m
m
m
l
m
m
t
m
m
m
m
l
m
m
t
m
m
m
m
l
m
m
m
m
l
m
m
t
m
m
m
m
l
m
m
t
m
m
m
m
l
m
m
m
l
m
m
m
m
m
r
r
m
m
m
r
r
m
m
m
r
r
m m m m
r
m
l
m
r
m
m
m
m
m
r
r
r
r
r
r
r
r
r
r
r
r
l
l
m
r
l
r
r
m
m
l
t
l
m
r
m
r
r
You're Reading a Preview l l
m
m
m
l
l
Unlock full access withl a free trial. m m
m
l
m
m
t
r
l
t
t
l
t
m
m
l
l
r
l
t m
Download With Free Trial r
l
r
m
t
m
t
m
t
r t
m
m
m
r
r
r
r
r
r
r
m
l l
m
m
l l r
r
l
r
l m
m
m
m
t
m
m
m
m
r
m
m
m
Read Free Foron 30this Days Sign up to vote title l
t
l
m
l
m
t
m
6 Develop default str ategies for dimension change mgmt 7 Design strategy to meet availability requirements
m
m
l
m
m
m
l
m
m
m m
l l
m
Not useful Cancel anytime.
Useful
4 Develop default str ategies for archiving extracted data 5 Develop default str ategies for policing data quality
Special offer for students: Only $4.99/month.
r
t
t
l
Master your semester with Scribd & The New York Times ETL SYSTEM DESIGN 1 Design high level ETL process 2 Test, c hoose and implement an ETL tool 3 Develop default str ategies for extracting data
l
m r
l
l
m
m
m m
m m
Home
Saved
Top Charts
Books
Audiobooks
Magazines
News
Documents
Sheet Music
Master your semester with Scribd & The New York Times Special offer for students: Only $4.99/month.
Upload
Sign In
Read Free For 30 Days Cancel anytime.
Join
Search
Home
Saved
389 views
0
Sign In
Upload
Join
RELATED TITLES
0
BI Task List Uploaded by Ravi Rajasekharuni
Top Charts
Books
Audiobooks
BI Task List Doc from Kimball Group
Save
Embed
Share
Print
Magazines
News
Documents
Deolitte ETL Testing
1
Download
of 3
Etl
SQL
Search document
COMPANY NAME -- PROJECT NAME
Fans
Sheet Music Project Task 9 User acceptance/project review
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
BI APPLICATION DEVELOPMENT Review application specifications and standards Populate BI tool metadata Create business metadata Test BI tools Set up user security Set up report process metadata system Develop BI applications Validate data model and data Provide data accuracy & cleanliness feedback Develop BI portal Set up report execution scheduling Test BI applications and verify data Document BI applications Develop BI application maintenance procedures Develop BI application deployment procedures User review/project acceptance
Front Office
s r e s U s s e n i s u B
/ r o r s e n v o i p r S D s s s s e e n i n i s s u u B B
r / e r g a o n t c a e M r i D m I a r B g / W o r D P
m
m
m
Coaches
Regular Line-Up
r e g a n a M t c e j o r P
d a e L t c e j o r P s s e n i s u B
t s y l a n A s s e n i s u B
t s y l a n A A Q / d r a w e t S a t a D
l
m
m
r
t
Special Teams
A B D / / t r c e e l t i e h d c r o A M a t a t a a D D
r e g a n a M a t a d a t e M
/ r t e c p e l o t i h e v c r e A D L L T T E E
/ r e p o l e v e D p r p e A p / l o t e c v e e t i D h l c a r A t r I o B P
m
r
r
m
m m
t
l
m m
m
l
m
m
m
m
m
m
t
t
l
l
r o t a c u d E
r
r
r
m m
t
m
l
m
m
m
m
l
m
m
m
m
m
t
t
l
t
m
m
t
m
l
m
m
m
m
m
m
l
m
m
m
m
m
m r
r
r e t s e T d a e L
m
m
r
r
l
t
m
r e g a n a M y t i r u c e S
t s i l a i c e p S s t a t S / g n i n i M a t a D
l m
m
m
t s i l / i a t c c e e t p i S h t c r r A o l p p a u c S i n h h c c e e T T
m
m
m
m
m
m
l m
m
m
m
m
l l
m
m
m
m
m
m m
l m
l
r
r
r
m
m
m
m
m
l
l
m
m
m
r
r
r
m
DEPLOYMENT & OPERATIONS 1 2 3 4 5
Pre-Deployment Testing Develop a plan for implementing testing Purchase and implement test management tools Develop test datasets Define tests User acceptance/project review
1 2 3 4 5 6
Data and Process Testing Test historic load Test primary dataset for incremental load Conduct live tests with real data Test overall process and system integration Test month-end or other unusual conditions User acceptance/project review
1 2 3 4
Performance Tuning Test conformance to Servic e Level Agreements Test performance of data loads Improve performance of data loads Test query performance
Improve query performance via new indexes and/or 5 aggregations End-to-end testing of system after performance-related 6 changes 7 User acceptance/project review Other Testing 1 Usability testing of BI applications and portal 2 Confirm desktop readiness 3 User acceptance/project review
1 2 3 4 5 6
System Deployment Develop playbook for relational DW deployment Develop playbook for ETL system deployment Develop playbook for OLAP database deployment Develop playbook for BI application deployment Deploy new or changed system User acceptance/project review
t
r
l
m
m
m
m
l
m
m
l
m
m
m
m
l
m
m
m
m m
m
m m
m
m
m
m
l
m
m
m
l
m
m
m
l
m
m
m
m
m
l
m
m
m
m
m
m
l
m
l
m m
1 2 3 4
1
Back Room Operations Develop back roomoperations plan Maintain physical database and disks Maintain indexes and partitions Perform regular backups and test recovery
2 Special offer for students: Only $4.99/month. 3 4
m
r
m
m
m
m r
r
l
m
m
m
m
l
m
m
m
m
l
m
m
m
m
m
m
m
m
l
m
m
m
m
m
m
m
l
m
m
m
m
l
m
m
m
r
m
Download With Free Trial m
r
r
r
r
m
m
m
m
m
t
m
m
m
m
t
m
m
m
m
t
t
t
m
l
m
m
m
t
l l
m r
m
r
r
l m
l m
l l m
m
l
m
m
m
m
m
m
m
m
m
m
m
m
m
l
m
m
m
m
m
m
m
m
Unlock full access with a free trial. r l m m m m r m m
m r
l
m
m
m l
m
m
m
m
m
m
m
m
m
l
m
m
r
m
m
l
r
m
m
m
You're Reading a Preview m
Master your semester with Scribd & The New York Times User Facing Deployment Develop documentation Develop training Deliver training User acceptance/project review
m
r
l
m
r
m
m
m
m
r
l
l
r
r
m
m
m
m
m
m
t
m
l
Read Free Foron 30this Days Sign up to vote title t
m
m
m
t
m
l
t
m
t
t
l
m
m
r
t
m
Not useful Cancel anytime.
Useful
Home
Saved
Top Charts
Books
Audiobooks
Magazines
News
Documents
Sheet Music
Master your semester with Scribd & The New York Times Special offer for students: Only $4.99/month.
