Transcript Promote Yourself - through Tuning into Your BI Clients` Needs!

Promote Yourself - through Tuning into Your BI Clients' Needs!
Agenda: An interactive discussion on BI success factors:
1. Anticipating changing requirements
2. How are you optimizing performance?
3. How are you Marketing your BI/DW?
“How do the clients like our BI Applications?”
Bill Chadwick Consulting 1-905-8530955
1
Anticipating Changing Requirements
1. How often should you survey all your users for feedback/needs/ideas?
2. How quickly do you provide for new Alerts, changing thresholds,
prebuilt reports?
3. How do you stay current on reorganizations that will affect BI reports?
4. How do you learn of changes to source system processess that may
affect BI?
5. How do you plan to meet new near Real-Time BI requirements?
6. How connected is your process to business rule changes?
7. What feedback do you provide on source system and load data quality?
• Are rejected records made available for querying/correction?
• Is there an active Data Steward accountable for quality
improvement in each internal data source?
8. How do you manage changing security and privacy requirements?
• Do you monitor query activity for signs of theft or fraud?
Bill Chadwick Consulting 1-905-8530955
2
How are you optimizing performance?
1.
2.
3.
4.
5.
6.
7.
8.
9.
How frequently do you measure query response time?
Do you have a plan to pre-process frequently repeated queries?
How aggressively do you seek new aggregations?
Do you insulate high performance needs from Data Mining, etc?
Can you stop a runaway query without shutting down?
Do you know your simultaneous query load (actual & max capacity)?
How often do you archive seldom used data?
What is your process for Index tuning, partitioning, etc?
Other suggestions?
Bill Chadwick Consulting 1-905-8530955
3
How are you Marketing your BI/DW?
1.
2.
3.
4.
5.
6.
Within the teams you currently serve?
In Departments and teams not currently using your BI/DW?
For B to B, B to C, Regulators, or other third party needs?
Do you track Return On Investment?
How do you nurture your Sponsor?
How are you tuning in to changing Corporate goals, risks,
opportunities?
7. Is there a active Committee coordinating all BI/DW work across the
Enterprise?
8. Other suggestions?
Bill Chadwick Consulting 1-905-8530955
4
The Bottom Line question:
Will you use the lessons learned tonight to
Promote Yourself - through Tuning into Your
BI Clients' Needs?
For more tips consider: “An Introduction to Business Intelligence”. Next class
starts Jan 31st for 6 evenings at U of T’s School of Continuing Studies
(Course SCS 0245). see www.utoronto.ca
Bill Chadwick Consulting 1-905-8530955
5