Loading presentation...

Present Remotely

Send the link below via email or IM

Copy

Present to your audience

Start remote presentation

  • Invited audience members will follow you as you navigate and present
  • People invited to a presentation do not need a Prezi account
  • This link expires 10 minutes after you close the presentation
  • A maximum of 30 users can follow your presentation
  • Learn more about this feature in our knowledge base article

Do you really want to delete this prezi?

Neither you, nor the coeditors you shared it with will be able to recover it again.

DeleteCancel

Make your likes visible on Facebook?

Connect your Facebook account to Prezi and let your likes appear on your timeline.
You can change this under Settings & Account at any time.

No, thanks

Data Warehousing

No description
by

Heidi M

on 18 October 2012

Comments (0)

Please log in to add your comment.

Report abuse

Transcript of Data Warehousing

Data Warehousing Tia Thu Howell & Heidi Moesinger Data Warehousing Definition System Requirements Problems Data Warehousing Solves Some Companies that use
Data Warehousing Risks Co t Implementation Recommendations Technology Choice Frost, Alan. (2010). Warehousing Data: The Data Warehouse, Data Mining, OLAP, and Data Visualization. Retrieved on October 17, 2012 from http://www.knowledge-management-tools.net/data-warehousing.html Thank you! Questions & Comments Data Warehousing
Word Press. (2009) Retrieved October 13, 2012 from http://ecommercecenter.net/management/what-is-a-data-warehouse.html Frost, Alan. (2010). Warehousing Data: The Data Warehouse, Data Mining, OLAP, and Data Visualization. Retrieved on October 17, 2012 from http://www.knowledge-management-tools.net/data-warehousing.html Data enters
warehouse Data is cleaned
& transformed Departments & Processes Affected Inmon, William H. (2000). The Datawarehouse Budget. Retrieved on October 15, 2012 from http://www.google.com/url?sa=t&rct=j&q=&esrc=s&source=web&cd=1&ved=0CDQQFjAA&url=http%3A%2F%2Fwww.datawarehouse.inf.br%2Fpapers%2Finmon%2520budget-1.pdf&ei=jtR8UPmcK8aB0QGU2YGwCA&usg=AFQjCNHh9X_iwHVLKfywcyS7UPOXRWX-jw Health Care
Retail
Financial Services
Telecommunications Data Warehousing by Industry. Retrieved on October 15, 2012 from http://www.google.com/url?sa=t&rct=j&q=&esrc=s&source=web&cd=1&ved=0CDEQFjAA&url=http%3A%2F%2Facme.highpoint.edu%2F~kreaves%2FMIS%2520420%2520Presentations%2FData%2520Warehousing%2520by%2520Industry.ppt&ei=tth8ULGmHuSn0AG61IGgDQ&usg=AFQjCNGaQ1KTQiiFrPENW6zyfRRhBXchZg Access to data
Data Sharing
Faster Decision Making
Higher Quality Data Adelman, Sid (2002). Impossible Data Warehouse Situations: Management Issues. Retrieved on October 16, 2012 from http://www.tdan.com/view-articles/5061 Failure
Inaccurate data input
Duplicate records
Incompatibility with company Adelman, Sid. (2002) Impossible Data Warehouse Situations: Management Issues. Retrieved on October 15, 2012 from http://www.tdan.com/view-articles/5061 Opportunities Data is stored Data is retrieved for use IBM. System requirements for the data warehouse. Retrieved on October 16, 2012 from http://publib.boulder.ibm.com/infocenter/rqmhelp/v2r0/index.jsp?topic=/com.ibm.rational.rcpr.help.doc/topics/r_system_software_datawarehouse.html All departments, especially sales

Increasing need for integrated data &
better executive decision making Ranjan, Ravi. Data Warehouse. Retrieved on October 16, 2012 from http://www.authorstream.com/Presentation/ravionly431-142230-final-data-warehousing-present-complete-datawarehousing-information-education-ppt-powerpoint/
-DB2 from IBM Corporation
-MySql from Sun Software
-Oracle from Oracle Corporation
-SQL Server from Microsoft Corporation
-Teradata from Teradata Corporation
-Sybase-IQ and Postgres Haertzen, David. Relational Database Technology for Data Warehousing. Retrieved on October 16, 2012 from http://infogoal.com/datawarehousing/database.htm -Ability to see the company as a whole
-Ability to handle server tasks connected to querying which is not used by most transaction systems
-Making queries of data on a regular basis. Exforsys Inc. (2007). The Benefits of Data Warehouses. Retrieved on October 16, 2012 from http://www.exforsys.com/tutorials/data-warehousing/data-warehouses-benefits.html Depends on our goals and objectives
-Consider performance features
-Consider financial features Determine
Focus of the system needed by the company
Information needs of users
Size and complexity of the system needed Optimize
User competence
Maintenance of system
Accuracy and clarity of data entered
Full transcript