Data Analysis

Data Analysis When moving data from a source to a warehouse, which integration method is considered modern? A.) ELT B.) EIT C.) ETL D.) EIS ANS: ELT Most large corporations are overwhelmingly interested in which "V" of big data information? A.) Volume B.) Variety C.) Value D.) Velocity ANS: Variety According to the CRISP-DM hierarchal model, at which level would a differentiation occur such as deciding whether to clean categorical or numerical values? A.) Phases B.) Specialized Tasks C.) Process Instances D.) Generic Tasks ANS: Specialized tasks According to Scott Berinato's article titled "Visualizations That Really Work," which of the following is NOT one of the four types of visual communication? A.) Decision Trees B.) Idea Generation C.) Visual Discovery D.) Everyday Dataviz ANS: Decision trees According to "You May Not Need Big Data After All", which is NOT one of the four practices companies follow when they have a culture of evidence-based decision making? A) Establish multiple forms of performance data to ensure reliability B) Give decision makers real-time feedback C) Update business rules in response to facts D) Coach employees who make decisions often ANS: Establish multiple forms of performance data to ensure reliability According to "The Quick and Dirty on Data Visualization" by Nancy Duarte, which of the following SHOULD be used to captivate the audience? A.) Crazy Colors B.) Extra Labels C.) Scales D.) Fancy Effects ANS: Scales According to "Banking on the Cloud", what is not an advantage to using a private-cloud infrastructure? A.) Reducing risk to the business B.) Allows for increased complexity C.) The uniform structure of the infrastructure D.) Faster update times ANS: Allows for increased complexity According to "How 'Big Data' is Different", which of the following is NOT how organizations taking advantage of big data differ from those using traditional data analysis environments? A.) They pay attention to data flows as opposed to stocks B.) They rely on data scientists rather than data analysts C.) They're moving analytics into the IT Function D.) They're moving analytics into core business, operational and production functions ANS: They're moving analytics into the IT Function According to the article, "Analytics: The Real World Use of Big Data," what is the top business driven outcome of big data initiatives? A: Employee collaboration B: Customer-centric outcomes C: Risk/financial management D: Operational optimization ANS: Customer-centric outcomes According to "Connecting People Investments and Business Outcomes at Lowe's" by Cedric T. Coco, which step is NOT involved in designing a Value Link? A.) Discussing competition B.) Establishing buy in C.) Building behind the firewall D.) Evolving the model ANS: Discussing competition Which of the following is not one of the three types of Big Data? A. Structured B. Semi-Structured C. Quarter-Structured D. Unstructured ANS: Quarter-structured Which of these statements about traditional IT and big data analytics is NOT true? a) Traditional IT projects optimize supply chain performance b) Analytics improves upon optimization through prediction c) Big data analytics changes how customers think about data d) Employees basing decisions on data is a sign of analytical success ANS: Big data analytics changes how customers think about data According to Shawn Callahan, which of the following is NOT a form of story work? A.) Story telling B.) Story spotting C.) Story triggering D.) Story listening ANS: Story spotting As the BI market changes, which of the following is no longer a primary objective of the new technologies? A. transitioning towards predictive models showing what will happen B. providing information on what happened in one specific segment of business alone C. focusing on how various parts of an organization work together to produce an outcome D. illustrating the big picture so that leaders can make informed decisions ANS: Providing information on what happened in one specific segment of business alone Which of the following is NOT a question that is posed when discussing data visualization methodology? A. How do we choose what we visualize? B. How do we represent data quality? C. How do we compare different data sets? D. How do we visualize metadata? ANS: How do we compare different data sets? 1.) Which of the following is not a hallmark of a positive business intelligence culture A.) Treat data as a core Asset B.) Use findings to change operations C.) Have a deep understanding of various information systems D.) Be open to new ideas ANS: Have a deep understanding of various information systems Which of the following is an example of structured Big Data? A. PDF files B. Customer account numbers C. HTML or email files D. Images or videos ANS: Customer account numbers Which of the following is NOT a step in the BI Process A. Ingestion B. Planning C. Delivery D. Analysis ANS: Planning According to the article "Analytics: The Real World Use of Big Data," which of the following is NOT encompassed upon developing an enterprise-wide big data blueprint? a) The scope b) The strategy and requirements for big data within an organization c) An alignment between users and IT d) A detailed understanding of the enterprise's intended implementation of big data ANS: A detailed understanding of the enterprise's intended implementation of big data 1.)Which of the following is NOT part of the Business Intelligence Balancing Act. A.) Adapt B.) Anticipate C.) Activate D.) Assimilate ANS: Activate In "Connecting People Investments and Business Outcomes at Lowe's" by Cedric T. Coco, Lowe's used an organizational approach to data sharing and follow-up. Which was the reasoning behind adopting this method? A.) So they could allow individual business units within the company to choose their own focus. B.) It allowed the time to educate the organization and individual business units on how to use the data and enhance control. C.) So that each business unit had time to tailor and mature the cha ANS: It allowed the time to educate the organization and individual business units on how to use the data and enhance control. Which of the following is a key difference between "Big Data" and "Analytics? A) Density B) Volume C) Diversity D) Speed ANS: Volume Which of the following is NOT one of the phases presented in the CRISP-DM reference model? A.) Data understanding B.) Data preparation C.) Modeling D.) Data mining ANS: Data mining 1. Which of the following is NOT a component of BI analytics. a) Behaviors b) Values c) Outcomes d) Liabilities ANS: Liabilities According to "Why IT Fumbles Analytics" by Donald A. Marchand and Joe Peppard, why are most companies failing to find worthwhile success through investing in data scientists and IT tools? A.) Companies incorrectly treat big data projects the same as they would other IT projects B.) It is too difficult and expensive for companies to invest in big data IT which requires the restructuring of an entire supply chain C.) Instead of focusing on how companies should explore new data and information, com ANS: Companies incorrectly treat big data projects the same as they would other IT projects Which of the following is NOT an element of exploratory data? a) prototyping b) iterating c) documenting d) building hypothesis ANS: Documenting Approximately what percentage of companies have moved workloads to public IT-as-a-service infrastructure platforms? A. 5-10% B. 15-20% C. 25-30% D. 35-40% ANS: 15-20% According to "Banking on the Cloud" what did NOT help with the switch to a private cloud? a. Easy access for software engineers to test and improve the system. b. incentivizing moving work to the cloud. c. Setting up teams to focus and cooperate on specific parts of the business. d. Integrating complex systems into the core of the business. ANS: Integrating complex systems into the core of the business. SQL vs No-SQL ANS: SQL - Data warehouses - Only extract specific information and deletes the rest - Sequence Q language No-SQL - Data lakes - Modern, incorporates "variety" - Can save information to use for different purposes Shrinkage rate decreases based on ANS: How engaged employees are Manager satisfaction affects ANS: Perception and attentiveness of employees Manager engagement has the ANS: Highest level of effect on engagement Designing value linkage ANS: 1. Establish buy in 2. Discovery process 3. Building behind the firewall 4. Identifying performance themes with executive buy-in 5. Cascading results and taking action 6. Evolving the model Excel vs Access ANS: Excel - 1 worksheet - 1 million cells Access - Databases (multiple related tables) - Can exceed 1 million cells - SQL What is DBMS used for? ANS: Purchasing, customers, orders, and inventory - can put into multiple locations and then let the department use the data how they need to - Use SQL code to sort into different functions Databases must be ANS: - Subject oriented - Integrated - Time variant - Non-volatile Define non-volatile ANS: Connects one data set to another data set What is normalization? ANS: - Tearing a data set apart - Storing data in its smallest pieces What is denormalization? ANS: Combining small pieces of data to make a report What are the 4 principles of data management? ANS: 1. Organization 2. Placement 3. Democratization ("menu" of data values to choose from) 4. Infrastructure (e.g. data lakes