Transcript C522 Information Technology for Managers Kelley School of

A337 Accounting Information Systems
N J Taylor
Topics
• Business Intelligence
• Data Quality
• XBRL
Enterprise Systems
“Enterprise” Systems
Enterprise Resource Planning (ERP)
Systems
– Operational data in a single database
Data Warehouse
– Decision data in a single “extracted”
database
– Can be a subset of the data (data
mart)
Business Intelligence
Extract, Transform, Load (ETL)
From Computerworld QuickStudy
Data Quality
Data Quality: What is Dirty Data?
Potential Problems?
• Inventory Reorder
• Profit per unit  Net profit
• Customer Satisfaction
– Less Repeat Business
– Angry Bloggers
Solution: Same code for vendor and retailer
No translation necessary (like MAC address)
Data Integrity: Wal-Mart's Dirty Secret
Web Scraping and Data Quality
• Poor data quality can lead to
poor decisions (GIGO)
• Cleanup can be costly
because it often involves
human effort
• Demo (Madonna of Foligno
(Raphael)
Web Scraping and Data Quality
• XML
<painting>
<img src="madonna.jpg" alt='Foligno Madonna, by Raphael'/>
<caption>This is Raphael's "Foligno" Madonna, painted in
<date>1511</date>–<date>1512</date>. </caption>
</painting>
• Web Services
– Allows computer-to-computer communication.
– Data representation can be a challenge - e.g. Historical
stock price for Sun Microsystems (SUN, JAVA, ORCL)