Paul Boal Mercy Health March 23 2011 Opening Questions What kinds of jobs does someone do in the area of business intelligence What does someone working in business intelligence do What are common tools used in business intelligence ID: 799159
Download The PPT/PDF document "Business Intelligence Technology and Car..." is the property of its rightful owner. Permission is granted to download and print the materials on this web site for personal, non-commercial use only, and to display it on your personal computer provided you do not modify the materials and that you retain all copyright notices contained in the materials. By downloading content from our website, you accept the terms of this agreement.
Slide1
Business Intelligence
Technology and Career Options
Paul
Boal
Mercy Health
March 23, 2011
Slide2Opening Questions
What kinds of jobs does someone do in the area of business intelligence?
What does someone working in business intelligence do?
What are common tools used in business intelligence?
2
Slide3What do you do in Business Intelligence?
3
Slide4What do you do in Business Intelligence?
Data Governance
Data Architecture, Analysis, and Design
Database Management
Data SecurityData QualityMaster Data Management
Data Warehousing
Reporting
Metadata Management
4
Data analyst
Business analyst
Data modeler
Data architect
Report writer
BI developer
ETL developer
Slide5What do you do in Business Intelligence?
Interview users
Understand business problems
Model databases
Analyze dataIntegrate dataWrite reports
Build dashboards
Share insights
Make the organization smarter…
Solve
Business
Problems
Slide6The (sometimes) thankless part…
Data management isn’t important…
First priority is delivering services/products…
Reporting is easy…
6
Slide7Mercy Data Warehousing / Mercy Insight
Here’s how easy it is…
Slide8COMMON CHALLENGES
Getting access
to source data
Working with application teams
Data quality and data stewardship
Master data management
User Expectations
8
Slide9Challenge:
Getting Access to Data
Vendor Contract Obstacles
Flexibility of vendor to allow access / support
Cost of building extracts
Technical Obstacles
Legacy systems, programming/system skills
Knowledge Gaps
Knowledge of source system data
Cultural Obstacles
Application team controls access too tightly
Development teams are timid about database access
9
Slide10Challenge: Application Teams
Development Style
You tell me exactly what you want and I'll build it.
Give me the business logic and I'll build it.
Analytical HubrisThis is the way it works;
come to find out the data doesn't match.
I assumed that you wanted it like that other extract.
Fear of a down-stream dependency
e.g.
Kronos PR530
The PICA code
10
Slide11Challenge: Data Quality &
Master Data Management
Not analyzing or profiling data contents
Using
terms rather than
ideas
Building in rules that are too strict
Missing formal data governance policies
Lack of clear data stewardship
Data seen only as operational
11
http://ocdqblog.com
Slide12Challenge: User Expectations
Sometimes, users expect computers to be able to solve problems for them;
Sometimes, users don't want the system to do anything for them.
Rationalize data integration / data warehousing
80% gathering information together
20% analyzing and decision making
Web 2.0 versus Enterprise Applications
Enterprise solutions
versus
departmental control
System Performance
12
Slide13Challenges in Getting Value from Data
Data Usage Survey
195 data users across Mercy (of 380 surveyed)
analysts, informaticists, statisticians, report writers
Top Challenges
Finding the data they need
Performance of the systems they use to access data
Integrity of the data they have access to
Integrating data from multiple sources
Target
80% using data and %20 getting data
1
Current Efficiency Gap
13
Slide14STAYING FIT
Organizations / Conferences
TDWI
B-Eye-Network
TDAN
Analysts:
Gartner
, Forrester
Blogs
I'll email you my Google Reader list:
paul.boal@gmail.com
Twitter
BI Twitter ListOpen Source and Developer ToolsTalend, Pentaho, Jaspersoft, BIRT, InfobrightOracle, Teradata, IBM
14
Slide15Demonstrations
15
Slide16Business Objects Universe
16
Slide17Business Objects
WebI
17
Slide18Dashboard Example
18
Slide19Tools / Resources
Open Source BI
Pentaho
– reporting, analytics, integration, dashboards, mining
Talend – integration, data quality, master data
Jaspersoft
– reporting, analytics, integration, dashboards
Actuate BIRT
– reporting
Open Source Stats/Mining
R
– statistics
Weka – machine learningDatabasesMySQL, Oracle, Teradata, SQL Server, InfobrightTeradata University Network
Internships19