Loading presentation...

Present Remotely

Send the link below via email or IM


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.


Foundations of Business

No description

Brooke Borchers

on 27 March 2015

Comments (0)

Please log in to add your comment.

Report abuse

Transcript of Foundations of Business

Foundations of Business
Intelligence: Databases and
Information Management

Learning Objectives
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?
Team 2
How would online analytical processing (OLAP) be used by a product manager?
Team 4
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.
Big Data
Explosion of Data
Web Traffic, E-ail Messages, Social Media
Better than Traditional & Small Data
Larger Quanitities
Patterns & Differences
New Insights
New Technology
Big Data
"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.
Team 1
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?
Chapter 6
Team 5
Team 6
Team 7
Team 8
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
Team 1:
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.

Team 5:

Why was the participation of business users so important? If they didn't play this role, what would have happened?

Team 6:

How did implementing a data warehouse help American Water move toward a more centralized organization?

Team 7:

Give some examples of problems that would have occured at American Water if its data were not "clean".

Team 8:

How would American Waters data warehouse improve operations and management decision making?

Case Study Update
The Globe and Mail
Previous System:
Not Easily Accessible
Hindered Decision Making
Scattered Data
Security Problems
Marketing & Advertisment
The Globe and Mail
Technical Staff
Standard Company-Wide Format
Establish Procedures
Provide Tools
Prevent Errors
Boost Efficiency
Educate Employees
Better Decisions
Marketing Campaigns
Example in the Book p.201
Product Manager
Region Sales
Forecasted Sales

Top-rated zoo with over 1.2 million attendees every year
Non-profit with an annual budget of $26 million
Senior management
management had little understanding of the daily business within the zoo
Four legacy point of sale system
Galaxy POS & IBM and BrightStar Partners
Data mining
focuses on the hidden relationships.
The Cincinnati Zoo & Botancial Garden
Weather Forecasts
Rainy Days
Hot Days
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"
Harvard- Unemployment
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/
Data Mining
"OLAP can be used for data mining or the discovery of previously undiscerned relationships between data items"
OLAP Cubes
Method for Storing Data
Advanced Analysis
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.
Data Cleansing
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.
Figure 6.14
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
Cloud storage
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
Full transcript