ISDS Test 2

Teradata, parallel

1976-1979 concept of _______; a database management system for ______ processing with multiple microprocessors targeted for decision support

dimensional, architecture

1996 Ralph Kimball wrote The Data Warehouse Toolkit discussed general-purpose ______ design techniques to improve the data ________ for query-centered decision support systems

closed, operational, strategic, performance, strategy

3 Components of BPM system: Set of integrated ____-loop managment and analytic processes that addresses financial as well as ______ activities Tools for businesses to define _____ goals and then measure and manage _______ against those goals Core set of processes linked to organizational _______

monitoring, analysis, management

3 Layers of information portrayed on dashboards: _______ _______ _______

metric, dashboard, balanced

3 Major categories of business reports: ______ management reports ______-type reports _______ scorecard-type reports

customer, financial, internal, learning, growth

4 Perspectives that BPM suggests to view organizational performance: _______ _______ _______ business processes _______ and ______

Strategize, plan, performance, analytical, interpret, track, differently

4 Phases of the BPM cycle: ______: missions, visions, and objectives are key components of this phase ______: answers "How do we get there" Monitor/Analyze: "How are we doing?"; _______ dashboards, reports, and ______ tools Act/Adjust: leaders ______, collaborate, assess, and ______; "What do we need to do ______?"

ad hoc, discovered, managed, optimized, automated

5 levels of metadata management maturity: ___ ____ _______ _______ _______ _______

analytics, improve

A Better Data Plan: Well-Established TELCOs Leverage Data Warehousing and Analytics to Stay on Top in a Competitive Industry Highly targeted data ______ play an ever more critical role in helping carriers secure or ______ their standing in an increasingly competitive marketplace

customers, costs, pricing, satisfaction, customers, social, loyalty

A Better Data Plan: Well-Established TELCOs Leverage Data Warehousing and Analytics to Stay on Top in a Competitive Industry Main challenges for TELCOs: Retaining ______ Decreasing ______ Fine-tuning ______ models Improving customer _______ Acquiring new _______ Understanding the role of _____ media in customer ______

subject, integrated, time, nonvolatile

A data warehouse is ______-oriented, _______, ______-variant, _______ collection of data in support of management's decision-making process.

Balanced scorecard

A performance management system whose key feature is that it does not rely solely on financial measures of success; has become a generic term that is used to represent virtually every type of scorecard application and implementation but is intended to emphasize a strategic focu

periodically, required

A report is usually a document that contains information organized in a narrative, graphic, and/or tabular form, prepared ______ or on an as-______ (ad hoc) basis, referring to specific time periods, events occurrences, or subjects.

Business report

A written document that contains information regarding business matters

allocation, tangible, intangible

An organization's strategic objectives and key metrics should serve as top-down drivers for the _____ of the organization's _____ and ______ assets

probablity

Analytics Play Role for Saints in Locating, Evaluating Draft Prospects The results will tell the Saints something about those players and their _____ for success in the NFL.

simplified, evaluating, efficient, dangers, helpful, tendencies, unnoticed

Analytics Play Role for Saints in Locating, Evaluating Draft Prospects What's vastly different now is how readily available the information is and how it has _____ the scouting process in _______ draft prospects or of an upcoming opponent This has made it possible for the coaching staff to become more _____, but there are ____ in having so much info available Biggest key - using the info in ways that are _____. For the coaches, it can mean locating ______ or other things that might have once gone unrealized. In scouting draft prospects, the numbers can help them locate prospects like the cornerback who might have gone _______, but all decisions are still made with the eyeballs.

Report

Any communication artifact prepared with the specific intention of conveying info in a presentable form to whoever needs it, whenever and wherever they may need it

financially

As a measurement methodology, BSC is designed to overcome the limitations of systems that are ______ focused.

actions

As a strategic management methodology, BSC enables an organization to align its ____ with its overall strategies.

management, deliver, transparent

BP Lubricants Achieves BIGS Success BIGS: Business Intelligence program A strategic initiative for _______ info and business intelligence Purpose is to _____ globally consistent and _______ management info across functions

balance, measures

BSC ________: The combined set of _____ is supposed to encompass indicators that are financial and nonfinancial, leading and lagging, internal and external, quantitative and qualitative, and both short term and long term.

relational, enterprise wide,

Bill Inmon EDW approach: Top-down development adapts traditional _______ database tools to the development needs of an ______-_____ DW

data mart

Bottom-up approach: building one ____ ____ at a time

holistic, direction

Central to the BSC methodology is a _____ version of a measurement system tied to the strategic ____ of the organization

dependent, all, units, access, data marts, simplify, holistic, data marts

Centralized data warehouse: No ________ data marts Gigantic enterprise DW that serves the needs of _____ organizational ______ Provides users with _____ to all data in the DW instead of limiting them to _____ ______ _______ data management and administration Timely and ______ view of the enterprise to anyone Advises using data warehouses without ____ _____

Web, relational, multidimensional, client, server, real, metadata

Characteristics that enable DW's to be tuned almost exclusively for data access: ____ based ______/______ ____/______: provides easy access for end users _____ time Include _______

objective, end, time, budgets, managing

Critical to successful DW project: Clearly defining business ______ Gathering project support from management ____ users Setting reasonable ____ frames and _____ _______ expectations

generation, decision, process, reporting

Cyclic process of management: Data acquisition leads to information ________ which leads to ______ making which leads to business ______ management Most critical task in cyclic process: _______ (information generation)

action, short

Dashboard visual widgets: Help to highlight the data and exceptions that require ______ Convey a wealth of information to decision makers in a _____ time

range, customizable

Dashboard-type reports present a _____ of performance indicators on one page, with both static/predefined elements and _______ widgets and views.

legacy, external, OLTP, ERP, web

Data Sources: ______ systems ______ data providers ______ or _____ system _____ data

information

Data Visualization: What is portrayed in visualizations is the _______ not the data

business, insight

Data Warehousing: allows ready access to ______ information, and creates business ______

marts, subject, department, single subject

Data ____: usually smaller and focuses on a particular _____ or ______; subset of a data warehouse consisting of ______ _______ area

staging, loaded

Data loading: loaded into ____ area (transformed and cleansed), _______

2010s

Decade Big Data

2000s, plug

Decade Innovative solutions emerged that provided cost savings because they were ____-compatible to legacy data warehouse solutions

1980s, consolidate, sort, problems

Decade islands of data problems; solution led to a distributed data management system which magically pulled data from databases across the organization, bring it all back to the same place, then _____ and _____ it; ______ still existed

1970s

Decade mainframes with data that was locked away in the depths of the files and databases, had to formally request data from data-processing department where it was put on a long waiting list with others

1990s, data warehousing

Decade new approach to islands of data problem; data from those places was copied to another location and ____ ______ was born

operations, trends, changes

Decision makers require concise, dependable information about current ______, ______, and ______.

services, legal, reports, requirements

Delta Lloyd Group Ensures Accuracy and Efficiency in Financial Reporting Financial ______ provider based in the Netherlands Must produce reports to fulfill local ____ requirements for banking and insurance purposes Must provide _____ to meet international _______

mile, formatted

Delta Lloyd Group Ensures Accuracy and Efficiency in Financial Reporting Most challenging part of reporting process "last ____" - the stage at which the consolidated figures are cited, ______, and described to form the final text of the report

retrieval, query, processing, multidimensional

Dimensional modeling: ______-based system Supports high volume _____ access Should be designed in such a way that not only accomodates but boosts the ______ of complex _________ queries

entity relationship

EDW: Employs established database development methodologies and tools such as ______-_______ diagrams

cleanse, load, integral

ETL technologies pull data from many sources, ____ them, and ____ them into a DW. ETL is an _____ process in any datacentric project.

integrated, cleansed

ETL: Purpose: load warehouse with _____ and ______ data

metadata, centrally

ETL: Well designed DW: rules can be stored in a _____ repository and applied to the DW ______

70%

ETL: consumes ____ of time in data-centric project

Large, integrated

Enterprise Data Warehouses: _____ scale DW used across enterprise for decision support ______ of data from many sources into standard format for effective BI and decision support applications

parent, online, shopping, online, travel

Expedia.com's Customer Satisfaction Scorecard Expedia, Inc. is the ____ company to some of the world's leading travel companies It acts as an ____ travel agent for consumers who want to travel Because it is an online business, customer's ______ experience is critical to Expedia's revenues Online shopping experience can make or break an ______ business ______ experience is also critical to Expedia's success

continuous

Heat maps and highlight tables: illustrate the comparison of ______ values across two categories using color

volumes, visualization

Increasing demand for visual analytics coupled with fast-growing data _____ led to exponential growth in highly efficient _______ systems investment.

metrics, problems, operational, resolve

Layers of information found in dashboards: Monitoring - graphical, abstracted data to monitor key performance ______ Analysis - summarized dimensional data to analyze the root cause of ______ Management - detailed ______ data that identify what actions to take to _____ a problem

time

Line graphs: Good for ____ series data

partial, operational

Managers often make decisions with ______ information, at best using _______ systems.

structure, data, pattern, conversion

Metadata: Describe _____ of and some meaning about ______ ______ view: differentiate between different types of metadata Assist in ______ of data and info into knowledge

six sigma

Most companies use ____ _____ as a process improvement methodology that enables them to scrutinize their processes, pinpoint problems, and apply remedies.

operational, fast, manipulating, perspectives, relational, transactions

OLAP operations: Cube: main ________ structure Multidimensional data structure allows _____ analysis of data Capability of efficiently ______ and analyzing data from multiple ________ Arrangement aims to overcome a limitation of ______ databases Better suited for manipulating records that represent a series of _______

2

OLAP operations: Dice: slice on more than ___ dimensions of a data cube

vendors

Over the past 3 to 4 years, the biggest change in the BPM market has been the consolidation of BPM ______.

clarity, brevity, completeness, correctness

Primary characteristics of a good business report include _______, ______, ______, and _________.

BSC

Probably the best-known and most widely used performance management system is the _____.

dimensional

Ralph Kimball Data Mart approach: Bottom-up approach that employs ______ modeling

supplements, tactical, loading

Real time or active data warehousing ______ and expands traditional data warehousing, moving into the realm of operational and ______ decision making by ______ data in real time and providing data to users for active decision making.

architecture, modeling, physical, storage, maintainability

Real-time data warehousing problems: ________ Data ______ ______ database design _____ and scalability _________

affordable

Real-time data warehousing: future advancements needed to make this a reality with _______ price tage

real time, zero latency, active

Real-time data warehousing: near ____ ____ data warehousing, _____ ______ warehousing, _____ data warehousing

quick, interactive, predictive, prescriptive

Reasons for recent emergence of visual analytics: More BI and analytics vendors are becoming aware that their customers require _____ and preferably _______ visualizations, not just for their normal reporting systems, but also to illustrate ______ and ______ decision-making information.

trends, problems, reduced, relevant

Saudi Telecom Company Excels with Information Visualization Information visualization software allowed managers to see ____ and correct issues before they became ______ Amount of service tickets was ______ Dundas Dashboards show _____ metrics and KPI's on a soccer field-sized wall of monitors

two, three, enhanced, size

Scatter plots and Bubble Charts: Good for illustrating relationships between ____ or _____ variables Bubble charts are an _____ variant of a scatter plot because they add a dimension via the ____ of the dot

vendor, tool

Self-Service Reporting Environment Saves Millions For Corporate Customers A multi-_____, multi-_____ solution was implemented

value, costs

Self-Service Reporting Environment Saves Millions For Corporate Customers The key to winning new customers and retaining existing ones was to provide ____-added services to the clients so they can efficiently analyze _____ and other options to quickly instate optimal purchase agreements.

management, measurement, defects

Six Sigma: Not used much as a performance _______ or _______ methodology Aimed at reducing the number of ______ in a business process to as close to zero DPMO as possible

DMAIC

Six sigma uses ______, a closed-loop business improvement model that involves the steps of defining, measuring, analyzing, improving, and controlling a process

centralized, normalized

Snowflake Schema: Represented by _______ fact tables Dimensions are _______ into multiple related tables

Data Warehouse

Specially constructed data repository where data are organized so that they can be easily accessed by end users for several applications

facts, descriptive, decision, foreign, supports

Star Schema: Fact table: Contains lots of rows that correspond to observed _____ and external links Contains ______ attributes needed to perform ______ analysis and query reporting ______ keys used to link to dimension tables Primarily addresses what the DW _____ for decision analysis

large, complex, loyalty

Starwood Hotels & Resorts Manages Hotel Profitability With Data Warehousing Business operations are very ____ and _____ Operates a customer ______ program

Oracle

Study showed ______ as most common platform for hosting data warehouses

hub and spoke, bus, centralized

Study showed ________, ________, and _______ architectures as top 3

benefits

Substantial performance _____ can be gained by integrating BSC and Six Sigma.

web, big, open, saas, cloud

The Future of Data Warehousing: Sourcing: ____, Social media, and ____ Data _____ Source Software _____ _____ Computing

financial

The drawbacks of using _____ data as the core of a performance measurement system are well known.

communication, focus, resources

The gap between strategy and execution is found in the broad areas of ______,alignment, _____ , and ______.

strategy

The primary difference between BI and BPM is that BPM is always _____ driven.

10, 42, expand

Thing's Go Better with Coke's Data Warehouse Results of EDW implementation: Immediate ____ percent increase in sales ____ percent decline in costs while improving the efficiency of the salespeople who service the machines HCCBC intends to ____ the use of the active DW to cover all the vending machines in Japan

Middleware

Tools that enable access to DW

hierarchial

Tree maps: Good for showing ______ information, such as when illustrating the hierarchy chart of employees in a company

data warehouse, large

Two-Tier Architecture: DSS engine physically runs on same hardware platform as the ____ _____ Performance problems for ____ data warehouses that work with data-intensive applications

precomputation, processing, preprocessing, MOLAP, ROLAP

Variations of OLAP: ROLAP: does not require _______ and ______ of info MOLAP: requires _______ of info in the cube; stores this data in an optimized multidimensional array storage HOLAP: allows storing part of data in ______ and part in _______

reduced, redundant

When data is managed correctly as an enterprise asset, ETL efforts are ____ and _____ data are completely eliminated.

1993; data warehousing

Year Bill Inmon wrote Building the Data Warehouse; Father of ____ ______

2006, 2007

Year Microsoft jumped in data warehousing market; Year Oracle joined

1988

Year term business data warehouse introduced as a key component of business information systems

pie

You shouldn't use ___ charts if the number of categories is very large.

operational, tactical

_____ and _____ plans address the question "How do we get to the future?

DMAIC

closed loop performance improvement model that involves the following steps: define, measure, analyze, improve, and control

performance measurement system

considered a subset of the overall performance management system

Oper marts

created when operational data needs to be analyzed multidimensionally

Teradata

made worlds first relational database management system in 1983

Data visualization

more appropriately called "information visualization"; use of visual representations to explore, make sense of, and communicate data; closely related to the fields of information graphics, scientific visualization, and statistical graphics

main, faster, recovery

In-Memory processing technology: Keeps data permanently in _____ memory Direct access makes processing of data orders of magnitude _____ than traditional method Need for sophisticated data _____ strategies

orientation, display

OLAP operations: Pivot: Change the dimensional ________ of a report or ad hoc query-page _______

dimensions

OLAP operations: Roll-up: Computing all of the data relationships for one or more _______

multidimensional, single

OLAP operations: Slice: Subset of a _________ array corresponding to a _____ value set for one of the dimensions not in the subset

up, down

OLAP operations: Drill Down/Up: User navigates among levels of data ranging from the most summarized (____) to the most detailed (____)

OLAP, OLTP, OLTP, OLAP

OLTP and OLAP rely heavily on each other: ____ uses the data captures by _____ ______ automates the business processes that are managed by decisions supported by ______

Six Sigma

process improvement methodology that enables companies to scrutinize their processes, pinpoint problems, and apply remedies

performance dashboard

provide visual displays of important information that is consolidated and arranged on a single screen so that information can be digested at a single glance and easily drilled in and further explored

Business performance measurement (BPM)

refers to the business processes, methodologies, metrics, and technologies used by enterprises to measure, monitor, and manage business performance

Performance scorecards

visual displays used to chart progress against strategic and tactical goals and targets

policies, procedure, logical, access, physical, internal

4 Main areas of effective security in a DW: Establishing effective corporate and security ______ and _______ Implementing _____ security procedures and techniques to restrict ______ Limiting _____ access to the data center environment Establishing effective _____ control review process with an emphasis on security and privacy

inside, outside, ETL, reporting, intranet

Business report: Foundation of these reports is various sources of data coming from both _____ and ______ the organization Creation of these reports involves _____ procedures in coordination with a DW and then using one or more ______ tools Typically accessed via corporate ________

components, transparent, combine, through, timely, recent, customized

Common characteristics of dashboards and other info visuals: Visual ______ to highlight the data and exceptions that require action _______ to the user meaning they require minimal training and extremely easy to use ______ data from a variety of systems into a single, summarized, unified view of the business Enable drill-down or drill-______ to underlying data sources or reports, providing more detail about the underlying comparative and evaluative context Present a dynamic, real world view with _____ data refreshses, enabling the end user to stay up to date with any ____ changes in the business Require little to no _____ coding to implement, deploy, and maintain

little, strategic, decide, act

The overall impact of the planning and reporting practices of the average company is that management has ____ time to review results from a ______ perspective, _____ what should be done differently, and ___ on the revised plans

enterprise, decision, management

Business reporting (also called _______ reporting) is an essential part of the larger drive toward improved managerial ______ making and organizational knowledge ________.

data, analytics, efficiency, time

In-Database processing technology: ____ and _____ that work off the data live within the same environment Increases _______ of computationally intensive analytics procedures Significant performance where _____ is of the essence

hub and spoke, scalable, maintainable, centralized, dependent, customization, holistic

____ _____ _____ architecture: Most famous Focused on building a ______ and _______ infrastructure that includes a _______ DW and several _______ data marts Allows for easy _________ of user interfaces and reports Lacks the _______ enterprise view and may lead to data redundancy and data latency

Geographic maps

_____ ______: Typically used together with other charts and graphs, as opposed to by themselves, and show postal codes, country names, latitude/longitude, and etc.

Strategy

_____ answers the question "Where do we want to go in the future?"

Basic

_____ chart types include: line, bar, and pie chart.

team

_____ skills are needed to develop and implement a DW

Monitoring

______ addresses the question of "How are we doing?

Histograms

______ are like bar charts, except they depict frequency distributions.

Independent, costly, difficult, data marts

______ data marts: simplest and least ______ May have inconsistent data definitions and different dimensions and measures making it ______ to analyze data across ____ _____

Bullet

______ graphs: show progress toward a goal

Specialized

_______ charts are often derived from the basic charts as exceptional cases.

Access, indexing, retrieval

_______ modeling: needed to determine how data are to be retrieved from a DW Assists in physical definition of the warehouse by helping to define which data require ______ Indicate whether dependent data marts are needed to facilitate info ______

Comprehensive

_________ database: EDW to support all decision analysis

ODS

a type of customer-information-file database that is often used as a staging area for a DW

statistics, sources, analytics, useful, widespread, film, stats

Analytics Play Role for Saints in Locating, Evaluating Draft Prospects Since introducing the ICE system in 2010, and marrying it with _______ from STATS, Inc., the Saints have been looking to other ______ for information and statistics Team has embraced ______ and is willing to consider and compile any data is believes is ______ In recent years, the use of analytics has become more ______ in football thanks to subscription sites that break down _____ and produce ____ that once only used to be available to teams

merger, integrate, delay, adaptive, unifies, consolidated

BP Lubricants Achieves BIGS Success Challenges and Proposed solution: Had been involved in ______ activity which meant it had data held in disparate source systems Need to _____ data held in disparate source systems without the _____ of introducing a standardized ERP system Kalido: an ______ enterprise data warehousing solution Kalido integrates, ______, and stores info from multiple source systems to provide _______ views for marketing, sales, and finance

maximize, visibility, assist, consistency, transparency, faster, opportunities

BP Lubricants Achieves BIGS Success Obtained Results from BIGS: Helped BP identify a multitude of business opportunities to ______ margins and/or manage associated costs Improved the ______ of consistent, timely data used to _____ the business decisions Improved _______ and _______ of business data ______ and more flexible reporting Greater ability to respond intelligently to new business ________

BI

BPM is an outgrowth of _____, and it incorporates many of its technologies, applications, and techniques.

corporate, enterprise, strategic

BPM: also known as: ______ performance management _______ performance management _______ enterprise management

strategy, closed, performance

BPM: Considered to be a type of BI tool/technique _____ focused Encompasses a _____-loop set of processes that link strategy to execution in order to optimize business _______

BSC, Six Sigma, BSC, Six Sigma

BSC vs. Six Sigma: _____ focused on improving overall strategy, whereas ______ is focused on improving processes ______ gives a longer term view of the organization, whereas ______ gives a snapshot at a particular point in time of its operational effectiveness

perspective, bottom, action

Balanced Scorecard (BSC): The customer _______ is important in the balanced scorecard methodology because dissatisfied customers will eventually hurt the ______ line Measurement alone has little use without _______

integrated, perspectives

Balanced scorecard reports present an ______ view of a company's health and include financial, customer, business process, and learning/growth _______

nominal, numerical, comparative

Bar charts: Useful in displaying _____ data or _____ data that splits nicely into different categories so you can quickly see _____ results and trends within your data

analysis, consolidated, processing, servers, quickly, production, simplified

DW direct benefits: End users can perform extensive _____ in numerous ways ______ view of corporate data Permits info ______ to be relieved from costly operational systems into low cost _____ Many more end user info requests processed more _____ Enhanced system performance, frees ______ processing Data access ______

real, pulling, relational, tagged

Data Integration: Enterprise information integration: Promises ____ time data integration Mechanism for ______ data from source systems to satisfy a request for info Use predefined metadata to make integrated data appear ______ to end user XML allows data to be ______

source, functionality, OLTP,

Data Integration: Enterprise application integration: Pushing data from ______ systems into the DW Sharing _____ rather than data Use SOA coarse-grained services that are well defined and documented Facilitate data acquisition directly into a near-real-time DW or to deliver decisions to _____ systems

performance, insight, decision, structure, stable, improvements, communication

Data Warehouse Administrator: Should be familiar with high ______ software, hardware, and networking technologies Possess solid business ______ Be familiar with ______ making processes to suitably design and maintain DW _______ Keep the existing requirements and capabilities of the DW ______ while simultaneously providing flexibility for rapid ________ Posses excellent _______ skills

amount, quickly, grow, users, queries

Data Warehouses: Main Issues of Scalability: ______ of data in DW How _____ DW is expected to _____ Number of concurrent ______ Complexity of user _____

patient, efficiency, profits

Data Warehousing Helps MultiCare Save More Lives Role of data warehousing in healthcare systems: Case: Improving _____ care Improve ______ and ______

multiple, truth, unified, septicemia

Data Warehousing Helps MultiCare Save More Lives Use of data warehousing to improve health outcomes: Organized and simplified data from ______ sources across the continuum of care Adaptive Data Warehouse became a single source of ____ that _____ decision makers across functions Addressed serious problem of ______ by defining a standard of care for septic patients

change, update, discarded, new

Data Warehousing: Nonvolatile: Users cannot _____ or ______ data Obsolete data are _____ and changes are recorded as _____ data

forecasting, comparisons, temporal, time

Data Warehousing: Time Variant: Detect trends,deviations, and long-term relationships for _______ and ________ _______ quality Data for analysis from multiple sources contain multiple _____ points

Integrated, sources, measure

Data Warehousing: _________: Place data from many different ______ into a consistent format Must deal with naming conflicts and discrepancies among units of _______

access, federation, capture, ETL

Data integration comprises 3 major processes: Data _____, Data ______, and Change ______ When these 3 processes are correctly implemented, data can be accessed and made accessible to an array of ____ and analysis tools and data warehousing environments

bus, linked, middleware, consistency, enterprise, satisfactory

Data mart ____ architecture: Individual marts are _____ to each other via ________ Better chance of maintaining data ______ across the _______ Performance of analysis may not be ________

Independent, data warehouse, unit, department, EDW

Data mart: ________: lower cost, scaled down version of a ____ _____ Designed for a strategic business ______ or _______ Its source is not ______

Dependent, quality, single, end, data

Data mart: ________: subset created directly from data warehouse Consistent data model and _____ data Support _____ enterprise-wide data model Ensures ____ user is viewing same ____ accessed by all other data warehouse users

one, subset, expensive, supplement

Data marts: Contain data on ____ topic Can be a replication of a ____ of data in the DW Less ______ solution that can be replaced by or can ______ a DW Can be independent of or dependent on a DW

users, information

Data visualization techniques and tools make the ____ of business analytics and business intelligence systems better _____ consumers.

accessing, integrating, organzing

Data warehousing cuts through this obstacle by _______, ______, and _______ key operational data in a form that is consistent, reliable, timely, and readily available, wherever and whenever needed.

Subject, detailed, decision, why, comprehensive

Data warehousing: ______-oriented: Data organized by ______ subject such as sales, containing only info relevant to ______ support Enables users to determine not only how their business is performing but _____. Provides more _______ view of the organization.

1980s, data access

Decade of data warehousing innovation; Red Brick emerged as a visionary software company discussing how to improve _____ _____

execution

Decades of research highlight the gap between strategy and ______.

spreadsheet, automated, accurate

Delta Lloyd Group Ensures Accuracy and Efficiency in Financial Reporting Switched from a manual, _______-based process to utilizing IBM Cognos Financial Statement Reporting for their financial reporting in a more ______ and _____ way

predictive, what happened, what, why, analytics

Difference between information visualization and visual analytics: Visual analytics is the combination of visualization and ______ analytics. Information visualization is aimed at answering "_____ _____" and "____ is happening" and is closely associated with business intelligence Visual analytics is aimed at answering "____ is it happening", "what is more likely to happen", and is usually associated with business _______.

efficiently, current, centralized, improve, residents

EDW Helps Connect State Agencies in Michigan Like a business, a state government can operate more ______ and make better decisions if it has access to _____ data in a ______ EDW State officials can use the EDW to ______ efficiency and better serve the state's ______

massive, unified, complex

EDW Helps Connect State Agencies in Michigan Michigans EDW: _______ , _______, and ________

budgets, departments, unified, employees, delivery

EDW Helps Connect State Agencies in Michigan Struggles to balance ____ and satisfy a wide variety of needs Operates many kinds of ______ so it benefited from a _____ source of information Solution - Enterprise electronic DW linking _____ across departments instead of developing separate BI/DW platforms for each business area or state agency Results - Financial benefits and improvements in the accurate ______ and accounting of benefits

transformation

ETL: ________ by using rules or lookup tables or by combining data with other data

mix, needs, top, bottom, research, reality

Effective performance management/measurement: Should ____ past, present, and future Should balance the ____ of shareholders, employees, partners, suppliers, and other stakeholders Performance measures should start at the ___ and flow to the _____ Should involve targets that are based on _____ and _____ rather than arbitrary

satisfaction, satisfaction, basis, targets, context, satisfaction

Expedia.com's Customer Satisfaction Scorecard How company converted drivers of departmental performance into scorecard: Deciding how to measure ______. This required the group to determine which measures in the 20 databases would be useful for demonstrating a customer's level of _______. Became the ______ for the scorecards and KPI's Setting the right performance ______. This required the group to determine whether KPI targets had short-term or long-term payoffs. Putting data into ______. The group had to tie the data to ongoing customer ______ projects.

integrate, changing, existing, needed, global, supplement, replace

Federated data warehouse: Uses all possible means to ______ analytical resources from multiple sources to meet ______ needs or business conditions ______ decision support structures left in place and data accessed from them as ______ Supported by middleware vendors - offer users a ____ view of distributed data sources Work well to ______ data warehouses not ____ them

wanted, spreadsheet, increased, relevance

Flood of Paper Ends at FEMA BureauNet software allowed the FEMA staff to select just the information they ____ to see and get an on-screen report or download the data as a _______ Software was the primary reason behind the _____ speed and ______ of the reports FEMA employees received and could self-generate

two, paper

Flood of Paper Ends at FEMA Main challenges: Before FEMA implemented BureauNet, when the President declared a natural disaster, FEMA got ___ floods at once First the water covered the land and next a flood of ____ covered their desks

timelines, task, network, relationships

Gantt charts and PERT charts: Good at illustrating project ______ and _____ dependencies PERT charts (also called _____ diagrams) show precedence ______ among the project activities/tasks

develops, maintains

Hosted data warehouses: Another firm ____ and _____ DW

creation, detailed, reports, spreadsheet

IBM Cognos Express Helps Mace for Faster and Better Business Reporting IBM Cognos software enabled the rapid _____ of integrated, _____ and sophisticated ______ across 60 countries, replacing a large and complex _______

dynamic, customizable, monitor, profitability, time

IBM Cognos Express Helps Mace for Faster and Better Business Reporting Produces much more useful and ____ reports, including drill-down capabilities Reporting is automated and easily _______ Mace is now in a better position to ______ performance and maintain ______ while ensuring that their projects are delivered on ____ and within budget

objectives, connections

In BSC, strategy maps provide a way to formally represent an organization's strategic ______ and the causal _____ among them

timeliness, activity, hotels, truth, dependable, support

Isle of Capri Casinos Is Winning With Enterprise Data Warehouse: Benefits of EDW: Several benefits related to the ______ and detail of the data that became available Connects data about casino _____ with data about customers use of _____ and efforts by Isle's hosts Single version of the _______ means decision makers have more ______ data for their decisions, have the same data available to _______ their decisions, see the same results to queries.

competition, time lag, katrina

Isle of Capri Casinos Is Winning With Enterprise Data Warehouse: Business Challenges/Opportunities Isle was facing: _________ ______ _____ in data Hurricane ________

respond, offerings, understanding, high, real, behavior

Isle of Capri Casinos Is Winning With Enterprise Data Warehouse: EDW: Tells Isle what customers _____ to so casino can adapt their _______ Lets Isle deepen its ______ of customers so it can efficiently give them more of the kinds of entertainment they are looking for The most important service of the EDW was it provided Isle with a vast collection of _____ volume, _____ time transaction data about its customers and their _______.

core, intelligence, management

Isle of Capri Casinos Is Winning With Enterprise Data Warehouse: Process to realize EDW: Teradata provided the _____ solution IBM Cognos provided expertise in business ________ Hired a _______ team to help managers understand the potential of using detailed, up to the minute data

records, delivers, quality, transformations, storage, publication, assurance

Main components of a Business Reporting system: Online transaction processing system that ______ transactions Data supply that takes recorded events and transactions and _____ them to the reporting system ETL component that ensures ______ and performs necessary ______ prior to loading the data into a data store Data _____ itself (such as the DW) Business ______ converts the data into the reporting outputs _______ distributes or hosts the reports for end users _______ provides a quality control check on the reports and their dissemination

outcome, service, indicators

Metric management reports involve ______-oriented metrics based on _____ level agreements and/or key performance ______

mission, vision, objectives, direction

Most important part of BPM implementation: Strategy: Process of identifying and stating the organization's ______, ______, and ______. Provides an overall ______ to the enterprise

recent, staging, updated, short term, multiple, volatile

Operational Data Stores: Provides fairly _____ form of customer information file Used as interim ______ area for a DW ______ throughout course of business operations Used for ____-____ decisions Consolidates data from _____ source systems and provides near-real-time, integrated view of _____, current data

mission, goals, implementation, goals, objectives

Performance Management System: Purpose: Identify and articulate the strategic _____, ______, and objectives of an organization Assist managers in tracking the ________ of business strategy by comparing actual results against these strategic ______ and _______

management, measurement, BPM, platforms

Performance dashboards are common components of: Performance _______ systems Performance _______ systems ____ software suites BI ________

goals, feedback, progress, BPM

Performance measurement system: Comprises systematic methods of setting business _____ together with periodic ______ reports that indicate _____ against goals Key and necessary element of the ____ process

strategies, strategies

Performance measures need to be derived from the corporate and business unit _____ and from an analysis of the key business processes required to achieve those ______.

graphic, Napoleon's

Perhaps the most notable information____ of the past was developed by Charles J. Minard, who graphically portrayed the losses suffered by _______ army in the Russian campaign of 1812.

proportions

Pie Charts: Should be used for depicting ______, for example, to show relative proportions of majors declared by college students in their sophomore year

Data Warehouse

Pool of data to support decision making; also a repository of current and historical data of potential interest to managers throughout the organization

expensive, learning, IT

Purchase data transformation tools or build the transformation process: Tools are ______ Tools may have long _____ curve Difficult to measure how the ___ organization is doing until it has learned to use the data transformation tools

loading, available, EDW

Real-time data warehousing: process of _____ and providing data via the DW as they come ______; evolved from ____ concept

prime, visualization, constantly

Saudi Telecom Company Excels with Information Visualization Telecommunication companies such as Saudi Telecom are among the ____ users of information ______ tools Telecom companies typically have millions of customer, contacting them _______

platform, dynamic, plan, track, analyze, forecasts, directly, IT

Self-Service Reporting Environment Saves Millions For Corporate Customers Solution and Implementation: Implemented Information Builders WebFOCUS business intelligence ______ as the foundation of a ______ customer self-service BI environment Dashboard-driven expense-management application helps more than 800 external clients and more than 200 internal employees to _____, _____,______, and budget their travel expenses more efficiently Generate more precise _______ Approach was to create an online BI system that allows clients to access information ______, so they won't have to rely on ____ department to run reports for them

management, loyalty, planning, leisure

Self-Service Reporting Environment Saves Millions For Corporate Customers Travel and Transport, Inc. is the sixth largest travel ______ company in the US Has extensive experience in multiple verticals, including travel management, _____ solutions programs, meeting and incentive ______, and _____ travel services

crowded, costs, purchase

Self-Service Reporting Environment Saves Millions For Corporate Customers Travel industry is a very _____ marketplace With travel arrangements often made on an ad hoc basis, customers find it difficult to analyze ____ or instate optimal _____ agreements

multidimensional, snowflake

Snowflake Schema: logical arrangement of tables in _________ database in a way that the entity-relationship diagram resembles a _______

central, dimension

Star Schema: Contains a ______ fact table surrounded by and connected to several ______ tables

fast, simplicity, ease

Star Schema: Designed to provide ____ query-response time, _____, and ____ of maintenance for read-only database structures

classification, describe, analyzed, rows, numerical

Star Schema: Dimension tables: Contain _______ and aggregation info about the central fact rows Contain attributes that _____ the data contained within the fact table Address how data will be ______ and summarized One-to-many relationship with _____ Slice and dice _____ values in fact table to address requirements of ad hoc info needed

denormalized

Star Schema: Dimensions are ________ with each dimension being represented by a single table

increased, slow, rates, revenues

Starwood Hotels & Resorts Manages Hotel Profitability With Data Warehousing Challenges: Company grew significantly Greatly _____ the need for business critical info about the hotels and their customers Obtaining reports from the central reservation system was _____ With delays in obtaining data, managers had difficulty adjusting the _____ to increase ______

real time, access, profitably, service

Starwood Hotels & Resorts Manages Hotel Profitability With Data Warehousing Proposed solution: Oracle Exadata system Provides near ____ ____ information Results: Managers have accelereated ______ to data so they can do same-day or next-day analyses as well as additional reporting tools Company now operates more efficiently and ______, and customer ______ has improved

security, privacy

The ______ and _______ of data and information are critical issues for a DW professional.

operational, transactions, users, access, premier, marketing, quicker

Starwood Hotels & Resorts Manages Hotel Profitability With Data Warehousing With data warehousing, can quickly prepare _____ reports With real time feeds, _______ can be posted immediately to the DW and _____ can access the changes faster than before The accelerated ______ to data improves profits because hotel managers can make sure rooms are available for _____ customers and improve the ability to manage room occupancy rates ______ campaigns also have become more efficient as managers analyze results ______

effective, manual

TIBCO Spotfire Provides Dana-Farber Cancer Institute with Unprecedented Insight into Cancer Vaccine Clinical Trials Automated process was much more ____ and efficient than _____, spreadsheet-based data analysis

information, redundancy, exploration, explore, sense, communicate

TIBCO Spotfire Provides Dana-Farber Cancer Institute with Unprecedented Insight into Cancer Vaccine Clinical Trials Used _______ visualization to better understand cancer vaccine clinical trials Illustrates how the data from many sources along with the great inconsistency and _____ inherent in the data registry could be eliminated through the use of the TIBCO Spotfire computational and visual analysis tool for data _______ and discovery Excellent example of how data and information visualization can be effectively used to _____, make ____ of, and ______ the data related to cancer vaccine clinical trials

visualization, reporting, cost, sharing, simplified, create

Tableau Saves Blastrac Thousands of Dollars with Simplified Information Sharing Switched from a manual, excel-based approach of reporting to using Tableau software for data ______ and ______ Tableau allowed Blastrac to achieve significant ____ savings in reporting and information _____, save thousands of dollars with _____ information sharing, and deploy tools to quickly and easily ____ reports

spreadsheets

Tableau Saves Blastrac Thousands of Dollars with Simplified Information Sharing Tableau analytics software was used to replace massive ______ that were loaded with data from multiple ERP systems

columnar, size

The Future of Data Warehousing: Infrastructure: ______: stores data tables as sections of columns of data rather than as rows of data; Significant storage ____ optimization

historical, profitable, cost, sales, revenues, selling, alerts

Thing's Go Better with Coke's Data Warehouse HCCBC hired Teradata Corp. to implement a DW and analytical software to collect _____ data and near real time data wirelessly transmitted from each vending machine Needed a way to ensure each vending machine was ______ EDW led to immense ____ savings, increase in _____, and higher _____ The data tells the company what is _____, and it sends _____ when a product sells out, a customer is short-changed, or a machine is malfunctioning.

acquisition, separation, constraints, data marts

Three-Tier Architecture: Data and software for data _______ Advantage: _______ of functions of DW, eliminates resource _______ and makes it possible to easily create ____ _____

three, ease, platform

Web-based data warehousing: _____-tiered _____ of access ______ independence

sponsorship, expectations, politically, available, transactional, technology, user, internal, external, overlapping, performance, capacity, over, alerts

When developing a successful DW, consider various risks and avoid following issues: Starting with the wrong _______ chain Setting ______ that you cannot meet Engaging in ______ naive behavior Loading the warehouse with info just because it is ______ Believing that data warehousing database design is the same as _______ database design Choosing a data warehouse manager who is ______ oriented rather than _____ oriented Focusing on traditional ______ record-oriented data and ignoring the value of _______ data and of text, images, and, perhaps sound and video Delivering data with _______ and confusing definitions Believing promises of _______, ______, and scalability Believing that your problems are _____ when the DW is up and running Focusing on ad hoc data mining and periodic reporting instead of ______