agile data analysismydlc.com/pmi-mn/pres/2012b05_agiledataanaly_spesklo.pdfaria • expert in agile...
TRANSCRIPT
![Page 1: Agile Data Analysismydlc.com/pmi-mn/PRES/2012B05_AgileDataAnaly_SPesklo.pdfAria • Expert in Agile Data Analysis, Project Management, and Data Governance solutions with over 20 years](https://reader035.vdocuments.us/reader035/viewer/2022070722/5f01bb437e708231d400c42b/html5/thumbnails/1.jpg)
Aria
Agile Data Analysis – Considerations for
Implementing Data Projects
Steven Pesklo
Contact Steven Pesklo [email protected] (612) 360.0813
![Page 2: Agile Data Analysismydlc.com/pmi-mn/PRES/2012B05_AgileDataAnaly_SPesklo.pdfAria • Expert in Agile Data Analysis, Project Management, and Data Governance solutions with over 20 years](https://reader035.vdocuments.us/reader035/viewer/2022070722/5f01bb437e708231d400c42b/html5/thumbnails/2.jpg)
Aria
• Expert in Agile Data Analysis, Project Management, and Data Governance solutions with over 20 years of experience implementing data solutions around the world.
• Frequent speaker on data concepts and implementations
• Industry Expertise: Finance, Healthcare, Retail, Software, Manufacturing, Government
• Master’s degree in International Finance • Bachelor's degree in Computer Science.
About Steve Pesklo
Contact Steven Pesklo [email protected] www.softlakesolutions.com (612) 360.0813
![Page 3: Agile Data Analysismydlc.com/pmi-mn/PRES/2012B05_AgileDataAnaly_SPesklo.pdfAria • Expert in Agile Data Analysis, Project Management, and Data Governance solutions with over 20 years](https://reader035.vdocuments.us/reader035/viewer/2022070722/5f01bb437e708231d400c42b/html5/thumbnails/3.jpg)
Aria
Software Solutions:
• Ad Hoc Data Analysis – InfoZoom
• Data Governance – Collibra
Consulting Solutions:
• Data Profiling Consulting
• Data Quality Assessment
• Data Governance Consulting
Sales and Consulting Locations:
• Minneapolis
• New York
• Atlanta
• Phoenix
About SoftLake Solutions
Ad Hoc Data Analysis Solutions
Data Quality Data Governance
Solutions
Data Governance Data Analysis
Data Quality Assessment
Data Profiling Consulting
![Page 4: Agile Data Analysismydlc.com/pmi-mn/PRES/2012B05_AgileDataAnaly_SPesklo.pdfAria • Expert in Agile Data Analysis, Project Management, and Data Governance solutions with over 20 years](https://reader035.vdocuments.us/reader035/viewer/2022070722/5f01bb437e708231d400c42b/html5/thumbnails/4.jpg)
Aria Using the Interactive Keypads
Results are anonymous
Press “1” through “0”
Do not press Go or ?
Take a business card to consider for your next presentation
Contact: Tom Stuart
1 (877) 427-5111
www.interactiveconsultingresources.com
![Page 5: Agile Data Analysismydlc.com/pmi-mn/PRES/2012B05_AgileDataAnaly_SPesklo.pdfAria • Expert in Agile Data Analysis, Project Management, and Data Governance solutions with over 20 years](https://reader035.vdocuments.us/reader035/viewer/2022070722/5f01bb437e708231d400c42b/html5/thumbnails/5.jpg)
Aria
Learning Objectives
1. Determine when agile concepts should be applied to data and business intelligence projects
2. Better understand some of the special considerations needed in data reporting projects
3. Help improve the overall success rate for your data analysis and business intelligence projects
![Page 6: Agile Data Analysismydlc.com/pmi-mn/PRES/2012B05_AgileDataAnaly_SPesklo.pdfAria • Expert in Agile Data Analysis, Project Management, and Data Governance solutions with over 20 years](https://reader035.vdocuments.us/reader035/viewer/2022070722/5f01bb437e708231d400c42b/html5/thumbnails/6.jpg)
Aria
Why Agile, Ad Hoc Data Analysis?
“Between 70% to 80% of business intelligence projects fail”
- Gartner, Feb. 2011
Source
www.computerweekly.com/Articles/2011/01/25/244807/Poor-communication-to-blame-for-business-intelligence-failure-says.htm
Gartner’s Conclusions
• Poor communication between IT and the business
• Failure to ask the right questions about the real needs of the business
• Many of the businesses questions are psychological and sociological, not technical
• Make the mistake of looking at business intelligence as an engineering problem
![Page 7: Agile Data Analysismydlc.com/pmi-mn/PRES/2012B05_AgileDataAnaly_SPesklo.pdfAria • Expert in Agile Data Analysis, Project Management, and Data Governance solutions with over 20 years](https://reader035.vdocuments.us/reader035/viewer/2022070722/5f01bb437e708231d400c42b/html5/thumbnails/7.jpg)
Aria
Does the Gartner conclusion ring true in your organization?
1. Yes, Gartner’s conclusion is correct
2. Yes, Gartner’s conclusion is partially correct
3. No, not at my company
4. Don’t know
Interactive Question: Success of BI?
![Page 8: Agile Data Analysismydlc.com/pmi-mn/PRES/2012B05_AgileDataAnaly_SPesklo.pdfAria • Expert in Agile Data Analysis, Project Management, and Data Governance solutions with over 20 years](https://reader035.vdocuments.us/reader035/viewer/2022070722/5f01bb437e708231d400c42b/html5/thumbnails/8.jpg)
Aria
Agile Data Analysis
How to do it?
To frame the question, consider three categories:
People Process Technology
![Page 9: Agile Data Analysismydlc.com/pmi-mn/PRES/2012B05_AgileDataAnaly_SPesklo.pdfAria • Expert in Agile Data Analysis, Project Management, and Data Governance solutions with over 20 years](https://reader035.vdocuments.us/reader035/viewer/2022070722/5f01bb437e708231d400c42b/html5/thumbnails/9.jpg)
Aria
Agile Data Analysis
People Process Technology
![Page 10: Agile Data Analysismydlc.com/pmi-mn/PRES/2012B05_AgileDataAnaly_SPesklo.pdfAria • Expert in Agile Data Analysis, Project Management, and Data Governance solutions with over 20 years](https://reader035.vdocuments.us/reader035/viewer/2022070722/5f01bb437e708231d400c42b/html5/thumbnails/10.jpg)
Aria
“Tell me what you want to see… and I will do it for you.”
Why is this story relevant??
Lack of communication and a clash of working style
In Agile Data Analysis, “Tell me what you want to see… and I will do it for you”
does not work.
![Page 11: Agile Data Analysismydlc.com/pmi-mn/PRES/2012B05_AgileDataAnaly_SPesklo.pdfAria • Expert in Agile Data Analysis, Project Management, and Data Governance solutions with over 20 years](https://reader035.vdocuments.us/reader035/viewer/2022070722/5f01bb437e708231d400c42b/html5/thumbnails/11.jpg)
Aria
The “People” part of agile analysis
Key Questions:
• Does your business organization know what they want?
• Can your business organization articulate what they want?
• Does your business organization have the technical skills to perform data analysis?
• Does your business organization have the subject matter expertise to perform data analysis?
• Is there a level of trust between IT and Business organizations?
![Page 12: Agile Data Analysismydlc.com/pmi-mn/PRES/2012B05_AgileDataAnaly_SPesklo.pdfAria • Expert in Agile Data Analysis, Project Management, and Data Governance solutions with over 20 years](https://reader035.vdocuments.us/reader035/viewer/2022070722/5f01bb437e708231d400c42b/html5/thumbnails/12.jpg)
Aria
Agile Data Analysis
Process People Technology
![Page 13: Agile Data Analysismydlc.com/pmi-mn/PRES/2012B05_AgileDataAnaly_SPesklo.pdfAria • Expert in Agile Data Analysis, Project Management, and Data Governance solutions with over 20 years](https://reader035.vdocuments.us/reader035/viewer/2022070722/5f01bb437e708231d400c42b/html5/thumbnails/13.jpg)
Aria
Does your organization use an Agile Project Development Methodology?
1. Huh? What’s Agile?
2. We have experimented with agile concepts
3. We can scrum better than a New Zealand rugby team
4. Don’t know
Interactive Question: Agile Familiarity?
![Page 14: Agile Data Analysismydlc.com/pmi-mn/PRES/2012B05_AgileDataAnaly_SPesklo.pdfAria • Expert in Agile Data Analysis, Project Management, and Data Governance solutions with over 20 years](https://reader035.vdocuments.us/reader035/viewer/2022070722/5f01bb437e708231d400c42b/html5/thumbnails/14.jpg)
Aria Approaches to Data Analysis
Requirements
Analyze & Design
Implement
Test & Evaluate
Deploy
Data Analysis Philosophies
• Waterfall Approach
• Agile Approach The Waterfall Approach
![Page 15: Agile Data Analysismydlc.com/pmi-mn/PRES/2012B05_AgileDataAnaly_SPesklo.pdfAria • Expert in Agile Data Analysis, Project Management, and Data Governance solutions with over 20 years](https://reader035.vdocuments.us/reader035/viewer/2022070722/5f01bb437e708231d400c42b/html5/thumbnails/15.jpg)
Aria Approaches to Data Analysis
Data Analysis Philosophies
• Waterfall Approach
• Agile Approach
The Agile Approach
![Page 16: Agile Data Analysismydlc.com/pmi-mn/PRES/2012B05_AgileDataAnaly_SPesklo.pdfAria • Expert in Agile Data Analysis, Project Management, and Data Governance solutions with over 20 years](https://reader035.vdocuments.us/reader035/viewer/2022070722/5f01bb437e708231d400c42b/html5/thumbnails/16.jpg)
Aria
Are you familiar with or is your organization utilizing the Corporate Information Factory* or similar architectures?
1. I’m not familiar with the CIF concepts
2. I’m familiar, but my company does not have any CIF-type architecture strategy defined
3. We have a data architecture strategy in place, but do not refer to it as a CIF
4. We have a data architecture and reference it as a CIF-type architecture
Interactive Question: Using a CIF approach?
* = CIF as popularized by Bill Inmon
![Page 17: Agile Data Analysismydlc.com/pmi-mn/PRES/2012B05_AgileDataAnaly_SPesklo.pdfAria • Expert in Agile Data Analysis, Project Management, and Data Governance solutions with over 20 years](https://reader035.vdocuments.us/reader035/viewer/2022070722/5f01bb437e708231d400c42b/html5/thumbnails/17.jpg)
Aria
An example of a Corporate Information Factory
![Page 18: Agile Data Analysismydlc.com/pmi-mn/PRES/2012B05_AgileDataAnaly_SPesklo.pdfAria • Expert in Agile Data Analysis, Project Management, and Data Governance solutions with over 20 years](https://reader035.vdocuments.us/reader035/viewer/2022070722/5f01bb437e708231d400c42b/html5/thumbnails/18.jpg)
Aria Typical Waterfall Implementation
Financial Application
CRM Application
Data Warehouse / Staging Area
Data Marts
![Page 19: Agile Data Analysismydlc.com/pmi-mn/PRES/2012B05_AgileDataAnaly_SPesklo.pdfAria • Expert in Agile Data Analysis, Project Management, and Data Governance solutions with over 20 years](https://reader035.vdocuments.us/reader035/viewer/2022070722/5f01bb437e708231d400c42b/html5/thumbnails/19.jpg)
Aria An Agile Case Study: New Acquisition
Financial Application
CRM Application
Data Warehouse / Staging Area
Data Marts
Acquired Financial Application or Book of Business
1
2
3
4
Discussion Point
• Business demands fast turnaround
• What does Agile mean in this case?
MS Access / Excel
5
![Page 20: Agile Data Analysismydlc.com/pmi-mn/PRES/2012B05_AgileDataAnaly_SPesklo.pdfAria • Expert in Agile Data Analysis, Project Management, and Data Governance solutions with over 20 years](https://reader035.vdocuments.us/reader035/viewer/2022070722/5f01bb437e708231d400c42b/html5/thumbnails/20.jpg)
Aria
In your projects, which approach does your organization typically deploy?
1. Existing application
2. Staging area
3. Data mart
4. Reporting environment
5. Extract to a database
Interactive Question: What would be your approach?
![Page 21: Agile Data Analysismydlc.com/pmi-mn/PRES/2012B05_AgileDataAnaly_SPesklo.pdfAria • Expert in Agile Data Analysis, Project Management, and Data Governance solutions with over 20 years](https://reader035.vdocuments.us/reader035/viewer/2022070722/5f01bb437e708231d400c42b/html5/thumbnails/21.jpg)
Aria Data Analysis Spectrum
Requirements well defined and articulated
• Mature reporting infrastructure
• Well defined metadata
Waterfall Reporting
Agile Reporting
Requirements not well known
• Reporting infrastructure less mature
• Metadata not well defined
Business Consideration
• Stable business conditions
• Investment in IT systems and disciplines
Business Consideration
• Merger and Acquisitions
• Continuously changing businesses
• Forensics and Audit
![Page 22: Agile Data Analysismydlc.com/pmi-mn/PRES/2012B05_AgileDataAnaly_SPesklo.pdfAria • Expert in Agile Data Analysis, Project Management, and Data Governance solutions with over 20 years](https://reader035.vdocuments.us/reader035/viewer/2022070722/5f01bb437e708231d400c42b/html5/thumbnails/22.jpg)
Aria
How is MS Access used within your organization?
1. For data analysis
2. As operational systems
3. Special business applications
4. We do not use a large amount of MS Access
(select all that apply)
Interactive Question: Pervasive use of MS Access?
![Page 23: Agile Data Analysismydlc.com/pmi-mn/PRES/2012B05_AgileDataAnaly_SPesklo.pdfAria • Expert in Agile Data Analysis, Project Management, and Data Governance solutions with over 20 years](https://reader035.vdocuments.us/reader035/viewer/2022070722/5f01bb437e708231d400c42b/html5/thumbnails/23.jpg)
Aria
Agile Data Analysis
Technology People Process
![Page 24: Agile Data Analysismydlc.com/pmi-mn/PRES/2012B05_AgileDataAnaly_SPesklo.pdfAria • Expert in Agile Data Analysis, Project Management, and Data Governance solutions with over 20 years](https://reader035.vdocuments.us/reader035/viewer/2022070722/5f01bb437e708231d400c42b/html5/thumbnails/24.jpg)
Aria Many Technology Options
Ad Hoc Data Analysis Solutions
![Page 25: Agile Data Analysismydlc.com/pmi-mn/PRES/2012B05_AgileDataAnaly_SPesklo.pdfAria • Expert in Agile Data Analysis, Project Management, and Data Governance solutions with over 20 years](https://reader035.vdocuments.us/reader035/viewer/2022070722/5f01bb437e708231d400c42b/html5/thumbnails/25.jpg)
Aria
What does Agile Data Analysis look like at your company?
• Are there technologies that meet your agile needs?
• Are they business friendly?
• Do your technologies support business discovery?
• Do the technologies require business users to program?
Technologies
“IT departments make the mistake of looking at data analysis as an engineering problem” - Gartner
![Page 26: Agile Data Analysismydlc.com/pmi-mn/PRES/2012B05_AgileDataAnaly_SPesklo.pdfAria • Expert in Agile Data Analysis, Project Management, and Data Governance solutions with over 20 years](https://reader035.vdocuments.us/reader035/viewer/2022070722/5f01bb437e708231d400c42b/html5/thumbnails/26.jpg)
Aria Take-Aways
Consider all parts of the solution • People • Process • Technology
People • Proactively communicate with business groups • Build trust with a partnership approach • Understand the business need for agile analysis • Pick a project that can build on success
People Process Technology
![Page 27: Agile Data Analysismydlc.com/pmi-mn/PRES/2012B05_AgileDataAnaly_SPesklo.pdfAria • Expert in Agile Data Analysis, Project Management, and Data Governance solutions with over 20 years](https://reader035.vdocuments.us/reader035/viewer/2022070722/5f01bb437e708231d400c42b/html5/thumbnails/27.jpg)
Aria Take-Aways
Process • Have defined criteria when to leverage
Waterfall vs. Agile techniques • Have a support process for quickly analyzing data • Include agile analysis principles in an overall data
architecture
Technology • Avoid over-engineering a solution • Make certain the technologies can support agile
analysis • Does the technology allow for business
discovery?
Process
Technology