Business Driven Technology Study Set 5

Business

Quiz 8 :

Accessing Organisational Information - Data Warehouse

Quiz 8 :

Accessing Organisational Information - Data Warehouse

Question Type
search
arrow
Mining the Data Warehouse According to a Merrill Lynch survey in 2006, business intelligence software and data- mining tools were at the top of CIOs' technology spending list. Following are a few examples of how companies are using data warehousing and data-mining tools to gain valuable business intelligence. Ben Jerry's These days, when we all scream for ice cream, Ben Jerry's cuts through the din by using integrated query, reporting, and online analytical processing technology from BI software vendor Business Objects. Through an Oracle database and with BI from Business Objects, Ben Jerry's tracks the ingredients and life of each pint. If a consumer calls in with a complaint, the consumer affairs staff matches the pint with which supplier's milk, eggs, cherries, or whatever did not meet the organization's near-obsession with quality. The BI tools let Ben Jerry's officials access, analyze, and act on customer information collected by the sales, finance, purchasing, and quality-assurance departments. The company can determine what milk customers prefer in the making of the ice cream. The technology helped Ben Jerry's track more than 12,500 consumer contacts in 2005. The information ranged from comments about the ingredients used in ice cream to queries about social causes supported by the company. California Pizza Kitchen California Pizza Kitchen (CPK) is a leading casual dining chain in the premium pizza segment with a recognized consumer brand and an established, loyal customer base. Founded in 1985, there are currently more than 130 full-service restaurants in more than 26 states, the District of Columbia, and five foreign countries. Before implementing its BI tool, Cognos, CPK used spreadsheets to plan and track its financial statements and line items. The finance team had difficulty managing the volumes of data, complex calculations, and constant changes to the spreadsheets. It took several weeks of two people working full-time to obtain one version of the financial statements and future forecast. In addition, the team was limited by the software's inability to link cells and calculations across multiple spreadsheets, so updating other areas of corporate records became a time-consuming task. With Cognos, quarterly forecasting cycles have been reduced from eight days to two days. The finance team can now spend more time reviewing the results rather than collecting and entering the data. Noodles Company Noodles Company has more than 70 restaurants throughout Colorado, Illinois, Maryland, Michigan, Minnesota, Texas, Utah, Virginia, and Wisconsin. The company recently purchased Cognos BI tools to help implement reporting standards and communicate real-time operational information to field management throughout the United States. Before implementing the first phase of the Cognos solution, IT and finance professionals spent days compiling report requests from numerous departments including sales and marketing, human resources, and real estate. Since completing phase one, operational Cognos reports are being accessed on a daily basis through the Noodles Company website. This provides users with a single, 360-degree view of the business and consistent reporting throughout the enterprise. Noodles Company users benefit from the flexible query and reporting capabilities, allowing them to see patterns in the data to leverage new business opportunities. Cognos tools can pull information directly from a broad array of relational, operational, and other systems. Illustrate why 100 percent accurate and complete information is impossible for Noodles Company to obtain.
Free
Essay
Answer:

Answer:

It is impossible for N C to provide 100 percent accurate and complete information for the following reasons:
• It cannot provide 100 percent exact and thorough information.
• Faultless and unadulterated information is costly.
• Realizing faultless information is almost unmanageable.
• The more comprehensive and perfect a group wants to get its data, the more it charges.
The balance is the trade-off between data completeness and accurateness. Accurate data means the one which is exact, whereas complete information means there are no breaks and gaps. Most establishments define a sufficiently high percentage to make good conclusions at a realistic cost, such as 65% complete and 85% accurate.

Tags
Choose question tag
close menu
arrow
Mining the Data Warehouse According to a Merrill Lynch survey in 2006, business intelligence software and data- mining tools were at the top of CIOs' technology spending list. Following are a few examples of how companies are using data warehousing and data-mining tools to gain valuable business intelligence. Ben Jerry's These days, when we all scream for ice cream, Ben Jerry's cuts through the din by using integrated query, reporting, and online analytical processing technology from BI software vendor Business Objects. Through an Oracle database and with BI from Business Objects, Ben Jerry's tracks the ingredients and life of each pint. If a consumer calls in with a complaint, the consumer affairs staff matches the pint with which supplier's milk, eggs, cherries, or whatever did not meet the organization's near-obsession with quality. The BI tools let Ben Jerry's officials access, analyze, and act on customer information collected by the sales, finance, purchasing, and quality-assurance departments. The company can determine what milk customers prefer in the making of the ice cream. The technology helped Ben Jerry's track more than 12,500 consumer contacts in 2005. The information ranged from comments about the ingredients used in ice cream to queries about social causes supported by the company. California Pizza Kitchen California Pizza Kitchen (CPK) is a leading casual dining chain in the premium pizza segment with a recognized consumer brand and an established, loyal customer base. Founded in 1985, there are currently more than 130 full-service restaurants in more than 26 states, the District of Columbia, and five foreign countries. Before implementing its BI tool, Cognos, CPK used spreadsheets to plan and track its financial statements and line items. The finance team had difficulty managing the volumes of data, complex calculations, and constant changes to the spreadsheets. It took several weeks of two people working full-time to obtain one version of the financial statements and future forecast. In addition, the team was limited by the software's inability to link cells and calculations across multiple spreadsheets, so updating other areas of corporate records became a time-consuming task. With Cognos, quarterly forecasting cycles have been reduced from eight days to two days. The finance team can now spend more time reviewing the results rather than collecting and entering the data. Noodles Company Noodles Company has more than 70 restaurants throughout Colorado, Illinois, Maryland, Michigan, Minnesota, Texas, Utah, Virginia, and Wisconsin. The company recently purchased Cognos BI tools to help implement reporting standards and communicate real-time operational information to field management throughout the United States. Before implementing the first phase of the Cognos solution, IT and finance professionals spent days compiling report requests from numerous departments including sales and marketing, human resources, and real estate. Since completing phase one, operational Cognos reports are being accessed on a daily basis through the Noodles Company website. This provides users with a single, 360-degree view of the business and consistent reporting throughout the enterprise. Noodles Company users benefit from the flexible query and reporting capabilities, allowing them to see patterns in the data to leverage new business opportunities. Cognos tools can pull information directly from a broad array of relational, operational, and other systems. Explain how Ben Jerry's is using business intelligence tools to remain successful and competitive in a saturated market.
Free
Essay
Answer:

Answer:

B J keeps a track of the elements, components and life in a data storeroom. If a customer calls has a grievance, the customer relationship staff ties up the pint with which dealer's mile, cherries or eggs, etc. This did not encounter the establishment's near-obsession with superiority.
This tool assists B J to get official access and helps them to analyse and act on the information. This data is collected by the departments like finance, sales and purchasing.

Tags
Choose question tag
close menu
arrow
List the reasons a business would want to display information in a graphic or visual format.
Free
Essay
Answer:

Answer:

A business would want to display information in a graphic or visual format, primarily to convey multiple points of information in one or a few simple images. Graphics and other images allow data that could otherwise occupy a large spreadsheet, to be shown in a much more direct manner. In this way, data visualization allows for the detection of correlations that could have otherwise not been detected from looking at the raw data. Another reason a business would want to display information in a visual format is to enhance its marketing capabilities. Potential customers would often times rather see the data pertinent to their decision-making process in the form of a graphic or chart, rather than a cumbersome data table. Finally, a visual format can allow a business to present information in an aesthetically pleasing manner. This provides the business with the option of using a wide arsenal of graphic design tools to present the information it wants to convey in a myriad of ways.

Tags
Choose question tag
close menu
arrow
Explain how a marketing department could use data visualization tools to help with the release of a new product.
Essay
Answer:
Tags
Choose question tag
close menu
arrow
Assess how Hotels.com is using BI to identify trends and change associated business processes.
Essay
Answer:
Tags
Choose question tag
close menu
arrow
Describe how a business could use a business intelligence digital dashboard to gain an understanding of how the business is operating.
Essay
Answer:
Tags
Choose question tag
close menu
arrow
Mining the Data Warehouse According to a Merrill Lynch survey in 2006, business intelligence software and data- mining tools were at the top of CIOs' technology spending list. Following are a few examples of how companies are using data warehousing and data-mining tools to gain valuable business intelligence. Ben Jerry's These days, when we all scream for ice cream, Ben Jerry's cuts through the din by using integrated query, reporting, and online analytical processing technology from BI software vendor Business Objects. Through an Oracle database and with BI from Business Objects, Ben Jerry's tracks the ingredients and life of each pint. If a consumer calls in with a complaint, the consumer affairs staff matches the pint with which supplier's milk, eggs, cherries, or whatever did not meet the organization's near-obsession with quality. The BI tools let Ben Jerry's officials access, analyze, and act on customer information collected by the sales, finance, purchasing, and quality-assurance departments. The company can determine what milk customers prefer in the making of the ice cream. The technology helped Ben Jerry's track more than 12,500 consumer contacts in 2005. The information ranged from comments about the ingredients used in ice cream to queries about social causes supported by the company. California Pizza Kitchen California Pizza Kitchen (CPK) is a leading casual dining chain in the premium pizza segment with a recognized consumer brand and an established, loyal customer base. Founded in 1985, there are currently more than 130 full-service restaurants in more than 26 states, the District of Columbia, and five foreign countries. Before implementing its BI tool, Cognos, CPK used spreadsheets to plan and track its financial statements and line items. The finance team had difficulty managing the volumes of data, complex calculations, and constant changes to the spreadsheets. It took several weeks of two people working full-time to obtain one version of the financial statements and future forecast. In addition, the team was limited by the software's inability to link cells and calculations across multiple spreadsheets, so updating other areas of corporate records became a time-consuming task. With Cognos, quarterly forecasting cycles have been reduced from eight days to two days. The finance team can now spend more time reviewing the results rather than collecting and entering the data. Noodles Company Noodles Company has more than 70 restaurants throughout Colorado, Illinois, Maryland, Michigan, Minnesota, Texas, Utah, Virginia, and Wisconsin. The company recently purchased Cognos BI tools to help implement reporting standards and communicate real-time operational information to field management throughout the United States. Before implementing the first phase of the Cognos solution, IT and finance professionals spent days compiling report requests from numerous departments including sales and marketing, human resources, and real estate. Since completing phase one, operational Cognos reports are being accessed on a daily basis through the Noodles Company website. This provides users with a single, 360-degree view of the business and consistent reporting throughout the enterprise. Noodles Company users benefit from the flexible query and reporting capabilities, allowing them to see patterns in the data to leverage new business opportunities. Cognos tools can pull information directly from a broad array of relational, operational, and other systems. Identify why information cleansing is critical to California Pizza Kitchen's business intelligence tool's success.
Essay
Answer:
Tags
Choose question tag
close menu
arrow
Mining the Data Warehouse According to a Merrill Lynch survey in 2006, business intelligence software and data- mining tools were at the top of CIOs' technology spending list. Following are a few examples of how companies are using data warehousing and data-mining tools to gain valuable business intelligence. Ben Jerry's These days, when we all scream for ice cream, Ben Jerry's cuts through the din by using integrated query, reporting, and online analytical processing technology from BI software vendor Business Objects. Through an Oracle database and with BI from Business Objects, Ben Jerry's tracks the ingredients and life of each pint. If a consumer calls in with a complaint, the consumer affairs staff matches the pint with which supplier's milk, eggs, cherries, or whatever did not meet the organization's near-obsession with quality. The BI tools let Ben Jerry's officials access, analyze, and act on customer information collected by the sales, finance, purchasing, and quality-assurance departments. The company can determine what milk customers prefer in the making of the ice cream. The technology helped Ben Jerry's track more than 12,500 consumer contacts in 2005. The information ranged from comments about the ingredients used in ice cream to queries about social causes supported by the company. California Pizza Kitchen California Pizza Kitchen (CPK) is a leading casual dining chain in the premium pizza segment with a recognized consumer brand and an established, loyal customer base. Founded in 1985, there are currently more than 130 full-service restaurants in more than 26 states, the District of Columbia, and five foreign countries. Before implementing its BI tool, Cognos, CPK used spreadsheets to plan and track its financial statements and line items. The finance team had difficulty managing the volumes of data, complex calculations, and constant changes to the spreadsheets. It took several weeks of two people working full-time to obtain one version of the financial statements and future forecast. In addition, the team was limited by the software's inability to link cells and calculations across multiple spreadsheets, so updating other areas of corporate records became a time-consuming task. With Cognos, quarterly forecasting cycles have been reduced from eight days to two days. The finance team can now spend more time reviewing the results rather than collecting and entering the data. Noodles Company Noodles Company has more than 70 restaurants throughout Colorado, Illinois, Maryland, Michigan, Minnesota, Texas, Utah, Virginia, and Wisconsin. The company recently purchased Cognos BI tools to help implement reporting standards and communicate real-time operational information to field management throughout the United States. Before implementing the first phase of the Cognos solution, IT and finance professionals spent days compiling report requests from numerous departments including sales and marketing, human resources, and real estate. Since completing phase one, operational Cognos reports are being accessed on a daily basis through the Noodles Company website. This provides users with a single, 360-degree view of the business and consistent reporting throughout the enterprise. Noodles Company users benefit from the flexible query and reporting capabilities, allowing them to see patterns in the data to leverage new business opportunities. Cognos tools can pull information directly from a broad array of relational, operational, and other systems. Describe how each of the companies above is using BI to gain a competitive advantage.
Essay
Answer:
Tags
Choose question tag
close menu