Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
42 Cards in this Set
- Front
- Back
|
the 4 characteristics of data warehousing: |
1) subject oriented: organized by topics 2) integrated: from different sources, stored in a consistent format 3) Time variant: various points in time 4) nonvolatile: users can't change the data once entered into the data warehouse |
|
|
Enterprise Case Study problems/challenges? |
they wanted a solution that had scalability so it could grow with the company. they had a system that had performance issues with the batch jobs with the synchronization of the updates to the data in many data marts. |
|
|
Enterprise car solution? |
to build one enterprise DW for the tri brands of Enterprise, Alamo and National Car rental so the corporation could have an enterprise-view of the rental company |
|
|
benefits of rental car? |
allowed them to gather more info, to bring together disparate data bases and to deliver it in a timely fashion so the # of queries to the EDW increased per day. it helped to create ARMS, a solution that allowed the corporation to electronically communicate with the body shop and insurance company with less phone calls |
|
|
Inthe Expedia case study, how did the company convert drivers of departmentalperformance into a scorecard? |
a) Deciding how to measure satisfaction. This required the group to determine which measures in the 20 databases would be useful for demonstrating a customer's level of satisfaction. This became the basis for the scorecards and KPIs. b) Setting the right performance targets. This required the group to determine whether KPI targets had short-term or long-term payoffs. c) Putting data into context. The group had to tie the data to ongoing customer satisfaction projects. |
|
|
Why is customer satisfaction a very important part of Expedia's business? |
Because Expedia.com is an online business, the customer’s shopping experience is critical to Expedia’s revenues.The online shopping experience can make or break an online business. the travel experience is also critical to expedias success |
|
|
Single version of truth |
means decision makers have more dependable data for their decisions, have the same data available to support their decision, see the same results to queries |
|
|
Metadata |
how data are organized, the meaning of the data, and how to use them effectively |
|
|
examples of metadata in microsoft access database: |
- the data type for a variable contained in an access data table - the number of characters (field length) used for Last_Name field in a database - the variable Alcohol is a YES/NO variable - the variable CR_Date represents the Date of a Crash |
|
|
What is parallel processing? |
enables a DW to handle complex queries and scale up to handle many more requests |
|
|
Hub & Spoke Architecture |
- most famous DW architecture today - used to build a scalable and maintainable infrastructure that includes a centralized DW and serval dependent data marts |
|
|
Centralized DW |
similar to hub-and-spoke except there are no dependent data marts instead there is a gigantic EDW that serves the needs for all organizational units |
|
|
Components of what a centralized DW does? |
1) single version of truth in a timely & holistic view of the enterprise 2) provides all users with access to all data in the DW instead of limiting them to data marts 3) reduces the amount of data the technical team has to transfer or change 4) simplifies data mgt and administration |
|
|
Star schema |
the most commonly used and simplest style of dimensional modeling contain a fact table surrounded by and connected to serval dimension tables |
|
|
What does good scalability mean? |
that queries and other data access functions will grow linearly with the size of the warehouse |
|
|
What was the challenge with BP Lubricants? |
as a result of merger activity, BP needs to integrate data held in disparate source systems without the delay of introducing a standardized ERP system |
|
|
What was the proposed solution for BP Lubricants? |
a unified system the system integrates, unifies and stores information from multiple source systems to provide consolidates views for marketing, sales and finance |
|
|
What were the results for BP lubricants with BIGS? |
helped BP identify a multitude of business opportunities to maximize margins and/or manage associated costs. Improved the visibility of consistent, timely data used to assist the business decisions |
|
|
What were the challenges with the state of Michigan? |
struggled to balance budgets and satisfy a wide variety of needs |
|
|
the proposed solution for Michigan? |
a unified system because it operates many kinds of depts. An enterprise warehouse linking employees across depts instead of having a platform for each |
|
|
obtained results for Michigan? |
savings from the operational efficiencies and improvements in the accurate delivery and accounting of benefits |
|
|
What is the closed loop business process? |
1) Strategize 2) plan 3) monitor/analyze 4) act/adjust |
|
|
Parts of a balanced scorecard? |
1) the most popular measurement system 2) translates into a set of actionable initiatives 3) customer perspective is important because dissatisfied customers will eventually hurt the bottom line 4) measurement alone has little use without action |
|
|
Six Sigma |
a performance management methodology aimed at reducing the number of defects in a business process to as close to zero defects per million opportunities as possible |
|
|
Sigma or Sigma symbol |
measures the variability in a process; the number of defects |
|
|
Six sigma is ordinarily utilized in? |
manufacturing, service delivery, management and other business activities that rely on eliminating defects, waste, and quality control problems |
|
|
Six sigma is a simple performance improvement model known as ? |
DMAIC |
|
|
DMAIC performance model |
a closed loop business improvement model that encompasses the steps of defining, measuring, analyzing, improving and controlling a process |
|
|
How did Delta Lloyd Group improve accuracy and efficiency in financial reporting? |
they switched from a manual, spreadsheet-based process to utilizing IBM for their financial reporting in a more automated and accurate way |
|
|
What was the challenge for Delta Lloyd Group? |
the most challenging part of the reporting process is the "last mile" - the stage at which consolidated figures are cited, formatted, and described to form the final text of the report |
|
|
last mile |
the stage at which consolidated figures are cited, formatted, and described to form the final text of the report |
|
|
Why is important for Delta Lloyd Group to comply with industry regulations? |
its a financial service provider in the Netherlands, they must produce reports to fulfill local legal requirements for banking and insurance purposes and also report to meet international requirements |
|
|
What are the main challenges that FEMA faces? |
before FEMA implemented Bureaunet, when there was a disaster, FEMA had 2 floods: 1) water covered land 2) a flood of paper covered their desks |
|
|
How did FEMA improve its inefficient reporting practices? |
Bureaunet software allowed FEMA to select just the info they want to see and get an on screen report or download the data to a spreadsheet. it was the primary reason behind increased speed and relevance of the reports FEMA employees received and could self generate |
|
|
How did Blastrac achieve significant cost saving in reporting and info sharing? |
they switched from a manual expect based approach of reporting to using Tableau software for data visualization and reporting. it allowed them to achieve signifiant cost savings in reporting and info sharing, save thousands of dollars with simplified info sharing and deploy tools to quickly and easily create reports |
|
|
What was the solution for Blastrac? |
Tableau analytics software was used to replace massive spreadsheets that were loaded with data from multiple ERP systems |
|
|
How did Dana-Farber cancer institute use TIBCO Spotfire to enhance info reporting and visualization? |
the automated process was much more effective and efficient than manual spreadsheet based data analysis |
|
|
What were the challenges, solutions and results of Dana-Farber cancer institute? |
the cancer institute usedinformation visualization to better understand cancer vaccine clinical trials,illustrates how the data from many sources along with the great inconsistencyand redundancy inherent in the data registry could be eliminated through theuse of the TIBCO Spotfire computational and visual analysis tool for dataexploration and discovery, and is an excellent example of how data andinformation visualization can be effectively used to explore, make sense of,and communicate the data related to cancer vaccine clinical trials. |
|
|
Why do you think telecommunication companies are among the prime users of information visualization tools? |
typically they have millions of customers, contacting them constantly |
|
|
How did Saudi Telecom use information visualization? |
information visualization software allowed managers to see trends and correct issues before they became problems. The amount of service tickets were reduced. Dundas Dashboards show relevant metrics and KPIs on a soccer field sized wall of monitors |
|
|
What was the approach for IBM congas potential solution? |
the software enabled the rapid creation of integrated, detailed, and sophisticated reports across 60 countries, replacing a large and complex spreadsheet |
|
|
What were the results obtained in the short term for IBM Cognos? |
it produces much more useful and dynamic repots including drill down capabilities. reporting is automated and easily customizable mace is now in a better position to monitor performance and maintain profitability while ensuring that their projects are delivered on time and within budget |
