1 / 16

IM426 – business cases and Case studies in mis

IM426 – business cases and Case studies in mis. 27 – 29 May 2014 Compiled and/or Prepared by – Celeste Ng. Case 8: Responding to “Need it Yesterday” Customers with BI Apps. Case 8: Responding to “Need it Yesterday” Customers with BI Apps (1). Municipalities 市 Wholesalers 批發商

king
Download Presentation

IM426 – business cases and Case studies in mis

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. IM426 – business cases and Case studies in mis 27 – 29 May 2014 Compiled and/or Prepared by – Celeste Ng

  2. Case 8: Responding to “Need it Yesterday” Customers with BI Apps

  3. Case 8: Responding to “Need it Yesterday” Customers with BI Apps (1) • Municipalities市 • Wholesalers批發商 • Inventory availability庫存供應 • 24-hour turnaround time二十四小時周轉時間 • Manual planning人工規劃 • Manual budget手動預算 • Spreadsheets電子表格 • Reached throughout the organization’s districts達到整個組織的地區 • Executive dashboards執行儀表板 • District managers區域經理 • Extended擴展 • Tracking of the profitabilityof all aspects of the business跟踪業務的各個環節的盈利能力 • Intelligence and reporting requirements智能和報告要求 • Single web-based portal=單一以網路為基礎的入口網站 • Order dashboards=訂單的儀表板 • Custom fabrication=客製化製造 • perforated and mesh metal=穿孔網狀金屬 • Commercial construction=商業建築 • Metrics show profitability=指標顯示盈利 • Scattered throughout the organization=分散在整個組織 • Octopus with long tentacles=章魚長觸角 • Cumbersome=笨重 • Data integrity=數據完整性 • Complex financial scenarios=複雜的金融方案 • Transactional data=交易性數據 • Key performance indicators(KPIs)=關鍵績效指標 • Gross profit=毛利 • Margins=邊際利潤 • Customer inquiries=客戶查詢 • Invoice counts=發票數量 • Sales analytics=銷售分析

  4. Case 8: Responding to “Need it Yesterday” Customers with BI Apps (2) • The purpose of this case study: • Illustrate how real business problem faced by a company named McNICHOLS (http://www.mcnichols.com/viewer.htm) was solved using an information system (IS) – called IBM Cognos 8 BI • IBM Cognos 8 BI – integrates and consolidates transactional data into executive dashboards to deliver information to the management requiring it.

  5. Reference: http://publib.boulder.ibm.com/infocenter/wdfhelp/v6r1m0/topic/com.ibm.dashboard.doc/dashboard_framework_getting_started.pdf

  6. Reference: http://publib.boulder.ibm.com/infocenter/wdfhelp/v6r1m0/topic/com.ibm.dashboard.doc/dashboard_framework_getting_started.pdf

  7. Reference: http://publib.boulder.ibm.com/infocenter/wdfhelp/v6r1m0/topic/com.ibm.dashboard.doc/dashboard_framework_getting_started.pdf

  8. Reference: http://publib.boulder.ibm.com/infocenter/wdfhelp/v6r1m0/topic/com.ibm.dashboard.doc/dashboard_framework_getting_started.pdf

  9. Case 8: Responding to “Need it Yesterday” Customers with BI Apps (3) • Describe McNICHOLS data and reporting problems

  10. Case 8: Responding to “Need it Yesterday” Customers with BI Apps (4) • Why do you think the company was using Access and Excel for its Intelligence and reporting requirements?

  11. Case 8: Responding to “Need it Yesterday” Customers with BI Apps (5) • DescribleMcNICHOLS’s business strategy, or how it defines its competitive advantage. How important is customer loyalty?

  12. Case 8: Responding to “Need it Yesterday” Customers with BI Apps (6) • Were resources improperly allocated under the manual system? How has the BI system reallocated resources? • Resources improperly allocated because – budget process required 7-10 days to complete at the end of each quarter; and several hours in each month • BI system reallocated resources by – • Enabling sales analytics ---- they are linked budgeting modules, making it easier for managers to monitor KPIs. • Integrated views of all business and financial data, provided in a single web-based portal. • Improved accuracy and quality of data. • Marketing, production, and order dashboards that enable real-time tracking of the profitability of all aspects of the aspects of the business. • Managers that have a good handle on actual transactions forecasts, and targets

  13. Case 8: Responding to “Need it Yesterday” Customers with BI Apps (7) • What might have been the business case for BI at McNICHOLS? • McNICHOLS requires a solution that –

More Related