BI Project Management Flashcards

1
Q

Elements of BI Project Planning

A

— Building the BI business case

— Requirements

— Sponsor(s), stakeholders, BI team

— Building a plan

— Executing that plan

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Project Characteristics

A

import from PM

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

5 Stages of Projects

A
  1. Initiating
  2. Planning
  3. Executing
  4. Monitoring and controlling
  5. Closing
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Quadruple Triangle

A

*quality has many definitions

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Advantages of Project Management

A

▪Better control of financial, physical, and people resources

▪Improved customer relations

▪Shorter development times

▪Lower costs

▪Higher quality and increased reliability

▪Higher profit margins

▪Improved productivity

▪Better internal coordination

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Duties of Project Managers

A
  • Gather resources for the project
  • Linked to the customer interface
  • Provides direction, coordination, and integration to the project team
  • Responsible for performance and success of the project
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Challenge of Project Management:

A
  • Managing temporary, non-repetitive activities and often acting independent of the organization
  • Getting right people, right time to address the right issues and make the right decisions.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Define PM

A

the application of knowledge, skills, tools and techniques to project activities to meet project requirements

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

15 PM Functions

A
  1. Define scope of project
  2. Identify stakeholders, decision-makers, escalation procedures
  3. Develop detailed task list (work breakdown structures)
  4. Estimate time requirements
  5. Develop initial project management flowchart
  6. Identify resources and budget
  7. Evaluate project requirements
  8. Identify and evaluate risks
  9. Prepare contingency plan
  10. Identify interdependencies
  11. Identify and track critical milestones
  12. Participate in project phase reviews
  13. Secure needed resources
  14. Manage the change control process
  15. Report project status
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

PM Lifecycle

A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Business Case

A
  • What business problems or opportunities will we tackle?
    • Pains it relieves
    • Gains it creates
  • Who will use the project deliverables?
  • What are the business benefits?
  • Have we had previous failed BI projects, and why?
    • What lessons have we incorporated?
  • Basline
  • Sets expectations
    • Deliverables, timescales
  • Estimate scope, costs, schedule
  • Return of Investment
  • Gain commitment from the business
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Business Case needs…

A
  • Review of organisation’s business initiatives
  • Committed BI sponsor
  • Connect with BI stakeholders
  • Lessons learned from previous projects?
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Sponsor

A
  • You need a senior management sponsor
    • With authority and respect in the business
  • Who will commit funding and support
    • Business resources to work with the BI project team
    • Ensure there is long term funding
    • Resolve problems that cannot be resolved by BI project team
  • Sponsor as point of escalation
    • CFO often a good sponsor –they need accurate enterprise info to fulfil their legal obligations
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Stakeholder involvement

A
  • Need them for requirements, testing,
  • Validation of Business Case
  • Involve stakeholders early
    • To gain more detailed business case input
    • To identify gaps and risks
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Building the technical case

A
  • Likely to introduce new technologies and products
  • Possible resistance from existing IT and staff
    • Get them on your side by involving the technologists
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

Selecting product short-list(s) workflow

A
17
Q

Choice of infrastructure platforms

A
  • On premises –in your own datacentre
  • Colo: co-location centre–rent kit, space, connectivity
  • Outsourcing –get someone else to run it for you
  • Cloud –shared IT resources on demand
18
Q

Assessing organisation’s readiness

A

A risk assessment…

  • Data and Data Quality
  • Expertise and experience –users and IT
  • Commitment to Analytics
  • Organisationaland cultural change
  • Financial commitment
19
Q

Project Definition Workshop

A

Structured 1/2, 1 or 2 day meeting with decision makers

  • Agree the project’s goals, objectives and scope
  • Define the project’s key tasks, structure, management, control mechanisms
  • Identify the risks, issues, assumptions, probabilities and impacts
  • Commit the main players to the project and the key decisions
  • Impel follow on actions; impart momentum to the project
  • Agree the completion criteria and deliverables
  • Results in a signed off Project Definition Report

It’s not

  • Detailed planning
  • A technical or project review design meeting
  • A brainstorming session
  • Unstructured
  • An “easy” day off from work
  • Not the end - further work is needed to go into more detail
20
Q

Managing Scope Screep

A
  • Clarify requirements, scope, schedule, budget, products
  • Set and communicate realistic expectations
  • Agree business rules and data definitions
  • Have room in schedule for changes and problems
  • Enforce a process to manage changes
  • Do impact analysis, adjust plans if necessary
  • Say “no” or “not yet’
  • Get sponsor to back you up
  • Communicate
21
Q

Use of Requirements + Types

A
  • Foundation for a successful BI solution
  • Development team uses these requirements to:
    • design
    • develop
    • deploy BI systems
  • Priotisation - MoSCoW (must have, should have,…)

Functional requirements

  • what the users will get; use cases

Non-functional requirements

  • qualities and constraints
  • e.g. availability, performance, security, operability
  • Project team plus IT Run’s infrastructure team
22
Q

Requirements – stepwise refinement

A
23
Q

Gathering requirements

A
  • Interviews
  • Consulting stakeholders
24
Q

IT roles and responsibilities

A
  • Determining what data the business needs for BI
  • Data profiling to identify data sources
  • Data modelling to enable integration and BI
  • Developing the data and information architecture
  • Physically doing the data integration
  • Designing and developing the infrastructure to support all this
25
Q

BI Steering Committee

A
  • Purpose –guide and support the project or programme
  • Made up of business and IT management
    • i.e. management of individual business, IT teams
  • Project manager presents status of project
  • Discusses issues and concerns
  • Helps resolve issues or enlist support
26
Q

BI Working Committee

A
  • Often set up as part of a BIprogramme
  • Bridges individual BI projects and Steering Committee
  • Tackles cross-project issues
27
Q

Project development team – core functions

A
28
Q

Example WBS of an individual BI project

A
29
Q

Example WBS of a BI architecture (workstream)

A
30
Q

JUST LEARN THE BASICS OF PM MODULE

A

JUST LEARN THE BASICS OF PM MODULE