Monday 10 November 2014

Starbucks




Information Systems at Starbucks

The Aim of This assignments
This aims to deliver how the systems used by Starbucks are integrated to help deliver the perfect cup of coffee every time a customer visits any Starbucks store worldwide.

Introduction
American global coffee company and coffeehouse chain. Started in Seattle in 1971. Grown to the largest coffeehouse in the world. 20,891 stores in 62 countries.




Company Background
Began operation in Seattle’s Pike Place Market in year 1982
Starbucks entered Malaysia in 1998 by a joint venture with Berjaya Corporation Berhad. The first Starbucks store in Malaysia opened on 17th December 1998 at KL Plaza Kuala Lumpur
Currently Starbucks has 170 stores in Malaysia, among which there are seven stores in Sarawak; five in the Kuching territory and two in Miri.Nowadays, Starbucks has expanded to more than 18000 stores in 62 countries.




Organizational charts


The Is system used at starbucks
Starbucks mainly uses four IS systems:
• Transaction Processing System.
• Supply Chain Management System.
• Decision Support System.
• Customer Relationship Management system
Information System Used by Starbucks

Decision Support System is used to analyze business data.
DSS is the auxiliary decision makers through the data, models and knowledge, human-computer interaction way for semi-structured or unstructured decision-making computer application system.
Starbucks used Online Analytical Processing (OLAP) to do the large-scale data analysis and statistical analysis that as a references to manage for decision making.

Decision Support System
DSS is a computer program application that analyzes business data and presents it so that user can more easily take their business decisions.Starbucks uses a singular DSS system at the parent company in USA: “oracle”. Oracle generates monthly reports on which important decisions are based.Only the parent company has the authority make decisions about products.


Why Oracle
            Starbucks had built its point-of-sale data warehouse on Oracle technology. This foundation, plus the Oracle OLAP option on Oracle Exadata Database Machine, enabled Starbucks to scale and seamlessly migrate its existing Oracle-based data warehouse to Oracle Exadata to expand insight and facilitate decisions, even with explosive growth in data and the user population.


 
Challenges
Create a robust, 24/7-available enterprise data warehouse containing sales, marketing, store management, point of sale, customer loyalty, and supply chain data to drive more informed business decisions at the corporate, regional, and store levels.Improve ability to rapidly analyze and act on customer loyalty, coffee sales, and supply chain information to continue to drive innovation. Ensure scalability to support rapid growth in data volume

Solutions
            Used Oracle Exadata Database Machine and Oracle Business Intelligence Enterprise Edition to create a high-performance enterprise data warehouse and business intelligence environment that provides analysts and managers at the branch, field, and corporate levels with timely and actionable insight into store and product performance, as well as supply chain operations.
            Gained the ability to load and refresh data from all stores in time for US East Coast store openings each morning, completing full loads in just four hours, and ensuring service level agreement compliance.
Enabled the company to load point-of-sale and customer loyalty data daily from 10,000 US stores to the data warehouse and answer most queries such as information on coffee sales, promotions, and product mixes in individual stores in fewer than 10 seconds.
Implemented Oracle Hybrid Columnar Compression to optimize storage area usage and compress 70 terabytes of raw data to approximately 20 terabytes in one case condensing 2 terabytes of table data to 275 gigabytes, an almost 90% footprint reduction.
Utilized Oracle OLAP option, enabling 1-terabyte cubes to be available for fast and sophisticated analytics.
Developed a front-end dashboard of key business indicators that enables 10,000 users including store and corporate managers to gain rapid visibility into store-level sales and operational data.
Increased product analysts’ insight into customer preferences to facilitate strategic development and product launches.
Reduced by hours the time that store managers spend on weekly reports, while simultaneously expanding insight and improving decision-making across thousands of stores.

            Used Oracle Partitioning to optimize data storage manageability and cost efficiency.


Oracle Product and Services by starbucks
Oracle OLAP is a world class multidimensional analytic engine embedded in Oracle Database 12c. Oracle OLAP cubes deliver sophisticated calculations using simple SQL queries - producing results with speed of thought response times. This outstanding query performance may be leveraged transparently when deploying OLAP cubes as materialized views – enhancing the performance of summary queries against detail relational tables. Because Oracle OLAP is embedded in Oracle Database 12c, it allows centralized management of data and business rules in a secure, scalable and enterprise-ready platform.
Oracle OLAP makes it easy to produce analytic measures, including time-series calculations, financial models, forecasts, allocations, regressions, and more. Hundreds of analytic functions can be easily combined in custom functions to solve nearly any analytic calculation requirement. Oracle OLAP cubes are represented using a star schema design: dimension views form a constellation around the cube (or fact) view. This standard representation of OLAP data makes it easy for any reporting and analysis tool or application - including sophisticated business intelligence solutions, SQL-based development tools and Microsoft Excel - to leverage the power of Oracle OLAP in a simple and productive way.


With Oracle OLAP you can:
  • Easily define a multidimensional model with advanced analytic calculations
  • Productively deliver rich analytics to any reporting and analysis tool using simple SQL
  • Transparently improve summary queries against tables using cube-based materialized views
  • Combine OLAP data with any other data in your Oracle Database - including spatial, data mining, XML, documents and more
  • Leverage your existing Oracle Database expertise and software investment    

Oracle Exadata Database Machine
The Oracle Exadata Database Machine is engineered to be the highest performing and most available platform for running the Oracle Database. Exadata is a modern architecture featuring scale-out industry-standard database servers, scale-out intelligent storage servers, and an extremely high speed InfiniBand internal fabric that connects all servers and storage.  Unique software algorithms in Exadata implement database intelligence in storage, PCI based flash, and InfiniBand networking to deliver higher performance and capacity at lower costs than other platforms.  Exadata runs all types of database workloads including Online Transaction Processing (OLTP), Data Warehousing (DW) and consolidation of mixed workloads. Simple and fast to implement, the Exadata Database Machine powers and protects your most important databases and is the ideal foundation for a consolidated database cloud.
  • Database Machine Benefits
  1. Best Data Warehouse platform: Accelerate data warehouse query performance by up to a factor of 10x or more, and run more queries concurrently for faster access to business-critical information.
  2. Best OLTP platform:  Accelerate performance of OLTP oriented workloads through a combination of large physical flash, ultra high-speed flash compression, and smart flash caching algorithms which can provide millions of I/Os per second.
  3. Best Consolidation platform: Replace isolated special-purpose system with a consolidated platform delivering leading performance and scalability for all database applications. Exadata has the unique ability to transparently prioritize requests as they flow from database servers, through network adapters and network switches, to storage, and back.


Oracle Business Intelligence Applications
Oracle Business Intelligence (BI) Applications are complete, prebuilt BI solutions that deliver intuitive, role-based intelligence for everyone in an organization from front line employees to senior management that enable better decisions, actions, and business processes. Designed for heterogeneous environments, these solutions enable organizations to gain insight from a range of data sources and applications including Siebel, Oracle E-Business Suite, PeopleSoft, and third party systems such as SAP

      Oracle BI Applications are built on the Oracle BI Suite Enterprise Edition, a comprehensive, innovative, and leading BI platform. This enables organizations to realize the value of a packaged BI Application, such as rapid deployment, lower TCO, and built-in best practices, while also being able to very easily extend those solutions to meet their specific needs, or build completely custom BI applications, all on one common BI architecture.
  • Oracle financial analytics (OFA)
  • Oracle HR analytics (OHRA)
  • Oracle marketing analytics (OMA)
  • Oracle vertical (industry specific) analytics
  • Oracle sales analytics (OSA)
  • Oracle service analytics (OSEA)
  • Oracle supply chain analytics (OSCA)
   A word from Starbucks Coffee Company
"    Our Oracle Exadata-based database warehouse and Oracle Business Intelligence environment deliver detailed insight into point-of-sale data that allows us to innovate and offer our customers better services." – Mike Manzano, Vice President, Analytics and Insight, Starbucks Coffee Company.


Recommendations
Improve in decision support system 
-use such as WebEx webOffices - communication driven
-use webFocus - data driven
-use captaris workflow - document driven


Conclusion
In conclusion Starbucks has come a long way from its initial systems that were ineffective and resulted in increased costs. However for Starbucks there is still a long way to go if it wants to exploit the IS technology that is already in the market. Starbucks main problem is its size, but this can be countered through employing a uniform IS System Organization wide.
            Starbucks have achieved their goals successfully to become the top five of fast food industry in the global market. Gain the higher of profit margin. Increase the reputation. Expand highly fast its business by opening retail stores around the worldwide. Decision-making level and quality of Starbucks have been improved. Starbucks' end-users and IS specialists can be easier to take their business decision for the future plan.






35 comments:

  1. Hi Database security, Having trouble to apply. The text is said that (The following email address is already used by a candidate included in the database: robbingolden1972@gmail.com.)

    ReplyDelete
  2. Hi Database security, Having trouble to apply. (Starbucks)The text is said that (The following email address is already used by a candidate included in the database: robbingolden1972@gmail.com.)

    ReplyDelete
  3. Visit our card page. Sign in to your Starbucks account, go to My Cards and select the Card you wish to view the balance on. From the Starbucks Mobile app for iPhone®: Select "Pay" and you will see your balance in the top left corner.

    You can't check the balance on a Starbucks gift card using the app, but you can easily check the balance of a gift card online.


    starbucksgiftcardbalance


    Starbucks Gift Card Tips: Check Your Starbucks Gift Card Balance You can't check the balance on a Starbucks gift card using the app, but you can easily check the balance of a gift card online.


    starbucksgiftcardbalance



    ReplyDelete
  4. Welcome to surveyprize.net Today here in this post, we are going to share with you Whataburger Customer Satisfaction Survey at www.whataburgersurvey.com. complete step by step information, you can also get the Whataburger Guest Experience Survey Rules & Requirements, and Whataburger Survey Rewards and Whataburger customer service number. I hope it will very helpful to complete the Whataburger Guest Satisfaction Survey.
    Whataburger Customer Satisfaction Survey

    ReplyDelete
  5. Struggling with QuickBooks Support Number Florida ? Fix it by dialling us at 1-855-533-6333. The error usually arrives due to improper installation of QuickBooks upgrading.

    ReplyDelete
  6. tdcardservices

    TD Credit Card Activation to TD Bank Activate Credit Card. Then, you have been landed at the correct point of information. From this post, you can find ways of Activate TD Bank Credit Card online @ www.td.com, TD Credit Card Login, and TD Bank Activate Credit Card phone number 1-800-983-8472.

    ReplyDelete
  7. When I was introduced to Mr. Pedro ( A Loan Officer), I was entering the market as a first time home buyer.
    My needs were a bit different and I had loads of questions, before he sent me my pre-approval letter, he called to speak with me about what it meant and what could change. He made himself available to me at pretty much any hour via email and texts, he was very responsive and knowledgeable. He’s also very straightforward, I explained to him what my expectations were in terms of closing time and other particulars. He said he would meet those expectations but he surpassed them. I closed so quickly my realtor and the seller of course were excited about that. But as a buyer I appreciated being walked through the process in a succinct yet thorough fashion. From pre-approval to closing- the journey was so seamless and I consider myself lucky because I’ve heard horror stories about the internet . I recommend A loan officer, Pedro Jerome contact email: pedroloanss@gmail.com & Whatsapp Number :+18632310632 to anyone looking for a loan in any market. Everything was handled electronically expediently and securely.

    ReplyDelete
  8. Thank you for sharing good information about Starbucks with us. it is very helpful to me. I like your post. Ii you want to know more about Starbucks then visit Starbucks Customer Survey

    ReplyDelete
  9. A really great impressive article blog. Thanks for posting. Geneva airport VIP service understands the importance of privacy and respect your time. They will always be on time to receive you at the airport. They are updated about the latest flight timings and ensure that the car is waiting for you the moment you step out. Book the [**airport VIP transfer in Geneva**][1] before you board your flight and enjoy their quick transfers.
    Airport VIP Transfer In Geneva

    ReplyDelete
  10. A really great impressive article blog. Thanks for posting. Swiss Chauffeur Service has carved a niche in the industry and is one of the [**best car hire company in Geneva airport**][1]. No matter the purpose of traveling, they will ensure you enjoy the trip in comfort and luxury. They have a luxurious fleet of cars for you to choose from.
    best car hire company geneva airport

    ReplyDelete
  11. Advatix is an all-inclusive solution for Supply Chain Technology needs. From development to analytics, Advatix has it all. They pledge to find better suitable approaches to move products via the supply chain and deliver products with trust to its customers.
    logistics consulting

    ReplyDelete
  12. A really great impressive article blog. Thanks for posting. Who says you cannot travel in style? You deserve to travel like a VIP, no matter where you are headed. Geneva is a luxury destination and is filled with beauty. When you land here, be ready to travel in luxury and comfort with the expert services offered by Swiss Chauffeur Service. The professionals have several years of experience and expertise in the industry and will be happy to cater to your needs
    limousine in Geneva
    local limousine service

    ReplyDelete
  13. Thanks for this blog i gain more knowledge about this thanks for sharing this information to everyone. "Power MyIT is Manage IT Services Offering for Small and Mid Size IT Environments. It is a package of People , Process and Technology to strengthen the Availability , Performance and Security of IT."
    IT engineer resource providers in india

    ReplyDelete
  14. Do you need instant support for QuickBooks errors? If yes, then we are here to help you.
    We at QuickBooks Customer Service Phone Number Texas 888^789^6945 is placed to take care of the minor complexity that exists in your software.

    ReplyDelete
  15. CNG cars have always managed to work their way very smoothly and gained a lot of popularity in the last few years given their cheaper running costs and eco-friendly nature. On the maintenance side, CNG cars require a lot more care than the cars running on petrol. However, here is a list of the best CNG Kits car maintenance tips that will help you out.
    Best CNG Kit Fitting in Delhi

    ReplyDelete
  16. Hi....Nice Blog. If you are facing any issue in QuickBooks, dial QuickBooks Support Number in Arizona and get your problem instantly.

    ReplyDelete
  17. This comment has been removed by the author.

    ReplyDelete
  18. This comment has been removed by the author.

    ReplyDelete
  19. This comment has been removed by the author.

    ReplyDelete
  20. QuickBooks is the most popular accounting software in world .Quickbooks customer service is available 24/7 which can help with anything from installation. just dial
    Quickbooks Customer Service +1 888-981-4592 and they will be glad to help you

    ReplyDelete
  21. If you are looking more informations about quickbooks Software then , then dial Quickbooks Customer Support +18555484814 and talk to a support agent

    ReplyDelete
  22. Great Service Blog ! If you are also a newbie looking for a reliable and affordable QuickBooks accounting software, then dial
    Quickbooks customer service : +1 855-675-3194

    ReplyDelete
  23. This comment has been removed by the author.

    ReplyDelete
  24. Thanks for sharing such important information ! If you have any query then our qualified technicians will provide you with quick solutions call at
    Quickbooks customer service number+1 855-548-4814

    ReplyDelete
  25. If you’re looking popular accounting Software then you can click on
    QuickBooks customer service +1 877-755-5046 to get the solution

    ReplyDelete
  26. By Dialing QuickBooks customer service +1 267-773-4333 for online customer Service to resolve your QuickBooks

    ReplyDelete
  27. Nice post Thanks !The QuickBooks customer service representatives are very helpful and friendly. If you are going through any issue while operating the software, connect with an expert team at QuickBooks and get the best hindering solutions. customer service +1 855-377-7767

    ReplyDelete
  28. QuickBooks is a software program that makes managing the finances of a small business If you are looking for contact information for QuickBooks then be sure to give them a call QuickBooks customer service +1 855-941-1563

    ReplyDelete
  29. very good information You can call QuickBooks to get answers to any questions you QuickBooks Support Phone Number +1 602-362-8345
    to get answer all your queries

    ReplyDelete
  30. QuickBooks is accounting software used for running business. If you are using QuickBooks accounting software simply dial QuickBooks Customer Service Phone Number +1 615-933-7123 and
    Upgrade QuickBooks

    ReplyDelete
  31. You can get answers to all your QuickBooks questions by Dialing QuickBooks Support Phone Number +1 717-844-9353 and talk to an expert.

    ReplyDelete
  32. Nice blog! If you use QuickBooks Software then then call them at
    QuickBooks Customer Support 1 866-306-2642 to get best technical solutions for QuickBooks errors.

    ReplyDelete
  33. Get answers to all of your QuickBooks questions by dialing toll free number QuickBooks Customer Service +1 615-933-7123 for any queries

    ReplyDelete