Business Driven Technology
7th Edition
ISBN: 9781259567322
Author: Paige Baltzan Instructor
Publisher: McGraw-Hill Education
expand_more
expand_more
format_list_bulleted
Concept explainers
Expert Solution & Answer
Chapter 8, Problem 1AYK
Explanation of Solution
Mining the Data Warehouse:
The different types of dimensions that are available in the data warehouse are as follows:
- Slowly changing dimension - The attributes of a dimension would change over a period of time.
- Rapidly changing dimension - This contains the marketing factors which include the demand, taste, preference, and other factors that changes rapidly are stored under rapidly changing dimensions.
- Junk dimension - It contains different and unrelated attributes to avoid large number of foreign keys in the fact table.
- Inferred dimension – Under this dimension, half processed or unprocessed data are stored...
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Write a one-page project proposal for big data analytics on the Google Cloud Platform. Be specific on which dataset you are going to work on and what is the purpose of the project. Forexample, I will do analysis on Cyber data. I should be specific on whichaspect of the Cyber dataset I will explore and what I want to know about the dataset. The proposalshould be novel. That is, I cannot propose something that has already been done or somethingavailable in public domain. Show the source of the data and how you are going to obtain the data.
You don’t need to be specific on which GCP services or tools to use. However, you can still mentionseveral options to choose from cheaper GCP services or tools to use.
Dashboards provide custom displays that summarize data and use statistics specific to each user. Scorecards provide a way of measuring the progress made toward implementing an organization’s strategic plan. Both dashboards and scorecards help manage an organization by providing information in a timely and readable manner.Consider a company that sells home goods online and in retail stores located in all major U. S. cities. Sales during the year average the same for both online and in-store purchases, though weekly and promotional sales vary significantly. The marketing department needs to determine the best way to advertise and promote sales.The analysts for the marketing department have enumerated their needs for designing on-target promotions. They need to know each of the following:Sales per daySales per itemSales per storePromotions offeredWeather in the targeted areasThe company has decided to provide a dashboard for the analysts. They want the dashboard to be…
Urban data design is a company which designs digital products and concepts that make neighborhoods more sustainable and healthier place to live and do business in. This project focuses on a creation of a new app for Urban Data Design for one of their business problems. The app will make it easier for organizers to find the best suited open spaces according to their requirements for a potential event. Make it easier for everyday citizens to find and participate in interesting events happening in open spaces around them.
The purpose is to provide a platform for people in the community to get information regarding open spaces located in their area.
The people will be able to organize events in these open spaces and list them on the app.
People can get information regarding events which are happening in their areas in open spaces.
Provide the community to participate in communal activities to build strong ties and belonging to its community.
These events can promote physical activities…
Chapter 8 Solutions
Business Driven Technology
Ch. 8 - Prob. 1OCCh. 8 - Prob. 2OCCh. 8 - Prob. 3OCCh. 8 - Prob. 1CQCh. 8 - Prob. 2CQCh. 8 - Prob. 3CQCh. 8 - Prob. 4CQCh. 8 - Prob. 1RQCh. 8 - Prob. 2RQCh. 8 - Prob. 3RQ
Ch. 8 - Prob. 4RQCh. 8 - Prob. 5RQCh. 8 - Prob. 6RQCh. 8 - Prob. 7RQCh. 8 - Prob. 8RQCh. 8 - Prob. 3MBDCh. 8 - Prob. 4MBDCh. 8 - Prob. 6MBDCh. 8 - Prob. 7MBDCh. 8 - Prob. 1CCOCh. 8 - How does data visualization use database...Ch. 8 - Prob. 3CCOCh. 8 - What is the correlation between data mining and...Ch. 8 - Prob. 5CCOCh. 8 - Prob. 6CCOCh. 8 - What could happen to a data visualization project...Ch. 8 - Prob. 1AYKCh. 8 - Prob. 2AYKCh. 8 - Prob. 4AYKCh. 8 - Prob. 5AYKCh. 8 - Prob. 7AYKCh. 8 - Prob. 8AYK
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Similar questions
- PLEASE HELP! Introduction Conditional formatting is a powerful tool for data visualization and analysis, as it helps you focus on the most relevant information and enhances the overall clarity of your Excel spreadsheets. Questions In what scenarios would conditional formatting be effective in highlighting critical data? Which specific types of conditional formatting, encompassing both formatting choices and visualization techniques, would be most impactful in enhancing data interpretation? Feel free to provide examples and insights into the strengths and limitations of different approaches.arrow_forwardAnswer questions 10 to 12 based on the following case study. As an analyst, you are assigned to model an Online Shopping Mall App. According to the stakeholders, the process begins when a customer places an order. The order is sent to the Order Processing Department. The staff in the Order Processing Department can be a supervisor or an assembler. Their job is to wrap products based on the orders they view using the app. Then, a staff in the Shipping Department update the order status at the app after delivering the parcel to the customer. 10. What are the most suitable actors for Online Shopping Mall App? i. Customer ii. Order Processing Department Staff iii. Shipping Department Staff. iv. Supervisor v. Assembler vi. Payment Gateway vii. Stakeholders a. i, iii, iv, v, vi b.i, ii, iii, vi c. i, ii, iii, vi, vii d. i, iii, iv, v, vi, vii As an analyst, you are…arrow_forwardAs a member of the campaign team for a mayoral candidate in Raleigh, your job is to gather data on the public perception of your candidate for the purpose of making informed decisions related to the campaign. More specifically, you plan to send out a survey (collecting information on race, religion, gender identity, age bracket, income level, education level, party affiliation, intention to vote for your candidate, etc.) to 4,000 Raleigh citizens in hopes of receiving at least 1,000 responses. In order to keep the responses anonymous, you plan to assign a 5-character code to each individual who receives a survey. In doing so, survey responses will be tied to codes rather than names, ensuring that the data collected is done akin to a blind study. Suppose that, for reasons tied to the software your team uses to process incoming data, you only have access to 6 unique digits: 2-7. Are you able to assign a unique code to each individual receiving the survey?arrow_forward
- - According to a recent report by Gartner, most business users will have access to some sort of self-service BI tool within the next few years; however, Gartner estimates that less than 10 percent of companies will have sufficient data governance practices in place to prevent data inconsistencies across the organization. Why do you think so many companies continue to invest in new analytics tools without implementing governance programs that ensure data consistency? - How important do you think it is for FIMC and other companies offering roadside assistance services to provide customers with access to services via a mobile app? Do you think a mobile app will provide FIMC with a competitive advantage, or is mobile access something that most customers have come to expect?arrow_forwardSentiment analysis is a very effective way to enhance and develop your business using the client feedback data. Using data mining and analytical tools, various behavioral buying patterns of the customers are determined which help companies in identifying their weaknesses and playing on their strengths.You have been appointed as a BA for a project which is an Online Application that applies Data Mining for analysis of user reviews of certain consumer products manufactured by a company. The client is a big multinational organization having more than 5,000 employees and they have a wide range of consumer and household products. Their customer base is large and diversified. The client is interested in Sentiment Analysis from the customers feedback which they give on social media, online surveys, text messages and onsite feedback forms. For an Online Grocery Web Store System:c) Follow the Use Case Specification template to specify 5 use cases identified.e) Identify 3 Business Rules for…arrow_forwardSentiment analysis is a very effective way to enhance and develop your business using the client feedback data. Using data mining and analytical tools, various behavioral buying patterns of the customers are determined which help companies in identifying their weaknesses and playing on their strengths.You have been appointed as a BA for a project which is an Online Application that applies Data Mining for analysis of user reviews of certain consumer products manufactured by a company. The client is a big multinational organization having more than 5,000 employees and they have a wide range of consumer and household products. Their customer base is large and diversified. The client is interested in Sentiment Analysis from the customers feedback which they gi…[12:13 AM, 11/28/2020] Taif: For an Online Grocery Web Store System:a) Specify some challenges of requirement elicitation if you follow the Waterfall Modelb) Specify some challenges of requirement elicitation if you follow the Agile…arrow_forward
- Sentiment analysis is a very effective way to enhance and develop your business using the client feedback data. Using data mining and analytical tools, various behavioral buying patterns of the customers are determined which help companies in identifying their weaknesses and playing on their strengths. You have been appointed as a BA for a project which is an Online Application that applies Data Mining for analysis of user reviews of certain consumer products manufactured by a company. The client is a big multinational organization having more than 5,000 employees and they have a wide range of consumer and household products. Their customer base is large and diversified. The client is interested in Sentiment Analysis from the customers feedback which they give on social media, online surveys, text messages and onsite feedback forms.For the project scenario a) Draw detailed Context Diagram showing all the entities and data flows between themarrow_forwardBackground CD Selections is a chain of 50 music stores located in California. Annual sales last year were $50 million, and they have been growing at about 3-5 percent per year for the past few years. Margaret Mooney, Vice President of Marketing, has recently become both excited by and concerned with the rise of Internet sites selling CDs. The Internet has the potential to enable CD Selections to reach beyond its regional focus and significantly increase sales. However, the Internet also poses a significant threat as Web competitors such as CDnow and Amazon continue to take sales from CD Selections traditional stores. CD Selections currently has a simple web page that provides information about the company and about each of its stores (e.g., map, operating hours, relative size). The System Approval has been given to create a new Internet sales system. A description of the new system is as follows: The Internet sales system will store basic information about the CDs that it can sell over…arrow_forwardwrite on a sheet of paper a topic you are most interested to explore. enumerate at least three ways on how you will look for the information and data needed about the chosen topic. share important information that you would like to probe on the chosen subject. for example, the topic is gender inequality among tvl (technical vocational technology) learners. what are you interested most? is it the difference in quantity of work? is it the difference in quality of work? alternatively, is it the type of ppe (personal protective equipment)?arrow_forward
- Computer Science You have been asked to help one of the data analysts who is working in your team. The data analyst has all the right data in place and upon exploring the data, you find out that there are lots of missing values. What are some of the ways you would use to address this problem? Please explain the merits and demerits of each approach? Do you think that the strategies you are using to tackle this issue are related to the ways you will use to feed your data to a specific algorithm to build a statistical/machine learning/deep learning model? Why or Why not?arrow_forward76644 An intern in a marketing research organization found out that there was a high correlation between the sale of newspapers and the rise in temperature. Thus, he concluded that rise in the temperature caused increase in sale of newspaper. Identify two mistakes that he made during this analysis. What would have been your next course of action if you found such a correlation? What is the term used to denote such a correlation? Which data analysis technique would you use to establish cause and effect relationship?arrow_forwardSenior management has asked you to research a Big Data topic. They would like you to choose one of the two options described below. You should write this as a case in which you present the business problem that needs to be addressed, then you present at least two Big Data solutions for solving the business problem, and conclude with which one you would recommend and why. Topics to research, along with questions to consider include: Option 1 - Data Analytics use in various industries – (industries could include weather, sports, social media, marketing, financial, politics, farming, medicine, or any other industry that you find interesting to explore.) This analysis should include the following. a. A summary of how data analytics is being used within the industry selected. b. Who, within the industry, is using data analytics? c. What opportunities does data analytics provide that was previous unavailable? d. What threats does using data analytics present? e. What skills are necessary for…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Management Of Information SecurityComputer ScienceISBN:9781337405713Author:WHITMAN, Michael.Publisher:Cengage Learning,
Fundamentals of Information SystemsComputer ScienceISBN:9781337097536Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning
Management Of Information Security
Computer Science
ISBN:9781337405713
Author:WHITMAN, Michael.
Publisher:Cengage Learning,
Fundamentals of Information Systems
Computer Science
ISBN:9781337097536
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning