Preview

Data Collection a Daily Delight Case Study

Good Essays
Open Document
Open Document
341 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Data Collection a Daily Delight Case Study
[“Data collection a daily delight” - Main business intelligence & data warehouse concepts]

1 | * Internal structured data from more than 40 sources including fund management, lending, human resources and treasury feed into St George’s new data warehouse. | 2 | * The bank uses these data to help decision making in marketing, customer service and the other strategic business areas data from the warehouse is turned into information. * “Customers who change their name or close individual account s and open a joint one, are an example of potential sales leads for home lending and other products.” | 3 | * The data warehouse of St George bank supports the integrated data among different departments * Data from different departments can be accessed freely * Integrated data from the data warehouse is more beneficial and creates more opportunities and BI for all departments (1+1=3) * “Most departments extract what they need from the warehouse using customer relationship management and BI applications without intervention.” * “They have access to all the data, can create their own filters, their own campaigns.” | 5 | * Good data quality is important to St George as the bank relies heavily on event-based marketing (a process that demands accurate data gathering and substantial analytics). * Especially, bank customers’ data is private and sensitive so needs to be maintained accurate all the time. | 6 | * IT department is not just one important department for the success of business intelligence of the bank. * The data fed into the warehouse helps IT department to better service the needs of the bank’s internal customers such as sales and marking departments. * However data warehouse which is managed by IT department act as an important source of the bank’s business intelligence. | 7 | * Technology is just one portion of the business intelligence and the first thing needed for the success of the business intelligence is

You May Also Find These Documents Helpful

  • Powerful Essays

    Ibm 211 Week 3

    • 4383 Words
    • 18 Pages

    IBM® Telecommunications Data Warehouse V8.4 delivers the following capabilities to communication providers: • • • Common customer view: Helps integrate customer identifiers, organizational structures, and account hierarchies across lines of business and functions. Product life cycle management: Helps integrate product management and performance measurement across lines of business and functions. Campaign performance management: Helps improve program planning, tracking of sales and marketing activities, and performance metrics across channels and touch points. Service management: Helps analyze usage, availability, and customer experience of new services, self-service, and new monetary services.…

    • 4383 Words
    • 18 Pages
    Powerful Essays
  • Satisfactory Essays

    This document is a proposal for building a data warehouse architecture that will consolidate and transform data into useful information for the purpose of decision-making and for establishing a new function that offers a broad array of decision support services to all units at ABC Retail Chain Corporation. Executives and decision-makers often need information to analyze the past, describe current circumstances, and anticipate the future. Presently, decision-makers across the Institute rely on hard copy reports or Excel Sheets to provide information. Typically, any request for information is forwarded to the operational areas of the Organization, which provide hard copy reports reflecting the data gathered in their functional area. To analyze and transform data into useful information, decision-makers and their staff have to manually re-enter the non-integrated data into their own mini-systems. This type of operation hinders the ability of decision making and the executives are either drowning in too much data with no option to analyze it or too little data, which means they are back to square one and must request additional information. Often executives receive multiple, conflicting information or information that is based on incomplete assumptions about the types of analysis required.…

    • 641 Words
    • 3 Pages
    Satisfactory Essays
  • Good Essays

    Cis 515week 3

    • 1024 Words
    • 4 Pages

    Barron, K. (2013, May 13). Columbus state university implements data warehouse and business intelligence environment to improve student retention and graduation rates. Retrieved from http://www.oracle.com/us/corporate/press/1946491…

    • 1024 Words
    • 4 Pages
    Good Essays
  • Good Essays

    An active data warehousing, or ADW, is a data warehouse implementation that supports near-time or near-real-time decision making. It is featured by event-driven actions that are triggered by a continuous stream of queries that are generated by people or applications regarding an organization or company against a broad, deep granular set of enterprise data. Continental uses active data warehousing to keep track of their company’s daily progress and performance. Continental’s management team holds an operations meeting every morning to discuss how their company is performing in regards to the data collected by their active data warehousing program. The management team believes, “you can’t manage what you can’t measure,” so they use active data warehousing to keep track of their customers experience while using Continental Airlines. The information that the management team uses to analyze their company in regards to customer relationship is on-time arrival, on-time departures, baggage handling, and other key performance indicators. Continental also uses active data warehousing for revenue management, revenue accounting, flight operations, fraud detection and airline security. Continental restructured their goals to try to become customers “favorite” airline to use. They use their active data warehousing to gain as much information about the company’s performance as well as the customers experience. They use this real-time warehousing program to interpret information that is provided and make changes that will better improve their customers experience and help Continental better suit their business in regards to their customers’ needs.…

    • 1485 Words
    • 6 Pages
    Good Essays
  • Better Essays

    Throughout history technology has influenced the very fabric of business operations. The role of business intelligence in this shift is the implementation and continuous improvement of that technology. This role is ever changing because technology continues to improve. While to some the role of business intelligence seems new and upcoming the usage and practice goes back to the earliest days of industry.…

    • 7414 Words
    • 23 Pages
    Better Essays
  • Powerful Essays

    Pfm Devices

    • 1302 Words
    • 6 Pages

    * The need for a data warehouse could reduce costs by increasing access and visibility to real-time data…

    • 1302 Words
    • 6 Pages
    Powerful Essays
  • Good Essays

    Closing Case Study One

    • 1065 Words
    • 5 Pages

    To redesign Ben & Jerry’s data warehouse the dimensions of information include frozen yogurt, ice cream, merchandise, locations, sales and shipping. This company should track all the different types of ice cream and yogurt flavors. They should also monitor these areas with the highest and lowest sales to make adjustments to save money. There should be information gathered on the merchandise being sold by Ben & Jerry. Ben & Jerry will monitor sales from stores in other locations ensuring the right merchandise is being shipped to the right location. The different dimensions are merchandise and locations.…

    • 1065 Words
    • 5 Pages
    Good Essays
  • Satisfactory Essays

    REI - CAHPTER 4, CASE 2

    • 2464 Words
    • 9 Pages

    A data warehouse is a database used for reporting and data analysis. REI is building a data warehouse so that they will precisely know what the customer uses indoors and outdoors.…

    • 2464 Words
    • 9 Pages
    Satisfactory Essays
  • Powerful Essays

    For Customer Profitability measurement, the tool used personal banking data to measure the profitability that used aggregate information rather than actual data. Then using this data(of…

    • 1564 Words
    • 7 Pages
    Powerful Essays
  • Satisfactory Essays

    dfdfdfdfdfdfdfdfdf

    • 352 Words
    • 2 Pages

    14) Sometimes, large organisations break out ________ from their data warehouses so they can be used for a specific functional area of the organisation like marketing or…

    • 352 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    Data Management can be defined as the ‘administrative process by which the required data is acquired, validated, stored, protected, and processed, and by which its accessibility, reliability, and timeliness is ensured to satisfy the needs of the data users’. The collection of data is vital within any HR department in any organisation and can help to keep them competitive and provide a fair service to their employee’s.…

    • 809 Words
    • 3 Pages
    Good Essays
  • Powerful Essays

    Data Warehousing Failures

    • 5385 Words
    • 22 Pages

    Auto Guys initiated a data warehousing project four years ago but it never achieved full usage. After initial support for the project eroded, management revisited their motives for the warehouse and…

    • 5385 Words
    • 22 Pages
    Powerful Essays
  • Best Essays

    Data Warehousing and Olap

    • 2507 Words
    • 11 Pages

    In the 1990s, as businesses grew more complex, corporation spread globally, and competition became fiercer, business executives became desperate for information to stay competitive and improve the bottom line. Data warehousing technologies have been successfully deployed in many industries: manufacturing (for order shipment and customer support), retail (for user profiling and inventory management), financial services (for claims analysis, risk analysis, credit card analysis, and fraud detection), transportation (for fleet management), telecommunications (for call analysis and fraud detection), utilities (for power usage analysis), and healthcare (for outcomes analysis). This paper presents a roadmap of data warehousing technologies, focusing on the special requirements that data warehouses place on database management systems (DBMSs).…

    • 2507 Words
    • 11 Pages
    Best Essays
  • Powerful Essays

    By 2000, Information Democracy will emerge in forward-thinking enterprises, with Business Intelligence information and applications available broadly to employees, consultants, customers, suppliers, and the public. The key to thriving in a competitive marketplace is staying ahead of the competition. Making sound business decisions based on accurate and current information takes more than intuition. Data analysis, reporting, and query tools can help business users wade through a sea of data to synthesize valuable information from it - today these tools collectively fall into a category called "Business Intelligence."…

    • 1234 Words
    • 5 Pages
    Powerful Essays
  • Satisfactory Essays

    BDW

    • 669 Words
    • 3 Pages

    A Primary Data Warehouse is a central repository of a database of a complete organization. It holds multiple subject areas and very detailed information. A Data Mart is a subset or an aggregation of the data stored to a primary data warehouse. It often holds only one subject area – for example, a specific department, finance or sales. It may hold more summaried data, and is typically smaller than a warehouse because of its employment on a different grain. Figure 1.1 illustrates the difference between data mart and a primary data warehouse. Since the data mart typically holds one subject area, it is much smaller than a primary data warehouse. These data marts can be viewed as small, local data warehouses replicating the part of primary data warehouse which is required by a specific domain or department.…

    • 669 Words
    • 3 Pages
    Satisfactory Essays