50 likes | 61 Views
Join an interactive discussion on BI success factors, including anticipating changing requirements, optimizing performance, and marketing your BI/DW. Learn how to stay current, meet real-time requirements, and manage security and privacy. Discover strategies for optimizing performance, measuring query response time, and marketing your BI/DW to different stakeholders.
E N D
Promote Yourself - through Tuning into Your BI Clients' Needs! • Agenda: An interactive discussion on BI success factors: • Anticipating changing requirements • How are you optimizing performance? • How are you Marketing your BI/DW? “How do the clients like our BI Applications?” Bill Chadwick Consulting 1-905-853-0955
Anticipating Changing Requirements • How often should you survey all your users for feedback/needs/ideas? • How quickly do you provide for new Alerts, changing thresholds, prebuilt reports? • How do you stay current on reorganizations that will affect BI reports? • How do you learn of changes to source system processess that may affect BI? • How do you plan to meet newnear Real-Time BI requirements? • How connected is your process to business rule changes? • 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? • 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-853-0955
How are you optimizing performance? • 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-853-0955
How are you Marketing your BI/DW? • 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? • Is there a active Committee coordinating all BI/DW work across the Enterprise? • Other suggestions? Bill Chadwick Consulting 1-905-853-0955
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-853-0955