Send the link below via email or IMCopy
Present to your audienceStart 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.
Make your likes visible on Facebook?
You can change this under Settings & Account at any time.
Foundations of Business
Transcript of Foundations of Business
Intelligence: Databases and
How does a relational database organzie data?
What are the principles of a database management system?
What are the principal tools and technologies for accessing information from databases to improve business performance and decision making?
What is the role of information policy and data administration in the management of organizational data resources?
Why is data quality assurance so important for a business?
How can information from big data be unhelpful when making decisions?
How would online analytical processing (OLAP) be used by a product manager?
Online analytical processing (OLAP) is used to analyze the relationships between multidimensional data which can be viewed in different dimensions using cubes.
The same data can be viewed in various ways in order to analyze different aspects of information.
Explosion of Data
Web Traffic, E-ail Messages, Social Media
Better than Traditional & Small Data
Patterns & Differences
"Capturing, storing, and analyzing big data can be expensive, and information from big data may not necessarily help decision-makers" (p.198).
If businesses don’t ask the right questions or have knowledge about how big data can solve problems, then the data are useless.
What was the business impact of The Globe and Mail's data management problems? What work had to be done by both business and technical staff to make sure that the data warehouse produced the results envisioned by management?
What problems were able to be solved by making better use of data available to the Cincinnati Zoo? (p.204)
How are businesses today ensuring data quality?
How are businesses linking databases to the web? And what are the benefits?
What are the techniques of storing data? Which do you think is most reliable?
Case Study Summary
American Water Keeps Data Flowing
Case Study Questions
Discuss the role of information policy, data administration, and efforts to ensure data quality and approving data management at American Water.
Team 2 and 4:
Describe the roles played by information systems specialists and end users in American Water's systems transformation project.
Why was the participation of business users so important? If they didn't play this role, what would have happened?
How did implementing a data warehouse help American Water move toward a more centralized organization?
Give some examples of problems that would have occured at American Water if its data were not "clean".
How would American Waters data warehouse improve operations and management decision making?
Case Study Update
The Globe and Mail
Not Easily Accessible
Hindered Decision Making
Marketing & Advertisment
The Globe and Mail
Standard Company-Wide Format
Example in the Book p.201
Top-rated zoo with over 1.2 million attendees every year
Non-profit with an annual budget of $26 million
management had little understanding of the daily business within the zoo
Four legacy point of sale system
Galaxy POS & IBM and BrightStar Partners
focuses on the hidden relationships.
The Cincinnati Zoo & Botancial Garden
Membership or Loyalty Cards
Target Specific Customers
The Cincinnati Zoo & Botanical Garden
"If the data is incomplete,
out of context
or otherwise contaminated, it can lead to decisions that could undermine the competitiveness of an enterprise or damage the personal lives of individuals"
Data does not equal intelligence
Armerding, T. (2013, August 26). Big data without good analytics can lead to bad decisions. Retrieved March 4, 2015, from http://www.infoworld.com/article/2611729/big-data/big-data-without-good-analytics-can-lead-to-bad-decisions.html
"the industry has over-focused on the management of machine-generated event data, rather than delivering actual value from core business data"
Not Serving Companies
Bien, F. (2014, May 7). 3 bad business-intelligence habits that we need to break. Retrieved March 4, 2015, from http://venturebeat.com/2014/05/07/looker-business-intelligence/
"OLAP can be used for data mining or the discovery of previously undiscerned relationships between data items"
Method for Storing Data
Millions of Records at One Time
Rouse, M. (n.d.). What is OLAP (online analytical processing)? - Definition from WhatIs.com. Retrieved March 4, 2015, from http://searchdatamanagement.techtarget.com/definition/OLAP
Data that are inaccurate, untimely or inconsistent with other sources of information create serious operational and financial problems for businesses.
Data Quality Audit
Surveys entire data files, samples of data files or surveys users for their perceptions of data quality.
Detecting and correcting data that are incorrect, incomplete, improperly formatted, or redundant.
Businesses want to make their information in their internal data bases available to their customers and their partners.
Customers can access the businesses internal database over the web using a web browser software on the customers PC. It would then request data from the businesses database using the HTML commands to communicate with the web server.
Some Techniques of Storing Data
File system compression
Back up storage compression
Data duplication systems
American Water was founded in 1886, it is the largest water utility in the United States. Although it is the largest Utility, it wasn't keeping up with the modern times. American Water had been using manual processes for its business practices to process data and each different subsidiary that it owned used different methods in acquiring the data. It wasn't until 2006 when American Water's software system truly showed that extra amount of work needed to actually run the software when the company decided to go public. The company soon implemented an Enterprise Resource Planning (ERP) system, SAP, which was backward compatible, meaning that it could pull the data from the various methods that the different subsidiary had and compile them together as they migrated from one system to another. It was the realization that having a better control and understanding of data can help organize and ensure the quality the data is useful to the company.
American Water as stated in the book has been focusing on data to be clean. As a result the company can report to you information that you need to know about what all is in your water in your area.
Did you Know we have American Water located here in Kentucky?
Yes. It is based out of Lexington Kentucky and we can check the results of the 2013 report