access agenda select lessons the day of the presentation is the primary criterion for selection...

Databases

X.1

DATABASES &

DATA WAREHOUSES

Access to a Gold Mine of Information

“The real value will come from getting the right information to the right people, at the right time, and giving those people the tools to find the meaning in it.” Declaration of Integration

Abbie Lundbergeditor-in-chief CIO

Aawwww, Rubbish! “Business intelligence tools (Excel, SPSS) are only as good as the

data that goes into them; faulty data leads to ill-informed decisions. The ramifications range from ticked-off customers, to misled investors, to testy regulators.”

► “Executives can face jail time under Sarbanes-Oxley if they don’t have financial data in order.”

► “Our marketing effectiveness leads to our sales effectiveness, which leads to our service effectiveness. Data quality is the key to success. If you don’t have quality data, that whole chain breaks down.”

X.2

Information Week:Business Innovation

Powered by Technology

Chuck Scoggins, VP Marketing, Hilton Hotels

Aawwww, Rubbish!

“The ultimate goal of data quality improvement is to catch errors the point of entry or, even better, to prevent errors from occurring at all.”

“Reliable data starts at the beginning…. As long as you are fixing things on the back end, you are not correcting the problem.”

Philip Russom Senior Manager of ResearchData Warehousing Institute

Rick WhitingInformation Week

X.2

ACCESS PROJECTS “What’s really great about databases and DBMSs is that the

concepts are the same whether you’re using a personal DBMSs package or a large mainframe DBMS package.”

“...once you learn database and DBMS concepts while using a personal DBMS package (like MS ACCESS), you can apply your knowledge directly to business environments where other DBMS packages may be used.” Haag.p94

Team Projects use ACCESS to demonstrate fundamental concepts: Data Definition: tables (fields, properties, keys) Project A Application Generators: forms (controls) Projects B, C, D Data Manipulation: sorting , filters & queries Projects E, F

X.2

Use Access as an Alternative…. “Access gives them a robust database engine that does not lock into a specific technology.” 1.3

“Your job is to get work done, not build computer programs. Access provides an easy way to get started …with a user interface that will be familiar to anyone who has used Microsoft Office.” 2.3

Access is inexpensive, and most people catch on quickly….Your company probably owns several copies of Access. 2.4-5

Access is a workable solution. 3.3 Stonyfield Farms & CSS

TechRepublic

A-2b X.2

AccessProject A

tables, properties

AccessProjects B, C, Dforms & controls

AccessProjects E, F

filter, sort, query

shared information

decentralized computing

radiating

intelligence

capturingreliability

conveyingaccess

creating

analysis

cradling

relevance

cradling

communicatingaccess

DBMS process data (reliability)

information (relevance) knowledge (access & analysis)

Access Projects demonstrate the

DBMS subsystems

of a relational database

Select Access ProjectsChoice: order CIO.1 presentations (Rx Build)

Tentativedates

Access ProjectCIO Team

935 1040 1145

MA: Data Definition(2.2) (cradling : relevance)B: Application Generators(3.1) (capturing : reliably)

WC: Application Generators (capturing : reliably)

D: Application Generators (capturing : reliably)

F E: Data Manipulation (creating : analysis)

F: Data Manipulation (creating : analysis)

SPR17

BRING

FLASH DRIVE

FRIDAY

&

SELECT

DATES

DATA forProject is in Chapter folder

Synthesis & Evaluationof DBMS procedures: outline of

text integrating concepts & screens

PROCEDURES fromMS step-by-step handout

CONCEPTS & TEMPLATES from

PowerPoint & handouts

Application &

Analysis(ALL 3)

CIO case

Presentation focusing on Analysis, Synthesis & Evaluation

contributes to Comprehension

Application &

Analysis

Hard limit:20 minutes. # slides depends on content & use.

Text in MS chapters illustrates how to

apply, synthesize & evaluate data procedures &

concepts

See samples of prior

presentations

copy to flash-drive from P:

after select projects

ACCESS Projects: Structure & Process

►Should do“Print Screens” into PPT as do

project

Emphasize Course

Concepts(refer HO)

ASSIGNMENT: Work with team on ACCESS project. Emphasize course concepts to

explain why the procedures are important in: meeting the MIS challenge performing the 5Cs, processing data into information

then knowledge, data sharing and decentralized

computing that support decision making and innovation

building CIS (TPS), MIS (dashboards), DSS, WSS

creating information partnerships, virtual – learning organizations that are timeless & locationless

These exercises are essential to the synthesis of concepts, frameworks and ideas into a new whole that changes the brain real learning (Bloom Hierarchy of Learning Objectives; WSJ 19Jan07 “Thinking Can Change the Brain”)

This requires reviewing Information Age, IT Systems, IT Strategies PowerPoints and using those concepts, frameworks and ideas to analyze and evaluate the ACCESS procedures.

Seinfeld car rental:databases support all 5Cs

take reservation capture forms

hold reservation cradle tables

availability of cars create query

presentation communicate & convey report

10

Cluster diagram: access performs 5Cs &

supports IT systems

Project F: Knowledge – Access & Analysis

*** Uncheck “read only box” in properties (right click on file for properties), then Apply, OK

*** Security Warning: Enable content

*** Handout

1. Access 2010: Chapter 8 “Create Queries”2. GardenCompany08 database

*** Context : p.209

8.2 Creating Queries Manually (Required) pp.216 - 220

8.3 Using Queries to Summarize Data (Optional) pp.221 - 224

8.5 Using Queries to Update Records (Required) pp. 231 – 234

8.6 Using Queries to Delete Records (Required) pp. 235 – 238

Do these pages

Some projects have optional

sections

2. Uncheck “Read Only”

4. click “OK”

3. click “Apply”

1. Right click the file, then click properties

select: enable content

DATABASES &

DATA WAREHOUSES

Access to a Gold Mine of Information

“The real value will come from getting the right information to the right people, at the right time, and giving those people the tools to find the meaning in it.” Declaration of Integration

Abbie Lundberg, CIO Editor

perform(5Cs)

so meetMIS challenge

DATABASES

&

DATA WAREHOUSES

DB-2.a

DBMS(ACCESS)

software that allows KW to perform these

tasks: 5Cscreate

information

ledger

DATA MARTanalyses:cash flow

Tools to perform 5Cs that process data into information and knowledge

so meet the MIS challenge

queries & reports used to create & communicate information from operational database to a special

form of database (ledger) that supports decision making with

MIS & EIS derived from a data warehouse by KW using queries & reports to convey information & create knowledge with DSS (Excel)

journal

capture & cradle data about basic objects & events (journal) with

TPS / CIS using forms & tables

capture cradle data

radiating intelligence X. 8 & 9

Why M4thWill RockYour World!Bus Week What is being done with this data!

“A generation ago, quants turned finance upside down. Now they’re mapping out ad campaigns (Victoria’s Secret) building new businesses from mountains of personal data (using databases).” 54.1

“Math wizzes are the new business elite. They’re turning personal data, trends and online content into math, crunching the numbers and discovering new efficiencies and ways to market (RRA). Before long they’ll have a mathematical model of you (Victoria’s Secret).” 6.1

What IS Victoria’s Secret?

DATABASES

“Databases enable e-tailers “ not only to track individuals’ purchases closely but also to analyze broad buying patterns - - by gender, location and credit-card type, at least, and even internet-

service provider, if an e-mail address is given…(to) create powerful profiles of shoppers and their buying habits” WSJ 1.5

“This wealth of data is used to target marketing efforts...WSJ 1.5

Victoria Secret mails several catalogues a year, featuring largely the same merchandise but with different covers and product

photos. Then it gauges which generates the most sales.” WSJ 3.1-4

Data Mining: Why Math Will Rock

Your World!

Not this!

Mapping out ad campaigns!


DATABASES

“…are useful for answering specific questions about shoppers’ behavior on a site. Do they abandon their shopping carts when

they get to the shipping charges?”

“… Do they quit the site if they have to browse through too many screens to find what they want? Will they spend more if

you show a shirt after they buy a pair of pants, but not if you show a jacket?” WSJ 2.4

Building a mathematical model of you!

Data Mining: Why Math Will Rock

Your World!


“In a recent instance, a lace-up gown was selling well in the site’s top-ten area, but was lagging in the section for gowns, where it was on the second of several screens. By making it more prominent in the gown section, not only were sales increased from the gown section, but also total sales of the gown as well….”

WSJ 3.4

Why M4thWill RockYour World!Bus Week

“Statistics and probability …will become core skills for business people as we grapple with challenges involving large data sets. Winners will know how to use statistics.”

“Statistics and probability …will come in handy whether you’re building financial models at Goldman Sachs or marketing plans at Ford.”

RRA: building financial model to find new

efficiencies to markets

Databases Mission Critical

(X.20 Big Data: Love it or Leave WSJ)

DB-12.b What are Databases & Data Warehouses?finance - accounting example

Extractive Petroleum Industry

SIC 1311

SEC EDGAR accounting DATABASE

S&P Compustat market

DATABASE

Data Mart RRA

Tactical, aimed at meeting an

immediate need

BUSINESS ANALYTICS

convey information & create knowledge efficiencies

in capital marketresource allocation

Math Will Rock You

OLAP (queries, sorting, filtering)

selectively extracts / organizes relevant data for analysis like ledger,

strategic but unfinished concept

create &

cradleinformation

OLTP: JOURNALIZING BASIC EVENTSBUSINESS SYSTEMS

CIS

(TPS)capture

& cradledata

whatis.com

NEW EFFICIENCIES TO MARKETS

E(RRS) R2 (ΔP) = .25

E(HC) R2 (ΔP) = .00JAAF @ NYU

DB-3.a

DBMSC3PO

Physical StructureHow is a relational database organized?

ITBS&A

Access

Why Math Will Rock

Your World

Logical Structure(d e c i s i o n s)

DBMS (Access) is software bridge between user’s logical requests and

physical structure so more easily get to their work

performing the 5Cs whatis.com

Manage big data: RRA

Table

RowsObservations

ColumnsCharacteristics

Data Mart

DB-4.a Figure 3.4

Facility file (table)

Logical Structure of a Relational Database

Part file (table)

is composed of files (tables)


DB-4.a

Fields in columnsrepresent characteristics

Part file (table)

Figure 3.4



is composed of files


DB-4.a

Records (observations) in rows entered by forms

Fields in columnsrepresent characteristics

Part file (table)

Figure 3.4



Primary keys define records & relationships within a file

Foreign keys id

entify re

lationships betw

een fil

es

is composed of files


What benefits / costs are related to databases & data warehouses?

Database

POTENTIAL BENEFITS improved data integrity (reliability: forms, controls,

validation rules) increased user productivity (input: forms;

output: queries/reports) increased security reduced data redundancy (capture once, use many)

POTENTIAL COSTS development training hardware maintenance software

DB-13

CIO CASES

What Are the Critical Success Factors for Databases & Data Warehouses?

►Project has a good sponsor, from the business side not IT

►Project team has the right skill set (CSS : KPMG)

►User involvement is ensured throughout the project

►Expectations are communicated to the users

►A realistic schedule including all necessary tasks

►Tools have been chosen to match the needs of the users

►Users are trained in the way they plan to use the warehouse

DataWarehousing.com

Data WarehouseDB-14

SystemsDevelopment

LifeCycle

Next topic

CriticalSuccessFactors

Assignments:► continue teamwork on Access project / presentation

access agenda select lessons the day of the presentation is the primary criterion for selection...

Documents